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,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000011','02:48:43 PM','2024 08 20','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:48:43','%','0','30.00','no','0.00',NULL,'202408201448','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(2,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000011','02:48:43 PM','2024 08 20','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:48:43','%','0','30.00','no','0.00',NULL,'202408201448','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(3,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000012','02:49:42 PM','2024 08 20','admin','1','  Dine-in','  Cash','105.00','105.00','3',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:49:42','%','0','35.00','no','0.00',NULL,'202408201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(4,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000012','02:49:42 PM','2024 08 20','admin','1','  Dine-in','  Cash','105.00','105.00','4',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:49:42','%','0','40.00','no','0.00',NULL,'202408201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(5,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000012','02:49:42 PM','2024 08 20','admin','1','  Dine-in','  Cash','105.00','105.00','5',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:49:42','%','0','30.00','no','0.00',NULL,'202408201449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(6,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000013','02:51:34 PM','2024 08 20','admin','1','  Dine-in','  Cash','65.00','65.00','6',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:51:34','%','0','35.00','no','0.00',NULL,'202408201451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(7,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000013','02:51:34 PM','2024 08 20','admin','1','  Dine-in','  Cash','65.00','65.00','7',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:51:34','%','0','30.00','no','0.00',NULL,'202408201451','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(8,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000014','02:52:13 PM','2024 08 20','admin','1','  Dine-in','  Cash','70.00','70.00','8',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:52:13','%','0','35.00','no','0.00',NULL,'202408201452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(9,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000014','02:52:13 PM','2024 08 20','admin','1','  Dine-in','  Cash','70.00','70.00','9',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:52:13','%','0','35.00','no','0.00',NULL,'202408201452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(10,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000015','02:53:34 PM','2024 08 20','admin','1','  Dine-in','  Cash','65.00','65.00','10',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:53:34','%','0','30.00','no','0.00',NULL,'202408201453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(11,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000015','02:53:34 PM','2024 08 20','admin','1','  Dine-in','  Cash','65.00','65.00','11',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082014:53:34','%','0','35.00','no','0.00',NULL,'202408201453','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(12,'pongal','1.74','30.00','52.20','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000016','03:06:24 PM','2024 08 20','admin','1','  Dine-in','  Cash','52.20','52.20','13',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:06:24','%','0','52.20','no','0.00',NULL,'202408201506','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'52.20','','','','',NULL,'30.00'),(13,'pongal','0.63','30.00','18.90','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000017','03:09:39 PM','2024 08 20','admin','1','  Dine-in','  Cash','83.90','83.90','14',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:09:39','%','0','18.90','no','0.00',NULL,'202408201509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'18.90','','','','',NULL,'30.00'),(14,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000017','03:09:39 PM','2024 08 20','admin','1','  Dine-in','  Cash','83.90','83.90','15',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:09:39','%','0','35.00','no','0.00',NULL,'202408201509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(15,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000017','03:09:39 PM','2024 08 20','admin','1','  Dine-in','  Cash','83.90','83.90','16',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:09:39','%','0','30.00','no','0.00',NULL,'202408201509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(16,'pongal','0.63','30.00','18.90','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000018','03:11:46 PM','2024 08 20','admin','1','  Dine-in','  Cash','48.90','48.90','17',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:11:46','%','0','18.90','no','0.00',NULL,'202408201511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'18.90','','','','',NULL,'30.00'),(17,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240820-1-000018','03:11:46 PM','2024 08 20','admin','1','  Dine-in','  Cash','48.90','48.90','18',NULL,NULL,NULL,NULL,'20 Aug 2024','2024082015:11:46','%','0','30.00','no','0.00',NULL,'202408201511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(18,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000011','10:53:45 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','1',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:53:45','%','0','30.00','no','0.00',NULL,'202408221053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(19,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000011','10:53:45 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','2',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:53:45','%','0','35.00','no','0.00',NULL,'202408221053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(20,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000012','10:54:44 AM','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','3',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:54:44','%','0','35.00','no','0.00',NULL,'202408221054','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(21,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000012','10:54:44 AM','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','4',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:54:44','%','0','35.00','no','0.00',NULL,'202408221054','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(22,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000013','10:58:17 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','5',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:58:17','%','0','35.00','no','0.00',NULL,'202408221058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(23,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000013','10:58:17 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','6',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:58:17','%','0','30.00','no','0.00',NULL,'202408221058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(24,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000014','10:58:55 AM','2024 08 22','admin','1','  Dine-in','  Cash','110.00','110.00','7',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:58:55','%','0','30.00','no','0.00',NULL,'202408221058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(25,'sheekh kabab','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000014','10:58:55 AM','2024 08 22','admin','1','  Dine-in','  Cash','110.00','110.00','8',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082210:58:55','%','0','80.00','no','0.00',NULL,'202408221058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(26,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','11:00:55 AM','2024 08 22','admin','1','  Dine-in','  Cash','95.00','95.00','9',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:00:55','%','0','35.00','no','0.00',NULL,'202408221100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(27,'chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','11:00:55 AM','2024 08 22','admin','1','  Dine-in','  Cash','95.00','95.00','10',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:00:55','%','0','60.00','no','0.00',NULL,'202408221100','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(28,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000016','11:14:03 AM','2024 08 22','admin','1','  Dine-in','  Cash','30.00','30.00','11',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:14:03','%','0','30.00','no','0.00',NULL,'202408221114','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(29,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','11:16:41 AM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','12',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:16:41','%','0','30.00','no','0.00',NULL,'202408221116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(30,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','11:16:41 AM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','13',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:16:41','%','0','35.00','no','0.00',NULL,'202408221116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(31,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','11:16:41 AM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','14',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:16:41','%','0','20.00','no','0.00',NULL,'202408221116','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(32,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000018','11:26:10 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','15',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:26:10','%','0','35.00','no','0.00',NULL,'202408221126','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(33,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000018','11:26:10 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','16',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:26:10','%','0','30.00','no','0.00',NULL,'202408221126','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(34,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000019','11:33:08 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','17',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:33:08','%','0','35.00','no','0.00',NULL,'202408221133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(35,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000019','11:33:08 AM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','18',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:33:08','%','0','30.00','no','0.00',NULL,'202408221133','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(36,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000110','11:59:52 AM','2024 08 22','admin','1','  Dine-in','  Cash','50.00','50.00','19',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:59:52','%','0','30.00','no','0.00',NULL,'202408221159','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(37,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000110','11:59:52 AM','2024 08 22','admin','1','  Dine-in','  Cash','50.00','50.00','20',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082211:59:52','%','0','20.00','no','0.00',NULL,'202408221159','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(38,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000111','12:14:06 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','21',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:14:06','%','0','35.00','no','0.00',NULL,'202408221214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(39,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000111','12:14:06 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','22',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:14:06','%','0','30.00','no','0.00',NULL,'202408221214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(40,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','12:16:07 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','23',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:16:07','%','0','30.00','no','0.00',NULL,'202408221216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(41,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','12:16:07 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','24',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:16:07','%','0','35.00','no','0.00',NULL,'202408221216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(42,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000113','12:49:22 PM','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','27',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:49:22','%','0','35.00','no','0.00',NULL,'202408221249','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(43,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000113','12:49:22 PM','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','28',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082212:49:22','%','0','35.00','no','0.00',NULL,'202408221249','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(44,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','01:02:51 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','1',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082213:02:51','%','0','30.00','no','0.00',NULL,'202408221302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(45,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','01:02:51 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','2',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082213:02:51','%','0','35.00','no','0.00',NULL,'202408221302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(46,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000115','01:04:27 PM','2024 08 22','admin','1','  Dine-in','  Cash','30.00','30.00','3',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082213:04:27','%','0','30.00','no','0.00',NULL,'202408221304','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(47,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','01:07:46 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','5',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082213:07:46','%','0','30.00','no','0.00',NULL,'202408221307','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(48,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','01:07:46 PM','2024 08 22','admin','1','  Dine-in','  Cash','65.00','65.00','6',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082213:07:46','%','0','35.00','no','0.00',NULL,'202408221307','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(49,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000117','04:10:14 PM','2024 08 22','admin','1','  Dine-in','  Cash','30.00','30.00','7',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:10:14','%','0','30.00','no','0.00',NULL,'202408221610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(50,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000118','04:14:20 PM','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','8',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:14:20','%','0','30.00','no','0.00',NULL,'202408221614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(51,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000118','04:14:20 PM','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','9',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:14:20','%','0','30.00','no','0.00',NULL,'202408221614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(52,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000119','04:15:37 PM','2024 08 22','admin','1','  Dine-in','  Cash','55.00','55.00','10',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:15:37','%','0','35.00','no','0.00',NULL,'202408221615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(53,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000119','04:15:37 PM','2024 08 22','admin','1','  Dine-in','  Cash','55.00','55.00','11',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:15:37','%','0','20.00','no','0.00',NULL,'202408221615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(54,'onion dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000120','04:16:23 PM','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','12',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:16:23','%','0','70.00','no','0.00',NULL,'202408221616','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(55,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000121','04:19:03 PM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','14',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:19:03','%','0','35.00','no','0.00',NULL,'202408221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(56,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000121','04:19:03 PM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','15',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:19:03','%','0','30.00','no','0.00',NULL,'202408221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(57,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000121','04:19:03 PM','2024 08 22','admin','1','  Dine-in','  Cash','85.00','85.00','16',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:19:03','%','0','20.00','no','0.00',NULL,'202408221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(58,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000122','04:25:11 PM','2024 08 22','admin','1','  Dine-in','  Cash','35.00','35.00','17',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:25:11','%','0','35.00','no','0.00',NULL,'202408221625','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(59,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000123','04:27:53 PM','2024 08 22','admin','1','  Dine-in','  Cash','30.00','30.00','18',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082216:27:53','%','0','30.00','no','0.00',NULL,'202408221627','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(60,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-000011','11:38:19 AM','2024 08 23','admin','1','  Dine-in','  Cash','60.00','60.00','19',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082311:38:19','%','0','60.00','no','0.00',NULL,'202408231138','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(61,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-000012','11:42:28 AM','2024 08 23','admin','1','  Dine-in','  Cash','30.00','30.00','20',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082311:42:28','%','0','30.00','no','0.00',NULL,'202408231142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(62,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-000013','11:42:49 AM','2024 08 23','admin','1','  Dine-in','  Cash','30.00','30.00','21',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082311:42:49','%','0','30.00','no','0.00',NULL,'202408231142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(63,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240823-000014','11:44:31 AM','2024 08 23','admin','1','  Dine-in','  Cash','30.00','30.00','22',NULL,NULL,NULL,NULL,'23 Aug 2024','2024082311:44:31','%','0','30.00','no','0.00',NULL,'202408231144','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.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,'20240820-1-000011','60.00','admin','2024 08 20','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1','202408201448',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240820-1-000012','105.00','admin','2024 08 20','  Cash','  Dine-in','105.00','0.00','0.00','0.0','2','202408201449',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240820-1-000013','65.00','admin','2024 08 20','  Cash','  Dine-in','65.00','0.00','0.00','0.0','3','202408201451',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240820-1-000014','70.00','admin','2024 08 20','  Cash','  Dine-in','70.00','0.00','0.00','0.0','4','202408201452',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240820-1-000015','65.00','admin','2024 08 20','  Cash','  Dine-in','65.00','0.00','0.00','0.0','5','202408201453',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240820-1-000016','52.20','admin','2024 08 20','  Cash','  Dine-in','52.20','0.00','0.00','0.0','6','202408201506',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240820-1-000017','83.90','admin','2024 08 20','  Cash','  Dine-in','83.90','0.00','0.00','0.0','7','202408201509',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240820-1-000018','48.90','admin','2024 08 20','  Cash','  Dine-in','48.90','0.00','0.00','0.0','8','202408201511',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240822-000011','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','9','202408221053',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240822-000012','70.00','admin','2024 08 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','10','202408221054',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240822-000013','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','11','202408221058',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240822-000014','110.00','admin','2024 08 22','  Cash','  Dine-in','110.00','0.00','0.00','0.0','12','202408221058',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240822-000015','95.00','admin','2024 08 22','  Cash','  Dine-in','95.00','0.00','0.00','0.0','13','202408221100',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240822-000016','30.00','admin','2024 08 22','  Cash','  Dine-in','30.00','0.00','0.00','0.0','14','202408221114',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240822-000017','85.00','admin','2024 08 22','  Cash','  Dine-in','85.00','0.00','0.00','0.0','15','202408221116',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240822-000018','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','16','202408221126',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240822-000019','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','17','202408221133',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240822-0000110','50.00','admin','2024 08 22','  Cash','  Dine-in','50.00','0.00','0.00','0.0','18','202408221159',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240822-0000111','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','19','202408221214',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240822-0000112','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','20','202408221216',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240822-0000113','70.00','admin','2024 08 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','21','202408221249',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240822-0000114','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','22','202408221302',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240822-0000115','30.00','admin','2024 08 22','  Cash','  Dine-in','30.00','0.00','0.00','0.0','23','202408221304',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240822-0000116','65.00','admin','2024 08 22','  Cash','  Dine-in','65.00','0.00','0.00','0.0','24','202408221307',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240822-0000117','30.00','admin','2024 08 22','  Cash','  Dine-in','30.00','0.00','0.00','0.0','25','202408221610',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240822-0000118','60.00','admin','2024 08 22','  Cash','  Dine-in','60.00','0.00','0.00','0.0','26','202408221614',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240822-0000119','55.00','admin','2024 08 22','  Cash','  Dine-in','55.00','0.00','0.00','0.0','27','202408221615',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240822-0000120','70.00','admin','2024 08 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','28','202408221616',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240822-0000121','85.00','admin','2024 08 22','  Cash','  Dine-in','85.00','0.00','0.00','0.0','29','202408221619',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240822-0000122','35.00','admin','2024 08 22','  Cash','  Dine-in','35.00','0.00','0.00','0.0','30','202408221625',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240822-0000123','30.00','admin','2024 08 22','  Cash','  Dine-in','30.00','0.00','0.00','0.0','31','202408221627',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240823-000011','60.00','admin','2024 08 23','  Cash','  Dine-in','60.00','0.00','0.00','0.0','32','202408231138',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240823-000012','30.00','admin','2024 08 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','33','202408231142',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240823-000013','30.00','admin','2024 08 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','34','202408231142',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240823-000014','30.00','admin','2024 08 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','35','202408231144',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
