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 (39,'Chicken Kuzhi Mandi Full','1.0','640.00','640.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-0000120','01:03:07 PM','2024 11 22','admin','1','  Dine-in','  Cash','640.00','640.00','28',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:03:07','%','0','640.00','no','0.00',NULL,'202411221303',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'609.52',NULL,'','','',NULL,'609.52'),(40,'Alfaham Mandi Qtr','1.0','200.00','200.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-000012','01:16:55 PM','2024 11 22','admin','1','  Dine-in','  Cash','220.00','220.00','1',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:16:55','%','0','200.00','no','0.00',NULL,'202411221316',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'190.48',NULL,'','','',NULL,'190.48'),(41,'cola 250 ML','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241122-1-000012','01:16:55 PM','2024 11 22','admin','1','  Dine-in','  Cash','220.00','220.00','2',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:16:55','%','0','20.00','no','0.00',NULL,'202411221316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(42,'Peri Peri Alfaham Mandi Qtr','1.0','220.00','220.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-000013','01:49:01 PM','2024 11 22','admin','1','  Dine-in','  Cash','220.00','220.00','3',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:49:01','%','0','220.00','no','0.00',NULL,'202411221349',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'209.52',NULL,'','','',NULL,'209.52'),(43,'Peri Peri Alfaham Mandi Qtr','1.0','220.00','220.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-000014','01:49:57 PM','2024 11 22','admin','1','  Dine-in','  Cash','220.00','220.00','4',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:49:57','%','0','220.00','no','0.00',NULL,'202411221349',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'209.52',NULL,'','','',NULL,'209.52'),(44,'M.Dew 250','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241122-1-000015','01:53:09 PM','2024 11 22','admin','1','  Dine-in','  Cash','20.00','20.00','5',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:53:09','%','0','20.00','no','0.00',NULL,'202411221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(45,'M.Dew 750','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20241122-1-000016','01:58:27 PM','2024 11 22','admin','1','  Dine-in','  Cash','45.00','45.00','6',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112213:58:27','%','0','45.00','no','0.00',NULL,'202411221358','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(46,'Beef Mandi Half','1.0','430.00','430.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-000017','02:10:54 PM','2024 11 22','admin','1','  Dine-in','  Cash','430.00','430.00','7',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:10:54','%','0','1290.00','no','0.00',NULL,'202411221410',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'409.52',NULL,'','','',NULL,'409.52'),(47,'Alfaham Mandi Qtr','1.0','200.00','200.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-000018','02:13:14 PM','2024 11 22','admin','1','  Dine-in','  Cash','200.00','200.00','8',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:13:14','%','0','200.00','no','0.00',NULL,'202411221413',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'190.48',NULL,'','','',NULL,'190.48'),(48,'7 up 1 L','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241122-1-000019','02:13:57 PM','2024 11 22','admin','1','  Dine-in','  Cash','50.00','50.00','9',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:13:57','%','0','50.00','no','0.00',NULL,'202411221413','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(49,'Alfaham Mandi Qtr','1.0','200.00','200.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-0000110','02:14:58 PM','2024 11 22','admin','1','  Dine-in','  Cash','200.00','200.00','10',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:14:58','%','0','200.00','no','0.00',NULL,'202411221414',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'190.48',NULL,'','','',NULL,'190.48'),(50,'Alfaham Mandi Half','1.0','379.99','379.99','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-0000111','02:20:29 PM','2024 11 22','admin','1','  Dine-in','  Cash','419.99','419.99','13',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:20:29','%','0','379.99','no','0.00',NULL,'202411221420',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'361.90',NULL,'','','',NULL,'361.90'),(51,'cola 500 ML','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241122-1-0000111','02:20:29 PM','2024 11 22','admin','1','  Dine-in','  Cash','419.99','419.99','14',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112214:20:29','%','0','40.00','no','0.00',NULL,'202411221420','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SOFT DRINKS','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(52,'Chicken Kuzhi Mandi Qtr','1.0','180.00','180.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-0000112','03:14:05 PM','2024 11 22','admin','1','  Dine-in','  Cash','180.00','180.00','17',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112215:14:05','%','0','180.00','no','0.00',NULL,'202411221514',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'171.43',NULL,'','','',NULL,'171.43'),(53,'Chicken Kuzhi Mandi Qtr','1.0','180.00','180.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241122-1-0000113','06:12:53 PM','2024 11 22','admin','1','  Dine-in','  Cash','180.00','180.00','1',NULL,NULL,NULL,NULL,'22 Nov 2024','2024112218:12:53','%','0','180.00','no','0.00',NULL,'202411221812',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'MANDI','admin','madmin',NULL,NULL,'',NULL,'171.43',NULL,'','','',NULL,'171.43'),(54,'Alfaham Kuboos Qtr','1.0','130.00','130.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20241123-1-000011','12:06:36 PM','2024 11 23','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'23 Nov 2024','2024112312:06:36','%','0','130.00','no','0.00',NULL,'202411231206',NULL,'sgst(2.5%)','2.5',NULL,NULL,NULL,NULL,NULL,NULL,'KUBOOS','admin','madmin',NULL,NULL,'',NULL,'123.81',NULL,'','','',NULL,'123.81');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'443');
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 (28,'20241122-1-0000120','640.00','admin','2024 11 22','  Cash','  Dine-in','640.00','30.48','0.00','0.0','28','202411221303',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20241122-1-000012','220.00','admin','2024 11 22','  Cash','  Dine-in','220.00','9.52','0.00','0.0','29','202411221316',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20241122-1-000013','220.00','admin','2024 11 22','  Cash','  Dine-in','220.00','10.48','0.00','0.0','30','202411221349',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20241122-1-000014','220.00','admin','2024 11 22','  Cash','  Dine-in','220.00','10.48','0.00','0.0','31','202411221349',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20241122-1-000015','20.00','admin','2024 11 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','32','202411221353',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20241122-1-000016','45.00','admin','2024 11 22','  Cash','  Dine-in','45.00','0.00','0.00','0.0','33','202411221358',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20241122-1-000017','430.00','admin','2024 11 22','  Cash','  Dine-in','430.00','20.48','0.00','0.0','34','202411221410',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20241122-1-000018','200.00','admin','2024 11 22','  Cash','  Dine-in','200.00','9.52','0.00','0.0','35','202411221413',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20241122-1-000019','50.00','admin','2024 11 22','  Cash','  Dine-in','50.00','0.00','0.00','0.0','36','202411221413',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20241122-1-0000110','200.00','admin','2024 11 22','  Cash','  Dine-in','200.00','9.52','0.00','0.0','37','202411221414',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20241122-1-0000111','419.99','admin','2024 11 22','  Cash','  Dine-in','419.99','18.09','0.00','0.0','38','202411221420',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20241122-1-0000112','180.00','admin','2024 11 22','  Cash','  Dine-in','180.00','8.57','0.00','0.0','39','202411221514',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20241122-1-0000113','180.00','admin','2024 11 22','  Cash','  Dine-in','180.00','8.57','0.00','0.0','40','202411221812',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20241123-1-000011','130.00','admin','2024 11 23','  Cash','  Dine-in','130.00','6.19','0.00','0.0','41','202411231206',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (6,'Chicken Kuzhi Mandi Half',1003),(7,'Peri Peri Alfaham Mandi Full',2399),(8,'Peri Peri Alfaham Mandi Half',840),(9,'full meat',120),(10,'pate shawarma',240),(11,'pepsi 1 L',200),(12,'shawarma roll',70);
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 (6,'2','Chicken Kuzhi Mandi Half',1003,8,'3','MANDI',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'7','Peri Peri Alfaham Mandi Full',2399,19,'3','MANDI',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'8','Peri Peri Alfaham Mandi Half',840,7,'2','MANDI',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'25','full meat',120,1,'1','SHAWARMA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'24','pate shawarma',240,2,'2','SHAWARMA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'26','pepsi 1 L',200,2,'2','SOFT DRINKS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'23','shawarma roll',70,1,'1','SHAWARMA',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (7,'KUBOOS',1110),(8,'MANDI',10802),(9,'SHAWARMA',430),(10,'SOFT DRINKS',200),(11,'MANDI',640),(12,'MANDI',1280),(13,'SOFT DRINKS',20),(14,'MANDI',1280),(15,'None',20),(16,'SOFT DRINKS',20),(17,'MANDI',1280),(18,'None',65),(19,'SOFT DRINKS',20),(20,'MANDI',1910),(21,'None',65),(22,'SOFT DRINKS',20),(23,'MANDI',2489),(24,'None',65),(25,'SOFT DRINKS',110),(26,'MANDI',2669),(27,'None',65),(28,'SOFT DRINKS',110),(29,'MANDI',2849),(30,'None',65),(31,'SOFT DRINKS',110);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',640);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',640,100);
