INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Qsr');
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','1',NULL,'first 1','0','10',''),(2,'2','2',NULL,'first 1','0','5',''),(3,'3','3',NULL,'first 1','0','4',''),(4,'','1',NULL,'ac','1','4',NULL),(5,'','2',NULL,'ac','1','4',NULL),(6,'','3',NULL,'ac','1','4',NULL),(7,'','4',NULL,'ac','1','4',NULL),(8,'','5',NULL,'ac','1','4',NULL),(9,'','6',NULL,'ac','1','4',NULL),(10,'','7',NULL,'ac','1','4',NULL),(11,'','8',NULL,'ac','1','4',NULL),(12,'','4',NULL,'first 1','0','4',NULL),(13,'','13',NULL,'first','0','4',NULL),(14,'','14',NULL,'first','0','4',NULL),(15,'','15',NULL,'first','0','4',NULL),(16,'','16',NULL,'first','0','4',NULL),(17,'','17',NULL,'first','0','4',NULL),(18,'','18',NULL,'first','0','4',NULL),(19,'','19',NULL,'first','0','4',NULL),(20,'','20',NULL,'first','0','4',NULL),(21,'','21',NULL,'first','0','4',NULL),(22,'','22',NULL,'first','0','4',NULL),(23,'','23',NULL,'first','0','4',NULL),(24,'','24',NULL,'first','0','4',NULL),(25,'','25',NULL,'first','0','4',NULL),(26,'','26',NULL,'first','0','4',NULL),(27,'','27',NULL,'first','0','4',NULL),(28,'','28',NULL,'first','0','4',NULL),(29,'','29',NULL,'first','0','4',NULL),(30,'','30',NULL,'first','0','4',NULL),(31,'','31',NULL,'first','0','4',NULL),(32,'','32',NULL,'first','0','4',NULL),(33,'','33',NULL,'first','0','4',NULL),(34,'','34',NULL,'first','0','4',NULL),(35,'','35',NULL,'first','0','4',NULL),(36,'','36',NULL,'first','0','4',NULL),(37,'','37',NULL,'first','0','4',NULL),(38,'','38',NULL,'first','0','4',NULL),(39,'','39',NULL,'first','0','4',NULL),(40,'','40',NULL,'first','0','4',NULL),(41,'','41',NULL,'first','0','4',NULL),(42,'','42',NULL,'first','0','4',NULL),(43,'','43',NULL,'first','0','4',NULL),(44,'','44',NULL,'first','0','4',NULL),(45,'','45',NULL,'first','0','4',NULL),(46,'','46',NULL,'first','0','4',NULL),(47,'','47',NULL,'first','0','4',NULL),(48,'','48',NULL,'first','0','4',NULL),(49,'','49',NULL,'first','0','4',NULL),(50,'','50',NULL,'first','0','4',NULL),(51,'','51',NULL,'first','0','4',NULL),(52,'','52',NULL,'first','0','4',NULL),(53,'','53',NULL,'first','0','4',NULL),(54,'','54',NULL,'first','0','4',NULL),(55,'','55',NULL,'first','0','4',NULL),(56,'','56',NULL,'first','0','4',NULL),(57,'','57',NULL,'first','0','4',NULL),(58,'','58',NULL,'first','0','4',NULL),(59,'','59',NULL,'first','0','4',NULL),(60,'','60',NULL,'first','0','4',NULL),(61,'','61',NULL,'first','0','4',NULL),(62,'','62',NULL,'first','0','4',NULL),(63,'','63',NULL,'first','0','4',NULL),(64,'','64',NULL,'first','0','4',NULL),(65,'','65',NULL,'first','0','4',NULL),(66,'','66',NULL,'first','0','4',NULL),(67,'','67',NULL,'first','0','4',NULL),(68,'','68',NULL,'first','0','4',NULL),(69,'','69',NULL,'first','0','4',NULL),(70,'','70',NULL,'first','0','4',NULL),(71,'','71',NULL,'first','0','4',NULL),(72,'','72',NULL,'first','0','4',NULL),(73,'','73',NULL,'first','0','4',NULL),(74,'','74',NULL,'first','0','4',NULL),(75,'','75',NULL,'first','0','4',NULL),(76,'','76',NULL,'first','0','4',NULL),(77,'','77',NULL,'first','0','4',NULL),(78,'','78',NULL,'first','0','4',NULL),(79,'','79',NULL,'first','0','4',NULL),(80,'','80',NULL,'first','0','4',NULL),(81,'','81',NULL,'first','0','4',NULL),(82,'','82',NULL,'first','0','4',NULL),(83,'','83',NULL,'first','0','4',NULL),(84,'','84',NULL,'first','0','4',NULL),(85,'','85',NULL,'first','0','4',NULL),(86,'','86',NULL,'first','0','4',NULL),(87,'','87',NULL,'first','0','4',NULL),(88,'','88',NULL,'first','0','4',NULL),(89,'','89',NULL,'first','0','4',NULL),(90,'','90',NULL,'first','0','4',NULL),(91,'','91',NULL,'first','0','4',NULL),(92,'','92',NULL,'first','0','4',NULL),(93,'','93',NULL,'first','0','4',NULL),(94,'','94',NULL,'first','0','4',NULL),(95,'','95',NULL,'first','0','4',NULL),(96,'','96',NULL,'first','0','4',NULL),(97,'','97',NULL,'first','0','4',NULL),(98,'','98',NULL,'first','0','4',NULL),(99,'','99',NULL,'first','0','4',NULL),(100,'','1',NULL,'first','0','4',NULL),(101,'','2',NULL,'first','0','4',NULL),(102,'','3',NULL,'first','0','4',NULL),(103,'','1',NULL,'Ground floor ','2','4',NULL),(104,'','2',NULL,'Ground floor ','2','4',NULL),(105,'','3',NULL,'Ground floor ','2','4',NULL),(106,'','4',NULL,'Ground floor ','2','4',NULL),(107,'','5',NULL,'Ground floor ','2','4',NULL),(108,'','1',NULL,'2 floor ','3','4',NULL),(109,'','2',NULL,'2 floor ','3','4',NULL),(110,'','3',NULL,'2 floor ','3','4',NULL),(111,'','4',NULL,'2 floor ','3','4',NULL),(112,'','5',NULL,'2 floor ','3','4',NULL),(113,'','1',NULL,'take away','4','4',NULL),(114,'','2',NULL,'take away','4','4',NULL),(115,'','3',NULL,'take away','4','4',NULL),(116,'','4',NULL,'take away','4','4',NULL),(117,'','5',NULL,'take away','4','4',NULL),(118,'','1',NULL,'pick up','5','4',NULL),(119,'','2',NULL,'pick up','5','4',NULL),(120,'','3',NULL,'pick up','5','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,'','','',NULL);
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 (27,'Intuition','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','www.intuitionsoftwares.com','','');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first 1','0'),(2,'ac','1'),(3,'Ground floor ','2'),(4,'2 floor ','3'),(5,'take away','4'),(6,'pick up','5');
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,'BEVERAGES',NULL,NULL,NULL,NULL),(5,'breakfast ',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 (7,'rice','idly','0.2','7.58','12 Oct 2023','202310121302','01:02:25 pm','1302','202403131831','Kg','2.0'),(10,'rice','veg biriyani','0.1','20','28 Oct 2023','202310281458','02:58:32 pm','1458','202310281507','Kg','-15.0'),(17,'rava','rava dosa','0.2','50','05 Dec 2023','202312051225','12:25:51 pm','1225','202312051225','Kg','0.0'),(18,'rava','samosa','0.3','50','05 Dec 2023','202312051225','12:25:51 pm','1225','202312051225','Kg','0.0'),(20,'rice','chicken biriyani','0.02','7.80','29 Feb 2024','2024 02 29','04:13:53 pm','1613','202402291613','Kg',NULL),(21,'rava','idly','0.02','49.40','13 Mar 2024','2024 03 13','06:31:17 pm','1831','202403131831','Kg',NULL),(22,'dal','dosa','0.02','29.96','26 Mar 2024','202403262102','09:02:25 pm','2102','202403262102','Kg','-5.0'),(23,'dal','idly','0.01','30','26 Mar 2024','202403262102','09:02:25 pm','2102','202403262102','Kg','-5.0'),(24,'dal','masal dosa','0.02','30','26 Mar 2024','202403262102','09:02:25 pm','2102','202403262102','Kg','-5.0'),(26,'chess ','bread omlette','0.02','0.98','29 Mar 2024','202403291518','03:18:20 pm','1518','202403291518','Kg','1.0'),(27,'Dal 1','pongal','0.01','25','04 Apr 2024','202404041339','01:39:25 pm','1339','202404041339','Kg','0.0'),(28,'Dal 1','dosa','0.1','25','04 Apr 2024','202404041339','01:39:25 pm','1339','202404041339','Kg','0.0'),(29,'flour ','butterscotch cake','0.02','29.94','18 Apr 2024','202404181457','02:57:57 pm','1457','202404181457','Kg','0.0'),(30,'mflour ','butterscotch cake','0.02','29.96','18 Apr 2024','202404181459','02:59:09 pm','1459','202404181459','Kg','0.0'),(31,'red chill ','masal dosa','0.01','30','16 May 2024','202405161821','06:21:29 pm','1821','202405161821','Kg','-5.0'),(32,'red chill ','poori','0.01','30','16 May 2024','202405161821','06:21:29 pm','1821','202405161821','Kg','-5.0'),(33,'rice 1','idly','0.01','30','17 May 2024','202405171235','12:35:29 pm','1235','202405171235','Kg','-10.0'),(34,'rice 1','dosa','0.01','30','17 May 2024','202405171235','12:35:29 pm','1235','202405171235','Kg','-10.0'),(35,'flour 4','pongal','0.4','19.80','30 May 2024','202405301951','07:51:36 pm','1951','202405301951','Kg','-10.0'),(36,'flour 4','dosa','0.2','19.80','30 May 2024','202405301951','07:51:36 pm','1951','202405301951','Kg','-10.0'),(37,'flour 4','idly','0','19.80','30 May 2024','202405301951','07:51:36 pm','1951','202405301951','Kg','-10.0'),(38,'milk','coffee ','0.01','30','02 Jun 2024','202406021219','12:19:21 pm','1219','202406021219','L','-5.0'),(39,'milk','c coffee ','0.02','30','02 Jun 2024','202406021219','12:19:21 pm','1219','202406021219','L','-5.0'),(40,'coffee beans ','coffee ','0.01','30','07 Jun 2024','202406071256','12:56:04 pm','1256','202406071256','Kg','0.0'),(41,'coffee beans ','c coffee ','0.01','30','07 Jun 2024','202406071256','12:56:04 pm','1256','202406071256','Kg','0.0'),(42,'rice 10','idly','0.1','30','10 Jun 2024','202406101319','01:19:34 pm','1319','202406101319','Kg','0.0'),(43,'rice 10','dosa','0.01','30','10 Jun 2024','202406101319','01:19:34 pm','1319','202406101319','Kg','0.0'),(44,'rice 10','pongal','0.02','30','10 Jun 2024','202406101319','01:19:34 pm','1319','202406101319','Kg','0.0'),(45,'qwert','idly','0.01','30','11 Jun 2024','202406111314','01:14:38 pm','1314','202406111314','Kg','0.0'),(46,'qwert','dosa','0.02','30','11 Jun 2024','202406111314','01:14:38 pm','1314','202406111314','Kg','0.0'),(47,'qwert','pongal','0.01','30','11 Jun 2024','202406111314','01:14:38 pm','1314','202406111314','Kg','0.0'),(48,'asdfg','idly','0.01','29.65','13 Jun 2024','202406131747','05:47:28 pm','1747','202406131747','Kg','0.0'),(49,'asdfg','dosa','0.3','29.65','13 Jun 2024','202406131747','05:47:28 pm','1747','202406131747','Kg','0.0'),(50,'asdfg','pongal','0.02','29.65','13 Jun 2024','202406131747','05:47:28 pm','1747','202406131747','Kg','0.0'),(51,'asdfg','upma','0.02','29.65','13 Jun 2024','202406131747','05:47:28 pm','1747','202406131747','Kg','0.0'),(52,'Dal 4','pongal','0.2','24.10','16 Jul 2024','202407161758','05:58:27 pm','1758','202407161758','Kg','0.0'),(53,'Dal 4','upma','0.3','24.10','16 Jul 2024','202407161758','05:58:27 pm','1758','202407161758','Kg','0.0'),(54,'Dal 4','poori','0.4','24.10','16 Jul 2024','202407161758','05:58:27 pm','1758','202407161758','Kg','0.0'),(55,'rice','dosa','0.01','29.99','16 Aug 2024','202408162020','08:20:55 pm','2020','202408162020','Kg','0.0'),(56,'rice9','dosa','0.01','29.99','16 Aug 2024','202408162021','08:21:41 pm','2021','202408162021','Kg','0.0'),(57,'coffee beans 10','coffee ','0.01','25','22 Aug 2024','202408221840','06:40:31 pm','1840','202408221840','Kg','-5.0'),(58,'coffee beans 10','c coffee ','0.01','24.99','22 Aug 2024','202408221841','06:41:57 pm','1841','202408221841','Kg','-5.0'),(59,'qwertq','SINGLE THATTE IDLI','0.03','24.97','16 Dec 2024','202412161349','01:49:02 pm','1349','202412161349','Kg','0.0');
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,'rice','10','5','7.18','Kg','0',NULL,'202310281504','28 Oct 2023','1504','03:04:44 pm','202310281507','0','-15.0','','Low',NULL,NULL,NULL,NULL,NULL,'0',NULL),(2,'flour ','25','30','29.94','Kg','0',NULL,'202311181409','18 Nov 2023','1409','02:09:01 pm','202401092150','0','-10.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(3,'rava','25','50','49.30','Kg','0',NULL,'202312051225','05 Dec 2023','1225','12:25:53 pm','202312051225','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(4,'coffee beans ','20','30','29.98','Kg','0',NULL,'202312081507','08 Dec 2023','1507','03:07:00 pm','202312081507','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'dal','30','25','29.82','Kg','0',NULL,'202403262102','26 Mar 2024','2102','09:02:27 pm','202403262102','0','-5.0','','Low',NULL,NULL,NULL,NULL,NULL,'0',NULL),(6,'rice 1','30','35','29.92','Kg','0',NULL,'202403281415','28 Mar 2024','1415','02:15:24 pm','202403281415','0','0.0','','Low',NULL,NULL,NULL,NULL,NULL,'0',NULL),(7,'chess ','0.5','2','0.98','Kg','0',NULL,'202403291518','29 Mar 2024','1518','03:18:22 pm','202403291518','0','1.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(8,'Dal 1','20','25','24.58','Kg','0',NULL,'202404041339','04 Apr 2024','1339','01:39:27 pm','202412121827','0','0.42000008','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(9,'mflour ','25','30','29.96','Kg','0',NULL,'202404181458','18 Apr 2024','1458','02:58:16 pm','202404181459','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(10,'red chill ','20','25','29.96','Kg','0',NULL,'202405161821','16 May 2024','1821','06:21:31 pm','202405161821','0','-5.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(11,'rice 3','25','20','30','Kg','0',NULL,'202405171235','17 May 2024','1235','12:35:38 pm','202405171235','0','-10.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(12,'flour 4','5','10','17.40','Kg','0',NULL,'202405301951','30 May 2024','1951','07:51:38 pm','202405301951','0','-10.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(13,'milk','20','25','29.97','L','0',NULL,'202406021219','02 Jun 2024','1219','12:19:26 pm','202406021219','0','-5.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(14,'coffee beans 2','20','30','30','Kg','0',NULL,'202406071256','07 Jun 2024','1256','12:56:08 pm','202406071256','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(15,'rice 10','10','30','29.68','Kg','0',NULL,'202406101319','10 Jun 2024','1319','01:19:38 pm','202406101319','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(16,'qwert','20','30','29.83','Kg','0',NULL,'202406111314','11 Jun 2024','1314','01:14:40 pm','202406111314','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(17,'asdfg','20','30','29.03','Kg','0',NULL,'202406131747','13 Jun 2024','1747','05:47:31 pm','202406131747','0','0.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(18,'Dal 4','20','25','25','Kg','0',NULL,'202407161758','16 Jul 2024','1758','05:58:34 pm','202407161758','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(19,'rice9','25','30','30','Kg','0',NULL,'202408162021','16 Aug 2024','2021','08:21:01 pm','202408162021','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(20,'coffee beans 10','20','20','25','Kg','0',NULL,'202408221840','22 Aug 2024','1840','06:40:07 pm','202408221841','0','-5.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(21,'qwertq','20','25','25','Kg','0',NULL,'202412161349','16 Dec 2024','1349','01:49:05 pm','202412161349','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'pongal','0.2','Kg','yes'),(2,'upma','0.3','Kg','yes'),(3,'poori','0.4','Kg','yes');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'SINGLE THATTE IDLI',35.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SI','',NULL,NULL,NULL,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,'THATTE IDLI WITH SAMBAR DIP',45.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','TH','',NULL,NULL,NULL,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,'BUTTER THATTE IDLI',50.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BU','',NULL,NULL,NULL,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,'GHEE PUDI THATTE IDLI',65.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GH','',NULL,NULL,NULL,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,'GHEE MASALA DOSA',100.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GH','',NULL,NULL,NULL,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,'BUTTER MASALA DOSA',100.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BU','',NULL,NULL,NULL,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,'KHALI DOSA',90.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','KH','',NULL,NULL,NULL,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,'BUTTER KHALI DOSA',100.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BU','',NULL,NULL,NULL,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,'SET DOSA',100.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SE','',NULL,NULL,NULL,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,'ONION DOSA',120.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ON','',NULL,NULL,NULL,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,'VEG PULAO',100.00,0,'TIFFIN','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','VE','',NULL,NULL,NULL,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,'FILTER COFFEE',30.00,0,'BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FI','',NULL,NULL,NULL,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,'FILTER COFFEE WITH JAGGERY',35.00,0,'BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FI','',NULL,NULL,NULL,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,'LEMON TEA',30.00,0,'BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','LE','',NULL,NULL,NULL,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,'BOOST / HORLICKS',40.00,0,'BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BO','',NULL,NULL,NULL,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,'BADAM MILK',40.00,0,'BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BA','',NULL,NULL,NULL,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,'qweyu',30.00,25,'breakfast ','None','','0','0',NULL,NULL,NULL,'no','%','0','QW','',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);
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'pizza','50.0','50.0','50.0','50.0','2500.0','',''),(2,'pongal','50.0','50.0','50.0','50.0','2500.0','',''),(3,'pongal','50.0','50.0','50.0','50.0','2500.0','',''),(4,'pizza','50.0','50.0','50.0','100.0','5000.0','',''),(5,'ash','60.0','60.0','60.0','50.0','3000.0','',''),(6,'asdg','20.0','20.0','20.0','50.0','1000.0','',''),(7,'hfhjcfv','50.0','50.0','50.0','150.0','7500.0','',''),(8,'ddgg','20.0','20.0','20.0','50.0','1000.0','',''),(9,'corn pizza ','150.0','150.0','150.0','50.0','7500.0','',''),(10,'chty','100.0','100.0','100.0','30.0','3000.0','',''),(11,'asdg','20.0','20.0','20.0','50.0','1000.0','',''),(12,'hfhjcfv','50.0','50.0','50.0','150.0','7500.0','',''),(13,'ddgg','20.0','20.0','20.0','50.0','1000.0','',''),(14,'corn pizza ','150.0','150.0','150.0','50.0','7500.0','',''),(15,'rice shake ','491.2','50.0','500.0','51.0','25050.0','',''),(16,'coffee idle ','20.0','20.0','20.0','50.0','1000.0','',''),(17,'chty','100.0','100.0','100.0','30.0','3000.0','',''),(18,'asdfg','10.0','10.0','10.0','20.0','200.0','',''),(19,'chicken chip rice','100.0','100.0','100.0','50.0','5000.0','',''),(20,'steak ','100.0','100.0','100.0','50.0','5000.0','',''),(21,'briyani ','300.0','300.0','300.0','50.0','15000.0','',''),(22,'chicken momo','100.0','100.0','100.0','50.0','5000.0','',''),(23,'jokbvg','50.0','50.0','50.0','50.0','2500.0','',''),(24,'wings 3','50.0','50.0','50.0','50.0','2500.0','',''),(25,'water','17.0','17.0','17.0','100.0','1700.0','',''),(26,'Dosa ','10.0','10.0','10.0','20.0','200.0','',''),(27,'gigui','45.0','45.0','45.0','20.0','900.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `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,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (7,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Pro');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'gst(2.5%)',2.50,'Globaltax','','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,'shivani ','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (1,'Regular','50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'large','100',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,'Shivani Nayak','+191812315','','','');
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,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','01:25 PM','11 Apr 2023','11 Apr 2023','202304111325','20230411','0','2500.0','0','11 Apr 2023','01:25 PM','202304111325',''),(2,'Shivani Nayak','+191812315','','3000.0','0','0','0','0','3000.0','05:19 PM','08 May 2023','08 May 2023','202305081719','20230508','0','3000.0','0','08 May 2023','05:19 PM','202305081719',''),(3,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','06:33 PM','16 May 2023','16 May 2023','202305161833','20230516','0','1000.0','0','16 May 2023','06:33 PM','202305161833',''),(4,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','02:07 PM','19 May 2023','19 May 2023','202305191407','20230519','0','2500.0','0','19 May 2023','02:07 PM','202305191407',''),(5,'Shivani Nayak','+191812315','','500.0','0','0','0','0','500.0','12:17 PM','01 Jun 2023','01 Jun 2023','202306011217','20230601','0','500.0','0','01 Jun 2023','12:17 PM','202306011217',''),(6,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','03:05 PM','01 Jun 2023','01 Jun 2023','202306011505','20230601','0','2500.0','0','01 Jun 2023','03:05 PM','202306011505',''),(7,'Shivani Nayak','+191812315','','5000.0','0','0','0','0','5000.0','03:36 PM','02 Jun 2023','02 Jun 2023','202306021536','20230602','0','5000.0','0','02 Jun 2023','03:36 PM','202306021536',''),(8,'Shivani Nayak','+191812315','','5000.0','0','0','0','0','5000.0','11:16 AM','07 Jun 2023','07 Jun 2023','202306071116','20230607','0','5000.0','0','07 Jun 2023','11:16 AM','202306071116',''),(9,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','11:17 AM','07 Jun 2023','07 Jun 2023','202306071117','20230607','0','1000.0','0','07 Jun 2023','11:17 AM','202306071117',''),(10,'Shivani Nayak','+191812315','','3000.0','0','0','0','0','3000.0','01:34 PM','21 Jun 2023','21 Jun 2023','202306211334','20230621','3000.0','0.0','3000.0','21 Jun 2023','01:34 PM','202306211334',''),(11,'Shivani Nayak','+191812315','','7500.0','0','0','0','0','7500.0','02:17 PM','23 Jun 2023','23 Jun 2023','202306231417','20230623','0','7500.0','0','23 Jun 2023','02:17 PM','202306231417',''),(12,'Shivani Nayak','+191812315','','7500.0','0','0','0','0','7500.0','02:17 PM','23 Jun 2023','23 Jun 2023','202306231417','20230623','7500','0.0','7500.0','23 Jun 2023','02:18 PM','202306231418',''),(13,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','03:12 PM','06 Jul 2023','06 Jul 2023','202307061512','20230706','2500','0.0','2500','06 Jul 2023','03:12 PM','202307061512',''),(14,'Shivani Nayak','+191812315','','50.0','0','0','0','0','50.0','03:16 PM','06 Jul 2023','06 Jul 2023','202307061516','20230706','0','50.0','0','06 Jul 2023','03:16 PM','202307061516',''),(15,'Shivani Nayak','+191812315','','25000.0','0','0','0','0','25000.0','04:41 PM','10 Jul 2023','10 Jul 2023','202307101641','20230710','25000','0.0','25000','10 Jul 2023','04:41 PM','202307101641',''),(16,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','03:52 PM','25 Jul 2023','25 Jul 2023','202307251552','20230725','0','1000.0','0','25 Jul 2023','03:52 PM','202307251552',''),(17,'Shivani Nayak','+191812315','','1200.0','0','0','0','0','1200.0','04:07 PM','25 Jul 2023','25 Jul 2023','202307251607','20230725','1200','0.0','1200','25 Jul 2023','04:07 PM','202307251607',''),(18,'Shivani Nayak','+191812315','','200.0','0','0','0','0','200.0','04:11 PM','25 Jul 2023','25 Jul 2023','202307251611','20230725','0','200.0','0','25 Jul 2023','04:11 PM','202307251611',''),(19,'Shivani Nayak','+191812315','','5000.0','0','0','0','0','5000.0','03:46 PM','05 Aug 2023','05 Aug 2023','202308051546','20230805','5000','0.0','5000','05 Aug 2023','03:46 PM','202308051546',''),(20,'Shivani Nayak','+191812315','','5000.0','0','0','0','0','5000.0','12:35 PM','16 Aug 2023','16 Aug 2023','202308161235','20230816','5000','0.0','5000','16 Aug 2023','12:35 PM','202308161235',''),(21,'Shivani Nayak','+191812315','','1500.0','0','0','0','0','1500.0','03:30 PM','17 Aug 2023','17 Aug 2023','202308171530','20230817','1500','0.0','1500','17 Aug 2023','03:30 PM','202308171530',''),(22,'Shivani Nayak','+191812315','','15000.0','0','0','0','0','15000.0','03:59 PM','18 Aug 2023','18 Aug 2023','202308181559','20230818','15000','0.0','15000','18 Aug 2023','03:59 PM','202308181559',''),(23,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','06:31 PM','22 Aug 2023','22 Aug 2023','202308221831','20230822','2500','0.0','2500','22 Aug 2023','06:31 PM','202308221831',''),(24,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','02:03 pm','31 Aug 2023','31 Aug 2023','202308311403','20230831','0','2500.0','0','31 Aug 2023','02:03 pm','202308311403',''),(25,'Shivani Nayak','+191812315','','5000.0','0','0','0','0','5000.0','01:37 pm','01 Sep 2023','01 Sep 2023','202309011337','20230901','5000','0.0','5000','01 Sep 2023','01:37 pm','202309011337',''),(26,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','02:48 pm','13 Sept 2023','13 Sept 2023','202309131448','20230913','2500','0.0','2500','13 Sept 2023','02:48 pm','202309131448',''),(27,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','03:42 pm','26 Sept 2023','26 Sept 2023','202309261542','20230926','2500','0.0','2500','26 Sept 2023','03:42 pm','202309261542',''),(28,'Shivani Nayak','+191812315','','850.0','0','0','0','0','850.0','02:49 pm','09 Oct 2023','09 Oct 2023','202310091449','20231009','850','0.0','850','09 Oct 2023','02:49 pm','202310091449',''),(29,'Shivani Nayak','+191812315','','200.0','0','0','0','0','200.0','03:14 pm','18 Oct 2023','18 Oct 2023','202310181514','20231018','200','0.0','200','18 Oct 2023','03:14 pm','202310181514',''),(30,'Shivani Nayak','+191812315','','900.0','0','0','0','0','900.0','02:53 pm','28 Oct 2023','28 Oct 2023','202310281453','20231028','900','0.0','900','28 Oct 2023','02:53 pm','202310281453',''),(31,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','06:26 pm','21 Nov 2023','21 Nov 2023','202311211826','20231121','1000','0.0','1000','21 Nov 2023','06:26 pm','202311211826',''),(32,'Shivani Nayak','+191812315','','360.0','0','0','0','0','360.0','04:00 pm','04 Dec 2023','04 Dec 2023','202312041600','20231204','360','0.0','360','04 Dec 2023','04:00 pm','202312041600',''),(33,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','12:16 pm','05 Dec 2023','05 Dec 2023','202312051216','20231205','2500','0.0','2500','05 Dec 2023','12:16 pm','202312051216',''),(34,'Shivani Nayak','+191812315','','600.0','0','0','0','0','600.0','02:56 pm','08 Dec 2023','08 Dec 2023','202312081456','20231208','600','0.0','600','08 Dec 2023','02:56 pm','202312081456',''),(35,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','08:04 pm','02 Jan 2024','02 Jan 2024','202401022004','20240102','0','2500.0','0','02 Jan 2024','08:04 pm','202401022004',''),(36,'Shivani Nayak','+191812315','','300.0','0','0','0','0','300.0','07:51 pm','08 Jan 2024','08 Jan 2024','202401081951','20240108','0','300.0','0','08 Jan 2024','07:51 pm','202401081951',''),(37,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','02:25 pm','03 Feb 2024','03 Feb 2024','202402031425','20240203','400','0.0','400','03 Feb 2024','02:25 pm','202402031425',''),(38,'Shivani Nayak','+191812315','','3000.0','0','0','0','0','3000.0','06:21 pm','03 Feb 2024','03 Feb 2024','202402031821','20240203','3000','0.0','3000','03 Feb 2024','06:21 pm','202402031821',''),(39,'Shivani Nayak','+191812315','','260.0','0','0','0','0','260.0','08:15 pm','26 Feb 2024','26 Feb 2024','202402262015','20240226','260','0.0','260','26 Feb 2024','08:15 pm','202402262015',''),(40,'Shivani Nayak','+191812315','','2500.0','0','0','0','0','2500.0','01:25 PM','11 Apr 2023','11 Apr 2023','202304111325','20230411','2500','0.0','2500.0','26 Feb 2024','08:17 pm','202402262017',''),(41,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','08:42 am','29 Feb 2024','29 Feb 2024','202402290842','20240229','400','0.0','400','29 Feb 2024','08:42 am','202402290842',''),(42,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','04:01 pm','29 Feb 2024','29 Feb 2024','202402291601','20240229','400','0.0','400','29 Feb 2024','04:01 pm','202402291601',''),(43,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','04:04 pm','29 Feb 2024','29 Feb 2024','202402291604','20240229','0','400.0','0','29 Feb 2024','04:04 pm','202402291604',''),(44,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','11:58 am','03 Mar 2024','03 Mar 2024','202403031158','20240303','400','0.0','400','03 Mar 2024','11:58 am','202403031158',''),(45,'Shivani Nayak','+191812315','','800.0','0','0','0','0','800.0','03:01 pm','29 Mar 2024','29 Mar 2024','202403291501','20240329','800','0.0','800','29 Mar 2024','03:01 pm','202403291501',''),(46,'Shivani Nayak','+191812315','','120.0','0','0','0','0','120.0','01:28 pm','04 Apr 2024','04 Apr 2024','202404041328','20240404','120','0.0','120','04 Apr 2024','01:28 pm','202404041328',''),(47,'Shivani Nayak','+191812315','','36.0','0','0','0','0','36.0','02:48 pm','18 Apr 2024','18 Apr 2024','202404181448','20240418','36.0','0.0','36.0','18 Apr 2024','02:48 pm','202404181448',''),(48,'Shivani Nayak','+191812315','','360.0','0','0','0','0','360.0','03:41 pm','18 Apr 2024','18 Apr 2024','202404181541','20240418','360.0','0.0','360.0','18 Apr 2024','03:41 pm','202404181541',''),(49,'Shivani Nayak','+191812315','','400.0','0','0','0','0','400.0','04:51 pm','07 May 2024','07 May 2024','202405071651','20240507','400','0.0','400','07 May 2024','04:51 pm','202405071651',''),(50,'Shivani Nayak','+191812315','','1500.0','0','0','0','0','1500.0','05:59 pm','16 May 2024','16 May 2024','202405161759','20240516','15000','-13500.0','15000','16 May 2024','05:59 pm','202405161759',''),(51,'Shivani Nayak','+191812315','','280.0','0','0','0','0','280.0','12:32 pm','17 May 2024','17 May 2024','202405171232','20240517','280','0.0','280','17 May 2024','12:32 pm','202405171232',''),(52,'Shivani Nayak','+191812315','','200.0','0','0','0','0','200.0','07:45 pm','30 May 2024','30 May 2024','202405301945','20240530','200','0.0','200','30 May 2024','07:45 pm','202405301945',''),(53,'Shivani Nayak','+191812315','','320.0','0','0','0','0','320.0','12:12 pm','02 Jun 2024','02 Jun 2024','202406021212','20240602','320','0.0','320','02 Jun 2024','12:12 pm','202406021212',''),(54,'Shivani Nayak','+191812315','','180.0','0','0','0','0','180.0','01:13 pm','10 Jun 2024','10 Jun 2024','202406101313','20240610','180','0.0','180','10 Jun 2024','01:13 pm','202406101313',''),(55,'Shivani Nayak','+191812315','','200.0','0','0','0','0','200.0','01:09 pm','11 Jun 2024','11 Jun 2024','202406111309','20240611','2000','-1800.0','2000','11 Jun 2024','01:09 pm','202406111309',''),(56,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','05:35 pm','13 Jun 2024','13 Jun 2024','202406131735','20240613','1000','0.0','1000','13 Jun 2024','05:35 pm','202406131735',''),(57,'Shivani Nayak','+191812315','','200.0','0','0','0','0','200.0','05:45 pm','16 Jul 2024','16 Jul 2024','202407161745','20240716','200','0.0','200','16 Jul 2024','05:45 pm','202407161745',''),(58,'Shivani Nayak','+191812315','','360.0','0','0','0','0','360.0','07:19 pm','17 Jul 2024','17 Jul 2024','202407171919','20240717','360.0','0.0','360.0','17 Jul 2024','07:19 pm','202407171919',''),(59,'Shivani Nayak','+191812315','','3000.0','0','0','0','0','3000.0','05:19 PM','08 May 2023','08 May 2023','202305081719','20230508','3000','0.0','3000.0','17 Jul 2024','07:23 pm','202407171923',''),(60,'Shivani Nayak','+191812315','','500.0','0','0','0','0','500.0','08:10 pm','16 Aug 2024','16 Aug 2024','202408162010','20240816','500','0.0','500','16 Aug 2024','08:10 pm','202408162010',''),(61,'Shivani Nayak','+191812315','','1000.0','0','0','0','0','1000.0','06:28 pm','22 Aug 2024','22 Aug 2024','202408221828','20240822','1000','0.0','1000','22 Aug 2024','06:28 pm','202408221828',''),(62,'Shivani Nayak','+191812315','','375.0','0','0','0','0','375.0','06:20 pm','12 Dec 2024','12 Dec 2024','202412121820','20241212','375','0.0','375','12 Dec 2024','06:20 pm','202412121820','');
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,'Shivani Nayak','+191812315','pizza','50','50','2500.0','','2500.0','0','0','0','0','2500.0','01:25 PM','11 Apr 2023','11 Apr 2023','202304111325','20230411','','2500.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,'Shivani Nayak','+191812315','pizza','50','50','2500.0','','2500.0','0','0','0','0','2500.0','01:25 PM','11 Apr 2023','11 Apr 2023','202304111325','20230411','','2500.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,'Shivani Nayak','+191812315','ash','50','60','3000.0','','3000.0','0','0','0','0','3000.0','05:19 PM','08 May 2023','08 May 2023','202305081719','20230508','','3000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Shivani Nayak','+191812315','asdg','50','20','1000.0','','1000.0','0','0','0','0','1000.0','06:33 PM','16 May 2023','16 May 2023','202305161833','20230516','','1000.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,'Shivani Nayak','+191812315','hfhjcfv','50','50','2500.0','','2500.0','0','0','0','0','2500.0','02:07 PM','19 May 2023','19 May 2023','202305191407','20230519','','2500.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,'Shivani Nayak','+191812315','idly','50','10','500.0','','500.0','0','0','0','0','500.0','12:17 PM','01 Jun 2023','01 Jun 2023','202306011217','20230601','','500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Shivani Nayak','+191812315','pongal','50','50','2500.0','','2500.0','0','0','0','0','2500.0','03:05 PM','01 Jun 2023','01 Jun 2023','202306011505','20230601','','2500.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,'Shivani Nayak','+191812315','dosa','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:36 PM','02 Jun 2023','02 Jun 2023','202306021536','20230602','','5000.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,'Shivani Nayak','+191812315','hfhjcfv','100','50','5000.0','','5000.0','0','0','0','0','5000.0','11:16 AM','07 Jun 2023','07 Jun 2023','202306071116','20230607','','5000.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,'Shivani Nayak','+191812315','ddgg','50','20','1000.0','','1000.0','0','0','0','0','1000.0','11:17 AM','07 Jun 2023','07 Jun 2023','202306071117','20230607','','1000.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,'Shivani Nayak','+191812315','chty','30','100','3000.0','','3000.0','0','0','0','0','3000.0','01:34 PM','21 Jun 2023','21 Jun 2023','202306211334','20230621','3000.0','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),(12,'Shivani Nayak','+191812315','corn pizza ','50','150','7500.0','','7500.0','0','0','0','0','7500.0','02:17 PM','23 Jun 2023','23 Jun 2023','202306231417','20230623','','7500.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,'Shivani Nayak','+191812315','poori','50','50','2500.0','','2500.0','0','0','0','0','2500.0','03:12 PM','06 Jul 2023','06 Jul 2023','202307061512','20230706','2500','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),(14,'Shivani Nayak','+191812315','rice shake ','1','50','50.0','','50.0','0','0','0','0','50.0','03:16 PM','06 Jul 2023','06 Jul 2023','202307061516','20230706','','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),(15,'Shivani Nayak','+191812315','rice shake ','50','500','25000.0','','25000.0','0','0','0','0','25000.0','04:41 PM','10 Jul 2023','10 Jul 2023','202307101641','20230710','25000','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),(16,'Shivani Nayak','+191812315','coffee idle ','50','20','1000.0','','1000.0','0','0','0','0','1000.0','03:52 PM','25 Jul 2023','25 Jul 2023','202307251552','20230725','','1000.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,'Shivani Nayak','+191812315','idly','20','10','200.0','','1200.0','0','0','0','0','1200.0','04:07 PM','25 Jul 2023','25 Jul 2023','202307251607','20230725','1200','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),(18,'Shivani Nayak','+191812315','pongal','20','50','1000.0','','1200.0','0','0','0','0','1200.0','04:07 PM','25 Jul 2023','25 Jul 2023','202307251607','20230725','1200','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),(19,'Shivani Nayak','+191812315','asdfg','20','10','200.0','','200.0','0','0','0','0','200.0','04:11 PM','25 Jul 2023','25 Jul 2023','202307251611','20230725','','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Shivani Nayak','+191812315','chicken chip rice','50','100','5000.0','','5000.0','0','0','0','0','5000.0','03:46 PM','05 Aug 2023','05 Aug 2023','202308051546','20230805','5000','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),(21,'Shivani Nayak','+191812315','steak ','50','100','5000.0','','5000.0','0','0','0','0','5000.0','12:35 PM','16 Aug 2023','16 Aug 2023','202308161235','20230816','5000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'Shivani Nayak','+191812315','masal dosa','50','30','1500.0','','1500.0','0','0','0','0','1500.0','03:30 PM','17 Aug 2023','17 Aug 2023','202308171530','20230817','1500','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),(23,'Shivani Nayak','+191812315','briyani ','50','300','15000.0','','15000.0','0','0','0','0','15000.0','03:59 PM','18 Aug 2023','18 Aug 2023','202308181559','20230818','15000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Shivani Nayak','+191812315','upma','50','50','2500.0','','2500.0','0','0','0','0','2500.0','06:31 PM','22 Aug 2023','22 Aug 2023','202308221831','20230822','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Shivani Nayak','+191812315','poori','50','50','2500.0','','2500.0','0','0','0','0','2500.0','02:03 pm','31 Aug 2023','31 Aug 2023','202308311403','20230831','','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Shivani Nayak','+191812315','chicken momo','50','100','5000.0','','5000.0','0','0','0','0','5000.0','01:37 pm','01 Sep 2023','01 Sep 2023','202309011337','20230901','5000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'Shivani Nayak','+191812315','wings 3','50','50','2500.0','','2500.0','0','0','0','0','2500.0','02:48 pm','13 Sept 2023','13 Sept 2023','202309131448','20230913','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'Shivani Nayak','+191812315','jokbvg','50','50','2500.0','','2500.0','0','0','0','0','2500.0','03:42 pm','26 Sept 2023','26 Sept 2023','202309261542','20230926','2500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'Shivani Nayak','+191812315','water','50','17','850.0','','850.0','0','0','0','0','850.0','02:49 pm','09 Oct 2023','09 Oct 2023','202310091449','20231009','850','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Shivani Nayak','+191812315','water','50','17','850.0','','850.0','0','0','0','0','850.0','02:49 pm','09 Oct 2023','09 Oct 2023','202310091449','20231009','850','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Shivani Nayak','+191812315','Dosa ','20','10','200.0','','200.0','0','0','0','0','200.0','03:14 pm','18 Oct 2023','18 Oct 2023','202310181514','20231018','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'Shivani Nayak','+191812315','gigui','20','45','900.0','','900.0','0','0','0','0','900.0','02:53 pm','28 Oct 2023','28 Oct 2023','202310281453','20231028','900','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),(33,'Shivani Nayak','+191812315','dosa','20','50','1000.0','','1000.0','0','0','0','0','1000.0','06:26 pm','21 Nov 2023','21 Nov 2023','202311211826','20231121','1000','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),(34,'Shivani Nayak','+191812315','onion dosa','20','18','360.0','','360.0','0','0','0','0','360.0','04:00 pm','04 Dec 2023','04 Dec 2023','202312041600','20231204','360','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),(35,'Shivani Nayak','+191812315','rava dosa','50','50','2500.0','','2500.0','0','0','0','0','2500.0','12:16 pm','05 Dec 2023','05 Dec 2023','202312051216','20231205','2500','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),(36,'Shivani Nayak','+191812315','masal dosa','20','30','600.0','','600.0','0','0','0','0','600.0','02:56 pm','08 Dec 2023','08 Dec 2023','202312081456','20231208','600','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'Shivani Nayak','+191812315','dosa','50','50','2500.0','','2500.0','0','0','0','0','2500.0','08:04 pm','02 Jan 2024','02 Jan 2024','202401022004','20240102','','2500.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),(38,'Shivani Nayak','+191812315','onion dosa','15','20','300.0','','300.0','0','0','0','0','300.0','07:51 pm','08 Jan 2024','08 Jan 2024','202401081951','20240108','','300.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'Shivani Nayak','+191812315','tea','20','20','400.0','','400.0','0','0','0','0','400.0','02:25 pm','03 Feb 2024','03 Feb 2024','202402031425','20240203','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'Shivani Nayak','+191812315','fish fry ','20','150','3000.0','','3000.0','0','0','0','0','3000.0','06:21 pm','03 Feb 2024','03 Feb 2024','202402031821','20240203','3000','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Shivani Nayak','+191812315','water bottle ','10','26','260.0','','260.0','0','0','0','0','260.0','08:15 pm','26 Feb 2024','26 Feb 2024','202402262015','20240226','260','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),(42,'Shivani Nayak','+191812315','coffee ','20','20','400.0','','400.0','0','0','0','0','400.0','08:42 am','29 Feb 2024','29 Feb 2024','202402290842','20240229','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Shivani Nayak','+191812315','c coffee ','20','20','400.0','','400.0','0','0','0','0','400.0','04:01 pm','29 Feb 2024','29 Feb 2024','202402291601','20240229','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Shivani Nayak','+191812315','qwryhf 500grms','20','20','400.0','','400.0','0','0','0','0','400.0','04:04 pm','29 Feb 2024','29 Feb 2024','202402291604','20240229','','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),(45,'Shivani Nayak','+191812315','asdf','20','20','400.0','','400.0','0','0','0','0','400.0','11:58 am','03 Mar 2024','03 Mar 2024','202403031158','20240303','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'Shivani Nayak','+191812315','onion dosa','50','16','800.0','','800.0','0','0','0','0','800.0','03:01 pm','29 Mar 2024','29 Mar 2024','202403291501','20240329','800','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),(47,'Shivani Nayak','+191812315','ice cream ','20','6','120.0','','120.0','0','0','0','0','120.0','01:28 pm','04 Apr 2024','04 Apr 2024','202404041328','20240404','120','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),(48,'Shivani Nayak','+191812315','water 2','2','18','36.0','','36.0','0','0','0','0','36.0','02:48 pm','18 Apr 2024','18 Apr 2024','202404181448','20240418','36.0','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),(49,'Shivani Nayak','+191812315','water 2','20','18','360.0','','360.0','0','0','0','0','360.0','03:41 pm','18 Apr 2024','18 Apr 2024','202404181541','20240418','360.0','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),(50,'Shivani Nayak','+191812315','water ','20','20','400.0','','400.0','0','0','0','0','400.0','04:51 pm','07 May 2024','07 May 2024','202405071651','20240507','400','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Shivani Nayak','+191812315','dosa','30','50','1500.0','','1500.0','0','0','0','0','1500.0','05:59 pm','16 May 2024','16 May 2024','202405161759','20240516','15000','-13500.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),(52,'Shivani Nayak','+191812315','Dosa ','28','10','280.0','','280.0','0','0','0','0','280.0','12:32 pm','17 May 2024','17 May 2024','202405171232','20240517','280','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),(53,'Shivani Nayak','+191812315','poori','20','10','200.0','','200.0','0','0','0','0','200.0','07:45 pm','30 May 2024','30 May 2024','202405301945','20240530','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'Shivani Nayak','+191812315','orange candy','20','16','320.0','','320.0','0','0','0','0','320.0','12:12 pm','02 Jun 2024','02 Jun 2024','202406021212','20240602','320','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),(55,'Shivani Nayak','+191812315','qwert1','20','9','180.0','','180.0','0','0','0','0','180.0','01:13 pm','10 Jun 2024','10 Jun 2024','202406101313','20240610','180','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),(56,'Shivani Nayak','+191812315','poori','20','10','200.0','','200.0','0','0','0','0','200.0','01:09 pm','11 Jun 2024','11 Jun 2024','202406111309','20240611','2000','-1800.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),(57,'Shivani Nayak','+191812315','rava dosa','20','50','1000.0','','1000.0','0','0','0','0','1000.0','05:35 pm','13 Jun 2024','13 Jun 2024','202406131735','20240613','1000','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),(58,'Shivani Nayak','+191812315','idly','20','10','200.0','','200.0','0','0','0','0','200.0','05:45 pm','16 Jul 2024','16 Jul 2024','202407161745','20240716','200','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'Shivani Nayak','+191812315','water ','20','18','360.0','','360.0','0','0','0','0','360.0','07:19 pm','17 Jul 2024','17 Jul 2024','202407171919','20240717','360.0','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),(60,'Shivani Nayak','+191812315','tyuoo','20','25','500.0','','500.0','0','0','0','0','500.0','08:10 pm','16 Aug 2024','16 Aug 2024','202408162010','20240816','500','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Shivani Nayak','+191812315','dosa','20','50','1000.0','','1000.0','0','0','0','0','1000.0','06:28 pm','22 Aug 2024','22 Aug 2024','202408221828','20240822','1000','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),(62,'Shivani Nayak','+191812315','idly','25','15','375.0','','375.0','0','0','0','0','375.0','06:20 pm','12 Dec 2024','12 Dec 2024','202412121820','20241212','375','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,'Shivani Nayak','+191812315','','','','0.0','0.0','0.0','0'),(2,'Shivani Nayak','+191812315','','','','2500.0','0.0','2500.0','1'),(3,'Shivani Nayak','+191812315','','','','6500.0','0.0','6500.0','3'),(4,'Shivani Nayak','+191812315','','','','6500.0','0.0','6500.0','3'),(5,'Shivani Nayak','+191812315','','','','6500.0','0.0','6500.0','3'),(6,'Shivani Nayak','+191812315','','','','12000.0','0.0','12000.0','6'),(8,'Shivani Nayak','+191812315','','','','23000.0','0.0','23000.0','9'),(9,'Shivani Nayak','+191812315','','','','26000.0','3000.0','23000.0','10'),(10,'Shivani Nayak','+191812315','','','','33500.0','3000.0','30500.0','11'),(11,'Shivani Nayak','+191812315','','','','36000.0','13000.0','23000.0','12'),(12,'Shivani Nayak','+191812315','','','','61050.0','38000.0','23050.0','14'),(13,'Shivani Nayak','+191812315','','','','62050.0','38000.0','24050.0','15'),(14,'Shivani Nayak','+191812315','','','','62050.0','38000.0','24050.0','15'),(15,'Shivani Nayak','+191812315','','','','63250.0','39200.0','24050.0','16'),(16,'Shivani Nayak','+191812315','','','','68450.0','44200.0','24250.0','18'),(17,'Shivani Nayak','+191812315','','','','73450.0','49200.0','24250.0','19'),(18,'Shivani Nayak','+191812315','','','','74950.0','50700.0','24250.0','20'),(19,'Shivani Nayak','+191812315','','','','89950.0','65700.0','24250.0','21'),(20,'Shivani Nayak','+191812315','','','','89950.0','65700.0','24250.0','21'),(21,'Shivani Nayak','+191812315','','','','92450.0','68200.0','24250.0','22'),(22,'Shivani Nayak','+191812315','','','','92450.0','68200.0','24250.0','22'),(23,'Shivani Nayak','+191812315','','','','94950.0','68200.0','26750.0','23'),(24,'Shivani Nayak','+191812315','','','','94950.0','68200.0','26750.0','23'),(25,'Shivani Nayak','+191812315','','','','99950.0','73200.0','26750.0','24'),(26,'Shivani Nayak','+191812315','','','','102450.0','75700.0','26750.0','25'),(27,'Shivani Nayak','+191812315','','','','104950.0','78200.0','26750.0','26'),(28,'Shivani Nayak','+191812315','','','','105800.0','79050.0','26750.0','27'),(29,'Shivani Nayak','+191812315','','','','105800.0','79050.0','26750.0','27'),(30,'Shivani Nayak','+191812315','','','','106000.0','79250.0','26750.0','28'),(31,'Shivani Nayak','+191812315','','','','106900.0','80150.0','26750.0','29'),(32,'Shivani Nayak','+191812315','','','','107900.0','81150.0','26750.0','30'),(33,'Shivani Nayak','+191812315','','','','108260.0','81510.0','26750.0','31'),(34,'Shivani Nayak','+191812315','','','','108260.0','81510.0','26750.0','31'),(35,'Shivani Nayak','+191812315','','','','110760.0','84010.0','26750.0','32'),(36,'Shivani Nayak','+191812315','','','','110760.0','84010.0','26750.0','32'),(37,'Shivani Nayak','+191812315','','','','111360.0','84610.0','26750.0','33'),(38,'Shivani Nayak','+191812315','','','','113860.0','84610.0','29250.0','34'),(39,'Shivani Nayak','+191812315','','','','114560.0','85010.0','29550.0','36'),(40,'Shivani Nayak','+191812315','','','','117560.0','88010.0','29550.0','37'),(41,'Shivani Nayak','+191812315','','','','117560.0','88010.0','29550.0','37'),(42,'Shivani Nayak','+191812315','','','','117820.0','88270.0','29550.0','38'),(43,'Shivani Nayak','+191812315','','','','117820.0','88270.0','29550.0','38'),(44,'Shivani Nayak','+191812315','','','','117820.0','90770.0','27050.0','38'),(45,'Shivani Nayak','+191812315','','','','118220.0','91170.0','27050.0','39'),(46,'Shivani Nayak','+191812315','','','','118620.0','91570.0','27050.0','40'),(47,'Shivani Nayak','+191812315','','','','119420.0','91970.0','27450.0','42'),(48,'Shivani Nayak','+191812315','','','','120220.0','92770.0','27450.0','43'),(49,'Shivani Nayak','+191812315','','','','120340.0','92890.0','27450.0','44'),(50,'Shivani Nayak','+191812315','','','','120376.0','92926.0','27450.0','45'),(51,'Shivani Nayak','+191812315','','','','120736.0','93286.0','27450.0','46'),(52,'Shivani Nayak','+191812315','','','','122636.0','108686.0','13950.0','48'),(53,'Shivani Nayak','+191812315','','','','123436.0','109486.0','13950.0','51'),(54,'Shivani Nayak','+191812315','','','','123616.0','109666.0','13950.0','52'),(55,'Shivani Nayak','+191812315','','','','125016.0','112866.0','12150.0','55'),(56,'Shivani Nayak','+191812315','','','','125376.0','113226.0','12150.0','56'),(57,'Shivani Nayak','+191812315','','','','125876.0','116726.0','9150.0','57'),(58,'Shivani Nayak','+191812315','','','','126876.0','117726.0','9150.0','58'),(59,'Shivani Nayak','+191812315','','','','127251.0','118101.0','9150.0','59');
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');
