INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'Namkeen','1.0','4.76','4.76','Item',NULL,NULL,'no',NULL,NULL,'20220709-1-000011','11:10:28 AM','2022 07 09','admin','1','  Dine-in','  Cash','5','5','1',NULL,NULL,NULL,NULL,'09 Jul 2022','2022070911:10:28','%','0','4.76','no','0.00',NULL,'202207091110','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pad Items','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'Namkeen','1.0','4.76','4.76','Item',NULL,NULL,'no',NULL,NULL,'20220717-1-000011','05:28:59 AM','2022 07 17','admin','1','  Dine-in','  Cash','5','5','2',NULL,NULL,NULL,NULL,'17 Jul 2022','2022071705:28:59','%','0','4.76','no','0.00',NULL,'202207170528','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pad Items','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'veg biriyani','1.0','76.19','76.19','Item',NULL,NULL,'no',NULL,NULL,'20220717-1-000012','11:17:57 AM','2022 07 17','ladmin','1','  Dine-in','  Cash','80','80','4',NULL,NULL,NULL,NULL,'17 Jul 2022','2022071711:17:57','%','0','76.19','no','0.00',NULL,'202207171117','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'RTE MEAL1','8.0','123.81','990.48','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','7',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','990.48','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'Idiyappam kadalai/Egg curry','5.0','47.62','238.10','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','8',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','238.10','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'Biscuit 1','5.0','38.10','190.50','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','9',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','190.50','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pad Items','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'KURKURE','5.0','19.05','95.25','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','10',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','95.25','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pad Items','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'samosa','3.0','19.05','57.15','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','11',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','57.15','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'P-veg curry','1.0','76.19','76.19','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','12',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','76.19','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'lassi','3.0','23.81','71.43','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','13',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','71.43','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'Tea','4.0','9.52','38.08','Item',NULL,NULL,'no',NULL,NULL,'20220718-1-000011','04:24:28 PM','2022 07 18','ladmin','1','  Dine-in','  Cash','1845','1845','14',NULL,NULL,NULL,NULL,'18 Jul 2022','2022071816:24:28','%','0','38.08','no','0.00',NULL,'202207181624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'Namkeen','1.0','4.76','4.76','Item',NULL,NULL,'no',NULL,NULL,'20220723-1-000011','05:37:47 AM','2022 07 23','admin','1','  Dine-in','  Cash','5','5','15',NULL,NULL,NULL,NULL,'23 Jul 2022','2022072305:37:47','%','0','4.76','no','0.00',NULL,'202207230537','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pad Items','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000011','08:52:32 AM','2022 07 26','ladmin','1','  Dine-in','  Cash','40','40','16',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072608:52:32','%','0','38.10','no','0.00',NULL,'202207260852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'P-veg curry','1.0','76.19','76.19','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000012','08:52:43 AM','2022 07 26','ladmin','1','  Dine-in','  Cash','120','120','17',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072608:52:43','%','0','76.19','no','0.00',NULL,'202207260852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'VEG CURRY/MATAR PANEER/CHOLE','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000012','08:52:43 AM','2022 07 26','ladmin','1','  Dine-in','  Cash','120','120','18',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072608:52:43','%','0','38.10','no','0.00',NULL,'202207260852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000013','08:52:58 AM','2022 07 26','ladmin','1','  Dine-in','  Cash','40','40','19',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072608:52:58','%','0','38.10','no','0.00',NULL,'202207260852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'masal vada','1.0','19.05','19.05','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000014','08:53:18 AM','2022 07 26','ladmin','1','  Dine-in','  Cash','20','20','20',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072608:53:18','%','0','19.05','no','0.00',NULL,'202207260853','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000015','12:23:17 PM','2022 07 26','ladmin','1','  Dine-in','  Cash','40','40','22',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072612:23:17','%','0','38.10','no','0.00',NULL,'202207261223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220726-1-000016','01:13:20 PM','2022 07 26','ladmin','1','  Dine-in','  Cash','40','40','23',NULL,NULL,NULL,NULL,'26 Jul 2022','2022072613:13:20','%','0','38.10','no','0.00',NULL,'202207261313','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'veg cutlet','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220728-1-000011','09:42:44 AM','2022 07 28','ladmin','1','  Dine-in','  Cash','40','40','26',NULL,NULL,NULL,NULL,'28 Jul 2022','2022072809:42:44','%','0','38.10','no','0.00',NULL,'202207280942','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'veg cutlet','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220728-1-000012','09:43:01 AM','2022 07 28','ladmin','1','  Dine-in','  Cash','40','40','27',NULL,NULL,NULL,NULL,'28 Jul 2022','2022072809:43:01','%','0','38.10','no','0.00',NULL,'202207280943','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'P-veg curry','1.0','76.19','76.19','Item',NULL,NULL,'no',NULL,NULL,'20220729-1-000011','01:42:43 PM','2022 07 29','ladmin','1','  Dine-in','  Cash','120','120','31',NULL,NULL,NULL,NULL,'29 Jul 2022','2022072913:42:43','%','0','76.19','no','0.00',NULL,'202207291342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'VEG CURRY/MATAR PANEER/CHOLE','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220729-1-000011','01:42:43 PM','2022 07 29','ladmin','1','  Dine-in','  Cash','120','120','32',NULL,NULL,NULL,NULL,'29 Jul 2022','2022072913:42:43','%','0','38.10','no','0.00',NULL,'202207291342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'Upma','2.0','38.10','76.20','Item',NULL,NULL,'no',NULL,NULL,'20220730-1-000011','10:02:57 AM','2022 07 30','ladmin','1','  Dine-in','  Cash','80','80','35',NULL,NULL,NULL,NULL,'30 Jul 2022','2022073010:02:57','%','0','76.20','no','0.00',NULL,'202207301002','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220801-1-000011','10:05:23 AM','2022 08 01','ladmin','1','  Dine-in','  Cash','40','40','36',NULL,NULL,NULL,NULL,'01 Aug 2022','2022080110:05:23','%','0','38.10','no','0.00',NULL,'202208011005','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'Masal dosa','1.0','47.62','47.62','Item',NULL,NULL,'no',NULL,NULL,'20220819-1-000011','09:40:12 AM','2022 08 19','ladmin','1','  Dine-in','  Cash','70','70','37',NULL,NULL,NULL,NULL,'19 Aug 2022','2022081909:40:12','%','0','47.62','no','0.00',NULL,'202208190940','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'vada','1.0','19.05','19.05','Item',NULL,NULL,'no',NULL,NULL,'20220819-1-000011','09:40:12 AM','2022 08 19','ladmin','1','  Dine-in','  Cash','70','70','38',NULL,NULL,NULL,NULL,'19 Aug 2022','2022081909:40:12','%','0','19.05','no','0.00',NULL,'202208190940','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'Wagh Bakri','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220819-1-000012','09:55:26 AM','2022 08 19','ladmin','1','  Dine-in','  Cash','15','15','39',NULL,NULL,NULL,NULL,'19 Aug 2022','2022081909:55:26','%','0','14.29','no','0.00',NULL,'202208190955','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000011','08:12:41 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','40',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:12:41','%','0','9.52','no','0.00',NULL,'202208220812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'Tea','2.0','9.52','19.04','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000012','08:13:15 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','20','20','41',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:13:15','%','0','19.04','no','0.00',NULL,'202208220813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000013','08:13:32 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','42',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:13:32','%','0','9.52','no','0.00',NULL,'202208220813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000014','08:13:49 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','43',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:13:49','%','0','9.52','no','0.00',NULL,'202208220813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000015','08:14:10 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','44',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:14:10','%','0','9.52','no','0.00',NULL,'202208220814','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000016','08:14:27 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','45',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:14:27','%','0','9.52','no','0.00',NULL,'202208220814','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'Tea','2.0','9.52','19.04','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000017','08:15:17 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','20','20','46',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:15:17','%','0','19.04','no','0.00',NULL,'202208220815','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000018','08:16:09 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','47',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:16:09','%','0','9.52','no','0.00',NULL,'202208220816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-000019','08:16:23 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','48',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:16:23','%','0','9.52','no','0.00',NULL,'202208220816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000110','08:17:40 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','49',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:17:40','%','0','14.29','no','0.00',NULL,'202208220817','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000111','08:17:52 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','50',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:17:52','%','0','14.29','no','0.00',NULL,'202208220817','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000112','08:18:04 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','51',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:18:04','%','0','14.29','no','0.00',NULL,'202208220818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000113','08:18:20 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','52',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:18:20','%','0','14.29','no','0.00',NULL,'202208220818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000114','08:18:37 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','53',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:18:37','%','0','14.29','no','0.00',NULL,'202208220818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000115','08:18:56 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','54',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:18:56','%','0','14.29','no','0.00',NULL,'202208220818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000116','08:19:11 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','55',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:19:11','%','0','14.29','no','0.00',NULL,'202208220819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000117','08:19:27 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','56',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:19:27','%','0','14.29','no','0.00',NULL,'202208220819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000118','08:19:41 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','57',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:19:41','%','0','14.29','no','0.00',NULL,'202208220819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000119','08:19:52 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','58',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:19:52','%','0','14.29','no','0.00',NULL,'202208220819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000120','08:20:09 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','59',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:20:09','%','0','14.29','no','0.00',NULL,'202208220820','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000121','08:20:22 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','60',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:20:22','%','0','14.29','no','0.00',NULL,'202208220820','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000122','08:21:31 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','61',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:21:31','%','0','14.29','no','0.00',NULL,'202208220821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000123','08:21:53 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','62',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:21:53','%','0','14.29','no','0.00',NULL,'202208220821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000124','08:22:06 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','63',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:22:06','%','0','14.29','no','0.00',NULL,'202208220822','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000125','08:22:23 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','64',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:22:23','%','0','14.29','no','0.00',NULL,'202208220822','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000126','08:22:36 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','65',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:22:36','%','0','14.29','no','0.00',NULL,'202208220822','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000127','08:22:53 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','66',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:22:53','%','0','14.29','no','0.00',NULL,'202208220822','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000128','08:23:05 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','67',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:23:05','%','0','14.29','no','0.00',NULL,'202208220823','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000129','08:23:24 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','68',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:23:24','%','0','14.29','no','0.00',NULL,'202208220823','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000130','08:23:39 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','69',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:23:39','%','0','14.29','no','0.00',NULL,'202208220823','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000131','08:23:51 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','70',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:23:51','%','0','14.29','no','0.00',NULL,'202208220823','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000132','08:24:07 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','71',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:24:07','%','0','14.29','no','0.00',NULL,'202208220824','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000133','08:24:20 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','72',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:24:20','%','0','14.29','no','0.00',NULL,'202208220824','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000134','08:24:37 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','73',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:24:37','%','0','14.29','no','0.00',NULL,'202208220824','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000135','08:24:49 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','74',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:24:49','%','0','14.29','no','0.00',NULL,'202208220824','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'Drinking Water','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000136','08:25:04 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','15','15','75',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:25:04','%','0','14.29','no','0.00',NULL,'202208220825','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'Tea','1.0','9.52','9.52','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000137','08:26:59 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','10','10','76',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:26:59','%','0','9.52','no','0.00',NULL,'202208220826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'Egg Biryani','1.0','85.71','85.71','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000138','08:37:32 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','90','90','77',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:37:32','%','0','85.71','no','0.00',NULL,'202208220837','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'Egg Biryani','2.0','85.71','171.42','Item',NULL,NULL,'no',NULL,NULL,'20220822-1-0000139','08:37:41 AM','2022 08 22','ladmin','1','  Dine-in','  Cash','180','180','78',NULL,NULL,NULL,NULL,'22 Aug 2022','2022082208:37:41','%','0','171.42','no','0.00',NULL,'202208220837','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220831-1-000011','10:12:40 AM','2022 08 31','ladmin','1','  Dine-in','  Cash','40','40','79',NULL,NULL,NULL,NULL,'31 Aug 2022','2022083110:12:40','%','0','38.10','no','0.00',NULL,'202208311012','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000011','08:25:22 AM','2022 09 10','admin','1','  Dine-in','  Cash','40','40','80',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091008:25:22','%','0','38.10','no','0.00',NULL,'202209100825','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'38.10','','','','',NULL,NULL),(70,'roti','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000012','08:27:25 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','15','15','81',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091008:27:25','%','0','14.29','no','0.00',NULL,'202209100827','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'14.29','','','','',NULL,NULL),(71,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000013','08:29:56 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','40','40','82',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091008:29:56','%','0','38.10','no','0.00',NULL,'202209100829','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'38.10','','','','',NULL,NULL),(72,'Bread omlett','1.0','47.62','47.62','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000014','09:54:55 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','50','50','83',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091009:54:55','%','0','47.62','no','0.00',NULL,'202209100954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'47.62','','','','',NULL,NULL),(73,'roti','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000015','09:57:42 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','15','15','84',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091009:57:42','%','0','14.29','no','0.00',NULL,'202209100957','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'14.29','','','','',NULL,NULL),(74,'Masala/Medu Vada','1.0','28.57','28.57','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000016','09:59:36 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','30','30','85',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091009:59:36','%','0','28.57','no','0.00',NULL,'202209100959','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'28.57','','','','',NULL,NULL),(75,'Upma','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220910-1-000017','10:59:02 AM','2022 09 10','ladmin','1','  Dine-in','  Cash','40','40','86',NULL,NULL,NULL,NULL,'10 Sep 2022','2022091010:59:02','%','0','38.10','no','0.00',NULL,'202209101059','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'38.10','','','','',NULL,NULL),(76,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20220912-1-000011','09:41:47 AM','2022 09 12','admin','1','  Dine-in','  Cash','40','40','87',NULL,NULL,NULL,NULL,'12 Sep 2022','2022091209:41:47','%','0','38.10','no','0.00',NULL,'202209120941','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(77,'vada','1.0','19.05','19.05','Item',NULL,NULL,'no',NULL,NULL,'20220924-1-000011','09:45:47 AM','2022 09 24','ladmin','1','  Dine-in','  Cash','20','20','88',NULL,NULL,NULL,NULL,'24 Sep 2022','2022092409:45:47','%','0','19.05','no','0.00',NULL,'202209240945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(78,'Chow-Chow Bath','1.0','47.62','47.62','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000011','11:51:41 AM','2022 09 25','ladmin','1','  Dine-in','  Cash','50','50','89',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092511:51:41','%','0','47.62','no','0.00',NULL,'202209251151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(79,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000012','11:51:57 AM','2022 09 25','ladmin','1','  Dine-in','  Cash','120','120','90',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092511:51:57','%','0','114.29','no','0.00',NULL,'202209251151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(80,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000013','07:18:37 PM','2022 09 25','admin','1','  Dine-in','  Cash','120','120','91',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092519:18:37','%','0','114.29','no','0.00',NULL,'202209251918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(81,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000014','07:18:48 PM','2022 09 25','admin','1','  Dine-in','  Cash','120','120','92',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092519:18:48','%','0','114.29','no','0.00',NULL,'202209251918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(82,'RTE MEAL2','2.0','114.29','228.58','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000015','07:18:56 PM','2022 09 25','admin','1','  Dine-in','  Cash','240','240','93',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092519:18:56','%','0','228.58','no','0.00',NULL,'202209251918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(83,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220925-1-000016','07:19:04 PM','2022 09 25','admin','1','  Dine-in','  Cash','120','120','94',NULL,NULL,NULL,NULL,'25 Sep 2022','2022092519:19:04','%','0','114.29','no','0.00',NULL,'202209251919','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(84,'RT MEAL','20.0','142.86','2857.20','Item',NULL,NULL,'no',NULL,NULL,'20220926-1-000011','10:55:02 AM','2022 09 26','admin','1','  Dine-in','  Cash','4100','4100','95',NULL,NULL,NULL,NULL,'26 Sep 2022','2022092610:55:02','%','0','2857.20','no','0.00',NULL,'202209261055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(85,'Std Non Veg b/f','10.0','47.62','476.20','Item',NULL,NULL,'no',NULL,NULL,'20220926-1-000011','10:55:02 AM','2022 09 26','admin','1','  Dine-in','  Cash','4100','4100','96',NULL,NULL,NULL,NULL,'26 Sep 2022','2022092610:55:02','%','0','476.20','no','0.00',NULL,'202209261055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(86,'RTE MEAL2','5.0','114.29','571.45','Item',NULL,NULL,'no',NULL,NULL,'20220926-1-000011','10:55:02 AM','2022 09 26','admin','1','  Dine-in','  Cash','4100','4100','97',NULL,NULL,NULL,NULL,'26 Sep 2022','2022092610:55:02','%','0','571.45','no','0.00',NULL,'202209261055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(87,'Std Non Veg b/f','2.0','47.62','95.24','Item',NULL,NULL,'no',NULL,NULL,'20220927-1-000011','12:29:32 PM','2022 09 27','admin','1','  Dine-in','  Cash','100','100','98',NULL,NULL,NULL,NULL,'27 Sep 2022','2022092712:29:32','%','0','95.24','no','0.00',NULL,'202209271229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(88,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220927-1-000012','12:30:54 PM','2022 09 27','admin','1','  Dine-in','  Cash','120','120','99',NULL,NULL,NULL,NULL,'27 Sep 2022','2022092712:30:54','%','0','114.29','no','0.00',NULL,'202209271230','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(89,'RTE MEAL2','2.0','114.29','228.58','Item',NULL,NULL,'no',NULL,NULL,'20220927-1-000013','12:31:12 PM','2022 09 27','admin','1','  Dine-in','  Cash','240','240','100',NULL,NULL,NULL,NULL,'27 Sep 2022','2022092712:31:12','%','0','228.58','no','0.00',NULL,'202209271231','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(90,'RTE MEAL2','1.0','114.29','114.29','Item',NULL,NULL,'no',NULL,NULL,'20220927-1-000014','04:30:59 PM','2022 09 27','admin','1','  Dine-in','  Cash','120','120','101',NULL,NULL,NULL,NULL,'27 Sep 2022','2022092716:30:59','%','0','114.29','no','0.00',NULL,'202209271630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(91,'RTE MEAL2','4.0','114.29','457.16','Item',NULL,NULL,'no',NULL,NULL,'20220927-1-000015','08:38:27 PM','2022 09 27','admin','1','  Dine-in','  Cash','480','480','102',NULL,NULL,NULL,NULL,'27 Sep 2022','2022092720:38:27','%','0','457.16','no','0.00',NULL,'202209272038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(92,'poori','1.0','33.33','33.33','Item',NULL,NULL,'no',NULL,NULL,'20221006-1-000011','09:38:26 AM','2022 10 06','admin','1','  Dine-in','  Cash','35','35','103',NULL,NULL,NULL,NULL,'06 Oct 2022','2022100609:38:26','%','0','33.33','no','0.00',NULL,'202210060938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(93,'poori','2.0','33.33','66.66','Item',NULL,NULL,'no',NULL,NULL,'20221006-1-000012','09:39:17 AM','2022 10 06','admin','1','  Dine-in','  Cash','70','70','104',NULL,NULL,NULL,NULL,'06 Oct 2022','2022100609:39:17','%','0','66.66','no','0.00',NULL,'202210060939','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(94,'poori','1.0','33.33','33.33','Item',NULL,NULL,'no',NULL,NULL,'20221012-1-000011','09:27:37 AM','2022 10 12','admin','1','  Dine-in','  Cash','35','35','105',NULL,NULL,NULL,NULL,'12 Oct 2022','2022101209:27:37','%','0','33.33','no','0.00',NULL,'202210120927','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(95,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20221018-1-000011','09:50:18 AM','2022 10 18','ladmin','1','  Dine-in','  Cash','40','40','106',NULL,NULL,NULL,NULL,'18 Oct 2022','2022101809:50:18','%','0','38.10','no','0.00',NULL,'202210180950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(96,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20230907-1-000011','01:49:33 PM','2023 09 07','admin','1','  Dine-in','  Cash','90.01','90.01','1',NULL,NULL,NULL,NULL,'07 Sep 2023','2023090713:49:33','%','0','38.10','no','0.00',NULL,'202309071349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(97,'Bread omlett','1.0','47.62','47.62','Item',NULL,NULL,'no',NULL,NULL,'20230907-1-000011','01:49:33 PM','2023 09 07','admin','1','  Dine-in','  Cash','90.01','90.01','2',NULL,NULL,NULL,NULL,'07 Sep 2023','2023090713:49:33','%','0','47.62','no','0.00',NULL,'202309071349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(98,'Idli','1.0','38.10','38.10','Item',NULL,NULL,'no',NULL,NULL,'20230907-1-000012','02:19:15 PM','2023 09 07','admin','1','  Dine-in','  Cash','90.01','90.01','1',NULL,NULL,NULL,NULL,'07 Sep 2023','2023090714:19:15','%','0','38.10','no','0.00',NULL,'202309071419','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(99,'Bread omlett','1.0','47.62','47.62','Item',NULL,NULL,'no',NULL,NULL,'20230907-1-000012','02:19:15 PM','2023 09 07','admin','1','  Dine-in','  Cash','90.01','90.01','2',NULL,NULL,NULL,NULL,'07 Sep 2023','2023090714:19:15','%','0','47.62','no','0.00',NULL,'202309071419','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(101,'Wagh Bakri','1.0','14.29','14.29','Item',NULL,NULL,'no',NULL,NULL,'20240506-1-000011','10:29:13 PM','2024 05 06','admin','1','  Dine-in','  Cash','15.00','15.00','22',NULL,NULL,NULL,NULL,'06 May 2024','2024050622:29:13','%','0','14.29','no','0.00',NULL,'202405062229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(218,' Veg Meal with mater paneer','1.0','172.00','172.00','Item',NULL,NULL,'no',NULL,NULL,'20240128-1-000011','10:02:45 PM','2024 01 28','ladmin','1','  Dine-in','  Cash','180.60','180.60','439',NULL,NULL,NULL,NULL,'28 Jan 2024','2024012822:02:45','%','0','172.00','no','0.00',NULL,'202401282202','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'172.00','','','','',NULL,NULL),(219,'Bread omlett','4.0','47.62','190.48','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000011','09:49:14 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','220.01','220.01','459',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:49:14','%','0','190.48','no','0.00',NULL,'202402212149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'190.48','','','','',NULL,NULL),(220,'vada','1.0','19.05','19.05','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000011','09:49:14 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','220.01','220.01','460',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:49:14','%','0','19.05','no','0.00',NULL,'202402212149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'19.05','','','','',NULL,NULL),(221,' Veg Meal with mater paneer','1.0','172.00','172.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000012','09:51:06 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','180.60','180.60','461',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:51:06','%','0','172.00','no','0.00',NULL,'202402212151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'172.00','','','','',NULL,NULL),(222,' Veg Meal with mater paneer','2.0','172.00','344.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000013','09:51:18 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','361.20','361.20','462',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:51:18','%','0','344.00','no','0.00',NULL,'202402212151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'344.00','','','','',NULL,NULL),(223,' Veg Meal with mater paneer','2.0','172.00','344.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000014','09:51:28 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','361.20','361.20','463',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:51:28','%','0','344.00','no','0.00',NULL,'202402212151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'344.00','','','','',NULL,NULL),(224,' Veg Meal with mater paneer','2.0','172.00','344.00','Item',NULL,NULL,'no',NULL,NULL,'20240221-1-000015','09:51:52 PM','2024 02 21','ladmin','1','  Dine-in','  Cash','361.20','361.20','464',NULL,NULL,NULL,NULL,'21 Feb 2024','2024022121:51:52','%','0','344.00','no','0.00',NULL,'202402212151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'344.00','','','','',NULL,NULL),(225,' chicken curry meal with veg dry','5.0','171.81','859.05','Item',NULL,NULL,'no',NULL,NULL,'20240222-1-000011','10:08:23 AM','2024 02 22','ladmin','1','  Dine-in','  Cash','1141.99','1141.99','470',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022210:08:23','%','0','171.81','no','0.00',NULL,'202402221008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'859.05','','','','',NULL,NULL),(226,'RTE B/F','4.0','57.14','228.56','Item',NULL,NULL,'no',NULL,NULL,'20240222-1-000011','10:08:23 AM','2024 02 22','ladmin','1','  Dine-in','  Cash','1141.99','1141.99','471',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022210:08:23','%','0','228.56','no','0.00',NULL,'202402221008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,'228.56','','','','',NULL,NULL),(227,'puri sabji','14.0','48.10','673.40','Item',NULL,NULL,'no',NULL,NULL,'20240222-1-000012','10:16:20 AM','2024 02 22','ladmin','1','  Dine-in','  Cash','707.07','707.07','473',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022210:16:20','%','0','673.40','no','0.00',NULL,'202402221016','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'673.40','','','','',NULL,NULL),(228,'puri sabji','4.0','48.10','192.40','Item',NULL,NULL,'no',NULL,NULL,'20240222-1-000013','10:17:05 AM','2024 02 22','ladmin','1','  Dine-in','  Cash','202.02','202.02','474',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022210:17:05','%','0','192.40','no','0.00',NULL,'202402221017','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'192.40','','','','',NULL,NULL),(229,'puri sabji','18.0','48.10','865.80','Item',NULL,NULL,'no',NULL,NULL,'20240222-1-000014','10:18:13 AM','2024 02 22','ladmin','1','  Dine-in','  Cash','909.09','909.09','475',NULL,NULL,NULL,NULL,'22 Feb 2024','2024022210:18:13','%','0','865.80','no','0.00',NULL,'202402221018','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'865.80','','','','',NULL,NULL),(230,'poha','1.0','48.10','48.10','Item',NULL,NULL,'no',NULL,NULL,'20240225-1-000011','05:43:40 PM','2024 02 25','ladmin','1','  Dine-in','  Cash','225.35','225.35','476',NULL,NULL,NULL,NULL,'25 Feb 2024','2024022517:43:40','%','0','48.10','no','0.00',NULL,'202402251743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'48.10','','','','',NULL,NULL),(231,'Cappuccino','1.0','23.81','23.81','Item',NULL,NULL,'no',NULL,NULL,'20240225-1-000011','05:43:40 PM','2024 02 25','ladmin','1','  Dine-in','  Cash','225.35','225.35','477',NULL,NULL,NULL,NULL,'25 Feb 2024','2024022517:43:40','%','0','23.81','no','0.00',NULL,'202402251743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'23.81','','','','',NULL,NULL),(232,'maggi','3.0','47.57','142.71','Item',NULL,NULL,'no',NULL,NULL,'20240225-1-000011','05:43:40 PM','2024 02 25','ladmin','1','  Dine-in','  Cash','225.35','225.35','478',NULL,NULL,NULL,NULL,'25 Feb 2024','2024022517:43:40','%','0','142.71','no','0.00',NULL,'202402251743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'142.71','','','','',NULL,NULL),(233,' Veg Meal with mater paneer','1.0','172.00','172.00','Item',NULL,NULL,'no',NULL,NULL,'20240225-1-000012','09:13:55 PM','2024 02 25','ladmin','1','  Dine-in','  Cash','281.10','281.10','480',NULL,NULL,NULL,NULL,'25 Feb 2024','2024022521:13:55','%','0','172.00','no','0.00',NULL,'202402252113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'172.00','','','','',NULL,NULL),(234,'Egg Biryani','1.0','95.71','95.71','Item',NULL,NULL,'no',NULL,NULL,'20240225-1-000012','09:13:55 PM','2024 02 25','ladmin','1','  Dine-in','  Cash','281.10','281.10','481',NULL,NULL,NULL,NULL,'25 Feb 2024','2024022521:13:55','%','0','95.71','no','0.00',NULL,'202402252113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'95.71','','','','',NULL,NULL);
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20220709-1-000011','5.00','admin','2022 07 09','  Cash','  Dine-in','4.76','0.24','+ 0.00','5.0','1','202207091110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20220717-1-000011','5.00','admin','2022 07 17','  Cash','  Dine-in','4.76','0.24','+ 0.00','5.0','2','202207170528',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20220717-1-000012','80.00','ladmin','2022 07 17','  Cash','  Dine-in','76.19','3.81','+ 0.00','5.0','3','202207171117',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20220718-1-000011','1845.00','ladmin','2022 07 18','  Cash','  Dine-in','1757.18','87.86','- 0.04','5.0','4','202207181624',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20220723-1-000011','5.00','admin','2022 07 23','  Cash','  Dine-in','4.76','0.24','+ 0.00','5.0','5','202207230537',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20220726-1-000011','40.00','ladmin','2022 07 26','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','6','202207260852',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20220726-1-000012','120.00','ladmin','2022 07 26','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','7','202207260852',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20220726-1-000013','40.00','ladmin','2022 07 26','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','8','202207260852',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20220726-1-000014','20.00','ladmin','2022 07 26','  Cash','  Dine-in','19.05','0.95','- 0.00','5.0','9','202207260853',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20220726-1-000015','40.00','ladmin','2022 07 26','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','10','202207261223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20220726-1-000016','40.00','ladmin','2022 07 26','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','11','202207261313',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20220728-1-000011','40.00','ladmin','2022 07 28','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','12','202207280942',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20220728-1-000012','40.00','ladmin','2022 07 28','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','13','202207280943',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'20220729-1-000011','120.00','ladmin','2022 07 29','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','14','202207291342',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'20220730-1-000011','80.00','ladmin','2022 07 30','  Cash','  Dine-in','76.20','3.81','- 0.01','5.0','15','202207301002',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'20220801-1-000011','40.00','ladmin','2022 08 01','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','16','202208011005',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'20220819-1-000011','70.00','ladmin','2022 08 19','  Cash','  Dine-in','66.67','3.33','- 0.00','5.0','17','202208190940',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'20220819-1-000012','15.00','ladmin','2022 08 19','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','18','202208190955',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'20220822-1-000011','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','19','202208220812',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'20220822-1-000012','20.00','ladmin','2022 08 22','  Cash','  Dine-in','19.04','0.95','+ 0.01','5.0','20','202208220813',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'20220822-1-000013','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','21','202208220813',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'20220822-1-000014','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','22','202208220813',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'20220822-1-000015','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','23','202208220814',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'20220822-1-000016','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','24','202208220814',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'20220822-1-000017','20.00','ladmin','2022 08 22','  Cash','  Dine-in','19.04','0.95','+ 0.01','5.0','25','202208220815',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'20220822-1-000018','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','26','202208220816',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'20220822-1-000019','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','27','202208220816',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'20220822-1-0000110','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','28','202208220817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'20220822-1-0000111','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','29','202208220817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'20220822-1-0000112','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','30','202208220818',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'20220822-1-0000113','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','31','202208220818',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'20220822-1-0000114','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','32','202208220818',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'20220822-1-0000115','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','33','202208220818',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'20220822-1-0000116','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','34','202208220819',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'20220822-1-0000117','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','35','202208220819',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'20220822-1-0000118','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','36','202208220819',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'20220822-1-0000119','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','37','202208220819',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'20220822-1-0000120','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','38','202208220820',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'20220822-1-0000121','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','39','202208220820',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'20220822-1-0000122','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','40','202208220821',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'20220822-1-0000123','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','41','202208220821',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'20220822-1-0000124','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','42','202208220822',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'20220822-1-0000125','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','43','202208220822',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'20220822-1-0000126','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','44','202208220822',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'20220822-1-0000127','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','45','202208220822',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'20220822-1-0000128','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','46','202208220823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'20220822-1-0000129','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','47','202208220823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'20220822-1-0000130','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','48','202208220823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'20220822-1-0000131','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','49','202208220823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'20220822-1-0000132','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','50','202208220824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'20220822-1-0000133','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','51','202208220824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'20220822-1-0000134','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','52','202208220824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'20220822-1-0000135','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','53','202208220824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'20220822-1-0000136','15.00','ladmin','2022 08 22','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','54','202208220825',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'20220822-1-0000137','10.00','ladmin','2022 08 22','  Cash','  Dine-in','9.52','0.48','+ 0.00','5.0','55','202208220826',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'20220822-1-0000138','90.00','ladmin','2022 08 22','  Cash','  Dine-in','85.71','4.29','+ 0.00','5.0','56','202208220837',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'20220822-1-0000139','180.00','ladmin','2022 08 22','  Cash','  Dine-in','171.42','8.57','+ 0.01','5.0','57','202208220837',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'20220831-1-000011','40.00','ladmin','2022 08 31','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','58','202208311012',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'20220910-1-000011','40.00','admin','2022 09 10','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','59','202209100825',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'20220910-1-000012','15.00','ladmin','2022 09 10','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','60','202209100827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'20220910-1-000013','40.00','ladmin','2022 09 10','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','61','202209100829',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'20220910-1-000014','50.00','ladmin','2022 09 10','  Cash','  Dine-in','47.62','2.38','- 0.00','5.0','62','202209100954',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'20220910-1-000015','15.00','ladmin','2022 09 10','  Cash','  Dine-in','14.29','0.71','- 0.00','5.0','63','202209100957',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'20220910-1-000016','30.00','ladmin','2022 09 10','  Cash','  Dine-in','28.57','1.43','+ 0.00','5.0','64','202209100959',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'20220910-1-000017','40.00','ladmin','2022 09 10','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','65','202209101059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'20220912-1-000011','40.00','admin','2022 09 12','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','66','202209120941',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'20220924-1-000011','20.00','ladmin','2022 09 24','  Cash','  Dine-in','19.05','0.95','- 0.00','5.0','67','202209240945',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'20220925-1-000011','50.00','ladmin','2022 09 25','  Cash','  Dine-in','47.62','2.38','- 0.00','5.0','68','202209251151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'20220925-1-000012','120.00','ladmin','2022 09 25','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','69','202209251151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'20220925-1-000013','120.00','admin','2022 09 25','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','70','202209251918',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'20220925-1-000014','120.00','admin','2022 09 25','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','71','202209251918',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'20220925-1-000015','240.00','admin','2022 09 25','  Cash','  Dine-in','228.58','11.43','- 0.01','5.0','72','202209251918',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'20220925-1-000016','120.00','admin','2022 09 25','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','73','202209251919',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'20220926-1-000011','4100.00','admin','2022 09 26','  Cash','  Dine-in','3904.85','195.24','- 0.09','5.0','74','202209261055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'20220927-1-000011','100.00','admin','2022 09 27','  Cash','  Dine-in','95.24','4.76','- 0.00','5.0','75','202209271229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'20220927-1-000012','120.00','admin','2022 09 27','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','76','202209271230',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'20220927-1-000013','240.00','admin','2022 09 27','  Cash','  Dine-in','228.58','11.43','- 0.01','5.0','77','202209271231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'20220927-1-000014','120.00','admin','2022 09 27','  Cash','  Dine-in','114.29','5.71','- 0.00','5.0','78','202209271630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'20220927-1-000015','480.00','admin','2022 09 27','  Cash','  Dine-in','457.16','22.86','- 0.02','5.0','79','202209272038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'20221006-1-000011','35.00','admin','2022 10 06','  Cash','  Dine-in','33.33','1.67','+ 0.00','5.0','80','202210060938',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'20221006-1-000012','70.00','admin','2022 10 06','  Cash','  Dine-in','66.66','3.33','+ 0.01','5.0','81','202210060939',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'20221012-1-000011','35.00','admin','2022 10 12','  Cash','  Dine-in','33.33','1.67','+ 0.00','5.0','82','202210120927',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'20221018-1-000011','40.00','ladmin','2022 10 18','  Cash','  Dine-in','38.10','1.90','- 0.00','5.0','83','202210180950',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'20230907-1-000011','90.01','admin','2023 09 07','  Cash','  Dine-in','85.72','4.29','0.00','5.0','1','202309071349',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'20230907-1-000012','90.01','admin','2023 09 07','  Cash','  Dine-in','85.72','4.29','0.00','5.0','2','202309071419',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'20240506-1-000011','15.00','admin','2024 05 06','  Cash','  Dine-in','14.29','0.71','0.00','5.0','1','202405062229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,'20240128-1-000011','180.60','ladmin','2024 01 28','  Cash','  Dine-in','172.00','8.60','0.00','5.0','105','202401282202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(189,'20240221-1-000011','220.01','ladmin','2024 02 21','  Cash','  Dine-in','209.53','10.48','0.00','5.0','106','202402212149',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(190,'20240221-1-000012','180.60','ladmin','2024 02 21','  Cash','  Dine-in','172.00','8.60','0.00','5.0','107','202402212151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'20240221-1-000013','361.20','ladmin','2024 02 21','  Cash','  Dine-in','344.00','17.20','0.00','5.0','108','202402212151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'20240221-1-000014','361.20','ladmin','2024 02 21','  Cash','  Dine-in','344.00','17.20','0.00','5.0','109','202402212151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,'20240221-1-000015','361.20','ladmin','2024 02 21','  Cash','  Dine-in','344.00','17.20','0.00','5.0','110','202402212151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(194,'20240222-1-000011','1141.99','ladmin','2024 02 22','  Cash','  Dine-in','1087.61','54.38','0.00','5.0','111','202402221008',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,'20240222-1-000012','707.07','ladmin','2024 02 22','  Cash','  Dine-in','673.40','33.67','0.00','5.0','112','202402221016',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,'20240222-1-000013','202.02','ladmin','2024 02 22','  Cash','  Dine-in','192.40','9.62','0.00','5.0','113','202402221017',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(197,'20240222-1-000014','909.09','ladmin','2024 02 22','  Cash','  Dine-in','865.80','43.29','0.00','5.0','114','202402221018',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(198,'20240225-1-000011','225.35','ladmin','2024 02 25','  Cash','  Dine-in','214.62','10.73','0.00','5.0','115','202402251743',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(199,'20240225-1-000012','281.10','ladmin','2024 02 25','  Cash','  Dine-in','267.71','13.39','0.00','5.0','116','202402252113',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Drinking Water',385),(2,'Egg Biryani',257),(3,'Tea',114);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'36','Drinking Water',385,51,'27','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'23','Egg Biryani',257,34,'3','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'27','Tea',114,15,'12','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Drinks',114),(2,'Main course',257),(3,'None',385);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',795);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',795,100);
