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,'20240823-1-000011','01:07:22 PM','2024 08 23','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082313:07:22','%','0','25.00','no','0.00',NULL,'202408231307','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('10','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240827-1-000012','01:39:47 PM','2024 08 27','admin','1','  Dine-in','  Card','1.00','1.00','8',NULL,NULL,NULL,NULL,'27 Aug 2024','2024082713:39:47','%','0','1.00','no','0.00',NULL,'202408271339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('100','dosa','1.0','35.70','35.70','Item',NULL,NULL,'no','2','cgst(2%)','20241104-1-000016','03:21:28 PM','2024 11 04','admin','1','  Dine-in','  Cash','17.85','35.70','9',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110415:21:28','%','0','35.70','no','0.00',NULL,'202411041521','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('101','dosa','1.0','35.70','35.70','Item',NULL,NULL,'no','2','cgst(2%)','20241104-1-000017','05:46:30 PM','2024 11 04','admin','1','  Dine-in','  Cash','17.85','35.70','10',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110417:46:30','%','0','35.70','no','0.00',NULL,'202411041746','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('102','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241105-1-000011','06:37:44 PM','2024 11 05','admin','1','  Dine-in','  Cash','72.40','72.40','11',NULL,NULL,NULL,NULL,'05 Nov 2024','2024110518:37:44','%','0','1.00','no','0.00',NULL,'202411051837','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('103','dosa','2.0','35.70','71.40','Item',NULL,NULL,'no','2','cgst(2%)','20241105-1-000011','06:37:44 PM','2024 11 05','admin','1','  Dine-in','  Cash','72.40','72.40','12',NULL,NULL,NULL,NULL,'05 Nov 2024','2024110518:37:44','%','0','71.40','no','0.00',NULL,'202411051837','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),('104','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241105-1-000012','07:15:24 PM','2024 11 05','admin','1','  Dine-in','  Cash','46.70','46.70','13',NULL,NULL,NULL,NULL,'05 Nov 2024','2024110519:15:24','%','0','1.00','no','0.00',NULL,'202411051915','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('105','dosa','1.0','35.70','35.70','Item',NULL,NULL,'no','2','cgst(2%)','20241105-1-000012','07:15:24 PM','2024 11 05','admin','1','  Dine-in','  Cash','46.70','46.70','14',NULL,NULL,NULL,NULL,'05 Nov 2024','2024110519:15:24','%','0','35.70','no','0.00',NULL,'202411051915','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('106','chicken biryani 1','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241105-1-000012','07:15:24 PM','2024 11 05','admin','1','  Dine-in','  Cash','46.70','46.70','15',NULL,NULL,NULL,NULL,'05 Nov 2024','2024110519:15:24','%','0','10.00','no','0.00',NULL,'202411051915','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),('107','poori','4.0','35.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20241119-1-000011','12:45:32 PM','2024 11 19','admin','1','  Dine-in','  Cash','140.00','140.00','1',NULL,NULL,NULL,NULL,'19 Nov 2024','2024111912:45:32','%','0','140.00','no','0.00',NULL,'202411191245','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'35.00'),('108','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241126-1-000011','11:54:18 AM','2024 11 26','admin','1','  Dine-in','  Upiqr','1.00','1.00','1',NULL,NULL,NULL,NULL,'26 Nov 2024','2024112611:54:18','%','0','1.00','no','0.00',NULL,'202411261154','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('109','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241126-1-000012','11:57:24 AM','2024 11 26','admin','1','  Dine-in','  Cash','36.70','36.70','4',NULL,NULL,NULL,NULL,'26 Nov 2024','2024112611:57:24','%','0','1.00','no','0.00',NULL,'202411261157','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('11','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240902-1-000011','07:38:29 PM','2024 09 02','admin','1','  Dine-in','  Card','1.00','1.00','9',NULL,NULL,NULL,NULL,'02 Sep 2024','2024090219:38:29','%','0','1.00','no','0.00',NULL,'202409021938','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('110','dosa','1.0','35.70','35.70','Item',NULL,NULL,'no','2','None','20241126-1-000012','11:57:24 AM','2024 11 26','admin','1','  Dine-in','  Cash','36.70','36.70','5',NULL,NULL,NULL,NULL,'26 Nov 2024','2024112611:57:24','%','0','35.70','no','0.00',NULL,'202411261157','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('111','idly','3.0','25.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','1',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','75.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'75.00','','','','',NULL,'25.00'),('112','dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','2',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','70.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),('113','upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','3',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','30.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('114','bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','4',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','30.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('115','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','5',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','35.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('116','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241127-1-000014','02:38:03 PM','2024 11 27','admin','1','  Dine-in','  Cash','270.00','275.00','6',NULL,NULL,NULL,NULL,'27 Nov 2024','2024112714:38:03','%','0','35.00','no','0.00',NULL,'202411271438','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('117','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000011','01:34:46 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','1',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:34:46','%','0','35.00','no','0.00',NULL,'202412041334','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('118','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000011','01:34:46 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','2',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:34:46','%','0','25.00','no','0.00',NULL,'202412041334','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('119','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000011','01:34:46 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','3',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:34:46','%','0','30.00','no','0.00',NULL,'202412041334','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('12','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240903-1-000011','07:45:44 PM','2024 09 03','admin','1','  Dine-in','  Card','1.00','1.00','10',NULL,NULL,NULL,NULL,'03 Sep 2024','2024090319:45:44','%','0','1.00','no','0.00',NULL,'202409031945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('120','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000012','01:35:08 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','4',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:35:08','%','0','35.00','no','0.00',NULL,'202412041335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('121','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000012','01:35:08 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','5',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:35:08','%','0','30.00','no','0.00',NULL,'202412041335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('122','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000012','01:35:08 pm','2024 12 04','admin','1','  Dine-in','  Cash','90.00','90.00','6',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:35:08','%','0','25.00','no','0.00',NULL,'202412041335','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('123','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000013','01:38:14 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','4',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:38:14','%','0','35.00','no','0.00',NULL,'202412041338','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('124','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000013','01:38:14 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','5',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:38:14','%','0','30.00','no','0.00',NULL,'202412041338','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('125','idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000013','01:38:14 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','6',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:38:14','%','0','50.00','no','0.00',NULL,'202412041338','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),('126','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000014','01:39:47 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','4',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:39:47','%','0','35.00','no','0.00',NULL,'202412041339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('127','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000014','01:39:47 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','5',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:39:47','%','0','30.00','no','0.00',NULL,'202412041339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('128','idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000014','01:39:47 pm','2024 12 04','admin','1','  Dine-in','  Cash','115.00','115.00','6',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:39:47','%','0','50.00','no','0.00',NULL,'202412041339','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),('129','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000015','01:40:05 pm','2024 12 04','admin','1','  Dine-in','  Cash','130.00','130.00','7',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:40:05','%','0','35.00','no','0.00',NULL,'202412041340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('13','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240903-1-000012','08:18:22 PM','2024 09 03','admin','1','  Dine-in','  Card','1.00','1.00','11',NULL,NULL,NULL,NULL,'03 Sep 2024','2024090320:18:22','%','0','1.00','no','0.00',NULL,'202409032018','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('130','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000015','01:40:05 pm','2024 12 04','admin','1','  Dine-in','  Cash','130.00','130.00','8',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:40:05','%','0','35.00','no','0.00',NULL,'202412041340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('131','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000015','01:40:05 pm','2024 12 04','admin','1','  Dine-in','  Cash','130.00','130.00','9',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:40:05','%','0','30.00','no','0.00',NULL,'202412041340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('132','upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241204-1-000015','01:40:05 pm','2024 12 04','admin','1','  Dine-in','  Cash','130.00','130.00','10',NULL,NULL,NULL,NULL,'04 Dec 2024','2024120413:40:05','%','0','30.00','no','0.00',NULL,'202412041340','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('133','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000011','10:28:39 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','11',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:28:39','%','0','25.00','no','0.00',NULL,'202412101028','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('134','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000011','10:28:39 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','12',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:28:39','%','0','35.00','no','0.00',NULL,'202412101028','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('135','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000012','10:29:00 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','13',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:00','%','0','25.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('136','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000012','10:29:00 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','14',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:00','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('137','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000013','10:29:09 am','2024 12 10','admin','1','  Dine-in','  Cash','70.00','70.00','15',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:09','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('138','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000013','10:29:09 am','2024 12 10','admin','1','  Dine-in','  Cash','70.00','70.00','16',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:09','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('139','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000014','10:29:20 am','2024 12 10','admin','1','  Dine-in','  Cash','70.00','70.00','17',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:20','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('14','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240903-1-000013','08:21:20 PM','2024 09 03','admin','1','  Dine-in','  Upiqr','1.00','1.00','12',NULL,NULL,NULL,NULL,'03 Sep 2024','2024090320:21:20','%','0','1.00','no','0.00',NULL,'202409032021','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('140','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000014','10:29:20 am','2024 12 10','admin','1','  Dine-in','  Cash','70.00','70.00','18',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:20','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('141','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000015','10:29:30 am','2024 12 10','admin','1','  Dine-in','  Cash','65.00','65.00','19',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:30','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('142','bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000015','10:29:30 am','2024 12 10','admin','1','  Dine-in','  Cash','65.00','65.00','20',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:30','%','0','30.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('143','uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000016','10:29:40 am','2024 12 10','admin','1','  Dine-in','  Cash','50.00','50.00','21',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:40','%','0','30.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('144','vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000016','10:29:40 am','2024 12 10','admin','1','  Dine-in','  Cash','50.00','50.00','22',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:40','%','0','20.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),('145','rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000017','10:29:56 am','2024 12 10','admin','1','  Dine-in','  Cash','75.00','75.00','23',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:56','%','0','35.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('146','masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000017','10:29:56 am','2024 12 10','admin','1','  Dine-in','  Cash','75.00','75.00','24',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:29:56','%','0','40.00','no','0.00',NULL,'202412101029','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),('147','sheekh kabab','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000018','10:30:32 am','2024 12 10','admin','1','  Dine-in','  Cash','100.00','100.00','25',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:32','%','0','80.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),('148','masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000018','10:30:32 am','2024 12 10','admin','1','  Dine-in','  Cash','100.00','100.00','26',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:32','%','0','20.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),('149','pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000019','10:30:38 am','2024 12 10','admin','1','  Dine-in','  Cash','120.00','120.00','27',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:38','%','0','60.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),('15','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-1-000011','09:25:45 AM','2024 09 04','admin','1','  Dine-in','  Upiqr','1.00','1.00','13',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090409:25:45','%','0','1.00','no','0.00',NULL,'202409040925','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('150','chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000019','10:30:38 am','2024 12 10','admin','1','  Dine-in','  Cash','120.00','120.00','28',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:38','%','0','60.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),('151','samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000110','10:30:44 am','2024 12 10','admin','1','  Dine-in','  Cash','50.00','50.00','29',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:44','%','0','20.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),('152','uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000110','10:30:44 am','2024 12 10','admin','1','  Dine-in','  Cash','50.00','50.00','30',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:30:44','%','0','30.00','no','0.00',NULL,'202412101030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('153','pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000111','10:38:51 am','2024 12 10','admin','1','  Dine-in','  Cash','105.00','105.00','31',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:38:51','%','0','35.00','no','0.00',NULL,'202412101038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('154','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000111','10:38:51 am','2024 12 10','admin','1','  Dine-in','  Cash','105.00','105.00','32',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:38:51','%','0','35.00','no','0.00',NULL,'202412101038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('155','rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000111','10:38:51 am','2024 12 10','admin','1','  Dine-in','  Cash','105.00','105.00','33',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121010:38:51','%','0','35.00','no','0.00',NULL,'202412101038','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('156','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000112','11:03:30 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121011:03:30','%','0','25.00','no','0.00',NULL,'202412101103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('157','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000112','11:03:30 am','2024 12 10','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121011:03:30','%','0','35.00','no','0.00',NULL,'202412101103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('158','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000113','11:05:59 am','2024 12 10','admin','1','  Dine-in','  Cash','95.00','95.00','1',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121011:05:59','%','0','25.00','no','0.00',NULL,'202412101105','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('159','dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000113','11:05:59 am','2024 12 10','admin','1','  Dine-in','  Cash','95.00','95.00','2',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121011:05:59','%','0','70.00','no','0.00',NULL,'202412101105','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),('16','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-1-000012','10:30:41 AM','2024 09 04','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090410:30:41','%','0','25.00','no','0.00',NULL,'202409041030','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('160','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000031','03:33:44 PM','2024 12 10','admin','3','  Takeaway','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:33:44','%','0','25.00','no','0.00',NULL,'202412101533','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('161','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-000031','03:33:44 PM','2024 12 10','admin','3','  Takeaway','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:33:44','%','0','35.00','no','0.00',NULL,'202412101533','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('162','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000114','03:45:14 pm','2024 12 10','admin','1','  Dine-in','  Cash','125.00','125.00','1',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:45:14','%','0','25.00','no','0.00',NULL,'202412101545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('163','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000114','03:45:14 pm','2024 12 10','admin','1','  Dine-in','  Cash','125.00','125.00','2',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:45:14','%','0','35.00','no','0.00',NULL,'202412101545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('164','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000114','03:45:14 pm','2024 12 10','admin','1','  Dine-in','  Cash','125.00','125.00','3',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:45:14','%','0','35.00','no','0.00',NULL,'202412101545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('165','upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241210-1-0000114','03:45:14 pm','2024 12 10','admin','1','  Dine-in','  Cash','125.00','125.00','4',NULL,NULL,NULL,NULL,'10 Dec 2024','2024121015:45:14','%','0','30.00','no','0.00',NULL,'202412101545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('166','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241217-1-000011','10:46:59 AM','2024 12 17','admin','1','  Dine-in','  Upiqr','1.00','1.00','1',NULL,NULL,NULL,NULL,'17 Dec 2024','2024121710:46:59','%','0','1.00','no','0.00',NULL,'202412171046','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('17','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-1-000013','10:32:10 AM','2024 09 04','admin','1','  Dine-in','  Cash','35.00','35.00','2',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090410:32:10','%','0','35.00','no','0.00',NULL,'202409041032','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('18','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-1-000014','03:18:08 PM','2024 09 04','admin','1','  Dine-in','  Card','1.00','1.00','1',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090415:18:08','%','0','1.00','no','0.00',NULL,'202409041518','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('19','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-1-000015','03:42:38 PM','2024 09 04','admin','1','  Dine-in','  Upiqr','1.00','1.00','2',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090415:42:38','%','0','1.00','no','0.00',NULL,'202409041542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('2','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-1-000012','01:07:56 PM','2024 08 23','admin','1','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082313:07:56','%','0','25.00','no','0.00',NULL,'202408231307','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('20','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000011','09:42:54 AM','2024 09 05','admin','1','  Dine-in','  Cash','1.00','1.00','3',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:42:54','%','0','1.00','no','0.00',NULL,'202409050942','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('21','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000012','09:43:02 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','4',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:43:02','%','0','35.00','no','0.00',NULL,'202409050943','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('22','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000012','09:43:02 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','5',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:43:02','%','0','35.00','no','0.00',NULL,'202409050943','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('23','poori','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000013','09:44:03 AM','2024 09 05','admin','1','  Dine-in','  Cash','145.00','145.00','6',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:03','%','0','70.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'70.00','','','','',NULL,'35.00'),('24','masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000013','09:44:03 AM','2024 09 05','admin','1','  Dine-in','  Cash','145.00','145.00','7',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:03','%','0','40.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),('25','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000013','09:44:03 AM','2024 09 05','admin','1','  Dine-in','  Cash','145.00','145.00','8',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:03','%','0','35.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('26','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000014','09:44:14 AM','2024 09 05','admin','1','  Dine-in','  Cash','65.00','65.00','9',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:14','%','0','35.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('27','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000014','09:44:14 AM','2024 09 05','admin','1','  Dine-in','  Cash','65.00','65.00','10',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:14','%','0','30.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('28','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000015','09:44:42 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','11',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:42','%','0','35.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('29','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000015','09:44:42 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','12',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:44:42','%','0','35.00','no','0.00',NULL,'202409050944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('3','pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-1-000013','01:08:45 PM','2024 08 23','admin','1','  Dine-in','  Cash','35.00','35.00','3',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082313:08:45','%','0','35.00','no','0.00',NULL,'202408231308','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('30','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000016','09:45:19 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','13',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:45:19','%','0','35.00','no','0.00',NULL,'202409050945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('31','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000016','09:45:19 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','14',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:45:19','%','0','35.00','no','0.00',NULL,'202409050945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('32','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000017','09:47:33 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','15',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:47:33','%','0','35.00','no','0.00',NULL,'202409050947','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('33','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000017','09:47:33 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','16',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090509:47:33','%','0','35.00','no','0.00',NULL,'202409050947','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('34','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000018','10:17:49 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','17',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:17:49','%','0','35.00','no','0.00',NULL,'202409051017','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('35','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000018','10:17:49 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','18',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:17:49','%','0','35.00','no','0.00',NULL,'202409051017','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('36','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000019','10:23:53 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','19',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:23:53','%','0','35.00','no','0.00',NULL,'202409051023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('37','poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000019','10:23:53 AM','2024 09 05','admin','1','  Dine-in','  Cash','70.00','70.00','20',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:23:53','%','0','35.00','no','0.00',NULL,'202409051023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('38','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-0000110','10:46:52 AM','2024 09 05','admin','1','  Dine-in','  Card','1.00','1.00','25',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:46:52','%','0','1.00','no','0.00',NULL,'202409051046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('39','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-0000111','12:53:35 PM','2024 09 05','admin','1','  Dine-in','  Card','1.00','1.00','26',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090512:53:35','%','0','1.00','no','0.00',NULL,'202409051253','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('4','bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-1-000014','01:09:30 PM','2024 08 23','admin','1','  Dine-in','  Cash','30.00','30.00','4',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082313:09:30','%','0','30.00','no','0.00',NULL,'202408231309','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('40','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-0000112','03:39:57 PM','2024 09 05','admin','1','  Dine-in','  Cash','35.00','35.00','1',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090515:39:57','%','0','35.00','no','0.00',NULL,'202409051539','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('41','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','03:23:22 PM','2024 09 12','admin','1','  Dine-in','  Upiqr','1.00','1.00','1',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091215:23:22','%','0','1.00','no','0.00',NULL,'202409121523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('42','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000012','03:23:51 PM','2024 09 12','admin','1','  Dine-in','  Card','1.00','1.00','2',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091215:23:51','%','0','1.00','no','0.00',NULL,'202409121523','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('43','masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000011','10:26:55 AM','2024 09 16','admin','1','  Dine-in','  Cash','85.00','85.00','4',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:26:55','%','0','20.00','no','0.00',NULL,'202409161026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),('44','bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000012','10:27:21 AM','2024 09 16','admin','1','  Dine-in','  Cash','130.00','130.00','5',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:27:21','%','0','30.00','no','0.00',NULL,'202409161027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('45','onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000012','10:27:21 AM','2024 09 16','admin','1','  Dine-in','  Cash','130.00','130.00','6',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:27:21','%','0','35.00','no','0.00',NULL,'202409161027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('46','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000012','10:27:21 AM','2024 09 16','admin','1','  Dine-in','  Cash','130.00','130.00','7',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:27:21','%','0','30.00','no','0.00',NULL,'202409161027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('47','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000012','10:27:21 AM','2024 09 16','admin','1','  Dine-in','  Cash','130.00','130.00','8',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:27:21','%','0','35.00','no','0.00',NULL,'202409161027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('48','idly','1.0','1.15','1.15','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20240916-1-000013','10:29:54 AM','2024 09 16','admin','1','  Dine-in','  Cash','172.04','172.04','9',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:29:54','%','0','1.15','no','0.00',NULL,'202409161029','','sgst(2.5%)','2.5','tax(10%)','10',NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('49','dosa','1.0','40.25','40.25','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20240916-1-000013','10:29:54 AM','2024 09 16','admin','1','  Dine-in','  Cash','172.04','172.04','10',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:29:54','%','0','40.25','no','0.00',NULL,'202409161029','','sgst(2.5%)','2.5','tax(10%)','10',NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('5','idly','2.0','1.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20240825-1-000011','12:39:06 PM','2024 08 25','admin','1','  Dine-in','  Cash','2.00','2.00','1',NULL,NULL,NULL,NULL,'25 Aug 2024','2024082512:39:06','%','0','2.00','no','0.00',NULL,'202408251239','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('50','pongal','1.0','34.50','34.50','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20240916-1-000013','10:29:54 AM','2024 09 16','admin','1','  Dine-in','  Cash','172.04','172.04','11',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:29:54','%','0','34.50','no','0.00',NULL,'202409161029','','sgst(2.5%)','2.5','tax(10%)','10',NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('51','upma','1.0','34.50','34.50','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20240916-1-000013','10:29:54 AM','2024 09 16','admin','1','  Dine-in','  Cash','172.04','172.04','12',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:29:54','%','0','34.50','no','0.00',NULL,'202409161029','','sgst(2.5%)','2.5','tax(10%)','10',NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('52','masal dosa','1.0','46.00','46.00','Item',NULL,NULL,'no','2.5','cgst(2.5%)','20240916-1-000013','10:29:54 AM','2024 09 16','admin','1','  Dine-in','  Cash','172.04','172.04','13',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:29:54','%','0','46.00','no','0.00',NULL,'202409161029','','sgst(2.5%)','2.5','tax(10%)','10',NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),('53','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000014','10:31:34 AM','2024 09 16','admin','1','  Dine-in','  Cash','65.00','65.00','14',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:31:34','%','0','35.00','no','0.00',NULL,'202409161031','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('54','bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240916-1-000014','10:31:34 AM','2024 09 16','admin','1','  Dine-in','  Cash','65.00','65.00','15',NULL,NULL,NULL,NULL,'16 Sep 2024','2024091610:31:34','%','0','30.00','no','0.00',NULL,'202409161031','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('55','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-1-000011','11:55:52 AM','2024 09 17','admin','1','  Dine-in','  Cash','35.00','35.00','1',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091711:55:52','%','0','35.00','no','0.00',NULL,'202409171155','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('56','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-1-000011','09:29:21 AM','2024 09 19','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091909:29:21','%','0','25.00','no','0.00',NULL,'202409190929','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('57','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-1-000011','09:29:21 AM','2024 09 19','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091909:29:21','%','0','35.00','no','0.00',NULL,'202409190929','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('58','chicken biriyani','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240923-1-000012','08:12:59 PM','2024 09 23','admin','1','  Dine-in','  Cash','200.00','200.00','4',NULL,NULL,NULL,NULL,'23 Sep 2024','2024092320:12:59','%','0','200.00','no','0.00',NULL,'202409232012','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'200.00','','','','',NULL,'100.00'),('59','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000011','05:59:03 PM','2024 09 24','admin','1','  Dine-in','  Cash','36.00','36.00','1',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:03','%','0','1.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('6','idly','2.0','1.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20240826-1-000011','07:15:07 PM','2024 08 26','admin','1','  Dine-in','  Cash','2.00','2.00','2',NULL,NULL,NULL,NULL,'26 Aug 2024','2024082619:15:07','%','0','2.00','no','0.00',NULL,'202408261915','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('60','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000011','05:59:03 PM','2024 09 24','admin','1','  Dine-in','  Cash','36.00','36.00','2',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:03','%','0','35.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('61','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000012','05:59:20 PM','2024 09 24','admin','1','  Dine-in','  Cash','110.00','110.00','3',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:20','%','0','30.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('62','masal dosa','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000012','05:59:20 PM','2024 09 24','admin','1','  Dine-in','  Cash','110.00','110.00','4',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:20','%','0','80.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'40.00'),('63','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000013','05:59:47 PM','2024 09 24','admin','1','  Dine-in','  Cash','66.00','66.00','5',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:47','%','0','1.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('64','pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000013','05:59:47 PM','2024 09 24','admin','1','  Dine-in','  Cash','66.00','66.00','6',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:47','%','0','30.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('65','dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240924-1-000013','05:59:47 PM','2024 09 24','admin','1','  Dine-in','  Cash','66.00','66.00','7',NULL,NULL,NULL,NULL,'24 Sep 2024','2024092417:59:47','%','0','35.00','no','0.00',NULL,'202409241759','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('66','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2.0','cgst(2%)','20241003-1-000011','05:29:07 PM','2024 10 03','admin','1','  Dine-in','  Upiqr','1.02','1.02','1',NULL,NULL,NULL,NULL,'03 Oct 2024','2024100317:29:07','%','0','1.02','no','0.00',NULL,'202410031729',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('67','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241003-1-000012','05:29:32 PM','2024 10 03','admin','1','  Dine-in','  Cash','1.02','1.02','2',NULL,NULL,NULL,NULL,'03 Oct 2024','2024100317:29:32','%','0','1.02','no','0.00',NULL,'202410031729','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('68','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000011','10:27:29 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','3',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:27:29','%','0','1.02','no','0.00',NULL,'202410041027','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('69','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000012','10:45:11 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','4',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:45:11','%','0','1.02','no','0.00',NULL,'202410041045','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('7','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240826-1-000012','07:15:31 PM','2024 08 26','admin','1','  Dine-in','  Card','1.00','1.00','3',NULL,NULL,NULL,NULL,'26 Aug 2024','2024082619:15:31','%','0','1.00','no','0.00',NULL,'202408261915','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('70','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000013','10:47:29 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','5',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:47:29','%','0','1.02','no','0.00',NULL,'202410041047','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('71','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000014','10:54:47 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','6',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:54:47','%','0','1.02','no','0.00',NULL,'202410041054','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('72','pongal','1.0','30.60','30.60','Item',NULL,NULL,'no','2.0','cgst(2%)','20241004-1-000015','10:55:18 AM','2024 10 04','admin','1','  Dine-in','  Cash','30.60','30.60','7',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:55:18','%','0','30.60','no','0.00',NULL,'202410041055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('73','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000016','10:56:15 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','8',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100410:56:15','%','0','1.02','no','0.00',NULL,'202410041056','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('74','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000017','11:25:37 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','9',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100411:25:37','%','0','1.02','no','0.00',NULL,'202410041125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('75','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000018','11:26:03 AM','2024 10 04','admin','1','  Dine-in','  Cash','1.02','1.02','10',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100411:26:03','%','0','1.02','no','0.00',NULL,'202410041126','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('76','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-000019','11:33:08 AM','2024 10 04','admin','1','  Dine-in','  Upiqr','1.02','1.02','11',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100411:33:08','%','0','1.02','no','0.00',NULL,'202410041133','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('77','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-0000110','01:12:01 PM','2024 10 04','admin','1','  Dine-in','  Card','1.02','1.02','13',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100413:12:01','%','0','1.02','no','0.00',NULL,'202410041312','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('78','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241004-1-0000111','07:10:22 PM','2024 10 04','admin','1','  Dine-in','  Card','1.02','1.02','14',NULL,NULL,NULL,NULL,'04 Oct 2024','2024100419:10:22','%','0','1.02','no','0.00',NULL,'202410041910','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('79','idly','2.0','1.02','2.04','Item',NULL,NULL,'no','2','cgst(2%)','20241007-1-000011','12:16:48 PM','2024 10 07','admin','1','  Dine-in','  Cash','2.04','2.04','15',NULL,NULL,NULL,NULL,'07 Oct 2024','2024100712:16:48','%','0','2.04','no','0.00',NULL,'202410071216','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('8','idly','2.0','1.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20240826-1-000013','07:17:25 PM','2024 08 26','admin','1','  Dine-in','  Card','2.00','2.00','4',NULL,NULL,NULL,NULL,'26 Aug 2024','2024082619:17:25','%','0','2.00','no','0.00',NULL,'202408261917','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('80','idly','2.0','1.02','2.04','Item',NULL,NULL,'no','2','cgst(2%)','20241007-1-000012','12:33:53 PM','2024 10 07','admin','1','  Dine-in','  Cash','2.04','2.04','16',NULL,NULL,NULL,NULL,'07 Oct 2024','2024100712:33:53','%','0','2.04','no','0.00',NULL,'202410071233','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('81','idly','2.0','1.02','2.04','Item',NULL,NULL,'no','2','cgst(2%)','20241007-1-000013','12:58:13 PM','2024 10 07','admin','1','  Dine-in','  Cash','2.04','2.04','17',NULL,NULL,NULL,NULL,'07 Oct 2024','2024100712:58:13','%','0','2.04','no','0.00',NULL,'202410071258','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'2.00','','','','',NULL,'1.00'),('82','idly','1.0','1.02','1.02','Item',NULL,NULL,'no','2','cgst(2%)','20241007-1-000014','02:48:32 PM','2024 10 07','admin','1','  Dine-in','  Upiqr','1.02','1.02','19',NULL,NULL,NULL,NULL,'07 Oct 2024','2024100714:48:32','%','0','1.02','no','0.00',NULL,'202410071448','123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('83','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000011','12:23:26 PM','2024 10 15','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101512:23:26','%','0','25.00','no','0.00',NULL,'202410151223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('84','roti','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000012','02:51:13 PM','2024 10 15','admin','1','  Dine-in','  Cash','200.00','200.00','2',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101514:51:13','%','0','15.00','no','0.00',NULL,'202410151451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin','0',NULL,'',NULL,'15.00','','','','',NULL,'15.00'),('85','rice','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000012','02:51:13 PM','2024 10 15','admin','1','  Dine-in','  Cash','200.00','200.00','3',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101514:51:13','%','0','30.00','no','0.00',NULL,'202410151451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00'),('86','non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000012','02:51:13 PM','2024 10 15','admin','1','  Dine-in','  Cash','200.00','200.00','4',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101514:51:13','%','0','80.00','no','0.00',NULL,'202410151451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),('87','masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000012','02:51:13 PM','2024 10 15','admin','1','  Dine-in','  Cash','200.00','200.00','5',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101514:51:13','%','0','35.00','no','0.00',NULL,'202410151451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),('88','masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000012','02:51:13 PM','2024 10 15','admin','1','  Dine-in','  Cash','200.00','200.00','6',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101514:51:13','%','0','40.00','no','0.00',NULL,'202410151451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),('89','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241021-1-000012','01:02:01 PM','2024 10 21','admin','1','  Dine-in','  Cash','12.50','25.00','1',NULL,NULL,NULL,NULL,'21 Oct 2024','2024102113:02:01','%','0','25.00','no','0.00',NULL,'202410211302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('9','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240827-1-000011','11:22:03 AM','2024 08 27','admin','1','  Dine-in','  Card','1.00','1.00','7',NULL,NULL,NULL,NULL,'27 Aug 2024','2024082711:22:03','%','0','1.00','no','0.00',NULL,'202408271122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('90','idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241021-1-000013','01:02:10 PM','2024 10 21','admin','1','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'21 Oct 2024','2024102113:02:10','%','0','25.00','no','0.00',NULL,'202410211302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('91','idly','1.0','25.50','25.50','Item',NULL,NULL,'no','2','None','20241022-1-000011','03:43:30 PM','2024 10 22','admin','1','  Dine-in','  Cash','25.50','25.50','1',NULL,NULL,NULL,NULL,'22 Oct 2024','2024102215:43:30','%','0','25.50','no','0.00',NULL,'202410221543','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),('92','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-1-000011','12:17:40 PM','2024 10 24','admin','1','  Dine-in','  Upiqr','1.00','1.00','1',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102412:17:40','%','0','1.00','no','0.00',NULL,'202410241217','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('93','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241024-1-000012','03:27:31 PM','2024 10 24','admin','1','  Dine-in','  Upiqr','1.00','1.00','3',NULL,NULL,NULL,NULL,'24 Oct 2024','2024102415:27:31','%','0','1.00','no','0.00',NULL,'202410241527','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('94','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000011','11:45:40 AM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','4',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110411:45:40','%','0','1.00','no','0.00',NULL,'202411041145','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('95','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000012','11:49:04 AM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','5',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110411:49:04','%','0','1.00','no','0.00',NULL,'202411041149','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('96','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000013','12:50:41 PM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','6',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110412:50:41','%','0','1.00','no','0.00',NULL,'202411041250','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('97','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000013','12:58:01 PM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','6',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110412:58:01','%','0','1.00','no','0.00',NULL,'202411041258','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('98','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000014','02:50:00 PM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','7',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110414:50:00','%','0','1.00','no','0.00',NULL,'202411041450','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),('99','idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20241104-1-000015','03:21:05 PM','2024 11 04','admin','1','  Dine-in','  Cash','1.00','1.00','8',NULL,NULL,NULL,NULL,'04 Nov 2024','2024110415:21:05','%','0','1.00','no','0.00',NULL,'202411041521','20aa3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.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,'20240823-1-000011','25.00','admin','2024 08 23','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202408231307',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240823-1-000012','25.00','admin','2024 08 23','  Cash','  Dine-in','25.00','0.00','0.00','0.0','2','202408231307',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240823-1-000013','35.00','admin','2024 08 23','  Cash','  Dine-in','35.00','0.00','0.00','0.0','3','202408231308',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240823-1-000014','30.00','admin','2024 08 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','4','202408231309',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240825-1-000011','2.00','admin','2024 08 25','  Cash','  Dine-in','2.00','0.00','0.00','0.0','5','202408251239',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240826-1-000011','2.00','admin','2024 08 26','  Cash','  Dine-in','2.00','0.00','0.00','0.0','6','202408261915',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240826-1-000012','1.00','admin','2024 08 26','  Card','  Dine-in','1.00','0.00','0.00','0.0','7','202408261915',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240826-1-000013','2.00','admin','2024 08 26','  Card','  Dine-in','2.00','0.00','0.00','0.0','8','202408261917',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240827-1-000011','1.00','admin','2024 08 27','  Card','  Dine-in','1.00','0.00','0.00','0.0','9','202408271122',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240827-1-000012','1.00','admin','2024 08 27','  Card','  Dine-in','1.00','0.00','0.00','0.0','10','202408271339',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240902-1-000011','1.00','admin','2024 09 02','  Card','  Dine-in','1.00','0.00','0.00','0.0','11','202409021938',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240903-1-000011','1.00','admin','2024 09 03','  Card','  Dine-in','1.00','0.00','0.00','0.0','12','202409031945',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240903-1-000012','1.00','admin','2024 09 03','  Card','  Dine-in','1.00','0.00','0.00','0.0','13','202409032018',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240903-1-000013','1.00','admin','2024 09 03','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','14','202409032021',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240904-1-000011','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','15','202409040925',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240904-1-000012','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','16','202409041426',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240909-1-000011','1.00','admin','2024 09 09','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','17','202409091556',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240910-1-000011','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','18','202409101432',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240910-1-000012','35.00','admin','2024 09 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','19','202409101611',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240910-1-000013','35.00','admin','2024 09 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','20','202409101622',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240910-1-000014','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','21','202409101634',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240910-1-000015','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','22','202409101750',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240910-1-000016','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','23','202409101837',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240910-1-000017','1.00','admin','2024 09 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','24','202409101839',NULL,NULL,NULL,NULL,NULL,NULL),(474,'20240903-1-000011','70.00','admin','2024 09 03','  Cash','  Dine-in','70.00','0.00','0.00','0.0','352','202409031101',NULL,NULL,NULL,NULL,NULL,NULL),(475,'20240904-1-000012','25.00','admin','2024 09 04','  Cash','  Dine-in','25.00','0.00','0.00','0.0','353','202409041030',NULL,NULL,NULL,NULL,NULL,NULL),(476,'20240904-1-000013','35.00','admin','2024 09 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','354','202409041032',NULL,NULL,NULL,NULL,NULL,NULL),(477,'20240904-1-000014','1.00','admin','2024 09 04','  Card','  Dine-in','1.00','0.00','0.00','0.0','355','202409041518',NULL,NULL,NULL,NULL,NULL,NULL),(478,'20240904-1-000015','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','356','202409041542',NULL,NULL,NULL,NULL,NULL,NULL),(479,'20240905-1-000011','1.00','admin','2024 09 05','  Cash','  Dine-in','1.00','0.00','0.00','0.0','357','202409050942',NULL,NULL,NULL,NULL,NULL,NULL),(480,'20240905-1-000012','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','358','202409050943',NULL,NULL,NULL,NULL,NULL,NULL),(481,'20240905-1-000013','145.00','admin','2024 09 05','  Cash','  Dine-in','145.00','0.00','0.00','0.0','359','202409050944',NULL,NULL,NULL,NULL,NULL,NULL),(482,'20240905-1-000014','65.00','admin','2024 09 05','  Cash','  Dine-in','65.00','0.00','0.00','0.0','360','202409050944',NULL,NULL,NULL,NULL,NULL,NULL),(483,'20240905-1-000015','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','361','202409050944',NULL,NULL,NULL,NULL,NULL,NULL),(484,'20240905-1-000016','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','362','202409050945',NULL,NULL,NULL,NULL,NULL,NULL),(485,'20240905-1-000017','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','363','202409050947',NULL,NULL,NULL,NULL,NULL,NULL),(486,'20240905-1-000018','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','364','202409051017',NULL,NULL,NULL,NULL,NULL,NULL),(487,'20240905-1-000019','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','365','202409051023',NULL,NULL,NULL,NULL,NULL,NULL),(488,'20240905-1-0000110','1.00','admin','2024 09 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','366','202409051046',NULL,NULL,NULL,NULL,NULL,NULL),(489,'20240905-1-0000111','1.00','admin','2024 09 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','367','202409051253',NULL,NULL,NULL,NULL,NULL,NULL),(490,'20240905-1-0000112','35.00','admin','2024 09 05','  Cash','  Dine-in','35.00','0.00','0.00','0.0','368','202409051539',NULL,NULL,NULL,NULL,NULL,NULL),(491,'20240912-000011','1.00','admin','2024 09 12','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','369','202409121523',NULL,NULL,NULL,NULL,NULL,NULL),(492,'20240912-000012','1.00','admin','2024 09 12','  Card','  Dine-in','1.00','0.00','0.00','0.0','370','202409121523',NULL,NULL,NULL,NULL,NULL,NULL),(493,'20240916-1-000013','172.04','admin','2024 09 16','  Cash','  Dine-in','156.40','36.04','0.00','10.0','371','202409161029',NULL,NULL,NULL,NULL,NULL,NULL),(494,'20240916-1-000014','65.00','admin','2024 09 16','  Cash','  Dine-in','65.00','0.00','0.00','0.0','372','202409161031',NULL,NULL,NULL,NULL,NULL,NULL),(495,'20240917-1-000011','35.00','admin','2024 09 17','  Cash','  Dine-in','35.00','0.00','0.00','0.0','373','202409171155',NULL,NULL,NULL,NULL,NULL,NULL),(496,'20240918-1-000012','35.00','user1','2024 09 18','  Cash','  Dine-in','35.00','0.00','0.00','0.0','374','202409181509',NULL,NULL,NULL,NULL,NULL,NULL),(497,'20240919-1-000011','60.00','admin','2024 09 19','  Cash','  Dine-in','60.00','0.00','0.00','0.0','375','202409190929',NULL,NULL,NULL,NULL,NULL,NULL),(498,'20240924-1-000011','36.00','admin','2024 09 24','  Cash','  Dine-in','36.00','0.00','0.00','0.0','376','202409241759',NULL,NULL,NULL,NULL,NULL,NULL),(499,'20240924-1-000012','110.00','admin','2024 09 24','  Cash','  Dine-in','110.00','0.00','0.00','0.0','377','202409241759',NULL,NULL,NULL,NULL,NULL,NULL),(500,'20240924-1-000013','66.00','admin','2024 09 24','  Cash','  Dine-in','66.00','0.00','0.00','0.0','378','202409241759',NULL,NULL,NULL,NULL,NULL,NULL),(501,'20241003-1-000011','1.02','admin','2024 10 03','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','379','202410031729',NULL,NULL,NULL,NULL,NULL,NULL),(502,'20241003-1-000012','1.02','admin','2024 10 03','  Cash','  Dine-in','1.02','0.02','0.00','0.0','380','202410031729',NULL,NULL,NULL,NULL,NULL,NULL),(503,'20241004-1-000011','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','381','202410041027',NULL,NULL,NULL,NULL,NULL,NULL),(504,'20241004-1-000012','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','382','202410041045',NULL,NULL,NULL,NULL,NULL,NULL),(505,'20241004-1-000013','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','383','202410041047',NULL,NULL,NULL,NULL,NULL,NULL),(506,'20241004-1-000014','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','384','202410041054',NULL,NULL,NULL,NULL,NULL,NULL),(507,'20241004-1-000015','30.60','admin','2024 10 04','  Cash','  Dine-in','30.60','0.60','0.00','0.0','385','202410041055',NULL,NULL,NULL,NULL,NULL,NULL),(508,'20241004-1-000016','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','386','202410041056',NULL,NULL,NULL,NULL,NULL,NULL),(509,'20241004-1-000017','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','387','202410041125',NULL,NULL,NULL,NULL,NULL,NULL),(510,'20241004-1-000018','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','388','202410041126',NULL,NULL,NULL,NULL,NULL,NULL),(511,'20241004-1-000019','1.02','admin','2024 10 04','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','389','202410041133',NULL,NULL,NULL,NULL,NULL,NULL),(512,'20241004-1-0000110','1.02','admin','2024 10 04','  Card','  Dine-in','1.02','0.02','0.00','0.0','390','202410041312',NULL,NULL,NULL,NULL,NULL,NULL),(513,'20241004-1-0000111','1.02','admin','2024 10 04','  Card','  Dine-in','1.02','0.02','0.00','0.0','391','202410041910',NULL,NULL,NULL,NULL,NULL,NULL),(514,'20241007-1-000011','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','392','202410071216',NULL,NULL,NULL,NULL,NULL,NULL),(515,'20241007-1-000012','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','393','202410071233',NULL,NULL,NULL,NULL,NULL,NULL),(516,'20241007-1-000013','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','394','202410071258',NULL,NULL,NULL,NULL,NULL,NULL),(517,'20241007-1-000014','1.02','admin','2024 10 07','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','395','202410071448',NULL,NULL,NULL,NULL,NULL,NULL),(518,'20241015-1-000011','25.00','admin','2024 10 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','396','202410151223',NULL,NULL,NULL,NULL,NULL,NULL),(519,'20241015-1-000012','200.00','admin','2024 10 15','  Cash','  Dine-in','200.00','0.00','0.00','0.0','397','202410151451',NULL,NULL,NULL,NULL,NULL,NULL),(520,'20241105-1-000011','1.00','admin','2024 11 05','  Cash','  Dine-in','1.00','0.00','0.00','0.0','398','202411051702',NULL,NULL,NULL,NULL,NULL,NULL),(521,'20241105-1-000012','1.00','admin','2024 11 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','399','202411051705',NULL,NULL,NULL,NULL,NULL,NULL),(648,'20241021-1-000011','61.20','madmin','2024 10 21','  card','  Dine-in','60.000000','1.200000','0.000000','0','398','202410211222','','','','0','0',NULL),(649,'20241021-1-000012','12.50','admin','2024 10 21','  Cash','  Dine-in','25.00','0.00','+ 0.00','0.0','399','202410211302',NULL,NULL,NULL,NULL,NULL,NULL),(650,'20241021-1-000013','25.00','admin','2024 10 21','  Cash','  Dine-in','25.00','0.00','0.00','0.0','400','202410211302',NULL,NULL,NULL,NULL,NULL,NULL),(651,'20241022-1-000011','25.50','admin','2024 10 22','  Cash','  Dine-in','25.50','0.00','0.00','0.0','401','202410221543',NULL,NULL,NULL,NULL,NULL,NULL),(652,'20241119-1-000011','140.00','admin','2024 11 19','  Cash','  Dine-in','140.00','0.00','0.00','0.0','402','202411191245',NULL,NULL,NULL,NULL,NULL,NULL),(653,'20241127-1-000011','61.20','madmin','2024 11 27','  Pay Later','  Dine-in','60.000000','1.200000','0.000000','0','403','202411271131','','','','0','0',NULL),(654,'20241127-1-000012','178.50','madmin','2024 11 27','  cash','  Dine-in','175.000000','3.500000','0.000000','0','404','202411271135','','','','0','0',NULL),(655,'20241127-1-000013','71.40','madmin','2024 11 27','  cash','  Dine-in','70.000000','1.400000','0.000000','0','405','202411271135','','','','0','0',NULL),(656,'20241127-1-000014','270.00','admin','2024 11 27','  Cash','  Dine-in','275.00','0.00','0.00','0.0','406','202411271438',NULL,NULL,NULL,NULL,NULL,NULL),(657,'20241204-1-000011','90.00','admin','2024 12 04','  Cash','  Dine-in','90.00','0.00','0.00','0.0','407','202412041334',NULL,NULL,NULL,NULL,NULL,NULL),(658,'20241204-1-000012','90.00','admin','2024 12 04','  Cash','  Dine-in','90.00','0.00','0.00','0.0','408','202412041335',NULL,NULL,NULL,NULL,NULL,NULL),(659,'20241204-1-000013','115.00','admin','2024 12 04','  Cash','  Dine-in','115.00','0.00','0.00','0.0','409','202412041338',NULL,NULL,NULL,NULL,NULL,NULL),(660,'20241204-1-000014','115.00','admin','2024 12 04','  Cash','  Dine-in','115.00','0.00','0.00','0.0','410','202412041339',NULL,NULL,NULL,NULL,NULL,NULL),(661,'20241204-1-000015','130.00','admin','2024 12 04','  Cash','  Dine-in','130.00','0.00','0.00','0.0','411','202412041340',NULL,NULL,NULL,NULL,NULL,NULL),(662,'20241210-1-000011','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','412','202412101028',NULL,NULL,NULL,NULL,NULL,NULL),(663,'20241210-1-000012','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','413','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(664,'20241210-1-000013','70.00','admin','2024 12 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','414','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(665,'20241210-1-000014','70.00','admin','2024 12 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','415','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(666,'20241210-1-000015','65.00','admin','2024 12 10','  Cash','  Dine-in','65.00','0.00','0.00','0.0','416','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(667,'20241210-1-000016','50.00','admin','2024 12 10','  Cash','  Dine-in','50.00','0.00','0.00','0.0','417','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(668,'20241210-1-000017','75.00','admin','2024 12 10','  Cash','  Dine-in','75.00','0.00','0.00','0.0','418','202412101029',NULL,NULL,NULL,NULL,NULL,NULL),(669,'20241210-1-000018','100.00','admin','2024 12 10','  Cash','  Dine-in','100.00','0.00','0.00','0.0','419','202412101030',NULL,NULL,NULL,NULL,NULL,NULL),(670,'20241210-1-000019','120.00','admin','2024 12 10','  Cash','  Dine-in','120.00','0.00','0.00','0.0','420','202412101030',NULL,NULL,NULL,NULL,NULL,NULL),(671,'20241210-1-0000110','50.00','admin','2024 12 10','  Cash','  Dine-in','50.00','0.00','0.00','0.0','421','202412101030',NULL,NULL,NULL,NULL,NULL,NULL),(672,'20241210-1-0000111','105.00','admin','2024 12 10','  Cash','  Dine-in','105.00','0.00','0.00','0.0','422','202412101038',NULL,NULL,NULL,NULL,NULL,NULL),(673,'20241210-1-0000112','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','423','202412101103',NULL,NULL,NULL,NULL,NULL,NULL),(674,'20241210-1-0000113','95.00','admin','2024 12 10','  Cash','  Dine-in','95.00','0.00','0.00','0.0','424','202412101105',NULL,NULL,NULL,NULL,NULL,NULL),(675,'20241210-1-000031','60.00','admin','2024 12 10','  Cash','  Takeaway','60.00','0.00','0.00','0.0','425','202412101533',NULL,NULL,NULL,NULL,NULL,NULL),(676,'20241210-1-0000114','125.00','admin','2024 12 10','  Cash','  Dine-in','125.00','0.00','0.00','0.0','426','202412101545',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (2,'2345678906','2147483647');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20241021-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,'2024 10 21','01:02:01 PM','20241021-1-000012','pushpanjali','50','12.50','12.50','21 Oct 2024','25.00',NULL,'202410211302',NULL),(3,'2024 11 04','03:21:28 PM','20241104-1-000016','pushpanjali','50','17.85','17.85','04 Nov 2024','35.70',NULL,'202411041521',NULL),(4,'2024 11 04','05:46:30 PM','20241104-1-000017','pushpanjali','50','17.85','17.85','04 Nov 2024','35.70',NULL,'202411041746',NULL),(5,NULL,NULL,'20241127-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,'20241127-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,'20241127-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(8,'2024 11 27','02:38:03 PM','20241127-1-000014','rty','1.82','270.00','5','27 Nov 2024','275.00',NULL,'202411271438',NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'auto','200','Transportation','madmin','madmin','17 Sep 2024','11:53 AM','202409171153');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'idly',3),(2,'dosa',145),(3,'idly',1),(4,'masal dosa',46),(5,'masal vada',20),(6,'onion dosa',35),(7,'pongal',94),(8,'upma',34),(9,'poori',70),(10,'rava dosa',35),(11,'samosa',20),(12,'sheekh kabab',80),(13,'uthappam',60),(14,'vada',20);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Tiffin',136,100,'5');
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1','idly',3,100,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',145,33,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1','idly',1,0,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'6','masal dosa',46,11,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'12','masal vada',20,5,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','onion dosa',35,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'3','pongal',94,22,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'4','upma',34,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'5','poori',70,10,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'9','rava dosa',35,5,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'13','samosa',20,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'15','sheekh kabab',80,11,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'10','uthappam',60,8,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'11','vada',20,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',3),(2,'Snacks',20),(3,'Tiffin',415),(4,'Tiffin',136),(5,'Tiffin',1),(6,'Tiffin',1),(7,'Tiffin',35),(8,'Tiffin',37),(9,'Tiffin',36),(10,'Tiffin',2),(11,'Tiffin',72),(12,'Tiffin',72),(13,'Tiffin',275),(14,'Snacks',260),(15,'Tiffin',460);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',3),(2,'madmin',311);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',3,100);
