{"userId":"243","date":"2021-01-24 11:21:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '182.77.47.138', '2021-01-24 11:21:45')"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE sitesupervision SET `siteid` = '1529', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '761'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE onssid = '3372'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE onssid = '3373'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE onssid = '3374'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE onssid = '3375'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79436 then '1' when ansid=79437 then '1' when ansid=79438 then '1' when ansid=79439 then '10' when ansid=79440 then '10' when ansid=79441 then '1' when ansid=79442 then '1' when ansid=79443 then '1' when ansid=79444 then '1' when ansid=79445 then '1' when ansid=79446 then '1' when ansid=79447 then '1' when ansid=79448 then '1' when ansid=79449 then '1' when ansid=79450 then '1' when ansid=79451 then '1' when ansid=79452 then '' when ansid=79453 then '' when ansid=79454 then '' when ansid=79455 then '' when ansid=79456 then '' when ansid=79457 then '' when ansid=79458 then '' when ansid=79459 then '' when ansid=79460 then '' when ansid=79461 then '' when ansid=79462 then '' when ansid=79463 then '' when ansid=79464 then '' when ansid=79465 then '' when ansid=79466 then '' when ansid=79467 then '' when ansid=79468 then '' when ansid=79469 then '' when ansid=79470 then '' when ansid=79471 then '' when ansid=79472 then '' when ansid=79473 then '' when ansid=79474 then '' when ansid=79475 then '' when ansid=79476 then '' when ansid=79477 then '' when ansid=79478 then '' when ansid=79479 then '' when ansid=79480 then '' when ansid=79481 then '' when ansid=79482 then '' when ansid=79483 then '' when ansid=79484 then '' when ansid=79485 then '' when ansid=79486 then '' when ansid=79487 then '' when ansid=79488 then '' when ansid=79489 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 11:22:29'\n\t\t\t\t\t\t\tWHERE ansid in ('79436','79437','79438','79439','79440','79441','79442','79443','79444','79445','79446','79447','79448','79449','79450','79451','79452','79453','79454','79455','79456','79457','79458','79459','79460','79461','79462','79463','79464','79465','79466','79467','79468','79469','79470','79471','79472','79473','79474','79475','79476','79477','79478','79479','79480','79481','79482','79483','79484','79485','79486','79487','79488','79489')"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE supvisstepid = '4854'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE visitfeedbackid = '3581'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE visitfeedbackid = '3582'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE visitfeedbackid = '3583'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE visitfeedbackid = '3584'"} {"userId":"243","date":"2021-01-24 11:22:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:22:29' WHERE visitfeedbackid = '3585'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE sitesupervision SET `siteid` = '1529', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '761'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE onssid = '3372'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE onssid = '3373'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE onssid = '3374'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE onssid = '3375'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79436 then '1' when ansid=79437 then '1' when ansid=79438 then '1' when ansid=79439 then '10' when ansid=79440 then '10' when ansid=79441 then '1' when ansid=79442 then '1' when ansid=79443 then '1' when ansid=79444 then '1' when ansid=79445 then '1' when ansid=79446 then '1' when ansid=79447 then '1' when ansid=79448 then '1' when ansid=79449 then '1' when ansid=79450 then '1' when ansid=79451 then '1' when ansid=79452 then '' when ansid=79453 then '' when ansid=79454 then '' when ansid=79455 then '' when ansid=79456 then '' when ansid=79457 then '' when ansid=79458 then '' when ansid=79459 then '' when ansid=79460 then '' when ansid=79461 then '' when ansid=79462 then '' when ansid=79463 then '' when ansid=79464 then '' when ansid=79465 then '' when ansid=79466 then '' when ansid=79467 then '' when ansid=79468 then '' when ansid=79469 then '' when ansid=79470 then '' when ansid=79471 then '' when ansid=79472 then '' when ansid=79473 then '' when ansid=79474 then '' when ansid=79475 then '' when ansid=79476 then '' when ansid=79477 then '' when ansid=79478 then '' when ansid=79479 then '' when ansid=79480 then '' when ansid=79481 then '' when ansid=79482 then '' when ansid=79483 then '' when ansid=79484 then '' when ansid=79485 then '' when ansid=79486 then '' when ansid=79487 then '' when ansid=79488 then '' when ansid=79489 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 11:26:24'\n\t\t\t\t\t\t\tWHERE ansid in ('79436','79437','79438','79439','79440','79441','79442','79443','79444','79445','79446','79447','79448','79449','79450','79451','79452','79453','79454','79455','79456','79457','79458','79459','79460','79461','79462','79463','79464','79465','79466','79467','79468','79469','79470','79471','79472','79473','79474','79475','79476','79477','79478','79479','79480','79481','79482','79483','79484','79485','79486','79487','79488','79489')"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE supvisstepid = '4853'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE visitfeedbackid = '3581'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE visitfeedbackid = '3582'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE visitfeedbackid = '3583'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE visitfeedbackid = '3584'"} {"userId":"243","date":"2021-01-24 11:26:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:24' WHERE visitfeedbackid = '3585'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE sitesupervision SET `siteid` = '1529', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '761'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE onssid = '3372'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE onssid = '3373'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE onssid = '3374'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE onssid = '3375'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79436 then '1' when ansid=79437 then '1' when ansid=79438 then '1' when ansid=79439 then '10' when ansid=79440 then '10' when ansid=79441 then '1' when ansid=79442 then '1' when ansid=79443 then '1' when ansid=79444 then '1' when ansid=79445 then '1' when ansid=79446 then '1' when ansid=79447 then '1' when ansid=79448 then '1' when ansid=79449 then '1' when ansid=79450 then '1' when ansid=79451 then '1' when ansid=79452 then '' when ansid=79453 then '' when ansid=79454 then '' when ansid=79455 then '' when ansid=79456 then '' when ansid=79457 then '' when ansid=79458 then '' when ansid=79459 then '' when ansid=79460 then '' when ansid=79461 then '' when ansid=79462 then '' when ansid=79463 then '' when ansid=79464 then '' when ansid=79465 then '' when ansid=79466 then '' when ansid=79467 then '' when ansid=79468 then '' when ansid=79469 then '' when ansid=79470 then '' when ansid=79471 then '' when ansid=79472 then '' when ansid=79473 then '' when ansid=79474 then '' when ansid=79475 then '' when ansid=79476 then '' when ansid=79477 then '' when ansid=79478 then '' when ansid=79479 then '' when ansid=79480 then '' when ansid=79481 then '' when ansid=79482 then '' when ansid=79483 then '' when ansid=79484 then '' when ansid=79485 then '' when ansid=79486 then '' when ansid=79487 then '' when ansid=79488 then '' when ansid=79489 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 11:26:56'\n\t\t\t\t\t\t\tWHERE ansid in ('79436','79437','79438','79439','79440','79441','79442','79443','79444','79445','79446','79447','79448','79449','79450','79451','79452','79453','79454','79455','79456','79457','79458','79459','79460','79461','79462','79463','79464','79465','79466','79467','79468','79469','79470','79471','79472','79473','79474','79475','79476','79477','79478','79479','79480','79481','79482','79483','79484','79485','79486','79487','79488','79489')"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE supvisstepid = '4854'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE visitfeedbackid = '3581'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE visitfeedbackid = '3582'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE visitfeedbackid = '3583'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE visitfeedbackid = '3584'"} {"userId":"243","date":"2021-01-24 11:26:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 11:26:56' WHERE visitfeedbackid = '3585'"} {"userId":"243","date":"2021-01-24 14:55:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '182.77.47.138', '2021-01-24 14:55:01')"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '762'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE onssid = '3376'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE onssid = '3377'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE onssid = '3378'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE onssid = '3379'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79490 then '' when ansid=79491 then '' when ansid=79492 then '' when ansid=79493 then '' when ansid=79494 then '' when ansid=79495 then '' when ansid=79496 then '' when ansid=79539 then '' when ansid=79541 then '' when ansid=79543 then '' when ansid=79545 then '' when ansid=79547 then '' when ansid=79549 then '' when ansid=79550 then '' when ansid=79551 then '' when ansid=79552 then '' when ansid=79553 then '' when ansid=79554 then '' when ansid=79555 then '' when ansid=79556 then '' when ansid=79557 then '' when ansid=79558 then '' when ansid=79559 then '' when ansid=79560 then '' when ansid=79561 then '' when ansid=79562 then '' when ansid=79563 then '' when ansid=79564 then '' when ansid=79565 then '' when ansid=79566 then '' when ansid=79567 then '' when ansid=79568 then '' when ansid=79569 then '' when ansid=79570 then '' when ansid=79571 then '' when ansid=79572 then '' when ansid=79573 then '' when ansid=79574 then '' when ansid=79575 then '' when ansid=79576 then '' when ansid=79577 then '' when ansid=79578 then '' when ansid=79579 then '' when ansid=79580 then '' when ansid=79581 then '' when ansid=79582 then '' when ansid=79583 then '' when ansid=79584 then '' when ansid=79585 then '' when ansid=79586 then '' when ansid=79587 then '' when ansid=79588 then '' when ansid=79589 then '' when ansid=79590 then '' when ansid=79591 then '' when ansid=79592 then '' when ansid=79593 then '' when ansid=79594 then '' when ansid=79595 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 14:55:38'\n\t\t\t\t\t\t\tWHERE ansid in ('79490','79491','79492','79493','79494','79495','79496','79539','79541','79543','79545','79547','79549','79550','79551','79552','79553','79554','79555','79556','79557','79558','79559','79560','79561','79562','79563','79564','79565','79566','79567','79568','79569','79570','79571','79572','79573','79574','79575','79576','79577','79578','79579','79580','79581','79582','79583','79584','79585','79586','79587','79588','79589','79590','79591','79592','79593','79594','79595')"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE supvisstepid = '4857'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE visitfeedbackid = '3586'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE visitfeedbackid = '3587'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE visitfeedbackid = '3588'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE visitfeedbackid = '3589'"} {"userId":"243","date":"2021-01-24 14:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:55:38' WHERE visitfeedbackid = '3590'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '762'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE onssid = '3376'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE onssid = '3377'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE onssid = '3378'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE onssid = '3379'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79490 then '1' when ansid=79491 then '1' when ansid=79492 then '1' when ansid=79493 then '' when ansid=79494 then '' when ansid=79495 then '1000' when ansid=79496 then '1' when ansid=79539 then '' when ansid=79541 then '' when ansid=79543 then '' when ansid=79545 then '' when ansid=79547 then '' when ansid=79549 then '' when ansid=79550 then '' when ansid=79551 then '' when ansid=79552 then '' when ansid=79553 then '' when ansid=79554 then '' when ansid=79555 then '' when ansid=79556 then '' when ansid=79557 then '' when ansid=79558 then '' when ansid=79559 then '' when ansid=79560 then '' when ansid=79561 then '' when ansid=79562 then '' when ansid=79563 then '' when ansid=79564 then '' when ansid=79565 then '' when ansid=79566 then '' when ansid=79567 then '' when ansid=79568 then '' when ansid=79569 then '' when ansid=79570 then '' when ansid=79571 then '' when ansid=79572 then '' when ansid=79573 then '' when ansid=79574 then '' when ansid=79575 then '' when ansid=79576 then '' when ansid=79577 then '' when ansid=79578 then '' when ansid=79579 then '' when ansid=79580 then '' when ansid=79581 then '' when ansid=79582 then '' when ansid=79583 then '' when ansid=79584 then '' when ansid=79585 then '' when ansid=79586 then '' when ansid=79587 then '' when ansid=79588 then '' when ansid=79589 then '' when ansid=79590 then '' when ansid=79591 then '' when ansid=79592 then '' when ansid=79593 then '' when ansid=79594 then '' when ansid=79595 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 14:56:22'\n\t\t\t\t\t\t\tWHERE ansid in ('79490','79491','79492','79493','79494','79495','79496','79539','79541','79543','79545','79547','79549','79550','79551','79552','79553','79554','79555','79556','79557','79558','79559','79560','79561','79562','79563','79564','79565','79566','79567','79568','79569','79570','79571','79572','79573','79574','79575','79576','79577','79578','79579','79580','79581','79582','79583','79584','79585','79586','79587','79588','79589','79590','79591','79592','79593','79594','79595')"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE supvisstepid = '4858'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE visitfeedbackid = '3586'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE visitfeedbackid = '3587'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE visitfeedbackid = '3588'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE visitfeedbackid = '3589'"} {"userId":"243","date":"2021-01-24 14:56:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:56:22' WHERE visitfeedbackid = '3590'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '762'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE onssid = '3376'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE onssid = '3377'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE onssid = '3378'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE onssid = '3379'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79490 then '1' when ansid=79491 then '1' when ansid=79492 then '1' when ansid=79493 then '' when ansid=79494 then '' when ansid=79495 then '1000' when ansid=79496 then '1' when ansid=79539 then '1' when ansid=79541 then '1' when ansid=79543 then '1' when ansid=79545 then '100' when ansid=79547 then '1' when ansid=79549 then '' when ansid=79550 then '' when ansid=79551 then '' when ansid=79552 then '' when ansid=79553 then '' when ansid=79554 then '' when ansid=79555 then '' when ansid=79556 then '' when ansid=79557 then '' when ansid=79558 then '' when ansid=79559 then '' when ansid=79560 then '' when ansid=79561 then '' when ansid=79562 then '' when ansid=79563 then '' when ansid=79564 then '' when ansid=79565 then '' when ansid=79566 then '' when ansid=79567 then '' when ansid=79568 then '' when ansid=79569 then '' when ansid=79570 then '' when ansid=79571 then '' when ansid=79572 then '' when ansid=79573 then '' when ansid=79574 then '' when ansid=79575 then '' when ansid=79576 then '' when ansid=79577 then '' when ansid=79578 then '' when ansid=79579 then '' when ansid=79580 then '' when ansid=79581 then '' when ansid=79582 then '' when ansid=79583 then '' when ansid=79584 then '' when ansid=79585 then '' when ansid=79586 then '' when ansid=79587 then '' when ansid=79588 then '' when ansid=79589 then '' when ansid=79590 then '' when ansid=79591 then '' when ansid=79592 then '' when ansid=79593 then '' when ansid=79594 then '' when ansid=79595 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 14:57:18'\n\t\t\t\t\t\t\tWHERE ansid in ('79490','79491','79492','79493','79494','79495','79496','79539','79541','79543','79545','79547','79549','79550','79551','79552','79553','79554','79555','79556','79557','79558','79559','79560','79561','79562','79563','79564','79565','79566','79567','79568','79569','79570','79571','79572','79573','79574','79575','79576','79577','79578','79579','79580','79581','79582','79583','79584','79585','79586','79587','79588','79589','79590','79591','79592','79593','79594','79595')"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE supvisstepid = '4859'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE visitfeedbackid = '3586'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE visitfeedbackid = '3587'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE visitfeedbackid = '3588'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE visitfeedbackid = '3589'"} {"userId":"243","date":"2021-01-24 14:57:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 14:57:18' WHERE visitfeedbackid = '3590'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '762'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE onssid = '3376'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE onssid = '3377'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE onssid = '3378'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE onssid = '3379'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79490 then '1' when ansid=79491 then '1' when ansid=79492 then '1' when ansid=79493 then '' when ansid=79494 then '' when ansid=79495 then '1000' when ansid=79496 then '1' when ansid=79539 then '1' when ansid=79541 then '1' when ansid=79543 then '1' when ansid=79545 then '100' when ansid=79547 then '1' when ansid=79549 then '1' when ansid=79550 then '1' when ansid=79551 then '1' when ansid=79552 then '1' when ansid=79553 then '' when ansid=79554 then '1' when ansid=79555 then '1' when ansid=79556 then '' when ansid=79557 then '1' when ansid=79558 then '' when ansid=79559 then '1' when ansid=79560 then '1' when ansid=79561 then '1' when ansid=79562 then '1' when ansid=79563 then '' when ansid=79564 then '1' when ansid=79565 then '' when ansid=79566 then '1' when ansid=79567 then '1' when ansid=79568 then '' when ansid=79569 then '1' when ansid=79570 then '1' when ansid=79571 then '1' when ansid=79572 then '1' when ansid=79573 then '1' when ansid=79574 then '1' when ansid=79575 then '1' when ansid=79576 then '1' when ansid=79577 then '1' when ansid=79578 then '1' when ansid=79579 then '' when ansid=79580 then '4' when ansid=79581 then '' when ansid=79582 then '1' when ansid=79583 then '1' when ansid=79584 then '1' when ansid=79585 then '' when ansid=79586 then '1' when ansid=79587 then '1' when ansid=79588 then '1' when ansid=79589 then '1' when ansid=79590 then '1' when ansid=79591 then '0' when ansid=79592 then 'nil' when ansid=79593 then 'nil' when ansid=79594 then 'nil' when ansid=79595 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 15:04:42'\n\t\t\t\t\t\t\tWHERE ansid in ('79490','79491','79492','79493','79494','79495','79496','79539','79541','79543','79545','79547','79549','79550','79551','79552','79553','79554','79555','79556','79557','79558','79559','79560','79561','79562','79563','79564','79565','79566','79567','79568','79569','79570','79571','79572','79573','79574','79575','79576','79577','79578','79579','79580','79581','79582','79583','79584','79585','79586','79587','79588','79589','79590','79591','79592','79593','79594','79595')"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE supvisstepid = '4860'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE visitfeedbackid = '3586'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE visitfeedbackid = '3587'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE visitfeedbackid = '3588'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE visitfeedbackid = '3589'"} {"userId":"243","date":"2021-01-24 15:04:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:04:42' WHERE visitfeedbackid = '3590'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '762'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE onssid = '3376'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE onssid = '3377'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE onssid = '3378'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE onssid = '3379'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79490 then '1' when ansid=79491 then '1' when ansid=79492 then '1' when ansid=79493 then '' when ansid=79494 then '' when ansid=79495 then '1000' when ansid=79496 then '1' when ansid=79539 then '1' when ansid=79541 then '1' when ansid=79543 then '1' when ansid=79545 then '100' when ansid=79547 then '1' when ansid=79549 then '1' when ansid=79550 then '1' when ansid=79551 then '1' when ansid=79552 then '1' when ansid=79553 then '' when ansid=79554 then '1' when ansid=79555 then '1' when ansid=79556 then '' when ansid=79557 then '1' when ansid=79558 then '' when ansid=79559 then '1' when ansid=79560 then '1' when ansid=79561 then '1' when ansid=79562 then '1' when ansid=79563 then '' when ansid=79564 then '1' when ansid=79565 then '' when ansid=79566 then '1' when ansid=79567 then '1' when ansid=79568 then '' when ansid=79569 then '1' when ansid=79570 then '1' when ansid=79571 then '1' when ansid=79572 then '1' when ansid=79573 then '1' when ansid=79574 then '1' when ansid=79575 then '1' when ansid=79576 then '1' when ansid=79577 then '1' when ansid=79578 then '1' when ansid=79579 then '' when ansid=79580 then '4' when ansid=79581 then '' when ansid=79582 then '1' when ansid=79583 then '1' when ansid=79584 then '1' when ansid=79585 then '' when ansid=79586 then '1' when ansid=79587 then '1' when ansid=79588 then '1' when ansid=79589 then '1' when ansid=79590 then '1' when ansid=79591 then '0' when ansid=79592 then 'nil' when ansid=79593 then 'nil' when ansid=79594 then 'nil' when ansid=79595 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 15:05:11'\n\t\t\t\t\t\t\tWHERE ansid in ('79490','79491','79492','79493','79494','79495','79496','79539','79541','79543','79545','79547','79549','79550','79551','79552','79553','79554','79555','79556','79557','79558','79559','79560','79561','79562','79563','79564','79565','79566','79567','79568','79569','79570','79571','79572','79573','79574','79575','79576','79577','79578','79579','79580','79581','79582','79583','79584','79585','79586','79587','79588','79589','79590','79591','79592','79593','79594','79595')"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE supvisstepid = '4861'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE visitfeedbackid = '3586'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE visitfeedbackid = '3587'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE visitfeedbackid = '3588'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE visitfeedbackid = '3589'"} {"userId":"243","date":"2021-01-24 15:05:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:05:11' WHERE visitfeedbackid = '3590'"} {"userId":"243","date":"2021-01-24 15:11:21","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1067', '2021-01-24', '243', '182.77.47.138', '243', '2021-01-24 15:11:21')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1067', '952', '243', '2021-01-24', '1', '182.77.47.138', '243', '2021-01-24 15:11:24', '', '')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('763', '0', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('763', '1', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('763', '2', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('763', '3', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('763', '', '', 'Array', '', 'Array', '', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('763', '', '', 'Array', '', 'Array', '', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('763', '', '', 'Array', '', 'Array', '', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('763', '', '', 'Array', '', 'Array', '', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:11:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('763', '182.77.47.138', '243', '2021-01-24 15:11:24')"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE sitesupervision SET `siteid` = '1067', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-24', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1000', `undertrialprisoners` = '1000' WHERE ssid = '763'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE onssid = '3380'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE onssid = '3381'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE onssid = '3382'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE onssid = '3383'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79642 then '' when ansid=79644 then '' when ansid=79646 then '' when ansid=79648 then '' when ansid=79650 then '' when ansid=79652 then '' when ansid=79653 then '' when ansid=79654 then '' when ansid=79655 then '' when ansid=79656 then '' when ansid=79657 then '' when ansid=79658 then '' when ansid=79659 then '' when ansid=79660 then '' when ansid=79661 then '' when ansid=79662 then '' when ansid=79663 then '' when ansid=79664 then '' when ansid=79665 then '' when ansid=79666 then '' when ansid=79667 then '' when ansid=79668 then '' when ansid=79669 then '' when ansid=79670 then '' when ansid=79671 then '' when ansid=79672 then '' when ansid=79673 then '' when ansid=79674 then '' when ansid=79675 then '' when ansid=79676 then '' when ansid=79677 then '' when ansid=79678 then '' when ansid=79679 then '' when ansid=79680 then '' when ansid=79681 then '' when ansid=79682 then '' when ansid=79683 then '' when ansid=79684 then '' when ansid=79685 then '' when ansid=79686 then '' when ansid=79687 then '' when ansid=79688 then '' when ansid=79689 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 15:12:42'\n\t\t\t\t\t\t\tWHERE ansid in ('79642','79644','79646','79648','79650','79652','79653','79654','79655','79656','79657','79658','79659','79660','79661','79662','79663','79664','79665','79666','79667','79668','79669','79670','79671','79672','79673','79674','79675','79676','79677','79678','79679','79680','79681','79682','79683','79684','79685','79686','79687','79688','79689')"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE supvisstepid = '4862'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE visitfeedbackid = '3592'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE visitfeedbackid = '3591'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE visitfeedbackid = '3593'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE visitfeedbackid = '3594'"} {"userId":"243","date":"2021-01-24 15:12:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:42' WHERE visitfeedbackid = '3595'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE sitesupervision SET `siteid` = '1067', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-24', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1000', `undertrialprisoners` = '1000' WHERE ssid = '763'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE onssid = '3380'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE onssid = '3381'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE onssid = '3382'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE onssid = '3383'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79642 then '' when ansid=79644 then '' when ansid=79646 then '' when ansid=79648 then '' when ansid=79650 then '' when ansid=79652 then '' when ansid=79653 then '' when ansid=79654 then '' when ansid=79655 then '' when ansid=79656 then '' when ansid=79657 then '' when ansid=79658 then '' when ansid=79659 then '' when ansid=79660 then '' when ansid=79661 then '' when ansid=79662 then '' when ansid=79663 then '' when ansid=79664 then '' when ansid=79665 then '' when ansid=79666 then '' when ansid=79667 then '' when ansid=79668 then '' when ansid=79669 then '' when ansid=79670 then '' when ansid=79671 then '' when ansid=79672 then '' when ansid=79673 then '' when ansid=79674 then '' when ansid=79675 then '' when ansid=79676 then '' when ansid=79677 then '' when ansid=79678 then '' when ansid=79679 then '' when ansid=79680 then '' when ansid=79681 then '' when ansid=79682 then '' when ansid=79683 then '' when ansid=79684 then '' when ansid=79685 then '' when ansid=79686 then '' when ansid=79687 then '' when ansid=79688 then '' when ansid=79689 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 15:12:59'\n\t\t\t\t\t\t\tWHERE ansid in ('79642','79644','79646','79648','79650','79652','79653','79654','79655','79656','79657','79658','79659','79660','79661','79662','79663','79664','79665','79666','79667','79668','79669','79670','79671','79672','79673','79674','79675','79676','79677','79678','79679','79680','79681','79682','79683','79684','79685','79686','79687','79688','79689')"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE supvisstepid = '4862'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE visitfeedbackid = '3592'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE visitfeedbackid = '3591'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE visitfeedbackid = '3593'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE visitfeedbackid = '3594'"} {"userId":"243","date":"2021-01-24 15:12:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:12:59' WHERE visitfeedbackid = '3595'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE sitesupervision SET `siteid` = '1067', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-24', `numofsamplecollected` = '100', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1000', `undertrialprisoners` = '1000' WHERE ssid = '763'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE onssid = '3380'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE onssid = '3381'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE onssid = '3382'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE onssid = '3383'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79642 then '1' when ansid=79644 then '1' when ansid=79646 then '1' when ansid=79648 then '100' when ansid=79650 then '1' when ansid=79652 then '' when ansid=79653 then '' when ansid=79654 then '' when ansid=79655 then '' when ansid=79656 then '' when ansid=79657 then '' when ansid=79658 then '' when ansid=79659 then '' when ansid=79660 then '' when ansid=79661 then '' when ansid=79662 then '' when ansid=79663 then '' when ansid=79664 then '' when ansid=79665 then '' when ansid=79666 then '' when ansid=79667 then '' when ansid=79668 then '' when ansid=79669 then '' when ansid=79670 then '' when ansid=79671 then '' when ansid=79672 then '' when ansid=79673 then '' when ansid=79674 then '' when ansid=79675 then '' when ansid=79676 then '' when ansid=79677 then '' when ansid=79678 then '' when ansid=79679 then '' when ansid=79680 then '' when ansid=79681 then '' when ansid=79682 then '' when ansid=79683 then '' when ansid=79684 then '' when ansid=79685 then '' when ansid=79686 then '' when ansid=79687 then '' when ansid=79688 then '' when ansid=79689 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.77.47.138',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-24 15:13:17'\n\t\t\t\t\t\t\tWHERE ansid in ('79642','79644','79646','79648','79650','79652','79653','79654','79655','79656','79657','79658','79659','79660','79661','79662','79663','79664','79665','79666','79667','79668','79669','79670','79671','79672','79673','79674','79675','79676','79677','79678','79679','79680','79681','79682','79683','79684','79685','79686','79687','79688','79689')"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE supvisstepid = '4863'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE visitfeedbackid = '3592'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE visitfeedbackid = '3591'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE visitfeedbackid = '3593'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE visitfeedbackid = '3594'"} {"userId":"243","date":"2021-01-24 15:13:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.77.47.138', `modifiedby` = '243', `modifieddate` = '2021-01-24 15:13:17' WHERE visitfeedbackid = '3595'"}