INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`) VALUES (807,'20240816-000011','1793.00','admin','2024 08 16','  Cash','  General','1792.64','0.00','+ 0.36','0.0','Shri Guru Traders _807','202408160943',NULL,NULL,NULL,NULL,NULL),(808,'20240816-000012','1032.00','admin','2024 08 16','  Cash','  General','1032.00','0.00','+ 0.00','0.0','Shri Guru Traders _808','202408160946',NULL,NULL,NULL,NULL,NULL),(809,'20240816-000013','150.00','admin','2024 08 16','  Cash','  General','150.00','0.00','+ 0.00','0.0','Shri Guru Traders _809','202408160948',NULL,NULL,NULL,NULL,NULL),(810,'20240816-000014','190.00','admin','2024 08 16','  Cash','  General','190.00','0.00','+ 0.00','0.0','Shri Guru Traders _810','202408160950',NULL,NULL,NULL,NULL,NULL),(811,'20240816-000015','1008.00','admin','2024 08 16','  Cash','  General','1008.00','0.00','+ 0.00','0.0','Shri Guru Traders _811','202408161011',NULL,NULL,NULL,NULL,NULL),(812,'20240816-000016','621.00','admin','2024 08 16','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _812','202408161012',NULL,NULL,NULL,NULL,NULL),(813,'20240816-000017','1224.00','admin','2024 08 16','  Cash','  General','1224.00','0.00','+ 0.00','0.0','Shri Guru Traders _813','202408161043',NULL,NULL,NULL,NULL,NULL),(814,'20240816-000018','621.00','admin','2024 08 16','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _814','202408161044',NULL,NULL,NULL,NULL,NULL),(815,'20240816-000019','621.00','admin','2024 08 16','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _815','202408161045',NULL,NULL,NULL,NULL,NULL),(816,'20240816-0000110','574.00','admin','2024 08 16','  Cash','  General','574.32','0.00','- 0.32','0.0','Shri Guru Traders _816','202408161107',NULL,NULL,NULL,NULL,NULL),(817,'20240816-0000111','310.00','admin','2024 08 16','  Cash','  General','310.32','0.00','- 0.32','0.0','Shri Guru Traders _817','202408161107',NULL,NULL,NULL,NULL,NULL),(818,'20240816-0000112','562.00','admin','2024 08 16','  Cash','  General','562.32','0.00','- 0.32','0.0','Shri Guru Traders _818','202408161114',NULL,NULL,NULL,NULL,NULL),(819,'20240816-0000113','2022.00','admin','2024 08 16','  Cash','  General','2021.76','0.00','+ 0.24','0.0','Shri Guru Traders _819','202408161153',NULL,NULL,NULL,NULL,NULL),(820,'20240816-0000114','621.00','admin','2024 08 16','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _820','202408161153',NULL,NULL,NULL,NULL,NULL),(821,'20240818-000011','460.00','admin','2024 08 18','  Cash','  General','460.32','0.00','- 0.32','0.0','Shri Guru Traders _821','202408181048',NULL,NULL,NULL,NULL,NULL),(822,'20240820-000011','621.00','admin','2024 08 20','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _822','202408200947',NULL,NULL,NULL,NULL,NULL),(823,'20240820-000012','935.00','admin','2024 08 20','  Cash','  General','935.28','0.00','- 0.28','0.0','Shri Guru Traders _823','202408200949',NULL,NULL,NULL,NULL,NULL),(824,'20240820-000013','621.00','admin','2024 08 20','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _824','202408200950',NULL,NULL,NULL,NULL,NULL),(825,'20240820-000014','621.00','admin','2024 08 20','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _825','202408201005',NULL,NULL,NULL,NULL,NULL),(826,'20240821-000011','1241.00','admin','2024 08 21','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _826','202408211047',NULL,NULL,NULL,NULL,NULL),(827,'20240822-000011','829.00','admin','2024 08 22','  Cash','  General','829.44','0.00','- 0.44','0.0','Shri Guru Traders _827','202408221115',NULL,NULL,NULL,NULL,NULL),(828,'20240825-000011','1821.00','admin','2024 08 25','  Cash','  General','1820.64','0.00','+ 0.36','0.0','Shri Guru Traders _828','202408251111',NULL,NULL,NULL,NULL,NULL),(829,'20240826-000011','1241.00','admin','2024 08 26','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _829','202408261029',NULL,NULL,NULL,NULL,NULL),(830,'20240826-000012','792.00','admin','2024 08 26','  Cash','  General','792.00','0.00','+ 0.00','0.0','Shri Guru Traders _830','202408261034',NULL,NULL,NULL,NULL,NULL),(831,'20240826-000013','621.00','admin','2024 08 26','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _831','202408261035',NULL,NULL,NULL,NULL,NULL),(832,'20240829-000011','1241.00','admin','2024 08 29','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _832','202408290958',NULL,NULL,NULL,NULL,NULL),(833,'20240829-000012','771.00','admin','2024 08 29','  Cash','  General','770.64','0.00','+ 0.36','0.0','Shri Guru Traders _833','202408291006',NULL,NULL,NULL,NULL,NULL),(834,'20240829-000013','2033.00','admin','2024 08 29','  Cash','  General','2033.28','0.00','- 0.28','0.0','Shri Guru Traders _834','202408291011',NULL,NULL,NULL,NULL,NULL),(835,'20240829-000014','1584.00','admin','2024 08 29','  Cash','  General','1584.00','0.00','+ 0.00','0.0','Shri Guru Traders _835','202408291014',NULL,NULL,NULL,NULL,NULL),(836,'20240829-000015','450.00','admin','2024 08 29','  Cash','  General','450.00','0.00','+ 0.00','0.0','Shri Guru Traders _836','202408291016',NULL,NULL,NULL,NULL,NULL),(837,'20240829-000016','570.00','admin','2024 08 29','  Cash','  General','570.00','0.00','+ 0.00','0.0','Shri Guru Traders _837','202408291018',NULL,NULL,NULL,NULL,NULL),(838,'20240829-000017','621.00','admin','2024 08 29','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _838','202408291019',NULL,NULL,NULL,NULL,NULL),(839,'20240829-000018','3429.00','admin','2024 08 29','  Cash','  General','3428.64','0.00','+ 0.36','0.0','Shri Guru Traders _839','202408291046',NULL,NULL,NULL,NULL,NULL),(840,'20240829-000019','1152.00','admin','2024 08 29','  Cash','  General','1151.76','0.00','+ 0.24','0.0','Shri Guru Traders _840','202408291056',NULL,NULL,NULL,NULL,NULL),(841,'20240829-0000110','517.00','admin','2024 08 29','  Cash','  General','517.20','0.00','- 0.20','0.0','Shri Guru Traders _841','202408291058',NULL,NULL,NULL,NULL,NULL),(842,'20240829-0000111','1215.00','admin','2024 08 29','  Cash','  General','1215.00','0.00','+ 0.00','0.0','Shri Guru Traders _842','202408291232',NULL,NULL,NULL,NULL,NULL),(843,'20240829-0000112','1193.00','admin','2024 08 29','  Cash','  General','1192.64','0.00','+ 0.36','0.0','Shri Guru Traders _843','202408291246',NULL,NULL,NULL,NULL,NULL),(844,'20240830-000011','621.00','admin','2024 08 30','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _844','202408301006',NULL,NULL,NULL,NULL,NULL),(845,'20240831-000011','621.00','admin','2024 08 31','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _845','202408311004',NULL,NULL,NULL,NULL,NULL),(846,'20240831-000012','1800.00','admin','2024 08 31','  Cash','  General','1800.00','0.00','+ 0.00','0.0','Shri Guru Traders _846','202408311022',NULL,NULL,NULL,NULL,NULL),(847,'20240902-000011','2700.00','admin','2024 09 02','  Cash','  General','2700.00','0.00','+ 0.00','0.0','Shri Guru Traders _847','202409021501',NULL,NULL,NULL,NULL,NULL),(848,'20240903-000011','1241.00','admin','2024 09 03','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _848','202409031219',NULL,NULL,NULL,NULL,NULL),(849,'20241011-000011','1212.00','admin','2024 10 11','  Cash','  General','1212.00','0.00','+ 0.00','0.0','Shri Guru Traders _849','202410111140',NULL,NULL,NULL,NULL,NULL),(850,'20241014-000011','522.00','admin','2024 10 14','  Cash','  General','521.88','0.00','+ 0.12','0.0','Shri Guru Traders _850','202410140940',NULL,NULL,NULL,NULL,NULL),(851,'20241014-000012','528.00','admin','2024 10 14','  Cash','  General','528.00','0.00','+ 0.00','0.0','Shri Guru Traders _851','202410140946',NULL,NULL,NULL,NULL,NULL),(852,'20241014-000013','1413.00','admin','2024 10 14','  Cash','  General','1412.64','0.00','+ 0.36','0.0','Shri Guru Traders _852','202410140947',NULL,NULL,NULL,NULL,NULL),(853,'20241014-000014','880','admin','2024 10 14','  Cash','  General','880.32','0.00','- 0.32','0.0','Shri Guru Traders _853','202410140953',NULL,NULL,NULL,NULL,NULL),(854,'20241014-000015','621.00','admin','2024 10 14','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _854','202410140958',NULL,NULL,NULL,NULL,NULL),(855,'20241014-000016','310.00','admin','2024 10 14','  Cash','  General','310.32','0.00','- 0.32','0.0','Shri Guru Traders _855','202410140959',NULL,NULL,NULL,NULL,NULL),(856,'20241014-000017','2055.00','admin','2024 10 14','  Cash','  General','2054.88','0.00','+ 0.12','0.0','Shri Guru Traders _856','202410141001',NULL,NULL,NULL,NULL,NULL),(857,'20241014-000018','570.00','admin','2024 10 14','  Cash','  General','570.00','0.00','+ 0.00','0.0','Shri Guru Traders _857','202410141053',NULL,NULL,NULL,NULL,NULL),(858,'20241014-000019','450.00','admin','2024 10 14','  Cash','  General','450.00','0.00','+ 0.00','0.0','Shri Guru Traders _858','202410141223',NULL,NULL,NULL,NULL,NULL),(859,'20241015-000011','621.00','admin','2024 10 15','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _859','202410151120',NULL,NULL,NULL,NULL,NULL),(860,'20241015-000012','1413.00','admin','2024 10 15','  Cash','  General','1412.64','0.00','+ 0.36','0.0','Shri Guru Traders _860','202410151121',NULL,NULL,NULL,NULL,NULL),(861,'20241021-000011','621.00','admin','2024 10 21','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _861','202410211019',NULL,NULL,NULL,NULL,NULL),(862,'20241021-000012','1251.00','admin','2024 10 21','  Cash','  General','1250.64','0.00','+ 0.36','0.0','Shri Guru Traders _862','202410211023',NULL,NULL,NULL,NULL,NULL),(863,'20241022-000011','1611','admin','2024 10 22','  Cash','  General','1610.64','0.00','+ 0.36','0.0','Shri Guru Traders _863','202410221013',NULL,NULL,NULL,NULL,NULL),(864,'20241022-000012','1611.00','admin','2024 10 22','  Cash','  General','1610.64','0.00','+ 0.36','0.0','Shri Guru Traders _864','202410221014',NULL,NULL,NULL,NULL,NULL),(865,'20241022-000013','621.00','admin','2024 10 22','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _865','202410221016',NULL,NULL,NULL,NULL,NULL),(866,'20241022-000014','771.00','admin','2024 10 22','  Cash','  General','770.64','0.00','+ 0.36','0.0','Shri Guru Traders _866','202410221017',NULL,NULL,NULL,NULL,NULL),(867,'20241022-000015','1563.00','admin','2024 10 22','  Cash','  General','1562.64','0.00','+ 0.36','0.0','Shri Guru Traders _867','202410221019',NULL,NULL,NULL,NULL,NULL),(868,'20241022-000016','1056.00','admin','2024 10 22','  Cash','  General','1056.00','0.00','+ 0.00','0.0','Shri Guru Traders _868','202410221020',NULL,NULL,NULL,NULL,NULL),(869,'20241022-000017','840.00','admin','2024 10 22','  Cash','  General','840.00','0.00','+ 0.00','0.0','Shri Guru Traders _869','202410221204',NULL,NULL,NULL,NULL,NULL),(870,'20241022-000018','621.00','admin','2024 10 22','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _870','202410221814',NULL,NULL,NULL,NULL,NULL),(871,'20241023-000011','1241.00','admin','2024 10 23','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _871','202410231016',NULL,NULL,NULL,NULL,NULL),(872,'20241023-000012','771.00','admin','2024 10 23','  Cash','  General','770.64','0.00','+ 0.36','0.0','Shri Guru Traders _872','202410231017',NULL,NULL,NULL,NULL,NULL),(873,'20241023-000013','150','admin','2024 10 23','  Cash','  General','150.00','0.00','+ 0.00','0.0','Shri Guru Traders _873','202410231018',NULL,NULL,NULL,NULL,NULL),(874,'20241023-000014','310.00','admin','2024 10 23','  Cash','  General','310.32','0.00','- 0.32','0.0','Shri Guru Traders _874','202410231109',NULL,NULL,NULL,NULL,NULL),(875,'20241026-000011','1008.00','admin','2024 10 26','  Cash','  General','1008.00','0.00','+ 0.00','0.0','Shri Guru Traders _875','202410261003',NULL,NULL,NULL,NULL,NULL),(876,'20241027-000011','1563.00','admin','2024 10 27','  Cash','  General','1562.64','0.00','+ 0.36','0.0','Shri Guru Traders _876','202410271054',NULL,NULL,NULL,NULL,NULL),(877,'20241027-000012','1398.00','admin','2024 10 27','  Cash','  General','1398.00','0.00','+ 0.00','0.0','Shri Guru Traders _877','202410271058',NULL,NULL,NULL,NULL,NULL),(878,'20241030-000011','1292.00','admin','2024 10 30','  Cash','  General','1292.32','0.00','- 0.32','0.0','Shri Guru Traders _878','202410301120',NULL,NULL,NULL,NULL,NULL),(879,'20241030-000012','1188.00','admin','2024 10 30','  Cash','  General','1187.52','0.00','+ 0.48','0.0','Shri Guru Traders _879','202410301127',NULL,NULL,NULL,NULL,NULL),(880,'20241030-000013','1209.00','admin','2024 10 30','  Cash','  General','1208.88','0.00','+ 0.12','0.0','Shri Guru Traders _880','202410301219',NULL,NULL,NULL,NULL,NULL),(881,'20241030-000014','730.00','admin','2024 10 30','  Cash','  General','730.32','0.00','- 0.32','0.0','Shri Guru Traders _881','202410301225',NULL,NULL,NULL,NULL,NULL),(882,'20241102-000011','450.00','admin','2024 11 02','  Cash','  General','450.00','0.00','+ 0.00','0.0','Shri Guru Traders _882','202411021122',NULL,NULL,NULL,NULL,NULL),(883,'20241102-000012','460.00','admin','2024 11 02','  Cash','  General','460.32','0.00','- 0.32','0.0','Shri Guru Traders _883','202411021149',NULL,NULL,NULL,NULL,NULL),(884,'20241102-000013','621.00','admin','2024 11 02','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _884','202411021254',NULL,NULL,NULL,NULL,NULL),(885,'20241102-000014','1021.00','admin','2024 11 02','  Cash','  General','1020.64','0.00','+ 0.36','0.0','Shri Guru Traders _885','202411021257',NULL,NULL,NULL,NULL,NULL),(886,'20241104-000011','621','admin','2024 11 04','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _886','202411040957',NULL,NULL,NULL,NULL,NULL),(887,'20241104-000012','1345.00','admin','2024 11 04','  Cash','  General','1344.72','0.00','+ 0.28','0.0','Shri Guru Traders _887','202411041001',NULL,NULL,NULL,NULL,NULL),(888,'20241104-000013','1413.00','admin','2024 11 04','  Cash','  General','1412.64','0.00','+ 0.36','0.0','Shri Guru Traders _888','202411041001',NULL,NULL,NULL,NULL,NULL),(889,'20241104-000014','1241.00','admin','2024 11 04','  Cash','  General','1241.28','0.00','- 0.28','0.0','Shri Guru Traders _889','202411041003',NULL,NULL,NULL,NULL,NULL),(890,'20241104-000015','831.00','admin','2024 11 04','  Cash','  General','830.64','0.00','+ 0.36','0.0','Shri Guru Traders _890','202411041003',NULL,NULL,NULL,NULL,NULL),(891,'20241104-000016','658.00','admin','2024 11 04','  Cash','  General','658.24','0.00','- 0.24','0.0','Shri Guru Traders _891','202411041004',NULL,NULL,NULL,NULL,NULL),(892,'20241104-000017','1626.00','admin','2024 11 04','  Cash','  General','1625.76','0.00','+ 0.24','0.0','Shri Guru Traders _892','202411041005',NULL,NULL,NULL,NULL,NULL),(893,'20241104-000018','621.00','admin','2024 11 04','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _893','202411041006',NULL,NULL,NULL,NULL,NULL),(894,'20241104-000019','207.00','admin','2024 11 04','  Cash','  General','206.88','0.00','+ 0.12','0.0','Shri Guru Traders _894','202411041006',NULL,NULL,NULL,NULL,NULL),(895,'20241104-0000110','207.00','admin','2024 11 04','  Cash','  General','206.88','0.00','+ 0.12','0.0','Shri Guru Traders _895','202411041006',NULL,NULL,NULL,NULL,NULL),(896,'20241104-0000111','621.00','admin','2024 11 04','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _896','202411041007',NULL,NULL,NULL,NULL,NULL),(897,'20241104-0000112','621.00','admin','2024 11 04','  Cash','  General','620.64','0.00','+ 0.36','0.0','Shri Guru Traders _897','202411041007',NULL,NULL,NULL,NULL,NULL),(898,'20241104-0000113','792.00','admin','2024 11 04','  Cash','  General','792.00','0.00','+ 0.00','0.0','Shri Guru Traders _898','202411041008',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (797,'Gayathri Supermarket ','0897959768','','',770,'0.0',NULL,NULL,NULL),(798,'RainBow Bakes ','8110034555','','',621,'0.0',NULL,NULL,NULL),(799,'Tulir Tea Stall','1246467668','','',3723,'0.0',NULL,NULL,NULL),(800,'Sri Balaji Bakery Vengalpuram ','8978568680','','',4198,'0.0',NULL,NULL,NULL),(801,'Sri Renuka Store','9025440304','','',4803,'0.0',NULL,NULL,NULL),(802,'  FAMILY PAN HOUSE RLY STATION RD','8646468965','','',3072,'0.0',NULL,NULL,NULL),(803,'New General Store Sacret College ','3656356866','','',2597,'0.0',NULL,NULL,NULL),(804,'Chandran Tea Stall Bustand ','8856864668','','',1461,'0.0',NULL,NULL,NULL),(805,'Vadamalai Super Market ','7708896434','','',6609,'0.0',NULL,NULL,NULL),(806,'Gopal Wholesale Store','9040750065','','',2880,'0.0',NULL,NULL,NULL),(807,'Chennai Bakery ','8778352098','','',621,'0.0',NULL,NULL,NULL),(810,'  Kulazhi  Super Market ','2246565656','','',816,'0.0',NULL,NULL,NULL),(812,'New Venkateswara Bakery Kovilur Road ','9551403337','','',4286,'0.0',NULL,NULL,NULL),(813,'Matha ji Wholesale ','3535656465','','',1728,'0.0',NULL,NULL,NULL),(814,'Arun Xerox and Paper Mart','0900898368','','',1242,'0.0',NULL,NULL,NULL),(815,'  Setu Maligai ','0888788679','','',391,'0.0',NULL,NULL,NULL),(817,'Lokesh Maligai Store ','2528656464','','',1032,'0.0',NULL,NULL,NULL),(819,'  VadaMalai Sweets Housing Board ','8940742456','','',190,'0.0',NULL,NULL,NULL),(821,'Sri Vinayaka Murgan Bakery Housing ','9940742797','','',621,'0.0',NULL,NULL,NULL),(822,'  NANDHINI WHOLESALE','8894076076','','',1224,'0.0',NULL,NULL,NULL),(823,'Nakpadiyan Sweets Bustand ','5979566956','','',621,'0.0',NULL,NULL,NULL),(824,'Happy Sweets Bustand ','8656868686','','',621,'0.0',NULL,NULL,NULL),(825,'Raja Fruit Juice ','8089768685','','',1726,'0.0',NULL,NULL,NULL),(826,'Vadamalai Bhavan ','0886756466','','',310,'0.0',NULL,NULL,NULL),(827,'Vadamalai Family Mart ','8870466495','','',1079,'0.0',NULL,NULL,NULL),(833,'Divya cool drinks ','8952554654','','',621,'0.0',NULL,NULL,NULL),(834,'NILGIRIS BAKERY ','8526026474','','',621,'0.0',NULL,NULL,NULL),(835,'T G Vardhan Tea Stall','8467867079','','',1241,'0.0',NULL,NULL,NULL),(836,'S R Paul College Canteen','8646768686','','',829,'0.0',NULL,NULL,NULL),(839,'Chennai Bakery ','6646756560','','',792,'0.0',NULL,NULL,NULL),(840,'Brindavan Iyengar Bakery 2 ','6554553333','','',621,'0.0',NULL,NULL,NULL),(841,'Vinayaka Murgan Bakery Asariyar Nagar ','6688565686','','',1241,'0.0',NULL,NULL,NULL),(842,'Saravana Supermarket ','8056484643','','',771,'0.0',NULL,NULL,NULL),(845,'Hammid Maligai Store ','7575769898','','',450,'0.0',NULL,NULL,NULL),(847,' KATHIRAVAN TRADERS ','8888598866','','',621,'0.0',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'9444616516','Infinity'),(2,'1234567891','Infinity'),(3,'8526026474','Infinity'),(4,'6688565686','Infinity'),(5,'3656356866','Infinity'),(6,'6382353218','Infinity'),(7,'2528656464','Infinity'),(8,'9042893653','Infinity'),(9,'9040750065','Infinity'),(10,'9500437906','Infinity'),(11,'8754926036','Infinity'),(12,'6554553333','Infinity'),(13,'9789794030','Infinity'),(14,'9500292879','Infinity'),(15,'9500652555','Infinity'),(16,'8643041419','Infinity'),(17,'9940742797','Infinity'),(18,'9025440304','Infinity'),(19,'0888788679','Infinity'),(20,'6586467967','Infinity'),(21,'7708896434','Infinity'),(22,'9080320114','Infinity'),(23,'0886756466','Infinity'),(24,'9944365357','Infinity'),(25,'0897959768','Infinity'),(26,'8825801080','Infinity'),(27,'8089768685','Infinity'),(28,'1246467668','Infinity'),(29,'3535656465','Infinity'),(30,'8808996686','Infinity'),(31,'2246565656','Infinity'),(32,'8890999869','Infinity'),(33,'6998986899','Infinity'),(34,'7575769898','Infinity'),(35,'8888598866','Infinity'),(36,'9943594399','Infinity'),(37,'8979764686','Infinity'),(38,'8974086687','Infinity'),(39,'8586765684','Infinity'),(40,'6646756560','Infinity'),(41,'1135546687','Infinity'),(42,'9551403337','Infinity'),(43,'8964686869','Infinity'),(44,'2565459668','Infinity'),(45,'8879608989','Infinity'),(46,'8870466495','Infinity'),(47,'8978568680','Infinity'),(48,'9965640655','Infinity'),(49,'4545468686','Infinity'),(50,'9976277415','Infinity'),(51,'7200552061','Infinity'),(52,'9626037255','Infinity'),(53,'9943552721','Infinity'),(54,'8778620834','Infinity'),(55,'9940922630','Infinity'),(56,'9597734432','Infinity'),(57,'8864864868','Infinity'),(58,'5979566956','Infinity'),(59,'9486677654','Infinity'),(60,'8467867764','Infinity'),(61,'6369114842','Infinity'),(62,'8976356565','Infinity'),(63,'9751657200','Infinity'),(64,'5979566958','Infinity'),(65,'8940742456','Infinity'),(66,'9952341793','Infinity'),(67,'9787377605','Infinity'),(68,'5437686856','Infinity'),(69,'5585700985','Infinity'),(70,'8952554654','Infinity'),(71,'0000978648','Infinity'),(72,'0099860768','Infinity'),(73,'9952665260','Infinity'),(74,'9150111960','Infinity'),(75,'8505098986','Infinity'),(76,'8976568686','Infinity'),(77,'8668059551','Infinity'),(78,'8895686843','Infinity'),(79,'0900898368','Infinity'),(80,'9363200982','Infinity'),(81,'9897567587','Infinity'),(82,'6380351543','Infinity'),(83,'8898686706','Infinity'),(84,'9894109924','Infinity'),(85,'8110034555','Infinity'),(86,'0897864864','Infinity'),(87,'8856864668','Infinity'),(88,'8686865686','Infinity'),(89,'4686538607','Infinity'),(90,'9500751175','Infinity'),(91,'0008995446','Infinity'),(92,'8656486494','Infinity'),(93,'8646876797','Infinity'),(94,'5558386526','Infinity'),(95,'9443247024','Infinity'),(96,'8646768686','Infinity'),(97,'0973438964','Infinity'),(98,'8894076076','Infinity'),(99,'8646468965','Infinity'),(100,'5585700885','Infinity'),(101,'8543846493','Infinity'),(102,'8674766456','Infinity'),(103,'8986864676','Infinity'),(104,'2384607697','Infinity'),(105,'8565986868','Infinity'),(106,'6648674376','Infinity'),(107,'5648667034','Infinity'),(108,'8986057566','Infinity'),(109,'8686858865','Infinity'),(110,'8648453136','Infinity'),(111,'8564064846','Infinity'),(112,'8648370648','Infinity'),(113,'8467867079','Infinity'),(114,'8545676653','Infinity'),(115,'5676439568','Infinity'),(116,'0888788678','Infinity'),(117,'9994677690','Infinity'),(118,'9123506720','Infinity'),(119,'8656868686','Infinity'),(120,'8648787697','Infinity'),(121,'0989860760','Infinity'),(122,'8794676674','Infinity'),(123,'8676998609','Infinity'),(124,'8778352098','Infinity'),(125,'8056484643','Infinity'),(126,'5524668','Infinity'),(127,'8072336157','Infinity'),(128,'84687387647','Infinity'),(129,'8643567649','Infinity'),(130,'9597461418','Infinity'),(131,'84978679797','Infinity'),(132,'85676568','Infinity'),(133,'56768958','Infinity');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Paper Boat Lychee MRP 10 ',467),(2,'Paper Boat Orange MRP 10 ',467),(3,'Pran Curry Noodles MRP 10',1032),(4,'Pran Doggy MRP 500',1260),(5,'Pran Drinko Litchi MRP 40 ',5976),(6,'Pran Drinko Mango MRP 40 ',2856),(7,'Pran Drinko Pineapple MRP 40',2112),(8,'Pran Litchi Drink 1 LTR MRP 80',2040),(9,'Pran Litchi Drink MRP 10',27711),(10,'Pran Litchi Drink MRP 20 ',2100),(11,'Pran Lollipop Jar MRP 250',770),(12,'Pran Potato Bis 75gm Cream and Onion MRP 25',1512),(13,'Pran Potato Biscuit MRP 10 ',1036),(14,'Pran Potato Biscuit Spicy MRP 25',3282),(15,'Pran Pudding Mango MRP 180',2424);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1632','Paper Boat Lychee MRP 10 ',467,1,'54','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1631','Paper Boat Orange MRP 10 ',467,1,'54','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1618','Pran Curry Noodles MRP 10',1032,2,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1608','Pran Doggy MRP 500',1260,2,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1638','Pran Drinko Litchi MRP 40 ',5976,11,'184','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1648','Pran Drinko Mango MRP 40 ',2856,5,'88','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1604','Pran Drinko Pineapple MRP 40',2112,4,'64','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1620','Pran Litchi Drink 1 LTR MRP 80',2040,4,'30','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1599','Pran Litchi Drink MRP 10',27711,50,'3256','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1600','Pran Litchi Drink MRP 20 ',2100,4,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1674','Pran Lollipop Jar MRP 250',770,1,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1601','Pran Potato Bis 75gm Cream and Onion MRP 25',1512,3,'72','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1607','Pran Potato Biscuit MRP 10 ',1036,2,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1621','Pran Potato Biscuit Spicy MRP 25',3282,6,'156','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1606','Pran Pudding Mango MRP 180',2424,4,'17','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (144,'None',55045);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',55050);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'Mani ',55050,100);
