INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','1',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','25.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','2',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','35.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','3',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','35.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','4',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','30.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'onion dosa','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','5',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','45.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000011','04:32:05 pm','2023 11 13','admin','1','  Dine-in','  Cash','205.00','205.00','6',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:32:05','%','0','35.00','no','0.00',NULL,'202311131632','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','1',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','35.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','2',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','25.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','3',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','35.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','4',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','30.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','5',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','20.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','6',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','60.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000021','04:33:17 pm','2023 11 13','admin','2','  Dine-in','  Pay Later','240.00','240.00','7',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:33:17','%','0','35.00','no','0.00',NULL,'202311131633','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','240',NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'Mutton-Biryani','5.00','200.00','1000.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000012','04:35:16 pm','2023 11 13','admin','1','  Dine-in','  Cash','990.00','990.00','7',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:16','%','1','990.00','yes','10.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non-Veg','admin','madmin',NULL,NULL,'41',NULL,NULL,'','','','',NULL,NULL),(15,'onion dosa','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','8',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','45.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','9',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','30.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'rava dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','10',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','35.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','11',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','40.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','12',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','35.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','13',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','30.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','14',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','20.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000013','04:35:54 pm','2023 11 13','admin','1','  Dine-in','  Cash','255.00','255.00','15',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:35:54','%','0','20.00','no','0.00',NULL,'202311131635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','1',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','35.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'roti','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','2',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','15.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'mutton biriyani','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','3',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','120.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','4',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','80.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'veg biriyani','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','5',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','140.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','6',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','40.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','7',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','60.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'chicken nuggets','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000031','04:36:24 pm','2023 11 13','admin','3','  Dine-in','  Cash','555.00','555.00','8',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:36:24','%','0','65.00','no','0.00',NULL,'202311131636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'rice','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000032','04:37:39 pm','2023 11 13','admin','3','  Dine-in','  Cash','125.00','125.00','9',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:37:39','%','0','30.00','no','0.00',NULL,'202311131637','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'roti','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000032','04:37:39 pm','2023 11 13','admin','3','  Dine-in','  Cash','125.00','125.00','10',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:37:39','%','0','15.00','no','0.00',NULL,'202311131637','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'chicken sukka','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000032','04:37:39 pm','2023 11 13','admin','3','  Dine-in','  Cash','125.00','125.00','11',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:37:39','%','0','80.00','no','0.00',NULL,'202311131637','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'rice','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','16',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','30.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','17',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','80.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','18',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','70.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','19',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','35.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'chicken nuggets','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','20',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','65.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'veg thali','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','21',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','50.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','22',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','100.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'roti','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','23',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','15.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'mutton biriyani','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','24',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','120.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'Mutton-Biryani','2.00','200.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','25',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','1','396.00','yes','4.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non-Veg','admin','madmin',NULL,NULL,'41',NULL,NULL,'','','','',NULL,NULL),(44,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000014','04:38:59 pm','2023 11 13','admin','1','  Dine-in','  Cash','1031.00','1031.00','26',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:38:59','%','0','70.00','no','0.00',NULL,'202311131638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'masal puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','8',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','35.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'chicken nuggets','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','9',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','65.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','10',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','60.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','11',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','35.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','12',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','70.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','13',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','80.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'mutton biriyani','2.0','120.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','14',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','240.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'rice','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','15',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','90.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'veg cutlet','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20231113-1-000022','04:40:38 pm','2023 11 13','admin','2','  Dine-in','  Cash','679.50','755.00','16',NULL,NULL,NULL,NULL,'13 Nov 2023','2023111316:40:38','%','0','80.00','no','0.00',NULL,'202311131640','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000011','10:25:44 am','2024 02 08','admin','1','  Dine-in','  Cash','120.00','120.00','1',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020810:25:44','%','0','50.00','no','0.00',NULL,'202402081025','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000011','10:25:44 am','2024 02 08','admin','1','  Dine-in','  Cash','120.00','120.00','2',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020810:25:44','%','0','35.00','no','0.00',NULL,'202402081025','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000011','10:25:44 am','2024 02 08','admin','1','  Dine-in','  Cash','120.00','120.00','3',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020810:25:44','%','0','35.00','no','0.00',NULL,'202402081025','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000031','02:19:03 pm','2024 02 08','admin','3','  Dine-in','  Cash','95.00','95.00','1',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020814:19:03','%','0','35.00','no','0.00',NULL,'202402081419','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000031','02:19:03 pm','2024 02 08','admin','3','  Dine-in','  Cash','95.00','95.00','2',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020814:19:03','%','0','35.00','no','0.00',NULL,'202402081419','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240208-1-000031','02:19:03 pm','2024 02 08','admin','3','  Dine-in','  Cash','95.00','95.00','3',NULL,NULL,NULL,NULL,'08 Feb 2024','2024020814:19:03','%','0','25.00','no','0.00',NULL,'202402081419','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'poori','0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240723-1-000011','01:26:06 pm','2024 07 23','admin','1','  Dine-in','  Cash','135.00','135.00','1',NULL,NULL,NULL,NULL,'23 Jul 2024','2024072313:26:06','%','0','35.00','no','0.00',NULL,'202407231326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(61,'bread omlette','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240723-1-000011','01:26:06 pm','2024 07 23','admin','1','  Dine-in','  Cash','135.00','135.00','2',NULL,NULL,NULL,NULL,'23 Jul 2024','2024072313:26:06','%','0','60.00','no','0.00',NULL,'202407231326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(62,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240723-1-000011','01:26:06 pm','2024 07 23','admin','1','  Dine-in','  Cash','135.00','135.00','3',NULL,NULL,NULL,NULL,'23 Jul 2024','2024072313:26:06','%','0','40.00','no','0.00',NULL,'202407231326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00');
INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (1,'poori','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20240723-1-000011','01:27:39 pm','2024 07 23','admin','  Dine-in','  Cash','135.00','135.0','1','Damaged/Spoiled','35.00','23 Jul 2024','35.00','%','0','35.00','no','','202407231327',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','35.00','35.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'2');
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,'20231113-1-000011','205.00','admin','2023 11 13','  Cash','  Dine-in','205.00','0.00','0.00','0.0','1','202311131632',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20231113-1-000021','240.00','admin','2023 11 13','  Pay Later','  Dine-in','240.00','0.00','0.00','0.0','2','202311131633',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20231113-1-000012','990.00','admin','2023 11 13','  Cash','  Dine-in','990.00','0.00','0.00','0.0','3','202311131635',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20231113-1-000013','255.00','admin','2023 11 13','  Cash','  Dine-in','255.00','0.00','0.00','0.0','4','202311131635',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20231113-1-000031','555.00','admin','2023 11 13','  Cash','  Dine-in','555.00','0.00','0.00','0.0','5','202311131636',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20231113-1-000032','125.00','admin','2023 11 13','  Cash','  Dine-in','125.00','0.00','0.00','0.0','6','202311131637',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20231113-1-000014','1031.00','admin','2023 11 13','  Cash','  Dine-in','1031.00','0.00','0.00','0.0','7','202311131638',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20231113-1-000022','679.50','admin','2023 11 13','  Cash','  Dine-in','755.00','0.00','+ 0.00','0.0','8','202311131640',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240208-1-000011','120.00','admin','2024 02 08','  Cash','  Dine-in','120.00','0.00','0.00','0.0','3','202402081025',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240208-1-000031','95.00','admin','2024 02 08','  Cash','  Dine-in','95.00','0.00','0.00','0.0','4','202402081419',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240723-1-000011','100.00','admin','2024 07 23','  Cash','  Dine-in','100.0','0.00','0.0','0.0','3','202407231326',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (1,'Aravindhan ','+919677755','aravindhan3@gmail.com','Chennai ',240,'240.0',NULL,NULL,NULL),(2,'Divya ','8300041145','divya96@gmail.com','Chennai ',125,'0.0',NULL,NULL,NULL);
INSERT INTO `cust_feedback` (`_id`, `cust_name`, `date`, `time`, `ambience_rating`, `pro_qual_rating`, `service_rating`, `overall_exp_rating`, `comments`, `percentage`, `cust_phoneno`) VALUES (1,'Aravindhan ','2023 11 14','08:50:13 AM','5','4','3.5','3.5','Nice ambience ','80.0','+919677755'),(2,'Divya ','2023 11 14','08:50:46 AM','4.5','4.5','5','4.5','good ','92.5','8300041145'),(3,'Deva','2023 11 14','08:51:00 AM','5','4.5','4','4.5','','90.0','9894852321');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2023 11 13','04:40:38 pm','20231113-1-000022','trynew','10','679.50','75.50','13 Nov 2023','755.00','8','202311131640',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Mutton-Biryani',1400),(2,'bread omlette',30),(3,'chicken biriyani',100),(4,'chicken nuggets',195),(5,'chicken sukka',80),(6,'dosa',140),(7,'idly',50),(8,'masal dosa',40),(9,'masal puri',105),(10,'masal vada',40),(11,'mutton biriyani',480),(12,'non veg thali',240),(13,'onion dosa',90),(14,'pani puri',70),(15,'pav bhajji',180),(16,'pongal',60),(17,'poori',105),(18,'rava dosa',70),(19,'rice',150),(20,'roti',45),(21,'upma',30),(22,'vada',20),(23,'veg biriyani',280),(24,'veg cutlet',120),(25,'veg thali',50);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'41','Mutton-Biryani',1400,34,'7','Non-Veg',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'7','bread omlette',30,1,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'22','chicken biriyani',100,2,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20','chicken nuggets',195,5,'3','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'29','chicken sukka',80,2,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'2','dosa',140,3,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1','idly',50,1,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'6','masal dosa',40,1,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'19','masal puri',105,3,'3','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'12','masal vada',40,1,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'25','mutton biriyani',480,12,'4','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'24','non veg thali',240,6,'3','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'8','onion dosa',90,2,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'16','pani puri',70,2,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'17','pav bhajji',180,4,'3','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'3','pongal',60,1,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'5','poori',105,3,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'9','rava dosa',70,2,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'27','rice',150,4,'5','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'26','roti',45,1,'3','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'4','upma',30,1,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'11','vada',20,1,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'21','veg biriyani',280,7,'4','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'18','veg cutlet',120,3,'3','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'23','veg thali',50,1,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Main course',1425),(2,'Non-Veg',1400),(3,'Snacks',730),(4,'Tiffin',615),(5,'Tiffin',135);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',4080);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',4080,100);
