INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'Friday','0','0'),(6,'Saturday','0','0'),(7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'On');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,'','1',NULL,'1 st floor ','0','4','0'),(2,'1','2',NULL,'1 st floor ','0','4','0'),(3,'2','3',NULL,'1 st floor ','0','4',NULL),(4,'','1',NULL,'Ac','1','4',NULL),(5,'','2',NULL,'Ac','1','4',NULL),(6,'','3',NULL,'Ac','1','4',NULL),(7,'','4',NULL,'Ac','1','4',NULL),(8,'','5',NULL,'Ac','1','4',NULL),(9,'','6',NULL,'Ac','1','4',NULL),(10,'','7',NULL,'Ac','1','4',NULL),(11,'','8',NULL,'Ac','1','4',NULL),(12,'','9',NULL,'Ac','1','4',NULL),(13,'','10',NULL,'Ac','1','4',NULL),(14,'','4',NULL,'1 st floor ','0','4',NULL),(15,'','15',NULL,'1 st floor ','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'Off');
INSERT INTO `billcount_tag` (`_id`, `tag_name`) VALUES (1,'Swadpurna ');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'InnerPrinter','00:11:22:33:44:55','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Not Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated'),(7,'mosambee','9633932257','5566','Activated'),(8,'mosambeep10','','','Not Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (1,'CAFE','9535897598',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','www.intuitionsoftwares.com','','');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'Disc10','10','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Abc','9535897598','reshmajs1611@gmail.com'),(2,'SHAM','','sham.media07@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'1 st floor ','0');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'COOL DRINKS',NULL,NULL,NULL,NULL),(4,'NONVEG PIZZA',NULL,NULL,NULL,NULL),(5,'VEG SANDWICH',NULL,NULL,NULL,NULL),(6,'CHICKEN SANDWICH',NULL,NULL,NULL,NULL),(7,'NONVEG WRAPS',NULL,NULL,NULL,NULL),(8,'VEG PIZZA',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'sugar','coffee','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(2,'sugar','tea','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(3,'sugar','soft drinks','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(4,'sugar','lime juice','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(5,'sugar','lassi','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(6,'sugar','grape juice','0','25.0','21 Mar 2023','202303211006','10:06:06 am','1006','202303211006','Kg','9.0'),(7,'Tea Dust','Tea ','0.005','20.00','01 Apr 2023','202304011646','04:46:56 pm','1646','202304051617','Kg','-20.0'),(8,'Tea Dust','parcel Tea','0.005','20.00','01 Apr 2023','202304011646','04:46:56 pm','1646','202304051617','Kg','-20.0'),(9,'sugar','Tea ','.010','25.0','01 Apr 2023','202304011647','04:47:51 pm','1647','202304051618','Kg','-25.0'),(10,'sugar','parcel Tea','0.20','25.0','01 Apr 2023','202304011647','04:47:51 pm','1647','202304051618','Kg','-25.0'),(13,'Rice ','pongal','0.2','11.0','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(14,'Rice ','idly','0','11.0','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(15,'Rice ','dosa','0','11.0','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(19,'onion','onion dosa','0.5','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(20,'onion','uthappam','0.2','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(21,'onion','vada','0.1','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(22,'onion','masal vada','0.5','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(23,'onion','samosa','0.5','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(24,'onion','chicken kabab','0.1','3.60','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(25,'lemon ','lime juice','0','25.0','01 Apr 2024','202404011418','02:18:42 pm','1418','202404011418','no.','50.0'),(26,'orange ','orange juice ','0','5.00','01 Apr 2024','202404011427','02:27:59 pm','1427','202404011427','Kg','10.0'),(27,'Rice ','Test item ','.20','11.0','14 May 2024','2024 05 14','11:55:30 am','1155','202405141155','Kg',NULL),(28,'Rice ','idly','0.10','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(29,'Rice ','dosa','0.10','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(30,'Rice ','pongal','0.50','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(31,'Rice ','masal dosa','0.10','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(32,'Rice ','onion dosa','0','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(33,'Rice ','rava dosa','0','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(34,'Rice ','uthappam','0','11.0','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(35,'Biryani ','Mandi biryani full','0.2','0','09 May 2025','202505091110','11:10:42 am','1110','202505091110','Kg','20.0'),(36,'Biryani ','Mandi biryani half ','0.1','0','09 May 2025','202505091110','11:10:42 am','1110','202505091110','Kg','20.0'),(37,'Oil','dosa','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(38,'Oil','upma','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(39,'Oil','poori','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(40,'Oil','masal dosa','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(41,'Oil','onion dosa','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(42,'Oil','chicken kabab','0.5','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(43,'Oil','sheekh kabab','0','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(44,'Oil','samosa','0.5','15.5','10 May 2025','202505101127','11:27:36 am','1127','202505101127','Kg','15.0'),(45,'Boneless chicken ','chicken kabab','0.18','5.18','14 May 2025','202505141824','06:24:01 pm','1824','202505141824','Kg','5.0'),(46,'Boneless chicken ','chicken nuggets','0.18','5.18','14 May 2025','202505141824','06:24:01 pm','1824','202505141824','Kg','5.0'),(47,'Boneless chicken ','chicken biriyani','0.18','5.18','14 May 2025','202505141824','06:24:01 pm','1824','202505141824','Kg','5.0'),(48,'Boneless chicken ','chicken sukka','0.18','5.18','14 May 2025','202505141824','06:24:01 pm','1824','202505141824','Kg','5.0'),(49,'sugar','coffee','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(50,'sugar','tea','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(51,'sugar','plain Tea Regular','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(52,'sugar','plain Tea large','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(53,'sugar','Ginger Tea Regular.','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(54,'sugar','Ginger Tea Large','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(55,'sugar','Masala Tea Regular','0.01','4.96','15 May 2025','202505151054','10:54:15 am','1054','202505151054','Kg','5.0'),(56,'Basmati Rice','Mandi biryani full','0.1','3','15 May 2025','202505151210','12:10:03 pm','1210','202505151210','Kg','7.0'),(57,'Basmati Rice','Mandi biryani half ','0.1','3','15 May 2025','202505151210','12:10:03 pm','1210','202505151210','Kg','7.0'),(58,'Oil','poori','0.5','15.5','15 May 2025','202505151214','12:14:05 pm','1214','202505151214','L','5.0'),(59,'Oil','samosa','0.5','15.5','15 May 2025','202505151214','12:14:05 pm','1214','202505151214','L','5.0'),(60,'coffe powder ','coffee','0.01','1','09 Jun 2025','202506091418','02:18:53 pm','1418','202506091418','Kg','19.0'),(61,'sugar','coffee','00.001','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(62,'sugar','lime juice','00.005','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(63,'sugar','grape juice','00.005','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(64,'sugar','coffee','00.001','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(65,'sugar','lime juice','00.005','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(66,'sugar','grape juice','00.005','5','05 Jul 2025','202507050932','09:32:57 AM','0932','202507050932','Kg ','-5.0'),(67,'test ingredients ','roti','0.01','5000','14 Jul 2025','202507141544','03:44:46 pm','1544','202507141544','gm','-5000.0'),(68,'TEA DUST','tea','0.005','5000','15 Jul 2025','202507150655','06:55:58 AM','0655','202507150655','Kg ','-5000.0'),(69,'sugar','lime juice','0.010','5','25 Jul 2025','202507251610','04:10:09 pm','1610','202507251610','Kg','-5.0'),(70,'sugar','lassi','0','5','25 Jul 2025','202507251610','04:10:09 pm','1610','202507251610','Kg','-5.0'),(71,'sugar','grape juice','0','5','25 Jul 2025','202507251610','04:10:09 pm','1610','202507251610','Kg','-5.0'),(74,'lemon','Lemon Tea','.01','0','11 Sep 2025','202509111444','02:44:01 pm','1444','202509111444','Kg','10.0'),(75,'lemon','Lemon Cheesecake','0.1','0','11 Sep 2025','202509111444','02:44:01 pm','1444','202509111444','Kg','10.0'),(76,'wheat bread','Cheese Grilled Sandwich','0.5','0','11 Sep 2025','202509111451','02:51:06 pm','1451','202509111451','pound','10.0'),(77,'wheat bread','Veg Grilled Sandwich','0.5','0','11 Sep 2025','202509111451','02:51:06 pm','1451','202509111451','pound','10.0'),(78,'wheat bread','Paneer Panini Sandwich','0.5','0','11 Sep 2025','202509111451','02:51:06 pm','1451','202509111451','pound','10.0'),(79,'wheat bread','Paneer Tikka Sandwich','0.5','0','11 Sep 2025','202509111451','02:51:06 pm','1451','202509111451','pound','10.0'),(80,'wheat bread','Cheese Grilled Sandwich','2','0','11 Sep 2025','202509111452','02:52:05 pm','1452','202509111452','no.','10.0'),(81,'wheat bread','Veg Grilled Sandwich','2','0','11 Sep 2025','202509111452','02:52:05 pm','1452','202509111452','no.','10.0'),(82,'wheat bread','Paneer Panini Sandwich','2','0','11 Sep 2025','202509111452','02:52:05 pm','1452','202509111452','no.','10.0'),(83,'wheat bread','Paneer Tikka Sandwich','2','0','11 Sep 2025','202509111452','02:52:05 pm','1452','202509111452','no.','10.0'),(86,'Milk','Tea ','0','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(87,'Milk','parcel Tea','0','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(88,'Milk','tea','0.5','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(89,'Milk','Tea ','0','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(90,'Milk','parcel Tea','0','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(91,'Milk','tea','0.010','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(92,'Milk','coffee','0.010','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(93,'Milk','Tea','0.2','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(94,'Milk','coffee ','0.3','9.50','06 Oct 2025','202510060646','06:46:12 AM','0646','202510060646','L ','0.5'),(95,'SKIMMED MILK','Cold Coffee Milkshake','20','0','06 Oct 2025','202510061125','11:25:56 AM','1125','202510061125','ml ','10.0'),(96,'SKIMMED MILK','Coffee Normal','20','0','06 Oct 2025','202510061125','11:25:56 AM','1125','202510061125','ml ','10.0'),(97,'SKIMMED MILK','Mini Coffee','10','0','06 Oct 2025','202510061125','11:25:56 AM','1125','202510061125','ml ','10.0'),(98,'SKIMMED MILK','Coffee Parcel','20','0','06 Oct 2025','202510061125','11:25:56 AM','1125','202510061125','ml ','10.0'),(99,'SKIMMED MILK','Filter Coffee','20','0','06 Oct 2025','202510061125','11:25:56 AM','1125','202510061125','ml ','10.0'),(100,'TONNED MILK','Tea Normal','0.02','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(101,'TONNED MILK','Mini Tea','0.02','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(102,'TONNED MILK','Tea Parcel','0.02','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(103,'TONNED MILK','Ginger Tea','0.02','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(104,'TONNED MILK','Sukku Tea','0.02','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(105,'TONNED MILK','Masala Tea','0.025','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(106,'TONNED MILK','Elachi Tea','0.025','0','06 Oct 2025','202510061136','11:36:00 AM','1136','202510061136','L ','20.0'),(107,'Paneer','Paneer Masala','0.2','0','19 Nov 2025','202511191446','02:46:35 pm','1446','202511191446','Kg','5.0'),(108,'onion','Chole Bhatore','0.05','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(109,'onion','Veg Meals','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(110,'onion','Fish Curry Meals','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(111,'onion','chicken meals','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(112,'onion','Egg Curry Meals','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(113,'onion','Veg Pulaw','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(114,'onion','Veg Fried Rice','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(115,'onion','Egg Fried Rice','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(116,'onion','Chicken Fried Rice','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(117,'onion','Chicken Curry','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(118,'onion','Chicken Masala','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(119,'onion','Ginger Chicken','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(120,'onion','Garlic Chicken','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(121,'onion','Papper Chicken','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(122,'onion','Mix Veg','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(123,'onion','Daal Makhni','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(124,'onion','Paneer Masala','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(125,'onion','Egg Biryani','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(126,'onion','Motton Biryani','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(127,'onion','Veg Biryani','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(128,'onion','Roti Sabji','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(129,'onion','Puri Sabji','0','0','19 Nov 2025','202511191449','02:49:29 pm','1449','202511191449','Kg','10.0'),(130,'sugar','Mojito','0.01','0','22 Nov 2025','202511221341','01:41:17 pm','1341','202511221341','Kg','10.0'),(131,'Rice','Egg Fried Rice','0.5','11.0','25 Nov 2025','202511251606','04:06:10 pm','1606','202511251607','Kg','9.0'),(132,'Rice','Chicken Fried Rice','0.2','11.0','25 Nov 2025','202511251606','04:06:10 pm','1606','202511251607','Kg','9.0'),(133,'Rice','Veg Fried Rice','0.1','11.0','25 Nov 2025','202511251606','04:06:10 pm','1606','202511251607','Kg','9.0'),(134,'Rice','Jeera Rice','0.1','11.0','25 Nov 2025','202511251606','04:06:10 pm','1606','202511251607','Kg','9.0'),(135,'Paneer','Paneer Tikka ','0.1','1','06 Jan 2026','202601061238','12:38:33 pm','1238','202601061238','Kg','-1.0'),(136,'Paneer ','Paneer Tikka ','0.1','0.80','06 Jan 2026','202601061243','12:43:01 pm','1243','202601061243','Kg','-0.9');
INSERT INTO `ingredient_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Abc','+449182173','','27000.0','0','0','0','0','27000.0','10:13 am','21 Mar 2023','21 Mar 2023','202303211013','20230321','0','27000.0','0','21 Mar 2023','10:13 am','202303211013',''),(2,'Abc','+449182173','','1000.0','0','0','0','0','1000.0','04:55 pm','01 Apr 2023','01 Apr 2023','202304011655','20230401','700','300.0','700','01 Apr 2023','04:55 pm','202304011655',''),(3,'Abc','+449182173','','2550.0','0','0','0','0','2550.0','03:38 pm','03 Apr 2023','03 Apr 2023','202304031538','20230403','0','2550.0','0','03 Apr 2023','03:38 pm','202304031538',''),(4,'Abc','+449182173','','200.0','0','0','0','0','200.0','02:56 pm','05 Apr 2023','05 Apr 2023','202304051456','20230405','200','0.0','200','05 Apr 2023','02:56 pm','202304051456',''),(5,'Abc','+449182173','','2000.0','0','0','0','0','2000.0','03:06 pm','05 Apr 2023','05 Apr 2023','202304051506','20230405','0','2000.0','0','05 Apr 2023','03:06 pm','202304051506',''),(6,'Abc','+449182173','','2000.0','0','0','0','0','2000.0','03:06 pm','05 Apr 2023','05 Apr 2023','202304051506','20230405','1000','1000.0','1000.0','05 Apr 2023','03:07 pm','202304051507',''),(7,'Xyz','1234567890','','100.0','0','0','0','0','100.0','03:31 pm','05 Apr 2023','05 Apr 2023','202304051531','20230405','2000','-1900.0','2000','05 Apr 2023','03:31 pm','202304051531',''),(8,'Xyz','1234567890','','100.0','0','0','0','0','100.0','03:55 pm','05 Apr 2023','05 Apr 2023','202304051555','20230405','100','0.0','100','05 Apr 2023','03:55 pm','202304051555',''),(9,'Xyz','1234567890','','500.0','0','0','0','0','500.0','04:00 pm','05 Apr 2023','05 Apr 2023','202304051600','20230405','500','0.0','500','05 Apr 2023','04:00 pm','202304051600',''),(10,'Xyz','1234567890','','300.0','0','0','0','0','300.0','04:03 pm','05 Apr 2023','05 Apr 2023','202304051603','20230405','300','0.0','300','05 Apr 2023','04:03 pm','202304051603',''),(11,'Xyz','1234567890','','852.0','0','0','0','0','852.0','02:20 pm','01 Apr 2024','01 Apr 2024','202404011420','20240401','20','832.0','20','01 Apr 2024','02:20 pm','202404011420',''),(12,'Abc','+449182173','','40.0','0','0','0','0','40.0','02:21 pm','01 Apr 2024','01 Apr 2024','202404011421','20240401','40','0.0','40','01 Apr 2024','02:21 pm','202404011421',''),(13,'Xyz','1234567890','','150.0','0','0','0','0','150.0','02:29 pm','01 Apr 2024','01 Apr 2024','202404011429','20240401','100','50.0','100','01 Apr 2024','02:29 pm','202404011429',''),(14,'Xyz','1234567890','','400.0','0','0','0','0','400.0','05:17 pm','27 Mar 2025','27 Mar 2025','202503271717','20250327','400','0.0','400','27 Mar 2025','05:17 pm','202503271717',''),(15,'Xyz','1234567890','','420.0','0','0','0','0','420.0','05:18 pm','27 Mar 2025','27 Mar 2025','202503271718','20250327','420','0.0','420','27 Mar 2025','05:18 pm','202503271718',''),(16,'Xyz','1234567890','','3000.0','0','0','0','0','3000.0','05:20 pm','27 Mar 2025','27 Mar 2025','202503271720','20250327','0','3000.0','0','27 Mar 2025','05:20 pm','202503271720',''),(17,'Xyz','1234567890','1234','3000','0','0','0','0','3000','07:20 AM','29 Mar 2025','29 Mar 2025','202503290720','20250329','0','3000.0','0','29 Mar 2025','07:20 AM','202503290720',NULL),(18,'Xyz','1234567890','11111','625','0','0','0','0','625','07:23 AM','29 Mar 2025','29 Mar 2025','202503290723','20250329','600','25.0','600','29 Mar 2025','07:23 AM','202503290723',NULL),(19,'Xyz','1234567890','22222','750','0','0','0','0','750','07:24 AM','29 Mar 2025','29 Mar 2025','202503290724','20250329','700','50.0','700','29 Mar 2025','07:24 AM','202503290724',NULL),(20,'Nandus chicken ','9535897598','','1500.0','0','0','0','0','1500.0','06:26 pm','14 May 2025','14 May 2025','202505141826','20250514','1000','500.0','1000','14 May 2025','06:26 pm','202505141826',''),(21,'Nandus chicken ','9535897598','','1500.0','0','0','0','0','1500.0','06:26 pm','14 May 2025','14 May 2025','202505141826','20250514','500','0.0','1500.0','14 May 2025','06:28 pm','202505141828',''),(22,'Sai traders','1234567809','','400.0','0','0','0','0','400.0','10:56 am','15 May 2025','15 May 2025','202505151056','20250515','2000','-1600.0','2000','15 May 2025','10:56 am','202505151056',''),(23,'Rice trader','9164000275','','600.0','0','0','0','0','600.0','12:10 pm','15 May 2025','15 May 2025','202505151210','20250515','600','0.0','600','15 May 2025','12:10 pm','202505151210',''),(24,'Xyz','1234567890','','750.0','0','0','0','0','750.0','12:16 pm','15 May 2025','15 May 2025','202505151216','20250515','750','0.0','750','15 May 2025','12:16 pm','202505151216',''),(25,'Sai traders','1234567809','','250.0','0','0','0','0','250.0','04:17 pm','25 Jul 2025','25 Jul 2025','202507251617','20250725','250','0.0','250','25 Jul 2025','04:17 pm','202507251617',''),(26,'Xyz','1234567890','','400.0','0','0','0','0','400.0','04:18 pm','25 Jul 2025','25 Jul 2025','202507251618','20250725','400','0.0','400','25 Jul 2025','04:18 pm','202507251618',''),(27,'Xyz','1234567890','','300.0','0','0','0','0','300.0','01:10 pm','04 Oct 2025','04 Oct 2025','202510041310','20251004','300','0.0','300','04 Oct 2025','01:10 pm','202510041310',''),(28,'Xyz','1234567890','','300.0','0','0','0','0','300.0','09:36 am','06 Oct 2025','06 Oct 2025','202510060936','20251006','300','0.0','300','06 Oct 2025','09:36 am','202510060936',''),(29,'Xyz','1234567890','06102025','275','0','0','0','0','275','11:32 AM','06 Oct 2025','06 Oct 2025','202510061132','20251006','200','75.0','200','06 Oct 2025','11:32 AM','202510061132',NULL),(30,'Sai traders','1234567809','','1720.0','0','0','0','0','1720.0','02:51 pm','19 Nov 2025','19 Nov 2025','202511191451','20251119','1700','20.0','1700','19 Nov 2025','02:51 pm','202511191451',''),(31,'Sai traders','1234567809','','1720.0','0','0','0','0','1720.0','02:51 pm','19 Nov 2025','19 Nov 2025','202511191451','20251119','20','0.0','1720.0','19 Nov 2025','02:52 pm','202511191452','');
INSERT INTO `ingredient_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `wastage`, `unit`) VALUES (1,'Abc','+449182173','Rice ','450','60','27000.0','','27000.0','0','0','0','0','27000.0','10:13 am','21 Mar 2023','21 Mar 2023','202303211013','20230321','','27000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'-15.0','Kg'),(2,'Abc','+449182173','Tea Dust','10','100','1000.0','','1000.0','0','0','0','0','1000.0','04:55 pm','01 Apr 2023','01 Apr 2023','202304011655','20230401','700','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(3,'Abc','+449182173','Tea Dust','15','100','1500.0','','2550.0','0','0','0','0','2550.0','03:38 pm','03 Apr 2023','03 Apr 2023','202304031538','20230403','','2550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(4,'Abc','+449182173','sugar','25','42','1050.0','','2550.0','0','0','0','0','2550.0','03:38 pm','03 Apr 2023','03 Apr 2023','202304031538','20230403','','2550.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(5,'Abc','+449182173','Milk','5','40','200.0','','200.0','0','0','0','0','200.0','02:56 pm','05 Apr 2023','05 Apr 2023','202304051456','20230405','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(6,'Abc','+449182173','Tea Dust','20','100','2000.0','','2000.0','0','0','0','0','2000.0','03:06 pm','05 Apr 2023','05 Apr 2023','202304051506','20230405','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(7,'Xyz','1234567890','Tea Dust','1','100','100.0','','100.0','0','0','0','0','100.0','03:31 pm','05 Apr 2023','05 Apr 2023','202304051531','20230405','2000','-1900.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(8,'Xyz','1234567890','Tea Dust','1','100','100.0','','100.0','0','0','0','0','100.0','03:55 pm','05 Apr 2023','05 Apr 2023','202304051555','20230405','100','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(9,'Xyz','1234567890','Tea Dust','5','100','500.0','','500.0','0','0','0','0','500.0','04:00 pm','05 Apr 2023','05 Apr 2023','202304051600','20230405','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(10,'Xyz','1234567890','Tea Dust','3','100','300.0','','300.0','0','0','0','0','300.0','04:03 pm','05 Apr 2023','05 Apr 2023','202304051603','20230405','300','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.0','Kg'),(11,'Xyz','1234567890','sugar','1','42','42.0','','852.0','0','0','0','0','852.0','02:20 pm','01 Apr 2024','01 Apr 2024','202404011420','20240401','20','832.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(12,'Xyz','1234567890','Rice ','20','40','800.0','','852.0','0','0','0','0','852.0','02:20 pm','01 Apr 2024','01 Apr 2024','202404011420','20240401','20','832.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(13,'Xyz','1234567890','lemon ','5','2','10.0','','852.0','0','0','0','0','852.0','02:20 pm','01 Apr 2024','01 Apr 2024','202404011420','20240401','20','832.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','no.'),(14,'Abc','+449182173','lemon ','20','2','40.0','','40.0','0','0','0','0','40.0','02:21 pm','01 Apr 2024','01 Apr 2024','202404011421','20240401','40','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.0','no.'),(15,'Xyz','1234567890','orange ','5','30','150.0','','150.0','0','0','0','0','150.0','02:29 pm','01 Apr 2024','01 Apr 2024','202404011429','20240401','100','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(16,'Xyz','1234567890','Rice','10','40','400.0','','400.0','0','0','0','0','400.0','05:17 pm','27 Mar 2025','27 Mar 2025','202503271717','20250327','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(17,'Xyz','1234567890','sugar','10','42','420.0','','420.0','0','0','0','0','420.0','05:18 pm','27 Mar 2025','27 Mar 2025','202503271718','20250327','420','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(18,'Xyz','1234567890','orange ','100','30','3000.0','','3000.0','0','0','0','0','3000.0','05:20 pm','27 Mar 2025','27 Mar 2025','202503271720','20250327','','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(19,'Xyz','1234567890','Rice ','50','60','3000','1234','3000','0','0','0','0','3000','07:20 AM','29 Mar 2025','29 Mar 2025','202503290720','20250329','0','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(20,'Xyz','1234567890','onion','25','25','625','11111','625','0','0','0','0','625','07:23 AM','29 Mar 2025','29 Mar 2025','202503290723','20250329','600','25.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(21,'Xyz','1234567890','Tea Dust','15','50','750','22222','750','0','0','0','0','750','07:24 AM','29 Mar 2025','29 Mar 2025','202503290724','20250329','700','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Kg'),(22,'Nandus chicken ','9535897598','Boneless chicken ','10','150','1500.0','','1500.0','0','0','0','0','1500.0','06:26 pm','14 May 2025','14 May 2025','202505141826','20250514','1000','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(23,'Sai traders','1234567809','sugar','10','40','400.0','','400.0','0','0','0','0','400.0','10:56 am','15 May 2025','15 May 2025','202505151056','20250515','2000','-1600.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(24,'Rice trader','9164000275','Basmati Rice','5','120','600.0','','600.0','0','0','0','0','600.0','12:10 pm','15 May 2025','15 May 2025','202505151210','20250515','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(25,'Xyz','1234567890','Oil','5','150','750.0','','750.0','0','0','0','0','750.0','12:16 pm','15 May 2025','15 May 2025','202505151216','20250515','750','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(26,'Sai traders','1234567809','Milk','5','50','250.0','','250.0','0','0','0','0','250.0','04:17 pm','25 Jul 2025','25 Jul 2025','202507251617','20250725','250','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(27,'Xyz','1234567890','sugar','10','40','400.0','','400.0','0','0','0','0','400.0','04:18 pm','25 Jul 2025','25 Jul 2025','202507251618','20250725','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(28,'Xyz','1234567890','Milk','5','60','300.0','','300.0','0','0','0','0','300.0','01:10 pm','04 Oct 2025','04 Oct 2025','202510041310','20251004','300','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(29,'Xyz','1234567890','Milk','5','60','300.0','','300.0','0','0','0','0','300.0','09:36 am','06 Oct 2025','06 Oct 2025','202510060936','20251006','300','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(30,'Xyz','1234567890','SKIMMED MILK','5','55','275','06102025','275','0','0','0','0','275','11:32 AM','06 Oct 2025','06 Oct 2025','202510061132','20251006','200','75.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ml'),(31,'Sai traders','1234567809','TONNED MILK','2','60','120.0','','1720.0','0','0','0','0','1720.0','02:51 pm','19 Nov 2025','19 Nov 2025','202511191451','20251119','1700','20.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','L'),(32,'Sai traders','1234567809','Paneer','5','320','1600.0','','1720.0','0','0','0','0','1720.0','02:51 pm','19 Nov 2025','19 Nov 2025','202511191451','20251119','1700','20.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg');
INSERT INTO `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (22,'Milk','1','10','9.50','L','50',NULL,'202507251615','25 Jul 2025','1615','04:15:41 pm','202510060939','50','0.5','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(26,'SKIMMED MILK','2','10','36','ml','55',NULL,'202510061125','06 Oct 2025','1125','11:25:56 AM','202510061659','55','100.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'55',NULL),(27,'TONNED MILK','2','20','0','L','60',NULL,'202510061136','06 Oct 2025','1136','11:36:00 AM','202510061136','60','20.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'60',NULL),(28,'Paneer','1','5','0','Kg','320',NULL,'202511191436','19 Nov 2025','1436','02:36:40 pm','202511191436','320','5.0','',NULL,NULL,NULL,NULL,NULL,NULL,'320',NULL),(29,'onion','1','10','0','Kg','35',NULL,'202511191449','19 Nov 2025','1449','02:49:34 pm','202511191449','35','10.0','',NULL,NULL,NULL,NULL,NULL,NULL,'35',NULL),(30,'sugar','2','10','-0.05','gm','40',NULL,'202511221341','22 Nov 2025','1341','01:41:20 pm','202511221342','40','10.05','',NULL,NULL,NULL,NULL,NULL,NULL,'40',NULL),(31,'Rice','1','10','11.0','Kg','80',NULL,'202511251607','25 Nov 2025','1607','04:07:12 pm','202511251607','80','9.0','',NULL,NULL,NULL,NULL,NULL,NULL,'80',NULL),(32,'Paneer ','0','0','0.90','Kg','500',NULL,'202601061243','06 Jan 2026','1243','12:43:04 pm','202601061243','500','-0.9','',NULL,NULL,NULL,NULL,NULL,NULL,'500',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'lime juice','0','no.','yes'),(2,'Mandi biryani half ','0.1','Kg','yes'),(3,'poori','0','Kg','yes'),(4,'masal dosa','0','Kg','yes'),(5,'onion dosa','0','Kg','yes'),(6,'chicken kabab','0','Kg','yes'),(7,'sheekh kabab','0','Kg','yes'),(8,'samosa','0','Kg','yes'),(9,'onion dosa','0','Kg','yes'),(10,'rava dosa','0','Kg','yes'),(11,'uthappam','0','Kg','yes'),(12,'Ginger Chicken','0','Kg',NULL),(13,'Garlic Chicken','0','Kg',NULL),(14,'Papper Chicken','0','Kg',NULL),(15,'Mix Veg','0','Kg',NULL),(16,'Daal Makhni','0','Kg',NULL),(17,'Paneer Masala','0','Kg',NULL),(18,'Egg Biryani','0','Kg','yes'),(19,'Motton Biryani','0','Kg','yes'),(20,'Veg Biryani','0','Kg','yes'),(21,'Roti Sabji','0','Kg','yes'),(22,'Puri Sabji','0','Kg','yes');
INSERT INTO `ingredients_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `unit`, `wastage_qty`, `wastage_cost`, `not_required`) VALUES (1,'Tea Dust','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(2,'Tea Dust','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(3,'Tea Dust','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(4,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(5,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(6,'Tea Dust','100.0','100.0','100.0','25.0','2500.0','','Kg','0.0','0',''),(7,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(8,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(9,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(10,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(11,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(12,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(13,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(14,'Tea Dust','100.0','100.0','100.0','25.0','2500.0','','Kg','0.0','0',''),(15,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(16,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(17,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(20,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(21,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(22,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(23,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(24,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(25,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(26,'Tea Dust','100.0','100.0','100.0','25.0','2500.0','','Kg','0.0','0',''),(27,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(28,'Tea Dust','100.0','100.0','100.0','15.0','1500.0','','Kg','0.0','0',''),(29,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(30,'Milk','40.0','40.0','40.0','5.0','200.0','','L','0.0','0',''),(31,'Tea Dust','100.0','100.0','100.0','20.0','2000.0','','Kg','0.0','0',''),(32,'Milk','40.0','40.0','40.0','5.0','200.0','','L','0.0','0',''),(37,'Tea Dust','100.0','100.0','100.0','21.0','2100.0','','Kg','0.0','0',''),(38,'Milk','40.0','40.0','40.0','5.0','200.0','','L','0.0','0',''),(43,'Sugar ','42.0','42.0','42.0','25.0','1050.0','','Kg','0.0','0',''),(44,'Milk','40.0','40.0','40.0','5.0','200.0','','L','0.0','0',''),(45,'Tea Dust','100.0','100.0','100.0','55.0','5500.0','','Kg','0.0','0',''),(46,'Rice','60.0','60.0','60.0','450.0','27000.0','','Kg','-15.0','-900.0',''),(47,'Sugar ','42.0','42.0','42.0','1.0','42.0','','Kg','0.0','0',''),(48,'Rice','40.0','40.0','40.0','20.0','800.0','','Kg','-15.0','-900.0',''),(49,'lemon ','2.0','2.0','2.0','25.0','50.0','','no.','0.0','0',''),(50,'Sugar ','42.0','42.0','42.0','10.0','420.0','','Kg','0.0','0',''),(51,'Rice','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(55,'Sugar ','42.0','42.0','42.0','10.0','420.0','','Kg','0.0','0',''),(56,'Rice','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(57,'orange ','30.0','30.0','30.0','100.0','3000.0','','Kg','0.0','0',''),(58,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(59,'Sugar ','42.0','42.0','42.0','36.0','1512.0','','Kg','0.0','0',''),(60,'Milk','40.0','40.0','40.0','5.0','200.0','0','L','0.0','0',''),(61,'Tea Dust','89.3','100.0','50.0','70.0','6250.0','','Kg','0.0','0',''),(62,'Rice','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(63,'onion','25.0','25.0','25.0','25.0','625.0','0','Kg','0.0','0',''),(64,'lemon ','2.0','2.0','2.0','25.0','50.0','','no.','0.0','0',''),(65,'orange ','30.0','30.0','30.0','105.0','3150.0','','Kg','0.0','0',''),(66,'Rice ','59.2','40.0','60.0','520.0','30800.0','','Kg','-15.0','-900.0',''),(67,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(68,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(69,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(70,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(71,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(72,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(76,'lemon ','2.0','2.0','2.0','25.0','50.0','','no.','0.0','0',''),(77,'orange ','30.0','30.0','30.0','105.0','3150.0','','Kg','0.0','0',''),(78,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(79,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(80,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(81,'Sugar ','42.0','42.0','42.0','10.0','420.0','','Kg','0.0','0',''),(82,'Tea Dust','50.0','50.0','50.0','15.0','750.0','','Kg','0.0','0',''),(83,'Rice','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(84,'onion','25.0','25.0','25.0','25.0','625.0','0','Kg','0.0','0',''),(85,'orange ','30.0','30.0','30.0','100.0','3000.0','','Kg','0.0','0',''),(86,'Rice ','60.0','60.0','60.0','50.0','3000.0','','Kg','-15.0','-900.0',''),(87,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(88,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(89,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(90,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(91,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(92,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(93,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(94,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(95,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(96,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(97,'Sugar ','42.0','42.0','42.0','10.0','420.0','','Kg','0.0','0',''),(98,'Tea Dust','50.0','50.0','50.0','15.0','750.0','','Kg','0.0','0',''),(99,'Rice','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(100,'onion','25.0','25.0','25.0','25.0','625.0','0','Kg','0.0','0',''),(101,'orange ','30.0','30.0','30.0','100.0','3000.0','','Kg','0.0','0',''),(102,'Rice ','60.0','60.0','60.0','50.0','3000.0','','Kg','-15.0','-900.0',''),(103,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(104,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(105,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(106,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(107,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(108,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(109,'Boneless chicken ','150.0','150.0','150.0','10.0','1500.0','','Kg','0.0','0',''),(110,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(111,'Basmati Rice','120.0','120.0','120.0','5.0','600.0','','Kg','0.0','0',''),(112,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(115,'onion','25.0','25.0','25.0','25.0','625.0','0','Kg','0.0','0',''),(116,'lemon ','2.0','2.0','2.0','25.0','50.0','','no.','0.0','0',''),(117,'orange ','30.0','30.0','30.0','105.0','3150.0','','Kg','0.0','0',''),(118,'Oil','150.0','150.0','150.0','5.0','750.0','','L','0.0','0',''),(119,'Sugar','40.0','40.0','40.0','20.0','800.0','','Kg','0.0','0',''),(120,'Milk','45.0','40.0','50.0','10.0','450.0','','L','0.0','0',''),(121,'Sugar','40.0','40.0','40.0','10.0','400.0','','Kg','0.0','0',''),(122,'Milk','50.0','50.0','50.0','5.0','250.0','','L','0.0','0',''),(123,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(125,'Milk','60.0','60.0','60.0','10.0','600.0','','L','0.0','0',''),(126,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(127,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(129,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(130,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(131,'Milk','60.0','60.0','60.0','5.0','300.0','','L','0.0','0',''),(132,'Milk','56.7','50.0','60.0','15.0','850.0','','L','0.0','0',''),(133,'SKIMMED MILK','55.0','55.0','55.0','5.0','275.0','0','ml','0.0','0',''),(134,'TONNED MILK','60.0','60.0','60.0','2.0','120.0','0','L','0.0','0',''),(135,'Paneer','320.0','320.0','320.0','5.0','1600.0','','Kg','0.0','0',''),(136,'TONNED MILK','60.0','60.0','60.0','2.0','120.0','0','L','0.0','0',''),(137,'Paneer','320.0','320.0','320.0','5.0','1600.0','','Kg','0.0','0',''),(138,'TONNED MILK','60.0','60.0','60.0','2.0','120.0','0','L','0.0','0',''),(139,'Paneer','320.0','320.0','320.0','5.0','1600.0','','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`, `is_veg`, `packing_charges`) VALUES (1,'Coke',20.00,0,'COOL DRINKS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(2,'Sprite',20.00,0,'COOL DRINKS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(3,'Fanta',20.00,0,'COOL DRINKS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Fa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(4,'Water 500ml',10.00,0,'COOL DRINKS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Wa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(5,'Water 1Litre',20.00,0,'COOL DRINKS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Wa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(6,'Chicken Grilled Sandwich',90.00,0,'CHICKEN SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(7,'BBQ Chicken Sandwich',90.00,0,'CHICKEN SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BB','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(8,'Tandoori Chicken Sandwich',90.00,0,'CHICKEN SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ta','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(9,'Arabian Chicken Sandwich',90.00,0,'CHICKEN SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ar','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(10,'Veg Grilled Sandwich',80.00,0,'VEG SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(11,'Veg Cheese Grilled Sandwich',90.00,0,'VEG SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(12,'Corn Sandwich',80.00,0,'VEG SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(13,'Corn  Peas Sandwich',80.00,0,'VEG SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(14,'Paneer Grilled Sandwich',90.00,0,'VEG SANDWICH','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(15,'Chicken Pizza',180.00,0,'NONVEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(16,'BBQ Chicken Pizza',180.00,0,'NONVEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BB','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(17,'Tandoori Chicken Pizza',180.00,0,'NONVEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ta','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(18,'Arabian Chicken Pizza',180.00,0,'NONVEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ar','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(19,'Chicken Cheese Pizza',200.00,0,'NONVEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(20,'Veg Pizza',160.00,0,'VEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(21,'Corn Pizza',160.00,0,'VEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(22,'Veg Cheese Pizza',180.00,0,'VEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(23,'Paneer Pizza',180.00,0,'VEG PIZZA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(24,'Chicken Zinger Wrap',120.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(25,'Chipotle Chicken Wrap',130.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(26,'Chicken Nugget Wrap',120.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(27,'Chicken BBQ Wrap',120.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(28,'Tandoori Chicken Wrap',120.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ta','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(29,'Arabian Chicken Wrap',130.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ar','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(30,'Fish Wrap',130.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Fi','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',''),(31,'veg burger',130.00,0,'NONVEG WRAPS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','');
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'idly','10.0','10.0','10.0','20.0','200.0','',''),(2,'bread omlette','25.0','25.0','25.0','5.0','125.0','',''),(3,'chicken nuggets','80.0','80.0','80.0','10.0','800.0','',''),(4,'Tea ','10.0','10.0','10.0','20.0','200.0','',''),(5,'Tea ','7.0','7.0','7.0','20.0','140.0','45',''),(6,'parcel Tea','10.0','10.0','10.0','30.0','300.0','46',''),(7,'Test product ','7.0','7.0','7.0','20.0','140.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','100');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'POS');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (5,'3 inch');
INSERT INTO `promotions` (`_id`, `email`) VALUES (1,'assasss');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stock_transfer_item_details` (`_id`, `itemname`, `qty_add`, `company`, `from_store`, `from_device`, `to_store`, `to_device`, `from_time`, `from_date`, `datetimee_new_from`) VALUES (1,'dosa','20','9535897598dine','store1','device1',NULL,NULL,'11:34 am','23 Apr 2024','20240423113451'),(2,'upma','20','9535897598dine','store1','device1',NULL,NULL,'11:34 am','23 Apr 2024','20240423113451'),(3,'dosa','20','9535897598dine','store1','device1','test12','device12','11:34 am','23 Apr 2024','20240423113451'),(4,'upma','20','9535897598dine','store1','device1','test12','device12','11:34 am','23 Apr 2024','20240423113451');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Pro');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (9,'regular','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Mini','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'regular','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Mini','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'regular','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Mini','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'regular','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Mini','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'regular','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'Mini','17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'regular','95.24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'Large','135.59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'regular','571.43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Customized Cake','593.22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'Semi Fondant','762.71',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'Full Fondant','1016.95',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'regular','571.43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'Customized Cake','593.22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'Semi Fondant','762.71',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'Full Fondant','1016.95',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'regular','571.43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Customized Cake','593.22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'Semi Fondant','762.71',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'Full Fondant','1016.95',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'regular','190.48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'Large','276.2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'regular','180.95',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'Large','257.14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'regular','152.38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'Large','209.52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'regular','171.43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'Large','247.62',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'regular','142.85',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'Large','190.48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'regular','571.43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'Customized Cake','809.52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'Semi Fondant','1000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'Full Fondant','1285.71',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'Regular','150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'large','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc','+449182173','','',''),(2,'Munna ','8000009123','','',''),(3,'vendor 1','9535897598','','',''),(4,'Test vendor ','9164000275','','',''),(5,'Test vendor ','9164000275','','',''),(6,'VINAYAK','9986688896','ivepos','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc','+449182173','','',''),(2,'Xyz','1234567890','','',''),(3,'Risi','12345','tyu@gh.jj','','45'),(4,'Nandus chicken ','9535897598','','chikpet',''),(5,'Sai traders','1234567809','','Jp nagar',''),(6,'Rice trader','9164000275','','',''),(7,'Aaaaa','+916400027','','Bangalore ','');
INSERT INTO `vendor_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (1,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','300.0','500','13 Mar 2023','12:21 pm','202303131221',''),(2,'Munna ','8000009123','','125.0','0','0','0','0','125.0','12:47 pm','13 Mar 2023','13 Mar 2023','202303131247','20230313','125','0.0','125','13 Mar 2023','12:47 pm','202303131247',''),(3,'Abc','+449182173','','200.0','0','0','0','0','200.0','02:05 pm','16 Mar 2023','16 Mar 2023','202303161405','20230316','150','50.0','150','16 Mar 2023','02:05 pm','202303161405',''),(4,'Munna ','8000009123','','300.0','0','0','0','0','300.0','07:38 pm','27 Mar 2023','27 Mar 2023','202303271938','20230327','200','100.0','200','27 Mar 2023','07:38 pm','202303271938',''),(5,'Abc','+449182173','','200.0','0','0','0','0','200.0','03:25 pm','03 Apr 2023','03 Apr 2023','202304031525','20230403','200','0.0','200','03 Apr 2023','03:25 pm','202304031525',''),(6,'Abc','+449182173','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0','200','08 Sep 2023','05:36 PM','202309081736',''),(7,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','100','200.0','600.0','04 Nov 2023','05:21 pm','202311041721',''),(8,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','200','0.0','800.0','04 Nov 2023','05:25 pm','202311041725',''),(9,'Munna ','8000009123','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0','500','08 Jan 2024','12:57 PM','202401081257',''),(10,'Munna ','8000009123','','5000.0','0','0','0','0','5000.0','03:40 PM','09 Feb 2024','09 Feb 2024','202402091540','20240209','2000','3000.0','2000','09 Feb 2024','03:40 PM','202402091540',''),(11,'Munna ','8000009123','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','-500.0','1300.0','19 Feb 2024','06:34 AM','202402190634',NULL),(12,'Abc','+449182173','','375','0','0','0','0','375','06:20 AM','27 Feb 2024','27 Feb 2024','202402270620','20240227','0','375.0','0','27 Feb 2024','06:20 AM','202402270620',NULL),(13,'Munna ','8000009123','','400','0','0','0','0','400','06:21 AM','27 Feb 2024','27 Feb 2024','202402270621','20240227','0','400.0','0','27 Feb 2024','06:21 AM','202402270621',NULL),(14,'Munna ','8000009123','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0','500','28 May 2024','04:02 pm','202405281602',''),(15,'Munna ','8000009123','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0','500','28 May 2024','04:04 pm','202405281604',''),(16,'Munna ','8000009123','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','200','180.0','700.0','28 May 2024','04:05 pm','202405281605',''),(17,'Munna ','8000009123','','3000.0','0','0','0','0','3000.0','11:20 am','10 May 2025','10 May 2025','202505101120','20250510','3000','0.0','3000','10 May 2025','11:20 am','202505101120',''),(18,'vendor 1','9535897598','','200.0','0','0','0','0','200.0','11:30 am','10 May 2025','10 May 2025','202505101130','20250510','1000','-800.0','1000','10 May 2025','11:30 am','202505101130',''),(19,'Munna ','8000009123','','100','0','0','0','0','100','06:10 AM','09 Jul 2025','09 Jul 2025','202507090610','20250709','100','0.0','100','09 Jul 2025','06:10 AM','202507090610',NULL),(20,'Abc','+449182173','','150.0','0','0','0','0','150.0','03:00 pm','11 Sep 2025','11 Sep 2025','202509111500','20250911','150','0.0','150','11 Sep 2025','03:00 pm','202509111500',''),(21,'vendor 1','9535897598','','2400.0','0','0','0','0','2400.0','03:05 pm','11 Sep 2025','11 Sep 2025','202509111505','20250911','2400','0.0','2400','11 Sep 2025','03:05 pm','202509111505',''),(22,'Vendor001','','','2000','0','0','0','0','2000','07:12 AM','21 Sep 2025','21 Sep 2025','202509210712','20250921','2000','0.0','2000','21 Sep 2025','07:12 AM','202509210712',NULL),(23,'vendor 1','9535897598','','800.0','0','0','0','0','800.0','12:54 pm','06 Jan 2026','06 Jan 2026','202601061254','20260106','500','300.0','500','06 Jan 2026','12:54 pm','202601061254',''),(24,'ABC','','','50','0','0','0','0','50','06:20 AM','23 Jan 2026','23 Jan 2026','202601230620','20260123','50','0.0','50','23 Jan 2026','06:20 AM','202601230620',NULL);
INSERT INTO `vendor_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`) VALUES (1,'Munna ','8000009123','chicken nuggets','10','80','800.0','123','800.0','0','0','0','0','800.0','12:21 pm','13 Mar 2023','13 Mar 2023','202303131221','20230313','500','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Munna ','8000009123','bread omlette','5','25','125.0','','125.0','0','0','0','0','125.0','12:47 pm','13 Mar 2023','13 Mar 2023','202303131247','20230313','125','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Abc','+449182173','idly','20','10','200.0','','200.0','0','0','0','0','200.0','02:05 pm','16 Mar 2023','16 Mar 2023','202303161405','20230316','150','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Munna ','8000009123','idly','20','15','300.0','','300.0','0','0','0','0','300.0','07:38 pm','27 Mar 2023','27 Mar 2023','202303271938','20230327','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Abc','+449182173','Tea ','20','10','200.0','','200.0','0','0','0','0','200.0','03:25 pm','03 Apr 2023','03 Apr 2023','202304031525','20230403','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Abc','+449182173','idly','10','15','150.0','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Abc','+449182173','dosa','10','15','150.0','','300.0','0','0','0','0','300.0','05:36 PM','08 Sep 2023','08 Sep 2023','202309081736','20230908','200','100.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Munna ','8000009123','idly','10','10','100.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Munna ','8000009123','pongal','20','10','200.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Munna ','8000009123','poori','20','10','200.0','123','500.0','0','0','0','0','500.0','12:57 PM','08 Jan 2024','08 Jan 2024','202401081257','20240108','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Munna ','8000009123','dosa','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:40 PM','09 Feb 2024','09 Feb 2024','202402091540','20240209','2000','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Abc','+449182173','dosa','25','15','375','','375','0','0','0','0','375','06:20 AM','27 Feb 2024','27 Feb 2024','202402270620','20240227','0','375.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'Munna ','8000009123','pongal','20','20','400','','400','0','0','0','0','400','06:21 AM','27 Feb 2024','27 Feb 2024','202402270621','20240227','0','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Munna ','8000009123','pongal','0','100','0.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Munna ','8000009123','tea','25','12','300.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Munna ','8000009123','Tea ','20','7','140.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Munna ','8000009123','parcel Tea','30','10','300.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'Munna ','8000009123','Test product ','20','7','140.0','1234','880.0','0','0','0','0','880.0','04:02 pm','28 May 2024','28 May 2024','202405281602','20240528','500','380.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Munna ','8000009123','idly','20','10','200.0','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Munna ','8000009123','dosa','30','15','450.0','','650.0','0','0','0','0','650.0','04:04 pm','28 May 2024','28 May 2024','202405281604','20240528','500','150.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Munna ','8000009123','pongal','30','100','3000.0','','3000.0','0','0','0','0','3000.0','11:20 am','10 May 2025','10 May 2025','202505101120','20250510','3000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'vendor 1','9535897598','upma','20','10','200.0','','200.0','0','0','0','0','200.0','11:30 am','10 May 2025','10 May 2025','202505101130','20250510','1000','-800.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'Munna ','8000009123','poori','10','10','100','','100','0','0','0','0','100','06:10 AM','09 Jul 2025','09 Jul 2025','202507090610','20250709','100','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Abc','+449182173','Coffee - Instant','10','15','150.0','','150.0','0','0','0','0','150.0','03:00 pm','11 Sep 2025','11 Sep 2025','202509111500','20250911','150','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'vendor 1','9535897598','Cheese Grilled Sandwich','20','30','600.0','','2400.0','0','0','0','0','2400.0','03:05 pm','11 Sep 2025','11 Sep 2025','202509111505','20250911','2400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'vendor 1','9535897598','Veg Grilled Sandwich','20','30','600.0','','2400.0','0','0','0','0','2400.0','03:05 pm','11 Sep 2025','11 Sep 2025','202509111505','20250911','2400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'vendor 1','9535897598','Paneer Panini Sandwich','20','30','600.0','','2400.0','0','0','0','0','2400.0','03:05 pm','11 Sep 2025','11 Sep 2025','202509111505','20250911','2400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'vendor 1','9535897598','Paneer Tikka Sandwich','20','30','600.0','','2400.0','0','0','0','0','2400.0','03:05 pm','11 Sep 2025','11 Sep 2025','202509111505','20250911','2400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'Vendor001','','Coffee - Instant','100','10','1000','','2000','0','0','0','0','2000','07:12 AM','21 Sep 2025','21 Sep 2025','202509210712','20250921','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Vendor001','','Ginger Tea','100','10','1000','','2000','0','0','0','0','2000','07:12 AM','21 Sep 2025','21 Sep 2025','202509210712','20250921','2000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'vendor 1','9535897598','Water 500ml','100','8','800.0','','800.0','0','0','0','0','800.0','12:54 pm','06 Jan 2026','06 Jan 2026','202601061254','20260106','500','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'ABC','','Coke','10','5','50','','50','0','0','0','0','50','06:20 AM','23 Jan 2026','23 Jan 2026','202601230620','20260123','50','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(2,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(3,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(4,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(5,'Munna ','8000009123','','','','925.0','625.0','300.0','2'),(6,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(7,'Munna ','8000009123','','','','925.0','625.0','300.0','2'),(8,'Abc','+449182173','','','','200.0','150.0','50.0','1'),(9,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(10,'Abc','+449182173','','','','200.0','150.0','50.0','1'),(11,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(12,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(13,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(14,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(15,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(16,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(17,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(18,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(19,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(20,'Abc','+449182173','','','','400.0','350.0','50.0','2'),(21,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(22,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(23,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(24,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(25,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(26,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(27,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(28,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(29,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(30,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(31,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(32,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(33,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(34,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(35,'Munna ','8000009123','','','','1225.0','825.0','400.0','3'),(36,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(37,'Munna ','8000009123','','','','1225.0','925.0','300.0','3'),(38,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(39,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(40,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(41,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(42,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(43,'Munna ','8000009123','','','','1225.0','1125.0','100.0','3'),(44,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(45,'Munna ','8000009123','','','','1725.0','1625.0','100.0','4'),(46,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(47,'Munna ','8000009123','','','','6725.0','3625.0','3100.0','5'),(48,'Abc','+449182173','','','','700.0','550.0','150.0','3'),(49,'Munna ','8000009123','','','','6725.0','3625.0','3100.0','5'),(50,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(51,'Munna ','8000009123','','','','7125.0','4125.0','3000.0','6'),(52,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(53,'Munna ','8000009123','','','','8655.0','5125.0','3530.0','8'),(54,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(55,'Munna ','8000009123','','','','11755.0','8425.0','3330.0','10'),(56,'vendor 1','9535897598','','','','200.0','1000.0','-800.0','1'),(57,'Abc','+449182173','','','','1075.0','550.0','525.0','4'),(58,'Munna ','8000009123','','','','11755.0','8425.0','3330.0','10'),(59,'vendor 1','9535897598','','','','200.0','1000.0','-800.0','1'),(60,'Abc','+449182173','','','','1225.0','700.0','525.0','5'),(61,'Munna ','8000009123','','','','11755.0','8425.0','3330.0','10'),(62,'vendor 1','9535897598','','','','2600.0','3400.0','-800.0','2'),(63,'Test vendor ','9164000275','','','','0.0','0.0','0.0','0'),(64,'Test vendor ','9164000275','','','','0.0','0.0','0.0','0');
INSERT INTO `vendor_temp_list_ingredient` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Abc','+449182173','','','','0.0','0.0','0.0','0'),(3,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(4,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(5,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(6,'Abc','+449182173','','','','30550.0','700.0','29850.0','3'),(7,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(8,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(9,'Xyz','1234567890','','','','0.0','0.0','0.0','0'),(10,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(11,'Xyz','1234567890','','','','1000.0','2900.0','-1900.0','4'),(12,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(13,'Abc','+449182173','','','','32750.0','1900.0','30850.0','5'),(14,'Xyz','1234567890','','','','1000.0','2900.0','-1900.0','4'),(15,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(16,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(17,'Xyz','1234567890','','','','10197.0','5140.0','5057.0','12'),(18,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(19,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(20,'Xyz','1234567890','','','','10197.0','5140.0','5057.0','12'),(21,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(22,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(23,'Sai traders','1234567809','','','Jp nagar','400.0','2000.0','-1600.0','1'),(24,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(25,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(26,'Xyz','1234567890','','','','10947.0','5890.0','5057.0','13'),(27,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(28,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(29,'Sai traders','1234567809','','','Jp nagar','400.0','2000.0','-1600.0','1'),(30,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(37,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(38,'Xyz','1234567890','','','','11347.0','6290.0','5057.0','14'),(39,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(40,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(41,'Sai traders','1234567809','','','Jp nagar','650.0','2250.0','-1600.0','2'),(42,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(43,'Aaaaa','+916400027','','','Bangalore ','0.0','0.0','0.0','0'),(44,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(45,'Xyz','1234567890','','','','11347.0','6290.0','5057.0','14'),(46,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(47,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(48,'Sai traders','1234567809','','','Jp nagar','650.0','2250.0','-1600.0','2'),(49,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(50,'Aaaaa','+916400027','','','Bangalore ','0.0','0.0','0.0','0'),(51,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(52,'Xyz','1234567890','','','','11947.0','6890.0','5057.0','16'),(53,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(54,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(55,'Sai traders','1234567809','','','Jp nagar','650.0','2250.0','-1600.0','2'),(56,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(57,'Aaaaa','+916400027','','','Bangalore ','0.0','0.0','0.0','0'),(58,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(59,'Xyz','1234567890','','','','12222.0','7090.0','5132.0','17'),(60,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(61,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(62,'Sai traders','1234567809','','','Jp nagar','2370.0','3950.0','-1580.0','3'),(63,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(64,'Aaaaa','+916400027','','','Bangalore ','0.0','0.0','0.0','0'),(65,'Abc','+449182173','','','','32790.0','1940.0','30850.0','6'),(66,'Xyz','1234567890','','','','12222.0','7090.0','5132.0','17'),(67,'Risi','12345','tyu@gh.jj','45','','0.0','0.0','0.0','0'),(68,'Nandus chicken ','9535897598','','','chikpet','1500.0','1500.0','0.0','1'),(69,'Sai traders','1234567809','','','Jp nagar','2370.0','3970.0','-1600.0','3'),(70,'Rice trader','9164000275','','','','600.0','600.0','0.0','1'),(71,'Aaaaa','+916400027','','','Bangalore ','0.0','0.0','0.0','0');
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
