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 (1,'','1',NULL,'first','0','4','1'),(2,'','2',NULL,'first','0','4','1'),(3,'','3',NULL,'first','0','4','2'),(4,'','1',NULL,'Second','1','4',NULL),(5,'','2',NULL,'Second','1','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'off');
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,'','','',NULL);
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','','','Not Activated'),(8,'mosambeep10','','','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,'ivepos demo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1234567890,'',NULL,'',NULL,'test1','demo@gmail.com','www.intuitionsoftwares.com','test2','test3');
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 `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Test','9874563214','testmail22@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0'),(2,'Second','1');
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),(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,'ice cream','veg biriyani','7','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(2,'ice cream','chicken biriyani','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(3,'ice cream','mutton biriyani','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(4,'ice cream','rice','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(5,'ice cream','pongal','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(18,'vegetables','chicken kabab','6','570.00','07 May 2024','202405071817','06:17:25 PM','1817','202405071817','Kg','11.0'),(19,'vegetables','chicken nuggets','0','570.00','07 May 2024','202405071817','06:17:25 PM','1817','202405071817','Kg','11.0'),(20,'vegetables','chicken biriyani','0','570.00','07 May 2024','202405071817','06:17:25 PM','1817','202405071817','Kg','11.0'),(21,'vegetables','chicken sukka','0','570.00','07 May 2024','202405071817','06:17:25 PM','1817','202405071817','Kg','11.0'),(26,'vegetables','coffee','1','570.00','30 May 2024','202405301553','03:53:49 pm','1553','202406031218','L','375.0'),(27,'vegetables','tea','10','570.00','30 May 2024','202405301553','03:53:49 pm','1553','202406031218','L','375.0'),(28,'vegetables','masala chai','6','570.00','30 May 2024','202405301553','03:53:49 pm','1553','202406031218','L','375.0'),(29,'vegetables','lassi','5','570.00','30 May 2024','202405301553','03:53:49 pm','1553','202406031218','L','375.0'),(30,'ice cream','veg biriyani','7','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(31,'ice cream','chicken biriyani','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(32,'ice cream','mutton biriyani','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(33,'ice cream','rice','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(34,'ice cream','pongal','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(35,'ice cream','dhal fry','0','91.00','09 Jul 2024','202407091544','15:44:50 PM','1544','202407091544','Kg ','-48.0'),(36,'vegetables','upma','0','570.00','03 Jun 2024','202406031218','12:18:07 pm','1218','202406031218','Kg','375.0'),(37,'sugar','idly','0','0.00','06 Jun 2024','202406061610','04:10:56 pm','1610','202406061610','Kg','0.0'),(38,'sugar','dosa','0','0.00','06 Jun 2024','202406061610','04:10:56 pm','1610','202406061610','Kg','0.0'),(39,'spinach','masal dosa','1','192.00','06 Jun 2024','202406061701','05:01:31 pm','1701','202406061701','Kg','-101.0'),(40,'spinach','rava dosa','1','192.00','06 Jun 2024','202406061701','05:01:31 pm','1701','202406061701','Kg','-101.0'),(41,'ice cream','masal vada','1','91.00','06 Jun 2024','202406061704','05:04:04 pm','1704','202406061704','Kg','-73.0'),(42,'ice cream','pongal','1','91.00','06 Jun 2024','202406061704','05:04:04 pm','1704','202406061704','Kg','-73.0'),(43,'cloves','bread omlette','1','166.00','06 Jun 2024','202406061707','05:07:29 pm','1707','202406061707','Kg','-77.0'),(44,'cloves','dosa','1','166.00','06 Jun 2024','202406061707','05:07:29 pm','1707','202406061707','Kg','-77.0'),(45,'fenugreek','veg biriyani','2','145.00','09 Jul 2024','202407091504','15:04:11 PM','1504','202407091504','Kg ','-31.0'),(46,'peppercorns','rice','2','128.00','09 Jul 2024','202407091510','15:10:42 PM','1510','202407091510','Kg ','-8.0'),(47,'toor dal','idly','0','76.00','23 Jul 2024','202407230901','09:01:59 am','0901','202407230901','Kg','0.0'),(48,'spinach','chicken kabab','2','192.00','26 Jul 2024','202407261232','12:32:59 PM','1232','202407261232','Kg ','40.0'),(49,'toor dal','dosa','0','76.00','02 Aug 2024','2024 08 02','09:52:59 AM','0952','202408020952','Kg',NULL),(50,'vegetables','dosa','0','570.00','02 Aug 2024','2024 08 02','09:56:28 AM','0956','202408020956','Kg',NULL),(51,'dtyt','dosa','0','655','07 Aug 2024','202408071250','12:50:04 PM','1250','202408071250','Kg','-655.0'),(52,'tyh','upma','0','5','07 Aug 2024','202408071302','01:02:38 PM','1302','202408071302','Kg','-5.0'),(53,'tyh','rava dosa','0','5','07 Aug 2024','202408071302','01:02:38 PM','1302','202408071302','Kg','-5.0'),(54,'tyh','onion dosa','0','5','07 Aug 2024','202408071302','01:02:38 PM','1302','202408071302','Kg','-5.0'),(55,'gooseberry','vada','1','53.00','07 Aug 2024','202408071333','01:33:02 PM','1333','202408071333','Kg','-88.0'),(56,'gooseberry','uthappam','1','53.00','07 Aug 2024','202408071333','01:33:02 PM','1333','202408071333','Kg','-88.0'),(57,'cloves','bread omlette','5','66','07 Aug 2024','202408071405','02:05:14 PM','1405','202408071405','Kg','1.0'),(58,'cloves','dosa','1','66','07 Aug 2024','202408071405','02:05:14 PM','1405','202408071405','Kg','1.0'),(59,'toor dal','idly','5','76.00','08 Aug 2024','202408081050','10:50:39 AM','1050','202408081050','Kg','-5.0'),(60,'toor dal','dosa','0','76.00','08 Aug 2024','202408081050','10:50:39 AM','1050','202408081050','Kg','-5.0'),(61,'drumstick','upma','1','165','08 Aug 2024','202408081701','05:01:32 PM','1701','202408081701','Kg','-135.0'),(63,'gooseberry','vada','10','53.00','08 Aug 2024','202408081707','05:07:37 PM','1707','202408081707','Kg','-4.0'),(64,'gooseberry','uthappam','1','53.00','08 Aug 2024','202408081707','05:07:37 PM','1707','202408081707','Kg','-4.0'),(65,'gooseberry','bread omlette','7','53.00','08 Aug 2024','202408081738','05:38:26 PM','1738','202408081738','Kg','14.0'),(66,'gooseberry','dosa','1','53.00','08 Aug 2024','202408081738','05:38:26 PM','1738','202408081738','Kg','14.0'),(67,'gooseberry','bread omlette','0','53.00','08 Aug 2024','202408081758','05:58:07 PM','1758','202408081758','Kg','-23.0'),(68,'gooseberry','samosa','0','53.00','08 Aug 2024','202408081758','05:58:07 PM','1758','202408081758','Kg','-23.0'),(69,'vegetables','bread omlette','0','570.00','08 Aug 2024','2024 08 08','07:38:09 PM','1938','202408081938','Kg',NULL),(70,'gooseberry','vada','8','53.00','10 Oct 2024','202410101258','12:58:59 PM','1258','202410101258','Kg','36.0'),(71,'gooseberry','uthappam','1','53.00','10 Oct 2024','202410101258','12:58:59 PM','1258','202410101258','Kg','36.0'),(72,'gooseberry','bread omlette','0','53.00','10 Oct 2024','202410101258','12:58:59 PM','1258','202410101258','Kg','36.0'),(73,'gooseberry','dosa','1','53.00','10 Oct 2024','202410101258','12:58:59 PM','1258','202410101258','Kg','36.0'),(74,'gooseberry','samosa','0','53.00','10 Oct 2024','202410101258','12:58:59 PM','1258','202410101258','Kg','36.0'),(75,'peppercorns','masal dosa','0','128.00','10 Oct 2024','2024 10 10','03:22:07 PM','1522','202410101522','Kg ',NULL),(76,'carrot','pongal','0','40.00','28 Oct 2024','2024 10 28','01:13:19 pm','1313','202410281313','Kg',NULL),(77,'saffron','masal dosa','0','55','28 Oct 2024','2024 10 28','05:53:29 pm','1753','202410281753','Kg',NULL),(78,'carrot','onion dosa','0','40.00','11 Nov 2024','2024 11 11','02:06:14 pm','1406','202411111406','Kg',NULL),(79,'carrot','upma','0','39.00','11 Nov 2024','2024 11 11','02:36:32 pm','1436','202411111436','Kg',NULL),(80,'toor dal','poori','0','76.00','11 Nov 2024','2024 11 11','02:56:45 pm','1456','202411111456','Kg',NULL),(81,'coriander seeds','masal vada','1','169','12 Nov 2024','202411121427','02:27:06 pm','1427','202411121427','Kg','-139.0'),(82,'coriander seeds','bread omlette','1','169','12 Nov 2024','202411121427','02:27:06 pm','1427','202411121427','Kg','-139.0'),(83,'ice cream','vada','10','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(84,'ice cream','uthappam','1','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(85,'ice cream','bread omlette','0','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(86,'ice cream','samosa','0','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(87,'ice cream','onion dosa','0','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(88,'ice cream','upma','0','91.00','12 Nov 2024','202411121429','02:29:56 pm','1429','202411121429','Kg','-20.0'),(89,'drumstick','bread omlette','0','164.00','12 Nov 2024','2024 11 12','02:32:55 pm','1432','202411121432','Kg',NULL),(90,'mango pickle','idly','1','129.00','13 Nov 2024','202411131445','02:45:46 pm','1445','202411131445','Kg','-97.0'),(91,'mango pickle','upma','1','129.00','13 Nov 2024','202411131445','02:45:46 pm','1445','202411131445','Kg','-97.0'),(92,'coriander seeds','masal vada','9','64','13 Nov 2024','202411131456','02:56:43 pm','1456','202411131456','Kg','22.0'),(93,'coriander seeds','bread omlette','4','64','13 Nov 2024','202411131456','02:56:43 pm','1456','202411131456','Kg','22.0'),(94,'chillies','veg thali','2','188.00','14 Nov 2024','202411140615','06:15:11 AM','0615','202411140615','Kg ','-82.0'),(95,'potato','tea','2','83.00','14 Nov 2024','202411140731','07:31:31 AM','0731','202411140731','Kg ','21.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,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','0','100000.0','0','30 May 2024','04:41 pm','202405301641',''),(2,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','300','99700.0','300.0','30 May 2024','04:42 pm','202405301642',''),(3,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','30','99670.0','330.0','30 May 2024','04:42 pm','202405301642',''),(4,'Vasanth','9912346158','','0.0','0','0','0','0','0.0','12:18 pm','03 Jun 2024','03 Jun 2024','202406031218','20240603','0','0.0','0','03 Jun 2024','12:18 pm','202406031218',''),(5,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','220','99450.0','550.0','03 Jun 2024','01:09 pm','202406031309',''),(6,'Vasanth','8832597744','sgf00093902002','3000.0','0','0','0','0','3000.0','01:18 pm','03 Jun 2024','03 Jun 2024','202406031318','20240603','800','2200.0','800','03 Jun 2024','01:18 pm','202406031318',''),(7,'Vasanth','8832597744','','40000.0','0','0','0','0','40000.0','01:19 pm','03 Jun 2024','03 Jun 2024','202406031319','20240603','0','40000.0','0','03 Jun 2024','01:19 pm','202406031319',''),(8,'karthi','9912346158','Vijay04848849','20000.0','0','0','0','0','20000.0','01:24 pm','03 Jun 2024','03 Jun 2024','202406031324','20240603','100','19900.0','100','03 Jun 2024','01:24 pm','202406031324',''),(9,'karthi','9912346158','Vijay04848849','20000.0','0','0','0','0','20000.0','01:24 pm','03 Jun 2024','03 Jun 2024','202406031324','20240603','19900','0.0','20000.0','03 Jun 2024','01:38 pm','202406031338',''),(10,'Vasanth','8832597744','sgf00093902002','3000.0','0','0','0','0','3000.0','01:18 pm','03 Jun 2024','03 Jun 2024','202406031318','20240603','0','2200.0','800.0','03 Jun 2024','01:49 pm','202406031349',''),(11,'Vasanth','8832597744','idn455585585','400.0','0','0','0','0','400.0','04:09 pm','03 Jun 2024','03 Jun 2024','202406031609','20240603','200','200.0','200','03 Jun 2024','04:09 pm','202406031609',''),(12,'Vasanth','8832597744','INV-58316','780.0','0','0','0','0','780.0','04:41 pm','03 Jun 2024','03 Jun 2024','202406031641','20240603','137','643.0','137','03 Jun 2024','04:41 pm','202406031641',''),(13,'Vasanth','9826599124','inv07985678','0','0','0','0','0','0','08:11 AM','04 Jul 2024','04 Jul 2024','202407040811','20240704','0','0.0','0','04 Jul 2024','08:11 AM','202407040811',NULL),(14,'Vasanth','9912346158','IVN9ee3535353','2000','0','0','0','0','2000','04:05 AM','10 Jul 2024','10 Jul 2024','202407100405','20240710','100','1900.0','100','10 Jul 2024','04:05 AM','202407100405',NULL),(15,'Vasanth','9912346158','INv00393844','900','0','0','0','0','900','04:06 AM','10 Jul 2024','10 Jul 2024','202407100406','20240710','100','800.0','100','10 Jul 2024','04:06 AM','202407100406',NULL),(16,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','390','99000.0','1000.0','23 Jul 2024','09:28 am','202407230928',''),(17,'Vasanth','9826599124','invg19181','5120.0','0','0','0','0','5120.0','10:48 am','23 Jul 2024','23 Jul 2024','202407231048','20240723','10','5110.0','10','23 Jul 2024','10:48 am','202407231048',''),(18,'Vasanth','9826599124','invg19181','5120.0','0','0','0','0','5120.0','10:48 am','23 Jul 2024','23 Jul 2024','202407231048','20240723','10','5100.0','20.0','23 Jul 2024','02:09 pm','202407231409',''),(19,'Vasanth','9826599124','invg19181','5120.0','0','0','0','0','5120.0','10:48 am','23 Jul 2024','23 Jul 2024','202407231048','20240723','10','5090.0','30.0','23 Jul 2024','02:12 pm','202407231412',''),(20,'Vasanth','8832597744','sgf00093902002','3000.0','0','0','0','0','3000.0','01:18 pm','03 Jun 2024','03 Jun 2024','202406031318','20240603','10','2190.0','810.0','23 Jul 2024','06:01 pm','202407231801',''),(21,'Vasanth','9826599124','inv099998','100.0','0','0','0','0','100.0','07:05 am','25 Jul 2024','25 Jul 2024','202407250705','20240725','10','90.0','10','25 Jul 2024','07:05 am','202407250705',''),(22,'Mangals','9598974789','INV20240726173008687','459','0','0','0','0','459','12:00 PM','26 Jul 2024','26 Jul 2024','202407261200','20240726','459','0.0','459','26 Jul 2024','12:00 PM','202407261200',NULL),(23,'David','9959205452','INV20240726180144912','580','0','0','0','0','580','12:31 PM','26 Jul 2024','26 Jul 2024','202407261231','20240726','580','0.0','580','26 Jul 2024','12:31 PM','202407261231',NULL),(24,'Vasanth','9826599124','inv099998','100.0','0','0','0','0','100.0','07:05 am','25 Jul 2024','25 Jul 2024','202407250705','20240725','90','0.0','100.0','03 Aug 2024','04:47 PM','202408031647',''),(25,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','20','98980.0','1020.0','03 Aug 2024','04:53 PM','202408031653',''),(26,'Vasanth','9912346158','INV-74109','0.0','0','0','0','0','0.0','05:29 PM','03 Aug 2024','03 Aug 2024','202408031729','20240803','198','-198.0','198','03 Aug 2024','05:29 PM','202408031729',''),(27,'David','9959205452','INV-18241','4466.0','0','0','0','0','4466.0','12:19 PM','08 Aug 2024','08 Aug 2024','202408081219','20240808','172','4294.0','172','08 Aug 2024','12:19 PM','202408081219',''),(28,'Vasanth','9826599124','inv099998','100.0','0','0','0','0','100.0','07:05 am','25 Jul 2024','25 Jul 2024','202407250705','20240725','0','0.0','100.0','08 Aug 2024','12:33 PM','202408081233',''),(29,'David','9959205452','INV-53968','4400.0','0','0','0','0','4400.0','06:05 PM','08 Aug 2024','08 Aug 2024','202408081805','20240808','160','4240.0','160','08 Aug 2024','06:05 PM','202408081805',''),(30,'David','9959205452','INV-53968','4400.0','0','0','0','0','4400.0','06:05 PM','08 Aug 2024','08 Aug 2024','202408081805','20240808','4240','0.0','4400.0','08 Aug 2024','06:09 PM','202408081809',''),(31,'Vasanth','9912346158','INv00393844','900','0','0','0','0','900','04:06 AM','10 Jul 2024','10 Jul 2024','202407100406','20240710','800','0.0','900.0','10 Oct 2024','12:48 PM','202410101248',''),(32,'Vasanth','9826599124','INV-91631','3045.0','0','0','0','0','3045.0','12:52 PM','10 Oct 2024','10 Oct 2024','202410101252','20241010','256','2789.0','256','10 Oct 2024','12:52 PM','202410101252',''),(33,'David','9959205452','INV20240726180144912','580','0','0','0','0','580','12:31 PM','26 Jul 2024','26 Jul 2024','202407261231','20240726','0','0.0','580.0','10 Oct 2024','03:19 PM','202410101519',''),(34,'Vasanth','9826599124','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','98980','0.0','100000.0','12 Nov 2024','02:35 pm','202411121435','');
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,'Vasanth','9826599124','vegetables','500','200','100000.0','Akle0284940','100000.0','0','0','0','0','100000.0','04:41 pm','30 May 2024','30 May 2024','202405301641','20240530','','100000.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'),(2,'Vasanth','9912346158','vegetables','0','200','0.0','','0.0','0','0','0','0','0.0','12:18 pm','03 Jun 2024','03 Jun 2024','202406031218','20240603','','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,'Vasanth','8832597744','ice cream','50','60','3000.0','sgf00093902002','3000.0','0','0','0','0','3000.0','01:18 pm','03 Jun 2024','03 Jun 2024','202406031318','20240603','800','2200.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'),(4,'Vasanth','8832597744','vegetables','200','200','40000.0','','40000.0','0','0','0','0','40000.0','01:19 pm','03 Jun 2024','03 Jun 2024','202406031319','20240603','','40000.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,'-908.0','Kg'),(5,'karthi','9912346158','cardamom','200','100','20000.0','Vijay04848849','20000.0','0','0','0','0','20000.0','01:24 pm','03 Jun 2024','03 Jun 2024','202406031324','20240603','100','19900.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,'Vasanth','8832597744','vegetables','2','200','400.0','idn455585585','400.0','0','0','0','0','400.0','04:09 pm','03 Jun 2024','03 Jun 2024','202406031609','20240603','200','200.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,'Vasanth','8832597744','ice cream','13','60','780.0','INV-58316','780.0','0','0','0','0','780.0','04:41 pm','03 Jun 2024','03 Jun 2024','202406031641','20240603','137','643.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,'Vasanth','9826599124','ice cream','0','60','0','inv07985678','0','0','0','0','0','0','08:11 AM','04 Jul 2024','04 Jul 2024','202407040811','20240704','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,NULL,'Kg'),(9,'Vasanth','9912346158','cardamom','20','100','2000','IVN9ee3535353','2000','0','0','0','0','2000','04:05 AM','10 Jul 2024','10 Jul 2024','202407100405','20240710','100','1900.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'),(10,'Vasanth','9912346158','cardamom','9','100','900','INv00393844','900','0','0','0','0','900','04:06 AM','10 Jul 2024','10 Jul 2024','202407100406','20240710','100','800.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'),(11,'Vasanth','9826599124','toor dal','10','10','100.0','inv099998','100.0','0','0','0','0','100.0','07:05 am','25 Jul 2024','25 Jul 2024','202407250705','20240725','10','90.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,'Mangals','9598974789','ice cream','17','27','459','INV20240726173008687','459','0','0','0','0','459','12:00 PM','26 Jul 2024','26 Jul 2024','202407261200','20240726','459','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 '),(13,'David','9959205452','cardamom','20','29','580','INV20240726180144912','580','0','0','0','0','580','12:31 PM','26 Jul 2024','26 Jul 2024','202407261231','20240726','580','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'),(14,'Vasanth','9912346158','toor dal','26','0','0.0','INV-74109','0.0','0','0','0','0','0.0','05:29 PM','03 Aug 2024','03 Aug 2024','202408031729','20240803','198','-198.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,'David','9959205452','cloves','22','203','4466.0','INV-18241','4466.0','0','0','0','0','4466.0','12:19 PM','08 Aug 2024','08 Aug 2024','202408081219','20240808','172','4294.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'),(16,'David','9959205452','cardamom','22','100','2200.0','INV-53968','4400.0','0','0','0','0','4400.0','06:05 PM','08 Aug 2024','08 Aug 2024','202408081805','20240808','160','4240.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,'David','9959205452','cardamom','22','100','2200.0','INV-53968','4400.0','0','0','0','0','4400.0','06:05 PM','08 Aug 2024','08 Aug 2024','202408081805','20240808','160','4240.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,'Vasanth','9826599124','cloves','15','203','3045.0','INV-91631','3045.0','0','0','0','0','3045.0','12:52 PM','10 Oct 2024','10 Oct 2024','202410101252','20241010','256','2789.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,'cardamom','15','150','197','Kg','100',NULL,'202411140616','14 Nov 2024','0616','06:16:23 AM','202411140616','100','-47.0','621','','','0',NULL,'','','100',''),(2,'vegetables','10','67','570.00','Kg','200',NULL,'202405071417','07 May 2024','1417','02:17:56 pm','202407251133','200.0','60.0','','Low','','0',NULL,'','','',''),(3,'ice cream','3','78','91.00','Kg ','60',NULL,'202407091544','09 Jul 2024','1544','15:44:50 PM','202407091544','60.0','-48.0','022','','','0',NULL,'','','60',''),(4,'cloves','2','67','66','Kg','203',NULL,'202406061707','06 Jun 2024','1707','05:07:31 pm','202408071405','203','1.0','','',NULL,NULL,NULL,NULL,NULL,'203',NULL),(5,'cardamom','2','62','572.00','Kg','256',NULL,'202407091550','09 Jul 2024','1550','15:50:01 PM','202407230918','256','-510.0','0','',NULL,NULL,NULL,NULL,NULL,'256',NULL),(6,'peppercorns','15','150','128.00','Kg ','123',NULL,'202411140720','14 Nov 2024','0720','07:20:47 AM','202411140720','123','-40.0','368','',NULL,NULL,NULL,NULL,NULL,'123',NULL),(7,'toor dal','3','61','76.00','Kg','0',NULL,'202407230913','23 Jul 2024','0913','09:13:07 am','202408081050','0','-5.0','','Low',NULL,NULL,NULL,NULL,NULL,'0',NULL),(8,'spinach','10','100','192.00','Kg ','112',NULL,'202407261232','26 Jul 2024','1232','12:32:59 PM','202407261232','112','40.0','249','',NULL,NULL,NULL,NULL,NULL,'112',NULL),(9,'gooseberry','4','89','53.00','Kg','256',NULL,'202408071333','07 Aug 2024','1333','01:33:03 PM','202410101259','256','36.0','',NULL,NULL,NULL,NULL,NULL,NULL,'256',NULL),(10,'drumstick','5','30','165','Kg','238',NULL,'202408081701','08 Aug 2024','1701','05:01:34 PM','202408081701','238','-135.0','',NULL,NULL,NULL,NULL,NULL,NULL,'238',NULL),(11,'saffron','3','66','55','Kg','204',NULL,'202410091221','09 Oct 2024','1221','12:21:51 pm','202410091230','204','11.0','',NULL,NULL,NULL,NULL,NULL,NULL,'204',NULL),(12,'coriander seeds','2','86','64','Kg','131',NULL,'202411121427','12 Nov 2024','1427','02:27:07 pm','202411131456','131','22.0','',NULL,NULL,NULL,NULL,NULL,NULL,'131',NULL),(13,'mango pickle','5','30','129.00','Kg','219',NULL,'202411131445','13 Nov 2024','1445','02:45:49 pm','202411131445','219','-97.0','',NULL,NULL,NULL,NULL,NULL,NULL,'219',NULL),(14,'chillies','10','100','188.00','Kg ','109',NULL,'202411140615','14 Nov 2024','0615','06:15:11 AM','202411140615','109','-82.0','496',NULL,NULL,NULL,NULL,NULL,NULL,'109',NULL),(15,'potato','10','100','83.00','Kg ','166',NULL,'202411140731','14 Nov 2024','0731','07:31:31 AM','202411140731','166','21.0','818',NULL,NULL,NULL,NULL,NULL,NULL,'166',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'sugar','0','Kg','yes'),(2,'sambar powder','1','Kg','yes'),(3,'mutton biriyani','0','Kg','yes'),(4,'rice','0','Kg','yes'),(5,'pongal','0','Kg','yes'),(6,'veg biriyani','7','Kg','yes'),(7,'chicken biriyani','0','Kg','yes'),(8,'mutton biriyani','0','Kg','yes'),(9,'rice','0','Kg','yes'),(10,'pongal','0','Kg','yes'),(11,'dhal fry','0','Kg','yes'),(12,'masal vada','1','Kg','yes'),(13,'pongal','1','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 (115,'cardamom','94.3','100.0','29.0','249.0','23480.0','665','Kg','0.0','0',''),(116,'vegetables','200.0','200.0','200.0','702.0','140400.0','','Kg','-908.0','-181600.0',''),(117,'ice cream','53.0','27.0','60.0','80.0','4239.0','022','Kg ','0.0','0',''),(118,'cardamom','94.3','100.0','29.0','249.0','23480.0','0','Kg','0.0','0',''),(119,'ergu','10.0','10.0','10.0','10.0','100.0','','Kg','0.0','0',''),(124,'cardamom','71.0','100.0','29.0','49.0','3480.0','665','Kg','0.0','0',''),(125,'ice cream','27.0','27.0','60.0','17.0','459.0','022','Kg ','0.0','0',''),(126,'cardamom','71.0','100.0','29.0','49.0','3480.0','0','Kg','0.0','0',''),(127,'ergu','10.0','10.0','10.0','10.0','100.0','','Kg','0.0','0',''),(132,'cardamom','71.0','100.0','29.0','49.0','3480.0','665','Kg','0.0','0',''),(133,'ice cream','27.0','27.0','60.0','17.0','459.0','022','Kg ','0.0','0',''),(134,'cardamom','71.0','100.0','29.0','49.0','3480.0','0','Kg','0.0','0',''),(135,'ergu','10.0','10.0','10.0','10.0','100.0','','Kg','0.0','0',''),(136,'cardamom','94.3','100.0','29.0','249.0','23480.0','665','Kg','0.0','0',''),(137,'vegetables','200.0','200.0','200.0','702.0','140400.0','','Kg','-908.0','-181600.0',''),(138,'ice cream','53.0','27.0','60.0','80.0','4239.0','022','Kg ','0.0','0',''),(139,'cardamom','94.3','100.0','29.0','249.0','23480.0','0','Kg','0.0','0',''),(140,'ergu','2.8','0.0','10.0','36.0','100.0','','Kg','0.0','0',''),(141,'cloves','203.0','203.0','203.0','22.0','4466.0','','Kg','0.0','0',''),(142,'vegetables','200.0','200.0','200.0','702.0','140400.0','','Kg','-908.0','-181600.0',''),(143,'ice cream','53.0','27.0','60.0','80.0','4239.0','022','Kg ','0.0','0',''),(144,'cardamom','94.3','100.0','29.0','249.0','23480.0','0','Kg','0.0','0',''),(145,'ergu','2.8','0.0','10.0','36.0','100.0','','Kg','0.0','0',''),(171,'cloves','203.0','203.0','203.0','22.0','4466.0','','Kg','0.0','0',''),(183,'cardamom','71.0','100.0','29.0','49.0','3480.0','665','Kg','0.0','0',''),(184,'ice cream','27.0','27.0','60.0','17.0','459.0','022','Kg ','0.0','0',''),(185,'cloves','203.0','203.0','203.0','22.0','4466.0','','Kg','0.0','0',''),(186,'cardamom','71.0','100.0','29.0','49.0','3480.0','0','Kg','0.0','0',''),(187,'toor dal','2.8','0.0','10.0','36.0','100.0','','Kg','0.0','0',''),(189,'cloves','203.0','203.0','203.0','15.0','3045.0','','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','','TM Printer');
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'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`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,749,'Chinese','Demo(12%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','2','id','',NULL,NULL,1012,'0','0','2','','','10','Unit','12.00','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,111,'Chinese','Demo(12%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,1055,'0','0','1137','','','26','Unit','12.00','','','','','','','','','','','','','','','','','','','','',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,125,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,1062,'0','0','1140','','','27','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,135,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,1063,'0','0','1151','','','25','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,95,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,1078,'0','0','1188','','','25','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,110,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,1077,'0','0','1180','',NULL,'27','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,117,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,1068,'0','0','1199','',NULL,'21','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,118,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,630,'0','0','733','','','24','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,128,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,635,'0','0','718','','','20','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,126,'Chinese','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,622,'0','0','742','','','27','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,138,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,1003,'0','0','300','',NULL,'20','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,139,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,990,'0','0','1089','',NULL,'30','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,144,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,354,'0','0','454','','','25','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,137,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,334,'0','0','464','','','29','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,137,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,373,'0','0','502','',NULL,'25','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,135,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,404,'0','0','523','','','23','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,144,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,367,'0','0','489','',NULL,'26','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,140,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,387,'0','0','506','',NULL,'30','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,3,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,7,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,150,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,1,'0','0','154','',NULL,'30','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,140,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,421,'0','0','525','',NULL,'21','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,136,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,432,'0','0','532','',NULL,'30','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,134,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,438,'0','0','538','',NULL,'28','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,128,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,431,'0','0','528','',NULL,'25','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',17.00,630,'Snacks','','','0','0',NULL,NULL,NULL,'no','%','5','MU','',NULL,NULL,412,'0','0','298','',NULL,'26','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),