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,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000011','08:49:34 AM','2024 09 11','admin','1','  Dine-in','  Cash','130.00','130.00','3',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091108:49:34','%','0','35.00','no','0.00',NULL,'202409110849','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(2,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000011','08:49:34 AM','2024 09 11','admin','1','  Dine-in','  Cash','130.00','130.00','4',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091108:49:34','%','0','35.00','no','0.00',NULL,'202409110849','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(3,'chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000011','08:49:34 AM','2024 09 11','admin','1','  Dine-in','  Cash','130.00','130.00','5',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091108:49:34','%','0','60.00','no','0.00',NULL,'202409110849','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(4,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000012','04:19:29 PM','2024 09 11','admin','1','  Dine-in','  Cash','110.00','110.00','6',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091116:19:29','%','0','110.00','no','0.00',NULL,'202409111619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(5,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000013','04:21:12 PM','2024 09 11','admin','1','  Dine-in','  Cash','170.00','170.00','7',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091116:21:12','%','0','90.00','no','0.00',NULL,'202409111621','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(6,'veg clear soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000013','04:21:12 PM','2024 09 11','admin','1','  Dine-in','  Cash','170.00','170.00','8',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091116:21:12','%','0','80.00','no','0.00',NULL,'202409111621','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(7,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-1-000014','04:23:16 PM','2024 09 11','admin','1','  Dine-in','  Cash','80.00','80.00','9',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091116:23:16','%','0','80.00','no','0.00',NULL,'202409111623','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(8,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000011','07:51:33 AM','2024 09 12','admin','1','  Dine-in','  Cash','190.00','190.00','10',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:51:33','%','0','100.00','no','0.00',NULL,'202409120751','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(9,'prawn pepper soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000011','07:51:33 AM','2024 09 12','admin','1','  Dine-in','  Cash','190.00','190.00','11',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:51:33','%','0','90.00','no','0.00',NULL,'202409120751','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(10,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000012','07:52:31 AM','2024 09 12','admin','1','  Dine-in','  Cash','300.00','300.00','12',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:52:31','%','0','80.00','no','0.00',NULL,'202409120752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(11,'chicken noodles','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000012','07:52:31 AM','2024 09 12','admin','1','  Dine-in','  Cash','300.00','300.00','13',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:52:31','%','0','120.00','no','0.00',NULL,'202409120752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(12,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000012','07:52:31 AM','2024 09 12','admin','1','  Dine-in','  Cash','300.00','300.00','14',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:52:31','%','0','100.00','no','0.00',NULL,'202409120752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(13,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000013','07:53:32 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','15',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:53:32','%','0','100.00','no','0.00',NULL,'202409120753','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(14,'veg clear soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000013','07:53:32 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','16',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:53:32','%','0','80.00','no','0.00',NULL,'202409120753','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(15,'mixed noodles','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000014','07:54:08 AM','2024 09 12','admin','1','  Dine-in','  Cash','240.00','240.00','17',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:54:08','%','0','140.00','no','0.00',NULL,'202409120754','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'140.00'),(16,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000014','07:54:08 AM','2024 09 12','admin','1','  Dine-in','  Cash','240.00','240.00','18',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091207:54:08','%','0','100.00','no','0.00',NULL,'202409120754','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(17,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000015','08:01:44 AM','2024 09 12','admin','1','  Dine-in','  Cash','90.00','90.00','19',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:01:44','%','0','90.00','no','0.00',NULL,'202409120801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(18,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000016','08:04:09 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','20',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:04:09','%','0','100.00','no','0.00',NULL,'202409120804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(19,'prawn pepper soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000017','08:19:04 AM','2024 09 12','admin','1','  Dine-in','  Cash','90.00','90.00','21',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:19:04','%','0','90.00','no','0.00',NULL,'202409120819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(20,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000018','08:19:41 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','22',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:19:41','%','0','100.00','no','0.00',NULL,'202409120819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(21,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000019','08:25:41 AM','2024 09 12','admin','1','  Dine-in','  Cash','110.00','110.00','23',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:25:41','%','0','110.00','no','0.00',NULL,'202409120825','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(22,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000110','08:25:50 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','24',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:25:50','%','0','100.00','no','0.00',NULL,'202409120825','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(23,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000111','08:26:46 AM','2024 09 12','admin','1','  Dine-in','  Cash','90.00','90.00','25',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:26:46','%','0','90.00','no','0.00',NULL,'202409120826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(24,'cream of tomato soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000112','08:27:16 AM','2024 09 12','admin','1','  Dine-in','  Cash','80.00','80.00','26',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:27:16','%','0','80.00','no','0.00',NULL,'202409120827','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(25,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000113','08:29:03 AM','2024 09 12','admin','1','  Dine-in','  Cash','80.00','80.00','27',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:29:03','%','0','80.00','no','0.00',NULL,'202409120829','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(26,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000114','08:30:03 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','28',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091208:30:03','%','0','100.00','no','0.00',NULL,'202409120830','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(27,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','42',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','90.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(28,'chicken noodle soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','43',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','90.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(29,'prawn pepper soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','44',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','90.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(30,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','45',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','80.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(31,'egg masala','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','46',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','30.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'egg','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(32,'egg roast','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000115','09:33:20 AM','2024 09 12','admin','1','  Dine-in','  Cash','420.00','420.00','47',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:33:20','%','0','40.00','no','0.00',NULL,'202409120933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'egg','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(33,'egg burb','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000116','09:34:18 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','48',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:34:18','%','0','40.00','no','0.00',NULL,'202409120934','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'egg','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(34,'egg masala','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000116','09:34:18 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','49',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:34:18','%','0','30.00','no','0.00',NULL,'202409120934','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'egg','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(35,'egg curry','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000116','09:34:18 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','50',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:34:18','%','0','30.00','no','0.00',NULL,'202409120934','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'egg','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(36,'veg clear soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000116','09:34:18 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','51',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:34:18','%','0','80.00','no','0.00',NULL,'202409120934','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(37,'veg manchow soup','3.0','80.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','52',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','240.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'240.00','','','','',NULL,'80.00'),(38,'chicken noodle soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','53',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','90.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(39,'cream of tomato soup','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','54',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','160.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'80.00'),(40,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','55',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','90.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(41,'prawn pepper soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','56',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','90.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(42,'mixed noodles','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000117','09:45:47 AM','2024 09 12','admin','1','  Dine-in','  Cash','810.00','810.00','57',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:45:47','%','0','140.00','no','0.00',NULL,'202409120945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'140.00'),(43,'veg manchow soup','3.0','80.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','1',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','240.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'240.00','','','','',NULL,'80.00'),(44,'chicken noodle soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','2',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','90.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(45,'prawn pepper soup','2.0','90.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','3',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','180.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'180.00','','','','',NULL,'90.00'),(46,'veg clear soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','4',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','80.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(47,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','5',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','100.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(48,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-000021','09:54:27 AM','2024 09 12','admin','2','  Dine-in','  Cash','790.00','790.00','6',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091209:54:27','%','0','100.00','no','0.00',NULL,'202409120954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(49,'chicken noodle soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000118','10:20:41 AM','2024 09 12','admin','1','  Dine-in','  Cash','270.00','270.00','58',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:20:41','%','0','90.00','no','0.00',NULL,'202409121020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(50,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000118','10:20:41 AM','2024 09 12','admin','1','  Dine-in','  Cash','270.00','270.00','59',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:20:41','%','0','80.00','no','0.00',NULL,'202409121020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(51,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000118','10:20:41 AM','2024 09 12','admin','1','  Dine-in','  Cash','270.00','270.00','60',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:20:41','%','0','100.00','no','0.00',NULL,'202409121020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(52,'chicken noodle soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000119','10:22:37 AM','2024 09 12','admin','1','  Dine-in','  Cash','90.00','90.00','61',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:22:37','%','0','90.00','no','0.00',NULL,'202409121022','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(53,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000120','10:35:45 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','68',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:35:45','%','0','100.00','no','0.00',NULL,'202409121035','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(54,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000120','10:35:45 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','69',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:35:45','%','0','80.00','no','0.00',NULL,'202409121035','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(55,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000121','10:36:37 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','70',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:36:37','%','0','100.00','no','0.00',NULL,'202409121036','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(56,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000122','10:37:54 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','71',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:37:54','%','0','100.00','no','0.00',NULL,'202409121037','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(57,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000123','10:39:52 AM','2024 09 12','admin','1','  Dine-in','  Cash','330.00','330.00','71',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:39:52','%','0','100.00','no','0.00',NULL,'202409121039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(58,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000123','10:39:52 AM','2024 09 12','admin','1','  Dine-in','  Cash','330.00','330.00','72',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:39:52','%','0','110.00','no','0.00',NULL,'202409121039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(59,'chicken kurma','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000123','10:39:52 AM','2024 09 12','admin','1','  Dine-in','  Cash','330.00','330.00','73',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:39:52','%','0','120.00','no','0.00',NULL,'202409121039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(60,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000124','10:46:29 AM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','74',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:46:29','%','0','80.00','no','0.00',NULL,'202409121046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(61,'chicken noodles','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000124','10:46:29 AM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','75',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:46:29','%','0','120.00','no','0.00',NULL,'202409121046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(62,'chicken 65270','2.0','270.00','540.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000125','10:59:11 AM','2024 09 12','admin','1','  Dine-in','  Cash','1140.00','1140.00','76',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:59:11','%','0','540.00','no','0.00',NULL,'202409121059','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken starts','admin','madmin',NULL,NULL,'',NULL,'540.00','','','','',NULL,'270.00'),(63,'chicken 65520','1.0','520.00','520.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000125','10:59:11 AM','2024 09 12','admin','1','  Dine-in','  Cash','1140.00','1140.00','77',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:59:11','%','0','520.00','no','0.00',NULL,'202409121059','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken starts','admin','madmin',NULL,NULL,'',NULL,'520.00','','','','',NULL,'520.00'),(64,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000125','10:59:11 AM','2024 09 12','admin','1','  Dine-in','  Cash','1140.00','1140.00','78',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091210:59:11','%','0','80.00','no','0.00',NULL,'202409121059','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(65,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000126','11:08:19 AM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','79',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:08:19','%','0','100.00','no','0.00',NULL,'202409121108','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(66,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000127','11:09:00 AM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','80',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:09:00','%','0','80.00','no','0.00',NULL,'202409121109','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(67,'chicken noodles','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000127','11:09:00 AM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','81',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:09:00','%','0','120.00','no','0.00',NULL,'202409121109','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(68,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000128','11:09:23 AM','2024 09 12','admin','1','  Dine-in','  Cash','110.00','110.00','82',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:09:23','%','0','110.00','no','0.00',NULL,'202409121109','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(69,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000129','11:10:06 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','83',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:10:06','%','0','100.00','no','0.00',NULL,'202409121110','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(70,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000129','11:10:06 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','84',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:10:06','%','0','80.00','no','0.00',NULL,'202409121110','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(71,'veg mushroom soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000130','11:40:19 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','85',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:40:19','%','0','80.00','no','0.00',NULL,'202409121140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(72,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000130','11:40:19 AM','2024 09 12','admin','1','  Dine-in','  Cash','180.00','180.00','86',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:40:19','%','0','100.00','no','0.00',NULL,'202409121140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(73,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000131','11:46:12 AM','2024 09 12','admin','1','  Dine-in','  Cash','360.00','360.00','87',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:46:12','%','0','80.00','no','0.00',NULL,'202409121146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(74,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000131','11:46:12 AM','2024 09 12','admin','1','  Dine-in','  Cash','360.00','360.00','88',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:46:12','%','0','100.00','no','0.00',NULL,'202409121146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(75,'veg noodles','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000131','11:46:12 AM','2024 09 12','admin','1','  Dine-in','  Cash','360.00','360.00','89',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:46:12','%','0','80.00','no','0.00',NULL,'202409121146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(76,'chicken masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000131','11:46:12 AM','2024 09 12','admin','1','  Dine-in','  Cash','360.00','360.00','90',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:46:12','%','0','100.00','no','0.00',NULL,'202409121146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(77,'prawn sweed corn soup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000132','11:56:27 AM','2024 09 12','admin','1','  Dine-in','  Cash','170.00','170.00','91',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:56:27','%','0','90.00','no','0.00',NULL,'202409121156','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'90.00'),(78,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000132','11:56:27 AM','2024 09 12','admin','1','  Dine-in','  Cash','170.00','170.00','92',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:56:27','%','0','80.00','no','0.00',NULL,'202409121156','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(79,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000133','11:57:19 AM','2024 09 12','admin','1','  Dine-in','  Cash','80.00','80.00','93',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:57:19','%','0','80.00','no','0.00',NULL,'202409121157','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(80,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000134','11:57:42 AM','2024 09 12','admin','1','  Dine-in','  Cash','210.00','210.00','94',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:57:42','%','0','110.00','no','0.00',NULL,'202409121157','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(81,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000134','11:57:42 AM','2024 09 12','admin','1','  Dine-in','  Cash','210.00','210.00','95',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091211:57:42','%','0','100.00','no','0.00',NULL,'202409121157','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(82,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000135','12:00:04 PM','2024 09 12','admin','1','  Dine-in','  Cash','80.00','80.00','96',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:00:04','%','0','80.00','no','0.00',NULL,'202409121200','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(83,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000136','12:05:16 PM','2024 09 12','admin','1','  Dine-in','  Cash','190.00','190.00','98',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:05:16','%','0','80.00','no','0.00',NULL,'202409121205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(84,'chicken varutharachathu','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000136','12:05:16 PM','2024 09 12','admin','1','  Dine-in','  Cash','190.00','190.00','99',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:05:16','%','0','110.00','no','0.00',NULL,'202409121205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(85,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000137','12:16:49 PM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','100',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:16:49','%','0','100.00','no','0.00',NULL,'202409121216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(86,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000137','12:18:23 PM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','100',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:18:23','%','0','100.00','no','0.00',NULL,'202409121218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(87,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000138','12:19:59 PM','2024 09 12','admin','1','  Dine-in','  Cash','100.00','100.00','101',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:19:59','%','0','100.00','no','0.00',NULL,'202409121219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(88,'veg manchow soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000139','12:23:11 PM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','102',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:23:11','%','0','80.00','no','0.00',NULL,'202409121223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(89,'chicken noodles','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000139','12:23:11 PM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','103',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:23:11','%','0','120.00','no','0.00',NULL,'202409121223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'noodles','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(90,'nadan chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000140','12:26:14 PM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','105',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:26:14','%','0','100.00','no','0.00',NULL,'202409121226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(91,'Thalassery chicken curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000140','12:26:14 PM','2024 09 12','admin','1','  Dine-in','  Cash','200.00','200.00','106',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:26:14','%','0','100.00','no','0.00',NULL,'202409121226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(92,'cream of tomato soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000141','12:51:06 PM','2024 09 12','admin','1','  Dine-in','  Cash','80.00','80.00','1',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:51:06','%','0','80.00','no','0.00',NULL,'202409121251','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(93,'cream of tomato soup','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000142','12:53:55 PM','2024 09 12','admin','1','  Dine-in','  Cash','400.00','400.00','2',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:53:55','%','0','80.00','no','0.00',NULL,'202409121253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soup','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(94,'chicken varutharachathu','2.0','110.00','220.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000142','12:53:55 PM','2024 09 12','admin','1','  Dine-in','  Cash','400.00','400.00','3',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:53:55','%','0','220.00','no','0.00',NULL,'202409121253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'220.00','','','','',NULL,'110.00'),(95,'chicken pepper masala','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-1-0000142','12:53:55 PM','2024 09 12','admin','1','  Dine-in','  Cash','400.00','400.00','4',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091212:53:55','%','0','100.00','no','0.00',NULL,'202409121253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'chicken curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.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,'20240911-1-000011','130.00','admin','2024 09 11','  Cash','  Dine-in','130.00','0.00','0.00','0.0','1','202409110849',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240911-1-000012','110.00','admin','2024 09 11','  Cash','  Dine-in','110.00','0.00','0.00','0.0','2','202409111619',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240911-1-000013','170.00','admin','2024 09 11','  Cash','  Dine-in','170.00','0.00','0.00','0.0','3','202409111621',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240911-1-000014','80.00','admin','2024 09 11','  Cash','  Dine-in','80.00','0.00','0.00','0.0','4','202409111623',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240912-1-000011','190.00','admin','2024 09 12','  Cash','  Dine-in','190.00','0.00','0.00','0.0','5','202409120751',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240912-1-000012','300.00','admin','2024 09 12','  Cash','  Dine-in','300.00','0.00','0.00','0.0','6','202409120752',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240912-1-000013','180.00','admin','2024 09 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','7','202409120753',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240912-1-000014','240.00','admin','2024 09 12','  Cash','  Dine-in','240.00','0.00','0.00','0.0','8','202409120754',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240912-1-000015','90.00','admin','2024 09 12','  Cash','  Dine-in','90.00','0.00','0.00','0.0','9','202409120801',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240912-1-000016','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','10','202409120804',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240912-1-000017','90.00','admin','2024 09 12','  Cash','  Dine-in','90.00','0.00','0.00','0.0','11','202409120819',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240912-1-000018','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','12','202409120819',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240912-1-000019','110.00','admin','2024 09 12','  Cash','  Dine-in','110.00','0.00','0.00','0.0','13','202409120825',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240912-1-0000110','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','14','202409120825',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240912-1-0000111','90.00','admin','2024 09 12','  Cash','  Dine-in','90.00','0.00','0.00','0.0','15','202409120826',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240912-1-0000112','80.00','admin','2024 09 12','  Cash','  Dine-in','80.00','0.00','0.00','0.0','16','202409120827',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240912-1-0000113','80.00','admin','2024 09 12','  Cash','  Dine-in','80.00','0.00','0.00','0.0','17','202409120829',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240912-1-0000114','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','18','202409120830',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240912-1-0000115','420.00','admin','2024 09 12','  Cash','  Dine-in','420.00','0.00','0.00','0.0','19','202409120933',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240912-1-0000116','180.00','admin','2024 09 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','20','202409120934',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240912-1-0000117','810.00','admin','2024 09 12','  Cash','  Dine-in','810.00','0.00','0.00','0.0','21','202409120945',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240912-1-000021','790.00','admin','2024 09 12','  Cash','  Dine-in','790.00','0.00','0.00','0.0','22','202409120954',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240912-1-0000118','270.00','admin','2024 09 12','  Cash','  Dine-in','270.00','0.00','0.00','0.0','23','202409121020',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240912-1-0000119','90.00','admin','2024 09 12','  Cash','  Dine-in','90.00','0.00','0.00','0.0','24','202409121022',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240912-1-0000120','180.00','admin','2024 09 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','25','202409121035',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240912-1-0000121','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','26','202409121036',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240912-1-0000122','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','27','202409121037',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240912-1-0000123','330.00','admin','2024 09 12','  Cash','  Dine-in','330.00','0.00','0.00','0.0','28','202409121039',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240912-1-0000124','200.00','admin','2024 09 12','  Cash','  Dine-in','200.00','0.00','0.00','0.0','29','202409121046',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240912-1-0000125','1140.00','admin','2024 09 12','  Cash','  Dine-in','1140.00','0.00','0.00','0.0','30','202409121059',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240912-1-0000126','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','31','202409121108',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240912-1-0000127','200.00','admin','2024 09 12','  Cash','  Dine-in','200.00','0.00','0.00','0.0','32','202409121109',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240912-1-0000128','110.00','admin','2024 09 12','  Cash','  Dine-in','110.00','0.00','0.00','0.0','33','202409121109',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240912-1-0000129','180.00','admin','2024 09 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','34','202409121110',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240912-1-0000130','180.00','admin','2024 09 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','35','202409121140',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20240912-1-0000131','360.00','admin','2024 09 12','  Cash','  Dine-in','360.00','0.00','0.00','0.0','36','202409121146',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20240912-1-0000132','170.00','admin','2024 09 12','  Cash','  Dine-in','170.00','0.00','0.00','0.0','37','202409121156',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20240912-1-0000133','80.00','admin','2024 09 12','  Cash','  Dine-in','80.00','0.00','0.00','0.0','38','202409121157',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20240912-1-0000134','210.00','admin','2024 09 12','  Cash','  Dine-in','210.00','0.00','0.00','0.0','39','202409121157',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20240912-1-0000135','80.00','admin','2024 09 12','  Cash','  Dine-in','80.00','0.00','0.00','0.0','40','202409121200',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20240912-1-0000136','190.00','admin','2024 09 12','  Cash','  Dine-in','190.00','0.00','0.00','0.0','41','202409121205',NULL,NULL,NULL,NULL,NULL,NULL),(42,'20240912-1-0000137','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','42','202409121218',NULL,NULL,NULL,NULL,NULL,NULL),(43,'20240912-1-0000138','100.00','admin','2024 09 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','43','202409121219',NULL,NULL,NULL,NULL,NULL,NULL),(44,'20240912-1-0000139','200.00','admin','2024 09 12','  Cash','  Dine-in','200.00','0.00','0.00','0.0','44','202409121223',NULL,NULL,NULL,NULL,NULL,NULL),(45,'20240912-1-0000140','200.00','admin','2024 09 12','  Cash','  Dine-in','200.00','0.00','0.00','0.0','45','202409121226',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20240912-1-0000141','80.00','admin','2024 09 12','  Cash','  Dine-in','80.00','0.00','0.00','0.0','46','202409121251',NULL,NULL,NULL,NULL,NULL,NULL),(47,'20240912-1-0000142','400.00','admin','2024 09 12','  Cash','  Dine-in','400.00','0.00','0.00','0.0','47','202409121253',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'chicken kabab',60),(2,'dosa',35),(3,'rava dosa',35),(4,'chicken noodles',240),(5,'chicken pepper masala',900),(6,'chicken varutharachathu',220),(7,'cream of tomato soup',240),(8,'egg burb',40),(9,'egg curry',30),(10,'egg masala',60),(11,'egg roast',40),(12,'mixed noodles',280),(13,'nadan chicken curry',200),(14,'prawn pepper soup',540),(15,'prawn sweed corn soup',360),(16,'veg clear soup',240),(17,'veg manchow soup',960);
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,'14','chicken kabab',60,46,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',35,27,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'9','rava dosa',35,27,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'14','chicken noodles',240,5,'2','noodles',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'12','chicken pepper masala',900,17,'9','chicken curry',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','chicken varutharachathu',220,4,'2','chicken curry',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'6','cream of tomato soup',240,5,'3','soup',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'44','egg burb',40,1,'1','egg',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'41','egg curry',30,1,'1','egg',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'43','egg masala',60,1,'2','egg',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'42','egg roast',40,1,'1','egg',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'17','mixed noodles',280,5,'2','noodles',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'9','nadan chicken curry',200,4,'2','chicken curry',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'3','prawn pepper soup',540,10,'6','soup',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2','prawn sweed corn soup',360,7,'4','soup',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'4','veg clear soup',240,5,'3','soup',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'7','veg manchow soup',960,18,'12','soup',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Snacks',60),(2,'Tiffin',70),(3,'chicken curry',1840),(4,'egg',170),(5,'noodles',520),(6,'soup',2790);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',130);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',130,100);
