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,'','2',NULL,'first','0','4',NULL),(3,'','3',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,'RPP04-E','00:00:04:03:10:14','','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');
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 (25,'Intuition',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'www.intuitionsoftwares.com',NULL,NULL);
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'India');
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 `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,'test data ','idly','0','20.0','22 Jun 2023','202306220958','09:58:07 AM','0958','202306220958','Kg','0.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,'test vendor ','77385910','','500.0','0','0','0','0','500.0','10:14 AM','22 Jun 2023','22 Jun 2023','202306221014','20230622','20','480.0','20','22 Jun 2023','10:14 AM','202306221014',''),(2,'test vendor ','77385910','','500.0','0','0','0','0','500.0','10:14 AM','22 Jun 2023','22 Jun 2023','202306221014','20230622','10','470.0','30.0','22 Jun 2023','10:16 AM','202306221016','');
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,'test vendor ','77385910','test data ','10','50','500.0','','500.0','0','0','0','0','500.0','10:14 AM','22 Jun 2023','22 Jun 2023','202306221014','20230622','20','480.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 (1,'test data ','5','10','20.0','Kg','50',NULL,'202306220958','22 Jun 2023','0958','09:58:09 AM','202306220959','50.0','-10.0','','','Add','0',NULL,'0','0','50','');
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,'test data ','50.0','50.0','50.0','10.0','500.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`) VALUES (1,'idly',25.00,49,'Tiffin','None','[encoded data, 23788 characters]','0','0',NULL,NULL,NULL,'no','%','0','ID','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,48,'Tiffin','None','[encoded data, 19884 characters]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,50,'Tiffin','None','[encoded data, 20668 characters]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,50,'Tiffin','None','[encoded data, 9448 characters]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,46,'Tiffin','None','[encoded data, 24760 characters]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,48,'Tiffin','None','[encoded data, 18692 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,20,'Tiffin','None','[encoded data, 10588 characters]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,28,'Tiffin','None','[encoded data, 24584 characters]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,28,'Tiffin','None','[encoded data, 24764 characters]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,30,'Tiffin','None','[encoded data, 10148 characters]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,96,'Snacks','None','[encoded data, 21796 characters]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,50,'Snacks','None','[encoded data, 29096 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,49,'Snacks','None','[encoded data, 24228 characters]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,20,'Snacks','None','[encoded data, 28344 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,20,'Snacks','None','[encoded data, 10608 characters]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,30,'Snacks','None','[encoded data, 10360 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,30,'Snacks','None','[encoded data, 9748 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,30,'Snacks','None','[encoded data, 9000 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,30,'Snacks','None','[encoded data, 10156 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,10,'Snacks','None','[encoded data, 7856 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,50,'Main course','None','[encoded data, 9144 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,50,'Main course','None','[encoded data, 9168 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,50,'Main course','None','[encoded data, 28280 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,50,'Main course','None','[encoded data, 10088 characters]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120.00,50,'Main course','None','[encoded data, 9144 characters]','0','0',NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,100,'Main course','None','[encoded data, 23260 characters]','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,50,'Main course','None','[encoded data, 8168 characters]','0','0',NULL,NULL,NULL,'no','%','0','RI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,49,'Main course','None','[encoded data, 27440 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,49,'Main course','None','[encoded data, 24756 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','None','[encoded data, 9596 characters]','0','0',NULL,NULL,NULL,'no','%','0','DH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),