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,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000011','01:57:00 PM','2023 11 27','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112713:57:00','%','0','25.00','no','0.00',NULL,'202311271357','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000011','01:57:00 PM','2023 11 27','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112713:57:00','%','0','35.00','no','0.00',NULL,'202311271357','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000012','02:04:54 PM','2023 11 27','admin','1','  Dine-in','  Cash','60.00','60.00','3',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:04:54','%','0','25.00','no','0.00',NULL,'202311271404','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000012','02:04:54 PM','2023 11 27','admin','1','  Dine-in','  Cash','60.00','60.00','4',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:04:54','%','0','35.00','no','0.00',NULL,'202311271404','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000013','02:05:50 PM','2023 11 27','admin','1','  Dine-in','  Cash','25.00','25.00','5',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:05:50','%','0','25.00','no','0.00',NULL,'202311271405','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000014','02:06:01 PM','2023 11 27','admin','1','  Dine-in','  Cash','100.00','100.00','6',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:06:01','%','0','35.00','no','0.00',NULL,'202311271406','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000014','02:06:01 PM','2023 11 27','admin','1','  Dine-in','  Cash','100.00','100.00','7',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:06:01','%','0','30.00','no','0.00',NULL,'202311271406','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000014','02:06:01 PM','2023 11 27','admin','1','  Dine-in','  Cash','100.00','100.00','8',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112714:06:01','%','0','35.00','no','0.00',NULL,'202311271406','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'sweetd','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000017','03:41:55 PM','2023 11 27','admin','1','  Dine-in','  Cash','140.00','140.00','12',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112715:41:55','%','0','100.00','no','0.00',NULL,'202311271541','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000017','03:41:55 PM','2023 11 27','admin','1','  Dine-in','  Cash','140.00','140.00','13',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112715:41:55','%','0','20.00','no','0.00',NULL,'202311271541','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000017','03:41:55 PM','2023 11 27','admin','1','  Dine-in','  Cash','140.00','140.00','14',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112715:41:55','%','0','20.00','no','0.00',NULL,'202311271541','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000031','04:06:49 PM','2023 11 27','admin','3','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112716:06:49','%','0','20.00','no','0.00',NULL,'202311271606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000031','04:06:49 PM','2023 11 27','admin','3','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112716:06:49','%','0','20.00','no','0.00',NULL,'202311271606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000031','04:06:49 PM','2023 11 27','admin','3','  Dine-in','  Cash','60.00','60.00','3',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112716:06:49','%','0','20.00','no','0.00',NULL,'202311271606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'sweetd','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231127-1-000018','04:19:56 PM','2023 11 27','admin','1','  Dine-in','  Cash','100.00','100.00','18',NULL,NULL,NULL,NULL,'27 Nov 2023','2023112716:19:56','%','0','100.00','no','0.00',NULL,'202311271619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-1-000011','02:51:17 PM','2024 07 30','admin','1','  Dine-in','  Cash','120.00','120.00','1',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073014:51:17','%','0','25.00','no','0.00',NULL,'202407301451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(17,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-1-000011','02:51:17 PM','2024 07 30','admin','1','  Dine-in','  Cash','120.00','120.00','2',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073014:51:17','%','0','35.00','no','0.00',NULL,'202407301451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(18,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240730-1-000011','02:51:17 PM','2024 07 30','admin','1','  Dine-in','  Cash','120.00','120.00','3',NULL,NULL,NULL,NULL,'30 Jul 2024','2024073014:51:17','%','0','60.00','no','0.00',NULL,'202407301451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(19,'rice','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000011','01:16:36 PM','2024 07 31','admin','1','  Dine-in','  Cash','280.00','280.00','4',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073113:16:36','%','0','30.00','no','0.00',NULL,'202407311316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(20,'paneer butter masala','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000011','01:16:36 PM','2024 07 31','admin','1','  Dine-in','  Cash','280.00','280.00','5',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073113:16:36','%','0','60.00','no','0.00',NULL,'202407311316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(21,'idly','6.0','25.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000011','01:16:36 PM','2024 07 31','admin','1','  Dine-in','  Cash','280.00','280.00','6',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073113:16:36','%','0','150.00','no','0.00',NULL,'202407311316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'150.00','','','','',NULL,'25.00'),(22,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240731-1-000011','01:16:36 PM','2024 07 31','admin','1','  Dine-in','  Cash','280.00','280.00','7',NULL,NULL,NULL,NULL,'31 Jul 2024','2024073113:16:36','%','0','40.00','no','0.00',NULL,'202407311316','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(23,'chicken sukka','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','1',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','160.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,'80.00'),(24,'coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','2',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','20.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(25,'tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','3',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','20.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(26,'veg thali','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','4',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','50.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(27,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','5',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','100.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(28,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','6',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','70.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(29,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000021','09:50:06 AM','2024 08 10','admin','2','  Dine-in','  Cash','500.00','500.00','7',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:06','%','0','80.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(30,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000031','09:50:18 AM','2024 08 10','admin','3','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:18','%','0','10.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(31,'lime juice','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000031','09:50:18 AM','2024 08 10','admin','3','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:18','%','0','15.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(32,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','8',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','70.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(33,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','9',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','100.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(34,'veg thali','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','10',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','50.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(35,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','11',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','80.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(36,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','12',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','25.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(37,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-1-000011','09:50:33 AM','2024 08 10','admin','1','  Dine-in','  Cash','360.00','360.00','13',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081009:50:33','%','0','35.00','no','0.00',NULL,'202408100950','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(38,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-1-000011','11:02:05 PM','2024 08 13','admin','1','  Dine-in','  Cash','190.00','190.00','14',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081323:02:05','%','0','50.00','no','0.00',NULL,'202408132302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(39,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-1-000011','11:02:05 PM','2024 08 13','admin','1','  Dine-in','  Cash','190.00','190.00','15',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081323:02:05','%','0','70.00','no','0.00',NULL,'202408132302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(40,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-1-000011','11:02:05 PM','2024 08 13','admin','1','  Dine-in','  Cash','190.00','190.00','16',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081323:02:05','%','0','30.00','no','0.00',NULL,'202408132302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(41,'butterscotch icecream','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240813-1-000011','11:02:05 PM','2024 08 13','admin','1','  Dine-in','  Cash','190.00','190.00','17',NULL,NULL,NULL,NULL,'13 Aug 2024','2024081323:02:05','%','0','40.00','no','0.00',NULL,'202408132302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.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,'20231127-1-000011','60.00','admin','2023 11 27','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1','202311271357',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20231127-1-000012','60.00','admin','2023 11 27','  Cash','  Dine-in','60.00','0.00','0.00','0.0','2','202311271404',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20231127-1-000013','25.00','admin','2023 11 27','  Cash','  Dine-in','25.00','0.00','0.00','0.0','3','202311271405',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20231127-1-000014','100.00','admin','2023 11 27','  Cash','  Dine-in','100.00','0.00','0.00','0.0','4','202311271406',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20231127-1-000014','100.00','admin','2023 11 27','  Cash','  Dine-in','100.00','0','0.00','0.0','5','202311271406',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20231127-1-000014','100.00','admin','2023 11 27','  Cash','  Dine-in','100.00','0','0.00','0.0','6','202311271406',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20231127-1-000017','140.00','admin','2023 11 27','  Cash','  Dine-in','140.00','0.00','0.00','0.0','7','202311271541',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20231127-1-000031','60.00','admin','2023 11 27','  Cash','  Dine-in','60.00','0.00','0.00','0.0','8','202311271606',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20231127-1-000018','100.00','admin','2023 11 27','  Cash','  Dine-in','100.00','0.00','0.00','0.0','9','202311271619',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240730-1-000011','120.00','admin','2024 07 30','  Cash','  Dine-in','120.00','0.00','0.00','0.0','1','202407301451',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240731-1-000011','280.00','admin','2024 07 31','  Cash','  Dine-in','280.00','0.00','0.00','0.0','2','202407311316',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240810-1-000021','500.00','admin','2024 08 10','  Cash','  Dine-in','500.00','0.00','0.00','0.0','3','202408100950',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240810-1-000031','25.00','admin','2024 08 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','4','202408100950',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240810-1-000011','360.00','admin','2024 08 10','  Cash','  Dine-in','360.00','0.00','0.00','0.0','5','202408100950',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240813-1-000011','190.00','admin','2024 08 13','  Cash','  Dine-in','190.00','0.00','0.00','0.0','6','202408132302',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'salary','20000','Rent','madmin','madmin','27 Nov 2023','04:24 PM','202311271624');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'dosa',105),(2,'idly',75),(3,'masal vada',40),(4,'poori',35),(5,'samosa',20),(6,'sweetd',100),(7,'upma',30),(8,'vada',40);
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,'2','dosa',105,16,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','idly',75,12,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'12','masal vada',40,6,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'5','poori',35,5,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'13','samosa',20,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'41','sweetd',100,16,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'4','upma',30,5,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'11','vada',40,6,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (4,'None',100),(5,'Snacks',100),(6,'Tiffin',245);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',645);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',645,100);
