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`) VALUES (1,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000011','02:22:03 PM','2022 12 22','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:22:03','%','0','25.00','no','0.00',NULL,'202212221422','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(2,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000012','02:23:29 PM','2022 12 22','admin','1','  Dine-in','  Cash','50.00','50.00','2',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:23:29','%','0','50.00','no','0.00',NULL,'202212221423','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(3,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000013','02:45:49 PM','2022 12 22','admin','1','  Dine-in','  Cash','25.00','25.00','8',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:45:49','%','0','25.00','no','0.00',NULL,'202212221445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(4,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000014','02:45:58 PM','2022 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','9',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:45:58','%','0','30.00','no','0.00',NULL,'202212221445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(5,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000014','02:45:58 PM','2022 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','10',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:45:58','%','0','35.00','no','0.00',NULL,'202212221445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(6,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000014','02:45:58 PM','2022 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','11',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:45:58','%','0','35.00','no','0.00',NULL,'202212221445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(7,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000014','02:45:58 PM','2022 12 22','admin','1','  Dine-in','  Cash','130.00','130.00','12',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:45:58','%','0','30.00','no','0.00',NULL,'202212221445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(8,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000015','02:52:32 PM','2022 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','13',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:52:32','%','0','25.00','no','0.00',NULL,'202212221452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(9,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000015','02:52:32 PM','2022 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','14',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:52:32','%','0','35.00','no','0.00',NULL,'202212221452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(10,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000015','02:52:32 PM','2022 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','15',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:52:32','%','0','30.00','no','0.00',NULL,'202212221452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(11,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000015','02:52:32 PM','2022 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','16',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122214:52:32','%','0','30.00','no','0.00',NULL,'202212221452','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(12,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000016','03:09:20 PM','2022 12 22','admin','1','  Dine-in','  Cash','35.00','35.00','17',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:09:20','%','0','35.00','no','0.00',NULL,'202212221509','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(13,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000017','03:11:04 PM','2022 12 22','admin','1','  Dine-in','  Cash','20.00','20.00','18',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:11:04','%','0','20.00','no','0.00',NULL,'202212221511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(14,'chicken kabab','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000018','03:12:05 PM','2022 12 22','admin','1','  Dine-in','  Cash','120.00','120.00','19',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:12:05','%','0','120.00','no','0.00',NULL,'202212221512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(15,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','20',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','25.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(16,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','21',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(17,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','22',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(18,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','23',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(19,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','24',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(20,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','25',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','40.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(21,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','26',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(22,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','27',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(23,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','28',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(24,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','29',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(25,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','30',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','20.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(26,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','31',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','20.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(27,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','32',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','20.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(28,'chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','33',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','60.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(29,'sheekh kabab','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','34',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','80.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(30,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','35',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(31,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','36',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','60.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(32,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','37',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','40.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(33,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','38',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(34,'chicken nuggets','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-000019','03:38:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','760.00','760.00','39',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:18','%','0','65.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(35,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000110','03:38:46 PM','2022 12 22','admin','1','  Dine-in','  Cash','155.00','155.00','40',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:46','%','0','25.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(36,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000110','03:38:46 PM','2022 12 22','admin','1','  Dine-in','  Cash','155.00','155.00','41',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:46','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(37,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000110','03:38:46 PM','2022 12 22','admin','1','  Dine-in','  Cash','155.00','155.00','42',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:46','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(38,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000110','03:38:46 PM','2022 12 22','admin','1','  Dine-in','  Cash','155.00','155.00','43',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:46','%','0','30.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(39,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000110','03:38:46 PM','2022 12 22','admin','1','  Dine-in','  Cash','155.00','155.00','44',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122215:38:46','%','0','35.00','no','0.00',NULL,'202212221538','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(40,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000111','04:18:57 PM','2022 12 22','admin','1','  Dine-in','  Cash','75.00','75.00','45',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:18:57','%','0','35.00','no','0.00',NULL,'202212221618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(41,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000111','04:18:57 PM','2022 12 22','admin','1','  Dine-in','  Cash','75.00','75.00','46',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:18:57','%','0','40.00','no','0.00',NULL,'202212221618','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(42,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000112','04:19:04 PM','2022 12 22','admin','1','  Dine-in','  Cash','110.00','110.00','47',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:19:04','%','0','20.00','no','0.00',NULL,'202212221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(43,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000112','04:19:04 PM','2022 12 22','admin','1','  Dine-in','  Cash','110.00','110.00','48',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:19:04','%','0','20.00','no','0.00',NULL,'202212221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(44,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000112','04:19:04 PM','2022 12 22','admin','1','  Dine-in','  Cash','110.00','110.00','49',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:19:04','%','0','30.00','no','0.00',NULL,'202212221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(45,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000112','04:19:04 PM','2022 12 22','admin','1','  Dine-in','  Cash','110.00','110.00','50',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:19:04','%','0','40.00','no','0.00',NULL,'202212221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(46,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000113','04:24:53 PM','2022 12 22','admin','1','  Dine-in','  Cash','25.00','25.00','51',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:24:53','%','0','25.00','no','0.00',NULL,'202212221624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(47,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','52',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','35.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(48,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','53',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','60.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(49,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','54',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','20.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(50,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','55',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','20.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(51,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','56',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','40.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(52,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','57',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','30.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(53,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','58',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','25.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(54,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000114','04:39:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','265.00','265.00','59',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:34','%','0','35.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(55,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','60',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','20.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(56,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','61',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','20.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(57,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','62',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','20.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(58,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','63',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','40.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(59,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','64',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','60.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(60,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000115','04:39:45 PM','2022 12 22','admin','1','  Dine-in','  Cash','195.00','195.00','65',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:39:45','%','0','35.00','no','0.00',NULL,'202212221639','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(61,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000116','04:49:13 PM','2022 12 22','admin','1','  Dine-in','  Cash','135.00','135.00','66',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:13','%','0','20.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(62,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000116','04:49:13 PM','2022 12 22','admin','1','  Dine-in','  Cash','135.00','135.00','67',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:13','%','0','20.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(63,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000116','04:49:13 PM','2022 12 22','admin','1','  Dine-in','  Cash','135.00','135.00','68',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:13','%','0','35.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(64,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000116','04:49:13 PM','2022 12 22','admin','1','  Dine-in','  Cash','135.00','135.00','69',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:13','%','0','60.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(65,'veg cutlet','49.0','40.00','1960.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','70',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','1960.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(66,'pav bhajji','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','71',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','120.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(67,'masal vada','16.0','20.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','72',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','320.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(68,'masal dosa','3.0','40.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','73',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','120.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(69,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','74',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','40.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(70,'bread omlette','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000117','04:49:35 PM','2022 12 22','admin','1','  Dine-in','  Cash','2650.00','2650.00','75',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122216:49:35','%','0','90.00','no','0.00',NULL,'202212221649','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(71,'masal dosa','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000118','05:22:18 PM','2022 12 22','admin','1','  Dine-in','  Cash','80.00','80.00','76',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:22:18','%','0','80.00','no','0.00',NULL,'202212221722','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(72,'pav bhajji','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000119','05:23:23 PM','2022 12 22','admin','1','  Dine-in','  Cash','980.00','980.00','78',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:23:23','%','0','120.00','no','0.00',NULL,'202212221723','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(73,'masal vada','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000119','05:23:23 PM','2022 12 22','admin','1','  Dine-in','  Cash','980.00','980.00','79',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:23:23','%','0','80.00','no','0.00',NULL,'202212221723','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(74,'veg cutlet','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000119','05:23:23 PM','2022 12 22','admin','1','  Dine-in','  Cash','980.00','980.00','80',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:23:23','%','0','80.00','no','0.00',NULL,'202212221723','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(75,'vada','35.0','20.00','700.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000119','05:23:23 PM','2022 12 22','admin','1','  Dine-in','  Cash','980.00','980.00','81',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:23:23','%','0','700.00','no','0.00',NULL,'202212221723','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(76,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000120','05:24:09 PM','2022 12 22','admin','1','  Dine-in','  Cash','20.00','20.00','82',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:24:09','%','0','20.00','no','0.00',NULL,'202212221724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(77,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000121','05:25:34 PM','2022 12 22','admin','1','  Dine-in','  Cash','20.00','20.00','84',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:25:34','%','0','20.00','no','0.00',NULL,'202212221725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(78,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20221222-1-0000122','05:25:42 PM','2022 12 22','admin','1','  Dine-in','  Cash','20.00','20.00','85',NULL,NULL,NULL,NULL,'22 Dec 2022','2022122217:25:42','%','0','20.00','no','0.00',NULL,'202212221725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','');
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`) VALUES (1,'20221222-1-000011','25.00','admin','2022 12 22','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202212221422',NULL,NULL,NULL,NULL,NULL),(2,'20221222-1-000012','50.00','admin','2022 12 22','  Cash','  Dine-in','50.00','0.00','0.00','0.0','2','202212221423',NULL,NULL,NULL,NULL,NULL),(3,'20221222-1-000013','25.00','admin','2022 12 22','  Cash','  Dine-in','25.00','0.00','0.00','0.0','3','202212221445',NULL,NULL,NULL,NULL,NULL),(4,'20221222-1-000014','130.00','admin','2022 12 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','4','202212221445',NULL,NULL,NULL,NULL,NULL),(5,'20221222-1-000015','120.00','admin','2022 12 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','5','202212221452',NULL,NULL,NULL,NULL,NULL),(6,'20221222-1-000016','35.00','admin','2022 12 22','  Cash','  Dine-in','35.00','0.00','0.00','0.0','6','202212221509',NULL,NULL,NULL,NULL,NULL),(7,'20221222-1-000017','20.00','admin','2022 12 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','7','202212221511',NULL,NULL,NULL,NULL,NULL),(8,'20221222-1-000018','120.00','admin','2022 12 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','8','202212221512',NULL,NULL,NULL,NULL,NULL),(9,'20221222-1-000019','760.00','admin','2022 12 22','  Cash','  Dine-in','760.00','0.00','0.00','0.0','9','202212221538',NULL,NULL,NULL,NULL,NULL),(10,'20221222-1-0000110','155.00','admin','2022 12 22','  Cash','  Dine-in','155.00','0.00','0.00','0.0','10','202212221538',NULL,NULL,NULL,NULL,NULL),(11,'20221222-1-0000111','75.00','admin','2022 12 22','  Cash','  Dine-in','75.00','0.00','0.00','0.0','11','202212221618',NULL,NULL,NULL,NULL,NULL),(12,'20221222-1-0000112','110.00','admin','2022 12 22','  Cash','  Dine-in','110.00','0.00','0.00','0.0','12','202212221619',NULL,NULL,NULL,NULL,NULL),(13,'20221222-1-0000113','25.00','admin','2022 12 22','  Cash','  Dine-in','25.00','0.00','0.00','0.0','13','202212221624',NULL,NULL,NULL,NULL,NULL),(14,'20221222-1-0000114','265.00','admin','2022 12 22','  Cash','  Dine-in','265.00','0.00','0.00','0.0','14','202212221639',NULL,NULL,NULL,NULL,NULL),(15,'20221222-1-0000115','195.00','admin','2022 12 22','  Cash','  Dine-in','195.00','0.00','0.00','0.0','15','202212221639',NULL,NULL,NULL,NULL,NULL),(16,'20221222-1-0000116','135.00','admin','2022 12 22','  Cash','  Dine-in','135.00','0.00','0.00','0.0','16','202212221649',NULL,NULL,NULL,NULL,NULL),(17,'20221222-1-0000117','2650.00','admin','2022 12 22','  Cash','  Dine-in','2650.00','0.00','0.00','0.0','17','202212221649',NULL,NULL,NULL,NULL,NULL),(18,'20221222-1-0000118','80.00','admin','2022 12 22','  Cash','  Dine-in','80.00','0.00','0.00','0.0','18','202212221722',NULL,NULL,NULL,NULL,NULL),(19,'20221222-1-0000119','980.00','admin','2022 12 22','  Cash','  Dine-in','980.00','0.00','0.00','0.0','19','202212221723',NULL,NULL,NULL,NULL,NULL),(20,'20221222-1-0000120','20.00','admin','2022 12 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','20','202212221724',NULL,NULL,NULL,NULL,NULL),(21,'20221222-1-0000121','20.00','admin','2022 12 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','21','202212221725',NULL,NULL,NULL,NULL,NULL),(22,'20221222-1-0000122','20.00','admin','2022 12 22','  Cash','  Dine-in','20.00','0.00','0.00','0.0','22','202212221725',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
