(166,'50 C.M ELE/COL',250.00,45,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','50','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
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`) VALUES (167,'100 C.M ELE/COL',300.00,25,'SPARKLERS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','10','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(168,'10  R/G/Y/B',250.00,0,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','10','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(169,'12 R/G/Y/B',250.00,0,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','12','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,'30 R/G/Y/B',250.00,0,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','30','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,'MULTI MIX',200.00,0,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,'60 C.M ELE/COL',250.00,0,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','60','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,'12 CM STD',250.00,159,'SPARKLERS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','12','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(175,'ROLL CAP STD',100.00,20,'CHILDREN ITEMS','','[BLOB]','0','0','','','','no','%','0','RO','','','',0,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(176,'ROLL CAP',80.00,100,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(177,'RED BIJILI 50 PICES',10.00,-1,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','RE','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(178,'RED BIJILI 100 PICES',20.00,292,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','RE','',NULL,NULL,10,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,'POP POP',10.00,569,'CHILDREN ITEMS','','[BLOB]','0','0','','','','no','%','0','PO','','','',480,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,'PULLING THREAD',10.00,2396,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','PU','',NULL,NULL,99,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,'CHORSA',10.00,0,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,'MAGIC WHIP',200.00,0,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,'KIT KAT',40.00,0,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','KI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,'KUNG FU',60.00,-1,'CHILDREN ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','KU','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(185,'RAVAN',60.00,0,'CHILDREN ITEMS','','[BLOB]','0','0','','','','no','%','0','RA','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(186,'TITAN',2500.00,0,'GIFT BOXES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','TI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(187,'NAGAVALLI',2500.00,0,'GIFT BOXES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','NA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,'SILVER GIFT WHEEL',150.00,0,'GIFT BOXES','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(189,'FESTIVAL SEASON',1800.00,0,'GIFT BOXES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','FE','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(190,'DIVALI GIFT',2000.00,0,'GIFT BOXES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','DI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'ALL IS WHELL',200.00,70,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AL','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'TUIRLER',200.00,15,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','TU','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,'CUTE F.P',200.00,2,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CU','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(194,'DEXTER',200.00,35,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','DE','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,'COLOUR MAGIC WIPE',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CO','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,'VEIL MUTS F.P TIM',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','VE','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(197,'ASHRAFI KOTI',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AS','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(198,'COLOUR CHANGINGCHINMUN     13',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CO','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(199,'MAGIC STAR',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(200,'CHANDHINILIGHT',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CH','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(201,'KING CANDLE',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','KI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(202,'GOLD SHOWER',200.00,14,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GO','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,'PEANT DROPS',200.00,4,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','PE','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(204,'TRY COLOUR STD',300.00,54,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','TR','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,'SUPER DELUX',300.00,-1,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'no','%','0','SU','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,'WARRIOR',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','WA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,'PAYAL SATTI',200.00,20,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(209,'KINDER JOY',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','KI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(210,'MAGIC BATTEL',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(211,'HI SONA',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(212,'MERCURY LIGHTS',90.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ME','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(213,'MER CURY FLOWER',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ME','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(214,'MAGIC MATCHES',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(215,'LALI POP MATCHES',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','LA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(216,'RIDER MATCHES BOX',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','RI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(218,'MILANO',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(219,'AIR GUN',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(220,'OLA',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','OL','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(221,'STAR BUTS',200.00,10,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ST','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(222,'PEACOCKO SMALL',200.00,0,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','PE','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(223,'PEACOCKO BIG',450.00,0,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','PE','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(224,'CRACUING KING',350.00,10,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','CR','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(225,'TIN F.P',200.00,-1,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','TI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(226,'GOLDEN WHISLE',250.00,17,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','GO','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(227,'4K POT',280.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','4K','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,'HAPPINESS',280.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(229,'SELFI STICKE',280.00,31,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','SE','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(230,'STD F.P GAINT',450.00,9,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ST','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(231,'METOR',350.00,14,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ME','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(232,'RAILWAY SIGNAL',300.00,20,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','RA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(233,'JADE FLOWER',450.00,11,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','JA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(234,'HATRIUS F.P',280.00,27,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(235,'CHIT PUT BIG',150.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CH','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(236,'SARPAINT BIGG',50.00,10,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(237,'SARPANT SMALL',40.00,729,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,'5 IN ONE',250.00,10,'MATHCHES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','5 ','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,'KING MACHTES',250.00,1,'MATHCHES','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','KI','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(241,'25 SHOTS STD',600.00,13,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','25','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(242,'5 COMMETS',450.00,0,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','5 ','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(243,'SMOKE 2 PIC',150.00,-3,'SMOKE ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','SM','',NULL,NULL,3,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(260,'PARADIESE 250 SHOT',4500.00,2,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(261,'120 SHOT STD',2100.00,0,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','12','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(262,'7 SHOT',150.00,0,'SHOTS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','7 ','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(263,'72 SHOT ABHI',1500.00,-6,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','72','',NULL,NULL,6,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,'36 SHOT ABHI',750.00,34,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','36','',NULL,NULL,74,'0','0','0','','','','Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,'COLOUR CHANGING BUTTER FLY',350.00,0,'FANCY ITEMS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CO','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,'21 PAPERSHOT',1800.00,9,'SHOTS','','',NULL,NULL,NULL,NULL,NULL,'no','%','0','21','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(267,'VIP',250.00,313,'ATOM BOMBS','','','0',NULL,NULL,NULL,NULL,'no','%','0','VI','',NULL,NULL,39,'0','0','0','','','','Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(268,'ANDI THOOFAN',200.00,39,'ATOM BOMBS','','','0',NULL,NULL,NULL,NULL,'no','%','0','AN','',NULL,NULL,35,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(270,'GC DLX STD',250.00,16,'GROUND CHAKKARS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GC','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(271,'paper confetti',150.00,10,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(272,'3 .5 COMMENT',350.00,0,'None','','','0','0',NULL,NULL,NULL,'yes','%','0','3 ','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(273,'RSR 40 SHOT',7000.00,0,'None','','','0','0',NULL,NULL,NULL,'no','%','0','RS','',NULL,NULL,4,'0','0','0','Low','','','Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(275,'SMOKE FUSE',150.00,33,'SMOKE ITEMS','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SM','',NULL,NULL,0,'0','0','0','','','','Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(276,'6 PAPER SHOT',400.00,-1,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','6 ','',NULL,NULL,1,'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),(277,'xyz',1000.00,0,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','XY','',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),(278,'IPL shots',3800.00,0,'SHOTS','None','','0','0',NULL,NULL,NULL,'no','%','0','IP','',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),(279,'10 x 10',3300.00,0,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','10','',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),(280,'SET OUTS',3500.00,0,'IPL MEGHA SHOTS','None','','0','0',NULL,NULL,NULL,'no','%','0','SE','',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,'RSR 40 SHOT','6800.0','6800.0','6800.0','2.0','13600.0','',''),(2,'15 SHOTS','350.0','350.0','350.0','30.0','10500.0','',''),(3,'30 SHOTS','600.0','600.0','600.0','48.0','28800.0','',''),(4,'60 SHOTS','1150.0','1150.0','1150.0','24.0','27600.0','',''),(5,'100 SHOTS','1800.0','1800.0','1800.0','18.0','32400.0','',''),(6,'200 SHOTS','1800.0','1800.0','1800.0','24.0','43200.0','',''),(7,'500 SHOTS','6500.0','6500.0','6500.0','4.0','26000.0','',''),(8,'3 COMMET','275.0','275.0','275.0','35.0','9625.0','',''),(9,'4 COMMET','300.0','300.0','300.0','30.0','9000.0','',''),(10,'COLD FIRE C       180','150.0','150.0','150.0','180.0','27000.0','',''),(11,'36 SHOT ABHI','600.0','600.0','600.0','108.0','64800.0','',''),(12,'VIP','200.0','200.0','200.0','80.0','16000.0','',''),(13,'RSR 40 SHOT','6800.0','6800.0','6800.0','2.0','13600.0','',''),(14,'SMOKE FUSE','250.0','250.0','250.0','30.0','7500.0','',''),(15,'COLOUR KOTI/GAINT','250.0','250.0','250.0','300.0','75000.0','',''),(16,'RED BIJILI 100 PICES','40.0','40.0','40.0','30.0','1200.0','',''),(17,'RSR 40 SHOT','6800.0','6800.0','6800.0','4.0','27200.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 (4,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
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 `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','no','no','no','no','no','no','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'KARMANGHAT ','8008594408','','','');
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,'KARMANGHAT ','8008594408','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','0','164600.0','0','12 Mar 2023','08:30 pm','202303122030',''),(2,'KARMANGHAT ','8008594408','','45000.0','0','0','0','0','45000.0','07:20 pm','04 Apr 2023','04 Apr 2023','202304041920','20230404','0','45000.0','0','04 Apr 2023','07:20 pm','202304041920',''),(3,'KARMANGHAT ','8008594408','','10000.0','0','0','0','0','10000.0','07:22 pm','04 Apr 2023','04 Apr 2023','202304041922','20230404','0','10000.0','0','04 Apr 2023','07:22 pm','202304041922',''),(4,'KARMANGHAT ','8008594408','','9600.0','0','0','0','0','9600.0','07:23 pm','04 Apr 2023','04 Apr 2023','202304041923','20230404','0','9600.0','0','04 Apr 2023','07:23 pm','202304041923',''),(5,'KARMANGHAT ','8008594408','','8400.0','0','0','0','0','8400.0','07:24 pm','04 Apr 2023','04 Apr 2023','202304041924','20230404','0','8400.0','0','04 Apr 2023','07:24 pm','202304041924',''),(6,'KARMANGHAT ','8008594408','','5760.0','0','0','0','0','5760.0','07:25 pm','04 Apr 2023','04 Apr 2023','202304041925','20230404','0','5760.0','0','04 Apr 2023','07:25 pm','202304041925',''),(7,'KARMANGHAT ','8008594408','','21600.0','0','0','0','0','21600.0','04:44 PM','14 Apr 2023','14 Apr 2023','202304141644','20230414','0','21600.0','0','14 Apr 2023','04:44 PM','202304141644',''),(8,'KARMANGHAT ','8008594408','','43200.0','0','0','0','0','43200.0','04:46 PM','14 Apr 2023','14 Apr 2023','202304141646','20230414','0','43200.0','0','14 Apr 2023','04:46 PM','202304141646',''),(9,'KARMANGHAT ','8008594408','','43200.0','0','0','0','0','43200.0','04:47 PM','14 Apr 2023','14 Apr 2023','202304141647','20230414','0','43200.0','0','14 Apr 2023','04:47 PM','202304141647',''),(10,'KARMANGHAT ','8008594408','','9900.0','0','0','0','0','9900.0','04:48 PM','14 Apr 2023','14 Apr 2023','202304141648','20230414','0','9900.0','0','14 Apr 2023','04:48 PM','202304141648',''),(11,'KARMANGHAT ','8008594408','','28800.0','0','0','0','0','28800.0','04:53 PM','14 Apr 2023','14 Apr 2023','202304141653','20230414','0','28800.0','0','14 Apr 2023','04:53 PM','202304141653',''),(12,'KARMANGHAT ','8008594408','','1200.0','0','0','0','0','1200.0','04:54 PM','14 Apr 2023','14 Apr 2023','202304141654','20230414','0','1200.0','0','14 Apr 2023','04:54 PM','202304141654',''),(13,'KARMANGHAT ','8008594408','','39000.0','0','0','0','0','39000.0','04:54 PM','14 Apr 2023','14 Apr 2023','202304141654','20230414','0','39000.0','0','14 Apr 2023','04:54 PM','202304141654',''),(14,'KARMANGHAT ','8008594408','','27200.0','0','0','0','0','27200.0','04:55 PM','14 Apr 2023','14 Apr 2023','202304141655','20230414','0','27200.0','0','14 Apr 2023','04:55 PM','202304141655',''),(15,'KARMANGHAT ','8008594408','','30000.0','0','0','0','0','30000.0','05:18 PM','14 Apr 2023','14 Apr 2023','202304141718','20230414','0','30000.0','0','14 Apr 2023','05:18 PM','202304141718',''),(16,'KARMANGHAT ','8008594408','','20000.0','0','0','0','0','20000.0','05:18 PM','14 Apr 2023','14 Apr 2023','202304141718','20230414','0','20000.0','0','14 Apr 2023','05:18 PM','202304141718',''),(17,'KARMANGHAT ','8008594408','','68800.0','0','0','0','0','68800.0','05:19 PM','14 Apr 2023','14 Apr 2023','202304141719','20230414','0','68800.0','0','14 Apr 2023','05:19 PM','202304141719',''),(18,'KARMANGHAT ','8008594408','','30000.0','0','0','0','0','30000.0','05:19 PM','14 Apr 2023','14 Apr 2023','202304141719','20230414','0','30000.0','0','14 Apr 2023','05:19 PM','202304141719',''),(19,'KARMANGHAT ','8008594408','','32400.0','0','0','0','0','32400.0','05:20 PM','14 Apr 2023','14 Apr 2023','202304141720','20230414','0','32400.0','0','14 Apr 2023','05:20 PM','202304141720',''),(20,'KARMANGHAT ','8008594408','','51750.0','0','0','0','0','51750.0','05:20 PM','14 Apr 2023','14 Apr 2023','202304141720','20230414','0','51750.0','0','14 Apr 2023','05:20 PM','202304141720',''),(21,'KARMANGHAT ','8008594408','','45000.0','0','0','0','0','45000.0','05:21 PM','14 Apr 2023','14 Apr 2023','202304141721','20230414','0','45000.0','0','14 Apr 2023','05:21 PM','202304141721',''),(22,'KARMANGHAT ','8008594408','','15000.0','0','0','0','0','15000.0','07:18 PM','24 Apr 2023','29 Apr 2023','202304241918','20230429','0','15000.0','0','24 Apr 2023','07:18 PM','202304241918',''),(23,'KARMANGHAT ','8008594408','','13600.0','0','0','0','0','13600.0','07:20 PM','30 Apr 2023','29 Apr 2023','202304301920','20230429','0','13600.0','0','30 Apr 2023','07:20 PM','202304301920',''),(24,'KARMANGHAT ','8008594408','','64800.0','0','0','0','0','64800.0','07:21 PM','24 Apr 2023','29 Apr 2023','202304241921','20230429','0','64800.0','0','24 Apr 2023','07:21 PM','202304241921',''),(25,'KARMANGHAT ','8008594408','','28800.0','0','0','0','0','28800.0','07:22 PM','24 Apr 2023','29 Apr 2023','202304241922','20230429','0','28800.0','0','24 Apr 2023','07:22 PM','202304241922',''),(26,'KARMANGHAT ','8008594408','','27600.0','0','0','0','0','27600.0','07:24 PM','24 Apr 2023','29 Apr 2023','202304241924','20230429','0','27600.0','0','24 Apr 2023','07:24 PM','202304241924',''),(27,'KARMANGHAT ','8008594408','','10500.0','0','0','0','0','10500.0','07:25 PM','24 Apr 2023','29 Apr 2023','202304241925','20230429','0','10500.0','0','24 Apr 2023','07:25 PM','202304241925',''),(28,'KARMANGHAT ','8008594408','','9625.0','0','0','0','0','9625.0','07:26 PM','24 Apr 2023','29 Apr 2023','202304241926','20230429','0','9625.0','0','24 Apr 2023','07:26 PM','202304241926',''),(29,'KARMANGHAT ','8008594408','','9000.0','0','0','0','0','9000.0','07:26 PM','24 Apr 2023','29 Apr 2023','202304241926','20230429','0','9000.0','0','24 Apr 2023','07:26 PM','202304241926',''),(30,'KARMANGHAT ','8008594408','','32400.0','0','0','0','0','32400.0','07:27 PM','29 Apr 2023','29 Apr 2023','202304291927','20230429','0','32400.0','0','29 Apr 2023','07:27 PM','202304291927',''),(31,'KARMANGHAT ','8008594408','','16000.0','0','0','0','0','16000.0','07:27 PM','24 Apr 2023','29 Apr 2023','202304241927','20230429','0','16000.0','0','24 Apr 2023','07:27 PM','202304241927',''),(32,'KARMANGHAT ','8008594408','','43200.0','0','0','0','0','43200.0','07:28 PM','24 Apr 2023','29 Apr 2023','202304241928','20230429','0','43200.0','0','24 Apr 2023','07:28 PM','202304241928',''),(33,'KARMANGHAT ','8008594408','','26000.0','0','0','0','0','26000.0','07:28 PM','24 Apr 2023','29 Apr 2023','202304241928','20230429','0','26000.0','0','24 Apr 2023','07:28 PM','202304241928',''),(34,'KARMANGHAT ','8008594408','','7500.0','0','0','0','0','7500.0','08:20 PM','29 Apr 2023','29 Apr 2023','202304292020','20230429','0','7500.0','0','29 Apr 2023','08:20 PM','202304292020',''),(35,'KARMANGHAT ','8008594408','','27000','0','0','0','0','27000','08:09 AM','08 May 2023','08 May 2023','202305080809','20230508','0','27000.0','0','08 May 2023','08:09 AM','202305080809',NULL);
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,'KARMANGHAT ','8008594408','1000 WALA','120','250','30000.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','2000 WALA','40','500','20000.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','5000 WALA','32','600','19200.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','30 SHOTS','36','400','14400.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','60 SHOTS','45','800','36000.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','120 SHOTS','30','1500','45000.0','','164600.0','0','0','0','0','164600.0','08:30 pm','12 Mar 2023','03 Apr 2023','202303122030','20230403','','164600.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,'KARMANGHAT ','8008594408','COLOUR KOTI/GAINT','180','250','45000.0','','45000.0','0','0','0','0','45000.0','07:20 pm','04 Apr 2023','04 Apr 2023','202304041920','20230404','','45000.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,'KARMANGHAT ','8008594408','COLD FIRE  B      250','50','200','10000.0','','10000.0','0','0','0','0','10000.0','07:22 pm','04 Apr 2023','04 Apr 2023','202304041922','20230404','','10000.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,'KARMANGHAT ','8008594408','COLD FIRE C       180','60','160','9600.0','','9600.0','0','0','0','0','9600.0','07:23 pm','04 Apr 2023','04 Apr 2023','202304041923','20230404','','9600.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,'KARMANGHAT ','8008594408','15 SHOTS','24','350','8400.0','','8400.0','0','0','0','0','8400.0','07:24 pm','04 Apr 2023','04 Apr 2023','202304041924','20230404','','8400.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,'KARMANGHAT ','8008594408','COLD FIRE C       180','36','160','5760.0','','5760.0','0','0','0','0','5760.0','07:25 pm','04 Apr 2023','04 Apr 2023','202304041925','20230404','','5760.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,'KARMANGHAT ','8008594408','200 SHOTS','12','1800','21600.0','','21600.0','0','0','0','0','21600.0','04:44 PM','14 Apr 2023','14 Apr 2023','202304141644','20230414','','21600.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,'KARMANGHAT ','8008594408','100 SHOTS','24','1800','43200.0','','43200.0','0','0','0','0','43200.0','04:46 PM','14 Apr 2023','14 Apr 2023','202304141646','20230414','','43200.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,'KARMANGHAT ','8008594408','240 SHOTS','12','3600','43200.0','','43200.0','0','0','0','0','43200.0','04:47 PM','14 Apr 2023','14 Apr 2023','202304141647','20230414','','43200.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,'KARMANGHAT ','8008594408','3 COMMET','36','275','9900.0','','9900.0','0','0','0','0','9900.0','04:48 PM','14 Apr 2023','14 Apr 2023','202304141648','20230414','','9900.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,'KARMANGHAT ','8008594408','200 SHOTS','16','1800','28800.0','','28800.0','0','0','0','0','28800.0','04:53 PM','14 Apr 2023','14 Apr 2023','202304141653','20230414','','28800.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,'KARMANGHAT ','8008594408','RED BIJILI 100 PICES','30','40','1200.0','','1200.0','0','0','0','0','1200.0','04:54 PM','14 Apr 2023','14 Apr 2023','202304141654','20230414','','1200.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,'KARMANGHAT ','8008594408','500 SHOTS','6','6500','39000.0','','39000.0','0','0','0','0','39000.0','04:54 PM','14 Apr 2023','14 Apr 2023','202304141654','20230414','','39000.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,'KARMANGHAT ','8008594408','RSR 40 SHOT','4','6800','27200.0','','27200.0','0','0','0','0','27200.0','04:55 PM','14 Apr 2023','14 Apr 2023','202304141655','20230414','','27200.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,'KARMANGHAT ','8008594408','1000 WALA','120','250','30000.0','','30000.0','0','0','0','0','30000.0','05:18 PM','14 Apr 2023','14 Apr 2023','202304141718','20230414','','30000.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,'KARMANGHAT ','8008594408','2000 WALA','40','500','20000.0','','20000.0','0','0','0','0','20000.0','05:18 PM','14 Apr 2023','14 Apr 2023','202304141718','20230414','','20000.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,'KARMANGHAT ','8008594408','5000 WALA','32','2150','68800.0','','68800.0','0','0','0','0','68800.0','05:19 PM','14 Apr 2023','14 Apr 2023','202304141719','20230414','','68800.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,'KARMANGHAT ','8008594408','COLOUR KOTI/GAINT','120','250','30000.0','','30000.0','0','0','0','0','30000.0','05:19 PM','14 Apr 2023','14 Apr 2023','202304141719','20230414','','30000.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,'KARMANGHAT ','8008594408','30 SHOTS','54','600','32400.0','','32400.0','0','0','0','0','32400.0','05:20 PM','14 Apr 2023','14 Apr 2023','202304141720','20230414','','32400.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,'KARMANGHAT ','8008594408','60 SHOTS','45','1150','51750.0','','51750.0','0','0','0','0','51750.0','05:20 PM','14 Apr 2023','14 Apr 2023','202304141720','20230414','','51750.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,'KARMANGHAT ','8008594408','120 SHOTS','30','1500','45000.0','','45000.0','0','0','0','0','45000.0','05:21 PM','14 Apr 2023','14 Apr 2023','202304141721','20230414','','45000.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,'KARMANGHAT ','8008594408','SMOKE 5 PICE STD','30','500','15000.0','','15000.0','0','0','0','0','15000.0','07:18 PM','24 Apr 2023','29 Apr 2023','202304241918','20230429','','15000.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,'KARMANGHAT ','8008594408','RSR 40 SHOT','2','6800','13600.0','','13600.0','0','0','0','0','13600.0','07:20 PM','30 Apr 2023','29 Apr 2023','202304301920','20230429','','13600.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,'KARMANGHAT ','8008594408','36 SHOT ABHI','108','600','64800.0','','64800.0','0','0','0','0','64800.0','07:21 PM','24 Apr 2023','29 Apr 2023','202304241921','20230429','','64800.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,'KARMANGHAT ','8008594408','30 SHOTS','48','600','28800.0','','28800.0','0','0','0','0','28800.0','07:22 PM','24 Apr 2023','29 Apr 2023','202304241922','20230429','','28800.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,'KARMANGHAT ','8008594408','60 SHOTS','24','1150','27600.0','','27600.0','0','0','0','0','27600.0','07:24 PM','24 Apr 2023','29 Apr 2023','202304241924','20230429','','27600.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,'KARMANGHAT ','8008594408','15 SHOTS','30','350','10500.0','','10500.0','0','0','0','0','10500.0','07:25 PM','24 Apr 2023','29 Apr 2023','202304241925','20230429','','10500.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,'KARMANGHAT ','8008594408','3 COMMET','35','275','9625.0','','9625.0','0','0','0','0','9625.0','07:26 PM','24 Apr 2023','29 Apr 2023','202304241926','20230429','','9625.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,'KARMANGHAT ','8008594408','4 COMMET','30','300','9000.0','','9000.0','0','0','0','0','9000.0','07:26 PM','24 Apr 2023','29 Apr 2023','202304241926','20230429','','9000.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,'KARMANGHAT ','8008594408','100 SHOTS','18','1800','32400.0','','32400.0','0','0','0','0','32400.0','07:27 PM','29 Apr 2023','29 Apr 2023','202304291927','20230429','','32400.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,'KARMANGHAT ','8008594408','VIP','80','200','16000.0','','16000.0','0','0','0','0','16000.0','07:27 PM','24 Apr 2023','29 Apr 2023','202304241927','20230429','','16000.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,'KARMANGHAT ','8008594408','200 SHOTS','24','1800','43200.0','','43200.0','0','0','0','0','43200.0','07:28 PM','24 Apr 2023','29 Apr 2023','202304241928','20230429','','43200.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,'KARMANGHAT ','8008594408','500 SHOTS','4','6500','26000.0','','26000.0','0','0','0','0','26000.0','07:28 PM','24 Apr 2023','29 Apr 2023','202304241928','20230429','','26000.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,'KARMANGHAT ','8008594408','SMOKE FUSE','30','250','7500.0','','7500.0','0','0','0','0','7500.0','08:20 PM','29 Apr 2023','29 Apr 2023','202304292020','20230429','','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),(40,'KARMANGHAT ','8008594408','COLD FIRE C       180','180','150','27000','','27000','0','0','0','0','27000','08:09 AM','08 May 2023','08 May 2023','202305080809','20230508','0','27000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
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 (9,'KARMANGHAT ','8008594408','','','','594660.0','0.0','594660.0','17');
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');
