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,'poori','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241025-1-000011','11:33:09 AM','2024 10 25','admin','1','  Dine-in','  Cash','70.00','70.00','1',NULL,NULL,NULL,NULL,'25 Oct 2024','2024102511:33:09','%','0','70.00','no','0.00',NULL,'202410251133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'5',NULL,'70.00','','','','',NULL,'35.00'),(2,'Brass Laddu Gopal No.1 MH 266','1.0','300.00','300.00','Item',NULL,NULL,'no','12','GST(12%)','20241120-1-000011','02:59:56 pm','2024 11 20','admin','1','  Dine-in','  Cash','460.00','460.00','1',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112014:59:56','%','0','300.00','no','0.00',NULL,'202411201459',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DEVOTION','admin','madmin',NULL,NULL,'FG00014',NULL,'267.86','','','','',NULL,'267.86'),(3,'CB - Govinda','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000011','02:59:56 pm','2024 11 20','admin','1','  Dine-in','  Cash','460.00','460.00','2',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112014:59:56','%','0','80.00','no','0.00',NULL,'202411201459',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00063',NULL,'80.00','','','','',NULL,'80.00'),(4,'CB - Ayodhya','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000011','02:59:56 pm','2024 11 20','admin','1','  Dine-in','  Cash','460.00','460.00','3',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112014:59:56','%','0','80.00','no','0.00',NULL,'202411201459',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00064',NULL,'80.00','','','','',NULL,'80.00'),(5,'CB - Mahabharata','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000012','03:00:24 pm','2024 11 20','admin','1','  Dine-in','  Cash','145.00','145.00','4',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:00:24','%','0','80.00','no','0.00',NULL,'202411201500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00071',NULL,'80.00','','','','',NULL,'80.00'),(6,'Sandal 100 Gms.','1.0','65.00','65.00','Item',NULL,NULL,'no','5','GST(5%)','20241120-1-000012','03:00:24 pm','2024 11 20','admin','1','  Dine-in','  Cash','145.00','145.00','5',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:00:24','%','0','65.00','no','0.00',NULL,'202411201500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DEVOTION','admin','madmin',NULL,NULL,'FG00359',NULL,'61.90','','','','',NULL,'61.90'),(7,'Brass Laddu Gopal No.1 MH 266','1','267.86','267.86','Item','null','null','no','12','GST(12%)','20241120-1-000013','3:01:09 PM','2024 11 20','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','20Nov24','2024112003:001:009','%','0','','','','test','2024112003:001:009','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00014','test','test','test','test','test','test',NULL,NULL),(8,'CB - Govinda','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000014','03:02:38 pm','2024 11 20','admin','1','  Dine-in','  Cash','440.00','440.00','7',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:02:38','%','0','80.00','no','0.00',NULL,'202411201502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00063',NULL,'80.00','','','','',NULL,'80.00'),(9,'CB - Mahabharata','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000014','03:02:38 pm','2024 11 20','admin','1','  Dine-in','  Cash','440.00','440.00','8',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:02:38','%','0','80.00','no','0.00',NULL,'202411201502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00071',NULL,'80.00','','','','',NULL,'80.00'),(10,'CB - Lord Krishnas Advent  Pastimes','1.0','200.00','200.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000014','03:02:38 pm','2024 11 20','admin','1','  Dine-in','  Cash','440.00','440.00','9',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:02:38','%','0','200.00','no','0.00',NULL,'202411201502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00072',NULL,'200.00','','','','',NULL,'200.00'),(11,'CB - Ayodhya','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241120-1-000014','03:02:38 pm','2024 11 20','admin','1','  Dine-in','  Cash','440.00','440.00','10',NULL,NULL,NULL,NULL,'20 Nov 2024','2024112015:02:38','%','0','80.00','no','0.00',NULL,'202411201502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00064',NULL,'80.00','','','','',NULL,'80.00'),(12,'Brass Laddu Gopal No.1 MH 266','1','267.86','267.86','Item','null','null','no','12','GST(12%)','20241122-1-000011','9:33:11 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','22Nov24','2024112209:33:11','%','0','','','','test','2024112209:33:11','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00014','test','test','test','test','test','test',NULL,NULL),(13,'CB - Govinda','1','80.00','80.00','Item','null','null','no','0','GST(0%)','20241122-1-000011','9:33:11 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','22Nov24','2024112209:33:11','%','0','','','','test','2024112209:33:11','','','','','','','','','','BOOK','madmin','madmin','null','','FG00063','test','test','test','test','test','test',NULL,NULL),(14,'CB - Ayodhya','1','80.00','80.00','Item','null','null','no','0','GST(0%)','20241122-1-000011','9:33:11 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','3','null','null','null','null','22Nov24','2024112209:33:11','%','0','','','','test','2024112209:33:11','','','','','','','','','','BOOK','madmin','madmin','null','','FG00064','test','test','test','test','test','test',NULL,NULL),(15,'Nagachampa 250 gms','1','361.90','361.90','Item','null','null','no','5','GST(5%)','20241122-1-000012','9:33:39 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','7','null','null','null','null','22Nov24','2024112209:33:39','%','0','','','','test','2024112209:33:39','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00346','test','test','test','test','test','test',NULL,NULL),(16,'CB - Lord Krishnas Advent  Pastimes','1','200.00','200.00','Item','null','null','no','0','GST(0%)','20241122-1-000012','9:33:39 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','6','null','null','null','null','22Nov24','2024112209:33:39','%','0','','','','test','2024112209:33:39','','','','','','','','','','BOOK','madmin','madmin','null','','FG00072','test','test','test','test','test','test',NULL,NULL),(17,'Agarbathi Stand W/Print','1','178.57','178.57','Item','null','null','no','12','GST(12%)','20241122-1-000013','9:33:54 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','10','null','null','null','null','22Nov24','2024112209:33:54','%','0','','','','test','2024112209:33:54','','','','','','','','','','STAND','madmin','madmin','null','','FG00363','test','test','test','test','test','test',NULL,NULL),(18,'Nagachampa 250 gms','1','361.90','361.90','Item','null','null','no','5','GST(5%)','20241122-1-000013','9:33:54 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','7','null','null','null','null','22Nov24','2024112209:33:54','%','0','','','','test','2024112209:33:54','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00346','test','test','test','test','test','test',NULL,NULL),(19,'Sandal 100 Gms.','1','61.90','61.90','Item','null','null','no','5','GST(5%)','20241122-1-000013','9:33:54 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','8','null','null','null','null','22Nov24','2024112209:33:54','%','0','','','','test','2024112209:33:54','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00359','test','test','test','test','test','test',NULL,NULL),(20,'Agarbathi Stand W/Print','1','178.57','178.57','Item','null','null','no','12','GST(12%)','20241122-1-000014','11:49:41 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','10','null','null','null','null','22Nov24','2024112211:49:41','%','0','','','','test','2024112211:49:41','','','','','','','','','','STAND','madmin','madmin','null','','FG00363','test','test','test','test','test','test',NULL,NULL),(21,'CB - Lord Krishnas Advent  Pastimes','1','200.00','200.00','Item','null','null','no','0','GST(0%)','20241122-1-000014','11:49:41 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','6','null','null','null','null','22Nov24','2024112211:49:41','%','0','','','','test','2024112211:49:41','','','','','','','','','','BOOK','madmin','madmin','null','','FG00072','test','test','test','test','test','test',NULL,NULL),(22,'Brass Laddu Gopal No.1 MH 266','1','267.86','267.86','Item','null','null','no','12','GST(12%)','20241122-1-000015','11:49:56 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','22Nov24','2024112211:49:56','%','0','','','','test','2024112211:49:56','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00014','test','test','test','test','test','test',NULL,NULL),(23,'CB - Govinda','1','80.00','80.00','Item','null','null','no','0','GST(0%)','20241122-1-000015','11:49:56 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','22Nov24','2024112211:49:56','%','0','','','','test','2024112211:49:56','','','','','','','','','','BOOK','madmin','madmin','null','','FG00063','test','test','test','test','test','test',NULL,NULL),(24,'Nagachampa 250 gms','1','361.90','361.90','Item','null','null','no','5','GST(5%)','20241122-1-000016','11:50:23 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','7','null','null','null','null','22Nov24','2024112211:50:23','%','0','','','','test','2024112211:50:23','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00346','test','test','test','test','test','test',NULL,NULL),(25,'Sandal 100 Gms.','1','61.90','61.90','Item','null','null','no','5','GST(5%)','20241122-1-000016','11:50:23 AM','2024 11 22','madmin','1','  Dine-in','  cash','0','0','8','null','null','null','null','22Nov24','2024112211:50:23','%','0','','','','test','2024112211:50:23','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00359','test','test','test','test','test','test',NULL,NULL),(26,'CB - Lord Krishnas Advent  Pastimes','1','200.00','200.00','Item','null','null','no','0','GST(0%)','20241122-1-000021','12:20:10 PM','2024 11 22','madmin','2','  Dine-in','  cash','0','0','6','null','null','null','null','22Nov24','2024112212:20:10','%','0','','','','test','2024112212:20:10','','','','','','','','','','BOOK','madmin','madmin','null','','FG00072','test','test','test','test','test','test',NULL,NULL),(27,'CB - Mahabharata','1','80.00','80.00','Item','null','null','no','0','GST(0%)','20241122-1-000021','12:20:10 PM','2024 11 22','madmin','2','  Dine-in','  cash','0','0','5','null','null','null','null','22Nov24','2024112212:20:10','%','0','','','','test','2024112212:20:10','','','','','','','','','','BOOK','madmin','madmin','null','','FG00071','test','test','test','test','test','test',NULL,NULL),(28,'Brass Laddu Gopal No.1 MH 266','1','267.86','267.86','Item','null','null','no','12','GST(12%)','20241122-1-000021','12:20:10 PM','2024 11 22','madmin','2','  Dine-in','  cash','0','0','1','null','null','null','null','22Nov24','2024112212:20:10','%','0','','','','test','2024112212:20:10','','','','','','','','','','DEVOTION','madmin','madmin','null','','FG00014','test','test','test','test','test','test',NULL,NULL),(29,'CB - Govinda','1','80.00','80.00','Item','null','null','no','0','GST(0%)','20241122-1-000021','12:20:10 PM','2024 11 22','madmin','2','  Dine-in','  cash','0','0','2','null','null','null','null','22Nov24','2024112212:20:10','%','0','','','','test','2024112212:20:10','','','','','','','','','','BOOK','madmin','madmin','null','','FG00063','test','test','test','test','test','test',NULL,NULL),(30,'Brass Laddu Gopal No.1 MH 266','1.0','300.00','300.00','Item',NULL,NULL,'no','12','GST(12%)','20241212-1-000011','09:53:26 am','2024 12 12','admin','1','  Dine-in','  Cash','540.00','540.00','1',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:26','%','0','300.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DEVOTION','admin','madmin',NULL,NULL,'FG00014',NULL,'267.86','','','','',NULL,'267.86'),(31,'CB - Govinda','2.0','80.00','160.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000011','09:53:26 am','2024 12 12','admin','1','  Dine-in','  Cash','540.00','540.00','2',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:26','%','0','160.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00063',NULL,'160.00','','','','',NULL,'80.00'),(32,'CB - Ayodhya','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000011','09:53:26 am','2024 12 12','admin','1','  Dine-in','  Cash','540.00','540.00','3',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:26','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00064',NULL,'80.00','','','','',NULL,'80.00'),(33,'CB - Gokula','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000012','09:53:48 am','2024 12 12','admin','1','  Dine-in','  Cash','520.00','520.00','4',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:48','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00066',NULL,'80.00','','','','',NULL,'80.00'),(34,'CB - Mahabharata','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000012','09:53:48 am','2024 12 12','admin','1','  Dine-in','  Cash','520.00','520.00','5',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:48','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00071',NULL,'80.00','','','','',NULL,'80.00'),(35,'CB - Govinda','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000012','09:53:48 am','2024 12 12','admin','1','  Dine-in','  Cash','520.00','520.00','6',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:48','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00063',NULL,'80.00','','','','',NULL,'80.00'),(36,'CB - Ayodhya','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000012','09:53:48 am','2024 12 12','admin','1','  Dine-in','  Cash','520.00','520.00','7',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:48','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00064',NULL,'80.00','','','','',NULL,'80.00'),(37,'CB - Lord Krishnas Advent  Pastimes','1.0','200.00','200.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000012','09:53:48 am','2024 12 12','admin','1','  Dine-in','  Cash','520.00','520.00','8',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:48','%','0','200.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00072',NULL,'200.00','','','','',NULL,'200.00'),(38,'Sandal 100 Gms.','1.0','65.00','65.00','Item',NULL,NULL,'no','5','GST(5%)','20241212-1-000013','09:53:56 am','2024 12 12','admin','1','  Dine-in','  Cash','480.00','480.00','9',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:56','%','0','65.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DEVOTION','admin','madmin',NULL,NULL,'FG00359',NULL,'61.90','','','','',NULL,'61.90'),(39,'Sandal 250 Gms','1.0','135.00','135.00','Item',NULL,NULL,'no','5','GST(5%)','20241212-1-000013','09:53:56 am','2024 12 12','admin','1','  Dine-in','  Cash','480.00','480.00','10',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:56','%','0','135.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DEVOTION','admin','madmin',NULL,NULL,'FG00360',NULL,'128.57','','','','',NULL,'128.57'),(40,'CB - Lord Krishnas Advent  Pastimes','1.0','200.00','200.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000013','09:53:56 am','2024 12 12','admin','1','  Dine-in','  Cash','480.00','480.00','11',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:56','%','0','200.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00072',NULL,'200.00','','','','',NULL,'200.00'),(41,'CB - Mahabharata','1.0','80.00','80.00','Item',NULL,NULL,'no','0','GST(0%)','20241212-1-000013','09:53:56 am','2024 12 12','admin','1','  Dine-in','  Cash','480.00','480.00','12',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121209:53:56','%','0','80.00','no','0.00',NULL,'202412120953',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BOOK','admin','madmin',NULL,NULL,'FG00071',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,'20241025-1-000011','70.00','admin','2024 10 25','  Cash','  Dine-in','70.00','0.00','0.00','0.0','1','202410251133',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241120-1-000011','460.00','admin','2024 11 20','  Cash','  Dine-in','460.00','32.14','0.00','0.0','2','202411201459',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241120-1-000012','145.00','admin','2024 11 20','  Cash','  Dine-in','145.00','3.10','0.00','0.0','3','202411201500',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241120-1-000013','300.00','madmin','2024 11 20','  cash','  Dine-in','267.860000','32.140000','0.000000','0','4','20241120150001','','','','0','0',NULL),(5,'20241120-1-000014','440.00','admin','2024 11 20','  Cash','  Dine-in','440.00','0.00','0.00','0.0','5','202411201502',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241122-1-000011','460.00','madmin','2024 11 22','  cash','  Dine-in','427.860000','32.140000','0.000000','0','6','202411220933','','','','0','0',NULL),(7,'20241122-1-000012','580.00','madmin','2024 11 22','  cash','  Dine-in','561.900000','18.090000','0.000000','0','7','202411220933','','','','0','0',NULL),(8,'20241122-1-000013','644.99','madmin','2024 11 22','  cash','  Dine-in','602.370000','42.620000','0.000000','0','8','202411220933','','','','0','0',NULL),(9,'20241122-1-000014','400.00','madmin','2024 11 22','  cash','  Dine-in','378.570000','21.430000','0.000000','0','9','202411221149','','','','0','0',NULL),(10,'20241122-1-000015','380.00','madmin','2024 11 22','  cash','  Dine-in','347.860000','32.140000','0.000000','0','10','202411221149','','','','0','0',NULL),(11,'20241122-1-000016','444.99','madmin','2024 11 22','  cash','  Dine-in','423.800000','21.190000','0.000000','0','11','202411221150','','','','0','0',NULL),(12,'20241122-1-000021','660.00','madmin','2024 11 22','  cash','  Dine-in','627.860000','32.140000','0.000000','0','12','202411221220','','','','0','0',NULL),(13,'20241212-1-000011','540.00','admin','2024 12 12','  Cash','  Dine-in','540.00','32.14','0.00','0.0','13','202412120953',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20241212-1-000012','520.00','admin','2024 12 12','  Cash','  Dine-in','520.00','0.00','0.00','0.0','14','202412120953',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20241212-1-000013','480.00','admin','2024 12 12','  Cash','  Dine-in','480.00','9.52','0.00','0.0','15','202412120953',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20241120-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112003:001:009',NULL),(2,NULL,NULL,'20241122-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112209:33:11',NULL),(3,NULL,NULL,'20241122-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112209:33:39',NULL),(4,NULL,NULL,'20241122-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112209:33:54',NULL),(5,NULL,NULL,'20241122-1-000014',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112211:49:41',NULL),(6,NULL,NULL,'20241122-1-000015',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112211:49:56',NULL),(7,NULL,NULL,'20241122-1-000016',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112211:50:23',NULL),(8,NULL,NULL,'20241122-1-000021',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024112212:20:10',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Brass Laddu Gopal No.1 MH 266',300),(2,'CB - Ayodhya',80),(3,'CB - Govinda',80),(4,'CB - Mahabharata',80),(5,'Sandal 100 Gms.',65),(6,'Sandal 100 Gms.',65);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1','Brass Laddu Gopal No.1 MH 266',300,65,'1','DEVOTION',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'3','CB - Ayodhya',80,17,'1','BOOK',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'2','CB - Govinda',80,17,'1','BOOK',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'5','CB - Mahabharata',80,13,'1','BOOK',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'8','Sandal 100 Gms.',65,11,'1','DEVOTION',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','Sandal 100 Gms.',65,6,'1','DEVOTION',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'BOOK',160),(2,'DEVOTION',300),(5,'BOOK',240),(6,'DEVOTION',365),(7,'BOOK',320),(8,'DEVOTION',365),(9,'BOOK',760),(10,'DEVOTION',365);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',460);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',460,100);
