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,'Wagh Bakri','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-1-000011','11:34:58 AM','2024 09 05','admin','1','  Takeaway','  Cash','15.00','15.00','1',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090511:34:58','%','0','15.00','no','0.00',NULL,'202409051134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,NULL),(2,'Wagh Bakri','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000011','01:04:52 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','15.00','15.00','2',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:04:52','%','0','15.00','no','0.00',NULL,'202410010104','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,NULL),(3,'Upma','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000012','01:07:36 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','40.00','40.00','3',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:07:36','%','0','40.00','no','0.00',NULL,'202410010107','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(4,'Tomato Soup','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000013','01:08:15 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','20.00','20.00','4',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:08:15','%','0','20.00','no','0.00',NULL,'202410010108','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(5,'Fish Curry','40.0','100.00','4000.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','5',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','4000.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'4000.00','','','','',NULL,NULL),(6,'Chicken Curry','5.0','100.00','500.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','6',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','500.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'500.00','','','','',NULL,NULL),(7,'Vada Pao','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','7',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','90.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,NULL),(8,'Paneer curry','2.0','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','8',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','140.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,NULL),(9,'Egg Curru','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','9',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','160.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'160.00','','','','',NULL,NULL),(10,'Curd','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','10',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','30.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,NULL),(11,'Rabri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','11',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','35.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,NULL),(12,'Veg Curry','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','12',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','80.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(13,'P Veg Curry','18.0','80.00','1440.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','13',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','1440.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'1440.00','','','','',NULL,NULL),(14,'Cake','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','14',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(15,'Waffi','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','15',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','40.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(16,'RTE MEAL1','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','16',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','120.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,NULL),(17,'Kurkure','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','17',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(18,'Biscuit','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','18',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(19,'Chip','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','19',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','40.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(20,'Chips ','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','20',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','60.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,NULL),(21,'Namkin','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','21',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','40.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(22,'Mango Drink','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','22',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(23,'Jamping','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','23',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(24,'Flavour Milk','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','24',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','30.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,NULL),(25,'Aloo Bonda','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','25',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','40.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(26,'Std Chicken Meal','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','26',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','130.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'130.00','','','','',NULL,NULL),(27,'Idli','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','27',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','80.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(28,'Tomato Soup','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','28',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(29,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','29',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','25.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(30,'Wagh Bakri','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','30',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','15.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,NULL),(31,'Bread Omelett','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','31',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','50.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,NULL),(32,'Vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','32',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(33,'Samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','33',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(34,'Veg Cutlet','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','34',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','80.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(35,'Veg Biryani','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','35',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','80.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(36,'Curd Rice','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','36',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','50.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,NULL),(37,'Janta Meal','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','37',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','20.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(38,'Chicken biryani','2.0','110.00','220.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','38',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','220.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'220.00','','','','',NULL,NULL),(39,'Rajma/Chole Rice','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','39',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','100.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,NULL),(40,'Lassi','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','40',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','25.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(41,'Tea','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','41',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','10.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,NULL),(42,'Egg Biryani','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','42',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','90.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,NULL),(43,'Std Veg Meal','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','43',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','80.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(44,'Std Non Veg BF','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','44',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','50.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,NULL),(45,'Masala/Medu Vada','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000014','01:32:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','8140.00','8140.00','45',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:32:06','%','0','30.00','no','0.00',NULL,'202410010132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,NULL),(46,'Tomato Soup','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000015','01:42:06 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','21.00','21.00','46',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:42:06','%','0','20.00','no','0.00',NULL,'202410010142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(47,'Veg Cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000016','01:42:17 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','42.00','42.00','47',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:42:17','%','0','40.00','no','0.00',NULL,'202410010142','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(48,'Veg Cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000017','01:44:57 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','42.00','42.00','48',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:44:57','%','0','40.00','no','0.00',NULL,'202410010144','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(49,'Masala/Medu Vada','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000018','01:45:14 AM','2024 10 01','ladmin','1','  Dine-in','  Cash','31.50','31.50','49',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:45:14','%','0','30.00','no','0.00',NULL,'202410010145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,NULL),(50,'Upma','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-000019','01:45:41 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','42.00','42.00','50',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:45:41','%','0','40.00','no','0.00',NULL,'202410010145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,NULL),(51,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000110','01:46:05 AM','2024 10 01','ladmin','1','  Takeaway','  Upiqr','68.25','68.25','51',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:46:05','%','0','25.00','no','0.00',NULL,'202410010146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin','0',NULL,'',NULL,'25.00','','','','',NULL,NULL),(52,'Upma','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000110','01:46:05 AM','2024 10 01','ladmin','1','  Takeaway','  Upiqr','68.25','68.25','52',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:46:05','%','0','40.00','no','0.00',NULL,'202410010146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin','0',NULL,'',NULL,'40.00','','','','',NULL,NULL),(53,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000111','01:46:20 AM','2024 10 01','ladmin','1','  Takeaway','  Upiqr','26.25','26.25','53',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:46:20','%','0','25.00','no','0.00',NULL,'202410010146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin','0',NULL,'',NULL,'25.00','','','','',NULL,NULL),(54,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000112','01:47:13 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','26.25','26.25','54',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:47:13','%','0','25.00','no','0.00',NULL,'202410010147','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(55,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000113','01:47:58 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','26.25','26.25','55',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:47:58','%','0','25.00','no','0.00',NULL,'202410010147','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(56,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000114','01:48:20 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','26.25','26.25','56',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:48:20','%','0','25.00','no','0.00',NULL,'202410010148','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(57,'Upma','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000115','01:49:12 AM','2024 10 01','ladmin','1','  Dine-in','  Cash','105.00','105.00','57',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:49:12','%','0','80.00','no','0.00',NULL,'202410010149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,NULL),(58,'Tomato Soup','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000115','01:49:12 AM','2024 10 01','ladmin','1','  Dine-in','  Cash','105.00','105.00','58',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:49:12','%','0','20.00','no','0.00',NULL,'202410010149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(59,'Chicken Curry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000116','01:50:04 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','105.00','105.00','59',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:50:04','%','0','100.00','no','0.00',NULL,'202410010150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,NULL),(60,'Wagh Bakri','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000117','01:50:20 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','15.75','15.75','60',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:50:20','%','0','15.00','no','0.00',NULL,'202410010150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,NULL),(61,'Tomato Soup','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000118','01:50:35 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','21.00','21.00','61',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:50:35','%','0','20.00','no','0.00',NULL,'202410010150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,NULL),(62,'Cappuccino','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000119','01:51:51 AM','2024 10 01','ladmin','1','  Takeaway','  Cash','26.25','26.25','62',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100101:51:51','%','0','25.00','no','0.00',NULL,'202410010151','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,NULL),(63,'Curd Rice','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241001-1-0000120','03:20:32 PM','2024 10 01','ladmin','1','  Takeaway','  Cash','52.50','52.50','63',NULL,NULL,NULL,NULL,'01 Oct 2024','2024100115:20:32','%','0','50.00','no','0.00',NULL,'202410011520','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',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`, `order_id`) VALUES (1,'20240905-1-000011','15.00','admin','2024 09 05','  Cash','  Takeaway','15.00','0.00','0.00','0.0','1','202409051134',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241001-1-000011','15.00','ladmin','2024 10 01','  Cash','  Takeaway','15.00','0.00','0.00','0.0','2','202410010104',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241001-1-000012','40.00','ladmin','2024 10 01','  Cash','  Takeaway','40.00','0.00','0.00','0.0','3','202410010107',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241001-1-000013','20.00','ladmin','2024 10 01','  Cash','  Takeaway','20.00','0.00','0.00','0.0','4','202410010108',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241001-1-000014','8140.00','ladmin','2024 10 01','  Cash','  Takeaway','8140.00','0.00','0.00','0.0','5','202410010132',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241001-1-000015','21.00','ladmin','2024 10 01','  Cash','  Takeaway','20.00','1.00','0.00','5.0','6','202410010142',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241001-1-000016','42.00','ladmin','2024 10 01','  Cash','  Takeaway','40.00','2.00','0.00','5.0','7','202410010142',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20241001-1-000017','42.00','ladmin','2024 10 01','  Cash','  Takeaway','40.00','2.00','0.00','5.0','8','202410010144',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20241001-1-000018','31.50','ladmin','2024 10 01','  Cash','  Dine-in','30.00','1.50','0.00','5.0','9','202410010145',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20241001-1-000019','42.00','ladmin','2024 10 01','  Cash','  Takeaway','40.00','2.00','0.00','5.0','10','202410010145',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20241001-1-0000110','68.25','ladmin','2024 10 01','  Upiqr','  Takeaway','65.00','3.25','0.00','5.0','11','202410010146',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20241001-1-0000111','26.25','ladmin','2024 10 01','  Upiqr','  Takeaway','25.00','1.25','0.00','5.0','12','202410010146',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20241001-1-0000112','26.25','ladmin','2024 10 01','  Cash','  Takeaway','25.00','1.25','0.00','5.0','13','202410010147',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20241001-1-0000113','26.25','ladmin','2024 10 01','  Cash','  Takeaway','25.00','1.25','0.00','5.0','14','202410010147',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20241001-1-0000114','26.25','ladmin','2024 10 01','  Cash','  Takeaway','25.00','1.25','0.00','5.0','15','202410010148',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20241001-1-0000115','105.00','ladmin','2024 10 01','  Cash','  Dine-in','100.00','5.00','0.00','5.0','16','202410010149',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20241001-1-0000116','105.00','ladmin','2024 10 01','  Cash','  Takeaway','100.00','5.00','0.00','5.0','17','202410010150',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20241001-1-0000117','15.75','ladmin','2024 10 01','  Cash','  Takeaway','15.00','0.75','0.00','5.0','18','202410010150',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20241001-1-0000118','21.00','ladmin','2024 10 01','  Cash','  Takeaway','20.00','1.00','0.00','5.0','19','202410010150',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20241001-1-0000119','26.25','ladmin','2024 10 01','  Cash','  Takeaway','25.00','1.25','0.00','5.0','20','202410010151',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20241001-1-0000120','52.50','ladmin','2024 10 01','  Cash','  Takeaway','50.00','2.50','0.00','5.0','21','202410011520',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Aloo Bonda',40),(2,'Biscuit',20),(3,'Bread Omelett',50),(4,'Cake',20),(5,'Cappuccino',175),(6,'Chicken Curry',600),(7,'Chicken biryani',220),(8,'Chip',40),(9,'Chips ',60),(10,'Curd',30),(11,'Curd Rice',100),(12,'Egg Biryani',90),(13,'Egg Curru',160),(14,'Fish Curry',4000),(15,'Flavour Milk',30),(16,'Idli',80),(17,'Jamping',20),(18,'Janta Meal',20),(19,'Kurkure',20),(20,'Lassi',25),(21,'Mango Drink',20),(22,'Masala/Medu Vada',60),(23,'Namkin',40),(24,'P Veg Curry',1440),(25,'Paneer curry',140),(26,'RTE MEAL1',120),(27,'Rabri',35),(28,'Rajma/Chole Rice',100),(29,'Samosa',20),(30,'Std Chicken Meal',130),(31,'Std Non Veg BF',50),(32,'Std Veg Meal',80),(33,'Tea',10),(34,'Tomato Soup',100),(35,'Upma',200),(36,'Vada',20),(37,'Vada Pao',90),(38,'Veg Biryani',80),(39,'Veg Curry',80),(40,'Veg Cutlet',160),(41,'Waffi',40),(42,'Wagh Bakri',45);
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,'66','Aloo Bonda',40,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'75','Biscuit',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'44','Bread Omelett',50,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'77','Cake',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'46','Cappuccino',175,2,'7','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'88','Chicken Curry',600,7,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'53','Chicken biryani',220,3,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'71','Chip',40,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'72','Chips ',60,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'83','Curd',30,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'51','Curd Rice',100,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'54','Egg Biryani',90,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'86','Egg Curru',160,2,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'87','Fish Curry',4000,45,'40','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'70','Flavour Milk',30,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'41','Idli',80,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'69','Jamping',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'50','Janta Meal',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'76','Kurkure',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'58','Lassi',25,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'68','Mango Drink',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'67','Masala/Medu Vada',60,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'73','Namkin',40,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'81','P Veg Curry',1440,16,'18','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'89','Paneer curry',140,2,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'79','RTE MEAL1',120,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'84','Rabri',35,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'55','Rajma/Chole Rice',100,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'48','Samosa',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'65','Std Chicken Meal',130,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'62','Std Non Veg BF',50,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'63','Std Veg Meal',80,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'57','Tea',10,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'42','Tomato Soup',100,1,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'43','Upma',200,2,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'47','Vada',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'90','Vada Pao',90,1,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'52','Veg Biryani',80,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'82','Veg Curry',80,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'49','Veg Cutlet',160,2,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'78','Waffi',40,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'45','Wagh Bakri',45,1,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (64,'None',8860);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',8892);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',8892,100);
