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`) VALUES (1,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000011','03:19:45 pm','2023 12 18','admin','1','  Dine-in','  Cash','25.00','25.00','5',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:19:45','%','0','25.00','no','0.00',NULL,'202312181519','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(2,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000012','03:21:04 pm','2023 12 18','admin','1','  Dine-in','  Cash','50.00','50.00','6',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:21:04','%','0','40.00','no','0.00',NULL,'202312181521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(3,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000012','03:21:04 pm','2023 12 18','admin','1','  Dine-in','  Cash','50.00','50.00','7',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:21:04','%','0','10.00','no','0.00',NULL,'202312181521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(4,'paneer butter masala','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000013','03:22:42 pm','2023 12 18','admin','1','  Dine-in','  Cash','105.00','105.00','9',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:22:42','%','0','60.00','no','0.00',NULL,'202312181522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(5,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000013','03:22:42 pm','2023 12 18','admin','1','  Dine-in','  Cash','105.00','105.00','10',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:22:42','%','0','10.00','no','0.00',NULL,'202312181522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(6,'coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000013','03:22:42 pm','2023 12 18','admin','1','  Dine-in','  Cash','105.00','105.00','11',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:22:42','%','0','20.00','no','0.00',NULL,'202312181522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(7,'lime juice','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000013','03:22:42 pm','2023 12 18','admin','1','  Dine-in','  Cash','105.00','105.00','12',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121815:22:42','%','0','15.00','no','0.00',NULL,'202312181522','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(8,'Chicken Biryani','1.0','222.00','222.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000014','04:11:56 pm','2023 12 18','admin','1','  Dine-in','  Cash','222.00','222.00','13',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:11:56','%','0','222.00','no','0.00',NULL,'202312181611','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(9,'Fried Piece Biryani','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000015','04:12:03 pm','2023 12 18','admin','1','  Dine-in','  Cash','140.00','140.00','14',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:12:03','%','0','140.00','no','0.00',NULL,'202312181612','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIRYANI ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(10,'Chicken Biryani','1.0','222.00','222.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000016','04:12:48 pm','2023 12 18','admin','1','  Dine-in','  Cash','222.00','222.00','15',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:12:48','%','0','222.00','no','0.00',NULL,'202312181612','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(11,'Chilly Gobi','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000017','04:15:59 pm','2023 12 18','admin','1','  Dine-in','  Cash','130.00','130.00','16',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:15:59','%','0','70.00','no','0.00',NULL,'202312181615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(12,'Noodles','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000017','04:15:59 pm','2023 12 18','admin','1','  Dine-in','  Cash','130.00','130.00','17',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:15:59','%','0','60.00','no','0.00',NULL,'202312181615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(13,'Chicken fried rice','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000018','04:16:51 pm','2023 12 18','admin','1','  Dine-in','  Cash','80.00','80.00','18',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:16:51','%','0','80.00','no','0.00',NULL,'202312181616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(14,'Chilly Gobi','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-000019','04:17:03 pm','2023 12 18','admin','1','  Dine-in','  Cash','70.00','70.00','19',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:17:03','%','0','70.00','no','0.00',NULL,'202312181617','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(15,'Mushroom Momos Steamed(10pcs)','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-0000110','04:18:27 pm','2023 12 18','admin','1','  Dine-in','  Cash','125.00','125.00','20',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:18:27','%','0','80.00','no','0.00',NULL,'202312181618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(16,'Mushroom Momos Steamed(5pcs)','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-0000110','04:18:27 pm','2023 12 18','admin','1','  Dine-in','  Cash','125.00','125.00','21',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121816:18:27','%','0','45.00','no','0.00',NULL,'202312181618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(17,'Dum Biryanu','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-0000111','05:11:33 pm','2023 12 18','admin','1','  Dine-in','  Cash','130.00','130.00','28',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121817:11:33','%','0','130.00','no','0.00',NULL,'202312181711','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BIRYANI ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(18,'Pasta Manchurian','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231218-1-0000112','07:18:14 pm','2023 12 18','admin','1','  Dine-in','  Cash','80.00','80.00','35',NULL,NULL,NULL,NULL,'18 Dec 2023','2023121819:18:14','%','0','80.00','no','0.00',NULL,'202312181918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(19,'190 Veg shegvan Steamed(5pcs)','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000011','05:33:40 pm','2023 12 19','admin','1','  Dine-in','  Cash','45.00','45.00','42',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121917:33:40','%','0','45.00','no','0.00',NULL,'202312191733','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(20,'134 Virgin Mojito(regular)','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20231219-1-000012','05:38:29 pm','2023 12 19','admin','1','  Dine-in','  Cash','39.00','39.00','43',NULL,NULL,NULL,NULL,'19 Dec 2023','2023121917:38:29','%','0','39.00','no','0.00',NULL,'202312191738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(21,'134 Virgin Mojito(regular)','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20231220-1-000011','05:55:19 pm','2023 12 20','ladmin','1','  Dine-in','  Cash','39.00','39.00','47',NULL,NULL,NULL,NULL,'20 Dec 2023','2023122017:55:19','%','0','39.00','no','0.00',NULL,'202312201755','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','',''),(22,'107 Paneer Momos Fried(5pcs)','1.0','55.00','55.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000011','12:32:54 pm','2023 12 21','admin','1','  Dine-in','  Cash','55.00','55.00','51',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122112:32:54','%','0','55.00','no','0.00',NULL,'202312211232','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(23,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000012','12:53:17 pm','2023 12 21','admin','1','  Dine-in','  Cash','0.00','0.00','52',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122112:53:17','%','0','0.00','no','0.00',NULL,'202312211253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(24,'111 Shegwan Chicken Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000013','01:43:47 pm','2023 12 21','admin','1','  Dine-in','  Cash','0.00','0.00','53',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122113:43:47','%','0','0.00','no','0.00',NULL,'202312211343','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NON VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(25,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231221-1-000014','02:16:09 pm','2023 12 21','admin','1','  Dine-in','  Cash','0.00','0.00','54',NULL,NULL,NULL,NULL,'21 Dec 2023','2023122114:16:09','%','0','0.00','no','0.00',NULL,'202312211416','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(26,'134 Virgin Mojito(regular)','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000011','06:39:22 pm','2023 12 22','admin','1','  Dine-in','  Cash','39.00','39.00','56',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122218:39:22','%','0','39.00','no','0.00',NULL,'202312221839','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(27,'108 Mushroom Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000012','06:40:16 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','57',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122218:40:16','%','0','0.00','no','0.00',NULL,'202312221840','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(28,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000013','08:52:26 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','64',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122220:52:26','%','0','0.00','no','0.00',NULL,'202312222052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(29,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000014','08:58:00 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','65',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122220:58:00','%','0','0.00','no','0.00',NULL,'202312222058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(30,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000015','09:00:02 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','66',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:00:02','%','0','0.00','no','0.00',NULL,'202312222100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(31,'1 Chicken Biryani','1.0','222.00','222.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000016','09:01:08 pm','2023 12 22','admin','1','  Dine-in','  Cash','222.00','222.00','67',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:08','%','0','222.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(32,'1 Chicken Biryani','1.0','222.00','222.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','68',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','222.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(33,'3 Bucket Fried Chicken','1.0','722.00','722.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','69',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','722.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(34,'5 Bucket Biryani','1.0','799.00','799.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','70',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','799.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(35,'107 Paneer Momos Steamed(10pcs)','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','71',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','80.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(36,'102 Chicken Pop corn(Large)','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','72',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','140.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED CHICKEN ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(37,'109 Veg Momos Steamed(10pcs)','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000017','09:01:58 pm','2023 12 22','admin','1','  Dine-in','  Cash','2033.00','2033.00','73',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:01:58','%','0','70.00','no','0.00',NULL,'202312222101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(38,'102 Chicken Pop corn(Large)','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000018','09:03:16 pm','2023 12 22','admin','1','  Dine-in','  Cash','140.00','140.00','74',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:03:16','%','0','140.00','no','0.00',NULL,'202312222103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED CHICKEN ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(39,'107 Paneer Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000019','09:13:40 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','75',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:13:40','%','0','0.00','no','0.00',NULL,'202312222113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(40,'109 Veg Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000019','09:13:40 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','76',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:13:40','%','0','0.00','no','0.00',NULL,'202312222113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(41,'108 Mushroom Momos Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000019','09:13:40 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','77',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:13:40','%','0','0.00','no','0.00',NULL,'202312222113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(42,'190 Veg Shegvan Fried(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000019','09:13:40 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','78',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:13:40','%','0','0.00','no','0.00',NULL,'202312222113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(43,'190 Veg shegvan Steamed(regular)','1.0','0.00','0.00','Item',NULL,NULL,'no',NULL,NULL,'20231222-1-000019','09:13:40 pm','2023 12 22','admin','1','  Dine-in','  Cash','0.00','0.00','79',NULL,NULL,NULL,NULL,'22 Dec 2023','2023122221:13:40','%','0','0.00','no','0.00',NULL,'202312222113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG MOMOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(44,'1 Chicken Biryani','2.0','222.00','444.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-1-000011','10:18:55 pm','2024 01 09','admin','1','  Dine-in','  Cash','644.00','644.00','80',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010922:18:55','%','0','444.00','no','0.00',NULL,'202401092218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COMBO OFFERS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(45,'124 Egg fried Rice','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-1-000011','10:18:55 pm','2024 01 09','admin','1','  Dine-in','  Cash','644.00','644.00','81',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010922:18:55','%','0','60.00','no','0.00',NULL,'202401092218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(46,'128 Chilly Gobi','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-1-000011','10:18:55 pm','2024 01 09','admin','1','  Dine-in','  Cash','644.00','644.00','82',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010922:18:55','%','0','140.00','no','0.00',NULL,'202401092218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHINESE ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(47,'102 Chicken Pop corn(regular)','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240401-1-000011','07:57:00 pm','2024 04 01','admin','1','  Dine-in','  Cash','70.00','70.00','89',NULL,NULL,NULL,NULL,'01 Apr 2024','2024040119:57:00','%','0','70.00','no','0.00',NULL,'202404011957','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED CHICKEN ITEMS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(48,'131 Fountain(regular)','1.0','69.00','69.00','Item',NULL,NULL,'no',NULL,NULL,'20240401-1-000012','07:58:27 pm','2024 04 01','admin','1','  Dine-in','  Cash','405.00','405.00','90',NULL,NULL,NULL,NULL,'01 Apr 2024','2024040119:58:27','%','0','69.00','no','0.00',NULL,'202404011958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(49,'132 3 Layers kiwi','3.0','99.00','297.00','Item',NULL,NULL,'no',NULL,NULL,'20240401-1-000012','07:58:27 pm','2024 04 01','admin','1','  Dine-in','  Cash','405.00','405.00','91',NULL,NULL,NULL,NULL,'01 Apr 2024','2024040119:58:27','%','0','297.00','no','0.00',NULL,'202404011958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(50,'133 Mint Fresh(regular)','1.0','39.00','39.00','Item',NULL,NULL,'no',NULL,NULL,'20240401-1-000012','07:58:27 pm','2024 04 01','admin','1','  Dine-in','  Cash','405.00','405.00','92',NULL,NULL,NULL,NULL,'01 Apr 2024','2024040119:58:27','%','0','39.00','no','0.00',NULL,'202404011958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOJITOS','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`) VALUES (1,'20231218-1-000011','25.00','admin','2023 12 18','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202312181519',NULL,NULL,NULL,NULL,NULL),(2,'20231218-1-000012','50.00','admin','2023 12 18','  Cash','  Dine-in','50.00','0.00','0.00','0.0','2','202312181521',NULL,NULL,NULL,NULL,NULL),(3,'20231218-1-000013','105.00','admin','2023 12 18','  Cash','  Dine-in','105.00','0.00','0.00','0.0','3','202312181522',NULL,NULL,NULL,NULL,NULL),(4,'20231218-1-000014','222.00','admin','2023 12 18','  Cash','  Dine-in','222.00','0.00','0.00','0.0','4','202312181611',NULL,NULL,NULL,NULL,NULL),(5,'20231218-1-000015','140.00','admin','2023 12 18','  Cash','  Dine-in','140.00','0.00','0.00','0.0','5','202312181612',NULL,NULL,NULL,NULL,NULL),(6,'20231218-1-000016','222.00','admin','2023 12 18','  Cash','  Dine-in','222.00','0.00','0.00','0.0','6','202312181612',NULL,NULL,NULL,NULL,NULL),(7,'20231218-1-000017','130.00','admin','2023 12 18','  Cash','  Dine-in','130.00','0.00','0.00','0.0','7','202312181615',NULL,NULL,NULL,NULL,NULL),(8,'20231218-1-000018','80.00','admin','2023 12 18','  Cash','  Dine-in','80.00','0.00','0.00','0.0','8','202312181616',NULL,NULL,NULL,NULL,NULL),(9,'20231218-1-000019','70.00','admin','2023 12 18','  Cash','  Dine-in','70.00','0.00','0.00','0.0','9','202312181617',NULL,NULL,NULL,NULL,NULL),(10,'20231218-1-0000110','125.00','admin','2023 12 18','  Cash','  Dine-in','125.00','0.00','0.00','0.0','10','202312181618',NULL,NULL,NULL,NULL,NULL),(11,'20231218-1-0000111','130.00','admin','2023 12 18','  Cash','  Dine-in','130.00','0.00','0.00','0.0','11','202312181711',NULL,NULL,NULL,NULL,NULL),(12,'20231218-1-0000112','80.00','admin','2023 12 18','  Cash','  Dine-in','80.00','0.00','0.00','0.0','12','202312181918',NULL,NULL,NULL,NULL,NULL),(13,'20231219-1-000011','45.00','admin','2023 12 19','  Cash','  Dine-in','45.00','0.00','0.00','0.0','13','202312191733',NULL,NULL,NULL,NULL,NULL),(14,'20231219-1-000012','39.00','admin','2023 12 19','  Cash','  Dine-in','39.00','0.00','0.00','0.0','14','202312191738',NULL,NULL,NULL,NULL,NULL),(15,'20231220-1-000011','39.00','ladmin','2023 12 20','  Cash','  Dine-in','39.00','0.00','0.00','0.0','15','202312201755',NULL,NULL,NULL,NULL,NULL),(16,'20231221-1-000011','55.00','admin','2023 12 21','  Cash','  Dine-in','55.00','0.00','0.00','0.0','16','202312211232',NULL,NULL,NULL,NULL,NULL),(17,'20231221-1-000012','0.00','admin','2023 12 21','  Cash','  Dine-in','0.00','0.00','0.00','0.0','17','202312211253',NULL,NULL,NULL,NULL,NULL),(18,'20231221-1-000013','0.00','admin','2023 12 21','  Cash','  Dine-in','0.00','0.00','0.00','0.0','18','202312211343',NULL,NULL,NULL,NULL,NULL),(19,'20231221-1-000014','0.00','admin','2023 12 21','  Cash','  Dine-in','0.00','0.00','0.00','0.0','19','202312211416',NULL,NULL,NULL,NULL,NULL),(20,'20231222-1-000011','39.00','admin','2023 12 22','  Cash','  Dine-in','39.00','0.00','0.00','0.0','20','202312221839',NULL,NULL,NULL,NULL,NULL),(21,'20231222-1-000012','0.00','admin','2023 12 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','21','202312221840',NULL,NULL,NULL,NULL,NULL),(22,'20231222-1-000013','0.00','admin','2023 12 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','22','202312222052',NULL,NULL,NULL,NULL,NULL),(23,'20231222-1-000014','0.00','admin','2023 12 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','23','202312222058',NULL,NULL,NULL,NULL,NULL),(24,'20231222-1-000015','0.00','admin','2023 12 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','24','202312222100',NULL,NULL,NULL,NULL,NULL),(25,'20231222-1-000016','222.00','admin','2023 12 22','  Cash','  Dine-in','222.00','0.00','0.00','0.0','25','202312222101',NULL,NULL,NULL,NULL,NULL),(26,'20231222-1-000017','2033.00','admin','2023 12 22','  Cash','  Dine-in','2033.00','0.00','0.00','0.0','26','202312222101',NULL,NULL,NULL,NULL,NULL),(27,'20231222-1-000018','140.00','admin','2023 12 22','  Cash','  Dine-in','140.00','0.00','0.00','0.0','27','202312222103',NULL,NULL,NULL,NULL,NULL),(28,'20231222-1-000019','0.00','admin','2023 12 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','28','202312222113',NULL,NULL,NULL,NULL,NULL),(29,'20240109-1-000011','644.00','admin','2024 01 09','  Cash','  Dine-in','644.00','0.00','0.00','0.0','29','202401092218',NULL,NULL,NULL,NULL,NULL),(30,'20240401-1-000011','70.00','admin','2024 04 01','  Cash','  Dine-in','70.00','0.00','0.00','0.0','1','202404011957',NULL,NULL,NULL,NULL,NULL),(31,'20240401-1-000012','405.00','admin','2024 04 01','  Cash','  Dine-in','405.00','0.00','0.00','0.0','2','202404011958',NULL,NULL,NULL,NULL,NULL),(32,'20240531-1-000011','670.00','admin','2024 05 31','  Cash','  Dine-in','670.00','0.00','0.00','0.0','3','202405311418',NULL,NULL,NULL,NULL,NULL),(33,'20240531-1-000012','280.00','admin','2024 05 31','  Cash','  Dine-in','280.00','0.00','0.00','0.0','4','202405311420',NULL,NULL,NULL,NULL,NULL),(34,'20240531-1-000013','260.00','admin','2024 05 31','  Cash','  Dine-in','260.00','0.00','0.00','0.0','5','202405311423',NULL,NULL,NULL,NULL,NULL),(35,'20240531-1-000014','130.00','admin','2024 05 31','  Cash','  Dine-in','130.00','0.00','0.00','0.0','6','202405311431',NULL,NULL,NULL,NULL,NULL),(36,'20240531-1-000015','580.00','admin','2024 05 31','  Cash','  Dine-in','580.00','0.00','0.00','0.0','7','202405311440',NULL,NULL,NULL,NULL,NULL),(37,'20240531-1-000016','280.00','admin','2024 05 31','  Cash','  Dine-in','280.00','0.00','0.00','0.0','8','202405311443',NULL,NULL,NULL,NULL,NULL),(38,'20240531-1-000017','700.00','admin','2024 05 31','  Cash','  Dine-in','700.00','0.00','0.00','0.0','9','202405311444',NULL,NULL,NULL,NULL,NULL),(39,'20240531-1-000018','390.00','admin','2024 05 31','  Cash','  Dine-in','390.00','0.00','0.00','0.0','10','202405311445',NULL,NULL,NULL,NULL,NULL),(40,'20240531-1-000019','780.00','admin','2024 05 31','  Cash','  Dine-in','780.00','0.00','0.00','0.0','11','202405311450',NULL,NULL,NULL,NULL,NULL),(41,'20240602-1-000011','514.00','admin','2024 06 02','  Cash','  Dine-in','514.00','0.00','0.00','0.0','12','202406021211',NULL,NULL,NULL,NULL,NULL),(42,'20240712-1-000011','722.00','admin','2024 07 12','  Cash','  Dine-in','722.00','0.00','0.00','0.0','13','202407121916',NULL,NULL,NULL,NULL,NULL),(43,'20240712-1-000012','342.00','admin','2024 07 12','  Cash','  Dine-in','342.00','0.00','0.00','0.0','14','202407121919',NULL,NULL,NULL,NULL,NULL),(44,'20240712-1-000013','70.00','admin','2024 07 12','  Cash','  Dine-in','70.00','0.00','0.00','0.0','15','202407121919',NULL,NULL,NULL,NULL,NULL),(45,'20240712-1-000014','45.00','admin','2024 07 12','  Cash','  Dine-in','45.00','0.00','0.00','0.0','16','202407121919',NULL,NULL,NULL,NULL,NULL),(46,'20240802-1-000011','1899.00','admin','2024 08 02','  Cash','  Dine-in','1899.00','0.00','0.00','0.0','17','202408021840',NULL,NULL,NULL,NULL,NULL),(47,'20250122-1-000011','0.00','admin','2025 01 22','  Cash','  Dine-in','0.00','0.00','0.00','0.0','1','202501221912',NULL,NULL,NULL,NULL,NULL),(48,'20250122-1-000012','55.00','admin','2025 01 22','  Cash','  Dine-in','55.00','0.00','0.00','0.0','2','202501221931',NULL,NULL,NULL,NULL,NULL),(49,'20250122-1-000013','190.00','admin','2025 01 22','  Cash','  Dine-in','190.00','0.00','0.00','0.0','3','202501221935',NULL,NULL,NULL,NULL,NULL),(50,'20250122-1-000014','100.00','admin','2025 01 22','  Cash','  Dine-in','100.00','0.00','0.00','0.0','4','202501221936',NULL,NULL,NULL,NULL,NULL),(51,'20250122-1-000015','100.00','admin','2025 01 22','  Cash','  Dine-in','100.00','0.00','0.00','0.0','5','202501221938',NULL,NULL,NULL,NULL,NULL),(52,'20250122-1-000016','70.00','admin','2025 01 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','6','202501221942',NULL,NULL,NULL,NULL,NULL),(53,'20250122-1-000017','390.00','admin','2025 01 22','  Cash','  Dine-in','390.00','0.00','0.00','0.0','7','202501221943',NULL,NULL,NULL,NULL,NULL),(54,'20250122-1-000041','120.00','admin','2025 01 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','8','202501221945',NULL,NULL,NULL,NULL,NULL),(55,'20250122-1-000042','280.00','admin','2025 01 22','  Cash','  Dine-in','280.00','0.00','0.00','0.0','9','202501221947',NULL,NULL,NULL,NULL,NULL),(56,'20250122-1-000043','180.00','admin','2025 01 22','  Cash','  Dine-in','180.00','0.00','0.00','0.0','10','202501221948',NULL,NULL,NULL,NULL,NULL),(57,'20250203-1-000011','7997193728.00','admin','2025 02 03','  Cash','  Dine-in','7997193728.00','0.00','0.00','0.0','11','202502031703',NULL,NULL,NULL,NULL,NULL),(58,'20250203-1-000012','89.10','admin','2025 02 03','  Cash','  Dine-in','89.10','0.00','0.00','0.0','12','202502031743',NULL,NULL,NULL,NULL,NULL),(59,'20250311-1-000011','60.00','admin','2025 03 11','  Cash','  Dine-in','60.00','0.00','0.00','0.0','13','202503110814',NULL,NULL,NULL,NULL,NULL),(60,'20250311-1-000012','70.00','admin','2025 03 11','  Cash','  Dine-in','70.00','0.00','0.00','0.0','14','202503111128',NULL,NULL,NULL,NULL,NULL),(61,'20250311-1-000013','159.00','admin','2025 03 11','  Cash','  Dine-in','159.00','0.00','0.00','0.0','15','202503111129',NULL,NULL,NULL,NULL,NULL),(62,'20250311-1-000014','120.00','admin','2025 03 11','  Cash','  Dine-in','120.00','0.00','0.00','0.0','16','202503111204',NULL,NULL,NULL,NULL,NULL),(63,'20250311-1-000015','50.00','admin','2025 03 11','  Cash','  Dine-in','50.00','0.00','0.00','0.0','17','202503111537',NULL,NULL,NULL,NULL,NULL),(64,'20250312-1-000011','79.00','admin','2025 03 12','  Cash','  Dine-in','79.00','0.00','0.00','0.0','18','202503121045',NULL,NULL,NULL,NULL,NULL),(65,'20250312-1-000012','79.00','admin','2025 03 12','  Cash','  Dine-in','79.00','0.00','0.00','0.0','19','202503121045',NULL,NULL,NULL,NULL,NULL),(66,'20250312-1-000013','316.00','admin','2025 03 12','  Cash','  Dine-in','316.00','0.00','0.00','0.0','20','202503122215',NULL,NULL,NULL,NULL,NULL),(67,'20250312-1-000014','79.00','admin','2025 03 12','  Cash','  Dine-in','79.00','0.00','0.00','0.0','21','202503122215',NULL,NULL,NULL,NULL,NULL),(68,'20250312-1-000015','79.00','admin','2025 03 12','  Cash','  Dine-in','79.00','0.00','0.00','0.0','22','202503122216',NULL,NULL,NULL,NULL,NULL),(69,'20250312-1-000016','228.00','admin','2025 03 12','  Cash','  Dine-in','228.00','0.00','0.00','0.0','23','202503122219',NULL,NULL,NULL,NULL,NULL),(70,'20250313-1-000011','79.00','admin','2025 03 13','  Cash','  Dine-in','79.00','0.00','0.00','0.0','24','202503131702',NULL,NULL,NULL,NULL,NULL),(71,'20250324-1-000011','79.00','admin','2025 03 24','  Cash','  Dine-in','79.00','0.00','0.00','0.0','25','202503240039',NULL,NULL,NULL,NULL,NULL),(72,'20250418-1-000011','160.00','admin','2025 04 18','  Cash','  Dine-in','160.00','0.00','0.00','0.0','26','202504181143',NULL,NULL,NULL,NULL,NULL),(73,'20250418-1-000012','160.00','admin','2025 04 18','  Cash','  Dine-in','160.00','0.00','0.00','0.0','27','202504181147',NULL,NULL,NULL,NULL,NULL),(74,'20250418-1-000013','4000.00','admin','2025 04 18','  Cash','  Dine-in','4000.00','0.00','0.00','0.0','28','202504181151',NULL,NULL,NULL,NULL,NULL),(75,'20250418-1-000014','4000.00','admin','2025 04 18','  Cash','  Dine-in','4000.00','0.00','0.00','0.0','29','202504181152',NULL,NULL,NULL,NULL,NULL),(76,'20250429-1-000011','160.00','admin','2025 04 29','  Cash','  Dine-in','160.00','0.00','0.00','0.0','30','202504291710',NULL,NULL,NULL,NULL,NULL),(77,'20250429-1-000012','460.00','admin','2025 04 29','  Cash','  Dine-in','460.00','0.00','0.00','0.0','31','202504291713',NULL,NULL,NULL,NULL,NULL),(78,'20250429-1-000013','310.00','user1','2025 04 29','  Cash','  Dine-in','310.00','0.00','0.00','0.0','32','202504291715',NULL,NULL,NULL,NULL,NULL),(79,'20250429-1-000014','150.00','admin','2025 04 29','  Cash','  Dine-in','150.00','0.00','0.00','0.0','33','202504291717',NULL,NULL,NULL,NULL,NULL),(80,'20250429-1-000015','150.00','admin','2025 04 29','  Cash','  Dine-in','150.00','0.00','0.00','0.0','34','202504291719',NULL,NULL,NULL,NULL,NULL),(81,'20250429-1-000016','3750.00','admin','2025 04 29','  Cash','  Dine-in','3750.00','0.00','0.00','0.0','35','202504291721',NULL,NULL,NULL,NULL,NULL),(82,'20250714-1-000011','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','1','202507141307',NULL,NULL,NULL,NULL,NULL),(83,'20250714-1-000012','55.00','admin','2025 07 14','  Cash','  Dine-in','55.00','0.00','0.00','0.0','2','202507141311',NULL,NULL,NULL,NULL,NULL),(84,'20250714-1-000013','70.00','admin','2025 07 14','  Cash','  Dine-in','70.00','0.00','0.00','0.0','3','202507141317',NULL,NULL,NULL,NULL,NULL),(85,'20250714-1-000014','35.00','admin','2025 07 14','  Cash','  Dine-in','35.00','0.00','0.00','0.0','4','202507141317',NULL,NULL,NULL,NULL,NULL),(86,'20250714-1-000015','15994387456.00','admin','2025 07 14','  Cash','  Dine-in','15994387456.00','0.00','0.00','0.0','5','202507141320',NULL,NULL,NULL,NULL,NULL),(87,'20250714-1-000016','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','6','202507141322',NULL,NULL,NULL,NULL,NULL),(88,'20250714-1-000017','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','7','202507141324',NULL,NULL,NULL,NULL,NULL),(89,'20250714-1-000018','158.00','user1','2025 07 14','  Cash','  Dine-in','158.00','0.00','0.00','0.0','8','202507141326',NULL,NULL,NULL,NULL,NULL),(90,'20250714-1-000019','79.00','user2','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','9','202507141327',NULL,NULL,NULL,NULL,NULL),(91,'20250714-1-0000110','10.00','admin','2025 07 14','  Cash','  Dine-in','10.00','0.00','0.00','0.0','10','202507141329',NULL,NULL,NULL,NULL,NULL),(92,'20250714-1-0000111','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','11','202507141341',NULL,NULL,NULL,NULL,NULL),(93,'20250714-1-0000112','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','12','202507141343',NULL,NULL,NULL,NULL,NULL),(94,'20250714-1-0000113','79.00','admin','2025 07 14','  Cash','  Takeaway','79.00','0.00','0.00','0.0','13','202507141344',NULL,NULL,NULL,NULL,NULL),(95,'20250714-1-0000114','79.00','admin','2025 07 14','  Cash','  Dine-in','79.00','0.00','0.00','0.0','14','202507141419',NULL,NULL,NULL,NULL,NULL),(96,'20250714-1-0000115','89.00','admin','2025 07 14','  Cash','  Dine-in','89.00','0.00','0.00','0.0','15','202507142000',NULL,NULL,NULL,NULL,NULL),(97,'20250714-1-0000116','70.00','admin','2025 07 14','  Cash','  Dine-in','70.00','0.00','0.00','0.0','16','202507142017',NULL,NULL,NULL,NULL,NULL),(98,'20250725-1-000011','178.00','admin','2025 07 25','  Cash','  Dine-in','178.00','0.00','0.00','0.0','17','202507251520',NULL,NULL,NULL,NULL,NULL),(99,'20250731-1-000011','590.00','admin','2025 07 31','  Cash','  Dine-in','590.00','0.00','0.00','0.0','18','202507311311',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Chicken Biryani',444),(2,'Chicken fried rice',80),(3,'Chilly Gobi',140),(4,'Fried Piece Biryani',140),(5,'Mushroom Momos Steamed(10pcs)',80),(6,'Mushroom Momos Steamed(5pcs)',45),(7,'Noodles',60),(8,'coffee',20),(9,'idly',25),(10,'lime juice',15),(11,'masal dosa',40),(12,'paneer butter masala',60),(13,'soft drinks',20),(14,'paneer butter masala',60),(15,'soft drinks',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,'1','Chicken Biryani',444,38,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'41','Chicken fried rice',80,7,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'46','Chilly Gobi',140,12,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'8','Fried Piece Biryani',140,12,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'8','Mushroom Momos Steamed(10pcs)',80,7,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','Mushroom Momos Steamed(5pcs)',45,4,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'47','Noodles',60,5,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'47','coffee',20,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'47','idly',25,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'47','lime juice',15,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'47','masal dosa',40,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'47','paneer butter masala',60,5,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'47','soft drinks',20,2,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'49','paneer butter masala',60,4,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'49','soft drinks',20,1,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'BIRYANI ITEMS',140),(2,'CHINESE ITEMS',280),(3,'COMBO OFFERS',444),(4,'Drinks',55),(5,'Main course',60),(6,'Tiffin',65),(7,'VEG MOMOS',125),(8,'BIRYANI ITEMS',140),(9,'CHINESE ITEMS',280),(10,'COMBO OFFERS',444),(11,'Drinks',55),(12,'Main course',60),(13,'Tiffin',65),(14,'VEG MOMOS',125),(15,'BIRYANI ITEMS',270),(16,'CHINESE ITEMS',360),(17,'COMBO OFFERS',444),(18,'Drinks',55),(19,'Main course',60),(20,'Tiffin',65),(21,'VEG MOMOS',125),(22,'BIRYANI ITEMS',270),(23,'CHINESE ITEMS',360),(24,'COMBO OFFERS',444),(25,'Drinks',55),(26,'Main course',60),(27,'Tiffin',65),(28,'VEG MOMOS',125),(31,'KADAPA SPL BIRYANI',790),(32,'MEALS',70);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',1169);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',1169,100);
