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),(4,'','4',NULL,'first','0','4',NULL),(5,'','5',NULL,'first','0','4',NULL),(6,'','6',NULL,'first','0','4',NULL),(7,'','7',NULL,'first','0','4',NULL),(8,'','8',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'),(9,'bijlipay','16778557',NULL,'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,'',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,'pushpanjali','50','₹');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `ezetapmerchantreg` (`_id`, `account`, `userid`, `password`) VALUES (1,'Not_Registered','','');
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 (3,'rice','test','0','8.00','05 Nov 2024','2024 11 05','05:43:22 PM','1743','202411051743','Kg',NULL),(4,'chicken','test','0','8.00','05 Nov 2024','2024 11 05','05:43:22 PM','1743','202411051743','Kg',NULL);
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,'chicken','5','10','8.00','Kg','0',NULL,'202409171150','17 Sep 2024','1150','11:50:41 AM','202409171150','0','2.0','12',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(2,'rice','5','5','8.00','Kg','0',NULL,'202409171150','17 Sep 2024','1150','11:50:57 AM','202409171150','0','-3.0','14',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(3,'chicken','5','5','8.00','Kg','0',NULL,'202409232012','23 Sep 2024','2012','08:12:14 PM','202409232012','0','0.0','123',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(4,'rice','5','5','8.00','Kg','0',NULL,'202409232012','23 Sep 2024','2012','08:12:22 PM','202409232012','0','0.0','125',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'chicken','0','Kg','yes'),(2,'rice','0','Kg','yes');
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`) VALUES (1,'idly',25.00,46,'Tiffin','None','[encoded data, 14500 characters]','0','0',NULL,NULL,NULL,'no','%','0','id','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,'20aa3'),(2,'dosa',35.00,44,'Tiffin','None','[encoded data, 12232 characters]','0','0',NULL,NULL,NULL,'no','%','0','do','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(3,'pongal',30.00,48,'Tiffin','None','[encoded data, 12612 characters]','0','0',NULL,NULL,NULL,'no','%','0','po','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(4,'upma',30.00,49,'Tiffin','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','up','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(5,'poori',35.00,41,'Tiffin','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','po','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(6,'masal dosa',40.00,47,'Tiffin','None','[encoded data, 11308 characters]','0','0',NULL,NULL,NULL,'no','%','0','ma','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(7,'bread omlette',30.00,18,'Tiffin','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','br','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(8,'onion dosa',35.00,28,'Tiffin','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','on','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ra','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(10,'uthappam',30.00,30,'Tiffin','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ut','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(11,'vada',20.00,100,'Snacks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','va','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ma','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(13,'samosa',20.00,50,'Snacks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(14,'chicken kabab',60.00,17,'Snacks','None','[encoded data, 16696 characters]','0','0',NULL,NULL,NULL,'no','%','0','ch','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(16,'pani puri',35.00,29,'Snacks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(17,'pav bhajji',60.00,28,'Snacks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(19,'masal puri',35.00,29,'Snacks','None','[encoded data, 16284 characters]','0','0',NULL,NULL,NULL,'no','%','0','ma','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(23,'veg thali',50.00,50,'Main course','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ve','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(24,'non veg thali',80.00,49,'Main course','None','[encoded data, 16088 characters]','0','0',NULL,NULL,NULL,'no','%','0','no','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','mu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(26,'roti',15.00,99,'Main course','None','[encoded data, 14140 characters]','0','0',NULL,NULL,NULL,'no','%','0','ro','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(27,'rice',30.00,49,'Main course','None','[encoded data, 12472 characters]','0','0',NULL,NULL,NULL,'no','%','0','ri','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','dh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(31,'coffee',20.00,100,'Drinks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(32,'tea',20.00,50,'Drinks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ma','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','so','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','li','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(36,'lassi',25.00,25,'Drinks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','la','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','gr','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',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','[encoded data, 13332 characters]','0','0',NULL,NULL,NULL,'no','%','0','va','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',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','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','bu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(40,'butterscotch cake',35.00,50,'Desserts','None','[encoded data, 14384 characters]','0','0',NULL,NULL,NULL,'no','%','0','bu','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(41,'test',1.00,-3,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,4,'0','0','0',NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(42,'test11',20.00,0,'Desserts','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(43,'test12',20.00,0,'Drinks','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(44,'lays chips',10.00,0,'None','cgst(2%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','la','2134',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,''),(45,'chicken biryani 1',10.00,0,'None','None','','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,NULL,NULL,NULL,NULL,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','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kds_data` (`_id`, `kotno`, `kotno_auto`, `reset_date`) VALUES (1,'10','164','20241220');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `ladmin` (`_id`, `username`, `password`, `name`) VALUES (1,'ladmin','1234','ladmin');
INSERT INTO `login` (`ID`, `USERNAME`, `PASSWORD`, `name`) VALUES (1,'admin','0000','madmin');
INSERT INTO `loginuser` (`_id`, `username`, `password`) VALUES (1,'admin','0000'),(2,'admin','0000'),(3,'admin','0000'),(4,'admin','0000'),(5,'admin','0000'),(9,'admin','1093'),(10,'admin','1093'),(11,'admin','1093'),(21,'admin','0000'),(22,'admin','0000'),(23,'admin','0000'),(24,'admin','0000'),(25,'admin','0000'),(2932,'admin','0000'),(3020,'admin','0000'),(3021,'admin','0000'),(3022,'admin','0000'),(3023,'admin','0000'),(3024,'admin','0000'),(3491,'user1','1111'),(3492,'user1','1111'),(3527,'admin','0000'),(3528,'admin','0000'),(3529,'admin','0000'),(3530,'admin','0000'),(3531,'admin','0000'),(3536,'admin','0000'),(3537,'admin','0000'),(3538,'admin','0000'),(3539,'admin','0000'),(3540,'admin','0000'),(3541,'admin','0000'),(3542,'admin','0000'),(3543,'admin','0000'),(3544,'admin','0000'),(3545,'admin','0000'),(3546,'admin','0000'),(3547,'admin','0000'),(3548,'admin','0000'),(3549,'admin','0000'),(3550,'admin','0000'),(3551,'admin','0000'),(3552,'admin','0000'),(3553,'admin','0000'),(3554,'admin','0000'),(3555,'admin','0000'),(3557,'admin','0000'),(3558,'admin','0000'),(3559,'admin','0000'),(3560,'admin','0000'),(3561,'admin','0000'),(3562,'admin','0000'),(3563,'admin','0000'),(3564,'admin','0000'),(3565,'admin','0000'),(3566,'admin','0000'),(3567,'admin','0000'),(3568,'admin','0000'),(3569,'admin','0000'),(3571,'admin','0000'),(3572,'admin','0000'),(3573,'admin','0000'),(3574,'admin','0000'),(3575,'admin','0000'),(3576,'admin','0000'),(3577,'admin','0000'),(3578,'admin','0000'),(3579,'admin','0000'),(3580,'admin','0000'),(3581,'admin','0000'),(3582,'admin','0000'),(3583,'admin','0000'),(3584,'admin','0000'),(3586,'admin','0000'),(3587,'admin','0000'),(3588,'admin','0000'),(3589,'admin','0000'),(3590,'admin','0000'),(3591,'admin','0000'),(3593,'admin','0000'),(3594,'admin','0000'),(3595,'admin','0000'),(3596,'admin','0000'),(3597,'admin','0000'),(3598,'admin','0000'),(3599,'admin','0000'),(3601,'admin','0000'),(3602,'admin','0000'),(3603,'admin','0000'),(3604,'admin','0000'),(3605,'admin','0000'),(3606,'admin','0000'),(3607,'admin','0000'),(3608,'admin','0000'),(3609,'admin','0000'),(3610,'admin','0000'),(3611,'admin','0000'),(3612,'admin','0000'),(3613,'admin','0000'),(3614,'admin','0000'),(3615,'admin','0000'),(3616,'admin','0000'),(3617,'admin','0000'),(3618,'admin','0000'),(3619,'admin','0000'),(3620,'admin','0000'),(3621,'admin','0000'),(3622,'admin','0000'),(3623,'admin','0000'),(3624,'admin','0000'),(3625,'admin','0000'),(3626,'admin','0000'),(3627,'admin','0000'),(3628,'admin','0000'),(3629,'admin','0000'),(3630,'admin','0000'),(3631,'admin','0000'),(3632,'admin','0000'),(3633,'admin','0000'),(3634,'admin','0000'),(3635,'admin','0000'),(3636,'admin','0000'),(3637,'admin','0000'),(3638,'admin','0000'),(3639,'admin','0000'),(3640,'admin','0000'),(3641,'admin','0000'),(3642,'admin','0000'),(3643,'admin','0000'),(3644,'admin','0000'),(3645,'admin','0000'),(3646,'admin','0000'),(3647,'admin','0000'),(3648,'admin','0000'),(3649,'admin','0000'),(3650,'admin','0000'),(3651,'admin','0000'),(3652,'admin','0000'),(3653,'admin','0000'),(3654,'admin','0000'),(3655,'admin','0000'),(3656,'admin','0000'),(3657,'admin','0000'),(3658,'admin','0000'),(3659,'admin','0000'),(3660,'admin','0000'),(3661,'admin','0000'),(3662,'admin','0000'),(3663,'admin','0000'),(3664,'admin','0000'),(3665,'admin','0000'),(3666,'admin','0000'),(3667,'admin','0000'),(3668,'admin','0000'),(3669,'admin','0000'),(3670,'admin','0000'),(3671,'user1','1111'),(3672,'user1','1111'),(3673,'admin','0000'),(3674,'admin','0000'),(3675,'admin','0000'),(3676,'admin','0000'),(3677,'admin','0000'),(3678,'admin','0000'),(3679,'admin','0000'),(3680,'admin','0000'),(3681,'admin','0000'),(3682,'admin','0000'),(3683,'admin','0000'),(3684,'admin','0000'),(3685,'admin','0000'),(3686,'admin','0000'),(3687,'admin','0000'),(3688,'admin','0000'),(3689,'admin','0000'),(3690,'admin','0000'),(3691,'admin','0000'),(3692,'admin','0000'),(3693,'admin','0000'),(3694,'admin','0000'),(3695,'admin','0000'),(3696,'admin','0000'),(3697,'admin','0000'),(3698,'admin','0000'),(3699,'admin','0000'),(3700,'admin','0000'),(3701,'admin','0000'),(3702,'admin','0000'),(3703,'admin','0000'),(3704,'admin','0000'),(3705,'ladmin','1234'),(3707,'ladmin','1234'),(3708,'ladmin','1234'),(3709,'admin','0000'),(3710,'ladmin','1234'),(3711,'admin','0000'),(3712,'admin','0000'),(3713,'admin','0000'),(3714,'admin','0000'),(3715,'admin','0000'),(3716,'admin','0000'),(3717,'admin','0000'),(3718,'admin','0000'),(3719,'admin','0000'),(3720,'admin','0000'),(3721,'admin','0000'),(3722,'admin','0000'),(3723,'admin','0000'),(3724,'admin','0000'),(3725,'admin','0000'),(3726,'admin','0000'),(3727,'admin','0000'),(3729,'admin','0000'),(3730,'admin','0000'),(3731,'admin','0000'),(3732,'admin','0000'),(3733,'admin','0000'),(3735,'admin','0000'),(3736,'admin','0000'),(3737,'admin','0000'),(3738,'admin','0000'),(3739,'admin','0000'),(3740,'admin','0000'),(3741,'admin','0000'),(3742,'admin','0000'),(3743,'admin','0000'),(3744,'admin','0000'),(3745,'admin','0000'),(3746,'admin','0000'),(3747,'admin','0000'),(3748,'admin','0000'),(3749,'admin','0000'),(3750,'admin','0000'),(3751,'admin','0000'),(3752,'admin','0000'),(3753,'admin','0000'),(3754,'admin','0000'),(3755,'admin','0000'),(3756,'admin','0000'),(3757,'admin','0000'),(3758,'admin','0000'),(3759,'admin','0000'),(3760,'admin','0000'),(3761,'admin','0000'),(3762,'admin','0000'),(3763,'admin','0000'),(3764,'admin','0000'),(3765,'admin','0000'),(3766,'admin','0000'),(3767,'admin','0000'),(3768,'admin','0000'),(3770,'admin','0000'),(3771,'admin','0000'),(3772,'admin','0000'),(3773,'admin','0000'),(3774,'admin','0000'),(3775,'admin','0000'),(3776,'admin','0000'),(3777,'admin','0000'),(3778,'admin','0000'),(3779,'admin','0000'),(3780,'admin','0000'),(3781,'admin','0000'),(3782,'admin','0000'),(3784,'admin','0000'),(3785,'admin','0000'),(3786,'admin','0000'),(3787,'admin','0000'),(3788,'admin','0000'),(3789,'admin','0000'),(3790,'admin','0000'),(3791,'admin','0000'),(3792,'admin','0000'),(3793,'admin','0000'),(3794,'admin','0000'),(3795,'admin','0000'),(3796,'admin','0000'),(3797,'admin','0000'),(3798,'admin','0000'),(3799,'admin','0000'),(3800,'admin','0000'),(3802,'admin','0000'),(3804,'admin','0000'),(3807,'admin','0000'),(3810,'user1','1111'),(3811,'admin','0000'),(3812,'admin','0000'),(3813,'admin','0000'),(3814,'admin','0000'),(3815,'admin','0000'),(3816,'admin','0000'),(3817,'admin','0000'),(3818,'admin','0000'),(3819,'admin','0000'),(3820,'admin','0000'),(3821,'admin','0000'),(3822,'admin','0000'),(3823,'admin','0000'),(3824,'admin','0000'),(3825,'admin','0000'),(3826,'admin','0000'),(3827,'admin','0000'),(3828,'admin','0000'),(3829,'admin','0000'),(3830,'admin','0000'),(3831,'admin','0000'),(3832,'admin','0000'),(3833,'admin','0000'),(3834,'admin','0000'),(3835,'admin','0000'),(3836,'admin','0000'),(3837,'admin','0000'),(3838,'admin','0000'),(3839,'admin','0000'),(3840,'admin','0000'),(3841,'admin','0000'),(3842,'admin','0000'),(3843,'admin','0000'),(3844,'admin','0000'),(3845,'admin','0000'),(3846,'admin','0000'),(3847,'admin','0000'),(3848,'admin','0000'),(3849,'admin','0000'),(3850,'admin','0000');
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 `mobikwikmerchantreg` (`_id`, `Account`, `Merchant_name`, `Mid_otp`, `Secretkey_otp`, `Mid_debit`, `Secretkey_debit`) VALUES (1,'Not_Registered','','','','','');
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,'');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'2318');
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 `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,'cgst(2%)',2.00,'Itemtax','',NULL,NULL,NULL,NULL),(2,'irs(5%)',5.00,'Itemtax','','Dine-in','Takeaway','Home Delivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user1` (`_id`, `name`, `username`, `password`) VALUES (1,'User1','user1','1111');
INSERT INTO `user2` (`_id`, `name`, `username`, `password`) VALUES (1,'User2','user2','2222');
INSERT INTO `user3` (`_id`, `name`, `username`, `password`) VALUES (1,'User3','user3','3333');
INSERT INTO `user4` (`_id`, `name`, `username`, `password`) VALUES (1,'User4','user4','4444');
INSERT INTO `user5` (`_id`, `name`, `username`, `password`) VALUES (1,'User5','user5','5555');
INSERT INTO `user6` (`_id`, `name`, `username`, `password`) VALUES (1,'User6','user6','6666');
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 `userlogin_checking` (`_id`, `username`, `password`, `name`) VALUES (1,NULL,NULL,'madmin'),(2,NULL,NULL,'madmin'),(3,NULL,NULL,'madmin'),(4,NULL,NULL,'madmin'),(5,NULL,NULL,'madmin'),(10,NULL,NULL,'madmin'),(11,NULL,NULL,'madmin'),(12,NULL,NULL,'madmin'),(22,NULL,NULL,'madmin'),(23,NULL,NULL,'madmin'),(24,NULL,NULL,'madmin'),(25,NULL,NULL,'madmin'),(26,NULL,NULL,'madmin'),(2884,NULL,NULL,'madmin'),(2977,NULL,NULL,'madmin'),(2978,NULL,NULL,'madmin'),(2979,NULL,NULL,'madmin'),(2980,NULL,NULL,'madmin'),(2981,NULL,NULL,'madmin'),(3455,NULL,NULL,'user1'),(3456,NULL,NULL,'user1'),(3491,NULL,NULL,'madmin'),(3492,NULL,NULL,'madmin'),(3493,NULL,NULL,'madmin'),(3494,NULL,NULL,'madmin'),(3495,NULL,NULL,'madmin'),(3500,NULL,NULL,'madmin'),(3501,NULL,NULL,'madmin'),(3502,NULL,NULL,'madmin'),(3503,NULL,NULL,'madmin'),(3504,NULL,NULL,'madmin'),(3505,NULL,NULL,'madmin'),(3506,NULL,NULL,'madmin'),(3507,NULL,NULL,'madmin'),(3508,NULL,NULL,'madmin'),(3509,NULL,NULL,'madmin'),(3510,NULL,NULL,'madmin'),(3511,NULL,NULL,'madmin'),(3512,NULL,NULL,'madmin'),(3513,NULL,NULL,'madmin'),(3514,NULL,NULL,'madmin'),(3515,NULL,NULL,'madmin'),(3516,NULL,NULL,'madmin'),(3517,NULL,NULL,'madmin'),(3518,NULL,NULL,'madmin'),(3519,NULL,NULL,'madmin'),(3521,NULL,NULL,'madmin'),(3522,NULL,NULL,'madmin'),(3523,NULL,NULL,'madmin'),(3524,NULL,NULL,'madmin'),(3525,NULL,NULL,'madmin'),(3526,NULL,NULL,'madmin'),(3527,NULL,NULL,'madmin'),(3528,NULL,NULL,'madmin'),(3529,NULL,NULL,'madmin'),(3530,NULL,NULL,'madmin'),(3531,NULL,NULL,'madmin'),(3532,NULL,NULL,'madmin'),(3533,NULL,NULL,'madmin'),(3535,NULL,NULL,'madmin'),(3536,NULL,NULL,'madmin'),(3537,NULL,NULL,'madmin'),(3538,NULL,NULL,'madmin'),(3539,NULL,NULL,'madmin'),(3540,NULL,NULL,'madmin'),(3541,NULL,NULL,'madmin'),(3542,NULL,NULL,'madmin'),(3543,NULL,NULL,'madmin'),(3544,NULL,NULL,'madmin'),(3545,NULL,NULL,'madmin'),(3546,NULL,NULL,'madmin'),(3547,NULL,NULL,'madmin'),(3548,NULL,NULL,'madmin'),(3550,NULL,NULL,'madmin'),(3551,NULL,NULL,'madmin'),(3552,NULL,NULL,'madmin'),(3553,NULL,NULL,'madmin'),(3554,NULL,NULL,'madmin'),(3555,NULL,NULL,'madmin'),(3557,NULL,NULL,'madmin'),(3558,NULL,NULL,'madmin'),(3559,NULL,NULL,'madmin'),(3560,NULL,NULL,'madmin'),(3561,NULL,NULL,'madmin'),(3562,NULL,NULL,'madmin'),(3563,NULL,NULL,'madmin'),(3565,NULL,NULL,'madmin'),(3566,NULL,NULL,'madmin'),(3567,NULL,NULL,'madmin'),(3568,NULL,NULL,'madmin'),(3569,NULL,NULL,'madmin'),(3570,NULL,NULL,'madmin'),(3571,NULL,NULL,'madmin'),(3572,NULL,NULL,'madmin'),(3573,NULL,NULL,'madmin'),(3574,NULL,NULL,'madmin'),(3575,NULL,NULL,'madmin'),(3576,NULL,NULL,'madmin'),(3577,NULL,NULL,'madmin'),(3578,NULL,NULL,'madmin'),(3579,NULL,NULL,'madmin'),(3580,NULL,NULL,'madmin'),(3581,NULL,NULL,'madmin'),(3582,NULL,NULL,'madmin'),(3583,NULL,NULL,'madmin'),(3584,NULL,NULL,'madmin'),(3585,NULL,NULL,'madmin'),(3586,NULL,NULL,'madmin'),(3587,NULL,NULL,'madmin'),(3588,NULL,NULL,'madmin'),(3589,NULL,NULL,'madmin'),(3590,NULL,NULL,'madmin'),(3591,NULL,NULL,'madmin'),(3592,NULL,NULL,'madmin'),(3593,NULL,NULL,'madmin'),(3594,NULL,NULL,'madmin'),(3595,NULL,NULL,'madmin'),(3596,NULL,NULL,'madmin'),(3597,NULL,NULL,'madmin'),(3598,NULL,NULL,'madmin'),(3599,NULL,NULL,'madmin'),(3600,NULL,NULL,'madmin'),(3601,NULL,NULL,'madmin'),(3602,NULL,NULL,'madmin'),(3603,NULL,NULL,'madmin'),(3604,NULL,NULL,'madmin'),(3605,NULL,NULL,'madmin'),(3606,NULL,NULL,'madmin'),(3607,NULL,NULL,'madmin'),(3608,NULL,NULL,'madmin'),(3609,NULL,NULL,'madmin'),(3610,NULL,NULL,'madmin'),(3611,NULL,NULL,'madmin'),(3612,NULL,NULL,'madmin'),(3613,NULL,NULL,'madmin'),(3614,NULL,NULL,'madmin'),(3615,NULL,NULL,'madmin'),(3616,NULL,NULL,'madmin'),(3617,NULL,NULL,'madmin'),(3618,NULL,NULL,'madmin'),(3619,NULL,NULL,'madmin'),(3620,NULL,NULL,'madmin'),(3621,NULL,NULL,'madmin'),(3622,NULL,NULL,'madmin'),(3623,NULL,NULL,'madmin'),(3624,NULL,NULL,'madmin'),(3625,NULL,NULL,'madmin'),(3626,NULL,NULL,'madmin'),(3627,NULL,NULL,'madmin'),(3628,NULL,NULL,'madmin'),(3629,NULL,NULL,'madmin'),(3630,NULL,NULL,'madmin'),(3631,NULL,NULL,'madmin'),(3632,NULL,NULL,'madmin'),(3633,NULL,'0000','madmin'),(3634,NULL,NULL,'madmin'),(3635,NULL,NULL,'madmin'),(3636,NULL,NULL,'user1'),(3637,NULL,NULL,'user1'),(3638,NULL,NULL,'madmin'),(3639,NULL,NULL,'madmin'),(3640,NULL,NULL,'madmin'),(3641,NULL,NULL,'madmin'),(3642,NULL,NULL,'madmin'),(3643,NULL,NULL,'madmin'),(3644,NULL,NULL,'madmin'),(3645,NULL,NULL,'madmin'),(3646,NULL,NULL,'madmin'),(3647,NULL,NULL,'madmin'),(3648,NULL,NULL,'madmin'),(3649,NULL,NULL,'madmin'),(3650,NULL,NULL,'madmin'),(3651,NULL,NULL,'madmin'),(3652,NULL,NULL,'madmin'),(3653,NULL,NULL,'madmin'),(3654,NULL,NULL,'madmin'),(3655,NULL,NULL,'madmin'),(3656,NULL,NULL,'madmin'),(3657,NULL,NULL,'madmin'),(3658,NULL,NULL,'madmin'),(3659,NULL,NULL,'madmin'),(3660,NULL,NULL,'madmin'),(3661,NULL,NULL,'madmin'),(3662,NULL,NULL,'madmin'),(3663,NULL,NULL,'madmin'),(3664,NULL,NULL,'madmin'),(3665,NULL,NULL,'madmin'),(3666,NULL,NULL,'madmin'),(3667,NULL,NULL,'madmin'),(3668,NULL,NULL,'madmin'),(3669,NULL,NULL,'madmin'),(3670,NULL,NULL,'ladmin'),(3672,NULL,NULL,'ladmin'),(3673,NULL,NULL,'ladmin'),(3674,NULL,NULL,'madmin'),(3675,NULL,NULL,'ladmin'),(3676,NULL,NULL,'madmin'),(3677,NULL,NULL,'madmin'),(3678,NULL,NULL,'madmin'),(3679,NULL,NULL,'madmin'),(3680,NULL,NULL,'madmin'),(3681,NULL,NULL,'madmin'),(3682,NULL,NULL,'madmin'),(3683,NULL,NULL,'madmin'),(3684,NULL,NULL,'madmin'),(3685,NULL,NULL,'madmin'),(3686,NULL,NULL,'madmin'),(3687,NULL,NULL,'madmin'),(3688,NULL,NULL,'madmin'),(3689,NULL,NULL,'madmin'),(3690,NULL,NULL,'madmin'),(3691,NULL,NULL,'madmin'),(3692,NULL,NULL,'madmin'),(3694,NULL,NULL,'madmin'),(3695,NULL,NULL,'madmin'),(3696,NULL,NULL,'madmin'),(3697,NULL,NULL,'madmin'),(3698,NULL,NULL,'madmin'),(3700,NULL,NULL,'madmin'),(3701,NULL,NULL,'madmin'),(3702,NULL,NULL,'madmin'),(3703,NULL,NULL,'madmin'),(3704,NULL,NULL,'madmin'),(3705,NULL,NULL,'madmin'),(3706,NULL,NULL,'madmin'),(3707,NULL,NULL,'madmin'),(3708,NULL,NULL,'madmin'),(3709,NULL,NULL,'madmin'),(3710,NULL,NULL,'madmin'),(3711,NULL,NULL,'madmin'),(3712,NULL,NULL,'madmin'),(3713,NULL,'0000','madmin'),(3714,NULL,NULL,'madmin'),(3715,NULL,NULL,'madmin'),(3716,NULL,NULL,'madmin'),(3717,NULL,NULL,'madmin'),(3718,NULL,NULL,'madmin'),(3719,NULL,NULL,'madmin'),(3720,NULL,NULL,'madmin'),(3721,NULL,NULL,'madmin'),(3722,NULL,NULL,'madmin'),(3723,NULL,NULL,'madmin'),(3724,NULL,NULL,'madmin'),(3725,NULL,NULL,'madmin'),(3726,NULL,NULL,'madmin'),(3727,NULL,NULL,'madmin'),(3728,NULL,NULL,'madmin'),(3729,NULL,NULL,'madmin'),(3730,NULL,NULL,'madmin'),(3731,NULL,NULL,'madmin'),(3732,NULL,NULL,'madmin'),(3733,NULL,NULL,'madmin'),(3734,NULL,NULL,'madmin'),(3736,NULL,NULL,'madmin'),(3737,NULL,NULL,'madmin'),(3738,NULL,NULL,'madmin'),(3739,NULL,NULL,'madmin'),(3740,NULL,NULL,'madmin'),(3741,NULL,NULL,'madmin'),(3742,NULL,NULL,'madmin'),(3743,NULL,NULL,'madmin'),(3744,NULL,NULL,'madmin'),(3745,NULL,NULL,'madmin'),(3746,NULL,NULL,'madmin'),(3747,NULL,NULL,'madmin'),(3748,NULL,NULL,'madmin'),(3750,NULL,NULL,'madmin'),(3751,NULL,NULL,'madmin'),(3752,NULL,NULL,'madmin'),(3753,NULL,NULL,'madmin'),(3754,NULL,NULL,'madmin'),(3755,NULL,NULL,'madmin'),(3756,NULL,NULL,'madmin'),(3757,NULL,NULL,'madmin'),(3758,NULL,NULL,'madmin'),(3759,NULL,NULL,'madmin'),(3760,NULL,NULL,'madmin'),(3761,NULL,NULL,'madmin'),(3762,NULL,NULL,'madmin'),(3763,NULL,NULL,'madmin'),(3764,NULL,'0000','madmin'),(3765,NULL,NULL,'madmin'),(3766,NULL,NULL,'madmin'),(3767,NULL,NULL,'madmin'),(3769,NULL,NULL,'madmin'),(3771,NULL,NULL,'madmin'),(3774,NULL,NULL,'madmin'),(3777,NULL,NULL,'user1'),(3778,NULL,NULL,'madmin'),(3779,NULL,NULL,'madmin'),(3780,NULL,NULL,'madmin'),(3781,NULL,NULL,'madmin'),(3782,NULL,NULL,'madmin'),(3783,NULL,NULL,'madmin'),(3784,NULL,NULL,'madmin'),(3785,NULL,NULL,'madmin'),(3786,NULL,NULL,'madmin'),(3787,NULL,NULL,'madmin'),(3788,NULL,NULL,'madmin'),(3789,NULL,NULL,'madmin'),(3790,NULL,NULL,'madmin'),(3791,NULL,NULL,'madmin'),(3792,NULL,NULL,'madmin'),(3793,NULL,NULL,'madmin'),(3794,NULL,NULL,'madmin'),(3795,NULL,NULL,'madmin'),(3796,NULL,NULL,'madmin'),(3797,NULL,NULL,'madmin'),(3798,NULL,NULL,'madmin'),(3799,NULL,NULL,'madmin'),(3800,NULL,NULL,'madmin'),(3801,NULL,NULL,'madmin'),(3802,NULL,NULL,'madmin'),(3803,NULL,NULL,'madmin'),(3804,NULL,NULL,'madmin'),(3805,NULL,NULL,'madmin'),(3806,NULL,NULL,'madmin'),(3807,NULL,NULL,'madmin'),(3808,NULL,NULL,'madmin'),(3809,NULL,NULL,'madmin'),(3810,NULL,NULL,'madmin'),(3811,NULL,NULL,'madmin'),(3812,NULL,NULL,'madmin'),(3813,NULL,NULL,'madmin'),(3814,NULL,NULL,'madmin'),(3815,NULL,NULL,'madmin'),(3816,NULL,NULL,'madmin'),(3817,NULL,NULL,'madmin');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (1,'Regular','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'small','5',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,'rohith','9581497872','krrohith934@gmail.com','','');
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','');
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','idly','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','pongal','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','idly','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','pongal','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);
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');
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');
