{"userId":null,"date":"2022-11-17 12:06:44","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('5', '627226', '0', '106.203.218.95', '', '2022-11-17 12:06:44')"}
{"userId":"5","date":"2022-11-17 12:11:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '106.203.218.95', '2022-11-17 12:11:46')"}
{"userId":"5","date":"2022-11-17 12:16:26","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('174', '2022-11-30', '5', '106.203.218.95', '5', '2022-11-17 12:16:26')"}
{"userId":"5","date":"2022-11-17 12:17:17","query":"UPDATE plannedsites SET `siteid` = '175', `visitdate` = '2022-11-30', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:17:17' WHERE plansiteid = '2810'"}
{"userId":"5","date":"2022-11-17 12:17:25","query":"UPDATE plannedsites SET `siteid` = '174', `visitdate` = '2022-11-30', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:17:25' WHERE plansiteid = '2810'"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('174', '2810', '5', '2022-11-17', '0', '106.203.218.95', '5', '2022-11-17 12:18:52', '', '')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2409', '0', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2409', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2409', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2409', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2409', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:18:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2409', '106.203.218.95', '5', '2022-11-17 12:18:52')"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2409'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE onssid = '9964'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE onssid = '9965'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE onssid = '9966'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE onssid = '9967'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE supvisstepid = '11933'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE visitfeedbackid = '11821'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE visitfeedbackid = '11822'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE visitfeedbackid = '11823'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE visitfeedbackid = '11824'"}
{"userId":"5","date":"2022-11-17 12:19:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:19:26' WHERE visitfeedbackid = '11825'"}
{"userId":"5","date":"2022-11-17 12:37:03","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('173', '2022-11-25', '5', '106.203.218.95', '5', '2022-11-17 12:37:03')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('173', '2811', '5', '2022-11-17', '1', '106.203.218.95', '5', '2022-11-17 12:37:20', '', '')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2410', '0', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2410', '1', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2410', '2', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2410', '3', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2410', '4', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2410', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2410', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2410', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2410', '', '', 'Array', '', 'Array', '', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:37:20","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2410', '106.203.218.95', '5', '2022-11-17 12:37:20')"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2410'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE onsitestaffs SET `staffname` = 'sd', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE onssid = '9968'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE onsitestaffs SET `staffname` = 'sadasd', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE onssid = '9969'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE onsitestaffs SET `staffname` = 'sadasddd', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE onssid = '9970'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE onssid = '9971'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223289 then '' when ansid=223290 then '' when ansid=223291 then '' when ansid=223292 then '' when ansid=223293 then ''  when ansid=223294 then ''   when ansid=223295 then ''  when ansid=223338 then '' when ansid=223340 then '' when ansid=223342 then '' when ansid=223344 then '' when ansid=223346 then '' when ansid=223348 then '' when ansid=223349 then '' when ansid=223350 then '' when ansid=223351 then ''  when ansid=223352 then ''   when ansid=223353 then ''  when ansid=223354 then ''  when ansid=223355 then ''   when ansid=223356 then ''   when ansid=223357 then ''   when ansid=223358 then ''  when ansid=223359 then '' when ansid=223360 then '' when ansid=223361 then ''  when ansid=223362 then ''   when ansid=223363 then ''   when ansid=223364 then ''   when ansid=223365 then ''  when ansid=223366 then ''  when ansid=223367 then ''   when ansid=223368 then ''  when ansid=223369 then '' when ansid=223370 then '' when ansid=223371 then '' when ansid=223372 then '' when ansid=223373 then '' when ansid=223374 then '' when ansid=223375 then '' when ansid=223376 then '' when ansid=223377 then ''  when ansid=223378 then ''   when ansid=223379 then ''   when ansid=223380 then ''   when ansid=223381 then ''  when ansid=223382 then '' when ansid=223383 then ''  when ansid=223384 then ''   when ansid=223385 then ''  when ansid=223386 then '' when ansid=223387 then '' when ansid=223388 then '' when ansid=223389 then '' when ansid=223390 then '' when ansid=223391 then '' when ansid=223392 then '' when ansid=223393 then '' when ansid=223394 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =5,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 12:39:09'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223289','223290','223291','223292','223293','223294','223295','223338','223340','223342','223344','223346','223348','223349','223350','223351','223352','223353','223354','223355','223356','223357','223358','223359','223360','223361','223362','223363','223364','223365','223366','223367','223368','223369','223370','223371','223372','223373','223374','223375','223376','223377','223378','223379','223380','223381','223382','223383','223384','223385','223386','223387','223388','223389','223390','223391','223392','223393','223394')"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE supvisstepid = '11934'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE visitfeedbackid = '11826'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE visitfeedbackid = '11827'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE visitfeedbackid = '11828'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE visitfeedbackid = '11829'"}
{"userId":"5","date":"2022-11-17 12:39:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:09' WHERE visitfeedbackid = '11830'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2410'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE onsitestaffs SET `staffname` = 'sd', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE onssid = '9968'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE onsitestaffs SET `staffname` = 'sadasd', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE onssid = '9969'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE onsitestaffs SET `staffname` = 'sadasddd', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE onssid = '9970'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE onssid = '9971'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223289 then '1' when ansid=223290 then '1' when ansid=223291 then '1' when ansid=223292 then '' when ansid=223293 then ''  when ansid=223294 then '20'   when ansid=223295 then '1'  when ansid=223338 then '' when ansid=223340 then '' when ansid=223342 then '' when ansid=223344 then '' when ansid=223346 then '' when ansid=223348 then '' when ansid=223349 then '' when ansid=223350 then '' when ansid=223351 then ''  when ansid=223352 then ''   when ansid=223353 then ''  when ansid=223354 then ''  when ansid=223355 then ''   when ansid=223356 then ''   when ansid=223357 then ''   when ansid=223358 then ''  when ansid=223359 then '' when ansid=223360 then '' when ansid=223361 then ''  when ansid=223362 then ''   when ansid=223363 then ''   when ansid=223364 then ''   when ansid=223365 then ''  when ansid=223366 then ''  when ansid=223367 then ''   when ansid=223368 then ''  when ansid=223369 then '' when ansid=223370 then '' when ansid=223371 then '' when ansid=223372 then '' when ansid=223373 then '' when ansid=223374 then '' when ansid=223375 then '' when ansid=223376 then '' when ansid=223377 then ''  when ansid=223378 then ''   when ansid=223379 then ''   when ansid=223380 then ''   when ansid=223381 then ''  when ansid=223382 then '' when ansid=223383 then ''  when ansid=223384 then ''   when ansid=223385 then ''  when ansid=223386 then '' when ansid=223387 then '' when ansid=223388 then '' when ansid=223389 then '' when ansid=223390 then '' when ansid=223391 then '' when ansid=223392 then '' when ansid=223393 then '' when ansid=223394 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =5,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 12:39:38'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223289','223290','223291','223292','223293','223294','223295','223338','223340','223342','223344','223346','223348','223349','223350','223351','223352','223353','223354','223355','223356','223357','223358','223359','223360','223361','223362','223363','223364','223365','223366','223367','223368','223369','223370','223371','223372','223373','223374','223375','223376','223377','223378','223379','223380','223381','223382','223383','223384','223385','223386','223387','223388','223389','223390','223391','223392','223393','223394')"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE supvisstepid = '11935'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE visitfeedbackid = '11826'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE visitfeedbackid = '11827'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE visitfeedbackid = '11828'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE visitfeedbackid = '11829'"}
{"userId":"5","date":"2022-11-17 12:39:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:38' WHERE visitfeedbackid = '11830'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2410'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'sd', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE onssid = '9968'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'sadasd', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE onssid = '9969'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'sadasddd', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE onssid = '9970'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE onssid = '9971'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223289 then '1' when ansid=223290 then '1' when ansid=223291 then '1' when ansid=223292 then '' when ansid=223293 then ''  when ansid=223294 then '20'   when ansid=223295 then '1'  when ansid=223338 then '1' when ansid=223340 then '1' when ansid=223342 then '1' when ansid=223344 then '10' when ansid=223346 then '5' when ansid=223348 then '' when ansid=223349 then '' when ansid=223350 then '' when ansid=223351 then ''  when ansid=223352 then ''   when ansid=223353 then ''  when ansid=223354 then ''  when ansid=223355 then ''   when ansid=223356 then ''   when ansid=223357 then ''   when ansid=223358 then ''  when ansid=223359 then '' when ansid=223360 then '' when ansid=223361 then ''  when ansid=223362 then ''   when ansid=223363 then ''   when ansid=223364 then ''   when ansid=223365 then ''  when ansid=223366 then ''  when ansid=223367 then ''   when ansid=223368 then ''  when ansid=223369 then '' when ansid=223370 then '' when ansid=223371 then '' when ansid=223372 then '' when ansid=223373 then '' when ansid=223374 then '' when ansid=223375 then '' when ansid=223376 then '' when ansid=223377 then ''  when ansid=223378 then ''   when ansid=223379 then ''   when ansid=223380 then ''   when ansid=223381 then ''  when ansid=223382 then '' when ansid=223383 then ''  when ansid=223384 then ''   when ansid=223385 then ''  when ansid=223386 then '' when ansid=223387 then '' when ansid=223388 then '' when ansid=223389 then '' when ansid=223390 then '' when ansid=223391 then '' when ansid=223392 then '' when ansid=223393 then '' when ansid=223394 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =5,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 12:39:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223289','223290','223291','223292','223293','223294','223295','223338','223340','223342','223344','223346','223348','223349','223350','223351','223352','223353','223354','223355','223356','223357','223358','223359','223360','223361','223362','223363','223364','223365','223366','223367','223368','223369','223370','223371','223372','223373','223374','223375','223376','223377','223378','223379','223380','223381','223382','223383','223384','223385','223386','223387','223388','223389','223390','223391','223392','223393','223394')"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE supvisstepid = '11936'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE visitfeedbackid = '11826'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE visitfeedbackid = '11827'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE visitfeedbackid = '11828'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE visitfeedbackid = '11829'"}
{"userId":"5","date":"2022-11-17 12:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:39:58' WHERE visitfeedbackid = '11830'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2410'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE onsitestaffs SET `staffname` = 'sd', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE onssid = '9968'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE onsitestaffs SET `staffname` = 'sadasd', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE onssid = '9969'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE onsitestaffs SET `staffname` = 'sadasddd', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE onssid = '9970'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE onssid = '9971'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223289 then '1' when ansid=223290 then '1' when ansid=223291 then '1' when ansid=223292 then '' when ansid=223293 then ''  when ansid=223294 then '20'   when ansid=223295 then '1'  when ansid=223338 then '1' when ansid=223340 then '1' when ansid=223342 then '1' when ansid=223344 then '10' when ansid=223346 then '5' when ansid=223348 then '50' when ansid=223349 then '5' when ansid=223350 then '100' when ansid=223351 then '25'  when ansid=223352 then ''   when ansid=223353 then '1'  when ansid=223354 then '1'  when ansid=223355 then ''   when ansid=223356 then '1'   when ansid=223357 then ''   when ansid=223358 then '1'  when ansid=223359 then '5' when ansid=223360 then '1' when ansid=223361 then '1'  when ansid=223362 then ''   when ansid=223363 then '1'   when ansid=223364 then ''   when ansid=223365 then '1'  when ansid=223366 then '1'  when ansid=223367 then ''   when ansid=223368 then '1'  when ansid=223369 then '1' when ansid=223370 then '1' when ansid=223371 then '1' when ansid=223372 then '1' when ansid=223373 then '1' when ansid=223374 then '1' when ansid=223375 then '1' when ansid=223376 then '1' when ansid=223377 then '1'  when ansid=223378 then ''   when ansid=223379 then '1'   when ansid=223380 then ''   when ansid=223381 then '1'  when ansid=223382 then '1' when ansid=223383 then '1'  when ansid=223384 then ''   when ansid=223385 then '1'  when ansid=223386 then '1' when ansid=223387 then '1' when ansid=223388 then '1' when ansid=223389 then '1' when ansid=223390 then '12' when ansid=223391 then 'ghgfhf' when ansid=223392 then 'fghgfh' when ansid=223393 then 'gfhgfh' when ansid=223394 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =5,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 12:44:35'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223289','223290','223291','223292','223293','223294','223295','223338','223340','223342','223344','223346','223348','223349','223350','223351','223352','223353','223354','223355','223356','223357','223358','223359','223360','223361','223362','223363','223364','223365','223366','223367','223368','223369','223370','223371','223372','223373','223374','223375','223376','223377','223378','223379','223380','223381','223382','223383','223384','223385','223386','223387','223388','223389','223390','223391','223392','223393','223394')"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE supvisstepid = '11937'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE visitfeedbackid = '11826'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE visitfeedbackid = '11827'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE visitfeedbackid = '11828'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE visitfeedbackid = '11829'"}
{"userId":"5","date":"2022-11-17 12:44:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:35' WHERE visitfeedbackid = '11830'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2410'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'sd', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE onssid = '9968'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'sadasd', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE onssid = '9969'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE onsitestaffs SET `staffname` = 'sadasddd', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE onssid = '9970'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE onssid = '9971'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223289 then '1' when ansid=223290 then '1' when ansid=223291 then '1' when ansid=223292 then '' when ansid=223293 then ''  when ansid=223294 then '20'   when ansid=223295 then '1'  when ansid=223338 then '1' when ansid=223340 then '1' when ansid=223342 then '1' when ansid=223344 then '10' when ansid=223346 then '5' when ansid=223348 then '50' when ansid=223349 then '5' when ansid=223350 then '100' when ansid=223351 then '25'  when ansid=223352 then ''   when ansid=223353 then '1'  when ansid=223354 then '1'  when ansid=223355 then ''   when ansid=223356 then '1'   when ansid=223357 then ''   when ansid=223358 then '1'  when ansid=223359 then '5' when ansid=223360 then '1' when ansid=223361 then '1'  when ansid=223362 then ''   when ansid=223363 then '1'   when ansid=223364 then ''   when ansid=223365 then '1'  when ansid=223366 then '1'  when ansid=223367 then ''   when ansid=223368 then '1'  when ansid=223369 then '1' when ansid=223370 then '1' when ansid=223371 then '1' when ansid=223372 then '1' when ansid=223373 then '1' when ansid=223374 then '1' when ansid=223375 then '1' when ansid=223376 then '1' when ansid=223377 then '1'  when ansid=223378 then ''   when ansid=223379 then '1'   when ansid=223380 then ''   when ansid=223381 then '1'  when ansid=223382 then '1' when ansid=223383 then '1'  when ansid=223384 then ''   when ansid=223385 then '1'  when ansid=223386 then '1' when ansid=223387 then '1' when ansid=223388 then '1' when ansid=223389 then '1' when ansid=223390 then '12' when ansid=223391 then 'ghgfhf' when ansid=223392 then 'fghgfh' when ansid=223393 then 'gfhgfh' when ansid=223394 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =5,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 12:44:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223289','223290','223291','223292','223293','223294','223295','223338','223340','223342','223344','223346','223348','223349','223350','223351','223352','223353','223354','223355','223356','223357','223358','223359','223360','223361','223362','223363','223364','223365','223366','223367','223368','223369','223370','223371','223372','223373','223374','223375','223376','223377','223378','223379','223380','223381','223382','223383','223384','223385','223386','223387','223388','223389','223390','223391','223392','223393','223394')"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE supvisstepid = '11938'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE visitfeedback SET `feedback` = 'fghgfh', `recommendation` = 'fghgf', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE visitfeedbackid = '11826'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE visitfeedback SET `feedback` = 'fghg', `recommendation` = 'fghf', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE visitfeedbackid = '11827'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE visitfeedbackid = '11828'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE visitfeedbackid = '11829'"}
{"userId":"5","date":"2022-11-17 12:44:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '5', `modifieddate` = '2022-11-17 12:44:59' WHERE visitfeedbackid = '11830'"}
{"userId":"12","date":"2022-11-17 14:15:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('12', '106.203.218.95', '2022-11-17 14:15:28')"}
{"userId":"12","date":"2022-11-17 14:16:43","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('174', '2022-11-25', '12', '106.203.218.95', '12', '2022-11-17 14:16:43')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('174', '2812', '12', '2022-11-17', '1', '106.203.218.95', '12', '2022-11-17 14:17:56', '', '')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2411', '0', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2411', '1', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2411', '2', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2411', '3', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2411', '4', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2411', '', '', 'Array', '', 'Array', '', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2411', '', '', 'Array', '', 'Array', '', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2411', '', '', 'Array', '', 'Array', '', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2411', '', '', 'Array', '', 'Array', '', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:17:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2411', '106.203.218.95', '12', '2022-11-17 14:17:56')"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '12', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-17', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2411'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE onssid = '9972'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE onssid = '9973'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE onssid = '9974'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE onssid = '9975'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223395 then '' when ansid=223396 then '' when ansid=223397 then '' when ansid=223398 then '' when ansid=223399 then ''  when ansid=223400 then ''   when ansid=223401 then ''  when ansid=223444 then '' when ansid=223446 then '' when ansid=223448 then '' when ansid=223450 then '' when ansid=223452 then '' when ansid=223454 then '' when ansid=223455 then '' when ansid=223456 then '' when ansid=223457 then ''  when ansid=223458 then ''   when ansid=223459 then ''  when ansid=223460 then ''  when ansid=223461 then ''   when ansid=223462 then ''   when ansid=223463 then ''   when ansid=223464 then ''  when ansid=223465 then '' when ansid=223466 then '' when ansid=223467 then ''  when ansid=223468 then ''   when ansid=223469 then ''   when ansid=223470 then ''   when ansid=223471 then ''  when ansid=223472 then ''  when ansid=223473 then ''   when ansid=223474 then ''  when ansid=223475 then '' when ansid=223476 then '' when ansid=223477 then '' when ansid=223478 then '' when ansid=223479 then '' when ansid=223480 then '' when ansid=223481 then '' when ansid=223482 then '' when ansid=223483 then ''  when ansid=223484 then ''   when ansid=223485 then ''   when ansid=223486 then ''   when ansid=223487 then ''  when ansid=223488 then '' when ansid=223489 then ''  when ansid=223490 then ''   when ansid=223491 then ''  when ansid=223492 then '' when ansid=223493 then '' when ansid=223494 then '' when ansid=223495 then '' when ansid=223496 then '' when ansid=223497 then '' when ansid=223498 then '' when ansid=223499 then '' when ansid=223500 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =12,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 14:19:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223395','223396','223397','223398','223399','223400','223401','223444','223446','223448','223450','223452','223454','223455','223456','223457','223458','223459','223460','223461','223462','223463','223464','223465','223466','223467','223468','223469','223470','223471','223472','223473','223474','223475','223476','223477','223478','223479','223480','223481','223482','223483','223484','223485','223486','223487','223488','223489','223490','223491','223492','223493','223494','223495','223496','223497','223498','223499','223500')"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE supvisstepid = '11939'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE visitfeedbackid = '11831'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE visitfeedbackid = '11832'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE visitfeedbackid = '11833'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE visitfeedbackid = '11834'"}
{"userId":"12","date":"2022-11-17 14:19:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:19:58' WHERE visitfeedbackid = '11835'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '12', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-17', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2411'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE onssid = '9972'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE onssid = '9973'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE onssid = '9974'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE onssid = '9975'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223395 then '1' when ansid=223396 then '1' when ansid=223397 then '1' when ansid=223398 then '' when ansid=223399 then ''  when ansid=223400 then ''   when ansid=223401 then ''  when ansid=223444 then '' when ansid=223446 then '' when ansid=223448 then '' when ansid=223450 then '' when ansid=223452 then '' when ansid=223454 then '' when ansid=223455 then '' when ansid=223456 then '' when ansid=223457 then ''  when ansid=223458 then ''   when ansid=223459 then ''  when ansid=223460 then ''  when ansid=223461 then ''   when ansid=223462 then ''   when ansid=223463 then ''   when ansid=223464 then ''  when ansid=223465 then '' when ansid=223466 then '' when ansid=223467 then ''  when ansid=223468 then ''   when ansid=223469 then ''   when ansid=223470 then ''   when ansid=223471 then ''  when ansid=223472 then ''  when ansid=223473 then ''   when ansid=223474 then ''  when ansid=223475 then '' when ansid=223476 then '' when ansid=223477 then '' when ansid=223478 then '' when ansid=223479 then '' when ansid=223480 then '' when ansid=223481 then '' when ansid=223482 then '' when ansid=223483 then ''  when ansid=223484 then ''   when ansid=223485 then ''   when ansid=223486 then ''   when ansid=223487 then ''  when ansid=223488 then '' when ansid=223489 then ''  when ansid=223490 then ''   when ansid=223491 then ''  when ansid=223492 then '' when ansid=223493 then '' when ansid=223494 then '' when ansid=223495 then '' when ansid=223496 then '' when ansid=223497 then '' when ansid=223498 then '' when ansid=223499 then '' when ansid=223500 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =12,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 14:20:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223395','223396','223397','223398','223399','223400','223401','223444','223446','223448','223450','223452','223454','223455','223456','223457','223458','223459','223460','223461','223462','223463','223464','223465','223466','223467','223468','223469','223470','223471','223472','223473','223474','223475','223476','223477','223478','223479','223480','223481','223482','223483','223484','223485','223486','223487','223488','223489','223490','223491','223492','223493','223494','223495','223496','223497','223498','223499','223500')"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE supvisstepid = '11940'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE visitfeedbackid = '11831'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE visitfeedbackid = '11832'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE visitfeedbackid = '11833'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE visitfeedbackid = '11834'"}
{"userId":"12","date":"2022-11-17 14:20:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:19' WHERE visitfeedbackid = '11835'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '12', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-17', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2411'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE onssid = '9972'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE onssid = '9973'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE onssid = '9974'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE onssid = '9975'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223395 then '1' when ansid=223396 then '1' when ansid=223397 then '1' when ansid=223398 then '' when ansid=223399 then ''  when ansid=223400 then ''   when ansid=223401 then ''  when ansid=223444 then '1' when ansid=223446 then '2' when ansid=223448 then '2' when ansid=223450 then '2' when ansid=223452 then '2' when ansid=223454 then '' when ansid=223455 then '' when ansid=223456 then '' when ansid=223457 then ''  when ansid=223458 then ''   when ansid=223459 then ''  when ansid=223460 then ''  when ansid=223461 then ''   when ansid=223462 then ''   when ansid=223463 then ''   when ansid=223464 then ''  when ansid=223465 then '' when ansid=223466 then '' when ansid=223467 then ''  when ansid=223468 then ''   when ansid=223469 then ''   when ansid=223470 then ''   when ansid=223471 then ''  when ansid=223472 then ''  when ansid=223473 then ''   when ansid=223474 then ''  when ansid=223475 then '' when ansid=223476 then '' when ansid=223477 then '' when ansid=223478 then '' when ansid=223479 then '' when ansid=223480 then '' when ansid=223481 then '' when ansid=223482 then '' when ansid=223483 then ''  when ansid=223484 then ''   when ansid=223485 then ''   when ansid=223486 then ''   when ansid=223487 then ''  when ansid=223488 then '' when ansid=223489 then ''  when ansid=223490 then ''   when ansid=223491 then ''  when ansid=223492 then '' when ansid=223493 then '' when ansid=223494 then '' when ansid=223495 then '' when ansid=223496 then '' when ansid=223497 then '' when ansid=223498 then '' when ansid=223499 then '' when ansid=223500 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =12,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 14:20:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223395','223396','223397','223398','223399','223400','223401','223444','223446','223448','223450','223452','223454','223455','223456','223457','223458','223459','223460','223461','223462','223463','223464','223465','223466','223467','223468','223469','223470','223471','223472','223473','223474','223475','223476','223477','223478','223479','223480','223481','223482','223483','223484','223485','223486','223487','223488','223489','223490','223491','223492','223493','223494','223495','223496','223497','223498','223499','223500')"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE supvisstepid = '11941'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE visitfeedbackid = '11831'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE visitfeedbackid = '11832'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE visitfeedbackid = '11833'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE visitfeedbackid = '11834'"}
{"userId":"12","date":"2022-11-17 14:20:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:20:33' WHERE visitfeedbackid = '11835'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '12', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-17', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2411'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE onssid = '9972'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE onssid = '9973'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE onssid = '9974'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE onssid = '9975'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223395 then '1' when ansid=223396 then '1' when ansid=223397 then '1' when ansid=223398 then '' when ansid=223399 then ''  when ansid=223400 then ''   when ansid=223401 then ''  when ansid=223444 then '1' when ansid=223446 then '2' when ansid=223448 then '2' when ansid=223450 then '2' when ansid=223452 then '2' when ansid=223454 then '1' when ansid=223455 then '1' when ansid=223456 then '1' when ansid=223457 then '1'  when ansid=223458 then ''   when ansid=223459 then '1'  when ansid=223460 then '1'  when ansid=223461 then ''   when ansid=223462 then '1'   when ansid=223463 then ''   when ansid=223464 then '1'  when ansid=223465 then '1' when ansid=223466 then '1' when ansid=223467 then '1'  when ansid=223468 then '11'   when ansid=223469 then '1'   when ansid=223470 then ''   when ansid=223471 then '1'  when ansid=223472 then '1'  when ansid=223473 then ''   when ansid=223474 then '1'  when ansid=223475 then '1' when ansid=223476 then '1' when ansid=223477 then '1' when ansid=223478 then '1' when ansid=223479 then '1' when ansid=223480 then '1' when ansid=223481 then '1' when ansid=223482 then '1' when ansid=223483 then '1'  when ansid=223484 then ''   when ansid=223485 then '1'   when ansid=223486 then ''   when ansid=223487 then '1'  when ansid=223488 then '1' when ansid=223489 then '1'  when ansid=223490 then ''   when ansid=223491 then '1'  when ansid=223492 then '1' when ansid=223493 then '1' when ansid=223494 then '1' when ansid=223495 then '1' when ansid=223496 then '11' when ansid=223497 then 'asdasdas asdasd' when ansid=223498 then 'asdasdas' when ansid=223499 then 'asdasdasds' when ansid=223500 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =12,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 14:22:44'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223395','223396','223397','223398','223399','223400','223401','223444','223446','223448','223450','223452','223454','223455','223456','223457','223458','223459','223460','223461','223462','223463','223464','223465','223466','223467','223468','223469','223470','223471','223472','223473','223474','223475','223476','223477','223478','223479','223480','223481','223482','223483','223484','223485','223486','223487','223488','223489','223490','223491','223492','223493','223494','223495','223496','223497','223498','223499','223500')"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE supvisstepid = '11942'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE visitfeedbackid = '11831'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE visitfeedbackid = '11832'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE visitfeedbackid = '11833'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE visitfeedbackid = '11834'"}
{"userId":"12","date":"2022-11-17 14:22:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:22:44' WHERE visitfeedbackid = '11835'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '12', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-17', `numofsamplecollected` = '50', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2411'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE onssid = '9972'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE onssid = '9973'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE onssid = '9974'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE onssid = '9975'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=223395 then '1' when ansid=223396 then '1' when ansid=223397 then '1' when ansid=223398 then '' when ansid=223399 then ''  when ansid=223400 then ''   when ansid=223401 then ''  when ansid=223444 then '1' when ansid=223446 then '2' when ansid=223448 then '2' when ansid=223450 then '2' when ansid=223452 then '2' when ansid=223454 then '1' when ansid=223455 then '1' when ansid=223456 then '1' when ansid=223457 then '1'  when ansid=223458 then ''   when ansid=223459 then '1'  when ansid=223460 then '1'  when ansid=223461 then ''   when ansid=223462 then '1'   when ansid=223463 then ''   when ansid=223464 then '1'  when ansid=223465 then '1' when ansid=223466 then '1' when ansid=223467 then '1'  when ansid=223468 then '11'   when ansid=223469 then '1'   when ansid=223470 then ''   when ansid=223471 then '1'  when ansid=223472 then '1'  when ansid=223473 then ''   when ansid=223474 then '1'  when ansid=223475 then '1' when ansid=223476 then '1' when ansid=223477 then '1' when ansid=223478 then '1' when ansid=223479 then '1' when ansid=223480 then '1' when ansid=223481 then '1' when ansid=223482 then '1' when ansid=223483 then '1'  when ansid=223484 then ''   when ansid=223485 then '1'   when ansid=223486 then ''   when ansid=223487 then '1'  when ansid=223488 then '1' when ansid=223489 then '1'  when ansid=223490 then ''   when ansid=223491 then '1'  when ansid=223492 then '1' when ansid=223493 then '1' when ansid=223494 then '1' when ansid=223495 then '1' when ansid=223496 then '11' when ansid=223497 then 'asdasdas asdasd' when ansid=223498 then 'asdasdas' when ansid=223499 then 'asdasdasds' when ansid=223500 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.203.218.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =12,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-17 14:23:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('223395','223396','223397','223398','223399','223400','223401','223444','223446','223448','223450','223452','223454','223455','223456','223457','223458','223459','223460','223461','223462','223463','223464','223465','223466','223467','223468','223469','223470','223471','223472','223473','223474','223475','223476','223477','223478','223479','223480','223481','223482','223483','223484','223485','223486','223487','223488','223489','223490','223491','223492','223493','223494','223495','223496','223497','223498','223499','223500')"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE supvisstepid = '11943'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE visitfeedback SET `feedback` = 'aaa', `recommendation` = 'cccc', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE visitfeedbackid = '11831'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE visitfeedback SET `feedback` = 'bbb', `recommendation` = 'dddd', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE visitfeedbackid = '11832'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE visitfeedbackid = '11833'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE visitfeedbackid = '11834'"}
{"userId":"12","date":"2022-11-17 14:23:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.203.218.95', `modifiedby` = '12', `modifieddate` = '2022-11-17 14:23:19' WHERE visitfeedbackid = '11835'"}
{"userId":"12","date":"2022-11-17 14:30:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('12', '106.203.218.95', '2022-11-17 14:30:06')"}