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,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000011','01:57:45 PM','2024 12 05','admin','1','  Dine-in','  Cash','35.00','35.00','1',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120513:57:45','%','0','35.00','no','0.00',NULL,'202412051357','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(2,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000012','01:59:49 PM','2024 12 05','admin','1','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120513:59:49','%','0','25.00','no','0.00',NULL,'202412051359','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(3,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000013','02:00:59 PM','2024 12 05','admin','1','  Dine-in','  Cash','70.00','70.00','3',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120514:00:59','%','0','40.00','no','0.00',NULL,'202412051400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(4,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000013','02:00:59 PM','2024 12 05','admin','1','  Dine-in','  Cash','70.00','70.00','4',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120514:00:59','%','0','30.00','no','0.00',NULL,'202412051400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(5,'tea','5.0','20.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000014','05:34:02 PM','2024 12 05','admin','1','  Dine-in','  Cash','125.00','125.00','5',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:34:02','%','0','100.00','no','0.00',NULL,'202412051734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'20.00'),(6,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000014','05:34:02 PM','2024 12 05','admin','1','  Dine-in','  Cash','125.00','125.00','6',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:34:02','%','0','25.00','no','0.00',NULL,'202412051734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'25.00'),(7,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000015','05:34:33 PM','2024 12 05','admin','1','  Takeaway','  Cash','50.00','50.00','7',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:34:33','%','0','25.00','no','0.00',NULL,'202412051734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(8,'lassi','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000015','05:34:33 PM','2024 12 05','admin','1','  Takeaway','  Cash','50.00','50.00','8',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:34:33','%','0','25.00','no','0.00',NULL,'202412051734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(9,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000016','05:35:21 PM','2024 12 05','admin','1','  Home delivery','  Cash','25.00','25.00','9',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:35:21','%','0','25.00','no','0.00',NULL,'202412051735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(10,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000017','05:37:12 PM','2024 12 05','admin','1','  Dine-in','  Upiqr','25.00','25.00','10',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:37:12','%','0','25.00','no','0.00',NULL,'202412051737','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(11,'lassi','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000018','05:38:15 PM','2024 12 05','admin','1','  Dine-in','  Cash','75.00','75.00','11',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:38:15','%','0','50.00','no','0.00',NULL,'202412051738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(12,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000018','05:38:15 PM','2024 12 05','admin','1','  Dine-in','  Cash','75.00','75.00','12',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:38:15','%','0','25.00','no','0.00',NULL,'202412051738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(13,'coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000021','05:43:46 PM','2024 12 05','admin','2','  Dine-in','  Cash','40.00','40.00','1',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:43:46','%','0','20.00','no','0.00',NULL,'202412051743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(14,'tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000021','05:43:46 PM','2024 12 05','admin','2','  Dine-in','  Cash','40.00','40.00','2',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:43:46','%','0','20.00','no','0.00',NULL,'202412051743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(15,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000019','05:46:21 PM','2024 12 05','admin','1','  Dine-in','  Cash','60.00','60.00','13',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:46:21','%','0','35.00','no','0.00',NULL,'202412051746','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(16,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000019','05:46:21 PM','2024 12 05','admin','1','  Dine-in','  Cash','60.00','60.00','14',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:46:21','%','0','25.00','no','0.00',NULL,'202412051746','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(17,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000081','05:49:13 PM','2024 12 05','admin','8','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:49:13','%','0','30.00','no','0.00',NULL,'202412051749','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(18,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000081','05:49:13 PM','2024 12 05','admin','8','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:49:13','%','0','30.00','no','0.00',NULL,'202412051749','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(19,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000091','05:49:48 PM','2024 12 05','admin','9','  Dine-in','  Cash','120.00','120.00','1',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:49:48','%','0','50.00','no','0.00',NULL,'202412051749','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(20,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000091','05:49:48 PM','2024 12 05','admin','9','  Dine-in','  Cash','120.00','120.00','2',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:49:48','%','0','70.00','no','0.00',NULL,'202412051749','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(21,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-000092','05:50:30 PM','2024 12 05','admin','9','  Dine-in','  Cash','50.00','50.00','3',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:50:30','%','0','50.00','no','0.00',NULL,'202412051750','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(22,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-0000110','05:53:21 PM','2024 12 05','admin','1','  Dine-in','  Cash','25.00','25.00','15',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:53:21','%','0','25.00','no','0.00',NULL,'202412051753','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(23,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-0000111','05:54:08 PM','2024 12 05','admin','1','  Dine-in','  Cash','40.00','40.00','16',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:54:08','%','0','40.00','no','0.00',NULL,'202412051754','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(24,'dosa','4.0','35.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20241205-1-0000112','05:59:49 PM','2024 12 05','admin','1','  Dine-in','  Cash','140.00','140.00','18',NULL,NULL,NULL,NULL,'05 Dec 2024','2024120517:59:49','%','0','140.00','no','0.00',NULL,'202412051759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'35.00'),(31,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000011','12:18:32 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','27',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:18:32','%','0','25.00','no','0.00',NULL,'202412161218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(32,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000011','12:18:32 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','28',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:18:32','%','0','35.00','no','0.00',NULL,'202412161218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(33,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000012','12:19:16 PM','2024 12 16','admin','1','  Dine-in','  Cash','70.00','70.00','29',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:19:16','%','0','40.00','no','0.00',NULL,'202412161219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(34,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000012','12:19:16 PM','2024 12 16','admin','1','  Dine-in','  Cash','70.00','70.00','30',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:19:16','%','0','30.00','no','0.00',NULL,'202412161219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(35,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000013','12:19:37 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','31',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:19:37','%','0','25.00','no','0.00',NULL,'202412161219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(36,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000013','12:19:37 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','32',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:19:37','%','0','35.00','no','0.00',NULL,'202412161219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(37,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000014','12:20:24 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','33',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:20:24','%','0','25.00','no','0.00',NULL,'202412161220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(38,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000014','12:20:24 PM','2024 12 16','admin','1','  Dine-in','  Cash','60.00','60.00','34',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:20:24','%','0','35.00','no','0.00',NULL,'202412161220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','Ashil',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(39,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000015','12:39:19 PM','2024 12 16','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:39:19','%','0','25.00','no','0.00',NULL,'202412161239','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(40,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000016','12:46:23 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:46:23','%','0','65.00','no','0.00',NULL,'202412161246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(41,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000016','12:46:23 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','3',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:46:23','%','0','65.00','no','0.00',NULL,'202412161246','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(42,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000017','12:59:51 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:59:51','%','0','65.00','no','0.00',NULL,'202412161259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(43,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000017','12:59:51 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:59:51','%','0','65.00','no','0.00',NULL,'202412161259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(44,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000018','01:15:10 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:15:10','%','0','65.00','no','0.00',NULL,'202412161315','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(45,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000018','01:15:10 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:15:10','%','0','65.00','no','0.00',NULL,'202412161315','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(46,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000019','01:16:02 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','3',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:16:02','%','0','65.00','no','0.00',NULL,'202412161316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(47,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-000019','01:16:02 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','4',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:16:02','%','0','65.00','no','0.00',NULL,'202412161316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(48,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000110','01:21:59 PM','2024 12 16','admin','1','  Dine-in','  Cash','195.00','195.00','5',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:21:59','%','0','65.00','no','0.00',NULL,'202412161321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(49,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000110','01:21:59 PM','2024 12 16','admin','1','  Dine-in','  Cash','195.00','195.00','6',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:21:59','%','0','65.00','no','0.00',NULL,'202412161321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(50,'orange','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000110','01:21:59 PM','2024 12 16','admin','1','  Dine-in','  Cash','195.00','195.00','7',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:21:59','%','0','65.00','no','0.00',NULL,'202412161321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(51,'orange','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000111','01:25:30 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','8',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:30','%','0','65.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(52,'pineapple','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000111','01:25:30 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','9',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:30','%','0','130.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,'65.00'),(53,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000111','01:25:30 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','10',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:30','%','0','65.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(54,'orange','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000112','01:25:52 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','11',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:52','%','0','65.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(55,'pineapple','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000112','01:25:52 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','12',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:52','%','0','130.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,'65.00'),(56,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000112','01:25:52 PM','2024 12 16','admin','1','  Dine-in','  Cash','260.00','260.00','13',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:25:52','%','0','65.00','no','0.00',NULL,'202412161325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(57,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000113','01:40:31 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:40:31','%','0','65.00','no','0.00',NULL,'202412161340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(58,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000113','01:40:31 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:40:31','%','0','65.00','no','0.00',NULL,'202412161340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(59,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000114','01:40:54 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','3',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:40:54','%','0','65.00','no','0.00',NULL,'202412161340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(60,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-1-0000114','01:40:54 PM','2024 12 16','admin','1','  Dine-in','  Cash','130.00','130.00','4',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121613:40:54','%','0','65.00','no','0.00',NULL,'202412161340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(61,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241218-1-000011','07:02:46 PM','2024 12 18','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'18 Dec 2024','2024121819:02:46','%','0','65.00','no','0.00',NULL,'202412181902','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(62,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241218-1-000011','07:02:46 PM','2024 12 18','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'18 Dec 2024','2024121819:02:46','%','0','65.00','no','0.00',NULL,'202412181902','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(63,'mango juice','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000011','02:11:19 PM','2024 12 21','admin','1','  Dine-in','  Cash','260.00','260.00','1',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:11:19','%','0','130.00','no','0.00',NULL,'202412211411','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,'65.00'),(64,'pineapple','2.0','65.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000011','02:11:19 PM','2024 12 21','admin','1','  Dine-in','  Cash','260.00','260.00','2',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:11:19','%','0','130.00','no','0.00',NULL,'202412211411','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,'65.00'),(65,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000012','02:12:03 PM','2024 12 21','admin','1','  Dine-in','  Upiqr','130.00','130.00','3',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:12:03','%','0','65.00','no','0.00',NULL,'202412211412','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin','0',NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(66,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000012','02:12:03 PM','2024 12 21','admin','1','  Dine-in','  Upiqr','130.00','130.00','4',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:12:03','%','0','65.00','no','0.00',NULL,'202412211412','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin','0',NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(67,'mango juice','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000013','02:13:13 PM','2024 12 21','admin','1','  Dine-in','  Cash','130.00','130.00','5',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:13:13','%','0','65.00','no','0.00',NULL,'202412211413','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(68,'pineapple','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241221-1-000013','02:13:13 PM','2024 12 21','admin','1','  Dine-in','  Cash','130.00','130.00','6',NULL,NULL,NULL,NULL,'21 Dec 2024','2024122114:13:13','%','0','65.00','no','0.00',NULL,'202412211413','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(69,'tea','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20220101-1-000011','05:44:12 AM','2022 01 01','admin','1','  Dine-in','  Cash','20.00','20.00','10',NULL,NULL,NULL,NULL,'01 Jan 2022','2022010105:44:12','%','0','20.00','no','0.00',NULL,'202201010544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(70,'tea','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20220101-1-000012','06:10:23 AM','2022 01 01','admin','1','  Dine-in','  Cash','20.00','20.00','11',NULL,NULL,NULL,NULL,'01 Jan 2022','2022010106:10:23','%','0','20.00','no','0.00',NULL,'202201010610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(73,'Porotta','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000011','03:17:20 PM','2024 12 22','admin','1','  Dine-in','  Cash','210.00','210.00','26',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:17:20','%','0','100.00','no','0.00',NULL,'202412221517','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'10.00'),(74,'Beef Roast','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000011','03:17:20 PM','2024 12 22','admin','1','  Dine-in','  Cash','210.00','210.00','27',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:17:20','%','0','110.00','no','0.00',NULL,'202412221517','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(75,'Porotta','3.0','10.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000012','03:33:40 PM','2024 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','31',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:33:40','%','0','30.00','no','0.00',NULL,'202412221533','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'10.00'),(76,'Chicken Roast','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000012','03:33:40 PM','2024 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','32',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:33:40','%','0','100.00','no','0.00',NULL,'202412221533','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curry','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(77,'Porotta','4.0','10.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000013','03:38:50 PM','2024 12 22','admin','1','  Dine-in','  Cash','40.00','40.00','33',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:38:50','%','0','40.00','no','0.00',NULL,'202412221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'10.00'),(78,'Kuboos roll','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000014','03:43:27 PM','2024 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','34',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:43:27','%','0','100.00','no','0.00',NULL,'202412221543','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shawarma roll','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(79,'Coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000014','03:43:27 PM','2024 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','35',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:43:27','%','0','20.00','no','0.00',NULL,'202412221543','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(80,'Rumali roll','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000015','03:56:20 PM','2024 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','36',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122215:56:20','%','0','120.00','no','0.00',NULL,'202412221556','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shawarma roll','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(81,'tea','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000016','04:14:36 PM','2024 12 22','admin','1','  Dine-in','  Cash','10.00','10.00','37',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:14:36','%','0','10.00','no','0.00',NULL,'202412221614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(82,'Grape juice','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000017','04:22:57 PM','2024 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','38',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:22:57','%','0','120.00','no','0.00',NULL,'202412221622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'60.00'),(83,'Porotta','10.0','10.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000018','04:35:16 PM','2024 12 22','admin','1','  Dine-in','  Cash','320.00','320.00','39',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:35:16','%','0','100.00','no','0.00',NULL,'202412221635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'10.00'),(84,'Beef Fry ','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000018','04:35:16 PM','2024 12 22','admin','1','  Dine-in','  Cash','320.00','320.00','40',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:35:16','%','0','110.00','no','0.00',NULL,'202412221635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(85,'Beef Roast','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000018','04:35:16 PM','2024 12 22','admin','1','  Dine-in','  Cash','320.00','320.00','41',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:35:16','%','0','110.00','no','0.00',NULL,'202412221635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(86,'tea','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-000019','04:36:59 PM','2024 12 22','admin','1','  Dine-in','  Cash','20.00','20.00','42',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:36:59','%','0','20.00','no','0.00',NULL,'202412221636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(87,'tea','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000110','04:56:22 PM','2024 12 22','admin','1','  Dine-in','  Cash','15.00','15.00','43',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122216:56:22','%','0','15.00','no','0.00',NULL,'202412221656','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(88,'chicken biriyani','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000111','05:08:54 PM','2024 12 22','admin','1','  Dine-in','  Cash','340.00','340.00','45',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122217:08:54','%','0','140.00','no','0.00',NULL,'202412221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Rice','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'140.00'),(89,'Porotta','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000111','05:08:54 PM','2024 12 22','admin','1','  Dine-in','  Cash','340.00','340.00','46',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122217:08:54','%','0','20.00','no','0.00',NULL,'202412221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bread','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(90,'Beef Fry ','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000111','05:08:54 PM','2024 12 22','admin','1','  Dine-in','  Cash','340.00','340.00','47',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122217:08:54','%','0','110.00','no','0.00',NULL,'202412221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curry','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(91,'pineapple juice','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000111','05:08:54 PM','2024 12 22','admin','1','  Dine-in','  Cash','340.00','340.00','48',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122217:08:54','%','0','60.00','no','0.00',NULL,'202412221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'juice','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(92,'tea','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241222-1-0000111','05:08:54 PM','2024 12 22','admin','1','  Dine-in','  Cash','340.00','340.00','49',NULL,NULL,NULL,NULL,'22 Dec 2024','2024122217:08:54','%','0','10.00','no','0.00',NULL,'202412221708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tea and coffee','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.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,'20241205-1-000011','35.00','admin','2024 12 05','  Cash','  Dine-in','35.00','0.00','0.00','0.0','1','202412051357',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241205-1-000012','25.00','admin','2024 12 05','  Cash','  Dine-in','25.00','0.00','0.00','0.0','2','202412051359',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241205-1-000013','70.00','admin','2024 12 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','3','202412051400',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241205-1-000014','125.00','admin','2024 12 05','  Cash','  Dine-in','125.00','0.00','0.00','0.0','4','202412051734',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241205-1-000015','50.00','admin','2024 12 05','  Cash','  Takeaway','50.00','0.00','0.00','0.0','5','202412051734',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241205-1-000016','25.00','admin','2024 12 05','  Cash','  Home delivery','25.00','0.00','0.00','0.0','6','202412051735',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241205-1-000017','25.00','admin','2024 12 05','  Upiqr','  Dine-in','25.00','0.00','0.00','0.0','7','202412051737',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20241205-1-000018','75.00','admin','2024 12 05','  Cash','  Dine-in','75.00','0.00','0.00','0.0','8','202412051738',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20241205-1-000021','40.00','admin','2024 12 05','  Cash','  Dine-in','40.00','0.00','0.00','0.0','9','202412051743',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20241205-1-000019','60.00','admin','2024 12 05','  Cash','  Dine-in','60.00','0.00','0.00','0.0','10','202412051746',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20241205-1-000081','60.00','admin','2024 12 05','  Cash','  Dine-in','60.00','0.00','0.00','0.0','11','202412051749',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20241205-1-000091','120.00','admin','2024 12 05','  Cash','  Dine-in','120.00','0.00','0.00','0.0','12','202412051749',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20241205-1-000092','50.00','admin','2024 12 05','  Cash','  Dine-in','50.00','0.00','0.00','0.0','13','202412051750',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20241205-1-0000110','25.00','admin','2024 12 05','  Cash','  Dine-in','25.00','0.00','0.00','0.0','14','202412051753',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20241205-1-0000111','40.00','admin','2024 12 05','  Cash','  Dine-in','40.00','0.00','0.00','0.0','15','202412051754',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20241205-1-0000112','140.00','admin','2024 12 05','  Cash','  Dine-in','140.00','0.00','0.00','0.0','16','202412051759',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20241216-1-000011','60.00','admin','2024 12 16','  Cash','  Dine-in','60.00','0.00','0.00','0.0','17','202412161218',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20241216-1-000012','70.00','admin','2024 12 16','  Cash','  Dine-in','70.00','0.00','0.00','0.0','18','202412161219',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20241216-1-000013','60.00','admin','2024 12 16','  Cash','  Dine-in','60.00','0.00','0.00','0.0','19','202412161219',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20241216-1-000014','60.00','admin','2024 12 16','  Cash','  Dine-in','60.00','0.00','0.00','0.0','20','202412161220',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20241216-1-000015','25.00','admin','2024 12 16','  Cash','  Dine-in','25.00','0.00','0.00','0.0','21','202412161239',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20241216-1-000016','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','22','202412161246',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20241216-1-000017','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','23','202412161259',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20241216-1-000018','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','24','202412161315',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20241216-1-000019','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','25','202412161316',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20241216-1-0000110','195.00','admin','2024 12 16','  Cash','  Dine-in','195.00','0.00','0.00','0.0','26','202412161321',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20241216-1-0000111','260.00','admin','2024 12 16','  Cash','  Dine-in','260.00','0.00','0.00','0.0','27','202412161325',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20241216-1-0000112','260.00','admin','2024 12 16','  Cash','  Dine-in','260.00','0.00','0.00','0.0','28','202412161325',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20241216-1-0000113','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','29','202412161340',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20241216-1-0000114','130.00','admin','2024 12 16','  Cash','  Dine-in','130.00','0.00','0.00','0.0','30','202412161340',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20241218-1-000011','130.00','admin','2024 12 18','  Cash','  Dine-in','130.00','0.00','0.00','0.0','31','202412181902',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20241221-1-000011','260.00','admin','2024 12 21','  Cash','  Dine-in','260.00','0.00','0.00','0.0','32','202412211411',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20241221-1-000012','130.00','admin','2024 12 21','  Upiqr','  Dine-in','130.00','0.00','0.00','0.0','33','202412211412',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20241221-1-000013','130.00','admin','2024 12 21','  Cash','  Dine-in','130.00','0.00','0.00','0.0','34','202412211413',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20220101-1-000011','20.00','admin','2022 01 01','  Cash','  Dine-in','20.00','0.00','0.00','0.0','35','202201010544',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20220101-1-000012','20.00','admin','2022 01 01','  Cash','  Dine-in','20.00','0.00','0.00','0.0','36','202201010610',NULL,NULL,NULL,NULL,NULL,NULL),(43,'20241222-1-000011','210.00','admin','2024 12 22','  Cash','  Dine-in','210.00','0.00','0.00','0.0','35','202412221517',NULL,NULL,NULL,NULL,NULL,NULL),(44,'20241222-1-000012','130.00','admin','2024 12 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','36','202412221533',NULL,NULL,NULL,NULL,NULL,NULL),(45,'20241222-1-000013','40.00','admin','2024 12 22','  Cash','  Dine-in','40.00','0.00','0.00','0.0','37','202412221538',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20241222-1-000014','120.00','admin','2024 12 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','38','202412221543',NULL,NULL,NULL,NULL,NULL,NULL),(47,'20241222-1-000015','120.00','admin','2024 12 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','39','202412221556',NULL,NULL,NULL,NULL,NULL,NULL),(48,'20241222-1-000016','10.00','admin','2024 12 22','  Cash','  Dine-in','10.00','0.00','0.00','0.0','40','202412221614',NULL,NULL,NULL,NULL,NULL,NULL),(49,'20241222-1-000017','120.00','admin','2024 12 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','41','202412221622',NULL,NULL,NULL,NULL,NULL,NULL),(50,'20241222-1-000018','320.00','admin','2024 12 22','  Cash','  Dine-in','320.00','0.00','0.00','0.0','42','202412221635',NULL,NULL,NULL,NULL,NULL,NULL),(51,'20241222-1-000019','20.00','admin','2024 12 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','43','202412221636',NULL,NULL,NULL,NULL,NULL,NULL),(52,'20241222-1-0000110','15.00','admin','2024 12 22','  Cash','  Dine-in','15.00','0.00','0.00','0.0','44','202412221656',NULL,NULL,NULL,NULL,NULL,NULL),(53,'20241222-1-0000111','340.00','admin','2024 12 22','  Cash','  Dine-in','340.00','0.00','0.00','0.0','45','202412221708',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 (1,'sh','9103982791','','alu',25,'0.0',NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'bread omlette',30),(2,'dosa',35),(3,'grape juice',125),(4,'idly',25),(5,'lassi',75),(6,'masal dosa',40),(7,'tea',100),(8,'pongal',30),(9,'tea',120),(10,'upma',30);
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,'7','bread omlette',30,7,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',35,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'37','grape juice',125,29,'5','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1','idly',25,6,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'36','lassi',75,17,'3','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'6','masal dosa',40,9,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'32','tea',100,23,'5','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'3','pongal',30,4,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'32','tea',120,16,'6','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'4','upma',30,4,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Drinks',300),(2,'Tiffin',130),(3,'Drinks',340),(4,'Tiffin',420),(5,'Drinks',340),(6,'Tiffin',485),(7,'Drinks',340),(8,'Tiffin',625);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',430);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',430,100);
