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,'Tea','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000021','08:13:37 AM','2024 10 29','user4','2','  Dine-in','  Cash','5000.00','5000.00','14',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102908:13:37','%','0','1000.00','no','0.00',NULL,'202410290813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user4','IKENNA',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(2,'Coffee','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000021','08:13:37 AM','2024 10 29','user4','2','  Dine-in','  Cash','5000.00','5000.00','15',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102908:13:37','%','0','1000.00','no','0.00',NULL,'202410290813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user4','IKENNA',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(3,'Boiled Yam','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000021','08:13:37 AM','2024 10 29','user4','2','  Dine-in','  Cash','5000.00','5000.00','16',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102908:13:37','%','0','3000.00','no','0.00',NULL,'202410290813','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user4','IKENNA',NULL,NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(4,'Boiled Yam','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','07:03:14 PM','2024 10 29','user3','1','  Dine-in','  Cash','5000.00','5000.00','19',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102919:03:14','%','0','3000.00','no','0.00',NULL,'202410291903','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','admin','Peters',NULL,NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(5,'Bread','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','07:03:14 PM','2024 10 29','user3','1','  Dine-in','  Cash','5000.00','5000.00','20',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102919:03:14','%','0','1000.00','no','0.00',NULL,'202410291903','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','admin','Peters',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(6,'Tea','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','07:03:14 PM','2024 10 29','user3','1','  Dine-in','  Cash','5000.00','5000.00','22',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102919:03:14','%','0','1000.00','no','0.00',NULL,'202410291903','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','admin','Peters',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(7,'Budweiser','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','34',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','1500.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BEER','admin','Peters','0',NULL,'',NULL,'1500.00','','','','',NULL,'1500.00'),(8,'Akara and Pap','3.0','6000.00','18000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','35',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','18000.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','admin','Peters','0',NULL,'',NULL,'18000.00','','','','',NULL,'6000.00'),(9,'Assorted Juices','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','36',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','2500.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters','0',NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(10,'Beta Malt','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','37',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','1200.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters','0',NULL,'',NULL,'1200.00','','','','',NULL,'1200.00'),(11,'Bitter Lemon','1.0','800.00','800.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','38',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','800.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters','0',NULL,'',NULL,'800.00','','','','',NULL,'800.00'),(12,'Blue Bullet','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','06:16:51 PM','2024 11 04','admin','1','  Dine-in','  Card','27000.00','27000.00','39',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:16:51','%','0','3000.00','no','0.00',NULL,'202411041816','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters','0',NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(13,'Fanta','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000012','06:18:53 PM','2024 11 04','user6','1','  Dine-in','  Cash','7500.00','7500.00','40',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:18:53','%','0','1000.00','no','0.00',NULL,'202411041818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(14,'Chi Exotic Juice','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000012','06:18:53 PM','2024 11 04','user6','1','  Dine-in','  Cash','7500.00','7500.00','41',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:18:53','%','0','2500.00','no','0.00',NULL,'202411041818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters',NULL,NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(15,'Chivita Active','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000012','06:18:53 PM','2024 11 04','user6','1','  Dine-in','  Cash','7500.00','7500.00','42',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:18:53','%','0','2500.00','no','0.00',NULL,'202411041818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters',NULL,NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(16,'Climax','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000012','06:18:53 PM','2024 11 04','user6','1','  Dine-in','  Cash','7500.00','7500.00','43',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110418:18:53','%','0','1500.00','no','0.00',NULL,'202411041818','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','Peters',NULL,NULL,'',NULL,'1500.00','','','','',NULL,'1500.00'),(17,'Vegetable Soup','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000011','03:58:57 PM','2024 11 06','user1','1','  Dine-in','  Card','22000.00','22000.00','61',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:58:57','%','0','13000.00','no','0.00',NULL,'202411061558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user1','MODESTUS','0',NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(18,'Porridge Plantain','1.0','6000.00','6000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000011','03:58:57 PM','2024 11 06','user1','1','  Dine-in','  Card','22000.00','22000.00','62',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:58:57','%','0','6000.00','no','0.00',NULL,'202411061558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user1','MODESTUS','0',NULL,'',NULL,'6000.00','','','','',NULL,'6000.00'),(19,'Vegetable sauce','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000011','03:58:57 PM','2024 11 06','user1','1','  Dine-in','  Card','22000.00','22000.00','63',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:58:57','%','0','3000.00','no','0.00',NULL,'202411061558','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user1','MODESTUS','0',NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(20,'Chicken Burger','1.0','12000.00','12000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000021','03:59:28 PM','2024 11 06','user1','2','  Dine-in','  Cash','32500.00','32500.00','17',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:59:28','%','0','12000.00','no','0.00',NULL,'202411061559','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'12000.00','','','','',NULL,'12000.00'),(21,'Chicken Sandwich','1.0','8500.00','8500.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000021','03:59:28 PM','2024 11 06','user1','2','  Dine-in','  Cash','32500.00','32500.00','18',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:59:28','%','0','8500.00','no','0.00',NULL,'202411061559','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'8500.00','','','','',NULL,'8500.00'),(22,'ClassicClub SanW','1.0','12000.00','12000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000021','03:59:28 PM','2024 11 06','user1','2','  Dine-in','  Cash','32500.00','32500.00','19',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110615:59:28','%','0','12000.00','no','0.00',NULL,'202411061559','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'12000.00','','','','',NULL,'12000.00'),(23,'Spaghetti Carbo','1.0','15000.00','15000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000022','04:00:28 PM','2024 11 06','admin','2','  Dine-in','  Card','29000.00','29000.00','20',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:00:28','%','0','15000.00','no','0.00',NULL,'202411061600','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS','0',NULL,'',NULL,'15000.00','','','','',NULL,'15000.00'),(24,'Margarita Pizza','1.0','14000.00','14000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000022','04:00:28 PM','2024 11 06','admin','2','  Dine-in','  Card','29000.00','29000.00','21',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:00:28','%','0','14000.00','no','0.00',NULL,'202411061600','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS','0',NULL,'',NULL,'14000.00','','','','',NULL,'14000.00'),(25,'Margarita Pizza','1.0','14000.00','14000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000012','04:06:45 PM','2024 11 06','user2','1','  Dine-in','  Cash','23000.00','23000.00','70',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:06:45','%','0','14000.00','no','0.00',NULL,'202411061606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'14000.00','','','','',NULL,'14000.00'),(26,'Beef Burger','1.0','9000.00','9000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000012','04:06:45 PM','2024 11 06','user2','1','  Dine-in','  Cash','23000.00','23000.00','71',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:06:45','%','0','9000.00','no','0.00',NULL,'202411061606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'9000.00','','','','',NULL,'9000.00'),(27,'Margarita Pizza','1.0','14000.00','14000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000013','04:08:40 PM','2024 11 06','user2','1','  Dine-in','  Cash','23000.00','23000.00','72',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:08:40','%','0','14000.00','no','0.00',NULL,'202411061608','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'14000.00','','','','',NULL,'14000.00'),(28,'Beef Burger','1.0','9000.00','9000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000013','04:08:40 PM','2024 11 06','user2','1','  Dine-in','  Cash','23000.00','23000.00','73',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:08:40','%','0','9000.00','no','0.00',NULL,'202411061608','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'9000.00','','','','',NULL,'9000.00'),(29,'Spaghetti Carbo','1.0','15000.00','15000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000014','04:09:53 PM','2024 11 06','user2','1','  Dine-in','  Cash','29000.00','29000.00','74',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:09:53','%','0','15000.00','no','0.00',NULL,'202411061609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'15000.00','','','','',NULL,'15000.00'),(30,'Margarita Pizza','1.0','14000.00','14000.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000014','04:09:53 PM','2024 11 06','user2','1','  Dine-in','  Cash','29000.00','29000.00','75',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110616:09:53','%','0','14000.00','no','0.00',NULL,'202411061609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','user1','MODESTUS',NULL,NULL,'',NULL,'14000.00','','','','',NULL,'14000.00'),(31,'Buffet breakfast','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','01:29:07 PM','2024 11 07','admin','1','  Dine-in','  Cash','11000.00','11000.00','76',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110713:29:07','%','0','10000.00','no','0.00',NULL,'202411071329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user1','MODESTUS',NULL,NULL,'',NULL,'10000.00','','','','',NULL,'10000.00'),(32,'Bread','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','01:29:07 PM','2024 11 07','admin','1','  Dine-in','  Cash','11000.00','11000.00','77',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110713:29:07','%','0','1000.00','no','0.00',NULL,'202411071329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user1','MODESTUS',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.00'),(33,'OFE OWERRI(SEMO)','1.0','15000.00','15000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000031','07:32:44 PM','2024 11 08','admin','3','  Dine-in','  Card','22000.00','22000.00','7',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110819:32:44','%','0','15000.00','no','0.00',NULL,'202411081932','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'15000.00','','','','',NULL,'15000.00'),(34,'Pepper Cow Leg','1.0','7000.00','7000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000031','07:32:44 PM','2024 11 08','admin','3','  Dine-in','  Card','22000.00','22000.00','8',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110819:32:44','%','0','7000.00','no','0.00',NULL,'202411081932','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PEPPERED PROTEIN','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'7000.00','','','','',NULL,'7000.00'),(35,'CHICKEN STEW(JELLOF RICE )','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000032','07:46:31 PM','2024 11 08','admin','3','  Dine-in','  Card','13000.00','13000.00','9',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110819:46:31','%','0','13000.00','no','0.00',NULL,'202411081946','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RICE DISHES','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(36,'Extra Rice','1.0','4000.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000033','08:12:50 PM','2024 11 08','admin','3','  Dine-in','  Card','4000.00','4000.00','11',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110820:12:50','%','0','4000.00','no','0.00',NULL,'202411082012','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'4000.00','','','','',NULL,'4000.00'),(37,'CHICKEN STEW(WHITE RICE)','2.0','13000.00','26000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000051','08:13:30 PM','2024 11 08','admin','5','  Dine-in','  Cash','33200.00','33200.00','10',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110820:13:30','%','0','26000.00','no','0.00',NULL,'202411082013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RICE DISHES','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'26000.00','','','','',NULL,'13000.00'),(38,'Extra Plantain','2.0','3000.00','6000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000051','08:13:30 PM','2024 11 08','admin','5','  Dine-in','  Cash','33200.00','33200.00','11',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110820:13:30','%','0','6000.00','no','0.00',NULL,'202411082013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'6000.00','','','','',NULL,'3000.00'),(39,'Nestle Water','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000051','08:13:30 PM','2024 11 08','admin','5','  Dine-in','  Cash','33200.00','33200.00','12',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110820:13:30','%','0','1200.00','no','0.00',NULL,'202411082013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'1200.00','','','','',NULL,'600.00'),(40,'BEEF STEW(JELLOF RICE )','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000061','08:14:59 PM','2024 11 08','admin','6','  Dine-in','  Cash','13000.00','13000.00','11',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110820:14:59','%','0','13000.00','no','0.00',NULL,'202411082014','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RICE DISHES','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(41,'CHICKEN STEW(JELLOF RICE )','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000021','09:05:40 PM','2024 11 08','admin','2','  Dine-in','  Card','13600.00','13600.00','22',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:05:40','%','0','13000.00','no','0.00',NULL,'202411082105','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RICE DISHES','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(42,'Nestle Water','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000021','09:05:40 PM','2024 11 08','admin','2','  Dine-in','  Card','13600.00','13600.00','23',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:05:40','%','0','600.00','no','0.00',NULL,'202411082105','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'600.00','','','','',NULL,'600.00'),(43,'CHICKEN STEW(FRIED RICE )','2.0','13000.00','26000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000041','09:14:42 PM','2024 11 08','admin','4','  Dine-in','  Card','34700.00','34700.00','9',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:14:42','%','0','26000.00','no','0.00',NULL,'202411082114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RICE DISHES','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'26000.00','','','','',NULL,'13000.00'),(44,'Pepper Chicken','1.0','7000.00','7000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000041','09:14:42 PM','2024 11 08','admin','4','  Dine-in','  Card','34700.00','34700.00','11',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:14:42','%','0','7000.00','no','0.00',NULL,'202411082114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PEPPERED PROTEIN','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'7000.00','','','','',NULL,'7000.00'),(45,'Take Away pack','1.0','500.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000041','09:14:42 PM','2024 11 08','admin','4','  Dine-in','  Card','34700.00','34700.00','12',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:14:42','%','0','500.00','no','0.00',NULL,'202411082114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'500.00','','','','',NULL,'500.00'),(46,'Nestle Water','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000041','09:14:42 PM','2024 11 08','admin','4','  Dine-in','  Card','34700.00','34700.00','13',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:14:42','%','0','1200.00','no','0.00',NULL,'202411082114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','user1','BLESSINGS FRANCIS ','0',NULL,'',NULL,'1200.00','','','','',NULL,'600.00'),(47,'Quaker Oat','2.0','2500.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000011','09:19:35 PM','2024 11 08','admin','1','  Dine-in','  Cash','12000.00','12000.00','110',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:19:35','%','0','5000.00','no','0.00',NULL,'202411082119','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BREAKFAST','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'5000.00','','','','',NULL,'2500.00'),(48,'Extra Rice','1.0','4000.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000011','09:19:35 PM','2024 11 08','admin','1','  Dine-in','  Cash','12000.00','12000.00','111',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:19:35','%','0','4000.00','no','0.00',NULL,'202411082119','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'4000.00','','','','',NULL,'4000.00'),(49,'Vegetable sauce','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241108-1-000011','09:19:35 PM','2024 11 08','admin','1','  Dine-in','  Cash','12000.00','12000.00','113',NULL,NULL,NULL,NULL,'08 Nov 2024','2024110821:19:35','%','0','3000.00','no','0.00',NULL,'202411082119','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user1','BLESSINGS FRANCIS ',NULL,NULL,'',NULL,'3000.00','','','','',NULL,'3000.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,'20241029-1-000021','5000.00','user4','2024 10 29','  Cash','  Dine-in','5000.00','0.00','0.00','0.0','1','202410290813',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241029-1-000011','5000.00','user3','2024 10 29','  Cash','  Dine-in','5000.00','0.00','0.00','0.0','2','202410291903',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241104-1-000011','27000.00','admin','2024 11 04','  Card','  Dine-in','27000.00','0.00','0.00','0.0','3','202411041816',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241104-1-000012','7500.00','user6','2024 11 04','  Cash','  Dine-in','7500.00','0.00','0.00','0.0','4','202411041818',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241106-1-000011','22000.00','user1','2024 11 06','  Card','  Dine-in','22000.00','0.00','0.00','0.0','5','202411061558',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241106-1-000021','32500.00','user1','2024 11 06','  Cash','  Dine-in','32500.00','0.00','0.00','0.0','6','202411061559',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241106-1-000022','29000.00','admin','2024 11 06','  Card','  Dine-in','29000.00','0.00','0.00','0.0','7','202411061600','transfer ',NULL,NULL,NULL,NULL,NULL),(8,'20241106-1-000012','23000.00','user2','2024 11 06','  Cash','  Dine-in','23000.00','0.00','0.00','0.0','8','202411061606',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20241106-1-000013','23000.00','user2','2024 11 06','  Cash','  Dine-in','23000.00','0.00','0.00','0.0','9','202411061608',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20241106-1-000014','29000.00','user2','2024 11 06','  Cash','  Dine-in','29000.00','0.00','0.00','0.0','10','202411061609',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20241107-1-000011','11000.00','admin','2024 11 07','  Cash','  Dine-in','11000.00','0.00','0.00','0.0','11','202411071329',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20241108-1-000031','22000.00','admin','2024 11 08','  Card','  Dine-in','22000.00','0.00','0.00','0.0','1','202411081932',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20241108-1-000032','13000.00','admin','2024 11 08','  Card','  Dine-in','13000.00','0.00','0.00','0.0','2','202411081946',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20241108-1-000033','4000.00','admin','2024 11 08','  Card','  Dine-in','4000.00','0.00','0.00','0.0','3','202411082012',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20241108-1-000051','33200.00','admin','2024 11 08','  Cash','  Dine-in','33200.00','0.00','0.00','0.0','4','202411082013',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20241108-1-000061','13000.00','admin','2024 11 08','  Cash','  Dine-in','13000.00','0.00','0.00','0.0','5','202411082014',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20241108-1-000021','13600.00','admin','2024 11 08','  Card','  Dine-in','13600.00','0.00','0.00','0.0','6','202411082105',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20241108-1-000041','34700.00','admin','2024 11 08','  Card','  Dine-in','34700.00','0.00','0.00','0.0','7','202411082114',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20241108-1-000011','12000.00','admin','2024 11 08','  Cash','  Dine-in','12000.00','0.00','0.00','0.0','8','202411082119',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Boiled Yam',3000),(2,'Coffee',1000),(3,'Tea',1000),(4,'Tea',2000),(5,'Blue Bullet',3000),(6,'Budweiser',1500),(7,'Chi Exotic Juice',2500),(8,'Chivita Active',2500),(9,'Climax',1500),(10,'Fanta',1000),(11,'Quaker Oat',5000),(12,'Take Away pack',500),(13,'Vegetable sauce',3000);
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,'379','Boiled Yam',3000,60,'1','BREAKFAST',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'374','Coffee',1000,20,'1','BREAKFAST',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'375','Tea',1000,20,'1','BREAKFAST',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'375','Tea',2000,20,'2','BREAKFAST',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'31','Blue Bullet',3000,9,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'39','Budweiser',1500,4,'1','BEER',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'27','Chi Exotic Juice',2500,7,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'26','Chivita Active',2500,7,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'33','Climax',1500,4,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'4','Fanta',1000,3,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'377','Quaker Oat',5000,3,'2','BREAKFAST',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'475','Take Away pack',500,0,'1','EXTRA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'397','Vegetable sauce',3000,2,'1','NIGERIA CUISINE',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'BREAKFAST',5000),(3,'BREAKFAST',10000),(7,'BEER',1500),(8,'BREAKFAST',18000),(9,'SOFT DRINKS',15000),(12,'NIGERIA CUISINE',22000),(13,'PASTA PIZZA SANDWICH',84500),(26,'BREAKFAST',5000),(27,'EXTRA',14500),(28,'NIGERIA CUISINE',18000),(29,'PEPPERED PROTEIN',14000),(30,'RICE DISHES',91000),(31,'SOFT DRINKS',3000);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'user4',5000),(2,'user4',5000),(3,'user2',23000);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'IKENNA',5000,100),(2,'IKENNA',5000,50),(3,'WISDOM ',23000,22);
