INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'26 Mar 2022','08:51:02 PM','ladmin','20220326-000021','40.00','10.00','ok','22');
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 (1,'pune','7020765633','','',1584,'0.0',NULL,NULL,NULL),(2,'santosh','9373003530','','',1118,'0.0',NULL,NULL,NULL),(12,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',4277,'1305.0',NULL,NULL,NULL),(29,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',300,'2365.0',NULL,NULL,NULL),(30,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',670,'2735.0',NULL,NULL,NULL),(32,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',918,'2983.0',NULL,NULL,NULL),(33,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',480,'2983.0',NULL,NULL,NULL),(36,'vt','7020765633','','',60,'0.0',NULL,NULL,NULL),(37,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',560,'3023.0',NULL,NULL,NULL),(39,'Bhawani Dairy Mahendra','7972712918','','Raviwar peth',5940,'5340.0',NULL,NULL,NULL),(44,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',1660,'1023.0',NULL,NULL,NULL),(45,'Santosh Agrawal','9373003530','','Paras spikars',1775,'0.0',NULL,NULL,NULL),(46,'Dalvi Kalyan','7057538148','','Kershaw nagar',1130,'0.0',NULL,NULL,'40.0'),(48,'Rahul choudhri','8209895696','','',20,'0.0',NULL,NULL,NULL),(49,'pure','8668260397','','',240,'0.0',NULL,NULL,NULL),(50,'Bhosle RS','9922487914','','',710,'0.0',NULL,NULL,NULL),(51,'vijay kumar','9673121355','','',70,'0.0',NULL,NULL,NULL),(52,'khedekar','9527242919','','',320,'0.0',NULL,NULL,NULL),(53,'Tanmay','9763493082','','',560,'0.0',NULL,NULL,NULL),(54,'shevale kalash','9130002875','','',620,'0.0',NULL,NULL,NULL),(55,'kiran','9881988155','','',280,'0.0',NULL,NULL,NULL),(56,'Rahate','8530557913','','',105,'0.0',NULL,NULL,NULL),(57,'Dharmadhikari','9850399293','','',210,'0.0',NULL,NULL,NULL),(58,'Ketkar','9595804406','','',2089,'0.0',NULL,NULL,NULL),(59,'Bansode','9370173532','','',880,'0.0',NULL,NULL,NULL),(60,'Shinde Ajinkya','7038375530','','',355,'0.0',NULL,NULL,NULL),(61,'padvekar','9834650796','','',160,'0.0',NULL,NULL,NULL),(62,'Rachi Mahadik','8459025479','','',440,'0.0',NULL,NULL,NULL),(63,'Ghosalkr','8983896945','','',240,'0.0',NULL,NULL,NULL),(64,'shinde Ganesh','9158330113','','',80,'0.0',NULL,NULL,NULL),(65,'Katkar','9623199213','','',140,'0.0',NULL,NULL,NULL),(66,'Shinde Prashant','7498457811','','',70,'0.0',NULL,NULL,NULL),(67,'Salman','9508013250','','',350,'0.0',NULL,NULL,NULL),(68,'Bandal Lahu','8329437618','','',80,'0.0',NULL,NULL,NULL),(69,'Makasare p','8605019678','','',840,'0.0',NULL,NULL,NULL),(70,'Kamle P','9860555876','','',110,'0.0',NULL,NULL,NULL),(71,'Vijay p','7620385873','','',80,'0.0',NULL,NULL,NULL),(72,'Tupe p','9552003449','','',140,'0.0',NULL,NULL,NULL),(73,'Kamle ram','9763876366','','',410,'0.0',NULL,NULL,NULL),(74,'Potddar ','9689181188','','',125,'0.0',NULL,NULL,NULL),(75,'Shinde Bina','9689513322','','',695,'0.0',NULL,NULL,NULL),(76,'Dhamale Shiva','7841994185','','',490,'0.0',NULL,NULL,NULL),(77,'kawre D','8888868325','','',440,'0.0',NULL,NULL,NULL),(78,'Om yam ','9766412912','','',300,'0.0',NULL,NULL,NULL),(79,'Laxman p','9822373387','','',420,'0.0',NULL,NULL,NULL),(80,'Navgire mam','9922886838','','',820,'0.0',NULL,NULL,NULL),(81,'Shah Krish','7057781513','','',200,'0.0',NULL,NULL,NULL),(82,'Duns Dairy','9823048565','','',400,'0.0',NULL,NULL,NULL),(83,'Bavankar h','9503519079','','',310,'0.0',NULL,NULL,NULL),(84,'Shinde Payal','9730929241','','',470,'0.0',NULL,NULL,NULL),(85,'Shabnam ','8208857423','','',540,'0.0',NULL,NULL,NULL),(86,'Kuthwal s','7350067103','','',200,'0.0',NULL,NULL,NULL),(87,'Sumnt','7276224018','','',200,'0.0',NULL,NULL,NULL),(88,'Kulkarni Rr','7588229352','','',320,'0.0',NULL,NULL,NULL),(89,'Mahadik D','8624908972','','',430,'0.0',NULL,NULL,NULL),(90,'Mohol shiv','7385025958','','',4050,'0.0',NULL,NULL,NULL),(91,'mo','','','',10,'0.0',NULL,NULL,NULL),(92,'Upasne m','8668259482','','',630,'0.0',NULL,NULL,NULL),(93,'Malusare Uj','9665354726','','',1515,'0.0',NULL,NULL,NULL),(94,'Pasalkar  Sw','9763894960','','',70,'0.0',NULL,NULL,NULL),(95,'Pawar  Vijya','9527244693','','',105,'0.0',NULL,NULL,NULL),(96,'Gonjare','9890832091','','',70,'0.0',NULL,NULL,NULL),(97,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',10,'1023.0',NULL,NULL,NULL),(98,'Laxman Shendge','9637522690','','',10,'0.0',NULL,NULL,NULL),(99,'Pawar  Mahesh','9604552465','','',1150,'0.0',NULL,NULL,NULL),(100,'Modak Rr','9623221600','','',445,'0.0',NULL,NULL,NULL),(101,'sutar shubham','8421949875','','',700,'0.0',NULL,NULL,NULL),(102,'Mahesh Maid','9175617789','','',280,'0.0',NULL,NULL,NULL),(103,'Yash rest.','7038796942','','',560,'0.0',NULL,NULL,NULL),(104,'Jadhv R','9881043470','','',180,'0.0',NULL,NULL,NULL),(105,'Nalavde Asha','9325136257','','',165,'0.0',NULL,NULL,NULL),(106,'YadavM','9021646261','','',210,'0.0',NULL,NULL,NULL),(107,'Kamle Vi','9371182292','','',140,'0.0',NULL,NULL,NULL),(108,'Kartik ksvekar','9322550876','','',280,'0.0',NULL,NULL,NULL),(109,'Ghemat S','9156289495','','',80,'0.0',NULL,NULL,NULL),(110,'shivraikar Sw','9970800164','','',10,'0.0',NULL,NULL,NULL),(111,'Veer','9765989635','','',240,'0.0',NULL,NULL,NULL),(112,'Kharat sir','7020794447','','',560,'0.0',NULL,NULL,NULL),(113,'Jadhv sharmila','9112977368','','',210,'0.0',NULL,NULL,NULL),(114,'jagtap sandeep','9637058035','','',260,'0.0',NULL,NULL,NULL),(115,'Jadhv atharv','8262877234','','',180,'0.0',NULL,NULL,NULL),(116,'Gunjal Reshma','7741003230','','',40,'0.0',NULL,NULL,NULL),(117,'Adhav Om','9881255518','','',70,'0.0',NULL,NULL,NULL),(118,'Dinesh Bogam','9922913570','','',100,'0.0',NULL,NULL,NULL),(119,'Vinaya shedge','7447841569','','',70,'0.0',NULL,NULL,NULL),(120,'Pagare','9702707468','','',120,'0.0',NULL,NULL,NULL),(121,'Dagde','9579652403','','',210,'0.0',NULL,NULL,NULL),(122,'Ughde','8999247166','','',290,'0.0',NULL,NULL,NULL),(123,'Chvhan Gaurv','9822315003','','',530,'0.0',NULL,NULL,NULL),(124,'Veer V','8788415406','','',120,'0.0',NULL,NULL,NULL),(125,'Kiran jagtap','9284042048','','',70,'0.0',NULL,NULL,NULL),(126,'Tilekar Sahil','7038914019','','',140,'0.0',NULL,NULL,NULL),(127,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',10,'1023.0',NULL,NULL,NULL),(128,'Laxman Shendge','9637522690','','',20,'0.0',NULL,NULL,NULL),(129,'Yadav K','9960499606','','',293,'0.0',NULL,NULL,NULL),(130,'Munot A','8149205605','','',70,'0.0',NULL,NULL,NULL),(131,'Chaudhri ','9595329343','','',410,'0.0',NULL,NULL,NULL),(132,'Salunkhe s','8421218622','','',268,'0.0',NULL,NULL,NULL),(133,'Gdphadche n','9960375995','','',175,'0.0',NULL,NULL,NULL),(134,'','','','',20,'0.0',NULL,NULL,NULL),(135,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',10,'1033.0',NULL,NULL,NULL),(136,'Hole Akshay','9146900832','','',560,'0.0',NULL,NULL,NULL),(137,'Chandivade','8275566382','','',140,'0.0',NULL,NULL,NULL),(138,'Dalve ','8793374625','','',550,'0.0',NULL,NULL,NULL),(139,'Patil c','9767412558','','',290,'0.0',NULL,NULL,NULL),(140,'Suryavanshi r','9860775006','','',360,'0.0',NULL,NULL,NULL),(141,'Deepak shingade','9850497140','','',425,'0.0',NULL,NULL,NULL),(142,'Karlekar','9890945006','','',210,'0.0',NULL,NULL,NULL),(143,'Mandale','7030911209','','',205,'0.0',NULL,NULL,NULL),(144,'Pardeshi Asha','7776944308','','',290,'0.0',NULL,NULL,NULL),(145,'Kumthekar','8766789268','','',140,'0.0',NULL,NULL,NULL),(146,'Patole','9922434464','','',554,'0.0',NULL,NULL,NULL),(147,'Dhumal mandar','9823230385','','',1130,'0.0',NULL,NULL,NULL),(148,'Marchetty','8208000138','','',100,'0.0',NULL,NULL,NULL),(149,'Pawar Laxmi','7666524149','','',530,'0.0',NULL,NULL,NULL),(150,'Mangaokar','9881093781','','',210,'0.0',NULL,NULL,NULL),(151,'Purankar','9325388825','','',477,'0.0',NULL,NULL,NULL),(152,'Sayyad','9890922312','','',210,'0.0',NULL,NULL,NULL),(153,'Ghanekar shivam','9168234558','','',80,'0.0',NULL,NULL,NULL),(154,'Sutar Deepali','98888397012','','',402,'0.0',NULL,NULL,NULL),(155,'Paranjpe Priya','9834056816','','',210,'0.0',NULL,NULL,NULL),(156,'Khandeka mam','9922327937','','',430,'0.0',NULL,NULL,NULL),(157,'Kank','9028094082','','',460,'0.0',NULL,NULL,NULL),(158,'Kalaskar','9004426962','','',140,'0.0',NULL,NULL,NULL),(159,'Fatak','8975331149','','',280,'0.0',NULL,NULL,NULL),(160,'Shinge s','9326357745','','',280,'0.0',NULL,NULL,NULL),(161,'Londhe Pooja','9130012938','','',150,'0.0',NULL,NULL,NULL),(162,'Pawar shantanu','8007177109','','',250,'0.0',NULL,NULL,NULL),(163,'Vijay virnar','9421689221','','',350,'0.0',NULL,NULL,NULL),(164,'Joshi devendra','9822454535','','',360,'0.0',NULL,NULL,NULL),(165,'Vitkar p','9823429975','','',260,'0.0',NULL,NULL,NULL),(166,'Tekade','7020653604','','',200,'0.0',NULL,NULL,NULL),(167,'More vijay','7970772216','','',570,'0.0',NULL,NULL,NULL),(168,'Takalkar','9049973718','','',110,'0.0',NULL,NULL,NULL),(169,'Atavdekar','8605013757','','',170,'0.0',NULL,NULL,NULL),(170,'Surve Pp','7822955033','','',200,'0.0',NULL,NULL,NULL),(171,'Kad appasaheb','9422536733','','',455,'0.0',NULL,NULL,NULL),(172,'Bharat tajne','9834733244','','',700,'0.0',NULL,NULL,NULL),(173,'Bhuwad','9767390821','','',340,'0.0',NULL,NULL,NULL),(174,'Parmar','9960469460','','',700,'0.0',NULL,NULL,NULL),(175,'Pawar k','8087878711','','',210,'0.0',NULL,NULL,NULL),(176,'Panvelkar','9822616898','','',280,'0.0',NULL,NULL,NULL),(177,'Mahendra joshi','9970903683','','',715,'0.0',NULL,NULL,NULL),(178,'Abijit Dangare','8999963382','','',240,'0.0',NULL,NULL,NULL),(179,'Harshal Theurkar','8983640180','','',80,'0.0',NULL,NULL,NULL),(180,'Hatenwar','9767397543','','',295,'0.0',NULL,NULL,NULL),(181,'More Pritesh','7774848394','','',180,'0.0',NULL,NULL,NULL),(182,'Radhika Habbu','8551906453','','',220,'0.0',NULL,NULL,NULL),(183,'Chavhan N','9503445537','','',320,'0.0',NULL,NULL,NULL),(184,'Dhumal Tusha','8178868767','','',128,'0.0',NULL,NULL,NULL),(185,'Shinde Bharat','9822414657','','',600,'0.0',NULL,NULL,NULL),(186,'Parekh K','8087723945','','',300,'0.0',NULL,NULL,NULL),(187,'Rajput manish','9158183747','','',200,'0.0',NULL,NULL,NULL),(188,'Gayakvad S','9226143932','','',150,'0.0',NULL,NULL,NULL),(189,'Vinod Divte','9689658302','','',420,'0.0',NULL,NULL,NULL),(190,'Reshma shaikh','9146831645','','',330,'0.0',NULL,NULL,NULL),(191,'Mandav vale','9356838468','','',140,'0.0',NULL,NULL,NULL),(192,'Bhujbal Vandana','9689331157','','',970,'0.0',NULL,NULL,NULL),(193,'Suryavanshi r','9860775006','','',545,'0.0',NULL,NULL,NULL),(194,'Honkalse','8208452581','','',490,'0.0',NULL,NULL,NULL),(196,'Darekar','9922472165','','',150,'0.0',NULL,NULL,NULL),(197,'SharmaSantosh','9021804504','','',1,'0.0',NULL,NULL,NULL),(198,'Kiran Vaishnav','9067755711','','',3100,'0.0',NULL,NULL,NULL),(199,'Pawar kashmira','9673730643','','',1575,'0.0',NULL,NULL,NULL),(200,'Kulkarni S.A.','9822172798','','',190,'0.0',NULL,NULL,NULL),(201,'Kadam Varsh','9284781323','','',150,'0.0',NULL,NULL,NULL),(202,'Nazre Pradeep','9325729808','','',610,'0.0',NULL,NULL,NULL),(203,'Hemant Agrawal','9890910700','hemantsagrawal@gmail.com','budhwar peth ',1,'1033.0',NULL,NULL,NULL),(204,'Thomas','9325069074','','',180,'0.0',NULL,NULL,NULL),(205,'Sen','9823667125','','',190,'0.0',NULL,NULL,NULL),(206,'Shuklaji','7517391793','','',500,'0.0',NULL,NULL,NULL),(207,'Sontakke','7276255906','','',333,'0.0',NULL,NULL,NULL),(208,'Kulkarni sarika','9850907487','','',815,'0.0',NULL,NULL,NULL),(209,'Shirsagar','9960522464','','',212,'0.0',NULL,NULL,NULL),(210,'Mandhare','9922777094','','',420,'0.0',NULL,NULL,NULL),(211,'Dhotre Sachi','7798798927','','',860,'0.0',NULL,NULL,NULL),(212,'Shinde Jyoti','8446678152','','',70,'0.0',NULL,NULL,NULL),(213,'Kulunge m','9860148502','','',160,'0.0',NULL,NULL,NULL),(214,'nimakar asmita','7385861209','','',140,'0.0',NULL,NULL,NULL),(215,'Jadhav Balasaheb','7666317851','','',80,'0.0',NULL,NULL,NULL),(216,'Yelle','8805464644','','',500,'0.0',NULL,NULL,NULL),(217,'Patel K','8975510400','','',190,'0.0',NULL,NULL,NULL),(218,'Kumbhar Ardhna','9145435258','','',150,'0.0',NULL,NULL,NULL),(219,'Bhogade','9823098715','','',240,'0.0',NULL,NULL,NULL),(220,'Bhungale','7887575196','','',160,'0.0',NULL,NULL,NULL),(221,'Jadhv harshl','9325479931','','',370,'0.0',NULL,NULL,NULL),(222,'Kale vidya','9922998192','','',380,'0.0',NULL,NULL,NULL),(223,'Marne','7355474345','','',220,'0.0',NULL,NULL,NULL),(224,'Rajguru','7720015567','','',646,'0.0',NULL,NULL,NULL),(225,'Shankar Pure','9552439354','','',72,'0.0',NULL,NULL,NULL),(226,'Kudale Jyoti','9850230591','','',840,'0.0',NULL,NULL,NULL),(227,'Mishraji','8355830487','','',300,'0.0',NULL,NULL,NULL),(228,'Kusalkar sweta','9850323717','','',275,'0.0',NULL,NULL,NULL),(229,'Shinde uma','9689259235','','',200,'0.0',NULL,NULL,NULL),(230,'Kulkarni Sripad','9422003974','','',560,'0.0',NULL,NULL,NULL),(231,'Dere','9921325268','','',280,'0.0',NULL,NULL,NULL),(232,'More aditya','9552907405','','',160,'0.0',NULL,NULL,NULL),(233,'Jadhaw Prthmesh','9860025455','','',230,'0.0',NULL,NULL,NULL),(234,'Shinde parth','9561964943','','',390,'0.0',NULL,NULL,NULL),(235,'Dadad','7620835651','','',560,'0.0',NULL,NULL,NULL),(236,'Parandekar','9271259590','','',5600,'0.0',NULL,NULL,NULL),(237,'Sanket kumbhar','9022768648','','',165,'0.0',NULL,NULL,NULL),(238,'Bhingarkar','8983769594','','',355,'0.0',NULL,NULL,NULL),(239,'Vasal','8830651681','','',320,'0.0',NULL,NULL,NULL),(240,'Avte','9823981280','','',320,'0.0',NULL,NULL,NULL),(241,'Ajit bharti','7350788102','','',330,'0.0',NULL,NULL,NULL),(242,'Sarak','9325858477','','',270,'0.0',NULL,NULL,NULL),(243,'Adv.Shivarkar','9850642133','','',560,'0.0',NULL,NULL,NULL),(244,'','976349','','',150,'0.0',NULL,NULL,NULL),(245,'Kulkarni snehal','9822351949','','',240,'0.0',NULL,NULL,NULL),(246,'Ganu','8208195695','','',820,'0.0',NULL,NULL,NULL),(247,'Balasaheb khandve','9850848108','','',1230,'0.0',NULL,NULL,NULL),(248,'Ovhal shashwati','8080109811','','',202,'0.0',NULL,NULL,NULL),(249,'Jadale','8600792826','','',230,'0.0',NULL,NULL,NULL),(250,'Dangat Nitin','9970943738','','',210,'0.0',NULL,NULL,NULL),(251,'Kotrange','9850860433','','',440,'0.0',NULL,NULL,NULL),(252,'Dhariwal Poonam','9022454445','','',360,'0.0',NULL,NULL,NULL),(253,'Baldota Snehal','9881123802','','',420,'0.0',NULL,NULL,NULL),(254,'Patil ds','8668337101','','',260,'0.0',NULL,NULL,NULL),(255,'Kavita dani','8796809802','','',360,'0.0',NULL,NULL,NULL),(256,'Pilane','7350545959','','',150,'0.0',NULL,NULL,NULL),(257,'Kurne n','9921693072','','',160,'0.0',NULL,NULL,NULL),(260,'Amit poddar','9021875940','','',200,'0.0',NULL,NULL,NULL),(261,'Kondhalkar','9730257760','','',315,'0.0',NULL,NULL,NULL),(262,'Renuka Reddy','7011805224','','',440,'0.0',NULL,NULL,NULL),(263,'Bhawsar Madhura','8087683790','','',350,'0.0',NULL,NULL,NULL),(264,'Kale ajinkya','8237561213','','',170,'0.0',NULL,NULL,NULL),(265,'Parekh Namrata','9370498068','','',380,'0.0',NULL,NULL,NULL),(266,'Bodhani','9850489779','','',140,'0.0',NULL,NULL,NULL),(267,'Anjali Gholap','9623569834','','',20,'0.0',NULL,NULL,NULL),(268,'Cheke','9923659498','','',260,'0.0',NULL,NULL,NULL),(269,'tushar. nanavre','8796772948','','',160,'0.0',NULL,NULL,NULL),(270,'Anand mane','9829328079','','',180,'0.0',NULL,NULL,NULL),(271,'kuber kadam','9158617008','','',400,'0.0',NULL,NULL,NULL),(272,'Deepak shinde','9822867238','','',370,'0.0',NULL,NULL,NULL),(273,'ajay  bhurukh','7620177529','','',190,'0.0',NULL,NULL,NULL),(274,'Anndate','8668305515','','',350,'0.0',NULL,NULL,NULL),(275,'Vibha Ranvade','9373082741','','',250,'0.0',NULL,NULL,NULL),(276,'Vijay Jagtap','9175050338','','',575,'0.0',NULL,NULL,NULL),(277,'Sanika wadvekar','8805985684','','',450,'0.0',NULL,NULL,NULL),(278,'','9527242919','','',310,'0.0',NULL,NULL,NULL),(279,'Ganesh chavan','899911810','','',160,'0.0',NULL,NULL,NULL),(280,'trupti sontake','9096564430','','',300,'0.0',NULL,NULL,NULL),(281,'Shekh Samina','9011943216','','',200,'0.0',NULL,NULL,NULL),(282,'Chaudhari abc','9136011751','','',960,'0.0',NULL,NULL,NULL),(283,'Rajesh prate','9545698230','','',340,'0.0',NULL,NULL,NULL),(284,'Bhosale S','9284460693','','',170,'0.0',NULL,NULL,NULL),(285,'Manjiri sathe','9922929922','','',470,'0.0',NULL,NULL,NULL),(286,'trivedi','9028198536','','',140,'0.0',NULL,NULL,NULL),(287,'mayuer kale','7030301154','','',280,'0.0',NULL,NULL,NULL),(288,'chadrkant vibhandi','9822115344','','',480,'0.0',NULL,NULL,NULL),(289,'Mate Ganesh','9881146186','','',1100,'0.0',NULL,NULL,NULL),(290,'minashki bhigardive','9579032623','','',180,'0.0',NULL,NULL,NULL),(291,'Khandekar','9923749225','','',450,'0.0',NULL,NULL,NULL),(292,'Bhokre P','9922354742','','',420,'0.0',NULL,NULL,NULL),(293,'Shelar Kiran','9372471246','','',160,'0.0',NULL,NULL,NULL),(294,'Mohite','7620206834','','',130,'0.0',NULL,NULL,NULL),(295,'Dipti Lambe','9370324203','','',440,'0.0',NULL,NULL,NULL),(296,'Balu Chavhan','9822647462','','',230,'0.0',NULL,NULL,NULL),(297,'Yadav pankaj','9011515151','','',410,'0.0',NULL,NULL,NULL),(298,'Gayakvad Rupali','8983024546','','',490,'0.0',NULL,NULL,NULL),(299,'geeta bachal','9975294474','','',1370,'0.0',NULL,NULL,NULL),(300,'Rajendr kumar','9922060269','','',160,'0.0',NULL,NULL,NULL),(301,'harshali. Mahashbadhe','8999710250','','',320,'0.0',NULL,NULL,NULL),(302,'gokhale ','9422331911','','',720,'0.0',NULL,NULL,NULL),(303,'Ganesh Raout','9922908576','','',690,'0.0',NULL,NULL,NULL),(304,'Rasal Rupali','7249288081','','',220,'0.0',NULL,NULL,NULL),(305,'Patil Suvarna','9763028009','','',520,'0.0',NULL,NULL,NULL),(306,'shital joshi','9850093371','','',140,'0.0',NULL,NULL,NULL),(307,'Shinde  sachin','9822559122','','',765,'0.0',NULL,NULL,NULL),(308,'jayshree Thakur desai','9029077725','','',1000,'0.0',NULL,NULL,NULL),(309,'shubhagi ','7722007557','','',1020,'0.0',NULL,NULL,NULL),(310,'eknath chavan','9422350071','','',110,'0.0',NULL,NULL,NULL),(311,'kalpana vahvare','7499109678','','',330,'0.0',NULL,NULL,NULL),(312,'Raviraj Khirsagar','8975995114','','',150,'0.0',NULL,NULL,NULL),(313,'Kale ketan','9765952639','','',160,'0.0',NULL,NULL,NULL),(314,'Manisha Ganaer','7875599883','','',280,'0.0',NULL,NULL,NULL),(315,'Bhikule','9420176177','','',260,'0.0',NULL,NULL,NULL),(316,'Nangre','9923056983','','',380,'0.0',NULL,NULL,NULL),(317,'Manoj k','9552941304','','',240,'0.0',NULL,NULL,NULL),(318,'Shivaji bhokre','8087607512','','',320,'0.0',NULL,NULL,NULL),(319,'Bhalerav','9822851243','','',180,'0.0',NULL,NULL,NULL),(320,'Kailas padval','9730966777','','',530,'0.0',NULL,NULL,NULL),(321,'Ramgir','8999853711','','',650,'0.0',NULL,NULL,NULL),(322,'patil g','9767412558','','',200,'0.0',NULL,NULL,NULL),(323,'Khedekar Suvrna','9422005529','','',730,'0.0',NULL,NULL,NULL),(324,'Bill','8698368781','','',190,'0.0',NULL,NULL,NULL),(325,'Yende Sharad','9028764293','','',252,'0.0',NULL,NULL,NULL),(326,'Pushpa Dalvi','9881572595','','',610,'0.0',NULL,NULL,NULL),(327,'supriya sawant','9823928933','','',190,'0.0',NULL,NULL,NULL),(328,'Apurva Narwade','9021878582','','',440,'0.0',NULL,NULL,NULL),(329,'jyoti. Bhokare','9021134949','','',160,'0.0',NULL,NULL,NULL),(330,'prakash mukdam','9850138309','','',310,'0.0',NULL,NULL,NULL),(331,'Sanjay Taru','9422321252','','',140,'0.0',NULL,NULL,NULL),(332,'Anita Sapre','7798881915','','',954,'0.0',NULL,NULL,NULL),(333,'Phadke','7558431838','','',470,'0.0',NULL,NULL,NULL),(334,'Phadakle','7066154616','','',516,'0.0',NULL,NULL,NULL),(335,'Rohini kadam','9067442136','','',220,'0.0',NULL,NULL,NULL),(336,'satyam kumar','7046456585','','',280,'0.0',NULL,NULL,NULL),(337,'chadivade','9421015383','','',468,'0.0',NULL,NULL,NULL),(338,'bahadre','8796635033','','',750,'0.0',NULL,NULL,NULL),(339,'Tiwari  meeta','9373233467','','',440,'0.0',NULL,NULL,NULL),(340,'sayali  Ipte','853021575','','',180,'0.0',NULL,NULL,NULL),(341,'sonali. jadhav','928473503','','',180,'0.0',NULL,NULL,NULL),(342,'yogesh khirsagar','9881273835','','',320,'0.0',NULL,NULL,NULL),(343,'Mhaske sandeep','8766526046','','',230,'0.0',NULL,NULL,NULL),(344,'Shinde yashvant','8087681817','','',250,'0.0',NULL,NULL,NULL),(345,'Ahir Jatin','9881566289','','',1190,'0.0',NULL,NULL,NULL),(346,'Parkhi Bhagyashri','9423573451','','',590,'0.0',NULL,NULL,NULL),(347,'Vasant Pawar','8625866044','','',320,'0.0',NULL,NULL,NULL),(348,'sourabh sangale','9975773870','','',840,'0.0',NULL,NULL,NULL),(349,'priya. shirke','7666896225','','',190,'0.0',NULL,NULL,NULL),(350,'Bachha','9822373248','','',160,'0.0',NULL,NULL,NULL),(351,'vikas khambe','9767517134','','',360,'0.0',NULL,NULL,NULL),(352,'Ashwini ','9823561639','','',330,'0.0',NULL,NULL,NULL),(353,'Gaikwad','9028925914','','',480,'0.0',NULL,NULL,NULL),(354,'Bansode','9370173532','','',590,'0.0',NULL,NULL,NULL),(355,'Ashwin hasrkar','9763328040','','',160,'0.0',NULL,NULL,NULL),(356,'Amar Marane','7040863710','','',110,'0.0',NULL,NULL,NULL),(357,'shubham waikar','8983655373','','',480,'0.0',NULL,NULL,NULL),(358,'Patil Ganesh','9822440133','','',540,'0.0',NULL,NULL,NULL),(359,'Shinde Varsha','8788070476','','',460,'0.0',NULL,NULL,NULL),(360,'Rahul Gokar','8007351342','','',120,'0.0',NULL,NULL,NULL),(361,'Gavade','9921475639','','',540,'0.0',NULL,NULL,NULL),(362,'Ruchira. Mulik','8308821491','','',160,'0.0',NULL,NULL,NULL),(363,'  vaishnavi darwatkar','7620547376','','',600,'0.0',NULL,NULL,NULL),(364,'Manisha. pujari','8308307887','','',380,'0.0',NULL,NULL,NULL),(365,'Pathak shivraj','9561829247','','',435,'0.0',NULL,NULL,NULL),(366,'Salunkhe vaishli','8421611942','','',310,'0.0',NULL,NULL,NULL),(367,'Dhawte S','9561896674','','',70,'0.0',NULL,NULL,NULL),(368,'Karanjkar Manoj','9762161736','','',290,'0.0',NULL,NULL,NULL),(369,'Patil abhijit','9975929065','','',300,'0.0',NULL,NULL,NULL),(370,'Shirke sagar','9967894948','','',305,'0.0',NULL,NULL,NULL),(371,'Nagre Aarti','8888402932','','',580,'0.0',NULL,NULL,NULL),(372,'Satpute P','9960132474','','',360,'0.0',NULL,NULL,NULL),(374,'Waghmare umesh','7387224141','','',480,'0.0',NULL,NULL,NULL),(375,'Gandle swapnali','9373065294','','',780,'0.0',NULL,NULL,NULL),(376,'Falke A','9112157196','','',350,'0.0',NULL,NULL,NULL),(377,'More mahendra','8080206097','','',300,'0.0',NULL,NULL,NULL),(378,'Shejwal Nilesh','7499771179','','',160,'0.0',NULL,NULL,NULL),(379,'Uttekar','8010823384','','',1018,'0.0',NULL,NULL,NULL);
INSERT INTO `cust_feedback` (`_id`, `cust_name`, `date`, `time`, `ambience_rating`, `pro_qual_rating`, `service_rating`, `overall_exp_rating`, `comments`, `percentage`, `cust_phoneno`) VALUES (1,'Dalvi Kalyan','2024 05 03','03:46:57 PM','5.0','1.0','1.0','1.0','','40.0','7057538148');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'cabbage kg',64),(2,'capsicum green kg',160),(3,'cauliflower kg',90),(4,'mawa',480),(5,'nutella',850),(6,'sona masoori raw rice 1kg',280),(7,'spinach bunch',100),(8,'tata urad dal whole white 1kg',1250),(9,'nutella',850),(10,'paneer',560),(11,'sona masoori raw rice 1kg',280),(12,'spinach bunch',100),(13,'tata urad dal whole white 1kg',1250),(14,'Mawa/Khawa (250gm)',140),(15,'Mawa/Khawa (750gm)',210),(16,'Nutdelight (16kg)',2592),(17,'Paneer (125gm)',35),(18,'Paneer (250gm)',140),(19,'Paneer (500gm)',140),(20,'Paneer (Regular)',6587),(21,'Pani botal ',50),(22,'Shri/Amrakand 1kg poli',1320),(23,'Shri/Amrakhand 250 Daba',35),(24,'Shri/Amrakhand 500 Daba',140),(25,'Shri/Amrakhand 500poli',840),(26,'Suhana masala(Regular)',40),(27,'Sweet 200 (1kg)',200),(28,'Sweet 200 (250gm)',100),(29,'Sweet 200 (500gm)',200),(30,'Sweet 400(125gm)',50),(31,'Tomato sos',100),(32,'chocolate',480),(33,'green peas 1kg',90),(34,'Paneer(500gm)',560),(35,'Pani botal /Dahi pouch',530),(36,'Parontha/ Nnan',300),(37,'Shri/Amrakand 1kg poli',8260),(38,'Shri/Amrakhand (250 gm)',400),(39,'Shri/Amrakhand (500 gm)',320),(40,'Shri/Amrakhand (Regular)',4960),(41,'Sreekhnd/Amra 500gm pac',980),(42,'Suhana masala(10gm)',20),(43,'Suhana masala(50gm)',30),(44,'Suhana masala(regular)',240),(45,'Sweet 280(250gm)',210),(46,'Sweet 280(regular)',924),(47,'Sweet 400(125gm)',50),(48,'Sweet 400(250gm)',200),(49,'Sweet 400(500gm)',200),(50,'Sweet 800',200),(51,'Tomato sos(Surbhi 1 kg)',140),(52,'sause',120),(53,'sause/pani',110),(54,'Sweet 400(125gm)',50),(55,'Sweet 400(250gm)',300),(56,'Sweet 400(500gm)',200),(57,'Sweet 560(500 gm)',280),(58,'culture',130),(59,'sause/pani',190),(60,'sause/pani',110),(61,'Sweet 560(125 gm)',70),(62,'Sweet 800(125g)',200),(63,'Tomato Sos(Wingar)',70),(64,'sause/pani',160);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Dairy',18,0,'1'),(2,NULL,'Frozan',60,0,'1'),(3,NULL,'RUNNING',13256,99,'45');
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,'19','cabbage kg',64,2,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'6','capsicum green kg',160,5,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'8','cauliflower kg',90,3,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1599','mawa',480,15,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'3','nutella',850,26,'5','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'3','sona masoori raw rice 1kg',280,9,'5','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'17','spinach bunch',100,3,'5','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'2','tata urad dal whole white 1kg',1250,38,'5','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1605','nutella',850,17,'5','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1603','paneer',560,11,'2','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1603','sona masoori raw rice 1kg',280,5,'5','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1603','spinach bunch',100,2,'5','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1603','tata urad dal whole white 1kg',1250,24,'5','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1690','Mawa/Khawa (250gm)',140,1,'2','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1690','Mawa/Khawa (750gm)',210,1,'1','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1690','Nutdelight (16kg)',2592,11,'1','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'1690','Paneer (125gm)',35,0,'1','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'1690','Paneer (250gm)',140,1,'2','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'1690','Paneer (500gm)',140,1,'1','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'1690','Paneer (Regular)',6587,27,'30','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'1608','Pani botal ',50,0,'5','Confectionery ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'1676','Shri/Amrakand 1kg poli',1320,6,'11','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'1677','Shri/Amrakhand 250 Daba',35,0,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'1678','Shri/Amrakhand 500 Daba',140,1,'2','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'1675','Shri/Amrakhand 500poli',840,4,'14','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'1675','Suhana masala(Regular)',40,0,'1','Confectionery ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'1675','Sweet 200 (1kg)',200,1,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'1675','Sweet 200 (250gm)',100,0,'2','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'1675','Sweet 200 (500gm)',200,1,'2','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'1675','Sweet 400(125gm)',50,0,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'1623','Tomato sos',100,0,'1','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'1619','chocolate',480,2,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'1605','green peas 1kg',90,0,'1','Frozan',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'31','Paneer(500gm)',560,1,'4','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'7','Pani botal /Dahi pouch',530,1,'27','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'46','Parontha/ Nnan',300,1,'3','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'43','Shri/Amrakand 1kg poli',8260,20,'59','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'43','Shri/Amrakhand (250 gm)',400,1,'10','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'43','Shri/Amrakhand (500 gm)',320,1,'4','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'43','Shri/Amrakhand (Regular)',4960,12,'31','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'50','Sreekhnd/Amra 500gm pac',980,2,'14','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'50','Suhana masala(10gm)',20,0,'2','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'50','Suhana masala(50gm)',30,0,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'50','Suhana masala(regular)',240,1,'6','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'50','Sweet 280(250gm)',210,1,'3','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'50','Sweet 280(regular)',924,2,'3','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'50','Sweet 400(125gm)',50,0,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'50','Sweet 400(250gm)',200,1,'2','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'50','Sweet 400(500gm)',200,1,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'73','Sweet 800',200,1,'0','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'73','Tomato sos(Surbhi 1 kg)',140,0,'2','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'73','sause',120,0,'12','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'76','sause/pani',110,0,'11','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'25','Sweet 400(125gm)',50,0,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'25','Sweet 400(250gm)',300,1,'3','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'25','Sweet 400(500gm)',200,1,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'25','Sweet 560(500 gm)',280,1,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'74','culture',130,0,'2','Dairy',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'76','sause/pani',190,1,'19','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'76','sause/pani',110,0,'11','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'19','Sweet 560(125 gm)',70,0,'1','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'19','Sweet 800(125g)',200,0,'2','Sweet',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'19','Tomato Sos(Wingar)',70,0,'1','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'76','sause/pani',160,0,'16','RUNNING',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'None',480),(2,'branded foods',850),(3,'dals pulses',1250),(4,'fruits and vegetables',414),(5,'rice whole grains',280),(6,'Confectionery ',540),(7,'Dairy',560),(8,'Frozan',18),(9,'None',1200),(10,'branded foods',850),(11,'dals pulses',1250),(12,'fruits and vegetables',454),(13,'rice whole grains',280),(14,'Confectionery ',770),(15,'Dairy',860),(16,'Frozan',270),(20,'Confectionery ',770),(21,'Dairy',860),(22,'Frozan',270),(23,'Confectionery ',760),(24,'Dairy',860),(25,'Frozan',270),(26,'Dairy',30),(27,'Confectionery ',20),(28,'Dairy',1260),(29,'Frozan',180),(30,'Sweet',60),(35,'Confectionery ',110),(36,'Dairy',11159),(37,'Frozan',9365),(38,'Sweet',3445),(39,'RUNNING',495),(44,'Dairy',4050),(45,'Frozan',360),(46,'Running',10641),(47,'Sweet',160),(50,'Dairy',460),(51,'Running',5675),(52,'Dairy',780),(53,'Running',2560),(54,'Sweet',90),(55,'Dairy',460),(56,'RUNNING',90),(57,'Running',23395),(58,'Sweet',100),(59,'Dairy',100),(60,'Frozan',1200),(61,'RUNNING',90),(62,'Running',5557),(63,'Dairy',220),(64,'Frozan',360),(65,'RUNNING',90),(66,'Running',1763),(67,'Dairy',320),(68,'Frozan',460),(69,'RUNNING',180),(70,'Running',3873),(71,'Sweet',500),(72,'Dairy',800),(73,'Frozan',560),(74,'Running',1865),(75,'Dairy',690),(76,'Running',1890),(77,'Dairy',180),(78,'Frozan',720),(79,'Running',1810),(80,'Running',770),(81,'Frozan',360),(82,'Running',5405),(83,'Dairy',120),(84,'Frozan',360),(85,'Running',6665),(86,'Confectionery ',80),(87,'Running',3600),(88,'Sweet',120),(89,'Confectionery ',80),(90,'Running',3750),(91,'Sweet',120),(92,'Dairy',600),(93,'Frozan',200),(94,'Running',3310),(95,'Running',720),(96,'Frozan',500),(97,'Running',1440),(98,'Dairy',580),(99,'Running',3404),(100,'Dairy',240),(101,'Frozan',100),(102,'Running',3160),(103,'Dairy',120),(104,'Running',3275),(105,'Sweet',460),(106,'Dairy',120),(107,'Running',2060),(108,'Running',1120),(109,'Frozan',720),(110,'Running',1450),(111,'Sweet',100),(112,'Dairy',1560),(113,'Running',2030),(114,'Dairy',1200),(115,'Frozan',580),(116,'Running',4650),(117,'Dairy',120),(118,'Frozan',360),(119,'Running',3525),(120,'Sweet',1680),(121,'Running',4860),(122,'Running',7990),(123,'Sweet',410),(124,'Running',10260),(125,'Sweet',530),(126,'Frozan',360),(127,'Running',1850),(128,'Sweet',70),(129,'Running',410),(130,'Dairy',240),(131,'Running',1190),(132,'Dairy',240),(133,'Running',4759),(134,'Sweet',300),(135,'Dairy',240),(136,'Running',3740),(137,'Dairy',240),(138,'Running',3890),(139,'Sweet',9430),(140,'Dairy',720),(141,'Frozan',1020),(142,'Running',950),(143,'Dairy',50),(144,'Running',3130),(145,'Sweet',120),(146,'Dairy',50),(147,'Frozan',360),(148,'Running',3880),(149,'Sweet',120),(150,'Running',1875),(151,'Dairy',240),(152,'Frozan',420),(153,'Running',4766),(154,'Sweet',120),(155,'Running',5810),(156,'Dairy',120),(157,'Running',3760),(158,'Sweet',200),(159,'Dairy',120),(160,'Running',3280),(161,'Sweet',250),(162,'Dairy',120),(163,'Running',13290),(167,'Frozan',440),(168,'Running',9655),(169,'Sweet',80),(170,'Frozan',110),(171,'Running',2815),(172,'Sweet',80),(173,'Running',3151),(174,'Dairy',120),(175,'Running',2590),(176,'Frozan',360),(177,'Running',320),(178,'Dairy',155),(179,'Running',2370),(180,'Sweet',40),(181,'Dairy',240),(182,'Frozan',360),(183,'Running',1620),(184,'Running',3735),(185,'Dairy',400),(186,'Frozan',140),(187,'Running',13985),(188,'Frozan',440),(189,'Running',7560),(190,'Sweet',290),(191,'Dairy',100),(192,'Running',27440),(193,'Sweet',7200),(194,'Confectionery ',120),(195,'Dairy',240),(196,'Running',560),(197,'Sweet',435),(198,'Confectionery',230),(199,'Confectionery',375),(200,'RUNNING',1450),(201,'Dairy',30),(202,'RUNNING',1280),(203,'Dairy',120),(204,'Frozan',205),(205,'RUNNING',2690),(206,'Dairy',120),(207,'Frozan',205),(208,'RUNNING',3020),(209,'Dairy',1750),(210,'RUNNING',6105),(211,'Confectionery',100),(212,'Frozan',220),(213,'RUNNING',4130),(214,'Confectionery',100),(215,'Dairy',240),(216,'Frozan',220),(217,'RUNNING',4260),(218,'Confectionery',100),(219,'Dairy',240),(220,'Frozan',220),(221,'RUNNING',4655),(222,'Confectionery',100),(223,'Dairy',240),(224,'Frozan',220),(225,'RUNNING',4903),(226,'Confectionery',100),(227,'Dairy',1700),(228,'Frozan',200),(229,'RUNNING',7110),(230,'RUNNING',1040),(231,'Confectionery',255),(232,'RUNNING',7589),(233,'Confectionery',6600),(234,'RUNNING',3820),(235,'Confectionery',460),(236,'Frozan',365),(237,'RUNNING',16970),(238,'Confectionery',250),(239,'Dairy',8167),(240,'RUNNING',11270),(241,'Confectionery',250),(242,'Dairy',8167),(243,'RUNNING',11545),(244,'Confectionery',1310),(245,'Dairy',8973),(246,'Frozan',340),(247,'RUNNING',31212),(248,'Sweet',200),(249,'Confectionery',360),(250,'Frozan',580),(251,'RUNNING',17895),(252,'Sweet',200),(253,'Dairy',1920),(254,'Frozan',130),(255,'RUNNING',11168),(256,'RUNNING',10115),(257,'Sweet',180),(258,'Dairy',280),(259,'RUNNING',29433),(260,'Sweet',500),(261,'Dairy',60),(262,'RUNNING',14640),(263,'Sweet',90),(264,'Dairy',1101),(265,'Frozan',535),(266,'RUNNING',16331),(267,'Sweet',90),(268,'Dairy',295),(269,'Frozan',370),(270,'RUNNING',19222),(271,'Dairy',900),(272,'Frozan',130),(273,'RUNNING',33756),(274,'Sweet',90),(275,'Dairy',900),(276,'Frozan',130),(277,'RUNNING',48864),(278,'Sweet',90),(279,'Dairy',1958),(280,'RUNNING',42590),(281,'Sweet',280),(282,'Dairy',1680),(283,'RUNNING',46874),(284,'Dairy',1680),(285,'RUNNING',46874),(286,'Dairy',520),(287,'RUNNING',6785),(288,'Dairy',520),(289,'RUNNING',6785),(290,'Dairy',290),(291,'Frozan',680),(292,'RUNNING',7180),(293,'Sweet',96),(294,'Dairy',145),(295,'RUNNING',7550),(296,'Dairy',5340),(297,'RUNNING',35793),(298,'Sweet',90),(299,'Dairy',3740),(300,'Frozan',370),(301,'RUNNING',18100),(302,'Sweet',90),(303,'RUNNING',7890),(304,'Dairy',1126),(305,'Frozan',130),(306,'RUNNING',43413),(307,'Sweet',290),(308,'Frozan',680),(309,'RUNNING',24446),(310,'Dairy',1360),(311,'Frozan',690),(312,'RUNNING',25355),(313,'Dairy',1160),(314,'RUNNING',37365),(315,'Sweet',270),(316,'Dairy',465),(317,'Frozan',535),(318,'RUNNING',21501),(319,'Sweet',280),(320,'Confectionery',60),(321,'Dairy',630),(322,'Frozan',145),(323,'RUNNING',24929),(324,'Sweet',180),(325,'Confectionery',100),(326,'Dairy',966),(327,'Frozan',985),(328,'RUNNING',32565),(333,'Dairy',120),(334,'Frozan',270),(335,'RUNNING',19028),(336,'Sweet',90),(338,'RUNNING',23160),(339,'RUNNING',10855),(340,'Sweet',360),(341,'Dairy',1117),(342,'RUNNING',11500),(343,'Sweet',180),(344,'Dairy',820),(345,'Frozan',270),(346,'RUNNING',39931),(347,'Dairy',552),(348,'RUNNING',20640),(349,'Dairy',450),(350,'RUNNING',33673),(351,'Dairy',96),(352,'Frozan',270),(353,'RUNNING',21759),(354,'Sweet',250),(358,'Dairy',18),(359,'Frozan',60),(360,'RUNNING',13256),(361,'Dairy',68),(362,'Frozan',330),(363,'RUNNING',14026),(364,'Sweet',50),(365,'Dairy',86),(366,'Frozan',470),(367,'RUNNING',16486),(368,'Sweet',50),(369,'Confectionery',60),(370,'Dairy',724),(371,'Frozan',200),(372,'RUNNING',28785),(373,'Sweet',180),(374,'Dairy',1956),(375,'Frozan',340),(376,'RUNNING',23868),(377,'Dairy',640),(378,'Frozan',750),(379,'RUNNING',5630),(380,'Dairy',1120),(381,'Frozan',810),(382,'RUNNING',15710),(383,'Dairy',1150),(384,'Frozan',285),(385,'RUNNING',28766),(386,'Sweet',70),(387,'Dairy',545),(388,'Frozan',625),(389,'RUNNING',25770),(390,'RUNNING',15965),(391,'Dairy',120),(392,'RUNNING',26780),(393,'Sweet',96),(394,'Dairy',1470),(395,'RUNNING',33135),(396,'Sweet',96),(397,'Dairy',1470),(398,'RUNNING',33135),(399,'Sweet',96),(400,'Dairy',560),(401,'Frozan',402),(402,'RUNNING',10063),(403,'Sweet',180),(404,'Dairy',708),(405,'Frozan',340),(406,'RUNNING',27513),(407,'Sweet',260),(408,'Dairy',704),(409,'Frozan',1600),(410,'RUNNING',24934),(411,'Sweet',480),(412,'Dairy',90),(413,'Frozan',610),(414,'RUNNING',30231),(415,'Sweet',910),(416,'Dairy',1362),(417,'Frozan',1035),(418,'RUNNING',36928),(419,'Sweet',280),(420,'RUNNING',1045),(421,'Dairy',1270),(422,'Frozan',1020),(423,'RUNNING',3055),(424,'Dairy',575),(425,'Frozan',795),(426,'RUNNING',45546),(427,'Dairy',120),(428,'Frozan',695),(429,'RUNNING',13047),(430,'Sweet',160),(431,'Dairy',1390),(432,'Frozan',135),(433,'RUNNING',18023),(434,'Sweet',140),(435,'Dairy',1390),(436,'Frozan',135),(437,'RUNNING',19393),(438,'Sweet',140),(439,'Dairy',1390),(440,'Frozan',135),(441,'None',1030),(442,'RUNNING',20243),(443,'Sweet',140),(444,'Dairy',1390),(445,'Frozan',135),(446,'None',1030),(447,'RUNNING',20803),(448,'Sweet',140),(449,'Dairy',1990),(450,'Frozan',615),(451,'None',1030),(452,'RUNNING',29123),(453,'Sweet',340),(458,'Dairy',18),(459,'Frozan',825),(460,'RUNNING',24076),(461,'Sweet',490),(462,'Confectionery',100),(463,'Dairy',50),(464,'Frozan',334),(465,'RUNNING',15546),(466,'Sweet',620),(467,'Dairy',120),(468,'RUNNING',24155),(469,'Dairy',108),(470,'RUNNING',10705),(471,'Sweet',200),(472,'Frozan',150),(473,'RUNNING',22184),(474,'Dairy',120),(475,'Frozan',755),(476,'RUNNING',20280),(477,'Sweet',100),(478,'Dairy',626),(479,'Frozan',485),(480,'RUNNING',19095),(481,'Sweet',350),(482,'Dairy',626),(483,'Frozan',485),(484,'RUNNING',22744),(485,'Sweet',350),(486,'Dairy',810),(487,'Frozan',65),(488,'RUNNING',22590),(489,'Dairy',120),(490,'RUNNING',1980),(491,'Dairy',460),(492,'Frozan',910),(493,'RUNNING',17329),(494,'Sweet',230),(495,'Frozan',340),(496,'RUNNING',9180),(500,'Frozan',340),(501,'RUNNING',11855),(502,'Sweet',140),(503,'Dairy',708),(504,'Frozan',1025),(505,'RUNNING',30258),(506,'Sweet',140),(507,'RUNNING',9970),(508,'Sweet',90),(509,'RUNNING',480),(510,'Dairy',810),(511,'Frozan',200),(512,'RUNNING',17939),(513,'Dairy',1090),(514,'Frozan',200),(515,'RUNNING',19829),(516,'Dairy',1090),(517,'Frozan',200),(518,'RUNNING',20169),(519,'Dairy',156),(520,'Frozan',1115),(521,'RUNNING',32137),(522,'Dairy',156),(523,'Frozan',1115),(524,'RUNNING',35467),(525,'Dairy',1823),(526,'Frozan',620),(527,'RUNNING',27614),(528,'Sweet',370),(529,'Confectionery',1360),(530,'Dairy',1050),(531,'Frozan',1015),(532,'RUNNING',22774),(533,'Sweet',200),(534,'Dairy',480),(535,'RUNNING',1940),(536,'Dairy',1612),(537,'Frozan',125),(538,'RUNNING',22980),(539,'Sweet',600),(540,'Dairy',3040),(541,'Frozan',350),(542,'RUNNING',34420),(543,'Sweet',100),(544,'RUNNING',3235),(545,'Sweet',140),(548,'RUNNING',13320),(549,'Sweet',140),(550,'Dairy',2136),(551,'Frozan',1070),(552,'RUNNING',45264),(553,'Sweet',1020),(554,'Dairy',25),(555,'Frozan',680),(556,'RUNNING',7710),(557,'Dairy',307),(558,'Frozan',1050),(559,'RUNNING',20845),(560,'Sweet',600),(561,'Dairy',980),(562,'Frozan',532),(563,'RUNNING',24303),(564,'Sweet',400),(565,'Frozan',145),(566,'RUNNING',19473),(567,'Sweet',320),(568,'Dairy',1297),(569,'Frozan',495),(570,'RUNNING',28165),(571,'Sweet',420),(572,'Dairy',1297),(573,'Frozan',630),(574,'RUNNING',29145),(575,'Sweet',420),(576,'Dairy',2065),(577,'Frozan',970),(578,'RUNNING',26783),(579,'RUNNING',6775),(580,'Sweet',560),(585,'Dairy',240),(586,'Frozan',130),(587,'RUNNING',29115),(588,'Sweet',560),(592,'Frozan',202),(593,'RUNNING',25420),(594,'Sweet',90),(595,'Dairy',206),(596,'Frozan',925),(597,'RUNNING',37897),(598,'Sweet',90),(599,'Dairy',240),(600,'Frozan',120),(601,'RUNNING',11390),(602,'Sweet',100),(603,'Dairy',642),(604,'Frozan',1180),(605,'RUNNING',24065),(606,'Sweet',100),(607,'Dairy',1200),(608,'Frozan',340),(609,'RUNNING',32802),(610,'Sweet',150),(611,'Confectionery',60),(612,'Dairy',1660),(613,'Frozan',740),(614,'RUNNING',15877),(615,'Dairy',463),(616,'Frozan',145),(617,'RUNNING',9048),(618,'Sweet',260),(619,'Dairy',463),(620,'Frozan',145),(621,'RUNNING',9048),(622,'Sweet',260),(623,'Dairy',396),(624,'Frozan',515),(625,'RUNNING',10708),(626,'Sweet',250),(627,'Confectionery',150),(628,'Dairy',840),(629,'Frozan',425),(630,'RUNNING',11534),(631,'Sweet',100),(632,'Barcode',360),(633,'Dairy',918),(634,'Frozan',600),(635,'RUNNING',18386),(636,'Sweet',280),(637,'Confectionery',40),(638,'Dairy',108),(639,'Frozan',490),(640,'RUNNING',21570),(641,'Sweet',200),(642,'Dairy',800),(643,'RUNNING',3935),(644,'Dairy',800),(645,'Frozan',680),(646,'RUNNING',19135),(647,'Confectionery',140),(648,'Dairy',1963),(649,'Frozan',1245),(650,'RUNNING',40626),(651,'Sweet',140),(652,'Confectionery',200),(653,'Dairy',1120),(654,'Frozan',1005),(655,'RUNNING',39320),(656,'Sweet',690),(657,'Dairy',3270),(658,'Frozan',500),(659,'RUNNING',24070),(660,'Sweet',200),(661,'Dairy',3356),(662,'Frozan',570),(663,'RUNNING',34205),(664,'Sweet',340),(665,'Dairy',745),(666,'Frozan',1144),(667,'None',150),(668,'RUNNING',30078),(669,'Sweet',380),(670,'Dairy',831),(671,'Frozan',1214),(672,'None',240),(673,'RUNNING',34907),(674,'Sweet',1070),(675,'Dairy',268),(676,'RUNNING',17455),(677,'Confectionery',100),(678,'Dairy',764),(679,'Frozan',190),(680,'RUNNING',36676),(681,'Sweet',410),(682,'Confectionery',300),(683,'Dairy',414),(684,'Frozan',260),(685,'RUNNING',33785),(686,'Sweet',550),(687,'Dairy',192),(688,'Frozan',600),(689,'RUNNING',26640),(690,'Dairy',2613),(691,'Frozan',870),(692,'RUNNING',13347),(693,'Sweet',240),(694,'Dairy',2613),(695,'Frozan',870),(696,'RUNNING',27842),(697,'Sweet',420),(698,'Dairy',1401),(699,'Frozan',840),(700,'RUNNING',25536),(701,'Sweet',470),(707,'Confectionery',100),(708,'Dairy',731),(709,'Frozan',610),(710,'RUNNING',42035),(711,'Sweet',370),(712,'Confectionery',440),(713,'Dairy',2061),(714,'Frozan',815),(715,'RUNNING',56435),(716,'Sweet',750),(717,'Confectionery',320),(718,'Dairy',976),(719,'Frozan',70),(720,'RUNNING',23468),(721,'Sweet',770),(722,'Dairy',240),(723,'Frozan',720),(724,'None',180),(725,'RUNNING',29514),(726,'Sweet',200),(727,'Barcode',110),(728,'Dairy',595),(729,'Frozan',1190),(730,'None',540),(731,'RUNNING',47793),(732,'Sweet',910),(733,'Dairy',50),(734,'Frozan',1225),(735,'RUNNING',58385),(736,'Sweet',1180),(737,'Dairy',2400),(738,'RUNNING',24730),(739,'Sweet',720),(740,'Dairy',789),(741,'Frozan',180),(742,'RUNNING',21510),(743,'Sweet',280),(744,'Dairy',240),(745,'Frozan',340),(746,'RUNNING',1630),(747,'Dairy',490),(748,'Frozan',830),(749,'RUNNING',19302),(750,'Sweet',290),(751,'Dairy',283),(752,'Frozan',1420),(753,'RUNNING',24455),(754,'RUNNING',16557),(755,'Sweet',380),(756,'Barcode',120),(757,'Dairy',960),(758,'RUNNING',25767),(759,'Sweet',380),(760,'Dairy',2080),(761,'Frozan',505),(762,'None',90),(763,'RUNNING',61151),(764,'Sweet',870),(765,'Dairy',620),(766,'Frozan',265),(767,'RUNNING',22040),(768,'Sweet',1000),(769,'Dairy',4160),(770,'Frozan',1593),(771,'None',90),(772,'RUNNING',30185),(773,'Sweet',1230),(774,'Barcode',110),(775,'Dairy',1920),(776,'RUNNING',32740),(777,'Sweet',50),(778,'Barcode',230),(779,'Dairy',2578),(780,'RUNNING',46155),(781,'Sweet',50),(782,'Dairy',960),(783,'Frozan',1500),(784,'RUNNING',19740),(785,'Sweet',80),(786,'Dairy',960),(787,'Frozan',1645),(788,'RUNNING',24688),(789,'Sweet',310),(790,'Dairy',996),(791,'Frozan',1705),(792,'RUNNING',35291),(793,'Sweet',310),(794,'Dairy',996),(795,'Frozan',1705),(796,'RUNNING',35681),(797,'Sweet',310),(798,'Dairy',530),(799,'RUNNING',2480),(800,'Dairy',706),(801,'Frozan',135),(802,'RUNNING',40893),(803,'Sweet',70),(804,'Frozan',745),(805,'RUNNING',12840),(806,'Barcode',220),(807,'Dairy',1384),(808,'Frozan',260),(809,'RUNNING',30315),(810,'Dairy',624),(811,'Frozan',150),(812,'RUNNING',33325),(813,'Sweet',200),(814,'Dairy',2304),(815,'Frozan',150),(816,'RUNNING',36875),(817,'Sweet',380),(818,'Dairy',580),(819,'Frozan',62),(820,'RUNNING',38838),(821,'Sweet',3190),(822,'Barcode',110),(823,'Dairy',1100),(824,'Frozan',515),(825,'RUNNING',23650),(826,'Sweet',840),(827,'Barcode',110),(828,'Dairy',1100),(829,'Frozan',645),(830,'RUNNING',37615),(831,'Sweet',4160),(832,'RUNNING',2658),(833,'Sweet',120),(834,'Dairy',570),(835,'RUNNING',5960),(836,'RUNNING',14753),(837,'RUNNING',18503),(838,'Dairy',400),(839,'RUNNING',20015),(840,'Dairy',400),(841,'RUNNING',28210),(842,'Barcode',120),(843,'Dairy',280),(844,'RUNNING',13360),(845,'Barcode',120),(846,'Dairy',2735),(847,'Frozan',760),(848,'RUNNING',42343),(849,'Sweet',200),(850,'Dairy',3100),(851,'Frozan',275),(852,'RUNNING',14290),(853,'Sweet',200),(854,'Dairy',738),(855,'Frozan',75),(856,'RUNNING',15476),(857,'Barcode',110),(858,'Dairy',1060),(859,'Frozan',760),(860,'RUNNING',12975),(861,'Sweet',1180),(862,'RUNNING',1640),(863,'Dairy',826),(864,'Frozan',605),(865,'RUNNING',33748),(866,'Dairy',600),(867,'RUNNING',5405),(868,'Dairy',600),(869,'RUNNING',16455),(870,'Dairy',1872),(871,'RUNNING',24535),(872,'Sweet',225),(873,'Barcode',110),(874,'Dairy',960),(875,'RUNNING',4650),(876,'RUNNING',9670),(877,'Dairy',3580),(878,'RUNNING',8346),(879,'RUNNING',960),(880,'RUNNING',1900),(881,'Dairy',430),(882,'Frozan',145),(883,'RUNNING',17736),(884,'Sweet',100),(885,'Dairy',500),(886,'Frozan',145),(887,'RUNNING',19056),(888,'Sweet',100);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (1,'ok',1);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'ladmin',10);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',3274),(2,'ladmin',7145);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',3274,100),(2,'ladmin',7145,64);
