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,'Famous Grouse','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','1',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','5000.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'5000.00','','','','',NULL,'5000.00'),(2,'Famous Grouse Sm','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','2',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','5000.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'5000.00','','','','',NULL,'5000.00'),(3,'Label 5 Whisky','1.0','14000.00','14000.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','3',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','14000.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'14000.00','','','','',NULL,'14000.00'),(4,'Mc Dowel','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','4',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','1500.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'1500.00','','','','',NULL,'1500.00'),(5,'Claymore','1.0','18000.00','18000.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','5',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','18000.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'18000.00','','','','',NULL,'18000.00'),(6,'Brennamans','1.0','18000.00','18000.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','6',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','18000.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'18000.00','','','','',NULL,'18000.00'),(7,'Jameson Sml','1.0','9500.00','9500.00','Item',NULL,NULL,'no',NULL,NULL,'20241026-1-000031','12:38:39 PM','2024 10 26','admin','3','  Dine-in','  Cash','71000.00','71000.00','7',NULL,NULL,NULL,NULL,'26 Oct 2024','2024102612:38:39','%','0','9500.00','no','0.00',NULL,'202410261238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','admin','madmin',NULL,NULL,'',NULL,'9500.00','','','','',NULL,'9500.00'),(8,'Afang Soup','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','09:33:06 AM','2024 10 29','admin','1','  Dine-in','  Card','34000.00','34000.00','24',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102909:33:06','%','0','13000.00','no','0.00',NULL,'202410290933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6','0',NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(9,'Assorted Meat','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','09:33:06 AM','2024 10 29','admin','1','  Dine-in','  Card','34000.00','34000.00','25',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102909:33:06','%','0','13000.00','no','0.00',NULL,'202410290933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6','0',NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(10,'COCONUT Rice','1.0','8000.00','8000.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','09:33:06 AM','2024 10 29','admin','1','  Dine-in','  Card','34000.00','34000.00','26',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102909:33:06','%','0','8000.00','no','0.00',NULL,'202410290933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6','0',NULL,'',NULL,'8000.00','','','','',NULL,'8000.00'),(11,'Chivita Active','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000041','07:29:17 AM','2024 11 04','user1','4','  Dine-in','  Cash','6200.00','6200.00','1',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:29:17','%','0','2500.00','no','0.00',NULL,'202411040729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS',NULL,NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(12,'Beta Malt','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000041','07:29:17 AM','2024 11 04','user1','4','  Dine-in','  Cash','6200.00','6200.00','2',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:29:17','%','0','1200.00','no','0.00',NULL,'202411040729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS',NULL,NULL,'',NULL,'1200.00','','','','',NULL,'1200.00'),(13,'Chi Exotic Juice','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000041','07:29:17 AM','2024 11 04','user1','4','  Dine-in','  Cash','6200.00','6200.00','3',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:29:17','%','0','2500.00','no','0.00',NULL,'202411040729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS',NULL,NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(14,'Chi Exotic Juice','1.0','2500.00','2500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','34',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','2500.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS','0',NULL,'',NULL,'2500.00','','','','',NULL,'2500.00'),(15,'Climax','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','35',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','1500.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS','0',NULL,'',NULL,'1500.00','','','','',NULL,'1500.00'),(16,'Blue Bullet','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','36',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','3000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','PETERS','0',NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(17,'Extra Plantain','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','37',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','3000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','admin','PETERS','0',NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(18,'Extra Chips','1.0','4000.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','38',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','4000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','admin','PETERS','0',NULL,'',NULL,'4000.00','','','','',NULL,'4000.00'),(19,'Extra Yam','1.0','3000.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','39',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','3000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXTRA','admin','PETERS','0',NULL,'',NULL,'3000.00','','','','',NULL,'3000.00'),(20,'PS Pizza','1.0','12000.00','12000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','40',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','12000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','admin','PETERS','0',NULL,'',NULL,'12000.00','','','','',NULL,'12000.00'),(21,'Cheese and Ham','1.0','12000.00','12000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','41',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','12000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','admin','PETERS','0',NULL,'',NULL,'12000.00','','','','',NULL,'12000.00'),(22,'Beef Burger','1.0','9000.00','9000.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','07:32:23 AM','2024 11 04','admin','1','  Dine-in','  Card','50000.00','50000.00','42',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110407:32:23','%','0','9000.00','no','0.00',NULL,'202411040732','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PASTA PIZZA SANDWICH','admin','PETERS','0',NULL,'',NULL,'9000.00','','','','',NULL,'9000.00'),(23,'AFANG SOUP/ SWALLOW (ASSORTED )','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','02:44:31 AM','2024 11 07','user6','1','  Dine-in','  Cash','44000.00','44000.00','72',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110702:44:31','%','0','13000.00','no','0.00',NULL,'202411070244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6',NULL,NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(24,'AFANG SOUP/ SWALLOW (COWLEG )','1.0','13000.00','13000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','02:44:31 AM','2024 11 07','user6','1','  Dine-in','  Cash','44000.00','44000.00','73',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110702:44:31','%','0','13000.00','no','0.00',NULL,'202411070244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6',NULL,NULL,'',NULL,'13000.00','','','','',NULL,'13000.00'),(25,'SEAFOOD OKRO(POUNDO)','1.0','18000.00','18000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','02:44:31 AM','2024 11 07','user6','1','  Dine-in','  Cash','44000.00','44000.00','74',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110702:44:31','%','0','18000.00','no','0.00',NULL,'202411070244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NIGERIA CUISINE','user6','User6',NULL,NULL,'',NULL,'18000.00','','','','',NULL,'16000.00'),(26,'1960 Bitter Big','1.0','4000.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000012','02:45:05 AM','2024 11 07','user1','1','  Dine-in','  Cash','4000.00','4000.00','75',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110702:45:05','%','0','4000.00','no','0.00',NULL,'202411070245','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPIRITS','user6','User6',NULL,NULL,'',NULL,'4000.00','','','','',NULL,'4000.00'),(27,'Nestle Water','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000021','03:29:56 AM','2024 11 07','user1','2','  Dine-in','  Cash','2800.00','2800.00','9',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110703:29:56','%','0','600.00','no','0.00',NULL,'202411070329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'600.00','','','','',NULL,'600.00'),(28,'Water Large','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000021','03:29:56 AM','2024 11 07','user1','2','  Dine-in','  Cash','2800.00','2800.00','10',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110703:29:56','%','0','1200.00','no','0.00',NULL,'202411070329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'1200.00','','','','',NULL,'1200.00'),(29,'Soda','1.0','1000.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000021','03:29:56 AM','2024 11 07','user1','2','  Dine-in','  Cash','2800.00','2800.00','11',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110703:29:56','%','0','1000.00','no','0.00',NULL,'202411070329','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'1000.00','','','','',NULL,'1000.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,'20241026-1-000031','71000.00','admin','2024 10 26','  Cash','  Dine-in','71000.00','0.00','0.00','0.0','1','202410261238',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241029-1-000011','34000.00','admin','2024 10 29','  Card','  Dine-in','34000.00','0.00','0.00','0.0','2','202410290933',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241104-1-000041','6200.00','user1','2024 11 04','  Cash','  Dine-in','6200.00','0.00','0.00','0.0','3','202411040729',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241104-1-000011','50000.00','admin','2024 11 04','  Card','  Dine-in','50000.00','0.00','0.00','0.0','4','202411040732',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241107-1-000011','44000.00','user6','2024 11 07','  Cash','  Dine-in','44000.00','0.00','0.00','0.0','5','202411070244',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241107-1-000012','4000.00','user1','2024 11 07','  Cash','  Dine-in','4000.00','0.00','0.00','0.0','6','202411070245',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241107-1-000021','2800.00','user1','2024 11 07','  Cash','  Dine-in','2800.00','0.00','0.00','0.0','7','202411070329',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Beef Burger',9000),(2,'Beta Malt',1200),(3,'Blue Bullet',3000),(4,'Cheese and Ham',12000),(5,'Chi Exotic Juice',5000),(6,'Chivita Active',2500),(7,'Climax',1500),(8,'Extra Chips',4000),(9,'Extra Plantain',3000),(10,'Extra Yam',3000),(11,'PS Pizza',12000);
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,'438','Beef Burger',9000,16,'1','PASTA PIZZA SANDWICH',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'9','Beta Malt',1200,2,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'31','Blue Bullet',3000,5,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'431','Cheese and Ham',12000,21,'1','PASTA PIZZA SANDWICH',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'27','Chi Exotic Juice',5000,9,'2','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'26','Chivita Active',2500,4,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'33','Climax',1500,3,'1','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'473','Extra Chips',4000,7,'1','EXTRA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'476','Extra Plantain',3000,5,'1','EXTRA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'472','Extra Yam',3000,5,'1','EXTRA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'429','PS Pizza',12000,21,'1','PASTA PIZZA SANDWICH',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'EXTRA',10000),(3,'PASTA PIZZA SANDWICH',33000),(4,'SOFT DRINKS',13200),(5,'NIGERIA CUISINE',44000),(6,'SPIRITS',4000);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',50000),(2,'user1',6200);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'PETERS',50000,89),(2,'User1',6200,11);
