{"userId":"57","date":"2023-04-25 09:47:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '117.237.205.12', '2023-04-25 09:47:29')"} {"userId":"57","date":"2023-04-25 09:48:03","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('110', '2023-04-20', '57', '117.237.205.12', '57', '2023-04-25 09:48:03')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('110', '3296', '57', '2023-04-25', '1', '117.237.205.12', '57', '2023-04-25 09:48:07', '', '')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2831', '0', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2831', '1', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2831', '2', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2831', '3', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2831', '4', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2831', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2831', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2831', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2831', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:48:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2831', '117.237.205.12', '57', '2023-04-25 09:48:07')"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-04', `numofsamplecollected` = '53', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2831'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Soreingam', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Did not get proper training but received online training by SACS official.', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE onssid = '11652'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE onsitestaffs SET `staffname` = 'Ningtipla', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE onssid = '11653'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE onsitestaffs SET `staffname` = 'Valleyros', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE onssid = '11654'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE onssid = '11655'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268411 then '' when ansid=268412 then '' when ansid=268413 then '' when ansid=268414 then '' when ansid=268415 then '' when ansid=268416 then '' when ansid=268417 then '' when ansid=268517 then '' when ansid=268518 then '' when ansid=268460 then '' when ansid=268462 then '' when ansid=268464 then '' when ansid=268466 then '' when ansid=268468 then '' when ansid=268470 then '' when ansid=268471 then '' when ansid=268472 then '' when ansid=268473 then '' when ansid=268474 then '' when ansid=268475 then '' when ansid=268476 then '' when ansid=268477 then '' when ansid=268478 then '' when ansid=268479 then '' when ansid=268480 then '' when ansid=268481 then '' when ansid=268482 then '' when ansid=268483 then '' when ansid=268484 then '' when ansid=268485 then '' when ansid=268486 then '' when ansid=268487 then '' when ansid=268488 then '' when ansid=268489 then '' when ansid=268490 then '' when ansid=268491 then '' when ansid=268492 then '' when ansid=268493 then '' when ansid=268494 then '' when ansid=268495 then '' when ansid=268496 then '' when ansid=268497 then '' when ansid=268498 then '' when ansid=268499 then '' when ansid=268500 then '' when ansid=268501 then '' when ansid=268502 then '' when ansid=268503 then '' when ansid=268504 then '' when ansid=268505 then '' when ansid=268506 then '' when ansid=268507 then '' when ansid=268508 then '' when ansid=268509 then '' when ansid=268510 then '' when ansid=268511 then '' when ansid=268512 then '' when ansid=268513 then '' when ansid=268514 then '' when ansid=268515 then '' when ansid=268516 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 09:53:47'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268411','268412','268413','268414','268415','268416','268417','268517','268518','268460','268462','268464','268466','268468','268470','268471','268472','268473','268474','268475','268476','268477','268478','268479','268480','268481','268482','268483','268484','268485','268486','268487','268488','268489','268490','268491','268492','268493','268494','268495','268496','268497','268498','268499','268500','268501','268502','268503','268504','268505','268506','268507','268508','268509','268510','268511','268512','268513','268514','268515','268516')"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE supvisstepid = '13956'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE visitfeedbackid = '13931'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE visitfeedbackid = '13932'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE visitfeedbackid = '13933'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE visitfeedbackid = '13934'"} {"userId":"57","date":"2023-04-25 09:53:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:53:47' WHERE visitfeedbackid = '13935'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-04', `numofsamplecollected` = '53', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2831'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Soreingam', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Did not get proper training but received online training by SACS official.', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE onssid = '11652'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Ningtipla', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE onssid = '11653'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Valleyros', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE onssid = '11654'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE onssid = '11655'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268411 then '1' when ansid=268412 then '1' when ansid=268413 then '1' when ansid=268414 then '' when ansid=268415 then '' when ansid=268416 then '90' when ansid=268417 then '1' when ansid=268517 then '1' when ansid=268518 then '1' when ansid=268460 then '' when ansid=268462 then '' when ansid=268464 then '' when ansid=268466 then '' when ansid=268468 then '' when ansid=268470 then '' when ansid=268471 then '' when ansid=268472 then '' when ansid=268473 then '' when ansid=268474 then '' when ansid=268475 then '' when ansid=268476 then '' when ansid=268477 then '' when ansid=268478 then '' when ansid=268479 then '' when ansid=268480 then '' when ansid=268481 then '' when ansid=268482 then '' when ansid=268483 then '' when ansid=268484 then '' when ansid=268485 then '' when ansid=268486 then '' when ansid=268487 then '' when ansid=268488 then '' when ansid=268489 then '' when ansid=268490 then '' when ansid=268491 then '' when ansid=268492 then '' when ansid=268493 then '' when ansid=268494 then '' when ansid=268495 then '' when ansid=268496 then '' when ansid=268497 then '' when ansid=268498 then '' when ansid=268499 then '' when ansid=268500 then '' when ansid=268501 then '' when ansid=268502 then '' when ansid=268503 then '' when ansid=268504 then '' when ansid=268505 then '' when ansid=268506 then '' when ansid=268507 then '' when ansid=268508 then '' when ansid=268509 then '' when ansid=268510 then '' when ansid=268511 then '' when ansid=268512 then '' when ansid=268513 then '' when ansid=268514 then '' when ansid=268515 then '' when ansid=268516 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 09:54:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268411','268412','268413','268414','268415','268416','268417','268517','268518','268460','268462','268464','268466','268468','268470','268471','268472','268473','268474','268475','268476','268477','268478','268479','268480','268481','268482','268483','268484','268485','268486','268487','268488','268489','268490','268491','268492','268493','268494','268495','268496','268497','268498','268499','268500','268501','268502','268503','268504','268505','268506','268507','268508','268509','268510','268511','268512','268513','268514','268515','268516')"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE supvisstepid = '13957'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE visitfeedbackid = '13931'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE visitfeedbackid = '13932'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE visitfeedbackid = '13933'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE visitfeedbackid = '13934'"} {"userId":"57","date":"2023-04-25 09:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:32' WHERE visitfeedbackid = '13935'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-04', `numofsamplecollected` = '53', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2831'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Soreingam', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Did not get proper training but received online training by SACS official.', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE onssid = '11652'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE onsitestaffs SET `staffname` = 'Ningtipla', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE onssid = '11653'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE onsitestaffs SET `staffname` = 'Valleyros', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE onssid = '11654'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE onssid = '11655'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268411 then '1' when ansid=268412 then '1' when ansid=268413 then '1' when ansid=268414 then '' when ansid=268415 then '' when ansid=268416 then '90' when ansid=268417 then '1' when ansid=268517 then '1' when ansid=268518 then '1' when ansid=268460 then '1' when ansid=268462 then '1' when ansid=268464 then '1' when ansid=268466 then '3' when ansid=268468 then '5' when ansid=268470 then '' when ansid=268471 then '' when ansid=268472 then '' when ansid=268473 then '' when ansid=268474 then '' when ansid=268475 then '' when ansid=268476 then '' when ansid=268477 then '' when ansid=268478 then '' when ansid=268479 then '' when ansid=268480 then '' when ansid=268481 then '' when ansid=268482 then '' when ansid=268483 then '' when ansid=268484 then '' when ansid=268485 then '' when ansid=268486 then '' when ansid=268487 then '' when ansid=268488 then '' when ansid=268489 then '' when ansid=268490 then '' when ansid=268491 then '' when ansid=268492 then '' when ansid=268493 then '' when ansid=268494 then '' when ansid=268495 then '' when ansid=268496 then '' when ansid=268497 then '' when ansid=268498 then '' when ansid=268499 then '' when ansid=268500 then '' when ansid=268501 then '' when ansid=268502 then '' when ansid=268503 then '' when ansid=268504 then '' when ansid=268505 then '' when ansid=268506 then '' when ansid=268507 then '' when ansid=268508 then '' when ansid=268509 then '' when ansid=268510 then '' when ansid=268511 then '' when ansid=268512 then '' when ansid=268513 then '' when ansid=268514 then '' when ansid=268515 then '' when ansid=268516 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 09:54:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268411','268412','268413','268414','268415','268416','268417','268517','268518','268460','268462','268464','268466','268468','268470','268471','268472','268473','268474','268475','268476','268477','268478','268479','268480','268481','268482','268483','268484','268485','268486','268487','268488','268489','268490','268491','268492','268493','268494','268495','268496','268497','268498','268499','268500','268501','268502','268503','268504','268505','268506','268507','268508','268509','268510','268511','268512','268513','268514','268515','268516')"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE supvisstepid = '13958'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE visitfeedbackid = '13931'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE visitfeedbackid = '13932'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE visitfeedbackid = '13933'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE visitfeedbackid = '13934'"} {"userId":"57","date":"2023-04-25 09:54:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:54:42' WHERE visitfeedbackid = '13935'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-04', `numofsamplecollected` = '53', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2831'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Soreingam', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Did not get proper training but received online training by SACS official.', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE onssid = '11652'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE onsitestaffs SET `staffname` = 'Ningtipla', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE onssid = '11653'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE onsitestaffs SET `staffname` = 'Valleyros', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE onssid = '11654'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE onssid = '11655'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268411 then '1' when ansid=268412 then '1' when ansid=268413 then '1' when ansid=268414 then '' when ansid=268415 then '' when ansid=268416 then '90' when ansid=268417 then '1' when ansid=268517 then '1' when ansid=268518 then '1' when ansid=268460 then '1' when ansid=268462 then '1' when ansid=268464 then '1' when ansid=268466 then '3' when ansid=268468 then '5' when ansid=268470 then '3' when ansid=268471 then '19' when ansid=268472 then '109' when ansid=268473 then '31' when ansid=268474 then '' when ansid=268475 then '1' when ansid=268476 then '1' when ansid=268477 then '' when ansid=268478 then '1' when ansid=268479 then '' when ansid=268480 then '1' when ansid=268481 then '5' when ansid=268482 then '1' when ansid=268483 then '1' when ansid=268484 then 'Counsellor' when ansid=268485 then '1' when ansid=268486 then '' when ansid=268487 then '1' when ansid=268488 then '1' when ansid=268489 then '' when ansid=268490 then '1' when ansid=268491 then '4' when ansid=268492 then '1' when ansid=268493 then '1' when ansid=268494 then '1' when ansid=268495 then '1' when ansid=268496 then '2' when ansid=268497 then '1' when ansid=268498 then '1' when ansid=268499 then '1' when ansid=268500 then '' when ansid=268501 then '3' when ansid=268502 then '' when ansid=268503 then '1' when ansid=268504 then '1' when ansid=268505 then '1' when ansid=268506 then '' when ansid=268507 then '1' when ansid=268508 then '1' when ansid=268509 then '1' when ansid=268510 then '1' when ansid=268511 then '1' when ansid=268512 then '0' when ansid=268513 then 'NIL' when ansid=268514 then 'Yes, SST Member' when ansid=268515 then 'A few blank forms were signed by the Site incharge.' when ansid=268516 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 09:58:07'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268411','268412','268413','268414','268415','268416','268417','268517','268518','268460','268462','268464','268466','268468','268470','268471','268472','268473','268474','268475','268476','268477','268478','268479','268480','268481','268482','268483','268484','268485','268486','268487','268488','268489','268490','268491','268492','268493','268494','268495','268496','268497','268498','268499','268500','268501','268502','268503','268504','268505','268506','268507','268508','268509','268510','268511','268512','268513','268514','268515','268516')"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE supvisstepid = '13959'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE visitfeedbackid = '13931'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE visitfeedbackid = '13932'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE visitfeedbackid = '13933'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE visitfeedbackid = '13934'"} {"userId":"57","date":"2023-04-25 09:58:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 09:58:07' WHERE visitfeedbackid = '13935'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-04', `numofsamplecollected` = '53', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2831'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Soreingam', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Did not get proper training but received online training by SACS official.', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE onssid = '11652'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE onsitestaffs SET `staffname` = 'Ningtipla', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE onssid = '11653'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE onsitestaffs SET `staffname` = 'Valleyros', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE onssid = '11654'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE onssid = '11655'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268411 then '1' when ansid=268412 then '1' when ansid=268413 then '1' when ansid=268414 then '' when ansid=268415 then '' when ansid=268416 then '90' when ansid=268417 then '1' when ansid=268517 then '1' when ansid=268518 then '1' when ansid=268460 then '1' when ansid=268462 then '1' when ansid=268464 then '1' when ansid=268466 then '3' when ansid=268468 then '5' when ansid=268470 then '3' when ansid=268471 then '19' when ansid=268472 then '109' when ansid=268473 then '31' when ansid=268474 then '' when ansid=268475 then '1' when ansid=268476 then '1' when ansid=268477 then '' when ansid=268478 then '1' when ansid=268479 then '' when ansid=268480 then '1' when ansid=268481 then '5' when ansid=268482 then '1' when ansid=268483 then '1' when ansid=268484 then 'Counsellor' when ansid=268485 then '1' when ansid=268486 then '' when ansid=268487 then '1' when ansid=268488 then '1' when ansid=268489 then '' when ansid=268490 then '1' when ansid=268491 then '4' when ansid=268492 then '1' when ansid=268493 then '1' when ansid=268494 then '1' when ansid=268495 then '1' when ansid=268496 then '2' when ansid=268497 then '1' when ansid=268498 then '1' when ansid=268499 then '1' when ansid=268500 then '' when ansid=268501 then '3' when ansid=268502 then '' when ansid=268503 then '1' when ansid=268504 then '1' when ansid=268505 then '1' when ansid=268506 then '' when ansid=268507 then '1' when ansid=268508 then '1' when ansid=268509 then '1' when ansid=268510 then '1' when ansid=268511 then '1' when ansid=268512 then '0' when ansid=268513 then 'NIL' when ansid=268514 then 'Yes, SST Member' when ansid=268515 then 'A few blank forms were signed by the Site incharge.' when ansid=268516 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 10:03:48'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268411','268412','268413','268414','268415','268416','268417','268517','268518','268460','268462','268464','268466','268468','268470','268471','268472','268473','268474','268475','268476','268477','268478','268479','268480','268481','268482','268483','268484','268485','268486','268487','268488','268489','268490','268491','268492','268493','268494','268495','268496','268497','268498','268499','268500','268501','268502','268503','268504','268505','268506','268507','268508','268509','268510','268511','268512','268513','268514','268515','268516')"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE supvisstepid = '13960'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE visitfeedback SET `feedback` = 'Counsellor and Lab technician have adequate knowledge about HSS activities.', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE visitfeedbackid = '13931'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE visitfeedback SET `feedback` = 'A few blank forms were signed by the Site incharge. It was advised to avoid such practices.', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE visitfeedbackid = '13932'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE visitfeedback SET `feedback` = 'Sentinel Site incharge did not receive any formal training about HSS plus activities. An onsite discussion was done about SOP for ANC site activities. However, he has knowledge about eligibility criteria and consecutive random sampling.', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE visitfeedbackid = '13933'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE visitfeedbackid = '13934'"} {"userId":"57","date":"2023-04-25 10:03:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:03:48' WHERE visitfeedbackid = '13935'"} {"userId":"57","date":"2023-04-25 10:50:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '117.237.205.12', '2023-04-25 10:50:57')"} {"userId":"57","date":"2023-04-25 10:51:41","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('111', '2023-04-20', '57', '117.237.205.12', '57', '2023-04-25 10:51:41')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('111', '3297', '57', '2023-04-25', '1', '117.237.205.12', '57', '2023-04-25 10:51:48', '', '')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2832', '0', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2832', '1', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2832', '2', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2832', '3', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2832', '4', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2832', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2832', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2832', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2832', '', '', 'Array', '', 'Array', '', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:51:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2832', '117.237.205.12', '57', '2023-04-25 10:51:48')"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '' when ansid=268520 then '' when ansid=268521 then '' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '' when ansid=268525 then '' when ansid=268625 then '' when ansid=268626 then '' when ansid=268568 then '' when ansid=268570 then '' when ansid=268572 then '' when ansid=268574 then '' when ansid=268576 then '' when ansid=268578 then '' when ansid=268579 then '' when ansid=268580 then '' when ansid=268581 then '' when ansid=268582 then '' when ansid=268583 then '' when ansid=268584 then '' when ansid=268585 then '' when ansid=268586 then '' when ansid=268587 then '' when ansid=268588 then '' when ansid=268589 then '' when ansid=268590 then '' when ansid=268591 then '' when ansid=268592 then '' when ansid=268593 then '' when ansid=268594 then '' when ansid=268595 then '' when ansid=268596 then '' when ansid=268597 then '' when ansid=268598 then '' when ansid=268599 then '' when ansid=268600 then '' when ansid=268601 then '' when ansid=268602 then '' when ansid=268603 then '' when ansid=268604 then '' when ansid=268605 then '' when ansid=268606 then '' when ansid=268607 then '' when ansid=268608 then '' when ansid=268609 then '' when ansid=268610 then '' when ansid=268611 then '' when ansid=268612 then '' when ansid=268613 then '' when ansid=268614 then '' when ansid=268615 then '' when ansid=268616 then '' when ansid=268617 then '' when ansid=268618 then '' when ansid=268619 then '' when ansid=268620 then '' when ansid=268621 then '' when ansid=268622 then '' when ansid=268623 then '' when ansid=268624 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 10:54:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE supvisstepid = '13961'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 10:54:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:54:32' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '' when ansid=268570 then '' when ansid=268572 then '' when ansid=268574 then '' when ansid=268576 then '' when ansid=268578 then '' when ansid=268579 then '' when ansid=268580 then '' when ansid=268581 then '' when ansid=268582 then '' when ansid=268583 then '' when ansid=268584 then '' when ansid=268585 then '' when ansid=268586 then '' when ansid=268587 then '' when ansid=268588 then '' when ansid=268589 then '' when ansid=268590 then '' when ansid=268591 then '' when ansid=268592 then '' when ansid=268593 then '' when ansid=268594 then '' when ansid=268595 then '' when ansid=268596 then '' when ansid=268597 then '' when ansid=268598 then '' when ansid=268599 then '' when ansid=268600 then '' when ansid=268601 then '' when ansid=268602 then '' when ansid=268603 then '' when ansid=268604 then '' when ansid=268605 then '' when ansid=268606 then '' when ansid=268607 then '' when ansid=268608 then '' when ansid=268609 then '' when ansid=268610 then '' when ansid=268611 then '' when ansid=268612 then '' when ansid=268613 then '' when ansid=268614 then '' when ansid=268615 then '' when ansid=268616 then '' when ansid=268617 then '' when ansid=268618 then '' when ansid=268619 then '' when ansid=268620 then '' when ansid=268621 then '' when ansid=268622 then '' when ansid=268623 then '' when ansid=268624 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 10:55:14'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE supvisstepid = '13962'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 10:55:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:14' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '1' when ansid=268570 then '1' when ansid=268572 then '1' when ansid=268574 then '3' when ansid=268576 then '5' when ansid=268578 then '' when ansid=268579 then '' when ansid=268580 then '' when ansid=268581 then '' when ansid=268582 then '' when ansid=268583 then '' when ansid=268584 then '' when ansid=268585 then '' when ansid=268586 then '' when ansid=268587 then '' when ansid=268588 then '' when ansid=268589 then '' when ansid=268590 then '' when ansid=268591 then '' when ansid=268592 then '' when ansid=268593 then '' when ansid=268594 then '' when ansid=268595 then '' when ansid=268596 then '' when ansid=268597 then '' when ansid=268598 then '' when ansid=268599 then '' when ansid=268600 then '' when ansid=268601 then '' when ansid=268602 then '' when ansid=268603 then '' when ansid=268604 then '' when ansid=268605 then '' when ansid=268606 then '' when ansid=268607 then '' when ansid=268608 then '' when ansid=268609 then '' when ansid=268610 then '' when ansid=268611 then '' when ansid=268612 then '' when ansid=268613 then '' when ansid=268614 then '' when ansid=268615 then '' when ansid=268616 then '' when ansid=268617 then '' when ansid=268618 then '' when ansid=268619 then '' when ansid=268620 then '' when ansid=268621 then '' when ansid=268622 then '' when ansid=268623 then '' when ansid=268624 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 10:55:26'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE supvisstepid = '13963'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 10:55:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 10:55:26' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '1' when ansid=268570 then '1' when ansid=268572 then '1' when ansid=268574 then '3' when ansid=268576 then '5' when ansid=268578 then '' when ansid=268579 then '' when ansid=268580 then '' when ansid=268581 then '' when ansid=268582 then '' when ansid=268583 then '' when ansid=268584 then '' when ansid=268585 then '' when ansid=268586 then '' when ansid=268587 then '' when ansid=268588 then '' when ansid=268589 then '' when ansid=268590 then '' when ansid=268591 then '' when ansid=268592 then '' when ansid=268593 then '' when ansid=268594 then '' when ansid=268595 then '' when ansid=268596 then '' when ansid=268597 then '' when ansid=268598 then '' when ansid=268599 then '' when ansid=268600 then '' when ansid=268601 then '' when ansid=268602 then '' when ansid=268603 then '' when ansid=268604 then '' when ansid=268605 then '' when ansid=268606 then '' when ansid=268607 then '' when ansid=268608 then '' when ansid=268609 then '' when ansid=268610 then '' when ansid=268611 then '' when ansid=268612 then '' when ansid=268613 then '' when ansid=268614 then '' when ansid=268615 then '' when ansid=268616 then '' when ansid=268617 then '' when ansid=268618 then '' when ansid=268619 then '' when ansid=268620 then '' when ansid=268621 then '' when ansid=268622 then '' when ansid=268623 then '' when ansid=268624 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 11:05:03'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE supvisstepid = '13962'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 11:05:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:03' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '1' when ansid=268570 then '1' when ansid=268572 then '1' when ansid=268574 then '3' when ansid=268576 then '5' when ansid=268578 then '' when ansid=268579 then '' when ansid=268580 then '' when ansid=268581 then '' when ansid=268582 then '' when ansid=268583 then '' when ansid=268584 then '' when ansid=268585 then '' when ansid=268586 then '' when ansid=268587 then '' when ansid=268588 then '' when ansid=268589 then '' when ansid=268590 then '' when ansid=268591 then '' when ansid=268592 then '' when ansid=268593 then '' when ansid=268594 then '' when ansid=268595 then '' when ansid=268596 then '' when ansid=268597 then '' when ansid=268598 then '' when ansid=268599 then '' when ansid=268600 then '' when ansid=268601 then '' when ansid=268602 then '' when ansid=268603 then '' when ansid=268604 then '' when ansid=268605 then '' when ansid=268606 then '' when ansid=268607 then '' when ansid=268608 then '' when ansid=268609 then '' when ansid=268610 then '' when ansid=268611 then '' when ansid=268612 then '' when ansid=268613 then '' when ansid=268614 then '' when ansid=268615 then '' when ansid=268616 then '' when ansid=268617 then '' when ansid=268618 then '' when ansid=268619 then '' when ansid=268620 then '' when ansid=268621 then '' when ansid=268622 then '' when ansid=268623 then '' when ansid=268624 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 11:05:08'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE supvisstepid = '13961'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 11:05:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:05:08' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '1' when ansid=268570 then '1' when ansid=268572 then '1' when ansid=268574 then '3' when ansid=268576 then '5' when ansid=268578 then '0' when ansid=268579 then '12' when ansid=268580 then '61' when ansid=268581 then '7' when ansid=268582 then '' when ansid=268583 then '1' when ansid=268584 then '1' when ansid=268585 then '' when ansid=268586 then '1' when ansid=268587 then '' when ansid=268588 then '1' when ansid=268589 then '3' when ansid=268590 then '1' when ansid=268591 then '1' when ansid=268592 then 'Counsellor' when ansid=268593 then '1' when ansid=268594 then '' when ansid=268595 then '1' when ansid=268596 then '1' when ansid=268597 then '' when ansid=268598 then '1' when ansid=268599 then '4' when ansid=268600 then '1' when ansid=268601 then '1' when ansid=268602 then '1' when ansid=268603 then '1' when ansid=268604 then '2' when ansid=268605 then '1' when ansid=268606 then '1' when ansid=268607 then '1' when ansid=268608 then '' when ansid=268609 then '3' when ansid=268610 then '' when ansid=268611 then '1' when ansid=268612 then '1' when ansid=268613 then '1' when ansid=268614 then '' when ansid=268615 then '1' when ansid=268616 then '1' when ansid=268617 then '1' when ansid=268618 then '1' when ansid=268619 then '1' when ansid=268620 then '0' when ansid=268621 then 'NIL' when ansid=268622 then 'Yes, SST Member' when ansid=268623 then 'Overall work was satisfactory.' when ansid=268624 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 11:08:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE supvisstepid = '13964'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 11:08:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:08:29' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE sitesupervision SET `siteid` = '111', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-04-03', `numofsamplecollected` = '38', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2832'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yasing Uashum', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE onssid = '11656'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE onsitestaffs SET `staffname` = 'Ngalashing Chithung', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE onssid = '11657'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE onsitestaffs SET `staffname` = 'Ngamba Ahanthem', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE onssid = '11658'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE onssid = '11659'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268519 then '1' when ansid=268520 then '1' when ansid=268521 then '1' when ansid=268522 then '' when ansid=268523 then '' when ansid=268524 then '52' when ansid=268525 then '1' when ansid=268625 then '1' when ansid=268626 then '1' when ansid=268568 then '1' when ansid=268570 then '1' when ansid=268572 then '1' when ansid=268574 then '3' when ansid=268576 then '5' when ansid=268578 then '0' when ansid=268579 then '12' when ansid=268580 then '61' when ansid=268581 then '7' when ansid=268582 then '' when ansid=268583 then '1' when ansid=268584 then '1' when ansid=268585 then '' when ansid=268586 then '1' when ansid=268587 then '' when ansid=268588 then '1' when ansid=268589 then '3' when ansid=268590 then '1' when ansid=268591 then '1' when ansid=268592 then 'Counsellor' when ansid=268593 then '1' when ansid=268594 then '' when ansid=268595 then '1' when ansid=268596 then '1' when ansid=268597 then '' when ansid=268598 then '1' when ansid=268599 then '4' when ansid=268600 then '1' when ansid=268601 then '1' when ansid=268602 then '1' when ansid=268603 then '1' when ansid=268604 then '2' when ansid=268605 then '1' when ansid=268606 then '1' when ansid=268607 then '1' when ansid=268608 then '' when ansid=268609 then '3' when ansid=268610 then '' when ansid=268611 then '1' when ansid=268612 then '1' when ansid=268613 then '1' when ansid=268614 then '' when ansid=268615 then '1' when ansid=268616 then '1' when ansid=268617 then '1' when ansid=268618 then '1' when ansid=268619 then '1' when ansid=268620 then '0' when ansid=268621 then 'NIL' when ansid=268622 then 'Yes, SST Member' when ansid=268623 then 'Overall work was satisfactory.' when ansid=268624 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.237.205.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-25 11:09:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268519','268520','268521','268522','268523','268524','268525','268625','268626','268568','268570','268572','268574','268576','268578','268579','268580','268581','268582','268583','268584','268585','268586','268587','268588','268589','268590','268591','268592','268593','268594','268595','268596','268597','268598','268599','268600','268601','268602','268603','268604','268605','268606','268607','268608','268609','268610','268611','268612','268613','268614','268615','268616','268617','268618','268619','268620','268621','268622','268623','268624')"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE supvisstepid = '13965'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE visitfeedback SET `feedback` = 'NIL', `recommendation` = 'NIL', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE visitfeedbackid = '13936'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE visitfeedbackid = '13937'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE visitfeedbackid = '13938'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE visitfeedbackid = '13939'"} {"userId":"57","date":"2023-04-25 11:09:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.237.205.12', `modifiedby` = '57', `modifieddate` = '2023-04-25 11:09:05' WHERE visitfeedbackid = '13940'"} {"userId":"57","date":"2023-04-25 11:10:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '117.237.205.12', '2023-04-25 11:10:36')"}