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,'first','0','4',NULL),(2,'1','2',NULL,'first','0','4',NULL),(3,'2','3',NULL,'first','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,'first','0','4',NULL),(15,'','15',NULL,'first','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 `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');
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,'Intuition',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',NULL,'Thank you ',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','%'),(2,'Divali','10','%'),(3,'3 percent ','3','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Abc','9535897598','reshmajs1611@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','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,'Tiffin',NULL,NULL,NULL,NULL),(4,'Snacks',NULL,NULL,NULL,NULL),(5,'Main course',NULL,NULL,NULL,NULL),(6,'Drinks',NULL,NULL,NULL,NULL),(7,'Desserts',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'),(11,'Milk','Tea ','0','5.00','03 Apr 2023','202304031544','03:44:47 pm','1544','202304031554','L','0.0'),(12,'Milk','parcel Tea','0','5.00','03 Apr 2023','202304031544','03:44:47 pm','1544','202304031554','L','0.0'),(13,'Rice ','pongal','0.2','5.30','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(14,'Rice ','idly','0','5.30','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(15,'Rice ','dosa','0','5.30','17 May 2023','202305171635','04:35:53 pm','1635','202305171637','Kg','0.0'),(16,'milk','tea','0.5','5','18 Dec 2023','202312181220','12:20:23 pm','1220','202312181220','L','95.0'),(17,'milk','Tea ','0','5','18 Dec 2023','202312181220','12:20:23 pm','1220','202312181220','L','95.0'),(18,'milk','parcel Tea','0','5','18 Dec 2023','202312181220','12:20:23 pm','1220','202312181220','L','95.0'),(19,'onion','onion dosa','0.5','3.00','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(20,'onion','uthappam','0.2','3.00','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(21,'onion','vada','0.1','3.00','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(22,'onion','masal vada','0.5','3.00','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(23,'onion','samosa','0.5','3.00','16 Feb 2024','202402161551','03:51:55 pm','1551','202402161551','Kg','7.0'),(24,'onion','chicken kabab','0.1','3.00','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','5.30','14 May 2024','2024 05 14','11:55:30 am','1155','202405141155','Kg',NULL),(28,'Rice ','idly','0.10','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(29,'Rice ','dosa','0.10','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(30,'Rice ','pongal','0.50','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(31,'Rice ','masal dosa','0.10','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(32,'Rice ','onion dosa','0','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(33,'Rice ','rava dosa','0','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0'),(34,'Rice ','uthappam','0','5.30','14 May 2024','202405141217','12:17:00 pm','1217','202405141217','Kg','15.0');
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','');
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');
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 (2,'Sugar ','1','0','25.0','Kg','42',NULL,'202304031530','03 Apr 2023','1530','03:30:01 pm','202304051618','42.0','-25.0','','','','0',NULL,'','','42',''),(3,'Milk','1','0','5.00','L','40',NULL,'202304031544','03 Apr 2023','1544','03:44:53 pm','202304031551','40.0','-5.0','','','','0',NULL,'','','40',''),(4,'Tea Dust','1','0','20.00','Kg','0',NULL,'202304051606','05 Apr 2023','1606','04:06:45 pm','202304051614','100.0','-20.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'Rice','1','1','5.30','Kg','40',NULL,'202305171636','17 May 2023','1636','04:36:00 pm','202305171637','59.1','-20.0','','','','0',NULL,'','','40',''),(6,'onion','2','10','3.00','Kg','25',NULL,'202402161551','16 Feb 2024','1551','03:51:58 pm','202402161551','NaN','7.0','','Low',NULL,NULL,NULL,NULL,NULL,'25',NULL),(7,'lemon ','5','50','25.0','no.','2',NULL,'202404011418','01 Apr 2024','1418','02:18:49 pm','202404011418','2.0','25.0','','','','0',NULL,'','','2',''),(8,'orange ','1','10','5.00','Kg','30',NULL,'202404011428','01 Apr 2024','1428','02:28:07 pm','202404011428','30.0','5.0','','','','0',NULL,'','','30',''),(9,'Rice ','5','20','5.30','Kg','60',NULL,'202405141217','14 May 2024','1217','12:17:04 pm','202405141217','60','15.0','','Low',NULL,NULL,NULL,NULL,NULL,'60',NULL);
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','');
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`) VALUES (1,'idly',25.00,13,'Tiffin','','','0','0',NULL,NULL,NULL,'no','%','0','id','1','checked','0',102,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'100','Add',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,42,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','2','checked','0',102,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,40,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','','','0',5,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'20','Add',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,45,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','4','','0',46,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,7,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','','','0',54,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,1,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','6','','0',38,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,5,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','7','','0',13,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,26,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,2,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','9','','0',25,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,24,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','','','0',5,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,88,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','11','','0',7,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,36,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','12','','0',9,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,33,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','13','','0',4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,14,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','14','','0',5,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,12,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','15','','0',8,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,28,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','16','','0',1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','17','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','18','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,29,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','19','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','20','','0',0,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,32,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','21','','0',14,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,41,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','22','','0',7,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,45,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','23','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,48,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','24','','0',1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120.00,49,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MU','25','','0',1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,97,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','26','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,47,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','27','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,48,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','28','','0',2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,47,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','29','','0',3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','30','','0',0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','','kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),