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,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000011','06:01:59 pm','2024 08 22','admin','1','  Dine-in','  Cash','105.00','105.00','1',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:01:59','%','0','35.00','no','0.00',NULL,'202408221801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(2,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000011','06:01:59 pm','2024 08 22','admin','1','  Dine-in','  Cash','105.00','105.00','2',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:01:59','%','0','30.00','no','0.00',NULL,'202408221801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(3,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000011','06:01:59 pm','2024 08 22','admin','1','  Dine-in','  Cash','105.00','105.00','3',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:01:59','%','0','40.00','no','0.00',NULL,'202408221801','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(4,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000012','06:02:06 pm','2024 08 22','admin','1','  Dine-in','  Cash','20.00','20.00','4',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:06','%','0','20.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(5,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000013','06:02:17 pm','2024 08 22','admin','1','  Dine-in','  Cash','40.00','40.00','5',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:17','%','0','20.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(6,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000013','06:02:17 pm','2024 08 22','admin','1','  Dine-in','  Cash','40.00','40.00','6',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:17','%','0','20.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(7,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000014','06:02:31 pm','2024 08 22','admin','1','  Dine-in','  Cash','90.00','90.00','7',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:31','%','0','25.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(8,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000014','06:02:31 pm','2024 08 22','admin','1','  Dine-in','  Cash','90.00','90.00','8',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:31','%','0','35.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(9,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000014','06:02:31 pm','2024 08 22','admin','1','  Dine-in','  Cash','90.00','90.00','9',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:02:31','%','0','30.00','no','0.00',NULL,'202408221802','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(10,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','06:03:00 pm','2024 08 22','admin','1','  Dine-in','  Cash','125.00','125.00','10',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:00','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(11,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','06:03:00 pm','2024 08 22','admin','1','  Dine-in','  Cash','125.00','125.00','11',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:00','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(12,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','06:03:00 pm','2024 08 22','admin','1','  Dine-in','  Cash','125.00','125.00','12',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:00','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(13,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000015','06:03:00 pm','2024 08 22','admin','1','  Dine-in','  Cash','125.00','125.00','13',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:00','%','0','35.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(14,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000016','06:03:11 pm','2024 08 22','admin','1','  Dine-in','  Cash','95.00','95.00','14',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:11','%','0','35.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(15,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000016','06:03:11 pm','2024 08 22','admin','1','  Dine-in','  Cash','95.00','95.00','15',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:11','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(16,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000016','06:03:11 pm','2024 08 22','admin','1','  Dine-in','  Cash','95.00','95.00','16',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:11','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(17,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','06:03:23 pm','2024 08 22','admin','1','  Takeaway','  Cash','105.00','105.00','17',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:23','%','0','35.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(18,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','06:03:23 pm','2024 08 22','admin','1','  Takeaway','  Cash','105.00','105.00','18',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:23','%','0','30.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(19,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000017','06:03:23 pm','2024 08 22','admin','1','  Takeaway','  Cash','105.00','105.00','19',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:03:23','%','0','40.00','no','0.00',NULL,'202408221803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(20,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000018','06:04:25 pm','2024 08 22','admin','1','  Home delivery','  Cash','95.00','95.00','20',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:04:25','%','0','30.00','no','0.00',NULL,'202408221804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(21,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000018','06:04:25 pm','2024 08 22','admin','1','  Home delivery','  Cash','95.00','95.00','21',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:04:25','%','0','30.00','no','0.00',NULL,'202408221804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(22,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000018','06:04:25 pm','2024 08 22','admin','1','  Home delivery','  Cash','95.00','95.00','22',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:04:25','%','0','35.00','no','0.00',NULL,'202408221804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(23,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000019','06:04:51 pm','2024 08 22','admin','1','  Home delivery','  Cash','95.00','95.00','23',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:04:51','%','0','60.00','no','0.00',NULL,'202408221804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(24,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-000019','06:04:51 pm','2024 08 22','admin','1','  Home delivery','  Cash','95.00','95.00','24',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:04:51','%','0','35.00','no','0.00',NULL,'202408221804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(25,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000110','06:05:49 pm','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','25',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:05:49','%','0','25.00','no','0.00',NULL,'202408221805','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(26,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000110','06:05:49 pm','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','26',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:05:49','%','0','35.00','no','0.00',NULL,'202408221805','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(27,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000111','06:06:04 pm','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','27',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:04','%','0','40.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(28,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000111','06:06:04 pm','2024 08 22','admin','1','  Dine-in','  Cash','70.00','70.00','28',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:04','%','0','30.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(29,'pongal','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','29',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','60.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(30,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','30',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','70.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(31,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','31',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','40.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(32,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','32',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','25.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(33,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','33',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','20.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(34,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000112','06:06:25 pm','2024 08 22','admin','1','  Dine-in','  Cash','235.00','235.00','34',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:06:25','%','0','20.00','no','0.00',NULL,'202408221806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(35,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000113','06:09:14 pm','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','35',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:14','%','0','25.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(36,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000113','06:09:14 pm','2024 08 22','admin','1','  Dine-in','  Cash','60.00','60.00','36',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:14','%','0','35.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(37,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','06:09:23 pm','2024 08 22','admin','1','  Dine-in','  Cash','130.00','130.00','37',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:23','%','0','25.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(38,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','06:09:23 pm','2024 08 22','admin','1','  Dine-in','  Cash','130.00','130.00','38',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:23','%','0','35.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(39,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','06:09:23 pm','2024 08 22','admin','1','  Dine-in','  Cash','130.00','130.00','39',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:23','%','0','30.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(40,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000114','06:09:23 pm','2024 08 22','admin','1','  Dine-in','  Cash','130.00','130.00','40',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:23','%','0','40.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(41,'soft drinks','4.0','10.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000115','06:09:54 pm','2024 08 22','admin','1','  Dine-in','  Cash','425.00','425.00','41',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:54','%','0','40.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'10.00'),(42,'veg thali','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000115','06:09:54 pm','2024 08 22','admin','1','  Dine-in','  Cash','425.00','425.00','42',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:54','%','0','150.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'150.00','','','','',NULL,'50.00'),(43,'masal vada','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000115','06:09:54 pm','2024 08 22','admin','1','  Dine-in','  Cash','425.00','425.00','43',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:54','%','0','60.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(44,'dosa','5.0','35.00','175.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000115','06:09:54 pm','2024 08 22','admin','1','  Dine-in','  Cash','425.00','425.00','44',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:09:54','%','0','175.00','no','0.00',NULL,'202408221809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'175.00','','','','',NULL,'35.00'),(45,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','06:10:46 pm','2024 08 22','admin','1','  Takeaway','  Cash','130.00','130.00','45',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:10:46','%','0','30.00','no','0.00',NULL,'202408221810','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(46,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','06:10:46 pm','2024 08 22','admin','1','  Takeaway','  Cash','130.00','130.00','46',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:10:46','%','0','35.00','no','0.00',NULL,'202408221810','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(47,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','06:10:46 pm','2024 08 22','admin','1','  Takeaway','  Cash','130.00','130.00','47',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:10:46','%','0','30.00','no','0.00',NULL,'202408221810','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(48,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240822-0000116','06:10:46 pm','2024 08 22','admin','1','  Takeaway','  Cash','130.00','130.00','48',NULL,NULL,NULL,NULL,'22 Aug 2024','2024082218:10:46','%','0','35.00','no','0.00',NULL,'202408221810','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.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,'20240822-000011','105.00','admin','2024 08 22','  Cash','  Dine-in','105.00','0.00','0.00','0.0','1','202408221801',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240822-000012','20.00','admin','2024 08 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','2','202408221802',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240822-000013','40.00','admin','2024 08 22','  Cash','  Dine-in','40.00','0.00','0.00','0.0','3','202408221802',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240822-000014','90.00','admin','2024 08 22','  Cash','  Dine-in','90.00','0.00','0.00','0.0','4','202408221802',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240822-000015','125.00','admin','2024 08 22','  Cash','  Dine-in','125.00','0.00','0.00','0.0','5','202408221803',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240822-000016','95.00','admin','2024 08 22','  Cash','  Dine-in','95.00','0.00','0.00','0.0','6','202408221803',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240822-000017','105.00','admin','2024 08 22','  Cash','  Takeaway','105.00','0.00','0.00','0.0','7','202408221803',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240822-000018','95.00','admin','2024 08 22','  Cash','  Home delivery','95.00','0.00','0.00','0.0','8','202408221804',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240822-000019','95.00','admin','2024 08 22','  Cash','  Home delivery','95.00','0.00','0.00','0.0','9','202408221804',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240822-0000110','60.00','admin','2024 08 22','  Cash','  Dine-in','60.00','0.00','0.00','0.0','10','202408221805',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240822-0000111','70.00','admin','2024 08 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','11','202408221806',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240822-0000112','235.00','admin','2024 08 22','  Cash','  Dine-in','235.00','0.00','0.00','0.0','12','202408221806',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240822-0000113','60.00','admin','2024 08 22','  Cash','  Dine-in','60.00','0.00','0.00','0.0','13','202408221809',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240822-0000114','130.00','admin','2024 08 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','14','202408221809',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240822-0000115','425.00','admin','2024 08 22','  Cash','  Dine-in','425.00','0.00','0.00','0.0','15','202408221809',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240822-0000116','130.00','admin','2024 08 22','  Cash','  Takeaway','130.00','0.00','0.00','0.0','16','202408221810',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
