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,'Omlet','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240716-1-000011','04:20:47 PM','2024 07 16','admin','1','  Dine-in','  Cash','50.00','50.00','1',NULL,NULL,NULL,NULL,'16 Jul 2024','2024071616:20:47','%','0','50.00','no','0.00',NULL,'202407161620','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EGG STARTERS','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(2,'Baby Corn Fried Rice','1.0','169.00','169.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','21',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','169.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin',NULL,NULL,'',NULL,'149.00','','','','',NULL,'169.00'),(3,'Veg Schezwan Noodles','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','22',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','199.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin',NULL,NULL,'',NULL,'149.00','','','','',NULL,'199.00'),(4,'Gobi Manchurian','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','23',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','179.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG STARTERS','admin','madmin',NULL,NULL,'',NULL,'149.00','','','','',NULL,'179.00'),(5,'Paneer Tikka Momo','01','149.00','149.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','25',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','298.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOMOS','admin','madmin',NULL,NULL,'',NULL,'149.00','','','','',NULL,'149.00'),(6,'Veg Fried Momo','1.0','149.00','149.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','26',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','149.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOMOS','admin','madmin',NULL,NULL,'',NULL,'149.00','','','','',NULL,'149.00'),(7,'Garlic Chicken Momo','1.0','219.00','219.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','27',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','219.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MOMOS','admin','madmin',NULL,NULL,'',NULL,'219.00','','','','',NULL,'219.00'),(8,'Chilli Garlic Noodles','2.0','199.00','398.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','28',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','398.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin',NULL,NULL,'',NULL,'398.00','','','','',NULL,'199.00'),(9,'Gobi Noodles','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000011','07:38:09 PM','2024 07 18','admin','1','  Dine-in','  Cash','1661.00','1661.00','32',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071819:38:09','%','0','199.00','no','0.00',NULL,'202407181938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin',NULL,NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(10,'Chicken Biryani','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000061','08:11:32 PM','2024 07 18','admin','6','  Dine-in','  Cash','378.00','378.00','1',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:11:32','%','0','199.00','no','0.00',NULL,'202407182011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin',NULL,NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(11,'Chicken Kebab','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000061','08:11:32 PM','2024 07 18','admin','6','  Dine-in','  Cash','378.00','378.00','2',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:11:32','%','0','179.00','no','0.00',NULL,'202407182011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NON VEG STARTERS','admin','madmin',NULL,NULL,'',NULL,'179.00','','','','',NULL,'179.00'),(12,'Chicken Kebab','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000062','08:34:10 PM','2024 07 18','admin','6','  Dine-in','  Upiqr','378.00','378.00','3',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:34:10','%','0','179.00','no','0.00',NULL,'202407182034','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NON VEG STARTERS','admin','madmin','0',NULL,'',NULL,'179.00','','','','',NULL,'179.00'),(13,'Chicken Biryani','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000062','08:34:10 PM','2024 07 18','admin','6','  Dine-in','  Upiqr','378.00','378.00','4',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:34:10','%','0','199.00','no','0.00',NULL,'202407182034','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin','0',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(14,'Paneer Chilli','1.0','189.00','189.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000021','08:39:03 PM','2024 07 18','admin','2','  Dine-in','  Upiqr','438.00','438.00','2',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:39:03','%','0','189.00','no','0.00',NULL,'202407182039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG STARTERS','admin','madmin','0',NULL,'',NULL,'189.00','','','','',NULL,'189.00'),(15,'Dragon Chicken','1.0','249.00','249.00','Item',NULL,NULL,'no',NULL,NULL,'20240718-1-000021','08:39:03 PM','2024 07 18','admin','2','  Dine-in','  Upiqr','438.00','438.00','3',NULL,NULL,NULL,NULL,'18 Jul 2024','2024071820:39:03','%','0','249.00','no','0.00',NULL,'202407182039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NON VEG STARTERS','admin','madmin','0',NULL,'',NULL,'249.00','','','','',NULL,'249.00'),(16,'Mix Veg Noodles','1.0','169.00','169.00','Item',NULL,NULL,'no',NULL,NULL,'20240719-1-000011','09:15:26 PM','2024 07 19','admin','1','  Dine-in','  Upiqr','348.00','348.00','42',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071921:15:26','%','0','169.00','no','0.00',NULL,'202407192115','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin','0',NULL,'',NULL,'169.00','','','','',NULL,'169.00'),(17,'Chicken Fried Rice','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20240719-1-000011','09:15:26 PM','2024 07 19','admin','1','  Dine-in','  Upiqr','348.00','348.00','43',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071921:15:26','%','0','179.00','no','0.00',NULL,'202407192115','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin','0',NULL,'',NULL,'179.00','','','','',NULL,'179.00'),(18,'Gobi Manchurian','1.0','179.00','179.00','Item',NULL,NULL,'no',NULL,NULL,'20240719-1-000041','10:07:24 PM','2024 07 19','admin','4','  Dine-in','  Upiqr','378.00','378.00','6',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071922:07:24','%','0','179.00','no','0.00',NULL,'202407192207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG STARTERS','admin','madmin','0',NULL,'',NULL,'179.00','','','','',NULL,'179.00'),(19,'Veg Schezwan Noodles','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240719-1-000041','10:07:24 PM','2024 07 19','admin','4','  Dine-in','  Upiqr','378.00','378.00','7',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071922:07:24','%','0','199.00','no','0.00',NULL,'202407192207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin','0',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(20,'Chicken Fried Rice','3.0','179.00','537.00','Item',NULL,NULL,'no',NULL,NULL,'20240721-1-000011','03:11:46 PM','2024 07 21','admin','1','  Dine-in','  Cash','537.00','537.00','45',NULL,NULL,NULL,NULL,'21 Jul 2024','2024072115:11:46','%','0','179.00','no','0.00',NULL,'202407211511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin',NULL,NULL,'',NULL,'537.00','','','','',NULL,'179.00'),(21,'Chicken Biryani','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240721-1-000012','04:21:15 PM','2024 07 21','admin','1','  Dine-in','  Card','199.00','199.00','47',NULL,NULL,NULL,NULL,'21 Jul 2024','2024072116:21:15','%','0','199.00','no','0.00',NULL,'202407211621','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin','0',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(22,'Gobi Noodles','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240721-1-000013','04:33:31 PM','2024 07 21','admin','1','  Dine-in','  Cash','199.00','199.00','48',NULL,NULL,NULL,NULL,'21 Jul 2024','2024072116:33:31','%','0','199.00','no','0.00',NULL,'202407211633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin',NULL,NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(23,'Baby Corn Chilli','1.0','189.00','189.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-1-000041','06:52:13 PM','2024 07 22','admin','4','  Dine-in','  Upiqr','388.00','388.00','9',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072218:52:13','%','0','189.00','no','0.00',NULL,'202407221852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VEG STARTERS','admin','madmin','0',NULL,'',NULL,'189.00','','','','',NULL,'189.00'),(24,'Chicken Biryani','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-1-000041','06:52:13 PM','2024 07 22','admin','4','  Dine-in','  Upiqr','388.00','388.00','10',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072218:52:13','%','0','199.00','no','0.00',NULL,'202407221852','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MAIN COURSE','admin','madmin','0',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(25,'Paneer Noodles','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000041','05:45:21 PM','2024 07 29','admin','4','  Dine-in','  Upiqr','199.00','199.00','12',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072917:45:21','%','0','199.00','no','0.00',NULL,'202407291745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NOODLES','admin','madmin','0',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(26,'Unlimited Meals','1.0','399.00','399.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000051','02:45:03 PM','2024 07 31','admin','5','  Dine-in','  Cash','399.00','399.00','1',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073114:45:03','%','0','399.00','no','0.00',NULL,'202407311445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEALS','admin','madmin',NULL,NULL,'',NULL,'399.00','','','','',NULL,'399.00'),(27,'Unlimited Meals','1.0','399.00','399.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000052','02:45:43 PM','2024 07 31','admin','5','  Dine-in','  Upiqr','399.00','399.00','2',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073114:45:43','%','0','399.00','no','0.00',NULL,'202407311445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEALS','admin','madmin','0',NULL,'',NULL,'399.00','','','','',NULL,'399.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,'20240716-1-000011','50.00','admin','2024 07 16','  Cash','  Dine-in','50.00','0.00','0.00','0.0','1','202407161620',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240718-1-000011','1661.00','admin','2024 07 18','  Cash','  Dine-in','1661.00','0.00','0.00','0.0','2','202407181938',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240718-1-000061','378.00','admin','2024 07 18','  Cash','  Dine-in','378.00','0.00','0.00','0.0','3','202407182011',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240718-1-000062','378.00','admin','2024 07 18','  Upiqr','  Dine-in','378.00','0.00','0.00','0.0','4','202407182034',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240718-1-000021','438.00','admin','2024 07 18','  Upiqr','  Dine-in','438.00','0.00','0.00','0.0','5','202407182039',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240719-1-000011','348.00','admin','2024 07 19','  Upiqr','  Dine-in','348.00','0.00','0.00','0.0','6','202407192115',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240719-1-000041','378.00','admin','2024 07 19','  Upiqr','  Dine-in','378.00','0.00','0.00','0.0','7','202407192207',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240721-1-000011','537.00','admin','2024 07 21','  Cash','  Dine-in','537.00','0.00','0.00','0.0','8','202407211511',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240721-1-000012','199.00','admin','2024 07 21','  Card','  Dine-in','199.00','0.00','0.00','0.0','9','202407211621',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240721-1-000013','199.00','admin','2024 07 21','  Cash','  Dine-in','199.00','0.00','0.00','0.0','10','202407211633',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240722-1-000041','388.00','admin','2024 07 22','  Upiqr','  Dine-in','388.00','0.00','0.00','0.0','11','202407221852',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240729-1-000041','199.00','admin','2024 07 29','  Upiqr','  Dine-in','199.00','0.00','0.00','0.0','12','202407291745',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240731-1-000051','399.00','admin','2024 07 31','  Cash','  Dine-in','399.00','0.00','0.00','0.0','13','202407311445',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240731-1-000052','399.00','admin','2024 07 31','  Upiqr','  Dine-in','399.00','0.00','0.00','0.0','14','202407311445',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Omlet',50),(2,'Chicken Biryani',398),(3,'Chicken Kebab',358),(4,'Chilli Garlic Noodles',398),(5,'Dragon Chicken',249),(6,'Garlic Chicken Momo',219),(7,'Gobi Manchurian',179),(8,'Gobi Noodles',199),(9,'Paneer Chilli',189),(10,'Paneer Tikka Momo',149),(11,'Veg Fried Momo',149),(12,'Veg Schezwan Noodles',199),(13,'Paneer Tikka Momo',149),(14,'Veg Fried Momo',149),(15,'Veg Schezwan Noodles',398);
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','Omlet',50,100,'1','EGG STARTERS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'39','Chicken Biryani',398,14,'2','MAIN COURSE',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'28','Chicken Kebab',358,13,'2','NON VEG STARTERS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'74','Chilli Garlic Noodles',398,14,'2','NOODLES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'34','Dragon Chicken',249,9,'1','NON VEG STARTERS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'66','Garlic Chicken Momo',219,8,'1','MOMOS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'9','Gobi Manchurian',179,6,'1','VEG STARTERS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'81','Gobi Noodles',199,7,'1','NOODLES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'18','Paneer Chilli',189,7,'1','VEG STARTERS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'63','Paneer Tikka Momo',149,5,'1','MOMOS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'61','Veg Fried Momo',149,5,'1','MOMOS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'77','Veg Schezwan Noodles',199,7,'1','NOODLES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'63','Paneer Tikka Momo',149,3,'1','MOMOS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'61','Veg Fried Momo',149,3,'1','MOMOS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'77','Veg Schezwan Noodles',398,9,'2','NOODLES',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'EGG STARTERS',50),(8,'MAIN COURSE',567),(9,'MOMOS',517),(10,'NON VEG STARTERS',607),(11,'NOODLES',796),(12,'VEG STARTERS',368),(18,'MAIN COURSE',567),(19,'MOMOS',517),(20,'NON VEG STARTERS',607),(21,'NOODLES',796),(22,'VEG STARTERS',368),(23,'MAIN COURSE',179),(24,'NOODLES',169),(25,'MAIN COURSE',179),(26,'NOODLES',169),(27,'MAIN COURSE',179),(28,'NOODLES',368),(29,'VEG STARTERS',179),(30,'MAIN COURSE',736),(31,'MAIN COURSE',736),(32,'NOODLES',199),(33,'MAIN COURSE',736),(34,'NOODLES',199),(35,'EGG STARTERS',50),(36,'MAIN COURSE',1482),(37,'MOMOS',517),(38,'NON VEG STARTERS',607),(39,'NOODLES',1363),(40,'VEG STARTERS',547),(41,'MAIN COURSE',199),(42,'VEG STARTERS',189),(43,'MAIN COURSE',199),(44,'VEG STARTERS',189),(45,'MAIN COURSE',199),(46,'VEG STARTERS',189),(47,'MAIN COURSE',935),(48,'NOODLES',199),(49,'VEG STARTERS',189),(50,'NOODLES',199);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',50);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',50,100);
