INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (145,'Changed mind',7),(146,'Changed mind',1),(148,'Changed mind',1),(149,'Changed mind',1),(150,'Changed mind',1),(151,'Changed mind',1),(152,'Changed mind',1),(153,'Changed mind',1),(154,'Changed mind',1),(155,'Changed mind',1),(156,'Changed mind',1),(158,'Changed mind',1),(159,'Changed mind',1),(160,'Changed mind',1),(162,'Changed mind',1),(163,'Changed mind',1),(164,'Changed mind',3),(165,'Changed mind',3),(166,'Changed mind',3),(167,'Changed mind',1),(168,'Changed mind',1),(169,'Changed mind',1),(170,'Changed mind',1),(171,'Changed mind',1),(173,'Changed mind',5),(174,'Changed mind',5),(176,'Changed mind',5),(177,'Changed mind',5),(178,'Changed mind',12),(180,'Changed mind',20),(181,'mis billed',1),(182,'Changed mind',20),(183,'mis billed',1),(184,'Changed mind',12),(186,'Changed mind',12),(188,'Changed mind',12),(189,'Changed mind',1),(190,'Changed mind',1),(191,'Changed mind',1),(192,'Changed mind',1),(193,'Changed mind',1),(194,'Changed mind',1),(195,'Changed mind',1),(196,'Changed mind',1),(197,'Changed mind',1),(198,'Changed mind',2),(199,'Changed mind',2),(200,'Changed mind',1),(204,'Changed mind',1),(205,'Changed mind',1),(207,'Changed mind',3),(208,'Changed mind',3),(209,'Changed mind',3),(210,'Changed mind',3),(211,'transport charges ',1),(212,'transport charges ',1),(213,'transport charges ',1),(214,'transport charges ',1),(218,'Changed mind',1),(220,'Changed mind',1),(221,'Changed mind',1),(222,'Changed mind',1),(223,'Changed mind',1),(224,'Changed mind',4),(225,'transport charges ',1),(232,'Changed mind',4),(233,'transport charges ',1),(236,'Changed mind',4),(237,'transport charges ',1),(238,'Changed mind',4),(239,'transport charges ',1),(242,'Changed mind',4),(243,'transport charges ',1),(244,'Changed mind',24),(245,'mis billed',1),(246,'transport charges ',1),(247,'Changed mind',1),(248,'Changed mind',1),(249,'Changed mind',1),(250,'Changed mind',1),(251,'Changed mind',1),(252,'Changed mind',1),(253,'Changed mind',1),(254,'Changed mind',1),(255,'Changed mind',1),(256,'Changed mind',3),(257,'Changed mind',3),(258,'Changed mind',3),(259,'Changed mind',3),(260,'Changed mind',4),(261,'Changed mind',4),(262,'Changed mind',4),(263,'Changed mind',4),(264,'Changed mind',4),(265,'Changed mind',5),(267,'Changed mind',5),(268,'Changed mind',5),(269,'Changed mind',5),(270,'Changed mind',1),(271,'Changed mind',1),(272,'Changed mind',1),(273,'Changed mind',1),(274,'Changed mind',1),(275,'Changed mind',1),(276,'Changed mind',1),(277,'Changed mind',1),(280,'Changed mind',1),(282,'Changed mind',1),(283,'Changed mind',1),(284,'Changed mind',1),(285,'Changed mind',1),(286,'Changed mind',1),(287,'Changed mind',1),(288,'Changed mind',1),(289,'Changed mind',1),(290,'Changed mind',1),(291,'Changed mind',3),(292,'Changed mind',3),(293,'Changed mind',3),(294,'Changed mind',3),(295,'Changed mind',3),(298,'Changed mind',4),(299,'Changed mind',1),(301,'Changed mind',4),(302,'Changed mind',1),(303,'Changed mind',1),(304,'Changed mind',1),(305,'Changed mind',4),(306,'Changed mind',33),(307,'mis billed',1),(308,'transport charges ',1),(309,'Changed mind',1),(310,'Changed mind',1),(311,'Changed mind',1),(312,'Changed mind',1),(315,'Changed mind',1),(317,'Changed mind',1),(319,'Changed mind',1),(320,'Changed mind',1),(321,'Changed mind',1),(322,'Changed mind',1),(324,'Changed mind',2),(326,'Changed mind',2),(327,'Changed mind',2),(328,'Changed mind',5),(329,'Changed mind',15),(330,'transport charges ',1),(342,'Changed mind',4),(343,'transport charges ',1),(344,'Changed mind',1),(345,'Changed mind',1),(346,'Changed mind',1),(347,'Changed mind',1),(348,'Changed mind',1),(349,'Changed mind',1),(350,'Changed mind',1),(351,'Changed mind',1),(352,'Accidental charge',1),(353,'Accidental charge',1),(360,'Accidental charge',1),(361,'Changed mind',1),(362,'Accidental charge',1),(363,'Changed mind',1),(364,'Accidental charge',1),(365,'Changed mind',1),(366,'Accidental charge',1),(367,'Changed mind',1),(368,'Accidental charge',1),(369,'Changed mind',1),(370,'Changed mind',1),(372,'Accidental charge',1),(373,'Changed mind',2),(374,'Changed mind',1),(375,'Changed mind',1),(379,'Changed mind',1),(380,'Changed mind',2),(381,'Changed mind',2),(382,'Changed mind',2),(383,'Changed mind',2),(384,'Changed mind',2),(386,'Accidental charge',1),(387,'Changed mind',4),(390,'Accidental charge',1),(391,'Changed mind',4),(392,'Accidental charge',1),(393,'Changed mind',4),(397,'Changed mind',5),(400,'Accidental charge',1),(401,'Changed mind',4),(406,'Changed mind',2),(407,'Changed mind',2),(408,'Accidental charge',1),(409,'Changed mind',4),(410,'Changed mind',1),(411,'Changed mind',1),(413,'Changed mind',1),(414,'Changed mind',1),(415,'Changed mind',1),(416,'Changed mind',1),(417,'Changed mind',1),(419,'Changed mind',1),(421,'Changed mind',1),(422,'Changed mind',1),(423,'Changed mind',1),(424,'Changed mind',1),(425,'Changed mind',2),(427,'Changed mind',2),(429,'Changed mind',2),(430,'Changed mind',3),(431,'Changed mind',1),(435,'Changed mind',1),(438,'Changed mind',1),(439,'Changed mind',1),(440,'Changed mind',1),(444,'Changed mind',1),(446,'Changed mind',1),(448,'Changed mind',1),(450,'Changed mind',5),(452,'Changed mind',3),(454,'Changed mind',1),(455,'Changed mind',1),(456,'Changed mind',1),(458,'Changed mind',3),(459,'Changed mind',1),(460,'Changed mind',1),(461,'Changed mind',1),(462,'Changed mind',1),(463,'Changed mind',1),(464,'Changed mind',1),(465,'Changed mind',1),(466,'Changed mind',1),(472,'Changed mind',3),(474,'Changed mind',6),(476,'Changed mind',6),(477,'Changed mind',1),(478,'Changed mind',1),(479,'Changed mind',2),(481,'Changed mind',2),(482,'Changed mind',2),(484,'Changed mind',2),(486,'Changed mind',2),(488,'Changed mind',1),(490,'Changed mind',1),(493,'Changed mind',1),(494,'Changed mind',1),(495,'Changed mind',2),(496,'Changed mind',2),(497,'Changed mind',2),(498,'Changed mind',2),(500,'Changed mind',2),(502,'Changed mind',2),(504,'Changed mind',2),(505,'Changed mind',1),(506,'Changed mind',1),(507,'Changed mind',1),(508,'Changed mind',1),(509,'Changed mind',1),(510,'Changed mind',2),(512,'Changed mind',2),(514,'Changed mind',2),(516,'Changed mind',2),(517,'Changed mind',2),(519,'Changed mind',1),(521,'Changed mind',1),(523,'Changed mind',1),(525,'Changed mind',1),(527,'Changed mind',1),(528,'Changed mind',1),(530,'Changed mind',1),(531,'Changed mind',1),(533,'Changed mind',1),(535,'Changed mind',1),(537,'Changed mind',1),(538,'Changed mind',1),(539,'Changed mind',1),(541,'Changed mind',2),(543,'Changed mind',2),(544,'Changed mind',1),(545,'Changed mind',1),(547,'Changed mind',1),(548,'Changed mind',1),(549,'Changed mind',1),(551,'Changed mind',1),(553,'Changed mind',1),(554,'Changed mind',1),(555,'Changed mind',1),(556,'Changed mind',1),(558,'Changed mind',1),(560,'Changed mind',1),(561,'Changed mind',1),(562,'Changed mind',1),(563,'Changed mind',1),(565,'Changed mind',1),(567,'Changed mind',1),(569,'Changed mind',1),(571,'Changed mind',1),(572,'Changed mind',2),(573,'Changed mind',2),(574,'Changed mind',2),(576,'Changed mind',2),(578,'Changed mind',2),(579,'Changed mind',2),(580,'Changed mind',2),(581,'Changed mind',1),(582,'Changed mind',1),(585,'Changed mind',1),(587,'Changed mind',1),(589,'Changed mind',1),(591,'Changed mind',1),(593,'Changed mind',1),(594,'Changed mind',1),(595,'Changed mind',1),(597,'Changed mind',1),(598,'Changed mind',1),(600,'Changed mind',1),(601,'Changed mind',3);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'ladmin',12955),(2,'user2',8363);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',50),(2,'user2',1040);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',50,100),(2,'Shashidhar ',1040,1);
INSERT INTO `write_off` (`_id`, `date`, `time`, `name`, `phoneno`, `write_off`) VALUES (17,'12 Aug 2023','06:06:15 pm','Prakash Kumar ','7676348740','0.0'),(18,'31 Jul 2023','05:55:58 pm','Arun','8217885018','0.0'),(19,'31 Jul 2023','11:01:14 am','Suresh','8762633454','0.0'),(20,'04 Aug 2023','06:53:30 pm','Adikrishna ','8951140997','0.0'),(21,'31 Jul 2023','04:56:19 pm','Naresh kumar','8970946143','0.0'),(22,'01 Aug 2023','05:45:44 pm','Narasimha ','8971595658','0.0'),(23,'01 Aug 2023','02:18:12 pm','Harish Dealer ','9036624840','0.0'),(24,'03 Aug 2023','02:10:36 pm','Rajashekhar ','9066943355','0.0'),(25,'31 Jul 2023','02:38:30 pm','Tejasvini ','9071000864','0.0'),(26,'31 Jul 2023','12:19:42 pm','Manjunath S.B','9448227673','0.0'),(27,'01 Aug 2023','10:59:32 am','Raghu ','9513639996','0.0'),(28,'05 Aug 2023','11:32:38 am','Manjunath V','9741000099','0.0'),(29,'31 Jul 2023','03:45:44 pm','Janardhan.H','9845069227','0.0'),(30,'31 Jul 2023','07:36:10 pm','Nagaraj ','9845131669','0.0'),(31,'10 Aug 2023','02:31:56 pm','Rigo water filtration ','9900017090','0.0'),(32,'03 Aug 2023','04:47:53 pm','prasanna','9972867101','0.0');
