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,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20220707-1-000011','05:02:54 PM','2022 07 07','user1','1','  Dine-in','  Cash','10.00','10.00','1',NULL,NULL,NULL,NULL,'07 Jul 2022','2022070717:02:54','%','0','10.00','no','0.00',NULL,'202207071702','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','user1','abcd',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000011','07:38:57 AM','2023 12 16','admin','1','  Dine-in','  Cash','21.00','21.00','1',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121607:38:57','%','0','20.00','no','0.00',NULL,'202312160738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'CHICKEN CHILLY (BONELESS)','1.0','95.24','95.24','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000012','07:40:14 AM','2023 12 16','admin','1','  Dine-in','  Cash','95.24','95.24','2',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121607:40:14','%','0','95.24','no','0.00',NULL,'202312160740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000012','07:41:02 AM','2023 12 16','admin','1','  Dine-in','  Cash','35','35','5',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121607:41:02','%','0','35.00','no','0.00',NULL,'202312160741','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'veg thali','9.0','80.00','720.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000013','01:06:25 PM','2023 12 16','admin','1','  Dine-in','  Cash','720.00','720.00','25',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121613:06:25','%','0','720.00','no','0.00',NULL,'202312161306','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'veg thali','12.0','80.00','960.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000014','01:15:26 PM','2023 12 16','admin','1','  Dine-in','  Cash','960.00','960.00','28',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121613:15:26','%','0','960.00','no','0.00',NULL,'202312161315','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'non veg barek fast ','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000015','01:16:26 PM','2023 12 16','admin','1','  Dine-in','  Cash','150.00','150.00','29',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121613:16:26','%','0','150.00','no','0.00',NULL,'202312161316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000016','01:28:34 PM','2023 12 16','admin','1','  Dine-in','  Cash','150.00','180.00','35',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121613:28:34','%','0','100.00','no','0.00',NULL,'202312161328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231216-1-000016','01:28:34 PM','2023 12 16','admin','1','  Dine-in','  Cash','150.00','180.00','36',NULL,NULL,NULL,NULL,'16 Dec 2023','2023121613:28:34','%','0','80.00','no','0.00',NULL,'202312161328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231217-1-000011','12:42:59 PM','2023 12 17','admin','1','  Dine-in','  Cash','80.00','80.00','37',NULL,NULL,NULL,NULL,'17 Dec 2023','2023121712:42:59','%','0','80.00','no','0.00',NULL,'202312171242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'veg thali','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231217-1-000012','01:43:33 PM','2023 12 17','admin','1','  Dine-in','  Cash','300.00','360.00','39',NULL,NULL,NULL,NULL,'17 Dec 2023','2023121713:43:33','%','0','160.00','no','0.00',NULL,'202312171343','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'Paneer Curry ','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20231217-1-000012','01:43:33 PM','2023 12 17','admin','1','  Dine-in','  Cash','300.00','360.00','40',NULL,NULL,NULL,NULL,'17 Dec 2023','2023121713:43:33','%','0','200.00','no','0.00',NULL,'202312171343','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000011','01:34:31 PM','2023 12 18','admin','1','  Dine-in','  Cash','20.00','20.00','41',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121813:34:31','%','0','20.00','no','0.00',NULL,'202312181334','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'egg viryani ','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000012','01:34:47 PM','2023 12 18','admin','1','  Dine-in','  Cash','90.00','90.00','42',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121813:34:47','%','0','90.00','no','0.00',NULL,'202312181334','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000013','01:35:12 PM','2023 12 18','admin','1','  Dine-in','  Cash','70.00','70.00','43',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121813:35:12','%','0','70.00','no','0.00',NULL,'202312181335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000014','07:08:30 PM','2023 12 18','admin','1','  Dine-in','  Cash','180.00','180.00','44',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121819:08:30','%','0','80.00','no','0.00',NULL,'202312181908','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000014','07:08:30 PM','2023 12 18','admin','1','  Dine-in','  Cash','180.00','180.00','45',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121819:08:30','%','0','100.00','no','0.00',NULL,'202312181908','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'egg thali ','2.0','90.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000015','07:09:21 PM','2023 12 18','admin','1','  Dine-in','  Cash','180.00','180.00','46',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121819:09:21','%','0','180.00','no','0.00',NULL,'202312181909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000011','12:54:14 PM','2023 12 19','admin','1','  Dine-in','  Cash','80.00','80.00','47',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121912:54:14','%','0','80.00','no','0.00',NULL,'202312191254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'CHICKEN CURRY','5.0','100.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','48',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','500.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'veg thali','8.0','80.00','640.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','49',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','640.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'tea','8.0','20.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','50',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','160.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'EGG CURRY','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','51',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','150.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'P-VEG CORMA','3.0','40.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','52',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','120.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','53',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','40.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'non veg barek fast ','4.0','50.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','01:46:41 PM','2023 12 19','admin','1','  Dine-in','  Cash','1810.00','1810.00','54',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:46:41','%','0','200.00','no','0.00',NULL,'202312191346','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'rail neer','3.0','15.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000013','01:51:16 PM','2023 12 19','admin','1','  Dine-in','  Cash','45.00','45.00','56',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121913:51:16','%','0','45.00','no','0.00',NULL,'202312191351','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'veg thali','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000014','08:40:34 PM','2023 12 19','admin','1','  Dine-in','  Cash','160.00','160.00','57',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121920:40:34','%','0','160.00','no','0.00',NULL,'202312192040','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'veg thali','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000015','08:41:53 PM','2023 12 19','admin','1','  Dine-in','  Cash','260.00','360.00','58',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121920:41:53','%','0','160.00','no','0.00',NULL,'202312192041','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'Paneer Curry ','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000015','08:41:53 PM','2023 12 19','admin','1','  Dine-in','  Cash','260.00','360.00','59',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121920:41:53','%','0','200.00','no','0.00',NULL,'202312192041','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'CHICKEN CURRY','4.0','100.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000016','09:35:01 PM','2023 12 19','admin','1','  Dine-in','  Cash','720.00','720.00','60',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121921:35:01','%','0','400.00','no','0.00',NULL,'202312192135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'veg thali','4.0','80.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000016','09:35:01 PM','2023 12 19','admin','1','  Dine-in','  Cash','720.00','720.00','61',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121921:35:01','%','0','320.00','no','0.00',NULL,'202312192135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'veg thali','16.0','80.00','1280.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000011','11:37:52 AM','2023 12 21','admin','1','  Dine-in','  Cash','2880.00','2880.0','62',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:37:52','%','0','1280.00','no','0.00',NULL,'202312211137','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'Paneer Curry ','16.0','100.00','1600.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000011','11:37:52 AM','2023 12 21','admin','1','  Dine-in','  Cash','2880.00','2880.0','63',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:37:52','%','0','1600.00','no','0.00',NULL,'202312211137','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'Paneer Curry ','16.0','100.00','1600.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000012','11:40:17 AM','2023 12 21','admin','1','  Dine-in','  Cash','2400.00','2880.00','66',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:40:17','%','0','1600.00','no','0.00',NULL,'202312211140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'veg thali','16.0','80.00','1280.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000012','11:40:17 AM','2023 12 21','admin','1','  Dine-in','  Cash','2400.00','2880.00','67',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:40:17','%','0','1280.00','no','0.00',NULL,'202312211140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'tea','20.0','20.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000013','11:50:47 AM','2023 12 21','admin','1','  Dine-in','  Cash','400.00','400.00','68',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:50:47','%','0','400.00','no','0.00',NULL,'202312211150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'rail neer','30.0','15.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000014','11:52:16 AM','2023 12 21','admin','1','  Dine-in','  Cash','450.00','450.00','69',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122111:52:16','%','0','450.00','no','0.00',NULL,'202312211152','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000015','01:31:07 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','70',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:31:07','%','0','80.00','no','0.00',NULL,'202312211331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000015','01:31:07 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','71',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:31:07','%','0','100.00','no','0.00',NULL,'202312211331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000016','01:31:34 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','72',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:31:34','%','0','80.00','no','0.00',NULL,'202312211331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000016','01:31:34 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','73',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:31:34','%','0','100.00','no','0.00',NULL,'202312211331','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000017','01:32:00 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','74',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:32:00','%','0','80.00','no','0.00',NULL,'202312211332','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000017','01:32:00 PM','2023 12 21','admin','1','  Dine-in','  Cash','150.00','180.00','75',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:32:00','%','0','100.00','no','0.00',NULL,'202312211332','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'pani puri','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000011','08:34:40 PM','2023 12 22','admin','1','  Dine-in','  Cash','70.00','70.00','76',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122220:34:40','%','0','70.00','no','0.00',NULL,'202312222034','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'non veg thali','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000012','08:38:30 PM','2023 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','77',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122220:38:30','%','0','130.00','no','0.00',NULL,'202312222038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'non veg thali','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000013','08:38:56 PM','2023 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','78',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122220:38:56','%','0','130.00','no','0.00',NULL,'202312222038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'egg viryani ','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000011','01:03:19 PM','2023 12 23','admin','1','  Dine-in','  Cash','90.00','90.00','79',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122313:03:19','%','0','90.00','no','0.00',NULL,'202312231303','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'veg thali','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000012','05:50:24 PM','2023 12 23','admin','1','  Dine-in','  Cash','300.00','360.00','88',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:50:24','%','0','160.00','no','0.00',NULL,'202312231750','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'Paneer Curry ','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000012','05:50:24 PM','2023 12 23','admin','1','  Dine-in','  Cash','300.00','360.00','89',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:50:24','%','0','200.00','no','0.00',NULL,'202312231750','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'veg thali','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000013','05:50:57 PM','2023 12 23','admin','1','  Dine-in','  Cash','300.00','360.00','90',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:50:57','%','0','160.00','no','0.00',NULL,'202312231750','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'Paneer Curry ','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000013','05:50:57 PM','2023 12 23','admin','1','  Dine-in','  Cash','300.00','360.00','91',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:50:57','%','0','200.00','no','0.00',NULL,'202312231750','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000014','05:51:25 PM','2023 12 23','admin','1','  Dine-in','  Cash','150.00','180.00','92',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:51:25','%','0','80.00','no','0.00',NULL,'202312231751','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000014','05:51:25 PM','2023 12 23','admin','1','  Dine-in','  Cash','150.00','180.00','93',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122317:51:25','%','0','100.00','no','0.00',NULL,'202312231751','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000015','07:09:14 PM','2023 12 23','admin','1','  Dine-in','  Cash','150.00','180.00','94',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122319:09:14','%','0','80.00','no','0.00',NULL,'202312231909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'Paneer Curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231223-1-000015','07:09:14 PM','2023 12 23','admin','1','  Dine-in','  Cash','150.00','180.00','95',NULL,NULL,NULL,NULL,'23 Dec 2023','2023122319:09:14','%','0','100.00','no','0.00',NULL,'202312231909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000011','02:54:01 PM','2023 12 26','admin','1','  Dine-in','  Cash','20.00','20.00','1',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:54:01','%','0','20.00','no','0.00',NULL,'202312261454','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'CHICKEN CHILLY (BONELESS)','1.0','95.24','95.24','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:09 PM','2023 12 26','admin','1','  Dine-in','  Cash','205','205','2',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:09','%','0','95.24','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'CHICKEN CURRY','1.0','95.24','95.24','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:09 PM','2023 12 26','admin','1','  Dine-in','  Cash','205','205','3',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:09','%','0','95.24','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'rail neer','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:09 PM','2023 12 26','admin','1','  Dine-in','  Cash','205','205','4',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:09','%','0','15.00','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'CHICKEN CHILLY (BONELESS)','1.0','95.24','95.24','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:50 PM','2023 12 26','admin','1','  Dine-in','  Cash','345','345','2',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:50','%','0','95.24','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'CHICKEN CURRY','1.0','95.24','95.24','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:50 PM','2023 12 26','admin','1','  Dine-in','  Cash','345','345','3',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:50','%','0','95.24','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'rail neer','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:50 PM','2023 12 26','admin','1','  Dine-in','  Cash','345','345','4',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:50','%','0','15.00','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'egg thali ','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:50 PM','2023 12 26','admin','1','  Dine-in','  Cash','345','345','5',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:50','%','0','90.00','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'non veg barek fast ','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:55:50 PM','2023 12 26','admin','1','  Dine-in','  Cash','345','345','6',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:55:50','%','0','50.00','no','0.00',NULL,'202312261455','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000012','02:57:31 PM','2023 12 26','admin','1','  Dine-in','  Cash','25','25','7',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122614:57:31','%','0','25.00','no','0.00',NULL,'202312261457','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000013','03:03:40 PM','2023 12 26','admin','1','  Dine-in','  Cash','35','35','8',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:03:40','%','0','35.00','no','0.00',NULL,'202312261503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000014','03:03:48 PM','2023 12 26','admin','1','  Dine-in','  Cash','35','35','9',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:03:48','%','0','35.00','no','0.00',NULL,'202312261503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000015','03:04:01 PM','2023 12 26','admin','1','  Dine-in','  Cash','35','35','10',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:04:01','%','0','35.00','no','0.00',NULL,'202312261504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000016','03:04:13 PM','2023 12 26','admin','1','  Dine-in','  Cash','30','30','11',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:04:13','%','0','30.00','no','0.00',NULL,'202312261504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000017','03:05:52 PM','2023 12 26','admin','1','  Dine-in','  Cash','30','30','12',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:05:52','%','0','30.00','no','0.00',NULL,'202312261505','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(72,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231226-1-000018','03:06:20 PM','2023 12 26','admin','1','  Dine-in','  Cash','35','35','13',NULL,NULL,NULL,NULL,'26 Dec 2023','2023122615:06:20','%','0','35.00','no','0.00',NULL,'202312261506','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(73,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000011','03:44:27 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','55','55','15',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:44:27','%','0','35.00','no','0.00',NULL,'202412291544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(74,'BAGH BAKRI CAPICHUNO TEA','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000011','03:44:27 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','55','55','16',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:44:27','%','0','20.00','no','0.00',NULL,'202412291544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(75,'BAGH BAKRI CAPICHUNO TEA','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000012','03:44:38 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','20','20','17',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:44:38','%','0','20.00','no','0.00',NULL,'202412291544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(76,'coffee chino ','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000013','03:53:18 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','25','25','18',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:53:18','%','0','25.00','no','0.00',NULL,'202412291553','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(77,'BAGH BAKRI CAPICHUNO TEA','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000014','03:58:05 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','40','40','19',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:58:05','%','0','20.00','no','0.00',NULL,'202412291558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(78,'tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000014','03:58:05 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','40','40','20',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122915:58:05','%','0','20.00','no','0.00',NULL,'202412291558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(79,'CHICKEN STD MEAL','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000015','04:02:34 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','130','130','24',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:02:34','%','0','130.00','no','0.00',NULL,'202412291602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(80,'paneer curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000016','04:04:44 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','27',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:04:44','%','0','100.00','no','0.00',NULL,'202412291604','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(81,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000016','04:04:44 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','28',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:04:44','%','0','80.00','no','0.00',NULL,'202412291604','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(82,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000017','04:05:00 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','29',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:00','%','0','80.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(83,'paneer curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000017','04:05:00 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','30',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:00','%','0','100.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(84,'paneer curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000018','04:05:13 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','31',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:13','%','0','100.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(85,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000018','04:05:13 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','32',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:13','%','0','80.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(86,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000019','04:05:23 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','33',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:23','%','0','80.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(87,'paneer curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-000019','04:05:23 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','34',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:05:23','%','0','100.00','no','0.00',NULL,'202412291605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(88,'chicken  curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000110','04:06:31 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','36',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:06:31','%','0','100.00','no','0.00',NULL,'202412291606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(89,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000110','04:06:31 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','37',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:06:31','%','0','80.00','no','0.00',NULL,'202412291606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(90,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000111','04:06:55 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','38',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:06:55','%','0','80.00','no','0.00',NULL,'202412291606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(91,'chicken  curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000111','04:06:55 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','39',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:06:55','%','0','100.00','no','0.00',NULL,'202412291606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(92,'chicken  curry ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000112','04:07:10 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','40',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:07:10','%','0','100.00','no','0.00',NULL,'202412291607','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(93,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000112','04:07:10 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','180','180','41',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:07:10','%','0','80.00','no','0.00',NULL,'202412291607','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(94,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241229-1-0000113','04:51:48 PM','2024 12 29','ladmin','1','  Dine-in','  Cash','100','100','42',NULL,NULL,NULL,NULL,'29 Dec 2024','2024122916:51:48','%','0','100.00','no','0.00',NULL,'202412291651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(95,'STD V- MEAL','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20250116-1-000011','08:58:41 PM','2025 01 16','ladmin','1','  Dine-in','  Cash','80','80','43',NULL,NULL,NULL,NULL,'16 Jan 2025','2025011620:58:41','%','0','80.00','no','0.00',NULL,'202501162058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(96,'railneer','2.0','14.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000011','05:05:26 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','28','28','46',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:05:26','%','0','28.00','no','0.00',NULL,'202509221705','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(97,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000012','05:06:01 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','47',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:06:01','%','0','14.00','no','0.00',NULL,'202509221706','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(98,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000013','05:06:11 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','48',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:06:11','%','0','14.00','no','0.00',NULL,'202509221706','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(99,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000014','05:06:22 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','49',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:06:22','%','0','14.00','no','0.00',NULL,'202509221706','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(100,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000015','05:06:31 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','50',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:06:31','%','0','14.00','no','0.00',NULL,'202509221706','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(101,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000016','05:06:44 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','51',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:06:44','%','0','14.00','no','0.00',NULL,'202509221706','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(102,'railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000017','05:08:08 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','52',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092217:08:08','%','0','14.00','no','0.00',NULL,'202509221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(103,'Railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000018','06:08:54 PM','2025 09 22','ladmin','1','  Dine-in','  Cash','14','14','53',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092218:08:54','%','0','14.00','no','0.00',NULL,'202509221808','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(104,'Railneer','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'20250922-1-000031','06:27:04 PM','2025 09 22','ladmin','3','  Takeaway','  Cash','14','14','1',NULL,NULL,NULL,NULL,'22 Sep 2025','2025092218:27:04','%','0','14.00','no','0.00',NULL,'202509221827','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(105,'PREMIX COFFEE','1.0','29.92','29.92','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20250926-1-000011','05:10:39 PM','2025 09 26','admin','1','  Dine-in','  Cash','30','30','1',NULL,NULL,NULL,NULL,'26 Sep 2025','2025092617:10:39','%','0','29.92','no','0.00',NULL,'202509261710',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'DRINKS','admin','madmin',NULL,NULL,'',NULL,'28.50',NULL,'','','',NULL,'28.50'),(106,'STD VEG MEAL','1.0','79.80','79.80','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20250926-1-000012','05:11:19 PM','2025 09 26','admin','1','  Dine-in','  Cash','80','80','2',NULL,NULL,NULL,NULL,'26 Sep 2025','2025092617:11:19','%','0','79.80','no','0.00',NULL,'202509261711',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','admin','madmin',NULL,NULL,'',NULL,'76.00',NULL,'','','',NULL,'76.00'),(107,'STANDARD TEA','1','4.99','4.99','Item','null','null','no','2.5','CGST(2.5%)','20251003-1-000011','12:00:20 PM','2025 10 03','madmin','1','Dine-in','UpiQr','0','0','1','null','null','null','null','03Oct25','2025100312:000:20','%','0','','','',' ','2025100312:000:20','','SGST(2.5%)','2.5','','','','','','','DRINKS','madmin','madmin','null','','',' ','4.75',' ',' ',' ',' ',NULL,'4.75'),(108,'COFFEE','1','9.97','9.97','Item','null','null','no','2.5','CGST(2.5%)','20251003-1-000012','12:02:15 PM','2025 10 03','madmin','1','Dine-in','cash','0','0','3','null','null','null','null','03Oct25','2025100312:002:15','%','0','','','',' ','2025100312:002:15','','SGST(2.5%)','2.5','','','','','','','DRINKS','madmin','madmin','null','','',' ','9.50',' ',' ',' ',' ',NULL,'9.50'),(109,'haldiram sweet','2.0','1154.00','2308.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251016-1-000011','07:41:39 PM','2025 10 16','admin','1','  Dine-in','  Cash','2308','2308','20',NULL,NULL,NULL,NULL,'16 Oct 2025','2025101619:41:39','%','0','2308.00','no','0.00',NULL,'202510161941','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'2308.00','','','','',NULL,'1154.00'),(110,'STD EGG MEAL','1.0','89.78','89.78','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251025-1-000011','01:43:49 PM','2025 10 25','admin','1','  Dine-in','  Cash','90','90','22',NULL,NULL,NULL,NULL,'25 Oct 2025','2025102513:43:49','%','0','89.78','no','0.00',NULL,'202510251343','','SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,'85.50',NULL,'','','',NULL,'85.50'),(111,'STD VEG MEAL','1.0','79.80','79.80','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251105-1-000011','02:08:05 PM','2025 11 05','admin','1','  Dine-in','  Cash','130','130','29',NULL,NULL,NULL,NULL,'05 Nov 2025','2025110514:08:05','%','0','79.80','no','0.00',NULL,'202511051408',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,'76.00',NULL,'','','',NULL,'76.00'),(112,'EGG CURRY','1.0','49.88','49.88','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251105-1-000011','02:08:05 PM','2025 11 05','admin','1','  Dine-in','  Cash','130','130','30',NULL,NULL,NULL,NULL,'05 Nov 2025','2025110514:08:05','₹','0','49.88','no','0.0',NULL,'202511051408',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'1',NULL,'47.50',NULL,'','','',NULL,'47.50'),(113,'STD VEG MEAL','1.0','79.80','79.80','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251105-1-000012','02:09:13 PM','2025 11 05','admin','1','  Dine-in','  Cash','130','130','31',NULL,NULL,NULL,NULL,'05 Nov 2025','2025110514:09:13','%','0','79.80','no','0.00',NULL,'202511051409',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'',NULL,'76.00',NULL,'','','',NULL,'76.00'),(114,'EGG CURRY','1.0','49.88','49.88','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251105-1-000012','02:09:13 PM','2025 11 05','admin','1','  Dine-in','  Cash','130','130','32',NULL,NULL,NULL,NULL,'05 Nov 2025','2025110514:09:13','₹','0','49.88','no','0.0',NULL,'202511051409',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MEAL','ladmin','ladmin',NULL,NULL,'1',NULL,'47.50',NULL,'','','',NULL,'47.50'),(115,'haldiram sweet','1.0','1154.00','1154.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251107-1-000011','04:32:44 PM','2025 11 07','admin','1','  Dine-in','  Cash','1154','1154','33',NULL,NULL,NULL,NULL,'07 Nov 2025','2025110716:32:44','%','0','1154.00','no','0.00',NULL,'202511071632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'1154.00','','','','',NULL,'1154.00'),(116,'haldiram sweet','1.0','1154.00','1154.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251107-1-000012','04:33:00 PM','2025 11 07','admin','1','  Dine-in','  Cash','1154','1154','34',NULL,NULL,NULL,NULL,'07 Nov 2025','2025110716:33:00','%','0','1154.00','no','0.00',NULL,'202511071633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'1154.00','','','','',NULL,'1154.00'),(117,'DIP TEA','1.0','9.98','9.98','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251107-1-000013','04:34:17 PM','2025 11 07','admin','1','  Dine-in','  Cash','10','10','36',NULL,NULL,NULL,NULL,'07 Nov 2025','2025110716:34:17','%','0','9.98','no','0.00',NULL,'202511071634',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'DRINKS','ladmin','ladmin',NULL,NULL,'',NULL,'9.50',NULL,'','','',NULL,'9.50'),(118,'MISTI DAHI','1.0','24.94','24.94','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251119-1-000011','09:30:30 AM','2025 11 19','admin','1','  Dine-in','  Cash','25','25','42',NULL,NULL,NULL,NULL,'19 Nov 2025','2025111909:30:30','%','0','24.94','no','0.00',NULL,'202511190930',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'23.75',NULL,'','','',NULL,'23.75'),(119,'MISTI DAHI','4.0','24.94','99.76','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251119-1-000012','09:30:56 AM','2025 11 19','admin','1','  Dine-in','  Cash','100','100','43',NULL,NULL,NULL,NULL,'19 Nov 2025','2025111909:30:56','%','0','99.76','no','0.00',NULL,'202511190930',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'95.00',NULL,'','','',NULL,'23.75'),(120,'RAILNEER','1.0','14.00','14.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251119-1-000013','09:32:54 AM','2025 11 19','admin','1','  Dine-in','  Cash','14','14','44',NULL,NULL,NULL,NULL,'19 Nov 2025','2025111909:32:54','%','0','14.00','no','0.00',NULL,'202511190932','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DRINKS','ladmin','ladmin',NULL,NULL,'',NULL,'14.00','','','','',NULL,'14.00'),(121,'NONVEG BREAKFAST','4.0','49.88','199.52','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251125-1-000011','09:14:52 AM','2025 11 25','admin','1','  Dine-in','  Cash','200','200','45',NULL,NULL,NULL,NULL,'25 Nov 2025','2025112509:14:52','%','0','199.52','no','0.00',NULL,'202511250914',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'190.00',NULL,'','','',NULL,'47.50'),(122,'MISTI DAHI','2.0','24.94','49.88','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251127-1-000011','03:18:53 PM','2025 11 27','admin','1','  Dine-in','  Cash','85','85','48',NULL,NULL,NULL,NULL,'27 Nov 2025','2025112715:18:53','%','0','49.88','no','0.00',NULL,'202511271518',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'47.50',NULL,'','','',NULL,'23.75'),(123,'DAHI','1.0','34.91','34.91','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251127-1-000011','03:18:53 PM','2025 11 27','admin','1','  Dine-in','  Cash','85','85','49',NULL,NULL,NULL,NULL,'27 Nov 2025','2025112715:18:53','%','0','34.91','no','0.00',NULL,'202511271518',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'mis',NULL,'33.25',NULL,'','','',NULL,'33.25'),(124,'MISTI DAHI','1.0','24.94','24.94','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251127-1-000012','03:20:32 PM','2025 11 27','admin','1','  Dine-in','  Cash','25','25','52',NULL,NULL,NULL,NULL,'27 Nov 2025','2025112715:20:32','%','0','24.94','no','0.00',NULL,'202511271520',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'23.75',NULL,'','','',NULL,'23.75'),(125,'chicken pakoura','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251128-1-000011','08:51:41 PM','2025 11 28','admin','1','  Dine-in','  Cash','250','250','55',NULL,NULL,NULL,NULL,'28 Nov 2025','2025112820:51:41','%','0','150.00','no','0.00',NULL,'202511282051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'150.00','','','','',NULL,'50.00'),(126,'egg noodles','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251128-1-000011','08:51:41 PM','2025 11 28','admin','1','  Dine-in','  Cash','250','250','56',NULL,NULL,NULL,NULL,'28 Nov 2025','2025112820:51:41','%','0','100.00','no','0.00',NULL,'202511282051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'50.00'),(127,'egg noodles','6.0','50.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251130-1-000011','11:50:01 AM','2025 11 30','admin','1','  Dine-in','  Cash','510','510','60',NULL,NULL,NULL,NULL,'30 Nov 2025','2025113011:50:01','%','0','300.00','no','0.00',NULL,'202511301150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'300.00','','','','',NULL,'50.00'),(128,'chicken pakoura','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251130-1-000011','11:50:01 AM','2025 11 30','admin','1','  Dine-in','  Cash','510','510','61',NULL,NULL,NULL,NULL,'30 Nov 2025','2025113011:50:01','%','0','50.00','no','0.00',NULL,'202511301150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(129,'VEG NOODLES','4.0','40.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251130-1-000011','11:50:01 AM','2025 11 30','admin','1','  Dine-in','  Cash','510','510','62',NULL,NULL,NULL,NULL,'30 Nov 2025','2025113011:50:01','%','0','160.00','no','0.00',NULL,'202511301150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'40.00'),(130,'NONVEG BREAKFAST','8.0','49.88','399.04','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251203-1-000011','09:06:29 AM','2025 12 03','admin','1','  Dine-in','  Cash','399','399','73',NULL,NULL,NULL,NULL,'03 Dec 2025','2025120309:06:29','%','0','399.04','no','0.00',NULL,'202512030906',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'380.00',NULL,'','','',NULL,'47.50'),(131,'veg pasta','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251203-1-000012','09:07:23 AM','2025 12 03','admin','1','  Dine-in','  Cash','50','50','74',NULL,NULL,NULL,NULL,'03 Dec 2025','2025120309:07:23','%','0','50.00','no','0.00',NULL,'202512030907','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(132,'NONVEG BREAKFAST','1.0','49.88','49.88','Item',NULL,NULL,'no','2.5','CGST(2.5%)','2732-20251208-1-000011','12:44:58 PM','2025 12 08','admin','1','  Dine-in','  Cash','50','50','75',NULL,NULL,NULL,NULL,'08 Dec 2025','2025120812:44:58','%','0','49.88','no','0.00',NULL,'202512081244',NULL,'SGST(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'47.50',NULL,'','','',NULL,'47.50'),(133,'chicken sandwich','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251208-1-000012','08:27:31 PM','2025 12 08','user6','1','  Dine-in','  Cash','50','50','78',NULL,NULL,NULL,NULL,'08 Dec 2025','2025120820:27:31','%','0','50.00','no','0.00',NULL,'202512082027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(134,'egg thali','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'2732-20251211-1-000011','01:58:41 PM','2025 12 11','admin','1','  Dine-in','  Cash','140','140','81',NULL,NULL,NULL,NULL,'11 Dec 2025','2025121113:58:41','%','0','140.00','no','0.00',NULL,'202512111358','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'140.00');
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`) VALUES (1,'20220707-1-000011','10.00','user1','2022 07 07','  Cash','  Dine-in','10.00','0.00','0.00','0.0','1','202207071702',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20231216-1-000011','21.00','admin','2023 12 16','  Cash','  Dine-in','20.00','1.00','0.00','5.0','1','202312160738',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20231216-1-000012','35.00','admin','2023 12 16','  Cash','  Dine-in','35.00','0.00','+ 0.00','0.0','2','202312160741',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20231216-1-000013','720.00','admin','2023 12 16','  Cash','  Dine-in','720.00','0.00','0.00','0.0','3','202312161306',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20231216-1-000014','960.00','admin','2023 12 16','  Cash','  Dine-in','960.00','0.00','0.00','0.0','4','202312161315',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20231216-1-000015','150.00','admin','2023 12 16','  Cash','  Dine-in','150.00','0.00','0.00','0.0','5','202312161316',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20231216-1-000016','150.00','admin','2023 12 16','  Cash','  Dine-in','180.00','0.00','0.00','0.0','6','202312161328',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20231217-1-000011','80.00','admin','2023 12 17','  Cash','  Dine-in','80.00','0.00','0.00','0.0','7','202312171242',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20231217-1-000012','300.00','admin','2023 12 17','  Cash','  Dine-in','360.00','0.00','0.00','0.0','8','202312171343',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20231218-1-000011','20.00','admin','2023 12 18','  Cash','  Dine-in','20.00','0.00','0.00','0.0','9','202312181334',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20231218-1-000012','90.00','admin','2023 12 18','  Cash','  Dine-in','90.00','0.00','0.00','0.0','10','202312181334',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20231218-1-000013','70.00','admin','2023 12 18','  Cash','  Dine-in','70.00','0.00','0.00','0.0','11','202312181335',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20231218-1-000014','180.00','admin','2023 12 18','  Cash','  Dine-in','180.00','0.00','0.00','0.0','12','202312181908',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20231218-1-000015','180.00','admin','2023 12 18','  Cash','  Dine-in','180.00','0.00','0.00','0.0','13','202312181909',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20231219-1-000011','80.00','admin','2023 12 19','  Cash','  Dine-in','80.00','0.00','0.00','0.0','14','202312191254',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20231219-1-000012','1810.00','admin','2023 12 19','  Cash','  Dine-in','1810.00','0.00','0.00','0.0','15','202312191346',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20231219-1-000013','45.00','admin','2023 12 19','  Cash','  Dine-in','45.00','0.00','0.00','0.0','16','202312191351',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20231219-1-000014','160.00','admin','2023 12 19','  Cash','  Dine-in','160.00','0.00','0.00','0.0','17','202312192040',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20231219-1-000015','260.00','admin','2023 12 19','  Cash','  Dine-in','360.00','0.00','0.00','0.0','18','202312192041',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20231219-1-000016','720.00','admin','2023 12 19','  Cash','  Dine-in','720.00','0.00','0.00','0.0','19','202312192135',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20231221-1-000011','2880.00','admin','2023 12 21','  Cash','  Dine-in','2880.00','0.00','0.00','0.0','20','202312211137',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20231221-1-000012','2400.00','admin','2023 12 21','  Cash','  Dine-in','2880.00','0.00','0.00','0.0','21','202312211140',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20231221-1-000013','400.00','admin','2023 12 21','  Cash','  Dine-in','400.00','0.00','0.00','0.0','22','202312211150',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20231221-1-000014','450.00','admin','2023 12 21','  Cash','  Dine-in','450.00','0.00','0.00','0.0','23','202312211152',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20231221-1-000015','150.00','admin','2023 12 21','  Cash','  Dine-in','180.00','0.00','0.00','0.0','24','202312211331',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20231221-1-000016','150.00','admin','2023 12 21','  Cash','  Dine-in','180.00','0.00','0.00','0.0','25','202312211331',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20231221-1-000017','150.00','admin','2023 12 21','  Cash','  Dine-in','180.00','0.00','0.00','0.0','26','202312211332',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20231222-1-000011','70.00','admin','2023 12 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','27','202312222034',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20231222-1-000012','130.00','admin','2023 12 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','28','202312222038',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20231222-1-000013','130.00','admin','2023 12 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','29','202312222038',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20231223-1-000011','90.00','admin','2023 12 23','  Cash','  Dine-in','90.00','0.00','0.00','0.0','30','202312231303',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20231223-1-000012','300.00','admin','2023 12 23','  Cash','  Dine-in','360.00','0.00','0.00','0.0','31','202312231750',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20231223-1-000013','300.00','admin','2023 12 23','  Cash','  Dine-in','360.00','0.00','0.00','0.0','32','202312231750',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20231223-1-000014','150.00','admin','2023 12 23','  Cash','  Dine-in','180.00','0.00','0.00','0.0','33','202312231751',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20231223-1-000015','150.00','admin','2023 12 23','  Cash','  Dine-in','180.00','0.00','0.00','0.0','34','202312231909',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20231226-1-000011','20.00','admin','2023 12 26','  Cash','  Dine-in','20.00','0.00','0.00','0.0','35','202312261454',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20231226-1-000012','25.00','admin','2023 12 26','  Cash','  Dine-in','25.00','0.00','+ 0.00','0.0','36','202312261457',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20231226-1-000013','35.00','admin','2023 12 26','  Cash','  Dine-in','35.00','0.00','+ 0.00','0.0','37','202312261503',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20231226-1-000014','35.00','admin','2023 12 26','  Cash','  Dine-in','35.00','0.00','+ 0.00','0.0','38','202312261503',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20231226-1-000015','35.00','admin','2023 12 26','  Cash','  Dine-in','35.00','0.00','+ 0.00','0.0','39','202312261504',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20231226-1-000016','30.00','admin','2023 12 26','  Cash','  Dine-in','30.00','0.00','+ 0.00','0.0','40','202312261504',NULL,NULL,NULL,NULL,NULL,NULL),(42,'20231226-1-000017','30.00','admin','2023 12 26','  Cash','  Dine-in','30.00','0.00','+ 0.00','0.0','41','202312261505',NULL,NULL,NULL,NULL,NULL,NULL),(43,'20231226-1-000018','35.00','admin','2023 12 26','  Cash','  Dine-in','35.00','0.00','+ 0.00','0.0','42','202312261506',NULL,NULL,NULL,NULL,NULL,NULL),(44,'20241229-1-000011','55.00','ladmin','2024 12 29','  Cash','  Dine-in','55.00','0.00','+ 0.00','0.0','1','202412291544',NULL,NULL,NULL,NULL,NULL,NULL),(45,'20241229-1-000012','20.00','ladmin','2024 12 29','  Cash','  Dine-in','20.00','0.00','+ 0.00','0.0','2','202412291544',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20241229-1-000013','25.00','ladmin','2024 12 29','  Cash','  Dine-in','25.00','0.00','+ 0.00','0.0','3','202412291553',NULL,NULL,NULL,NULL,NULL,NULL),(47,'20241229-1-000014','40.00','ladmin','2024 12 29','  Cash','  Dine-in','40.00','0.00','+ 0.00','0.0','4','202412291558',NULL,NULL,NULL,NULL,NULL,NULL),(48,'20241229-1-000015','130.00','ladmin','2024 12 29','  Cash','  Dine-in','130.00','0.00','+ 0.00','0.0','5','202412291602',NULL,NULL,NULL,NULL,NULL,NULL),(49,'20241229-1-000016','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','6','202412291604',NULL,NULL,NULL,NULL,NULL,NULL),(50,'20241229-1-000017','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','7','202412291605',NULL,NULL,NULL,NULL,NULL,NULL),(51,'20241229-1-000018','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','8','202412291605',NULL,NULL,NULL,NULL,NULL,NULL),(52,'20241229-1-000019','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','9','202412291605',NULL,NULL,NULL,NULL,NULL,NULL),(53,'20241229-1-0000110','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','10','202412291606',NULL,NULL,NULL,NULL,NULL,NULL),(54,'20241229-1-0000111','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','11','202412291606',NULL,NULL,NULL,NULL,NULL,NULL),(55,'20241229-1-0000112','180.00','ladmin','2024 12 29','  Cash','  Dine-in','180.00','0.00','+ 0.00','0.0','12','202412291607',NULL,NULL,NULL,NULL,NULL,NULL),(56,'20241229-1-0000113','100.00','ladmin','2024 12 29','  Cash','  Dine-in','100.00','0.00','+ 0.00','0.0','13','202412291651',NULL,NULL,NULL,NULL,NULL,NULL),(57,'20250116-1-000011','80.00','ladmin','2025 01 16','  Cash','  Dine-in','80.00','0.00','+ 0.00','0.0','14','202501162058',NULL,NULL,NULL,NULL,NULL,NULL),(58,'20250922-1-000011','28.00','ladmin','2025 09 22','  Cash','  Dine-in','28.00','0.00','+ 0.00','0.0','1','202509221705',NULL,NULL,NULL,NULL,NULL,NULL),(59,'20250922-1-000012','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','2','202509221706',NULL,NULL,NULL,NULL,NULL,NULL),(60,'20250922-1-000013','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','3','202509221706',NULL,NULL,NULL,NULL,NULL,NULL),(61,'20250922-1-000014','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','4','202509221706',NULL,NULL,NULL,NULL,NULL,NULL),(62,'20250922-1-000015','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','5','202509221706',NULL,NULL,NULL,NULL,NULL,NULL),(63,'20250922-1-000016','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','6','202509221706',NULL,NULL,NULL,NULL,NULL,NULL),(64,'20250922-1-000017','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','7','202509221708',NULL,NULL,NULL,NULL,NULL,NULL),(65,'20250922-1-000018','14.00','ladmin','2025 09 22','  Cash','  Dine-in','14.00','0.00','+ 0.00','0.0','8','202509221808',NULL,NULL,NULL,NULL,NULL,NULL),(66,'20250922-1-000031','14.00','ladmin','2025 09 22','  Cash','  Takeaway','14.00','0.00','+ 0.00','0.0','9','202509221827',NULL,NULL,NULL,NULL,NULL,NULL),(67,'20251003-1-000011','5.00','madmin','2025 10 03','  UpiQr','  Dine-in','4.990000','0.240000','0.010000','0','10','20251003120000','','','','0','0',NULL),(68,'20251003-1-000012','10.00','madmin','2025 10 03','  cash','  Dine-in','9.970000','0.480000','0.030000','0','11','20251003120002','','','','0','0',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2023 12 16','01:28:34 PM','20231216-1-000016','1','16.67','150.00','30','16 Dec 2023','180.00',NULL,'202312161328',NULL),(2,'2023 12 17','01:43:33 PM','20231217-1-000012','1','16.67','300.00','60','17 Dec 2023','360.00',NULL,'202312171343',NULL),(3,'2023 12 19','08:41:53 PM','20231219-1-000015','1','27.78','260.00','100','19 Dec 2023','360.00',NULL,'202312192041',NULL),(4,'2023 12 21','11:40:17 AM','20231221-1-000012','480','16.67','2400.00','480','21 Dec 2023','2880.00',NULL,'202312211140',NULL),(5,'2023 12 21','01:31:07 PM','20231221-1-000015','hgfg','16.67','150.00','30','21 Dec 2023','180.00',NULL,'202312211331',NULL),(6,'2023 12 21','01:31:34 PM','20231221-1-000016','as','16.67','150.00','30','21 Dec 2023','180.00',NULL,'202312211331',NULL),(7,'2023 12 21','01:32:00 PM','20231221-1-000017','ad','16.67','150.00','30','21 Dec 2023','180.00',NULL,'202312211332',NULL),(8,'2023 12 23','05:50:24 PM','20231223-1-000012','2','16.67','300.00','60','23 Dec 2023','360.00',NULL,'202312231750',NULL),(9,'2023 12 23','05:50:57 PM','20231223-1-000013','2','16.67','300.00','60','23 Dec 2023','360.00',NULL,'202312231750',NULL),(10,'2023 12 23','05:51:25 PM','20231223-1-000014','1','16.67','150.00','30','23 Dec 2023','180.00',NULL,'202312231751',NULL),(11,'2023 12 23','07:09:14 PM','20231223-1-000015','1','16.67','150.00','30','23 Dec 2023','180.00',NULL,'202312231909',NULL),(12,NULL,NULL,'20251003-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(13,NULL,NULL,'20251003-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'CHICKEN CHILLY (BONELESS)',95),(2,'dosa',35),(3,'vada',20);
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,'56','CHICKEN CHILLY (BONELESS)',95,173,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',35,64,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'11','vada',20,36,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'None',95),(2,'Snacks',20),(3,'Tiffin',35);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',56);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',56,100);
