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,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231002-1-000011','08:08:46 PM','2023 10 02','ladmin','1','  Dine-in','  Cash','120.00','120.00','1',NULL,NULL,NULL,NULL,'02 Oct 2023','2023100220:08:46','%','0','35.00','no','0.00',NULL,'202310022008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231002-1-000011','08:08:46 PM','2023 10 02','ladmin','1','  Dine-in','  Cash','120.00','120.00','2',NULL,NULL,NULL,NULL,'02 Oct 2023','2023100220:08:46','%','0','50.00','no','0.00',NULL,'202310022008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231002-1-000011','08:08:46 PM','2023 10 02','ladmin','1','  Dine-in','  Cash','120.00','120.00','3',NULL,NULL,NULL,NULL,'02 Oct 2023','2023100220:08:46','%','0','35.00','no','0.00',NULL,'202310022008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','4',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','50.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','5',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','70.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','6',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','30.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','7',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','20.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'vanilla icecream','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','8',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','70.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'butterscotch icecream','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000011','04:54:02 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','280.00','280.00','9',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:54:02','%','0','40.00','no','0.00',NULL,'202311241654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000012','04:55:31 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','65.00','65.00','10',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:55:31','%','0','30.00','no','0.00',NULL,'202311241655','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231124-1-000012','04:55:31 PM','2023 11 24','ladmin','1','  Dine-in','  Cash','65.00','65.00','11',NULL,NULL,NULL,NULL,'24 Nov 2023','2023112416:55:31','%','0','35.00','no','0.00',NULL,'202311241655','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231125-1-000011','01:36:26 PM','2023 11 25','ladmin','1','  Dine-in','  Cash','60.00','60.00','12',NULL,NULL,NULL,NULL,'25 Nov 2023','2023112513:36:26','%','0','25.00','no','0.00',NULL,'202311251336','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231125-1-000011','01:36:26 PM','2023 11 25','ladmin','1','  Dine-in','  Cash','60.00','60.00','13',NULL,NULL,NULL,NULL,'25 Nov 2023','2023112513:36:26','%','0','35.00','no','0.00',NULL,'202311251336','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'idly','3.0','25.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20231129-1-000011','04:22:46 PM','2023 11 29','ladmin','1','  Dine-in','  Cash','260.00','260.00','14',NULL,NULL,NULL,NULL,'29 Nov 2023','2023112916:22:46','%','0','75.00','no','0.00',NULL,'202311291622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'ghee pack','0.25','600.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20231129-1-000011','04:22:46 PM','2023 11 29','ladmin','1','  Dine-in','  Cash','260.00','260.00','15',NULL,NULL,NULL,NULL,'29 Nov 2023','2023112916:22:46','%','0','150.00','no','0.00',NULL,'202311291622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231129-1-000011','04:22:46 PM','2023 11 29','ladmin','1','  Dine-in','  Cash','260.00','260.00','16',NULL,NULL,NULL,NULL,'29 Nov 2023','2023112916:22:46','%','0','35.00','no','0.00',NULL,'202311291622','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231129-1-000012','04:24:11 PM','2023 11 29','ladmin','1','  Dine-in','  Cash','65.00','65.00','17',NULL,NULL,NULL,NULL,'29 Nov 2023','2023112916:24:11','%','0','35.00','no','0.00',NULL,'202311291624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231129-1-000012','04:24:11 PM','2023 11 29','ladmin','1','  Dine-in','  Cash','65.00','65.00','18',NULL,NULL,NULL,NULL,'29 Nov 2023','2023112916:24:11','%','0','30.00','no','0.00',NULL,'202311291624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000011','05:08:07 PM','2023 12 05','admin','1','  Dine-in','  Cash','270.00','270.00','19',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:07','%','0','60.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000011','05:08:07 PM','2023 12 05','admin','1','  Dine-in','  Cash','270.00','270.00','20',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:07','%','0','20.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000011','05:08:07 PM','2023 12 05','admin','1','  Dine-in','  Cash','270.00','270.00','21',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:07','%','0','50.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'dosa','4.0','35.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000011','05:08:07 PM','2023 12 05','admin','1','  Dine-in','  Cash','270.00','270.00','22',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:07','%','0','140.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000012','05:08:30 PM','2023 12 05','admin','1','  Dine-in','  Cash','45.00','45.00','23',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:30','%','0','20.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-1-000012','05:08:30 PM','2023 12 05','admin','1','  Dine-in','  Cash','45.00','45.00','24',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120517:08:30','%','0','25.00','no','0.00',NULL,'202312051708','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000011','05:16:34 PM','2024 01 29','ladmin','1','  Dine-in','  Cash','100.00','100.00','25',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012917:16:34','%','0','30.00','no','0.00',NULL,'202401291716','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000011','05:16:34 PM','2024 01 29','ladmin','1','  Dine-in','  Cash','100.00','100.00','26',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012917:16:34','%','0','35.00','no','0.00',NULL,'202401291716','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000011','05:16:34 PM','2024 01 29','ladmin','1','  Dine-in','  Cash','100.00','100.00','27',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012917:16:34','%','0','35.00','no','0.00',NULL,'202401291716','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240215-1-000011','09:23:02 AM','2024 02 15','ladmin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'15 Feb 2024','2024021509:23:02','%','0','25.00','no','0.00',NULL,'202402150923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240215-1-000011','09:23:02 AM','2024 02 15','ladmin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'15 Feb 2024','2024021509:23:02','%','0','35.00','no','0.00',NULL,'202402150923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240224-1-000011','02:56:35 PM','2024 02 24','admin','1','  Dine-in','  Cash','60.00','60.00','3',NULL,NULL,NULL,NULL,'24 Feb 2024','2024022414:56:35','%','0','25.00','no','0.00',NULL,'202402241456','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240224-1-000011','02:56:35 PM','2024 02 24','admin','1','  Dine-in','  Cash','60.00','60.00','4',NULL,NULL,NULL,NULL,'24 Feb 2024','2024022414:56:35','%','0','35.00','no','0.00',NULL,'202402241456','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240224-1-000012','02:56:55 PM','2024 02 24','admin','1','  Dine-in','  Cash','65.00','65.00','5',NULL,NULL,NULL,NULL,'24 Feb 2024','2024022414:56:55','%','0','35.00','no','0.00',NULL,'202402241456','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240224-1-000012','02:56:55 PM','2024 02 24','admin','1','  Dine-in','  Cash','65.00','65.00','6',NULL,NULL,NULL,NULL,'24 Feb 2024','2024022414:56:55','%','0','30.00','no','0.00',NULL,'202402241456','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240229-1-000013','12:22:55 PM','2024 02 29','admin','1','  Dine-in','  Cash','95.00','95.00','36',NULL,NULL,NULL,NULL,'29 Feb 2024','2024022912:22:55','%','0','30.00','no','0.00',NULL,'202402291222','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240229-1-000012','01:07:58 PM','2024 02 29','admin','1','  Dine-in','  Cash','40.00','40.00','8',NULL,NULL,NULL,NULL,'29 Feb 2024','2024022913:07:58','%','0','40.00','no','0.00',NULL,'202402291307','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240229-1-000013','01:08:32 PM','2024 02 29','admin','1','  Dine-in','  Cash','85.00','85.00','9',NULL,NULL,NULL,NULL,'29 Feb 2024','2024022913:08:32','%','0','50.00','no','0.00',NULL,'202402291308','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240229-1-000013','01:08:32 PM','2024 02 29','admin','1','  Dine-in','  Cash','85.00','85.00','10',NULL,NULL,NULL,NULL,'29 Feb 2024','2024022913:08:32','%','0','35.00','no','0.00',NULL,'202402291308','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240301-1-000011','03:00:45 PM','2024 03 01','admin','1','  Dine-in','  Cash','245.00','245.00','40',NULL,NULL,NULL,NULL,'01 Mar 2024','2024030115:00:45','%','0','20.00','no','0.00',NULL,'202403011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'masala chai','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240301-1-000011','03:00:45 PM','2024 03 01','admin','1','  Dine-in','  Cash','245.00','245.00','41',NULL,NULL,NULL,NULL,'01 Mar 2024','2024030115:00:45','%','0','25.00','no','0.00',NULL,'202403011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240301-1-000011','03:00:45 PM','2024 03 01','admin','1','  Dine-in','  Cash','245.00','245.00','42',NULL,NULL,NULL,NULL,'01 Mar 2024','2024030115:00:45','%','0','35.00','no','0.00',NULL,'202403011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240301-1-000011','06:35:34 PM','2024 03 01','admin','1','  Dine-in','  Cash','95.00','95.00','14',NULL,NULL,NULL,NULL,'01 Mar 2024','2024030118:35:34','%','0','20.00','no','0.00',NULL,'202403011835','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000011','02:17:48 PM','2024 03 18','admin','1','  Dine-in','  Cash','55.00','55.00','44',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:17:48','%','0','30.00','no','0.00',NULL,'202403181417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,NULL),(43,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000011','02:30:38 PM','2024 03 18','admin','1','  Dine-in','  Cash','375.00','375.00','16',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:30:38','%','0','20.00','no','0.00',NULL,'202403181430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'idly','5.0','25.00','125.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000011','02:30:38 PM','2024 03 18','admin','1','  Dine-in','  Cash','375.00','375.00','17',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:30:38','%','0','125.00','no','0.00',NULL,'202403181430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'dosa','6.0','35.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000011','02:30:38 PM','2024 03 18','admin','1','  Dine-in','  Cash','375.00','375.00','18',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:30:38','%','0','210.00','no','0.00',NULL,'202403181430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000021','02:32:42 PM','2024 03 18','admin','2','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:32:42','%','0','25.00','no','0.00',NULL,'202403181432','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240318-1-000021','02:32:42 PM','2024 03 18','admin','2','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'18 Mar 2024','2024031814:32:42','%','0','35.00','no','0.00',NULL,'202403181432','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','50',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','50.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'dosa','3.0','35.00','105.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','51',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','105.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','52',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','60.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','53',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','30.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','54',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','35.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240330-1-000011','03:11:29 PM','2024 03 30','admin','1','  Dine-in','  Cash','320.00','320.00','55',NULL,NULL,NULL,NULL,'30 Mar 2024','2024033015:11:29','%','0','40.00','no','0.00',NULL,'202403301511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'lassi','9.0','25.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20240518-1-000011','02:04:41 PM','2024 05 18','admin','1','  Dine-in','  Cash','525.00','525.00','56',NULL,NULL,NULL,NULL,'18 May 2024','2024051814:04:41','%','0','225.00','no','0.00',NULL,'202405181404','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'lime juice','11.0','15.00','165.00','Item',NULL,NULL,'no',NULL,NULL,'20240518-1-000011','02:04:41 PM','2024 05 18','admin','1','  Dine-in','  Cash','525.00','525.00','57',NULL,NULL,NULL,NULL,'18 May 2024','2024051814:04:41','%','0','165.00','no','0.00',NULL,'202405181404','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','1',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','25.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','2',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','35.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','3',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','60.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','4',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','30.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','5',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','35.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240517-1-000031','09:22:56 PM','2024 05 17','admin','3','  Dine-in','  Cash','225.00','225.00','6',NULL,NULL,NULL,NULL,'17 May 2024','2024051721:22:56','%','0','40.00','no','0.00',NULL,'202405172122','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240529-1-000013','03:03:28 PM','2024 05 29','admin','1','  Dine-in','  Cash','35.00','35.00','64',NULL,NULL,NULL,NULL,'29 May 2024','2024052915:03:28','%','0','25.00','no','0.00',NULL,'202405291503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240529-1-000013','03:03:28 PM','2024 05 29','admin','1','  Dine-in','  Cash','35.00','35.00','65',NULL,NULL,NULL,NULL,'29 May 2024','2024052915:03:28','%','0','10.00','no','0.00',NULL,'202405291503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000011','05:37:30 PM','2024 06 15','user1','1','  Dine-in','  Cash','85.00','85.00','66',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:37:30','%','0','50.00','no','0.00',NULL,'202406151737','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000011','05:37:30 PM','2024 06 15','user1','1','  Dine-in','  Cash','85.00','85.00','67',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:37:30','%','0','35.00','no','0.00',NULL,'202406151737','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000012','05:38:31 PM','2024 06 15','user1','1','  Dine-in','  Cash','25.00','25.00','68',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:38:31','%','0','25.00','no','0.00',NULL,'202406151738','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000013','05:40:43 PM','2024 06 15','user1','1','  Dine-in','  Cash','155.00','155.00','69',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:40:43','%','0','40.00','no','0.00',NULL,'202406151740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000013','05:40:43 PM','2024 06 15','user1','1','  Dine-in','  Cash','155.00','155.00','70',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:40:43','%','0','25.00','no','0.00',NULL,'202406151740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000013','05:40:43 PM','2024 06 15','user1','1','  Dine-in','  Cash','155.00','155.00','71',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:40:43','%','0','35.00','no','0.00',NULL,'202406151740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000013','05:40:43 PM','2024 06 15','user1','1','  Dine-in','  Cash','155.00','155.00','72',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:40:43','%','0','35.00','no','0.00',NULL,'202406151740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240615-1-000013','05:40:43 PM','2024 06 15','user1','1','  Dine-in','  Cash','155.00','155.00','73',NULL,NULL,NULL,NULL,'15 Jun 2024','2024061517:40:43','%','0','20.00','no','0.00',NULL,'202406151740','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','User1',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(73,'JILABI','0.50','200.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','02:00:00 PM','2024 07 29','admin','1','  Dine-in','  Cash','990.00','990.00','75',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072914:00:00','%','0','100.00','no','0.00',NULL,'202407291400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sweets','admin','madmin',NULL,NULL,'202',NULL,NULL,'','','','',NULL,NULL),(74,'Ladu','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','02:00:00 PM','2024 07 29','admin','1','  Dine-in','  Cash','990.00','990.00','76',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072914:00:00','%','0','600.00','no','0.00',NULL,'202407291400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sweets','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(75,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240729-1-000011','02:00:00 PM','2024 07 29','admin','1','  Dine-in','  Cash','990.00','990.00','77',NULL,NULL,NULL,NULL,'29 Jul 2024','2024072914:00:00','%','0','35.00','no','0.00',NULL,'202407291400','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(94,'dosa','3.0','35.00','105.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','96',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','105.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'105.00','','','','',NULL,'35.00'),(95,'pongal','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','97',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','90.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'30.00'),(96,'upma','4.0','30.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','98',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','120.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'30.00'),(97,'poori','3.0','35.00','105.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','99',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','105.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'105.00','','','','',NULL,'35.00'),(98,'masal dosa','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','100',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','80.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'40.00'),(99,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000011','11:36:47 AM','2024 08 01','admin','1','  Dine-in','  Cash','525.00','525.00','101',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:36:47','%','0','25.00','no','0.00',NULL,'202408011136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(100,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000012','11:38:54 AM','2024 08 01','admin','1','  Dine-in','  Cash','60.00','60.00','102',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:38:54','%','0','25.00','no','0.00',NULL,'202408011138','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(101,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000012','11:38:54 AM','2024 08 01','admin','1','  Dine-in','  Cash','60.00','60.00','103',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:38:54','%','0','35.00','no','0.00',NULL,'202408011138','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(102,'Ladu','2.0','600.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000013','11:49:56 AM','2024 08 01','admin','1','  Dine-in','  Cash','1240.00','1240.00','104',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:49:56','%','0','1200.00','no','0.00',NULL,'202408011149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sweets','admin','madmin',NULL,NULL,'',NULL,'1200.00','','','','',NULL,'600.00'),(103,'coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000013','11:49:56 AM','2024 08 01','admin','1','  Dine-in','  Cash','1240.00','1240.00','105',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:49:56','%','0','20.00','no','0.00',NULL,'202408011149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(104,'tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000013','11:49:56 AM','2024 08 01','admin','1','  Dine-in','  Cash','1240.00','1240.00','106',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080111:49:56','%','0','20.00','no','0.00',NULL,'202408011149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(105,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000014','03:00:05 PM','2024 08 01','admin','1','  Dine-in','  Cash','260.00','260.00','107',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:00:05','%','0','50.00','no','0.00',NULL,'202408011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(106,'dosa','5.0','35.00','175.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000014','03:00:05 PM','2024 08 01','admin','1','  Dine-in','  Cash','260.00','260.00','108',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:00:05','%','0','175.00','no','0.00',NULL,'202408011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'175.00','','','','',NULL,'35.00'),(107,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000014','03:00:05 PM','2024 08 01','admin','1','  Dine-in','  Cash','260.00','260.00','109',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:00:05','%','0','35.00','no','0.00',NULL,'202408011500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(108,'chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000021','03:02:27 PM','2024 08 01','admin','2','  Dine-in','  Cash','140.00','140.00','1',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:02:27','%','0','60.00','no','0.00',NULL,'202408011502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(109,'sheekh kabab','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000021','03:02:27 PM','2024 08 01','admin','2','  Dine-in','  Cash','140.00','140.00','2',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:02:27','%','0','80.00','no','0.00',NULL,'202408011502','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(110,'idly','3.0','25.00','75.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','110',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','75.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'75.00','','','','',NULL,'25.00'),(111,'onion dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','111',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','70.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(112,'Ladu','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','112',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','600.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sweets','admin','madmin',NULL,NULL,'',NULL,'600.00','','','','',NULL,'600.00'),(113,'HALWA','300.00','250.00','75000.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','113',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','75000.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sweets','admin','madmin',NULL,NULL,'201',NULL,'75000.00','','','','',NULL,'250.00'),(114,'rava dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','114',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','70.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(115,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000015','03:40:00 PM','2024 08 01','admin','1','  Dine-in','  Cash','75850.00','75850.00','115',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080115:40:00','%','0','35.00','no','0.00',NULL,'202408011540','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(116,'TEA','3.0','10.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000016','04:41:35 PM','2024 08 01','admin','1','  Dine-in','  Cash','120.00','120.00','116',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080116:41:35','%','0','30.00','no','0.00',NULL,'202408011641','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'100',NULL,'30.00','','','','',NULL,'10.00'),(117,'tea','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000016','04:41:35 PM','2024 08 01','admin','1','  Dine-in','  Cash','120.00','120.00','117',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080116:41:35','%','0','40.00','no','0.00',NULL,'202408011641','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(118,'MINT LIME','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000016','04:41:35 PM','2024 08 01','admin','1','  Dine-in','  Cash','120.00','120.00','118',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080116:41:35','%','0','50.00','no','0.00',NULL,'202408011641','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(119,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240801-1-000017','04:43:14 PM','2024 08 01','admin','1','  Dine-in','  Cash','25.00','25.00','119',NULL,NULL,NULL,NULL,'01 Aug 2024','2024080116:43:14','%','0','25.00','no','0.00',NULL,'202408011643','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.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,'20231002-1-000011','120.00','ladmin','2023 10 02','  Cash','  Dine-in','120.00','0.00','0.00','0.0','1','202310022008',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20231124-1-000011','280.00','ladmin','2023 11 24','  Cash','  Dine-in','280.00','0.00','0.00','0.0','2','202311241654',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20231124-1-000012','65.00','ladmin','2023 11 24','  Cash','  Dine-in','65.00','0.00','0.00','0.0','3','202311241655',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20231125-1-000011','60.00','ladmin','2023 11 25','  Cash','  Dine-in','60.00','0.00','0.00','0.0','4','202311251336',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20231129-1-000011','260.00','ladmin','2023 11 29','  Cash','  Dine-in','260.00','0.00','0.00','0.0','5','202311291622',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20231129-1-000012','65.00','ladmin','2023 11 29','  Cash','  Dine-in','65.00','0.00','0.00','0.0','6','202311291624',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20231205-1-000011','270.00','admin','2023 12 05','  Cash','  Dine-in','270.00','0.00','0.00','0.0','7','202312051708',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20231205-1-000012','45.00','admin','2023 12 05','  Cash','  Dine-in','45.00','0.00','0.00','0.0','8','202312051708',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240129-1-000011','100.00','ladmin','2024 01 29','  Cash','  Dine-in','100.00','0.00','0.00','0.0','9','202401291716',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240215-1-000011','60.00','ladmin','2024 02 15','  Cash','  Dine-in','60.00','0.00','0.00','0.0','10','202402150923',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240224-1-000011','60.00','admin','2024 02 24','  Cash','  Dine-in','60.00','0.00','0.00','0.0','11','202402241456',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240224-1-000012','65.00','admin','2024 02 24','  Cash','  Dine-in','65.00','0.00','0.00','0.0','12','202402241456',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240229-1-000011','35.00','admin','2024 02 29','  Cash','  Dine-in','35.00','0.00','0.00','0.0','13','202402291306',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240229-1-000012','40.00','admin','2024 02 29','  Cash','  Dine-in','40.00','0.00','0.00','0.0','14','202402291307',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240229-1-000013','85.00','admin','2024 02 29','  Cash','  Dine-in','85.00','0.00','0.00','0.0','15','202402291308',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240301-1-000011','95.00','admin','2024 03 01','  Cash','  Dine-in','95.00','0.00','0.00','0.0','16','202403011835',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240318-1-000011','375.00','admin','2024 03 18','  Cash','  Dine-in','375.00','0.00','0.00','0.0','17','202403181430',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240318-1-000021','60.00','admin','2024 03 18','  Cash','  Dine-in','60.00','0.00','0.00','0.0','18','202403181432',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240509-1-000011','125.00','admin','2024 05 09','  Cash','  Dine-in','125.00','0.00','0.00','0.0','19','202405091856',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240517-1-000011','20.00','admin','2024 05 17','  Cash','  Dine-in','20.00','0.00','0.00','0.0','20','202405172031',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240517-1-000012','1985.00','user1','2024 05 17','  Upiqr','  Dine-in','1985.00','0.00','0.00','0.0','21','202405172057',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240517-1-000031','225.00','admin','2024 05 17','  Cash','  Dine-in','225.00','0.00','0.00','0.0','22','202405172122',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240519-1-000011','130.00','admin','2024 05 19','  Cash','  Dine-in','130.00','0.00','0.00','0.0','23','202405191121',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240615-1-000013','155.00','user1','2024 06 15','  Cash','  Dine-in','155.00','0.00','0.00','0.0','24','202406151740',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240729-1-000011','990.00','admin','2024 07 29','  Cash','  Dine-in','990.00','0.00','0.00','0.0','25','202407291400',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240729-1-000012','330.00','admin','2024 07 29','  Cash','  Dine-in','330.00','0.00','0.00','0.0','26','202407291401',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240729-1-000013','90.00','admin','2024 07 29','  Cash','  Dine-in','90.00','0.00','0.00','0.0','27','202407291403',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240729-1-000014','65.00','admin','2024 07 29','  Cash','  Dine-in','65.00','0.00','0.00','0.0','28','202407291403',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240729-1-000015','65.00','admin','2024 07 29','  Cash','  Dine-in','65.00','0.00','0.00','0.0','29','202407291404',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240801-1-000011','525.00','admin','2024 08 01','  Cash','  Dine-in','525.00','0.00','0.00','0.0','30','202408011136',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240801-1-000012','60.00','admin','2024 08 01','  Cash','  Dine-in','60.00','0.00','0.00','0.0','31','202408011138',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240801-1-000013','1240.00','admin','2024 08 01','  Cash','  Dine-in','1240.00','0.00','0.00','0.0','32','202408011149',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240801-1-000014','260.00','admin','2024 08 01','  Cash','  Dine-in','260.00','0.00','0.00','0.0','33','202408011500',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240801-1-000021','140.00','admin','2024 08 01','  Cash','  Dine-in','140.00','0.00','0.00','0.0','34','202408011502',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240801-1-000015','75850.00','admin','2024 08 01','  Cash','  Dine-in','75850.00','0.00','0.00','0.0','35','202408011540',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20240801-1-000016','120.00','admin','2024 08 01','  Cash','  Dine-in','120.00','0.00','0.00','0.0','36','202408011641',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20240801-1-000017','25.00','admin','2024 08 01','  Cash','  Dine-in','25.00','0.00','0.00','0.0','37','202408011643',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
