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,'BluetoothPrint','66: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','','','Not 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 (56,'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,'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,'pushpanjali','50','₹'),(2,'welcome10','10','%');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0'),(2,'terrace','1');
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 `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'chickens','chicken kabab','0.5','20.0','30 Jul 2025','2025 07 30','08:22:38 PM','2022','202507302022','Kg',NULL),(2,'oil','chicken kabab','0.1','15','30 Jul 2025','2025 07 30','08:22:38 PM','2022','202507302022','L',NULL),(3,'flour','chicken kabab','0.1','30','30 Jul 2025','2025 07 30','08:22:38 PM','2022','202507302022','Kg',NULL),(4,'rice','veg biriyani','7','10','16 Dec 2025','2025 12 16','12:39:33 PM','1239','202512161239','Kg',NULL),(5,'oil','veg biriyani','1','15','16 Dec 2025','2025 12 16','12:39:33 PM','1239','202512161239','L',NULL),(6,'onion','veg biriyani','3','20','16 Dec 2025','2025 12 16','12:39:33 PM','1239','202512161239','Kg',NULL),(7,'tomato','veg biriyani','5','20','16 Dec 2025','2025 12 16','12:39:33 PM','1239','202512161239','Kg',NULL),(8,'oils','masal dosa','1','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(9,'oils','poori','1','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(10,'oils','upma','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(11,'oils','pongal','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(12,'oils','dosa','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(13,'oils','onion dosa','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(14,'oils','rava dosa','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','Kg','0.0'),(15,'oils','vada','0','0','16 Dec 2025','202512161451','02:51:56 PM','1451','202512161451','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,'rohith','9581497872','1234','2000.0','0','0','0','0','2000.0','08:18 PM','30 Jul 2025','30 Jul 2025','202507302018','20250730','0','2000.0','0','30 Jul 2025','08:18 PM','202507302018',''),(2,'rohith','9581497872','1234','2000.0','0','0','0','0','2000.0','08:18 PM','30 Jul 2025','30 Jul 2025','202507302018','20250730','100','1900.0','100.0','16 Dec 2025','02:53 PM','202512161453','');
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,'rohith','9581497872','chickens','10','200','2000.0','1234','2000.0','0','0','0','0','2000.0','08:18 PM','30 Jul 2025','30 Jul 2025','202507302018','20250730','','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');
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,'chickens','55','500','300','Kg','200',NULL,'202507091751','09 Jul 2025','1751','05:51:36 pm','202512161452','200.0','200.0','123344','','','0',NULL,'','','200',''),(2,'rice','5','5','10','Kg','50',NULL,'202507091752','09 Jul 2025','1752','05:52:31 pm','202507091752','NaN','-5.0','124','',NULL,NULL,NULL,NULL,NULL,'50',NULL),(3,'oil','5','5','15','L','200',NULL,'202507091753','09 Jul 2025','1753','05:53:35 pm','202507091753','NaN','-10.0','125','',NULL,NULL,NULL,NULL,NULL,'200',NULL),(4,'onion','10','10','20','Kg','0',NULL,'202507091755','09 Jul 2025','1755','05:55:00 pm','202507091755','NaN','-10.0','126','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'tomato','5','5','20','Kg','0',NULL,'202507091755','09 Jul 2025','1755','05:55:38 pm','202507091755','NaN','-15.0','127','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(6,'flour','10','20','30','Kg','0',NULL,'202507091756','09 Jul 2025','1756','05:56:15 pm','202507091756','NaN','-10.0','128','',NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'rice','0','Kg','yes'),(2,'oil','0','L','yes'),(3,'onion','0','Kg','yes'),(4,'tomato','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,'chickens','200.0','200.0','200.0','10.0','2000.0','123344','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.0.33','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','','TM Printer');
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','','','kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','','','kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.87','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.87','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`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`, `hsn_code`, `mfrs`, `batch_no`, `expiry`, `sch`, `online_avail_temp`, `online_avail`, `online_price`, `vendor_name`, `vendor_id`, `purchase_price`) VALUES (1,'idly',25.00,48,'Tiffin','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',1,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'dosa',35.00,50,'Tiffin','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',5,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'pongal',30.00,49,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'upma',30.00,49,'Tiffin','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'poori',35.00,48,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',6,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'masal dosa',40.00,49,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',3,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'bread omlette',30.00,20,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'onion dosa',35.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'rava dosa',35.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'uthappam',30.00,30,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',3,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'vada',20.00,100,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',2,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'masal vada',20.00,49,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',4,'0','0','0','',NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'samosa',20.00,50,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'chicken kabab',60.00,20,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'sheekh kabab',80.00,20,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'pani puri',35.00,30,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'pav bhajji',60.00,30,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'veg cutlet',40.00,30,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'masal puri',35.00,30,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'chicken nuggets',65.00,10,'Snacks','SGST(5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',3,'0','0','0',NULL,NULL,NULL,'Unit','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'veg biriyani',70.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'chicken biriyani',100.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'veg thali',50.00,49,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',1,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'non veg thali',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'mutton biriyani',120.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'roti',15.00,100,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'rice',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'paneer butter masala',60.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'chicken sukka',80.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'dhal fry',30.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'coffee',20.00,100,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,'tea',20.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,30,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,49,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'','','0',1,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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 `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','5.0','50.0','',''),(2,'pongal','28.0','28.0','28.0','10.0','280.0','',''),(3,'onion dosa','100.0','100.0','100.0','50.0','5000.0','',''),(4,'vada','150.0','150.0','150.0','50.0','7500.0','',''),(5,'onion dosa','100.0','100.0','100.0','50.0','5000.0','',''),(6,'vada','150.0','150.0','150.0','50.0','7500.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kds_data` (`_id`, `kotno`, `kotno_auto`, `reset_date`) VALUES (1,'14','388','20251216');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
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,'bijlipay');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (4,'2 inch'),(5,'3 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'1803');
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,'idly','100','rohithdine','dev3','poss3',NULL,NULL,'12:41 PM','16 Dec 2025','20251216124110');
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,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'gst(10%)',10.00,'Itemtax','','dine_in','takeaway','homedelivery',''),(2,'cgst(5%)',5.00,'Itemtax','','dine_in','takeaway','homedelivery',''),(3,'SGST(5%)',5.00,'Globaltax','','dine_in','takeaway','homedelivery',''),(4,'SGSTmk(3%)',3.00,'Itemtax',NULL,'dine_in','takeaway','homedelivery','');
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 `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'rohith','9581497872','krrohith934@gmail.com','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'rohith','9581497872','krrohith934@gmail.com','Bangalore',''),(2,'Vijay','9711588530','vasanth2166@example.com','Coimbatore','49ABCDE0656F30');
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,'rohith','9581497872','1234','330.0','0','0','0','0','330.0','11:37 AM','17 Sep 2024','17 Sep 2024','202409171137','20240917','0','330.0','0','17 Sep 2024','11:37 AM','202409171137',''),(2,'rohith','9581497872','1234','330.0','0','0','0','0','330.0','11:37 AM','17 Sep 2024','17 Sep 2024','202409171137','20240917','100','230.0','100.0','17 Sep 2024','11:38 AM','202409171138',''),(3,'rohith','9581497872','1234','2400.0','0','0','0','0','2400.0','07:06 PM','05 Nov 2024','05 Nov 2024','202411051906','20241105','0','2400.0','0','05 Nov 2024','07:06 PM','202411051906',''),(4,'rohith','9581497872','233456','10','0','0','0','0','10','01:06 PM','04 Feb 2025','04 Feb 2025','202502041306','20250204','10','0.0','10','04 Feb 2025','01:06 PM','202502041306',NULL),(5,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(6,'rohith','9581497872','1234','1340.0','0','0','0','0','1340.0','02:40 PM','26 Apr 2025','26 Apr 2025','202504261440','20250426','0','1340.0','0','26 Apr 2025','02:40 PM','202504261440',''),(7,'rohith','9581497872','123','50','0','0','0','0','50','02:07 PM','03 Jul 2025','03 Jul 2025','202507031407','20250703','0','50.0','0','03 Jul 2025','02:07 PM','202507031407',NULL),(8,'rohith','9581497872','456','40','0','0','0','0','40','02:08 PM','03 Jul 2025','03 Jul 2025','202507031408','20250703','0','40.0','0','03 Jul 2025','02:08 PM','202507031408',NULL),(9,'rohith','9581497872','','25','0','0','0','0','25','02:26 PM','03 Jul 2025','03 Jul 2025','202507031426','20250703','0','25.0','0','03 Jul 2025','02:26 PM','202507031426',NULL),(10,'rohith','9581497872','1234','700.0','0','0','0','0','700.0','07:54 PM','30 Jul 2025','30 Jul 2025','202507301954','20250730','0','700.0','0','30 Jul 2025','07:54 PM','202507301954',''),(11,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(12,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(13,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(14,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(15,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(16,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(17,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(18,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(19,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(20,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(21,'8247488369','','3456','100','0','0','0','0','100','03:11 PM','29 Jan 2025','29 Jan 2025','202501291511','20250129','100','0.0','100','29 Jan 2025','03:11 PM','202501291511',NULL),(22,'rohith','9581497872','1234','400.0','0','0','0','0','400.0','09:10 am','13 Nov 2025','13 Nov 2025','202511130910','20251113','0','400.0','0','13 Nov 2025','09:10 am','202511130910',''),(23,'rohith','9581497872','asdf','700.0','0','0','0','0','700.0','05:17 pm','17 Nov 2025','17 Nov 2025','202511171717','20251117','0','700.0','0','17 Nov 2025','05:17 pm','202511171717',''),(24,'rohith','9581497872','inv70977696','500.0','0','0','0','0','500.0','12:43 PM','16 Dec 2025','16 Dec 2025','202512161243','20251216','100','400.0','100','16 Dec 2025','12:43 PM','202512161243',''),(25,'rohith','9581497872','inv70977696','500.0','0','0','0','0','500.0','12:43 PM','16 Dec 2025','16 Dec 2025','202512161243','20251216','100','300.0','200.0','16 Dec 2025','12:43 PM','202512161243','');
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,'rohith','9581497872','idly2','5','10','50.0','1234','330.0','0','0','0','0','330.0','11:37 AM','17 Sep 2024','17 Sep 2024','202409171137','20240917','','330.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,'rohith','9581497872','pongal1','10','28','280.0','1234','330.0','0','0','0','0','330.0','11:37 AM','17 Sep 2024','17 Sep 2024','202409171137','20240917','','330.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,'rohith','9581497872','onion dosa','50','100','5000.0','12344','12500.0','0','0','0','0','12500.0','08:03 PM','23 Sep 2024','23 Sep 2024','202409232003','20240923','','12500.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,'rohith','9581497872','vada','50','150','7500.0','12344','12500.0','0','0','0','0','12500.0','08:03 PM','23 Sep 2024','23 Sep 2024','202409232003','20240923','','12500.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,'rohith','9581497872','idly2','100','10','1000.0','1234','2400.0','0','0','0','0','2400.0','07:06 PM','05 Nov 2024','05 Nov 2024','202411051906','20241105','','2400.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,'rohith','9581497872','pongal1','50','28','1400.0','1234','2400.0','0','0','0','0','2400.0','07:06 PM','05 Nov 2024','05 Nov 2024','202411051906','20241105','','2400.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,'rohith','9581497872','upma','2','5','10','233456','10','0','0','0','0','10','01:06 PM','04 Feb 2025','04 Feb 2025','202502041306','20250204','10','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),(8,'rohith','9581497872','jollof rice','50','10','500.0','1234','1340.0','0','0','0','0','1340.0','02:40 PM','26 Apr 2025','26 Apr 2025','202504261440','20250426','','1340.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,'rohith','9581497872','moin','30','28','840.0','1234','1340.0','0','0','0','0','1340.0','02:40 PM','26 Apr 2025','26 Apr 2025','202504261440','20250426','','1340.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,'rohith','9581497872','idly','10','5','50','123','50','0','0','0','0','50','02:08 PM','03 Jul 2025','03 Jul 2025','202507031408','20250703','0','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),(11,'rohith','9581497872','idly','8','5','40','456','40','0','0','0','0','40','02:08 PM','03 Jul 2025','03 Jul 2025','202507031408','20250703','0','40.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,'rohith','9581497872','idly','5','5','25','','25','0','0','0','0','25','02:26 PM','03 Jul 2025','03 Jul 2025','202507031426','20250703','0','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),(13,'rohith','9581497872','idly','20','5','100.0','1234','700.0','0','0','0','0','700.0','07:54 PM','30 Jul 2025','30 Jul 2025','202507301954','20250730','','700.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,'rohith','9581497872','dosa','30','20','600.0','1234','700.0','0','0','0','0','700.0','07:54 PM','30 Jul 2025','30 Jul 2025','202507301954','20250730','','700.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,'rohith','9581497872','idly','20','5','100.0','1234','400.0','0','0','0','0','400.0','09:10 am','13 Nov 2025','13 Nov 2025','202511130910','20251113','','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),(16,'rohith','9581497872','pongal','30','10','300.0','1234','400.0','0','0','0','0','400.0','09:10 am','13 Nov 2025','13 Nov 2025','202511130910','20251113','','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),(17,'rohith','9581497872','idly','20','5','100.0','asdf','700.0','0','0','0','0','700.0','05:17 pm','17 Nov 2025','17 Nov 2025','202511171717','20251117','','700.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,'rohith','9581497872','dosa','30','20','600.0','asdf','700.0','0','0','0','0','700.0','05:17 pm','17 Nov 2025','17 Nov 2025','202511171717','20251117','','700.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,'rohith','9581497872','idly','100','5','500.0','inv70977696','500.0','0','0','0','0','500.0','12:43 PM','16 Dec 2025','16 Dec 2025','202512161243','20251216','100','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);
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,'rohith','9581497872','krrohith934@gmail.com','','','330.0','100.0','230.0','1'),(2,'rohith','9581497872','krrohith934@gmail.com','','','2730.0','100.0','2630.0','2'),(3,'rohith','9581497872','krrohith934@gmail.com','','','4080.0','110.0','3970.0','4'),(4,'rohith','9581497872','krrohith934@gmail.com','','','4195.0','110.0','4085.0','7'),(5,'rohith','9581497872','krrohith934@gmail.com','','','4895.0','110.0','4785.0','8'),(6,'rohith','9581497872','krrohith934@gmail.com','','','5295.0','110.0','5185.0','9'),(7,'rohith','9581497872','krrohith934@gmail.com','','','5995.0','110.0','5885.0','10'),(10,'rohith','9581497872','krrohith934@gmail.com','','','5995.0','110.0','5885.0','10'),(11,'rohith','9581497872','krrohith934@gmail.com','','','5995.0','110.0','5885.0','10'),(12,'rohith','9581497872','krrohith934@gmail.com','','','6495.0','210.0','6285.0','11');
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,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','0.0','2000.0','1'),(2,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','0.0','2000.0','1'),(3,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','0.0','2000.0','1'),(4,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','100.0','1900.0','1'),(5,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','100.0','1900.0','1'),(6,'rohith','9581497872','krrohith934@gmail.com','','Bangalore','2000.0','100.0','1900.0','1'),(7,'Vijay','9711588530','vasanth2166@example.com','49ABCDE0656F30','Coimbatore','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');
