(31,'coffee',20.00,97,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CO','31','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20.00,72,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','TE','32','','0',3,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,48,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','33','','0',2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SO','34','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,27,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','35','','0',2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','36','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,24,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','37','','0',1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','38','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','39','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','40','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'chocolate Smoothy',40.00,-2,'smoothy','None','','0','0',NULL,NULL,NULL,'no','%','0','CH','41','','0',0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'abc',100.00,1,'Desserts','None','','0','0',NULL,NULL,NULL,'no','%','0','AB','42','','0',0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Gauva ',40.00,1,'smoothy','None','','0','0',NULL,NULL,NULL,'no','%','0','GA','43','','0',0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Pani poori',40.00,1,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','44','','0',0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','40','peanut','45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'Tea ',10.00,1,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','45','','0',55,'0','0','0','Low','','','Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'parcel Tea',25.00,30,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','46','','0',28,'0','0','0','Low','','','Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'Pups',15.00,12,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','PU','47','','0',6,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'veg Samosa',20.00,4,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','VE','48','','0',0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'Samosa',4.00,3,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','SA','49','','0',3,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'Pani puri',30.00,23,'chats ','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','50','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','Regular','30','matur Pani puri','35','','','','','','','kot2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Pongal ',15.00,19,'Tiffin','None','','0','0',NULL,NULL,NULL,'no','%','0','PO','51','','0',0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'abcd scrape ',100.00,10,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','AB','52','','0',0,'0','0','0','',NULL,NULL,'Weight',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'Test ',100.00,-2,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','53','','0',2,'0','0','0','Low',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'kingfisher water',10.00,19,'Drinks','None','','0','0',NULL,NULL,NULL,'no','%','0','KI','54','','0',1,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'Shavarma',120.00,100,'Snacks','None','','0','0',NULL,NULL,NULL,'no','₹','5','SH','','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','120','veg shavarma','100','Egg shavarma','110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'baby frock',500.00,96,'baby frock','None','','0','0',NULL,NULL,NULL,'no','%','0','BA','57','','0',3,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'shirt',500.00,19,'mensware','None','','0','0',NULL,NULL,NULL,'no','%','0','SH','58','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','500','42','550',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'Test item',100.00,0,'Abdulla Tea stall','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','59',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Weight',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','Regular','100','Test','110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'orange juice ',50.00,20,'Drinks','None','','0','0',NULL,NULL,NULL,'no','%','0','OR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Mango juice',50.00,20,'Drinks','None','','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'gold',0.00,10,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','GO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'Gold new',0.00,-1,'None','threepercent(3%)','','0','0',NULL,NULL,NULL,'no','%','0','GO','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','3','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'Cosmetics',0.00,-1,'None','percent(18%)','','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'Gold Test',0.00,1,'None','threepercent(3%)','','0','0',NULL,NULL,NULL,'no','%','3','GO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'Pedal ',100.00,-1,'sweets','None','','0','0',NULL,NULL,NULL,'no','%','0','PE','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Weight',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'Archana ',50.00,-1,'sweets','None','','0','0',NULL,NULL,NULL,'no','%','0','AR','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'Test item ',100.00,9,'Tiffin','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','100','test item 1','110','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'Test product ',100.00,26,'Drinks','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,0,'0','0','0','','','','Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'idly','10.0','10.0','10.0','20.0','200.0','',''),(2,'bread omlette','25.0','25.0','25.0','5.0','125.0','',''),(3,'chicken nuggets','80.0','80.0','80.0','10.0','800.0','',''),(4,'Tea ','10.0','10.0','10.0','20.0','200.0','',''),(5,'Tea ','7.0','7.0','7.0','20.0','140.0','45',''),(6,'parcel Tea','10.0','10.0','10.0','30.0','300.0','46',''),(7,'Test product ','7.0','7.0','7.0','20.0','140.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','10');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'POS');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stock_transfer_item_details` (`_id`, `itemname`, `qty_add`, `company`, `from_store`, `from_device`, `to_store`, `to_device`, `from_time`, `from_date`, `datetimee_new_from`) VALUES (1,'dosa','20','9535897598dine','store1','device1',NULL,NULL,'11:34 am','23 Apr 2024','20240423113451'),(2,'upma','20','9535897598dine','store1','device1',NULL,NULL,'11:34 am','23 Apr 2024','20240423113451'),(3,'dosa','20','9535897598dine','store1','device1','test12','device12','11:34 am','23 Apr 2024','20240423113451'),(4,'upma','20','9535897598dine','store1','device1','test12','device12','11:34 am','23 Apr 2024','20240423113451');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Pro');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'threepercent(3%)',3.00,'Itemtax','','dine_in','takeaway','homedelivery',''),(2,'percent(18%)',18.00,'Itemtax','','dine_in','takeaway','homedelivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','yes','yes','yes','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc','+449182173','','',''),(2,'Munna ','8000009123','','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc','+449182173','','',''),(2,'Xyz','1234567890','','',''),(3,'Risi','12345','tyu@gh.jj','','45');
INSERT INTO `vendor_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','300.0','500','13 Mar 2023','12:21 pm','202303131221',''),(2,'Munna ','8000009123','','125.0','0','0','0','0','125.0','12:47 pm','13 Mar 2023','13 Mar 2023','202303131247','20230313','125','0.0','125','13 Mar 2023','12:47 pm','202303131247',''),(3,'Abc','+449182173','','200.0','0','0','0','0','200.0','02:05 pm','16 Mar 2023','16 Mar 2023','202303161405','20230316','150','50.0','150','16 Mar 2023','02:05 pm','202303161405',''),(4,'Munna ','8000009123','','300.0','0','0','0','0','300.0','07:38 pm','27 Mar 2023','27 Mar 2023','202303271938','20230327','200','100.0','200','27 Mar 2023','07:38 pm','202303271938',''),(5,'Abc','+449182173','','200.0','0','0','0','0','200.0','03:25 pm','03 Apr 2023','03 Apr 2023','202304031525','20230403','200','0.0','200','03 Apr 2023','03:25 pm','202304031525',''),(6,'Abc','+449182173','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0','200','08 Sep 2023','05:36 PM','202309081736',''),(7,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','100','200.0','600.0','04 Nov 2023','05:21 pm','202311041721',''),(8,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','200','0.0','800.0','04 Nov 2023','05:25 pm','202311041725',''),(9,'Munna ','8000009123','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0','500','08 Jan 2024','12:57 PM','202401081257',''),(10,'Munna ','8000009123','','5000.0','0','0','0','0','5000.0','03:40 PM','09 Feb 2024','09 Feb 2024','202402091540','20240209','2000','3000.0','2000','09 Feb 2024','03:40 PM','202402091540',''),(11,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','-500.0','1300.0','19 Feb 2024','06:34 AM','202402190634',NULL),(12,'Abc','+449182173','','375','0','0','0','0','375','06:20 AM','27 Feb 2024','27 Feb 2024','202402270620','20240227','0','375.0','0','27 Feb 2024','06:20 AM','202402270620',NULL),(13,'Munna ','8000009123','','400','0','0','0','0','400','06:21 AM','27 Feb 2024','27 Feb 2024','202402270621','20240227','0','400.0','0','27 Feb 2024','06:21 AM','202402270621',NULL),(14,'Munna ','8000009123','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0','500','28 May 2024','04:02 pm','202405281602',''),(15,'Munna ','8000009123','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0','500','28 May 2024','04:04 pm','202405281604',''),(16,'Munna ','8000009123','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','200','180.0','700.0','28 May 2024','04:05 pm','202405281605','');
INSERT INTO `vendor_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`) VALUES (1,'Munna ','8000009123','chicken nuggets','10','80','800.0','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Munna ','8000009123','bread omlette','5','25','125.0','','125.0','0','0','0','0','125.0','12:47 pm','13 Mar 2023','13 Mar 2023','202303131247','20230313','125','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Abc','+449182173','idly','20','10','200.0','','200.0','0','0','0','0','200.0','02:05 pm','16 Mar 2023','16 Mar 2023','202303161405','20230316','150','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Munna ','8000009123','idly','20','15','300.0','','300.0','0','0','0','0','300.0','07:38 pm','27 Mar 2023','27 Mar 2023','202303271938','20230327','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Abc','+449182173','Tea ','20','10','200.0','','200.0','0','0','0','0','200.0','03:25 pm','03 Apr 2023','03 Apr 2023','202304031525','20230403','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Abc','+449182173','idly','10','15','150.0','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Abc','+449182173','dosa','10','15','150.0','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Munna ','8000009123','idly','10','10','100.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Munna ','8000009123','pongal','20','10','200.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Munna ','8000009123','poori','20','10','200.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Munna ','8000009123','dosa','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:40 PM','09 Feb 2024','09 Feb 2024','202402091540','20240209','2000','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Abc','+449182173','dosa','25','15','375','','375','0','0','0','0','375','06:20 AM','27 Feb 2024','27 Feb 2024','202402270620','20240227','0','375.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'Munna ','8000009123','pongal','20','20','400','','400','0','0','0','0','400','06:21 AM','27 Feb 2024','27 Feb 2024','202402270621','20240227','0','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Munna ','8000009123','pongal','0','100','0.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Munna ','8000009123','tea','25','12','300.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Munna ','8000009123','Tea ','20','7','140.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Munna ','8000009123','parcel Tea','30','10','300.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'Munna ','8000009123','Test product ','20','7','140.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Munna ','8000009123','idly','20','10','200.0','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Munna ','8000009123','dosa','30','15','450.0','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(2,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(3,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(4,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(5,'Munna ','8000009123','','','','925.0','625.0','300.0','2'),(6,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(7,'Munna ','8000009123','','','','925.0','625.0','300.0','2'),(8,'Abc','+449182173','','','','200.0','150.0','50.0','1'),(9,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(10,'Abc','+449182173','','','','200.0','150.0','50.0','1'),(11,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(12,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(13,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(14,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(15,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(16,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(17,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(18,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(19,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(20,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(21,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(22,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(23,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(24,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(25,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(26,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(27,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(28,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(29,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(30,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(31,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(32,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(33,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(34,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(35,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(36,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(37,'Munna ','8000009123','','','','1225.0','925.0','300.0','3'),(38,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(39,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(40,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(41,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(42,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(43,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(44,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(45,'Munna ','8000009123','','','','1725.0','1625.0','100.0','4'),(46,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(47,'Munna ','8000009123','','','','6725.0','3625.0','3100.0','5'),(48,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(49,'Munna ','8000009123','','','','6725.0','3625.0','3100.0','5'),(50,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(51,'Munna ','8000009123','','','','7125.0','4125.0','3000.0','6'),(52,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(53,'Munna ','8000009123','','','','8655.0','5125.0','3530.0','8');
INSERT INTO `vendor_temp_list_ingredient` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(3,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(4,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(5,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(6,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(7,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(8,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(9,'Xyz','1234567890','','','','0.0','0.0','0.0','0'),(10,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(11,'Xyz','1234567890','','','','1000.0','2900.0','-1900.0','4'),(12,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(13,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(14,'Xyz','1234567890','','','','1000.0','2900.0','-1900.0','4'),(15,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0');
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
