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,'20230120-1-000011','04:46:06 PM','2023 01 20','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'20 Jan 2023','2023012016:46:06','%','0','25.00','no','0.00',NULL,'202301201646','',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,'20230120-1-000011','04:46:06 PM','2023 01 20','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'20 Jan 2023','2023012016:46:06','%','0','35.00','no','0.00',NULL,'202301201646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240402-1-000011','09:42:30 AM','2024 04 02','admin','1','  Dine-in','  Cash','65.00','65.00','1',NULL,NULL,NULL,NULL,'02 Apr 2024','2024040209:42:30','%','0','35.00','no','0.00',NULL,'202404020942','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(4,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240402-1-000011','09:42:30 AM','2024 04 02','admin','1','  Dine-in','  Cash','65.00','65.00','2',NULL,NULL,NULL,NULL,'02 Apr 2024','2024040209:42:30','%','0','30.00','no','0.00',NULL,'202404020942','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(5,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240403-1-000011','05:38:28 PM','2024 04 03','admin','1','  Dine-in','  Card','1.00','1.00','2',NULL,NULL,NULL,NULL,'03 Apr 2024','2024040317:38:28','%','0','1.00','no','0.00',NULL,'202404031738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(6,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000011','11:04:24 AM','2024 04 04','admin','1','  Dine-in','  Cash','1.00','1.00','3',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:04:24','%','0','1.00','no','0.00',NULL,'202404041104','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(7,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000012','11:33:52 AM','2024 04 04','admin','1','  Dine-in','  Cash','66.00','66.00','6',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:33:52','%','0','1.00','no','0.00',NULL,'202404041133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(8,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000012','11:33:52 AM','2024 04 04','admin','1','  Dine-in','  Cash','66.00','66.00','7',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:33:52','%','0','35.00','no','0.00',NULL,'202404041133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(9,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000012','11:33:52 AM','2024 04 04','admin','1','  Dine-in','  Cash','66.00','66.00','8',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:33:52','%','0','30.00','no','0.00',NULL,'202404041133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(10,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000013','11:34:25 AM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','9',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:34:25','%','0','35.00','no','0.00',NULL,'202404041134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(11,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000013','11:34:25 AM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','10',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:34:25','%','0','30.00','no','0.00',NULL,'202404041134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(12,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000013','11:34:25 AM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','11',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:34:25','%','0','30.00','no','0.00',NULL,'202404041134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(13,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000014','11:44:58 AM','2024 04 04','admin','1','  Dine-in','  Cash','1.00','1.00','12',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040411:44:58','%','0','1.00','no','0.00',NULL,'202404041144','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(14,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000015','12:07:49 PM','2024 04 04','admin','1','  Dine-in','  Cash','1.00','1.00','13',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:07:49','%','0','1.00','no','0.00',NULL,'202404041207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(15,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000016','12:11:06 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','14',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:11:06','%','0','35.00','no','0.00',NULL,'202404041211','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(16,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000016','12:11:06 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','15',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:11:06','%','0','30.00','no','0.00',NULL,'202404041211','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(17,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000017','12:44:05 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','16',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:44:05','%','0','35.00','no','0.00',NULL,'202404041244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(18,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000017','12:44:05 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','17',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:44:05','%','0','30.00','no','0.00',NULL,'202404041244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(19,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000017','12:44:05 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','18',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:44:05','%','0','30.00','no','0.00',NULL,'202404041244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(20,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000018','12:48:19 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','19',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:48:19','%','0','35.00','no','0.00',NULL,'202404041248','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(21,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000018','12:48:19 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','20',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040412:48:19','%','0','30.00','no','0.00',NULL,'202404041248','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(22,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000019','01:24:35 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','21',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040413:24:35','%','0','35.00','no','0.00',NULL,'202404041324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(23,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-000019','01:24:35 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','22',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040413:24:35','%','0','30.00','no','0.00',NULL,'202404041324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(24,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000110','01:41:27 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','23',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040413:41:27','%','0','35.00','no','0.00',NULL,'202404041341','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(25,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000110','01:41:27 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','24',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040413:41:27','%','0','30.00','no','0.00',NULL,'202404041341','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(26,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000110','01:41:27 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','25',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040413:41:27','%','0','30.00','no','0.00',NULL,'202404041341','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(27,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000111','02:00:04 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','26',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040414:00:04','%','0','35.00','no','0.00',NULL,'202404041400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(28,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000111','02:00:04 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','27',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040414:00:04','%','0','30.00','no','0.00',NULL,'202404041400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(29,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000112','02:05:14 PM','2024 04 04','admin','1','  Dine-in','  Cash','1.00','1.00','30',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040414:05:14','%','0','1.00','no','0.00',NULL,'202404041405','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(30,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000113','03:00:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','96.00','96.00','37',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040415:00:58','%','0','1.00','no','0.00',NULL,'202404041500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(31,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000113','03:00:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','96.00','96.00','38',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040415:00:58','%','0','30.00','no','0.00',NULL,'202404041500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(32,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000113','03:00:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','96.00','96.00','39',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040415:00:58','%','0','30.00','no','0.00',NULL,'202404041500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(33,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000113','03:00:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','96.00','96.00','41',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040415:00:58','%','0','35.00','no','0.00',NULL,'202404041500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(34,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000114','04:13:39 PM','2024 04 04','admin','1','  Dine-in','  Cash','35.00','35.00','42',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:13:39','%','0','35.00','no','0.00',NULL,'202404041613','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(35,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000115','04:15:16 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','43',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:16','%','0','35.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(36,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000115','04:15:16 PM','2024 04 04','admin','1','  Dine-in','  Cash','65.00','65.00','44',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:16','%','0','30.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(37,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000116','04:15:36 PM','2024 04 04','admin','1','  Dine-in','  Cash','140.00','140.00','45',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:36','%','0','35.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(38,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000116','04:15:36 PM','2024 04 04','admin','1','  Dine-in','  Cash','140.00','140.00','46',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:36','%','0','30.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(39,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000116','04:15:36 PM','2024 04 04','admin','1','  Dine-in','  Cash','140.00','140.00','47',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:36','%','0','35.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(40,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000116','04:15:36 PM','2024 04 04','admin','1','  Dine-in','  Cash','140.00','140.00','48',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:15:36','%','0','40.00','no','0.00',NULL,'202404041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(41,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000117','04:39:01 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','49',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:39:01','%','0','35.00','no','0.00',NULL,'202404041639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(42,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000117','04:39:01 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','50',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:39:01','%','0','30.00','no','0.00',NULL,'202404041639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(43,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000117','04:39:01 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','51',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:39:01','%','0','30.00','no','0.00',NULL,'202404041639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(44,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000117','04:39:01 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','52',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:39:01','%','0','35.00','no','0.00',NULL,'202404041639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(45,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000118','04:43:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','100.00','100.00','53',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:43:58','%','0','35.00','no','0.00',NULL,'202404041643','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(46,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000118','04:43:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','100.00','100.00','54',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:43:58','%','0','30.00','no','0.00',NULL,'202404041643','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(47,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000118','04:43:58 PM','2024 04 04','admin','1','  Dine-in','  Cash','100.00','100.00','55',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:43:58','%','0','35.00','no','0.00',NULL,'202404041643','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(48,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000119','04:53:44 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','56',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:53:44','%','0','35.00','no','0.00',NULL,'202404041653','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(49,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000119','04:53:44 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','57',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:53:44','%','0','30.00','no','0.00',NULL,'202404041653','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(50,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000119','04:53:44 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','58',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:53:44','%','0','30.00','no','0.00',NULL,'202404041653','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(51,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000120','04:57:41 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','59',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:57:41','%','0','35.00','no','0.00',NULL,'202404041657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(52,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000120','04:57:41 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','60',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:57:41','%','0','30.00','no','0.00',NULL,'202404041657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(53,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000120','04:57:41 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','61',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:57:41','%','0','30.00','no','0.00',NULL,'202404041657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(54,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000120','04:57:41 PM','2024 04 04','admin','1','  Dine-in','  Cash','130.00','130.00','62',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040416:57:41','%','0','35.00','no','0.00',NULL,'202404041657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(55,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000121','05:02:00 PM','2024 04 04','admin','1','  Dine-in','  Cash','35.00','35.00','63',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:02:00','%','0','35.00','no','0.00',NULL,'202404041702','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(56,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000122','05:07:19 PM','2024 04 04','admin','1','  Dine-in','  Cash','35.00','35.00','64',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:07:19','%','0','35.00','no','0.00',NULL,'202404041707','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(57,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000123','05:13:54 PM','2024 04 04','admin','1','  Dine-in','  Cash','35.00','35.00','65',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:13:54','%','0','35.00','no','0.00',NULL,'202404041713','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(58,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000124','05:17:53 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','66',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:17:53','%','0','35.00','no','0.00',NULL,'202404041717','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(59,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000124','05:17:53 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','67',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:17:53','%','0','30.00','no','0.00',NULL,'202404041717','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(60,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000124','05:17:53 PM','2024 04 04','admin','1','  Dine-in','  Cash','95.00','95.00','68',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:17:53','%','0','30.00','no','0.00',NULL,'202404041717','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(61,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000125','05:30:37 PM','2024 04 04','admin','1','  Dine-in','  Cash','1.00','1.00','69',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:30:37','%','0','1.00','no','0.00',NULL,'202404041730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(62,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240404-1-0000126','05:31:31 PM','2024 04 04','admin','1','  Dine-in','  Card','1.00','1.00','70',NULL,NULL,NULL,NULL,'04 Apr 2024','2024040417:31:31','%','0','1.00','no','0.00',NULL,'202404041731','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(63,'Armenian Burger','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','05:04:13 AM','2024 07 29','admin','1','  Dine-in','  Cash','53.28','53.28','9',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072905:04:13','%','0','10.00','no','0.00',NULL,'202407290504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Batchig Items','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(64,'Lebanese Burger','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','05:04:13 AM','2024 07 29','admin','1','  Dine-in','  Cash','53.28','53.28','10',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072905:04:13','%','0','10.00','no','0.00',NULL,'202407290504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Batchig Items','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(65,'Soujouk Merguez','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','05:04:13 AM','2024 07 29','admin','1','  Dine-in','  Cash','53.28','53.28','11',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072905:04:13','%','0','10.00','no','0.00',NULL,'202407290504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Batchig Items','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(66,'Chicken Burger','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','05:04:13 AM','2024 07 29','admin','1','  Dine-in','  Cash','53.28','53.28','12',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072905:04:13','%','0','10.00','no','0.00',NULL,'202407290504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Batchig Items','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(67,'Chicken ceasar Sandwich','1.0','8.00','8.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','05:04:13 AM','2024 07 29','admin','1','  Dine-in','  Cash','53.28','53.28','13',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072905:04:13','%','0','8.00','no','0.00',NULL,'202407290504','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Batchig Items','admin','madmin',NULL,NULL,'',NULL,'8.00','','','','',NULL,'8.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,'20230120-1-000011','60.00','admin','2023 01 20','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1','202301201646',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240402-1-000011','65.00','admin','2024 04 02','  Cash','  Dine-in','65.00','0.00','0.00','0.0','1','202404020942',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240403-1-000011','1.00','admin','2024 04 03','  Card','  Dine-in','1.00','0.00','0.00','0.0','2','202404031738',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240404-1-000011','1.00','admin','2024 04 04','  Cash','  Dine-in','1.00','0.00','0.00','0.0','3','202404041104',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240404-1-000012','66.00','admin','2024 04 04','  Cash','  Dine-in','66.00','0.00','0.00','0.0','4','202404041133',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240404-1-000013','95.00','admin','2024 04 04','  Cash','  Dine-in','95.00','0.00','0.00','0.0','5','202404041134',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240404-1-000014','1.00','admin','2024 04 04','  Cash','  Dine-in','1.00','0.00','0.00','0.0','6','202404041144',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240404-1-000015','1.00','admin','2024 04 04','  Cash','  Dine-in','1.00','0.00','0.00','0.0','7','202404041207',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240404-1-000016','65.00','admin','2024 04 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','8','202404041211',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240404-1-000017','95.00','admin','2024 04 04','  Cash','  Dine-in','95.00','0.00','0.00','0.0','9','202404041244',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240404-1-000018','65.00','admin','2024 04 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','10','202404041248',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240404-1-000019','65.00','admin','2024 04 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','11','202404041324',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240404-1-0000110','95.00','admin','2024 04 04','  Cash','  Dine-in','95.00','0.00','0.00','0.0','12','202404041341',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240404-1-0000111','65.00','admin','2024 04 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','13','202404041400',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240404-1-0000112','1.00','admin','2024 04 04','  Cash','  Dine-in','1.00','0.00','0.00','0.0','14','202404041405',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240404-1-0000113','96.00','admin','2024 04 04','  Cash','  Dine-in','96.00','0.00','0.00','0.0','15','202404041500',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240404-1-0000114','35.00','admin','2024 04 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','16','202404041613',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240404-1-0000115','65.00','admin','2024 04 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','17','202404041615',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240404-1-0000116','140.00','admin','2024 04 04','  Cash','  Dine-in','140.00','0.00','0.00','0.0','18','202404041615',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240404-1-0000117','130.00','admin','2024 04 04','  Cash','  Dine-in','130.00','0.00','0.00','0.0','19','202404041639',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240404-1-0000118','100.00','admin','2024 04 04','  Cash','  Dine-in','100.00','0.00','0.00','0.0','20','202404041643',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240404-1-0000119','95.00','admin','2024 04 04','  Cash','  Dine-in','95.00','0.00','0.00','0.0','21','202404041653',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240404-1-0000120','130.00','admin','2024 04 04','  Cash','  Dine-in','130.00','0.00','0.00','0.0','22','202404041657',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240404-1-0000121','35.00','admin','2024 04 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','23','202404041702',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240404-1-0000122','35.00','admin','2024 04 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','24','202404041707',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240404-1-0000123','35.00','admin','2024 04 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','25','202404041713',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240404-1-0000124','95.00','admin','2024 04 04','  Cash','  Dine-in','95.00','0.00','0.00','0.0','26','202404041717',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240404-1-0000125','1.00','admin','2024 04 04','  Cash','  Dine-in','1.00','0.00','0.00','0.0','27','202404041730',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240404-1-0000126','1.00','admin','2024 04 04','  Card','  Dine-in','1.00','0.00','0.00','0.0','28','202404041731',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240729-1-000011','53.28','admin','2024 07 29','  Cash','  Dine-in','48.00','5.28','0.00','11.0','1','202407290504',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'dosa',70),(2,'idly',3),(3,'pongal',60),(4,'upma',30),(5,'Soujouk Merguez',10);
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',70,43,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','idly',3,2,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'3','pongal',60,37,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'4','upma',30,18,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'3','Soujouk Merguez',10,21,'1','Batchig Items',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',163),(3,'Batchig Items',48);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',163);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',163,100);
