INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'Friday','0','0'),(6,'Saturday','0','0'),(7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'On');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (7,'','1',NULL,'Third','2','4','0'),(8,'','2',NULL,'Third','2','4',NULL),(9,'','3',NULL,'Third','2','4',NULL),(10,'','4',NULL,'Third','2','4',NULL),(14,NULL,'1',NULL,'first','0','3','6'),(15,NULL,'2',NULL,'first','0','3','5'),(29,'','3',NULL,'first','0','3','0'),(30,'','4',NULL,'first','0','3',NULL),(31,'','5',NULL,'first','0','3',NULL),(32,NULL,'1',NULL,'test5','0','4',NULL),(33,NULL,'2',NULL,'test5','0','4','0'),(34,NULL,'3',NULL,'test5','0','4',NULL),(35,NULL,'4',NULL,'test5','0','4',NULL),(36,NULL,'5',NULL,'test5','0','4',NULL),(37,NULL,'6',NULL,'test5','0','4',NULL),(42,NULL,'7',NULL,'test5','0','4',NULL),(43,NULL,'8',NULL,'test5','0','4',NULL),(44,NULL,'9',NULL,'test5','0','4',NULL),(45,NULL,'10',NULL,'test5','0','4',NULL),(46,NULL,'11',NULL,'test5','0','4',NULL),(47,NULL,'12',NULL,'test5','0','4',NULL),(48,NULL,'1',NULL,'second','0','4','0'),(49,NULL,'2',NULL,'second','0','4',NULL),(50,NULL,'3',NULL,'second','0','4',NULL),(51,NULL,'4',NULL,'second','0','4',NULL),(52,NULL,'5',NULL,'second','0','4',NULL),(53,NULL,'1',NULL,'Fifth','0','',NULL),(54,NULL,'2',NULL,'Fifth','0','','2'),(55,NULL,'3',NULL,'Fifth','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'On');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'MPT-II','66:32:A1:34:0E:58','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Not Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated'),(7,'mosambee','9633932257','5566','Activated'),(8,'mosambeep10','9633932257','5566','Activated'),(9,'bijlipay','',NULL,'Not Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (1,'Priyanka',NULL,NULL,NULL,NULL,NULL,NULL,NULL,7348842227,'',NULL,'',NULL,'HM Tech park','','','Hopeform','');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'abcd','20','%'),(2,'abc','30','%'),(3,'xyz','40','%'),(4,'zxy','50','%'),(5,'diwali','60','%'),(6,'test','25','%'),(7,'DISCOUNT15','10','%'),(8,'DROP50','10','%'),(9,'CUT40','10','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'vendor','5865412336','vendor@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0'),(2,'second','1'),(3,'Third','2'),(4,'test5','4'),(5,'Fifth','4');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'Tiffin',NULL,NULL,NULL,NULL),(4,'Snacks',NULL,NULL,NULL,NULL),(5,'Main course',NULL,NULL,NULL,NULL),(6,'Drinks',NULL,NULL,NULL,NULL),(7,'Desserts',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'test','testing11','0','10.00','22 Jul 2024','2024 07 22','11:20:17 am','1120','202407221120','Kg',NULL),(2,'Abcd','testing11','0','103.00','22 Jul 2024','2024 07 22','11:20:17 am','1120','202407221120','Kg ',NULL),(3,'asafoetida','bread omlette','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(4,'asafoetida','butterscotch icecream','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(5,'asafoetida','butterscotch','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(6,'asafoetida','grape juice','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(7,'asafoetida','lassi','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(8,'asafoetida','lime juice','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(9,'asafoetida','soft drinks','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(10,'asafoetida','masala chai','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(11,'asafoetida','tea','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(12,'asafoetida','coffee','0','226.20','22 Jul 2024','202407221201','12:01:16 pm','1201','202407221201','Kg','500.0'),(13,'asafoetida','vanilla icecream','1.2','226.20','22 Jul 2024','202407221202','12:02:47 pm','1202','202407221202','Kg','500.0'),(14,'lentils','pongal','1','344.00','14 Aug 2024','202408141629','04:29:17 PM','1629','202408141629','Kg','-122.0'),(15,'lentils','bread omlette','1','344.00','14 Aug 2024','202408141629','04:29:17 PM','1629','202408141629','Kg','-122.0'),(16,'asafoetida','bread omlette','9','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(17,'asafoetida','butterscotch icecream','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(18,'asafoetida','butterscotch','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(19,'asafoetida','grape juice','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(20,'asafoetida','lassi','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(21,'asafoetida','lime juice','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(22,'asafoetida','soft drinks','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(23,'asafoetida','masala chai','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(24,'asafoetida','tea','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(25,'asafoetida','coffee','0','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(26,'asafoetida','vanilla icecream','1.2','226.20','14 Aug 2024','202408141636','04:36:01 PM','1636','202408141636','Kg','9.0'),(27,'wheat','pongal, Item name*','0','1.00','21 Aug 2024','2024 08 21','11:53:20 AM','1153','202408211153','Kg',NULL),(28,'asafoetida','idly','0','226.20','21 Aug 2024','2024 08 21','04:24:58 PM','1624','202408211624','Kg',NULL),(29,'lentils','pongal','10','344.00','21 Aug 2024','202408211626','04:26:05 PM','1626','202408211626','Kg','-10.0'),(30,'lentils','bread omlette','1','344.00','21 Aug 2024','202408211626','04:26:05 PM','1626','202408211626','Kg','-10.0'),(31,'Abcd','idly','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(32,'Abcd','dosa','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(33,'Abcd','pongal','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(34,'Abcd','upma','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(35,'Abcd','poori','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(36,'Abcd','masal dosa','2','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202409191156','Kg','189.0'),(37,'Abcd','bread omlette','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(38,'Abcd','onion dosa','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(39,'Abcd','rava dosa','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(40,'Abcd','uthappam','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(41,'Abcd','vada','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(42,'Abcd','masal vada','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(43,'Abcd','samosa','0','103.00','22 Aug 2024','202408221710','05:10:02 PM','1710','202408221710','Kg','189.0'),(44,'test','masal dosa','0','10.00','19 Sep 2024','2024 09 19','11:56:49 AM','1156','202409191156','Kg',NULL),(45,'asafoetida','bread omlette','10','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(46,'asafoetida','butterscotch icecream','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(47,'asafoetida','butterscotch','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(48,'asafoetida','grape juice','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(49,'asafoetida','lassi','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(50,'asafoetida','lime juice','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(51,'asafoetida','soft drinks','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(52,'asafoetida','masala chai','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(53,'asafoetida','tea','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(54,'asafoetida','coffee','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(55,'asafoetida','vanilla icecream','1.2','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(56,'asafoetida','idly','0','226.20','19 Sep 2024','202409191157','11:57:57 AM','1157','202409191157','Kg','-36.0'),(57,'ginger','poori','1','158.00','19 Sep 2024','202409191205','12:05:55 PM','1205','202409191205','Kg','-101.0'),(58,'ginger','onion dosa','1','158.00','19 Sep 2024','202409191205','12:05:55 PM','1205','202409191205','Kg','-101.0'),(59,'ginger','idly','0','158.00','04 Oct 2024','2024 10 04','12:59:38 PM','1259','202410041259','Kg',NULL),(60,'test','onion dosa','0','10.00','04 Oct 2024','2024 10 04','03:34:42 PM','1534','202410041534','Kg',NULL),(61,'maida','masal vada','0','2.0','07 Oct 2024','202410071452','02:52:13 PM','1452','202410071452','Kg','58.0'),(62,'maida','samosa','0','2.0','07 Oct 2024','202410071452','02:52:13 PM','1452','202410071452','Kg','58.0'),(63,'maida','pani puri','0','2.0','07 Oct 2024','202410071452','02:52:13 PM','1452','202410071452','Kg','58.0'),(64,'wheat','veg thali','0','1.00','07 Oct 2024','202410071508','03:08:14 PM','1508','202410071508','Kg','4.0'),(65,'wheat','roti','0','1.00','07 Oct 2024','202410071508','03:08:14 PM','1508','202410071508','Kg','4.0');
INSERT INTO `ingredient_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,'Ven1','7587687588985888888','001','125','0','0','0','0','125','04:33 PM','09 May 2024','09 May 2024','202405091633','20240509','125','0.0','125','09 May 2024','04:33 PM','202405091633',NULL),(2,'Ven1','7587687588985888888','008','96.0','0','0','0','0','96.0','10:39 am','24 May 2024','24 May 2024','202405241039','20240524','96','0.0','96','24 May 2024','10:39 am','202405241039',''),(3,'Mkp Vendor','9874569874','inv0985855','5000.0','2.5','125.0','10','500.0','4625.0','12:06 pm','22 Jul 2024','22 Jul 2024','202407221206','20240722','400','4225.0','400','22 Jul 2024','12:06 pm','202407221206',''),(4,'Mkp Vendor','9874569874','inv345789','1000.0','0','0','0','0','1000.0','07:11 am','23 Jul 2024','23 Jul 2024','202407230711','20240723','100','900.0','100','23 Jul 2024','07:11 am','202407230711',''),(5,'Mkp Vendor','9874569874','inv0985855','5000.0','2.5','125.0','10','500.0','4625.0','12:06 pm','22 Jul 2024','22 Jul 2024','202407221206','20240722','100','4125.0','500.0','23 Jul 2024','07:18 am','202407230718',''),(6,'Mkp Vendor','9874569874','inv345789','1000.0','0','0','0','0','1000.0','07:11 am','23 Jul 2024','23 Jul 2024','202407230711','20240723','100','800.0','200.0','23 Jul 2024','07:19 am','202407230719',''),(7,'Ven1','7587687588985888888','inv076606','500.0','0','0','0','0','500.0','07:37 am','23 Jul 2024','23 Jul 2024','202407230737','20240723','100','400.0','100','23 Jul 2024','07:37 am','202407230737',''),(8,'Ven1','7587687588985888888','INV-63071','525.0','0','0','0','0','525.0','12:20 PM','19 Aug 2024','19 Aug 2024','202408191220','20240819','287','238.0','287','19 Aug 2024','12:20 PM','202408191220',''),(9,'Ven1','7587687588985888888','008','96.0','0','0','0','0','96.0','10:39 am','24 May 2024','24 May 2024','202405241039','20240524','0','0.0','96.0','19 Aug 2024','12:22 PM','202408191222',''),(10,'Mkp Vendor','9874569874','INV-49496','3212.0','0','0','0','0','3212.0','11:48 AM','21 Aug 2024','21 Aug 2024','202408211148','20240821','165','3047.0','165','21 Aug 2024','11:48 AM','202408211148',''),(11,'Ven1','7587687588985888888','001','125','0','0','0','0','125','04:33 PM','09 May 2024','09 May 2024','202405091633','20240509','0','0.0','125.0','21 Aug 2024','11:50 AM','202408211150',''),(12,'Ven1','7587687588985888888','INV-81196','800.0','0','0','0','0','800.0','04:20 PM','21 Aug 2024','21 Aug 2024','202408211620','20240821','206','594.0','206','21 Aug 2024','04:20 PM','202408211620',''),(13,'Mkp Vendor','9874569874','inv0985855','5000.0','2.5','125.0','10','500.0','4625.0','12:06 pm','22 Jul 2024','22 Jul 2024','202407221206','20240722','4125','0.0','4625.0','21 Aug 2024','04:21 PM','202408211621',''),(14,'Ven1','7587687588985888888','474','250.0','0','0','0','0','250.0','04:59 PM','22 Aug 2024','22 Aug 2024','202408221659','20240822','250','0.0','250','22 Aug 2024','04:59 PM','202408221659',''),(15,'Mohan','8437672657','6767','200.0','0','0','0','0','200.0','05:01 PM','22 Aug 2024','22 Aug 2024','202408221701','20240822','200','0.0','200','22 Aug 2024','05:01 PM','202408221701',''),(16,'Ven1','7587687588985888888','566','3650.0','0','0','0','0','3650.0','05:12 PM','22 Aug 2024','22 Aug 2024','202408221712','20240822','3650','0.0','3650','22 Aug 2024','05:12 PM','202408221712',''),(17,'Ven1','7587687588985888888','56','3650.0','0','0','0','0','3650.0','05:14 PM','22 Aug 2024','22 Aug 2024','202408221714','20240822','3650','0.0','3650','22 Aug 2024','05:14 PM','202408221714',''),(18,'Ven1','7587687588985888888','6776','7300.0','0','0','0','0','7300.0','10:00 AM','23 Aug 2024','23 Aug 2024','202408231000','20240823','7300','0.0','7300','23 Aug 2024','10:00 AM','202408231000',''),(19,'Ven1','7587687588985888888','inv076606','500.0','0','0','0','0','500.0','07:37 am','23 Jul 2024','23 Jul 2024','202407230737','20240723','400','0.0','500.0','19 Sep 2024','12:44 PM','202409191244',''),(20,'Ven1','7587687588985888888','INV-63071','525.0','0','0','0','0','525.0','12:20 PM','19 Aug 2024','19 Aug 2024','202408191220','20240819','238','0.0','525.0','19 Sep 2024','12:45 PM','202409191245',''),(21,'Ven1','7587687588985888888','009','200.0','0','0','0','0','200.0','12:46 PM','19 Sep 2024','19 Sep 2024','202409191246','20240919','200','0.0','200','19 Sep 2024','12:46 PM','202409191246',''),(22,'Ven1','7587687588985888888','9870','500.0','4.0','20.0','0','0','520.0','12:48 PM','19 Sep 2024','19 Sep 2024','202409191248','20240919','520','0.0','520','19 Sep 2024','12:48 PM','202409191248',''),(23,'Ven1','7587687588985888888','5757','120.0','0','0','0','0','120.0','12:50 PM','19 Sep 2024','19 Sep 2024','202409191250','20240919','120','0.0','120','19 Sep 2024','12:50 PM','202409191250',''),(24,'Ven1','7587687588985888888','9865','750.0','0','0','0','0','750.0','12:57 PM','19 Sep 2024','19 Sep 2024','202409191257','20240919','750','0.0','750','19 Sep 2024','12:57 PM','202409191257',''),(25,'Ven1','7587687588985888888','678','240.0','0','0','0','0','240.0','01:00 PM','19 Sep 2024','19 Sep 2024','202409191300','20240919','240','0.0','240','19 Sep 2024','01:00 PM','202409191300',''),(26,'Ven1','7587687588985888888','58478','50.0','0','0','0','0','50.0','10:35 AM','26 Sep 2024','26 Sep 2024','202409261035','20240926','50','0.0','50','26 Sep 2024','10:35 AM','202409261035',''),(27,'Mkp Vendor','9874569874','inv345789','1000.0','0','0','0','0','1000.0','07:11 am','23 Jul 2024','23 Jul 2024','202407230711','20240723','800','0.0','1000.0','04 Oct 2024','12:56 PM','202410041256',''),(28,'Mkp Vendor','9874569874','inv0985855','5000.0','2.5','125.0','10','500.0','4625.0','12:06 pm','22 Jul 2024','22 Jul 2024','202407221206','20240722','0','0.0','4625.0','04 Oct 2024','03:32 PM','202410041532','');
INSERT INTO `ingredient_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`, `wastage`, `unit`) VALUES (1,'Ven1','7587687588985888888','Abcd','5','25','125','001','125','0','0','0','0','125','04:33 PM','09 May 2024','09 May 2024','202405091633','20240509','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,NULL,'Kg '),(2,'Ven1','7587687588985888888','wheat','8','12','96.0','008','96.0','0','0','0','0','96.0','10:39 am','24 May 2024','24 May 2024','202405241039','20240524','96','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,'0','Kg'),(3,'Mkp Vendor','9874569874','asafoetida','100','50','5000.0','inv0985855','5000.0','2.5','125.0','10','500.0','4625.0','12:06 pm','22 Jul 2024','22 Jul 2024','202407221206','20240722','400','4225.0','cgst(2.5%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(4,'Mkp Vendor','9874569874','asafoetida','20','50','1000.0','inv345789','1000.0','0','0','0','0','1000.0','07:11 am','23 Jul 2024','23 Jul 2024','202407230711','20240723','100','900.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,'0','Kg'),(5,'Ven1','7587687588985888888','Abcd','20','25','500.0','inv076606','500.0','0','0','0','0','500.0','07:37 am','23 Jul 2024','23 Jul 2024','202407230737','20240723','100','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,'0','Kg '),(6,'Ven1','7587687588985888888','Abcd','21','25','525.0','INV-63071','525.0','0','0','0','0','525.0','12:20 PM','19 Aug 2024','19 Aug 2024','202408191220','20240819','287','238.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,'0','Kg '),(7,'Mkp Vendor','9874569874','lentils','22','146','3212.0','INV-49496','3212.0','0','0','0','0','3212.0','11:48 AM','21 Aug 2024','21 Aug 2024','202408211148','20240821','165','3047.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,'0','Kg'),(8,'Ven1','7587687588985888888','asafoetida','16','50','800.0','INV-81196','800.0','0','0','0','0','800.0','04:20 PM','21 Aug 2024','21 Aug 2024','202408211620','20240821','206','594.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,'0','Kg'),(9,'Ven1','7587687588985888888','test','5','50','250.0','474','250.0','0','0','0','0','250.0','04:59 PM','22 Aug 2024','22 Aug 2024','202408221659','20240822','250','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,'0','Kg'),(10,'Mohan','8437672657','test','4','50','200.0','6767','200.0','0','0','0','0','200.0','05:01 PM','22 Aug 2024','22 Aug 2024','202408221701','20240822','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,'0','Kg'),(11,'Ven1','7587687588985888888','lentils','25','146','3650.0','566','3650.0','0','0','0','0','3650.0','05:12 PM','22 Aug 2024','22 Aug 2024','202408221712','20240822','3650','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,'0','Kg'),(12,'Ven1','7587687588985888888','lentils','25','146','3650.0','56','3650.0','0','0','0','0','3650.0','05:14 PM','22 Aug 2024','22 Aug 2024','202408221714','20240822','3650','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,'0','Kg'),(13,'Ven1','7587687588985888888','lentils','50','146','7300.0','6776','7300.0','0','0','0','0','7300.0','10:00 AM','23 Aug 2024','23 Aug 2024','202408231000','20240823','7300','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,'0','Kg'),(14,'Ven1','7587687588985888888','test','10','20','200.0','009','200.0','0','0','0','0','200.0','12:46 PM','19 Sep 2024','19 Sep 2024','202409191246','20240919','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,'0','Kg'),(15,'Ven1','7587687588985888888','Abcd','20','25','500.0','9870','500.0','4.0','20.0','0','0','520.0','12:48 PM','19 Sep 2024','19 Sep 2024','202409191248','20240919','520','0.0','cgst(4.00%)','sgst(5%)','gst(4%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4','5','4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(16,'Ven1','7587687588985888888','wheat','10','12','120.0','5757','120.0','0','0','0','0','120.0','12:50 PM','19 Sep 2024','19 Sep 2024','202409191250','20240919','120','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,'0','Kg'),(17,'Ven1','7587687588985888888','asafoetida','15','50','750.0','9865','750.0','0','0','0','0','750.0','12:57 PM','19 Sep 2024','19 Sep 2024','202409191257','20240919','750','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,'0','Kg'),(18,'Ven1','7587687588985888888','wheat','20','12','240.0','678','240.0','0','0','0','0','240.0','01:00 PM','19 Sep 2024','19 Sep 2024','202409191300','20240919','240','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,'0','Kg'),(19,'Ven1','7587687588985888888','Abcd','2','25','50.0','58478','50.0','0','0','0','0','50.0','10:35 AM','26 Sep 2024','26 Sep 2024','202409261035','20240926','50','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,'0','Kg');
INSERT INTO `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (1,'Abcd','1','2','103.00','Kg','25',NULL,'202405021738','02 May 2024','1738','17:38:04 PM','202408221711','25.0','-27.0','0','','','0',NULL,'','','25',''),(2,'wheat','2','5','1.00','Kg','12',NULL,'202405201133','20 May 2024','1133','11:33:30 AM','202410071508','12.0','4.0','','','','0',NULL,'','','12',''),(3,'test','5','10','10.00','Kg','20',NULL,'202405301121','30 May 2024','1121','11:21:27 am','202405301121','34.2','0.0','','','','0',NULL,'','','20',''),(4,'asafoetida','4','64','226.20','Kg','50',NULL,'202407221202','22 Jul 2024','1202','12:02:51 pm','202409191158','50.0','-41.0','215','','','0',NULL,'','','50',''),(5,'lentils','100','60','344.00','Kg','146',NULL,'202408141629','14 Aug 2024','1629','04:29:18 PM','202408221702','146.0','52.0','','',NULL,NULL,NULL,NULL,NULL,'146',NULL),(6,'ginger','5','30','158.00','Kg','150',NULL,'202409191205','19 Sep 2024','1205','12:05:58 PM','202409191205','NaN','-101.0','','',NULL,NULL,NULL,NULL,NULL,'150',NULL),(7,'maida','28','60','2.0','Kg','60',NULL,'202410071452','07 Oct 2024','1452','02:52:14 PM','202410071452','60','58.0','',NULL,NULL,NULL,NULL,NULL,NULL,'60',NULL),(8,'test','4','5','10.00','Kg','50',NULL,'202410071452','07 Oct 2024','1452','02:52:26 PM','202410071452','50','3.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(9,'test1','4','9','1','Kg','50',NULL,'202410071452','07 Oct 2024','1452','02:52:39 PM','202410071452','50','8.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(10,'wheat','2','5','1.00','Kg','28',NULL,'202410071454','07 Oct 2024','1454','02:54:12 PM','202410071508','28','4.0','',NULL,NULL,NULL,NULL,NULL,NULL,'28',NULL),(11,'test','4','6','10.00','Kg','25',NULL,'202410071510','07 Oct 2024','1510','03:10:00 PM','202410071510','25','4.0','',NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL),(12,'test1','2','5','1','Kg','35',NULL,'202410071510','07 Oct 2024','1510','03:10:48 PM','202410071510','35','4.0','',NULL,NULL,NULL,NULL,NULL,NULL,'35',NULL),(13,'test3','3','9','1','Kg','45',NULL,'202410071511','07 Oct 2024','1511','03:11:03 PM','202410071511','45','8.0','',NULL,NULL,NULL,NULL,NULL,NULL,'45',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'asafoetida','0','Kg','yes'),(2,'Abcd','0','Kg','yes'),(3,'asafoetida','0','Kg','yes'),(4,'grape juice','0','Kg','yes'),(5,'lassi','0','Kg','yes'),(6,'lime juice','0','Kg','yes'),(7,'soft drinks','0','Kg','yes'),(8,'masala chai','0','Kg','yes'),(9,'tea','0','Kg','yes'),(10,'coffee','0','Kg','yes'),(11,'vanilla icecream','1.2','Kg','yes'),(12,'bread omlette','9','Kg','yes'),(13,'butterscotch icecream','0','Kg','yes'),(14,'butterscotch','0','Kg','yes'),(15,'grape juice','0','Kg','yes'),(16,'lassi','0','Kg','yes'),(17,'lime juice','0','Kg','yes'),(18,'soft drinks','0','Kg','yes'),(19,'masala chai','0','Kg','yes'),(20,'tea','0','Kg','yes'),(21,'coffee','0','Kg','yes'),(22,'vanilla icecream','1.2','Kg','yes'),(23,'idly','0','Kg','yes'),(24,'bread omlette','10','Kg','yes'),(25,'butterscotch icecream','0','Kg','yes'),(26,'butterscotch','0','Kg','yes'),(27,'grape juice','0','Kg','yes'),(28,'lassi','0','Kg','yes'),(29,'lime juice','0','Kg','yes'),(30,'soft drinks','0','Kg','yes'),(31,'masala chai','0','Kg','yes'),(32,'tea','0','Kg','yes'),(33,'coffee','0','Kg','yes'),(34,'vanilla icecream','1.2','Kg','yes'),(35,'idly','0','Kg','yes');
INSERT INTO `ingredients_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `unit`, `wastage_qty`, `wastage_cost`, `not_required`) VALUES (1,'Abcd','25.0','25.0','25.0','5.0','125.0','0','Kg ','0.0','0',''),(2,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(3,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(5,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(6,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(7,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(8,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(9,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(10,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(11,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(12,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(13,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(14,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(15,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(16,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(17,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(18,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(19,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(20,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(21,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(22,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(23,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(24,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(25,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(26,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(28,'Abcd','25.0','25.0','25.0','5.0','125.0','0','Kg ','0.0','0',''),(29,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(30,'Sugar','50.0','50.0','50.0','100.0','5000.0','215','Kg','0.0','0',''),(31,'Abcd','25.0','25.0','25.0','5.0','125.0','0','Kg ','0.0','0',''),(32,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(33,'Sugar','50.0','50.0','50.0','100.0','5000.0','215','Kg','0.0','0',''),(34,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(35,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(49,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(50,'Sugar','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(51,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(52,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(55,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(56,'Sugar','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(59,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(60,'Wheat','12.0','12.0','12.0','8.0','96.0','0','Kg','0.0','0',''),(61,'Sugar','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(62,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(63,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(64,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(65,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(66,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(67,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(68,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(69,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(70,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(71,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(72,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(73,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(74,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(75,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(76,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(77,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(78,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(79,'Sugar','50.0','50.0','50.0','20.0','1000.0','215','Kg','0.0','0',''),(84,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(85,'Sugar','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(86,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(87,'Sugar','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(96,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg ','0.0','0',''),(97,'bitter gourd','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(101,'Abcd','25.0','25.0','25.0','21.0','525.0','0','Kg ','0.0','0',''),(104,'Abcd','25.0','25.0','25.0','41.0','1025.0','0','Kg ','0.0','0',''),(105,'bitter gourd','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(108,'Abcd','25.0','25.0','25.0','21.0','525.0','0','Kg ','0.0','0',''),(109,'methi seeds','146.0','146.0','146.0','22.0','3212.0','','Kg','0.0','0',''),(118,'Abcd','25.0','25.0','25.0','41.0','1025.0','0','Kg ','0.0','0',''),(119,'bitter gourd','50.0','50.0','50.0','120.0','6000.0','215','Kg','0.0','0',''),(120,'methi seeds','146.0','146.0','146.0','22.0','3212.0','','Kg','0.0','0',''),(125,'Abcd','25.0','25.0','25.0','21.0','525.0','0','Kg ','0.0','0',''),(126,'bitter gourd','50.0','50.0','50.0','16.0','800.0','215','Kg','0.0','0',''),(127,'methi seeds','146.0','146.0','146.0','22.0','3212.0','','Kg','0.0','0',''),(136,'Abcd','25.0','25.0','25.0','41.0','1025.0','0','Kg ','0.0','0',''),(137,'bitter gourd','50.0','50.0','50.0','136.0','6800.0','215','Kg','0.0','0',''),(138,'methi seeds','146.0','146.0','146.0','22.0','3212.0','','Kg','0.0','0',''),(139,'test','50.0','50.0','50.0','9.0','450.0','','Kg','0.0','0',''),(140,'Abcd','25.0','25.0','25.0','41.0','1025.0','0','Kg','0.0','0',''),(141,'test','50.0','50.0','50.0','9.0','450.0','','Kg','0.0','0',''),(142,'bitter gourd','50.0','50.0','50.0','136.0','6800.0','215','Kg','0.0','0',''),(143,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(154,'Abcd','25.0','25.0','25.0','41.0','1025.0','0','Kg','0.0','0',''),(155,'test','50.0','50.0','50.0','9.0','450.0','','Kg','0.0','0',''),(156,'bitter gourd','50.0','50.0','50.0','136.0','6800.0','215','Kg','0.0','0',''),(157,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(162,'Abcd','25.0','25.0','25.0','61.0','1525.0','0','Kg','0.0','0',''),(163,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(164,'test','34.2','20.0','50.0','19.0','650.0','','Kg','0.0','0',''),(165,'asafoetida','50.0','50.0','50.0','151.0','7550.0','215','Kg','0.0','0',''),(166,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(171,'Abcd','25.0','25.0','25.0','61.0','1525.0','0','Kg','0.0','0',''),(172,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(173,'test','34.2','20.0','50.0','19.0','650.0','','Kg','0.0','0',''),(174,'asafoetida','50.0','50.0','50.0','151.0','7550.0','215','Kg','0.0','0',''),(175,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(180,'Abcd','25.0','25.0','25.0','61.0','1525.0','0','Kg','0.0','0',''),(181,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(182,'test','34.2','20.0','50.0','19.0','650.0','','Kg','0.0','0',''),(183,'asafoetida','50.0','50.0','50.0','151.0','7550.0','215','Kg','0.0','0',''),(184,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(185,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg','0.0','0',''),(186,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(187,'test','20.0','20.0','20.0','10.0','200.0','','Kg','0.0','0',''),(188,'asafoetida','50.0','50.0','50.0','15.0','750.0','215','Kg','0.0','0',''),(189,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg','0.0','0',''),(190,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(191,'test','20.0','20.0','20.0','10.0','200.0','','Kg','0.0','0',''),(192,'asafoetida','50.0','50.0','50.0','15.0','750.0','215','Kg','0.0','0',''),(193,'Abcd','25.0','25.0','25.0','20.0','500.0','0','Kg','0.0','0',''),(194,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(195,'test','20.0','20.0','20.0','10.0','200.0','','Kg','0.0','0',''),(196,'asafoetida','50.0','50.0','50.0','15.0','750.0','215','Kg','0.0','0',''),(207,'Abcd','25.0','25.0','25.0','43.0','1075.0','0','Kg','0.0','0',''),(208,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(209,'test','34.2','20.0','50.0','19.0','650.0','','Kg','0.0','0',''),(210,'asafoetida','50.0','50.0','50.0','31.0','1550.0','215','Kg','0.0','0',''),(211,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0',''),(217,'Abcd','25.0','25.0','25.0','43.0','1075.0','0','Kg','0.0','0',''),(218,'Wheat','12.0','12.0','12.0','30.0','360.0','0','Kg','0.0','0',''),(219,'test','34.2','20.0','50.0','19.0','650.0','','Kg','0.0','0',''),(220,'asafoetida','50.0','50.0','50.0','31.0','1550.0','215','Kg','0.0','0',''),(221,'lentils','146.0','146.0','146.0','122.0','17812.0','','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.68.103','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.68.103','9100','','TM-m30','kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,31,'Tiffin','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','id','',NULL,NULL,2,'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),(2,'dosa',35.00,37,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','',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),(3,'pongal',30.00,45,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',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),(4,'upma',30.00,49,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','',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),(5,'poori',35.00,46,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',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),(6,'masal dosa',40.00,47,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',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),(7,'bread omlette',30.00,17,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','',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),(8,'onion dosa',35.00,29,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','',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),(9,'rava dosa',35.00,29,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','',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),(10,'uthappam',30.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','',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),(11,'vada',20.00,100,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',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),(12,'masal vada',20.00,50,'Snacks','None','[BLOB]','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),(13,'samosa',20.00,50,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','',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),(14,'chicken kabab',60.00,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',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),(15,'sheekh kabab',80.00,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','',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),(16,'pani puri',35.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',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),(17,'pav bhajji',60.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',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),(18,'veg cutlet',40.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',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),(19,'masal puri',35.00,30,'Snacks','None','[BLOB]','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),(20,'chicken nuggets',65.00,10,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',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),(21,'veg biriyani',70.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',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),(22,'chicken biriyani',100.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',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),(23,'veg thali',50.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',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),(24,'non veg thali',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','',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),(25,'mutton biriyani',120.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MU','',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),(26,'roti',15.00,100,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','',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),(27,'rice',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','',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),(28,'paneer butter masala',60.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',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),(29,'chicken sukka',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',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),(30,'dhal fry',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','',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),(31,'coffee',20.00,100,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CO','',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),(32,'tea',20.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','TE','',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),(33,'masala chai',25.00,50,'Drinks','None','[BLOB]','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),(34,'soft drinks',10.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SO','',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),(35,'lime juice',15.00,30,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','',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),(36,'lassi',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','',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),(37,'grape juice',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','',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),(38,'vanilla icecream',35.00,49,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',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),(39,'butterscotch icecream',40.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',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),(40,'butterscotch cake',35.00,49,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',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);
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'pongal','35.0','35.0','35.0','55.0','1925.0','00052144956',''),(2,'poori','30.0','30.0','30.0','15.0','450.0','',''),(3,'poori','30.0','30.0','30.0','15.0','450.0','',''),(4,'poori','58.0','58.0','58.0','44.0','2552.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kioskmode` (`_id`, `status`) VALUES (1,'On'),(1,'On');
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','1');
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 `phonepe_id` (`id`, `merchant_id`) VALUES (1,'IVEPOSDYNAMICQRUAT');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'bijlipay');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (10,'');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'2315');
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,'idly','1','angadipriyanka97dine','store1','device1','store2','device2','11:15 AM','May 20, 2024','20240520111501'),(2,'dosa','2','angadipriyanka97dine','store2','device2','store1','device1','11:22 AM','May 20, 2024','20240520112243'),(3,'idly','2','angadipriyanka97dine','store1','device1','store2','device2','04:28 PM','Jun 07, 2024','20240607162852'),(4,'pongal','4','angadipriyanka97dine','store1','device1','store2','device2','03:40 PM','Jul 11, 2024','20240711154022'),(5,'upma','2','angadipriyanka97dine','store1','device1',NULL,NULL,'11:31 am','22 Jul 2024','20240722113116'),(6,'onion dosa','1','angadipriyanka97dine','store1','device1',NULL,NULL,'11:31 am','22 Jul 2024','20240722113116'),(7,'dosa','2','angadipriyanka97dine','store1','device1',NULL,NULL,'07:07 am','23 Jul 2024','20240723070732'),(8,'pongal','2','angadipriyanka97dine','store1','device1',NULL,NULL,'11:12 AM','22 Aug 2024','20240822111216'),(9,'bread omlette','4','angadipriyanka97dine','store1','device1',NULL,NULL,'11:31 AM','22 Aug 2024','20240822113157'),(10,'poori','2','angadipriyanka97dine','store1','device1',NULL,NULL,'11:31 AM','22 Aug 2024','20240822113157'),(11,'idly','2','angadipriyanka97dine','store1','device1',NULL,NULL,'10:37 AM','26 Sep 2024','20240926103723');
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,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (3,'gst(5%)',5.00,'Globaltax',NULL,'dine_in','takeaway','homedelivery',''),(4,'GST(18%)',18.00,'Itemtax',NULL,NULL,NULL,NULL,NULL),(5,'GST(5%)',5.00,'Itemtax',NULL,NULL,NULL,NULL,NULL),(6,'GST(0.25%)',0.25,'Itemtax',NULL,NULL,NULL,NULL,NULL),(7,'GST(3%)',3.00,'Itemtax',NULL,NULL,NULL,NULL,NULL),(8,'GST(0%)',0.00,'Itemtax',NULL,NULL,NULL,NULL,NULL),(9,'GST(12%)',12.00,'Itemtax',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'5');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'username','no','no','no','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,'vendor1','8523987588','ven1@gmail.com','goa','567'),(2,'copper kitchen','8527419638','copper2gmail.com','china','reg093883A'),(3,'Arjun','9836685947','babu1285@example.com','Coimbatore','56ABCDE2259F96'),(4,'Vijay','9835464311','vasanth1232@example.com','Bangalore','08ABCDE8579F35');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Ven1','7587687588985888888','Ven1@gmail.com','Gia',''),(2,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','china','reg0987654'),(3,'new ven','7894566395','rakash@gmail.com','india','refg147852');
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,'vendor1','8523987588','006','175.0','0','0','0','0','175.0','10:40 am','24 May 2024','24 May 2024','202405241040','20240524','175','0.0','175','24 May 2024','10:40 am','202405241040',''),(2,'vendor1','8523987588','977','1750.0','10.0','175.0','0','0','1925.0','10:42 am','24 May 2024','24 May 2024','202405241042','20240524','1925','0.0','1925','24 May 2024','10:42 am','202405241042',''),(3,'vendor1','8523987588','inv094833','650.0','2.5','16.25','10','65.0','601.3','11:34 am','22 Jul 2024','22 Jul 2024','202407221134','20240722','6013','-5411.7','6013','22 Jul 2024','11:34 am','202407221134',''),(4,'vendor1','8523987588','001','50.0','0','0','0','0','50.0','09:40 am','23 Jul 2024','23 Jul 2024','202407230940','20240723','50','0.0','50','23 Jul 2024','09:40 am','202407230940',''),(5,'vendor1','8523987588','006','50.0','0','0','0','0','50.0','12:00 pm','07 Aug 2024','07 Aug 2024','202408071200','20240807','50','0.0','50','07 Aug 2024','12:00 pm','202408071200',''),(6,'copper kitchen','8527419638','INV-96288','1560.0','0','0','0','0','1560.0','04:39 PM','21 Aug 2024','21 Aug 2024','202408211639','20240821','1560.0','0.0','1560.0','21 Aug 2024','04:39 PM','202408211639',''),(7,'vendor1','8523987588','456','6800.0','0','0','0','0','6800.0','05:04 PM','22 Aug 2024','22 Aug 2024','202408221704','20240822','6800','0.0','6800','22 Aug 2024','05:04 PM','202408221704',''),(8,'vendor1','8523987588','INV-56915','2552.0','0','0','0','0','2552.0','12:12 PM','19 Sep 2024','19 Sep 2024','202409191212','20240919','2552.0','0.0','2552.0','19 Sep 2024','12:12 PM','202409191212',''),(9,'vendor1','8523987588','56788','100.0','0','0','0','0','100.0','01:06 PM','30 Sep 2024','30 Sep 2024','202409301306','20240930','100','0.0','100','30 Sep 2024','01:06 PM','202409301306',''),(10,'vendor1','8523987588','INV-89047','1170.0','0','0','0','0','1170.0','03:43 PM','04 Oct 2024','04 Oct 2024','202410041543','20241004','1170.0','0.0','1170.0','04 Oct 2024','03:43 PM','202410041543','');
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,'vendor1','8523987588','pongal1','5','35','175.0','006','175.0','0','0','0','0','175.0','10:40 am','24 May 2024','24 May 2024','202405241040','20240524','175','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),(2,'vendor1','8523987588','pongal1','50','35','1750.0','977','1750.0','10.0','175.0','0','0','1925.0','10:42 am','24 May 2024','24 May 2024','202405241042','20240524','1925','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,'vendor1','8523987588','idly1','20','10','200.0','inv094833','650.0','2.5','16.25','10','65.0','601.3','11:34 am','22 Jul 2024','22 Jul 2024','202407221134','20240722','6013','-5411.7',NULL,NULL,NULL,NULL,NULL,NULL,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,'vendor1','8523987588','poori','15','30','450.0','inv094833','650.0','2.5','16.25','10','65.0','601.3','11:34 am','22 Jul 2024','22 Jul 2024','202407221134','20240722','6013','-5411.7',NULL,NULL,NULL,NULL,NULL,NULL,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,'vendor1','8523987588','idly1','5','10','50.0','001','50.0','0','0','0','0','50.0','09:40 am','23 Jul 2024','23 Jul 2024','202407230940','20240723','50','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,'vendor1','8523987588','idly1','5','10','50.0','006','50.0','0','0','0','0','50.0','12:00 pm','07 Aug 2024','07 Aug 2024','202408071200','20240807','50','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),(7,'copper kitchen','8527419638','pongal','40','39','1560.0','INV-96288','1560.0','0','0','0','0','1560.0','04:39 PM','21 Aug 2024','21 Aug 2024','202408211639','20240821','1560.0','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),(8,'vendor1','8523987588','idly','80','85','6800.0','456','6800.0','0','0','0','0','6800.0','05:04 PM','22 Aug 2024','22 Aug 2024','202408221704','20240822','6800','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,'vendor1','8523987588','idly','5','85','425.0','565','425.0','0','0','0','0','425.0','04:31 PM','29 Aug 2024','29 Aug 2024','202408291631','20240829','425','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,'vendor1','8523987588','poori','44','58','2552.0','INV-56915','2552.0','0','0','0','0','2552.0','12:12 PM','19 Sep 2024','19 Sep 2024','202409191212','20240919','2552.0','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,'vendor1','8523987588','dosa','2','50','100.0','56788','100.0','0','0','0','0','100.0','01:06 PM','30 Sep 2024','30 Sep 2024','202409301306','20240930','100','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),(12,'vendor1','8523987588','dosa','39','30','1170.0','INV-89047','1170.0','0','0','0','0','1170.0','03:43 PM','04 Oct 2024','04 Oct 2024','202410041543','20241004','1170.0','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);
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,'vendor1','8523987588','ven1@gmail.com','567','goa','2701.3','8113.0','-5411.7','3'),(2,'vendor122','8523987588','ven1@gmail.com','567698','panjim goa','0.0','0.0','0.0','0'),(3,'vendor122','8523987588','ven1@gmail.com','567698','panjim goa','0.0','0.0','0.0','0'),(4,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','0.0','0.0','0.0','0'),(5,'vendor122','8523987588','ven1@gmail.com','567698','panjim goa','0.0','0.0','0.0','0'),(6,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','0.0','0.0','0.0','0'),(7,'vendor1','8523987588','ven1@gmail.com','567','goa','2751.3','8163.0','-5411.7','4'),(8,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','0.0','0.0','0.0','0'),(9,'vendor1','8523987588','ven1@gmail.com','567','goa','2751.3','8163.0','-5411.7','4'),(10,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','0.0','0.0','0.0','0'),(11,'vendor1','8523987588','ven1@gmail.com','567','goa','2751.3','8163.0','-5411.7','4'),(12,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','0.0','0.0','0.0','0'),(13,'vendor1','8523987588','ven1@gmail.com','567','goa','2801.3','8213.0','-5411.7','5'),(14,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(15,'vendor1','8523987588','ven1@gmail.com','567','goa','2801.3','8213.0','-5411.7','5'),(16,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(17,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(18,'vendor1','8523987588','ven1@gmail.com','567','goa','12153.3','17565.0','-5411.7','7'),(19,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(20,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(21,'vendor1','8523987588','ven1@gmail.com','567','goa','12153.3','17565.0','-5411.7','7'),(22,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(23,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(24,'vendor1','8523987588','ven1@gmail.com','567','goa','12153.3','17565.0','-5411.7','7'),(25,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(26,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(30,'vendor1','8523987588','ven1@gmail.com','567','goa','13423.3','18835.0','-5411.7','9'),(31,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(32,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(33,'Vijay','9835464311','vasanth1232@example.com','08ABCDE8579F35','Bangalore','0.0','0.0','0.0','0'),(34,'vendor1','8523987588','ven1@gmail.com','567','goa','13423.3','18835.0','-5411.7','9'),(35,'copper kitchen','8527419638','copper2gmail.com','reg093883A','china','1560.0','1560.0','0.0','1'),(36,'Arjun','9836685947','babu1285@example.com','56ABCDE2259F96','Coimbatore','0.0','0.0','0.0','0'),(37,'Vijay','9835464311','vasanth1232@example.com','08ABCDE8579F35','Bangalore','0.0','0.0','0.0','0');
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,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','221.0','221.0','0.0','2'),(2,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','221.0','221.0','0.0','2'),(3,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','221.0','221.0','0.0','2'),(4,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','4625.0','400.0','4225.0','1'),(8,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','221.0','221.0','0.0','2'),(9,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','4625.0','400.0','4225.0','1'),(10,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(11,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','221.0','221.0','0.0','2'),(12,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','5625.0','500.0','5125.0','2'),(13,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(14,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','721.0','321.0','400.0','3'),(15,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','5625.0','700.0','4925.0','2'),(16,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(17,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','1246.0','608.0','638.0','4'),(18,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','5625.0','700.0','4925.0','2'),(19,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(20,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','1246.0','608.0','638.0','4'),(21,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','865.0','7972.0','3'),(22,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(23,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','2046.0','814.0','1232.0','5'),(24,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','865.0','7972.0','3'),(25,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(26,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','2046.0','814.0','1232.0','5'),(27,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(28,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(29,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','2046.0','814.0','1232.0','5'),(30,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(31,'Mohan','8437672657','karthick2220@example.com','44ABCDE0014F78','Trichy','0.0','0.0','0.0','0'),(32,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','2046.0','814.0','1232.0','5'),(33,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(34,'Mohan','8437672657','karthick2220@example.com','44ABCDE0014F78','Trichy','0.0','0.0','0.0','0'),(35,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','16896.0','15664.0','1232.0','9'),(36,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(37,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(38,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','16896.0','15664.0','1232.0','9'),(39,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(40,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(41,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','16896.0','15664.0','1232.0','9'),(42,'Vasanth','9882571188','babu8498@example.com','85ABCDE5373F85','Salem','0.0','0.0','0.0','0'),(43,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(44,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','16896.0','15664.0','1232.0','9'),(45,'Vasanth','9882571188','babu8498@example.com','85ABCDE5373F85','Salem','0.0','0.0','0.0','0'),(46,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(47,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18726.0','18132.0','594.0','14'),(48,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(49,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(50,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(51,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(52,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(53,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(54,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','4990.0','3847.0','3'),(55,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(56,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(57,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','5790.0','3047.0','3'),(58,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(59,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(60,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','5790.0','3047.0','3'),(61,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(62,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(63,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','5790.0','3047.0','3'),(64,'new ven','7894566395','rakash@gmail.com','refg147852','india','0.0','0.0','0.0','0'),(65,'Ven1','7587687588985888888','Ven1@gmail.com','','Gia','18776.0','18182.0','594.0','15'),(66,'Mkp Vendor','9874569874','gajaanvendor@gmai.com','reg0987654','china','8837.0','5790.0','3047.0','3'),(67,'new ven','7894566395','rakash@gmail.com','refg147852','india','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');
