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,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000011','12:51:44 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','3',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120912:51:44','%','0','50.00','no','0.00',NULL,'202212091251','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'White Hakka Noodles(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000012','05:35:08 pm','2022 12 09','admin','1','  Takeaway','  Cash','160.00','160.00','4',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:35:08','%','0','30.00','no','0.00',NULL,'202212091735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'Veg Duplex Pizza(Regular)','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000012','05:35:08 pm','2022 12 09','admin','1','  Takeaway','  Cash','160.00','160.00','5',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:35:08','%','0','130.00','no','0.00',NULL,'202212091735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Extra Cheese Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'Sweet Corn Pizza (Regular)','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000013','05:35:31 pm','2022 12 09','admin','1','  Takeaway','  Cash','60.00','60.00','6',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:35:31','%','0','60.00','no','0.00',NULL,'202212091735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'Tomato Pizza (Regular)','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000014','05:35:44 pm','2022 12 09','admin','1','  Takeaway','  Cash','100.00','100.00','7',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:35:44','%','0','100.00','no','0.00',NULL,'202212091735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'Paneer Sandwich ','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000015','05:36:08 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','8',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:36:08','%','0','150.00','no','0.00',NULL,'202212091736','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sandwichs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'Simple Zingi Parcel','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000016','05:36:16 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','9',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:36:16','%','0','30.00','no','0.00',NULL,'202212091736','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'Simple Veg Burger','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000017','05:36:47 pm','2022 12 09','admin','1','  Takeaway','  Cash','130.00','130.00','10',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:36:47','%','0','60.00','no','0.00',NULL,'202212091736','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'Paneer Burger','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000017','05:36:47 pm','2022 12 09','admin','1','  Takeaway','  Cash','130.00','130.00','11',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:36:47','%','0','40.00','no','0.00',NULL,'202212091736','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'White Hakka Noodles(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000017','05:36:47 pm','2022 12 09','admin','1','  Takeaway','  Cash','130.00','130.00','12',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:36:47','%','0','30.00','no','0.00',NULL,'202212091736','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'Paneer Panch Pizza(Medium )','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000018','05:38:54 pm','2022 12 09','admin','1','  Takeaway','  Cash','250.00','250.00','13',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:38:54','%','0','250.00','no','0.00',NULL,'202212091738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Extra Cheese Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'Onion Pizza (Regular)','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-000019','05:39:05 pm','2022 12 09','admin','1','  Takeaway','  Cash','100.00','100.00','14',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:39:05','%','0','100.00','no','0.00',NULL,'202212091739','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'Simple Zingi Parcel','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000110','05:42:44 pm','2022 12 09','admin','1','  Takeaway','  Cash','110.00','110.00','15',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:42:44','%','0','90.00','no','0.00',NULL,'202212091742','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000110','05:42:44 pm','2022 12 09','admin','1','  Takeaway','  Cash','110.00','110.00','16',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:42:44','%','0','20.00','no','0.00',NULL,'202212091742','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'Capiscum Pizza (Medium )','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000111','05:58:30 pm','2022 12 09','admin','1','  Takeaway','  Cash','190.00','190.00','18',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:58:30','%','0','100.00','no','0.00',NULL,'202212091758','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'Simple Zingi Parcel','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000111','05:58:30 pm','2022 12 09','admin','1','  Takeaway','  Cash','190.00','190.00','19',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120917:58:30','%','0','90.00','no','0.00',NULL,'202212091758','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000112','06:06:29 pm','2022 12 09','admin','1','  Takeaway','  Cash','20.00','20.00','20',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:06:29','%','0','20.00','no','0.00',NULL,'202212091806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000113','06:09:07 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','21',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:09:07','%','0','50.00','no','0.00',NULL,'202212091809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'Simple Zingi Parcel','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000114','06:12:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','120.00','120.00','22',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:12:37','%','0','60.00','no','0.00',NULL,'202212091812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'Simple Veg Burger','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000114','06:12:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','120.00','120.00','23',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:12:37','%','0','60.00','no','0.00',NULL,'202212091812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'Veg Noodles(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000115','06:13:38 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','24',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:13:38','%','0','40.00','no','0.00',NULL,'202212091813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'Momos(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000116','06:14:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','80.00','80.00','25',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:14:37','%','0','30.00','no','0.00',NULL,'202212091814','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'Momos(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000116','06:14:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','80.00','80.00','26',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:14:37','%','0','50.00','no','0.00',NULL,'202212091814','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000117','06:20:52 pm','2022 12 09','admin','1','  Takeaway','  Cash','20.00','20.00','27',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:20:52','%','0','20.00','no','0.00',NULL,'202212091820','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'Singapuri Noodles(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000118','06:21:05 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','28',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:21:05','%','0','50.00','no','0.00',NULL,'202212091821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'Simple Zingi Parcel','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000119','06:21:16 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','29',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:21:16','%','0','60.00','no','0.00',NULL,'202212091821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'White Hakka Noodles(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000119','06:21:16 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','30',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:21:16','%','0','30.00','no','0.00',NULL,'202212091821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'Veg Noodles(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000120','06:27:54 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','31',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:27:54','%','0','40.00','no','0.00',NULL,'202212091827','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'Paneer Noodles(Regular)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000121','06:31:23 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','32',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:31:23','%','0','40.00','no','0.00',NULL,'202212091831','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'Singapuri Noodles(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000122','06:32:30 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','33',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:32:30','%','0','30.00','no','0.00',NULL,'202212091832','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'Momos(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000123','06:38:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','34',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:38:37','%','0','30.00','no','0.00',NULL,'202212091838','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'Spring Rolls(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000124','06:46:32 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','35',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:46:32','%','0','40.00','no','0.00',NULL,'202212091846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000125','06:50:56 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','36',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:50:56','%','0','50.00','no','0.00',NULL,'202212091850','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'Simple Zingi Parcel','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000126','06:53:01 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','37',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:53:01','%','0','30.00','no','0.00',NULL,'202212091853','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'Simple Zingi Parcel','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000127','06:56:03 pm','2022 12 09','admin','1','  Takeaway','  Cash','60.00','60.00','38',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:56:03','%','0','60.00','no','0.00',NULL,'202212091856','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000128','06:56:17 pm','2022 12 09','admin','1','  Takeaway','  Cash','20.00','20.00','39',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:56:17','%','0','20.00','no','0.00',NULL,'202212091856','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000129','06:57:08 pm','2022 12 09','admin','1','  Takeaway','  Cash','20.00','20.00','40',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120918:57:08','%','0','20.00','no','0.00',NULL,'202212091857','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000130','07:06:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','100.00','100.00','41',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:06:27','%','0','50.00','no','0.00',NULL,'202212091906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'Tomato Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000130','07:06:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','100.00','100.00','42',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:06:27','%','0','50.00','no','0.00',NULL,'202212091906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'Veg Noodles(Regular)','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000131','07:12:11 pm','2022 12 09','admin','1','  Takeaway','  Cash','20.00','20.00','43',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:12:11','%','0','20.00','no','0.00',NULL,'202212091912','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'Singapuri Noodles(Regular)','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000132','07:13:40 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','44',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:13:40','%','0','30.00','no','0.00',NULL,'202212091913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000133','07:13:49 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','45',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:13:49','%','0','50.00','no','0.00',NULL,'202212091913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000134','07:14:30 pm','2022 12 09','admin','1','  Takeaway','  Cash','50.00','50.00','46',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:14:30','%','0','50.00','no','0.00',NULL,'202212091914','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'Stuff Bread ','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000135','07:16:00 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','47',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:16:00','%','0','90.00','no','0.00',NULL,'202212091916','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'Onion and Capiscum Pizza (Regular)','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000136','07:21:50 pm','2022 12 09','admin','1','  Takeaway','  Cash','220.00','220.00','48',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:21:50','%','0','70.00','no','0.00',NULL,'202212091921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Double Toppings Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'Paneer and Onion Pizza(Medium )','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000136','07:21:50 pm','2022 12 09','admin','1','  Takeaway','  Cash','220.00','220.00','49',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:21:50','%','0','150.00','no','0.00',NULL,'202212091921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Paneer Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'Simple Veg Burger','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000137','07:21:56 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','50',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:21:56','%','0','90.00','no','0.00',NULL,'202212091921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'White Sauce Pasta(Full)','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000138','07:22:41 pm','2022 12 09','admin','1','  Takeaway','  Cash','80.00','80.00','51',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:22:41','%','0','80.00','no','0.00',NULL,'202212091922','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pasta','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'Momos(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000139','07:25:22 pm','2022 12 09','admin','1','  Takeaway','  Cash','170.00','170.00','52',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:25:22','%','0','50.00','no','0.00',NULL,'202212091925','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'Cheese Burger ','3.0','40.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000139','07:25:22 pm','2022 12 09','admin','1','  Takeaway','  Cash','170.00','170.00','53',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:25:22','%','0','120.00','no','0.00',NULL,'202212091925','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'White Hakka Noodles(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000140','07:33:33 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','54',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:33:33','%','0','50.00','no','0.00',NULL,'202212091933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000140','07:33:33 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','55',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:33:33','%','0','50.00','no','0.00',NULL,'202212091933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'Tomato Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000140','07:33:33 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','56',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:33:33','%','0','50.00','no','0.00',NULL,'202212091933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'Paneer Pizza (Regular)','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000141','07:34:10 pm','2022 12 09','admin','1','  Takeaway','  Cash','70.00','70.00','57',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:34:10','%','0','70.00','no','0.00',NULL,'202212091934','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Paneer Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'Spring Rolls(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000142','07:38:47 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','58',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:38:47','%','0','40.00','no','0.00',NULL,'202212091938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'Spring Rolls(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000143','07:58:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','410.00','410.00','59',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:58:27','%','0','40.00','no','0.00',NULL,'202212091958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'Sweet Corn Pizza (Medium )','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000143','07:58:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','410.00','410.00','60',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:58:27','%','0','100.00','no','0.00',NULL,'202212091958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'Simple Zingi Parcel','5.0','30.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000143','07:58:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','410.00','410.00','61',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:58:27','%','0','150.00','no','0.00',NULL,'202212091958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'Paneer Zingi Parcel ','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000143','07:58:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','410.00','410.00','62',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:58:27','%','0','40.00','no','0.00',NULL,'202212091958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'White Sauce Pasta(Regular)','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000143','07:58:27 pm','2022 12 09','admin','1','  Takeaway','  Cash','410.00','410.00','63',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120919:58:27','%','0','80.00','no','0.00',NULL,'202212091958','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pasta','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'White Sauce Pasta(Regular)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000144','08:55:13 pm','2022 12 09','admin','1','  Takeaway','  Cash','40.00','40.00','64',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:55:13','%','0','40.00','no','0.00',NULL,'202212092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pasta','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'Paneer Pizza (Medium )','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000145','08:55:29 pm','2022 12 09','admin','1','  Takeaway','  Cash','130.00','130.00','65',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:55:29','%','0','130.00','no','0.00',NULL,'202212092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Paneer Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'Sweet Corn Pizza (Medium )','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000146','08:55:37 pm','2022 12 09','admin','1','  Takeaway','  Cash','100.00','100.00','66',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:55:37','%','0','100.00','no','0.00',NULL,'202212092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'Spring Rolls(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000147','08:55:52 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','67',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:55:52','%','0','40.00','no','0.00',NULL,'202212092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'Momos(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000147','08:55:52 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','68',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:55:52','%','0','50.00','no','0.00',NULL,'202212092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'Momos(Full)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000148','08:56:02 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','69',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:56:02','%','0','50.00','no','0.00',NULL,'202212092056','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'Spring Rolls(Full)','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000148','08:56:02 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','70',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:56:02','%','0','40.00','no','0.00',NULL,'202212092056','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chinese','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'Simple Zingi Parcel','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000149','08:56:13 pm','2022 12 09','admin','1','  Takeaway','  Cash','70.00','70.00','71',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:56:13','%','0','30.00','no','0.00',NULL,'202212092056','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'Paneer Zingi Parcel ','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000149','08:56:13 pm','2022 12 09','admin','1','  Takeaway','  Cash','70.00','70.00','72',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:56:13','%','0','40.00','no','0.00',NULL,'202212092056','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000150','08:57:00 pm','2022 12 09','admin','1','  Takeaway','  Cash','140.00','140.00','73',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:57:00','%','0','50.00','no','0.00',NULL,'202212092057','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'Stuff Bread ','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000150','08:57:00 pm','2022 12 09','admin','1','  Takeaway','  Cash','140.00','140.00','74',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:57:00','%','0','90.00','no','0.00',NULL,'202212092057','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(72,'Sweet Corn Pizza (Regular)','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000151','08:57:32 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','75',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:57:32','%','0','60.00','no','0.00',NULL,'202212092057','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(73,'Simple Zingi Parcel','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000151','08:57:32 pm','2022 12 09','admin','1','  Takeaway','  Cash','150.00','150.00','76',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:57:32','%','0','90.00','no','0.00',NULL,'202212092057','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(74,'Paneer and Corn Pizza (Regular)','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000152','08:58:13 pm','2022 12 09','admin','1','  Takeaway','  Cash','80.00','80.00','77',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:58:13','%','0','80.00','no','0.00',NULL,'202212092058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Paneer Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(75,'Paneer Spicy Warps','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000153','08:58:46 pm','2022 12 09','admin','1','  Takeaway','  Cash','60.00','60.00','78',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:58:46','%','0','60.00','no','0.00',NULL,'202212092058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Warps','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(76,'Paneer Spicy Warps','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000154','08:59:00 pm','2022 12 09','admin','1','  Takeaway','  Cash','60.00','60.00','79',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120920:59:00','%','0','60.00','no','0.00',NULL,'202212092059','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Warps','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(77,'Paneer Pizza (Regular)','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000155','09:01:11 pm','2022 12 09','admin','1','  Takeaway','  Cash','210.00','210.00','80',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120921:01:11','%','0','210.00','no','0.00',NULL,'202212092101','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Paneer Pizza','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(78,'Simple Veg Burger','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000156','09:03:35 pm','2022 12 09','admin','1','  Takeaway','  Cash','30.00','30.00','81',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120921:03:35','%','0','30.00','no','0.00',NULL,'202212092103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(79,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000157','09:03:48 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','82',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120921:03:48','%','0','50.00','no','0.00',NULL,'202212092103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(80,'Veg Sandwich ','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221209-1-0000157','09:03:48 pm','2022 12 09','admin','1','  Takeaway','  Cash','90.00','90.00','83',NULL,NULL,NULL,NULL,'09 Dec 2022','2022120921:03:48','%','0','40.00','no','0.00',NULL,'202212092103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sandwichs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(81,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221219-1-000011','05:57:05 pm','2022 12 19','admin','1','  Takeaway','  Cash','50.00','50.00','84',NULL,NULL,NULL,NULL,'19 Dec 2022','2022121917:57:05','%','0','50.00','no','0.00',NULL,'202212191757','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(82,'Onion Pizza (Medium)','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230405-1-000011','01:48:49 am','2023 04 05','admin','1','  Takeaway','  Cash','90.00','90.00','1',NULL,NULL,NULL,NULL,'05 Apr 2023','2023040501:48:49','%','0','90.00','no','0.00',NULL,'202304050148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(83,'Onion Pizza (Medium)','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20230405-1-000012','01:53:05 am','2023 04 05','admin','1','  Takeaway','  Cash','200.00','200.00','2',NULL,NULL,NULL,NULL,'05 Apr 2023','2023040501:53:05','%','0','90.00','no','0.00',NULL,'202304050153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(84,'Tomato Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20230405-1-000012','01:53:05 am','2023 04 05','admin','1','  Takeaway','  Cash','200.00','200.00','3',NULL,NULL,NULL,NULL,'05 Apr 2023','2023040501:53:05','%','0','50.00','no','0.00',NULL,'202304050153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(85,'Sweet Corn Pizza (Regular)','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20230405-1-000012','01:53:05 am','2023 04 05','admin','1','  Takeaway','  Cash','200.00','200.00','4',NULL,NULL,NULL,NULL,'05 Apr 2023','2023040501:53:05','%','0','60.00','no','0.00',NULL,'202304050153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(86,'Onion Pizza (Regular)','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000011','10:20:02 AM','2024 08 04','admin','1','  Takeaway','  Cash','140.00','140.00','1',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:02','%','0','50.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(87,'Onion Pizza (Medium)','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000011','10:20:02 AM','2024 08 04','admin','1','  Takeaway','  Cash','140.00','140.00','2',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:02','%','0','90.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Single Topping Pizza ','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'50.00'),(88,'Paneer Burger','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000012','10:20:56 am','2024 08 04','admin','1','  Takeaway','  Cash','190.00','190.00','3',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:56','%','0','40.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Burgers','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(89,'Simple Zingi Parcel','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000012','10:20:56 am','2024 08 04','admin','1','  Takeaway','  Cash','190.00','190.00','4',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:56','%','0','30.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(90,'Paneer Zingi Parcel ','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000012','10:20:56 am','2024 08 04','admin','1','  Takeaway','  Cash','190.00','190.00','5',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:56','%','0','40.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(91,'CalaZone ','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240804-000012','10:20:56 am','2024 08 04','admin','1','  Takeaway','  Cash','190.00','190.00','6',NULL,NULL,NULL,NULL,'04 Aug 2024','2024080410:20:56','%','0','80.00','no','0.00',NULL,'202408041020','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Stuffs','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.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,'20221209-1-000011','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','1','202212091251',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20221209-1-000012','160.00','admin','2022 12 09','  Cash','  Takeaway','160.00','0.00','0.00','0.0','2','202212091735',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20221209-1-000013','60.00','admin','2022 12 09','  Cash','  Takeaway','60.00','0.00','0.00','0.0','3','202212091735',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20221209-1-000014','100.00','admin','2022 12 09','  Cash','  Takeaway','100.00','0.00','0.00','0.0','4','202212091735',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20221209-1-000015','150.00','admin','2022 12 09','  Cash','  Takeaway','150.00','0.00','0.00','0.0','5','202212091736',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20221209-1-000016','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','6','202212091736',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20221209-1-000017','130.00','admin','2022 12 09','  Cash','  Takeaway','130.00','0.00','0.00','0.0','7','202212091736',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20221209-1-000018','250.00','admin','2022 12 09','  Cash','  Takeaway','250.00','0.00','0.00','0.0','8','202212091738',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20221209-1-000019','100.00','admin','2022 12 09','  Cash','  Takeaway','100.00','0.00','0.00','0.0','9','202212091739',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20221209-1-0000110','110.00','admin','2022 12 09','  Cash','  Takeaway','110.00','0.00','0.00','0.0','10','202212091742',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20221209-1-0000111','190.00','admin','2022 12 09','  Cash','  Takeaway','190.00','0.00','0.00','0.0','11','202212091758',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20221209-1-0000112','20.00','admin','2022 12 09','  Cash','  Takeaway','20.00','0.00','0.00','0.0','12','202212091806',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20221209-1-0000113','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','13','202212091809',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20221209-1-0000114','120.00','admin','2022 12 09','  Cash','  Takeaway','120.00','0.00','0.00','0.0','14','202212091812',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20221209-1-0000115','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','15','202212091813',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20221209-1-0000116','80.00','admin','2022 12 09','  Cash','  Takeaway','80.00','0.00','0.00','0.0','16','202212091814',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20221209-1-0000117','20.00','admin','2022 12 09','  Cash','  Takeaway','20.00','0.00','0.00','0.0','17','202212091820',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20221209-1-0000118','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','18','202212091821',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20221209-1-0000119','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','19','202212091821',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20221209-1-0000120','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','20','202212091827',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20221209-1-0000121','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','21','202212091831',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20221209-1-0000122','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','22','202212091832',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20221209-1-0000123','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','23','202212091838',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20221209-1-0000124','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','24','202212091846',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20221209-1-0000125','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','25','202212091850',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20221209-1-0000126','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','26','202212091853',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20221209-1-0000127','60.00','admin','2022 12 09','  Cash','  Takeaway','60.00','0.00','0.00','0.0','27','202212091856',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20221209-1-0000128','20.00','admin','2022 12 09','  Cash','  Takeaway','20.00','0.00','0.00','0.0','28','202212091856',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20221209-1-0000129','20.00','admin','2022 12 09','  Cash','  Takeaway','20.00','0.00','0.00','0.0','29','202212091857',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20221209-1-0000130','100.00','admin','2022 12 09','  Cash','  Takeaway','100.00','0.00','0.00','0.0','30','202212091906',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20221209-1-0000131','20.00','admin','2022 12 09','  Cash','  Takeaway','20.00','0.00','0.00','0.0','31','202212091912',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20221209-1-0000132','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','32','202212091913',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20221209-1-0000133','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','33','202212091913',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20221209-1-0000134','50.00','admin','2022 12 09','  Cash','  Takeaway','50.00','0.00','0.00','0.0','34','202212091914',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20221209-1-0000135','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','35','202212091916',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20221209-1-0000136','220.00','admin','2022 12 09','  Cash','  Takeaway','220.00','0.00','0.00','0.0','36','202212091921',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20221209-1-0000137','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','37','202212091921',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20221209-1-0000138','80.00','admin','2022 12 09','  Cash','  Takeaway','80.00','0.00','0.00','0.0','38','202212091922',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20221209-1-0000139','170.00','admin','2022 12 09','  Cash','  Takeaway','170.00','0.00','0.00','0.0','39','202212091925',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20221209-1-0000140','150.00','admin','2022 12 09','  Cash','  Takeaway','150.00','0.00','0.00','0.0','40','202212091933',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20221209-1-0000141','70.00','admin','2022 12 09','  Cash','  Takeaway','70.00','0.00','0.00','0.0','41','202212091934',NULL,NULL,NULL,NULL,NULL,NULL),(42,'20221209-1-0000142','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','42','202212091938',NULL,NULL,NULL,NULL,NULL,NULL),(43,'20221209-1-0000143','410.00','admin','2022 12 09','  Cash','  Takeaway','410.00','0.00','0.00','0.0','43','202212091958',NULL,NULL,NULL,NULL,NULL,NULL),(44,'20221209-1-0000144','40.00','admin','2022 12 09','  Cash','  Takeaway','40.00','0.00','0.00','0.0','44','202212092055',NULL,NULL,NULL,NULL,NULL,NULL),(45,'20221209-1-0000145','130.00','admin','2022 12 09','  Cash','  Takeaway','130.00','0.00','0.00','0.0','45','202212092055',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20221209-1-0000146','100.00','admin','2022 12 09','  Cash','  Takeaway','100.00','0.00','0.00','0.0','46','202212092055',NULL,NULL,NULL,NULL,NULL,NULL),(47,'20221209-1-0000147','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','47','202212092055',NULL,NULL,NULL,NULL,NULL,NULL),(48,'20221209-1-0000148','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','48','202212092056',NULL,NULL,NULL,NULL,NULL,NULL),(49,'20221209-1-0000149','70.00','admin','2022 12 09','  Cash','  Takeaway','70.00','0.00','0.00','0.0','49','202212092056',NULL,NULL,NULL,NULL,NULL,NULL),(50,'20221209-1-0000150','140.00','admin','2022 12 09','  Cash','  Takeaway','140.00','0.00','0.00','0.0','50','202212092057',NULL,NULL,NULL,NULL,NULL,NULL),(51,'20221209-1-0000151','150.00','admin','2022 12 09','  Cash','  Takeaway','150.00','0.00','0.00','0.0','51','202212092057',NULL,NULL,NULL,NULL,NULL,NULL),(52,'20221209-1-0000152','80.00','admin','2022 12 09','  Cash','  Takeaway','80.00','0.00','0.00','0.0','52','202212092058',NULL,NULL,NULL,NULL,NULL,NULL),(53,'20221209-1-0000153','60.00','admin','2022 12 09','  Cash','  Takeaway','60.00','0.00','0.00','0.0','53','202212092058',NULL,NULL,NULL,NULL,NULL,NULL),(54,'20221209-1-0000154','60.00','admin','2022 12 09','  Cash','  Takeaway','60.00','0.00','0.00','0.0','54','202212092059',NULL,NULL,NULL,NULL,NULL,NULL),(55,'20221209-1-0000155','210.00','admin','2022 12 09','  Cash','  Takeaway','210.00','0.00','0.00','0.0','55','202212092101',NULL,NULL,NULL,NULL,NULL,NULL),(56,'20221209-1-0000156','30.00','admin','2022 12 09','  Cash','  Takeaway','30.00','0.00','0.00','0.0','56','202212092103',NULL,NULL,NULL,NULL,NULL,NULL),(57,'20221209-1-0000157','90.00','admin','2022 12 09','  Cash','  Takeaway','90.00','0.00','0.00','0.0','57','202212092103',NULL,NULL,NULL,NULL,NULL,NULL),(58,'20221219-1-000011','50.00','admin','2022 12 19','  Cash','  Takeaway','50.00','0.00','0.00','0.0','58','202212191757',NULL,NULL,NULL,NULL,NULL,NULL),(59,'20230405-1-000011','90.00','admin','2023 04 05','  Cash','  Takeaway','90.00','0.00','0.00','0.0','1','202304050148',NULL,NULL,NULL,NULL,NULL,NULL),(60,'20230405-1-000012','200.00','admin','2023 04 05','  Cash','  Takeaway','200.00','0.00','0.00','0.0','2','202304050153',NULL,NULL,NULL,NULL,NULL,NULL),(61,'20240804-000011','140.00','admin','2024 08 04','  Cash','  Takeaway','140.00','0.00','0.00','0.0','1','202408041020',NULL,NULL,NULL,NULL,NULL,NULL),(62,'20240804-000012','190.00','admin','2024 08 04','  Cash','  Takeaway','190.00','0.00','0.00','0.0','2','202408041020',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (2,'Abhay Vaish','8684903894','','',50,'0.0',NULL,NULL,NULL),(3,'sohil','8930335402','','',20,'0.0',NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Onion Pizza (Regular)',50),(2,'Paneer Burger',40),(3,'Paneer Sandwich ',150),(4,'Simple Veg Burger',60),(5,'Simple Zingi Parcel',30),(6,'Sweet Corn Pizza (Regular)',60),(7,'Tomato Pizza (Regular)',100),(8,'Veg Duplex Pizza(Regular)',130),(9,'White Hakka Noodles(Regular)',60),(10,'Veg Noodles(Regular)',20),(11,'White Hakka Noodles(Regular)',60),(12,'White Hakka Noodles(Regular)',60),(13,'Tomato Pizza (Regular)',100),(14,'Veg Duplex Pizza(Regular)',130),(15,'Veg Noodles(Full)',80),(16,'Veg Noodles(Regular)',60),(17,'White Hakka Noodles(Regular)',90),(18,'White Hakka Noodles(Regular)',90),(19,'White Hakka Noodles(Regular)',90),(20,'Veg Duplex Pizza(Regular)',130),(21,'Veg Noodles(Full)',80),(22,'Veg Noodles(Regular)',120),(23,'White Hakka Noodles(Full)',50),(24,'White Hakka Noodles(Regular)',90),(25,'White Sauce Pasta(Full)',80),(26,'White Hakka Noodles(Full)',50),(27,'White Hakka Noodles(Regular)',90),(28,'White Sauce Pasta(Full)',80),(29,'White Sauce Pasta(Regular)',80),(30,'White Sauce Pasta(Regular)',120),(31,'White Sauce Pasta(Regular)',120),(32,'White Sauce Pasta(Full)',80),(33,'White Sauce Pasta(Regular)',120);
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,'null','Onion Pizza (Regular)',50,100,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'80','Paneer Burger',40,6,'1','Burgers',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'76','Paneer Sandwich ',150,22,'3','Sandwichs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'79','Simple Veg Burger',60,9,'2','Burgers',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'67','Simple Zingi Parcel',30,4,'1','Stuffs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'67','Sweet Corn Pizza (Regular)',60,9,'1','Single Topping Pizza ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'67','Tomato Pizza (Regular)',100,15,'2','Single Topping Pizza ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'67','Veg Duplex Pizza(Regular)',130,19,'1','Extra Cheese Pizza',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'67','White Hakka Noodles(Regular)',60,9,'2','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'67','Veg Noodles(Regular)',20,2,'1','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'67','White Hakka Noodles(Regular)',60,5,'2','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'67','White Hakka Noodles(Regular)',60,4,'2','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'67','Tomato Pizza (Regular)',100,5,'2','Single Topping Pizza ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'67','Veg Duplex Pizza(Regular)',130,7,'1','Extra Cheese Pizza',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'67','Veg Noodles(Full)',80,4,'2','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'67','Veg Noodles(Regular)',60,3,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'67','White Hakka Noodles(Regular)',90,5,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'67','White Hakka Noodles(Regular)',90,5,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'67','White Hakka Noodles(Regular)',90,4,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'70','Veg Duplex Pizza(Regular)',130,4,'1','Extra Cheese Pizza',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'70','Veg Noodles(Full)',80,3,'2','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'70','Veg Noodles(Regular)',120,4,'6','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'70','White Hakka Noodles(Full)',50,2,'1','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'70','White Hakka Noodles(Regular)',90,3,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'70','White Sauce Pasta(Full)',80,3,'1','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'70','White Hakka Noodles(Full)',50,1,'1','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'70','White Hakka Noodles(Regular)',90,2,'3','Chinese',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'70','White Sauce Pasta(Full)',80,2,'1','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'70','White Sauce Pasta(Regular)',80,2,'2','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'70','White Sauce Pasta(Regular)',120,3,'3','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'70','White Sauce Pasta(Regular)',120,3,'3','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'75','White Sauce Pasta(Full)',80,2,'1','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'75','White Sauce Pasta(Regular)',120,2,'3','Pasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Single Topping Pizza ',50),(3,'Single Topping Pizza ',50),(4,'Burgers',100),(5,'Chinese',60),(6,'Extra Cheese Pizza',130),(7,'Sandwichs',150),(8,'Single Topping Pizza ',210),(9,'Stuffs',30),(10,'Burgers',100),(11,'Chinese',80),(12,'Extra Cheese Pizza',380),(13,'Sandwichs',150),(14,'Single Topping Pizza ',310),(15,'Stuffs',120),(16,'Burgers',100),(17,'Chinese',100),(18,'Extra Cheese Pizza',380),(19,'Sandwichs',150),(20,'Single Topping Pizza ',460),(21,'Stuffs',210),(28,'Burgers',160),(29,'Chinese',400),(30,'Extra Cheese Pizza',380),(31,'Sandwichs',150),(32,'Single Topping Pizza ',460),(33,'Stuffs',330),(34,'Burgers',160),(35,'Chinese',460),(36,'Extra Cheese Pizza',380),(37,'Sandwichs',150),(38,'Single Topping Pizza ',460),(39,'Stuffs',330),(40,'Burgers',160),(41,'Chinese',520),(42,'Extra Cheese Pizza',380),(43,'Sandwichs',150),(44,'Single Topping Pizza ',510),(45,'Stuffs',420),(46,'Burgers',160),(47,'Chinese',540),(48,'Extra Cheese Pizza',380),(49,'Sandwichs',150),(50,'Single Topping Pizza ',510),(51,'Stuffs',420),(52,'Burgers',370),(53,'Chinese',690),(54,'Double Toppings Pizza',70),(55,'Extra Cheese Pizza',380),(56,'Paneer Pizza',150),(57,'Pasta',80),(58,'Sandwichs',150),(59,'Single Topping Pizza ',810),(60,'Stuffs',510),(61,'Burgers',370),(62,'Chinese',770),(63,'Double Toppings Pizza',70),(64,'Extra Cheese Pizza',380),(65,'Paneer Pizza',220),(66,'Pasta',160),(67,'Sandwichs',150),(68,'Single Topping Pizza ',910),(69,'Stuffs',700),(70,'Burgers',370),(71,'Chinese',770),(72,'Double Toppings Pizza',70),(73,'Extra Cheese Pizza',380),(74,'Paneer Pizza',220),(75,'Pasta',160),(76,'Sandwichs',150),(77,'Single Topping Pizza ',910),(78,'Stuffs',700),(79,'Burgers',370),(80,'Chinese',950),(81,'Double Toppings Pizza',70),(82,'Extra Cheese Pizza',380),(83,'Paneer Pizza',350),(84,'Pasta',200),(85,'Sandwichs',150),(86,'Single Topping Pizza ',1010),(87,'Stuffs',770),(88,'Burgers',370),(89,'Chinese',950),(90,'Double Toppings Pizza',70),(91,'Extra Cheese Pizza',380),(92,'Paneer Pizza',350),(93,'Pasta',200),(94,'Sandwichs',150),(95,'Single Topping Pizza ',1120),(96,'Stuffs',950),(97,'Burgers',370),(98,'Chinese',950),(99,'Double Toppings Pizza',70),(100,'Extra Cheese Pizza',380),(101,'Paneer Pizza',430),(102,'Pasta',200),(103,'Sandwichs',150),(104,'Single Topping Pizza ',1120),(105,'Stuffs',950),(106,'Burgers',400),(107,'Chinese',950),(108,'Double Toppings Pizza',70),(109,'Extra Cheese Pizza',380),(110,'Paneer Pizza',640),(111,'Pasta',200),(112,'Sandwichs',190),(113,'Single Topping Pizza ',1170),(114,'Stuffs',950),(115,'Warps',120),(116,'Burgers',400),(117,'Chinese',950),(118,'Double Toppings Pizza',70),(119,'Extra Cheese Pizza',380),(120,'Paneer Pizza',640),(121,'Pasta',200),(122,'Sandwichs',190),(123,'Single Topping Pizza ',1170),(124,'Stuffs',950),(125,'Warps',120);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',50);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',50,100);
