{"userId":"5","date":"2020-12-04 10:49:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '59.93.139.208', '2020-12-04 10:49:08')"} {"userId":"5","date":"2020-12-04 10:50:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '59.93.139.208', '2020-12-04 10:50:46')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('89', '925', '5', '2020-12-04', '1', '59.93.139.208', '5', '2020-12-04 10:51:37', '', '')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '0', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '1', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '2', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '3', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '4', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '5', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('741', '6', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('741', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('741', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('741', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('741', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"5","date":"2020-12-04 10:51:37","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('741', '59.93.139.208', '5', '2020-12-04 10:51:37')"} {"userId":"7","date":"2020-12-04 16:14:51","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2020-12-04 16:14:51')"} {"userId":"7","date":"2020-12-04 16:18:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2020-12-04 16:18:02')"} {"userId":"7","date":"2020-12-04 16:19:12","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('474', '2020-12-04', '7', '14.139.125.18', '7', '2020-12-04 16:19:12')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('474', '930', '7', '2020-12-04', '1', '14.139.125.18', '7', '2020-12-04 16:20:04', '', '')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '0', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '1', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '2', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '3', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '4', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '5', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('742', '6', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('742', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('742', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('742', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('742', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:20:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('742', '14.139.125.18', '7', '2020-12-04 16:20:04')"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '' when ansid=77707 then '' when ansid=77708 then '' when ansid=77709 then '' when ansid=77710 then '' when ansid=77711 then '' when ansid=77712 then '' when ansid=77713 then '' when ansid=77715 then '' when ansid=77717 then '' when ansid=77719 then '' when ansid=77721 then '' when ansid=77723 then '' when ansid=77725 then '' when ansid=77727 then '' when ansid=77729 then '' when ansid=77731 then '' when ansid=77733 then '' when ansid=77735 then '' when ansid=77737 then '' when ansid=77739 then '' when ansid=77741 then '' when ansid=77743 then '' when ansid=77745 then '' when ansid=77747 then '' when ansid=77749 then '' when ansid=77751 then '' when ansid=77753 then '' when ansid=77755 then '' when ansid=77757 then '' when ansid=77759 then '' when ansid=77761 then '' when ansid=77763 then '' when ansid=77765 then '' when ansid=77766 then '' when ansid=77767 then '' when ansid=77768 then '' when ansid=77769 then '' when ansid=77770 then '' when ansid=77771 then '' when ansid=77772 then '' when ansid=77773 then '' when ansid=77774 then '' when ansid=77775 then '' when ansid=77776 then '' when ansid=77777 then '' when ansid=77778 then '' when ansid=77779 then '' when ansid=77780 then '' when ansid=77781 then '' when ansid=77782 then '' when ansid=77783 then '' when ansid=77784 then '' when ansid=77785 then '' when ansid=77786 then '' when ansid=77787 then '' when ansid=77788 then '' when ansid=77789 then '' when ansid=77790 then '' when ansid=77791 then '' when ansid=77792 then '' when ansid=77793 then '' when ansid=77794 then '' when ansid=77795 then '' when ansid=77796 then '' when ansid=77797 then '' when ansid=77798 then '' when ansid=77799 then '' when ansid=77800 then '' when ansid=77801 then '' when ansid=77802 then '' when ansid=77803 then '' when ansid=77804 then '' when ansid=77805 then '' when ansid=77806 then '' when ansid=77807 then '' when ansid=77808 then '' when ansid=77809 then '' when ansid=77810 then '' when ansid=77811 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:23:00'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE supvisstepid = '4749'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:23:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:23:00' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '' when ansid=77715 then '' when ansid=77717 then '' when ansid=77719 then '' when ansid=77721 then '' when ansid=77723 then '' when ansid=77725 then '' when ansid=77727 then '' when ansid=77729 then '' when ansid=77731 then '' when ansid=77733 then '' when ansid=77735 then '' when ansid=77737 then '' when ansid=77739 then '' when ansid=77741 then '' when ansid=77743 then '' when ansid=77745 then '' when ansid=77747 then '' when ansid=77749 then '' when ansid=77751 then '' when ansid=77753 then '' when ansid=77755 then '' when ansid=77757 then '' when ansid=77759 then '' when ansid=77761 then '' when ansid=77763 then '' when ansid=77765 then '' when ansid=77766 then '' when ansid=77767 then '' when ansid=77768 then '' when ansid=77769 then '' when ansid=77770 then '' when ansid=77771 then '' when ansid=77772 then '' when ansid=77773 then '' when ansid=77774 then '' when ansid=77775 then '' when ansid=77776 then '' when ansid=77777 then '' when ansid=77778 then '' when ansid=77779 then '' when ansid=77780 then '' when ansid=77781 then '' when ansid=77782 then '' when ansid=77783 then '' when ansid=77784 then '' when ansid=77785 then '' when ansid=77786 then '' when ansid=77787 then '' when ansid=77788 then '' when ansid=77789 then '' when ansid=77790 then '' when ansid=77791 then '' when ansid=77792 then '' when ansid=77793 then '' when ansid=77794 then '' when ansid=77795 then '' when ansid=77796 then '' when ansid=77797 then '' when ansid=77798 then '' when ansid=77799 then '' when ansid=77800 then '' when ansid=77801 then '' when ansid=77802 then '' when ansid=77803 then '' when ansid=77804 then '' when ansid=77805 then '' when ansid=77806 then '' when ansid=77807 then '' when ansid=77808 then '' when ansid=77809 then '' when ansid=77810 then '' when ansid=77811 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:24:31'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE supvisstepid = '4750'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:24:31' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '3' when ansid=77715 then '1' when ansid=77717 then '425' when ansid=77719 then '17' when ansid=77721 then '15' when ansid=77723 then '500' when ansid=77725 then '1' when ansid=77727 then '1' when ansid=77729 then '' when ansid=77731 then '' when ansid=77733 then '' when ansid=77735 then '' when ansid=77737 then '' when ansid=77739 then '' when ansid=77741 then '' when ansid=77743 then '' when ansid=77745 then '' when ansid=77747 then '' when ansid=77749 then '' when ansid=77751 then '' when ansid=77753 then '' when ansid=77755 then '' when ansid=77757 then '' when ansid=77759 then '' when ansid=77761 then '' when ansid=77763 then '' when ansid=77765 then '' when ansid=77766 then '' when ansid=77767 then '' when ansid=77768 then '' when ansid=77769 then '' when ansid=77770 then '' when ansid=77771 then '' when ansid=77772 then '' when ansid=77773 then '' when ansid=77774 then '' when ansid=77775 then '' when ansid=77776 then '' when ansid=77777 then '' when ansid=77778 then '' when ansid=77779 then '' when ansid=77780 then '' when ansid=77781 then '' when ansid=77782 then '' when ansid=77783 then '' when ansid=77784 then '' when ansid=77785 then '' when ansid=77786 then '' when ansid=77787 then '' when ansid=77788 then '' when ansid=77789 then '' when ansid=77790 then '' when ansid=77791 then '' when ansid=77792 then '' when ansid=77793 then '' when ansid=77794 then '' when ansid=77795 then '' when ansid=77796 then '' when ansid=77797 then '' when ansid=77798 then '' when ansid=77799 then '' when ansid=77800 then '' when ansid=77801 then '' when ansid=77802 then '' when ansid=77803 then '' when ansid=77804 then '' when ansid=77805 then '' when ansid=77806 then '' when ansid=77807 then '' when ansid=77808 then '' when ansid=77809 then '' when ansid=77810 then '' when ansid=77811 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:26:13'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE supvisstepid = '4751'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:26:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:26:13' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '3' when ansid=77715 then '1' when ansid=77717 then '425' when ansid=77719 then '17' when ansid=77721 then '15' when ansid=77723 then '500' when ansid=77725 then '1' when ansid=77727 then '1' when ansid=77729 then '2' when ansid=77731 then '400' when ansid=77733 then '400' when ansid=77735 then '400' when ansid=77737 then '18' when ansid=77739 then '1' when ansid=77741 then '450' when ansid=77743 then '400' when ansid=77745 then '450' when ansid=77747 then '2' when ansid=77749 then '4' when ansid=77751 then '1' when ansid=77753 then '5' when ansid=77755 then '' when ansid=77757 then '' when ansid=77759 then '' when ansid=77761 then '' when ansid=77763 then '' when ansid=77765 then '' when ansid=77766 then '' when ansid=77767 then '' when ansid=77768 then '' when ansid=77769 then '' when ansid=77770 then '' when ansid=77771 then '' when ansid=77772 then '' when ansid=77773 then '' when ansid=77774 then '' when ansid=77775 then '' when ansid=77776 then '' when ansid=77777 then '' when ansid=77778 then '' when ansid=77779 then '' when ansid=77780 then '' when ansid=77781 then '' when ansid=77782 then '' when ansid=77783 then '' when ansid=77784 then '' when ansid=77785 then '' when ansid=77786 then '' when ansid=77787 then '' when ansid=77788 then '' when ansid=77789 then '' when ansid=77790 then '' when ansid=77791 then '' when ansid=77792 then '' when ansid=77793 then '' when ansid=77794 then '' when ansid=77795 then '' when ansid=77796 then '' when ansid=77797 then '' when ansid=77798 then '' when ansid=77799 then '' when ansid=77800 then '' when ansid=77801 then '' when ansid=77802 then '' when ansid=77803 then '' when ansid=77804 then '' when ansid=77805 then '' when ansid=77806 then '' when ansid=77807 then '' when ansid=77808 then '' when ansid=77809 then '' when ansid=77810 then '' when ansid=77811 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:27:30'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE supvisstepid = '4752'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:30' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '3' when ansid=77715 then '1' when ansid=77717 then '425' when ansid=77719 then '17' when ansid=77721 then '15' when ansid=77723 then '500' when ansid=77725 then '1' when ansid=77727 then '1' when ansid=77729 then '2' when ansid=77731 then '400' when ansid=77733 then '400' when ansid=77735 then '400' when ansid=77737 then '18' when ansid=77739 then '1' when ansid=77741 then '450' when ansid=77743 then '400' when ansid=77745 then '450' when ansid=77747 then '2' when ansid=77749 then '4' when ansid=77751 then '1' when ansid=77753 then '5' when ansid=77755 then '1' when ansid=77757 then '1' when ansid=77759 then '1' when ansid=77761 then '2' when ansid=77763 then '3' when ansid=77765 then '' when ansid=77766 then '' when ansid=77767 then '' when ansid=77768 then '' when ansid=77769 then '' when ansid=77770 then '' when ansid=77771 then '' when ansid=77772 then '' when ansid=77773 then '' when ansid=77774 then '' when ansid=77775 then '' when ansid=77776 then '' when ansid=77777 then '' when ansid=77778 then '' when ansid=77779 then '' when ansid=77780 then '' when ansid=77781 then '' when ansid=77782 then '' when ansid=77783 then '' when ansid=77784 then '' when ansid=77785 then '' when ansid=77786 then '' when ansid=77787 then '' when ansid=77788 then '' when ansid=77789 then '' when ansid=77790 then '' when ansid=77791 then '' when ansid=77792 then '' when ansid=77793 then '' when ansid=77794 then '' when ansid=77795 then '' when ansid=77796 then '' when ansid=77797 then '' when ansid=77798 then '' when ansid=77799 then '' when ansid=77800 then '' when ansid=77801 then '' when ansid=77802 then '' when ansid=77803 then '' when ansid=77804 then '' when ansid=77805 then '' when ansid=77806 then '' when ansid=77807 then '' when ansid=77808 then '' when ansid=77809 then '' when ansid=77810 then '' when ansid=77811 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:27:52'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE supvisstepid = '4753'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:27:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:27:52' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '3' when ansid=77715 then '1' when ansid=77717 then '425' when ansid=77719 then '17' when ansid=77721 then '15' when ansid=77723 then '500' when ansid=77725 then '1' when ansid=77727 then '1' when ansid=77729 then '2' when ansid=77731 then '400' when ansid=77733 then '400' when ansid=77735 then '400' when ansid=77737 then '18' when ansid=77739 then '1' when ansid=77741 then '450' when ansid=77743 then '400' when ansid=77745 then '450' when ansid=77747 then '2' when ansid=77749 then '4' when ansid=77751 then '1' when ansid=77753 then '5' when ansid=77755 then '1' when ansid=77757 then '1' when ansid=77759 then '1' when ansid=77761 then '2' when ansid=77763 then '3' when ansid=77765 then '3' when ansid=77766 then '2' when ansid=77767 then '100' when ansid=77768 then '75' when ansid=77769 then '' when ansid=77770 then '1' when ansid=77771 then '1' when ansid=77772 then 'ABC' when ansid=77773 then '2' when ansid=77774 then '' when ansid=77775 then '1' when ansid=77776 then '20' when ansid=77777 then '1' when ansid=77778 then '1' when ansid=77779 then '' when ansid=77780 then '1' when ansid=77781 then '' when ansid=77782 then '1' when ansid=77783 then '1' when ansid=77784 then '' when ansid=77785 then '1' when ansid=77786 then '1' when ansid=77787 then '1' when ansid=77788 then '1' when ansid=77789 then '1' when ansid=77790 then '1' when ansid=77791 then '1' when ansid=77792 then '1' when ansid=77793 then '1' when ansid=77794 then '1' when ansid=77795 then '' when ansid=77796 then '3' when ansid=77797 then '' when ansid=77798 then '3' when ansid=77799 then '2' when ansid=77800 then '1' when ansid=77801 then '' when ansid=77802 then '1' when ansid=77803 then '1' when ansid=77804 then '1' when ansid=77805 then '1' when ansid=77806 then '1' when ansid=77807 then '2' when ansid=77808 then 'ABC' when ansid=77809 then 'No' when ansid=77810 then 'No' when ansid=77811 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:33:08'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE supvisstepid = '4754'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:33:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:33:08' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE sitesupervision SET `siteid` = '474', `userid` = '7', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '25', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19', `locationtype` = '1', `establishmentyear` = '2020', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '742'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE onsitestaffs SET `staffname` = 'ABC', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE onssid = '3296'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE onsitestaffs SET `staffname` = 'XYZ', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE onssid = '3297'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE onsitestaffs SET `staffname` = 'PQR', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '4', `istrained` = '1', `remarks` = '-', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE onssid = '3298'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE onssid = '3299'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77706 then '1' when ansid=77707 then '1' when ansid=77708 then '2' when ansid=77709 then '2' when ansid=77710 then '2' when ansid=77711 then '100' when ansid=77712 then '1' when ansid=77713 then '3' when ansid=77715 then '1' when ansid=77717 then '425' when ansid=77719 then '17' when ansid=77721 then '15' when ansid=77723 then '500' when ansid=77725 then '1' when ansid=77727 then '1' when ansid=77729 then '2' when ansid=77731 then '400' when ansid=77733 then '400' when ansid=77735 then '400' when ansid=77737 then '18' when ansid=77739 then '1' when ansid=77741 then '450' when ansid=77743 then '400' when ansid=77745 then '450' when ansid=77747 then '2' when ansid=77749 then '4' when ansid=77751 then '1' when ansid=77753 then '5' when ansid=77755 then '1' when ansid=77757 then '1' when ansid=77759 then '1' when ansid=77761 then '2' when ansid=77763 then '3' when ansid=77765 then '3' when ansid=77766 then '2' when ansid=77767 then '100' when ansid=77768 then '75' when ansid=77769 then '' when ansid=77770 then '1' when ansid=77771 then '1' when ansid=77772 then 'ABC' when ansid=77773 then '2' when ansid=77774 then '' when ansid=77775 then '1' when ansid=77776 then '20' when ansid=77777 then '1' when ansid=77778 then '1' when ansid=77779 then '' when ansid=77780 then '1' when ansid=77781 then '' when ansid=77782 then '1' when ansid=77783 then '1' when ansid=77784 then '' when ansid=77785 then '1' when ansid=77786 then '1' when ansid=77787 then '1' when ansid=77788 then '1' when ansid=77789 then '1' when ansid=77790 then '1' when ansid=77791 then '1' when ansid=77792 then '1' when ansid=77793 then '1' when ansid=77794 then '1' when ansid=77795 then '' when ansid=77796 then '3' when ansid=77797 then '' when ansid=77798 then '3' when ansid=77799 then '2' when ansid=77800 then '1' when ansid=77801 then '' when ansid=77802 then '1' when ansid=77803 then '1' when ansid=77804 then '1' when ansid=77805 then '1' when ansid=77806 then '1' when ansid=77807 then '2' when ansid=77808 then 'ABC' when ansid=77809 then 'No' when ansid=77810 then 'No' when ansid=77811 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:35:19'\n\t\t\t\t\t\t\tWHERE ansid in ('77706','77707','77708','77709','77710','77711','77712','77713','77715','77717','77719','77721','77723','77725','77727','77729','77731','77733','77735','77737','77739','77741','77743','77745','77747','77749','77751','77753','77755','77757','77759','77761','77763','77765','77766','77767','77768','77769','77770','77771','77772','77773','77774','77775','77776','77777','77778','77779','77780','77781','77782','77783','77784','77785','77786','77787','77788','77789','77790','77791','77792','77793','77794','77795','77796','77797','77798','77799','77800','77801','77802','77803','77804','77805','77806','77807','77808','77809','77810','77811')"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE supvisstepid = '4755'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE visitfeedback SET `feedback` = 'Distance of ANC OPD and PPTCT is more', `recommendation` = 'Attendant should accompany with partcipant', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE visitfeedbackid = '3486'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE visitfeedback SET `feedback` = 'Whitner is used', `recommendation` = 'Told them do not use whitener', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE visitfeedbackid = '3487'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE visitfeedbackid = '3488'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE visitfeedbackid = '3489'"} {"userId":"7","date":"2020-12-04 16:35:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:35:19' WHERE visitfeedbackid = '3490'"} {"userId":"7","date":"2020-12-04 16:42:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2020-12-04 16:42:30')"} {"userId":"7","date":"2020-12-04 16:42:44","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('477', '2020-12-04', '7', '14.139.125.18', '7', '2020-12-04 16:42:44')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('477', '931', '7', '2020-12-04', '1', '14.139.125.18', '7', '2020-12-04 16:42:54', '', '')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '0', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '1', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '2', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '3', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '4', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '5', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('743', '6', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('743', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('743', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('743', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('743', '', '', 'Array', '', 'Array', '', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:42:54","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('743', '14.139.125.18', '7', '2020-12-04 16:42:54')"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE sitesupervision SET `siteid` = '477', `userid` = '7', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2020-12-04', `numofsamplecollected` = '2', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20', `locationtype` = '2', `establishmentyear` = '2001', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '743'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE onssid = '3300'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE onssid = '3301'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE onssid = '3302'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE onssid = '3303'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77812 then '' when ansid=77813 then '' when ansid=77814 then '' when ansid=77815 then '' when ansid=77816 then '' when ansid=77817 then '' when ansid=77818 then '' when ansid=77819 then '' when ansid=77821 then '' when ansid=77823 then '' when ansid=77825 then '' when ansid=77827 then '' when ansid=77829 then '' when ansid=77831 then '' when ansid=77833 then '' when ansid=77835 then '' when ansid=77837 then '' when ansid=77839 then '' when ansid=77841 then '' when ansid=77843 then '' when ansid=77845 then '' when ansid=77847 then '' when ansid=77849 then '' when ansid=77851 then '' when ansid=77853 then '' when ansid=77855 then '' when ansid=77857 then '' when ansid=77859 then '' when ansid=77861 then '' when ansid=77863 then '' when ansid=77865 then '' when ansid=77867 then '' when ansid=77869 then '' when ansid=77871 then '' when ansid=77872 then '' when ansid=77873 then '' when ansid=77874 then '' when ansid=77875 then '' when ansid=77876 then '' when ansid=77877 then '' when ansid=77878 then '' when ansid=77879 then '' when ansid=77880 then '' when ansid=77881 then '' when ansid=77882 then '' when ansid=77883 then '' when ansid=77884 then '' when ansid=77885 then '' when ansid=77886 then '' when ansid=77887 then '' when ansid=77888 then '' when ansid=77889 then '' when ansid=77890 then '' when ansid=77891 then '' when ansid=77892 then '' when ansid=77893 then '' when ansid=77894 then '' when ansid=77895 then '' when ansid=77896 then '' when ansid=77897 then '' when ansid=77898 then '' when ansid=77899 then '' when ansid=77900 then '' when ansid=77901 then '' when ansid=77902 then '' when ansid=77903 then '' when ansid=77904 then '' when ansid=77905 then '' when ansid=77906 then '' when ansid=77907 then '' when ansid=77908 then '' when ansid=77909 then '' when ansid=77910 then '' when ansid=77911 then '' when ansid=77912 then '' when ansid=77913 then '' when ansid=77914 then '' when ansid=77915 then '' when ansid=77916 then '' when ansid=77917 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:43:20'\n\t\t\t\t\t\t\tWHERE ansid in ('77812','77813','77814','77815','77816','77817','77818','77819','77821','77823','77825','77827','77829','77831','77833','77835','77837','77839','77841','77843','77845','77847','77849','77851','77853','77855','77857','77859','77861','77863','77865','77867','77869','77871','77872','77873','77874','77875','77876','77877','77878','77879','77880','77881','77882','77883','77884','77885','77886','77887','77888','77889','77890','77891','77892','77893','77894','77895','77896','77897','77898','77899','77900','77901','77902','77903','77904','77905','77906','77907','77908','77909','77910','77911','77912','77913','77914','77915','77916','77917')"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE supvisstepid = '4756'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE visitfeedbackid = '3491'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE visitfeedbackid = '3492'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE visitfeedbackid = '3493'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE visitfeedbackid = '3494'"} {"userId":"7","date":"2020-12-04 16:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:20' WHERE visitfeedbackid = '3495'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE sitesupervision SET `siteid` = '477', `userid` = '7', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2020-12-04', `numofsamplecollected` = '2', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32', `locationtype` = '2', `establishmentyear` = '2001', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '743'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE onssid = '3300'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE onssid = '3301'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE onssid = '3302'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE onssid = '3303'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77812 then '2' when ansid=77813 then '1' when ansid=77814 then '2' when ansid=77815 then '1' when ansid=77816 then '' when ansid=77817 then '' when ansid=77818 then '2' when ansid=77819 then '' when ansid=77821 then '' when ansid=77823 then '' when ansid=77825 then '' when ansid=77827 then '' when ansid=77829 then '' when ansid=77831 then '' when ansid=77833 then '' when ansid=77835 then '' when ansid=77837 then '' when ansid=77839 then '' when ansid=77841 then '' when ansid=77843 then '' when ansid=77845 then '' when ansid=77847 then '' when ansid=77849 then '' when ansid=77851 then '' when ansid=77853 then '' when ansid=77855 then '' when ansid=77857 then '' when ansid=77859 then '' when ansid=77861 then '' when ansid=77863 then '' when ansid=77865 then '' when ansid=77867 then '' when ansid=77869 then '' when ansid=77871 then '' when ansid=77872 then '' when ansid=77873 then '' when ansid=77874 then '' when ansid=77875 then '' when ansid=77876 then '' when ansid=77877 then '' when ansid=77878 then '' when ansid=77879 then '' when ansid=77880 then '' when ansid=77881 then '' when ansid=77882 then '' when ansid=77883 then '' when ansid=77884 then '' when ansid=77885 then '' when ansid=77886 then '' when ansid=77887 then '' when ansid=77888 then '' when ansid=77889 then '' when ansid=77890 then '' when ansid=77891 then '' when ansid=77892 then '' when ansid=77893 then '' when ansid=77894 then '' when ansid=77895 then '' when ansid=77896 then '' when ansid=77897 then '' when ansid=77898 then '' when ansid=77899 then '' when ansid=77900 then '' when ansid=77901 then '' when ansid=77902 then '' when ansid=77903 then '' when ansid=77904 then '' when ansid=77905 then '' when ansid=77906 then '' when ansid=77907 then '' when ansid=77908 then '' when ansid=77909 then '' when ansid=77910 then '' when ansid=77911 then '' when ansid=77912 then '' when ansid=77913 then '' when ansid=77914 then '' when ansid=77915 then '' when ansid=77916 then '' when ansid=77917 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:43:32'\n\t\t\t\t\t\t\tWHERE ansid in ('77812','77813','77814','77815','77816','77817','77818','77819','77821','77823','77825','77827','77829','77831','77833','77835','77837','77839','77841','77843','77845','77847','77849','77851','77853','77855','77857','77859','77861','77863','77865','77867','77869','77871','77872','77873','77874','77875','77876','77877','77878','77879','77880','77881','77882','77883','77884','77885','77886','77887','77888','77889','77890','77891','77892','77893','77894','77895','77896','77897','77898','77899','77900','77901','77902','77903','77904','77905','77906','77907','77908','77909','77910','77911','77912','77913','77914','77915','77916','77917')"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE supvisstepid = '4757'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE visitfeedbackid = '3491'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE visitfeedbackid = '3492'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE visitfeedbackid = '3493'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE visitfeedbackid = '3494'"} {"userId":"7","date":"2020-12-04 16:43:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:32' WHERE visitfeedbackid = '3495'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE sitesupervision SET `siteid` = '477', `userid` = '7', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2020-12-04', `numofsamplecollected` = '2', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49', `locationtype` = '2', `establishmentyear` = '2001', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '743'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE onssid = '3300'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE onssid = '3301'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE onssid = '3302'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE onssid = '3303'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77812 then '2' when ansid=77813 then '1' when ansid=77814 then '2' when ansid=77815 then '1' when ansid=77816 then '' when ansid=77817 then '' when ansid=77818 then '2' when ansid=77819 then '3' when ansid=77821 then '1' when ansid=77823 then '450' when ansid=77825 then '25' when ansid=77827 then '25' when ansid=77829 then '500' when ansid=77831 then '1' when ansid=77833 then '1' when ansid=77835 then '' when ansid=77837 then '' when ansid=77839 then '' when ansid=77841 then '' when ansid=77843 then '' when ansid=77845 then '' when ansid=77847 then '' when ansid=77849 then '' when ansid=77851 then '' when ansid=77853 then '' when ansid=77855 then '' when ansid=77857 then '' when ansid=77859 then '' when ansid=77861 then '' when ansid=77863 then '' when ansid=77865 then '' when ansid=77867 then '' when ansid=77869 then '' when ansid=77871 then '' when ansid=77872 then '' when ansid=77873 then '' when ansid=77874 then '' when ansid=77875 then '' when ansid=77876 then '' when ansid=77877 then '' when ansid=77878 then '' when ansid=77879 then '' when ansid=77880 then '' when ansid=77881 then '' when ansid=77882 then '' when ansid=77883 then '' when ansid=77884 then '' when ansid=77885 then '' when ansid=77886 then '' when ansid=77887 then '' when ansid=77888 then '' when ansid=77889 then '' when ansid=77890 then '' when ansid=77891 then '' when ansid=77892 then '' when ansid=77893 then '' when ansid=77894 then '' when ansid=77895 then '' when ansid=77896 then '' when ansid=77897 then '' when ansid=77898 then '' when ansid=77899 then '' when ansid=77900 then '' when ansid=77901 then '' when ansid=77902 then '' when ansid=77903 then '' when ansid=77904 then '' when ansid=77905 then '' when ansid=77906 then '' when ansid=77907 then '' when ansid=77908 then '' when ansid=77909 then '' when ansid=77910 then '' when ansid=77911 then '' when ansid=77912 then '' when ansid=77913 then '' when ansid=77914 then '' when ansid=77915 then '' when ansid=77916 then '' when ansid=77917 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:43:49'\n\t\t\t\t\t\t\tWHERE ansid in ('77812','77813','77814','77815','77816','77817','77818','77819','77821','77823','77825','77827','77829','77831','77833','77835','77837','77839','77841','77843','77845','77847','77849','77851','77853','77855','77857','77859','77861','77863','77865','77867','77869','77871','77872','77873','77874','77875','77876','77877','77878','77879','77880','77881','77882','77883','77884','77885','77886','77887','77888','77889','77890','77891','77892','77893','77894','77895','77896','77897','77898','77899','77900','77901','77902','77903','77904','77905','77906','77907','77908','77909','77910','77911','77912','77913','77914','77915','77916','77917')"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE supvisstepid = '4758'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE visitfeedbackid = '3491'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE visitfeedbackid = '3492'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE visitfeedbackid = '3493'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE visitfeedbackid = '3494'"} {"userId":"7","date":"2020-12-04 16:43:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:43:49' WHERE visitfeedbackid = '3495'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE sitesupervision SET `siteid` = '477', `userid` = '7', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2020-12-04', `numofsamplecollected` = '2', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15', `locationtype` = '2', `establishmentyear` = '2001', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '743'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE onssid = '3300'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE onssid = '3301'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE onssid = '3302'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE onssid = '3303'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77812 then '2' when ansid=77813 then '1' when ansid=77814 then '2' when ansid=77815 then '1' when ansid=77816 then '' when ansid=77817 then '' when ansid=77818 then '2' when ansid=77819 then '3' when ansid=77821 then '1' when ansid=77823 then '450' when ansid=77825 then '25' when ansid=77827 then '25' when ansid=77829 then '500' when ansid=77831 then '1' when ansid=77833 then '1' when ansid=77835 then '2' when ansid=77837 then '450' when ansid=77839 then '200' when ansid=77841 then '400' when ansid=77843 then '25' when ansid=77845 then '1' when ansid=77847 then '450' when ansid=77849 then '450' when ansid=77851 then '500' when ansid=77853 then '2' when ansid=77855 then '5' when ansid=77857 then '1' when ansid=77859 then '5' when ansid=77861 then '' when ansid=77863 then '' when ansid=77865 then '' when ansid=77867 then '' when ansid=77869 then '' when ansid=77871 then '' when ansid=77872 then '' when ansid=77873 then '' when ansid=77874 then '' when ansid=77875 then '' when ansid=77876 then '' when ansid=77877 then '' when ansid=77878 then '' when ansid=77879 then '' when ansid=77880 then '' when ansid=77881 then '' when ansid=77882 then '' when ansid=77883 then '' when ansid=77884 then '' when ansid=77885 then '' when ansid=77886 then '' when ansid=77887 then '' when ansid=77888 then '' when ansid=77889 then '' when ansid=77890 then '' when ansid=77891 then '' when ansid=77892 then '' when ansid=77893 then '' when ansid=77894 then '' when ansid=77895 then '' when ansid=77896 then '' when ansid=77897 then '' when ansid=77898 then '' when ansid=77899 then '' when ansid=77900 then '' when ansid=77901 then '' when ansid=77902 then '' when ansid=77903 then '' when ansid=77904 then '' when ansid=77905 then '' when ansid=77906 then '' when ansid=77907 then '' when ansid=77908 then '' when ansid=77909 then '' when ansid=77910 then '' when ansid=77911 then '' when ansid=77912 then '' when ansid=77913 then '' when ansid=77914 then '' when ansid=77915 then '' when ansid=77916 then '' when ansid=77917 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:44:15'\n\t\t\t\t\t\t\tWHERE ansid in ('77812','77813','77814','77815','77816','77817','77818','77819','77821','77823','77825','77827','77829','77831','77833','77835','77837','77839','77841','77843','77845','77847','77849','77851','77853','77855','77857','77859','77861','77863','77865','77867','77869','77871','77872','77873','77874','77875','77876','77877','77878','77879','77880','77881','77882','77883','77884','77885','77886','77887','77888','77889','77890','77891','77892','77893','77894','77895','77896','77897','77898','77899','77900','77901','77902','77903','77904','77905','77906','77907','77908','77909','77910','77911','77912','77913','77914','77915','77916','77917')"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE supvisstepid = '4759'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE visitfeedbackid = '3491'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE visitfeedbackid = '3492'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE visitfeedbackid = '3493'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE visitfeedbackid = '3494'"} {"userId":"7","date":"2020-12-04 16:44:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:15' WHERE visitfeedbackid = '3495'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE sitesupervision SET `siteid` = '477', `userid` = '7', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2020-12-04', `numofsamplecollected` = '2', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23', `locationtype` = '2', `establishmentyear` = '2001', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '743'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE onssid = '3300'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE onssid = '3301'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE onsitestaffs SET `staffname` = 'asd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE onssid = '3302'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE onssid = '3303'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77812 then '2' when ansid=77813 then '1' when ansid=77814 then '2' when ansid=77815 then '1' when ansid=77816 then '' when ansid=77817 then '' when ansid=77818 then '2' when ansid=77819 then '3' when ansid=77821 then '1' when ansid=77823 then '450' when ansid=77825 then '25' when ansid=77827 then '25' when ansid=77829 then '500' when ansid=77831 then '1' when ansid=77833 then '1' when ansid=77835 then '2' when ansid=77837 then '450' when ansid=77839 then '200' when ansid=77841 then '400' when ansid=77843 then '25' when ansid=77845 then '1' when ansid=77847 then '450' when ansid=77849 then '450' when ansid=77851 then '500' when ansid=77853 then '2' when ansid=77855 then '5' when ansid=77857 then '1' when ansid=77859 then '5' when ansid=77861 then '1' when ansid=77863 then '1' when ansid=77865 then '1' when ansid=77867 then '250' when ansid=77869 then '7' when ansid=77871 then '' when ansid=77872 then '' when ansid=77873 then '' when ansid=77874 then '' when ansid=77875 then '' when ansid=77876 then '' when ansid=77877 then '' when ansid=77878 then '' when ansid=77879 then '' when ansid=77880 then '' when ansid=77881 then '' when ansid=77882 then '' when ansid=77883 then '' when ansid=77884 then '' when ansid=77885 then '' when ansid=77886 then '' when ansid=77887 then '' when ansid=77888 then '' when ansid=77889 then '' when ansid=77890 then '' when ansid=77891 then '' when ansid=77892 then '' when ansid=77893 then '' when ansid=77894 then '' when ansid=77895 then '' when ansid=77896 then '' when ansid=77897 then '' when ansid=77898 then '' when ansid=77899 then '' when ansid=77900 then '' when ansid=77901 then '' when ansid=77902 then '' when ansid=77903 then '' when ansid=77904 then '' when ansid=77905 then '' when ansid=77906 then '' when ansid=77907 then '' when ansid=77908 then '' when ansid=77909 then '' when ansid=77910 then '' when ansid=77911 then '' when ansid=77912 then '' when ansid=77913 then '' when ansid=77914 then '' when ansid=77915 then '' when ansid=77916 then '' when ansid=77917 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.125.18',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 16:44:23'\n\t\t\t\t\t\t\tWHERE ansid in ('77812','77813','77814','77815','77816','77817','77818','77819','77821','77823','77825','77827','77829','77831','77833','77835','77837','77839','77841','77843','77845','77847','77849','77851','77853','77855','77857','77859','77861','77863','77865','77867','77869','77871','77872','77873','77874','77875','77876','77877','77878','77879','77880','77881','77882','77883','77884','77885','77886','77887','77888','77889','77890','77891','77892','77893','77894','77895','77896','77897','77898','77899','77900','77901','77902','77903','77904','77905','77906','77907','77908','77909','77910','77911','77912','77913','77914','77915','77916','77917')"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE supvisstepid = '4760'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE visitfeedbackid = '3491'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE visitfeedbackid = '3492'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE visitfeedbackid = '3493'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE visitfeedbackid = '3494'"} {"userId":"7","date":"2020-12-04 16:44:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2020-12-04 16:44:23' WHERE visitfeedbackid = '3495'"} {"userId":"5","date":"2020-12-04 19:23:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '47.29.50.149', '2020-12-04 19:23:31')"} {"userId":"5","date":"2020-12-04 19:49:39","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('147', '2020-12-01', '5', '47.29.50.149', '5', '2020-12-04 19:49:39')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('147', '932', '5', '2020-12-04', '1', '47.29.50.149', '5', '2020-12-04 19:51:58', '', '')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '0', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '1', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '2', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '3', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '4', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '5', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('744', '6', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('744', '', '', 'Array', '', 'Array', '', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('744', '', '', 'Array', '', 'Array', '', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('744', '', '', 'Array', '', 'Array', '', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('744', '', '', 'Array', '', 'Array', '', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:51:58","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('744', '47.29.50.149', '5', '2020-12-04 19:51:58')"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '' when ansid=77919 then '' when ansid=77920 then '' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '' when ansid=77924 then '' when ansid=77925 then '' when ansid=77927 then '' when ansid=77929 then '' when ansid=77931 then '' when ansid=77933 then '' when ansid=77935 then '' when ansid=77937 then '' when ansid=77939 then '' when ansid=77941 then '' when ansid=77943 then '' when ansid=77945 then '' when ansid=77947 then '' when ansid=77949 then '' when ansid=77951 then '' when ansid=77953 then '' when ansid=77955 then '' when ansid=77957 then '' when ansid=77959 then '' when ansid=77961 then '' when ansid=77963 then '' when ansid=77965 then '' when ansid=77967 then '' when ansid=77969 then '' when ansid=77971 then '' when ansid=77973 then '' when ansid=77975 then '' when ansid=77977 then '' when ansid=77978 then '' when ansid=77979 then '' when ansid=77980 then '' when ansid=77981 then '' when ansid=77982 then '' when ansid=77983 then '' when ansid=77984 then '' when ansid=77985 then '' when ansid=77986 then '' when ansid=77987 then '' when ansid=77988 then '' when ansid=77989 then '' when ansid=77990 then '' when ansid=77991 then '' when ansid=77992 then '' when ansid=77993 then '' when ansid=77994 then '' when ansid=77995 then '' when ansid=77996 then '' when ansid=77997 then '' when ansid=77998 then '' when ansid=77999 then '' when ansid=78000 then '' when ansid=78001 then '' when ansid=78002 then '' when ansid=78003 then '' when ansid=78004 then '' when ansid=78005 then '' when ansid=78006 then '' when ansid=78007 then '' when ansid=78008 then '' when ansid=78009 then '' when ansid=78010 then '' when ansid=78011 then '' when ansid=78012 then '' when ansid=78013 then '' when ansid=78014 then '' when ansid=78015 then '' when ansid=78016 then '' when ansid=78017 then '' when ansid=78018 then '' when ansid=78019 then '' when ansid=78020 then '' when ansid=78021 then '' when ansid=78022 then '' when ansid=78023 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 19:53:21'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE supvisstepid = '4763'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 19:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:53:21' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '' when ansid=77927 then '' when ansid=77929 then '' when ansid=77931 then '' when ansid=77933 then '' when ansid=77935 then '' when ansid=77937 then '' when ansid=77939 then '' when ansid=77941 then '' when ansid=77943 then '' when ansid=77945 then '' when ansid=77947 then '' when ansid=77949 then '' when ansid=77951 then '' when ansid=77953 then '' when ansid=77955 then '' when ansid=77957 then '' when ansid=77959 then '' when ansid=77961 then '' when ansid=77963 then '' when ansid=77965 then '' when ansid=77967 then '' when ansid=77969 then '' when ansid=77971 then '' when ansid=77973 then '' when ansid=77975 then '' when ansid=77977 then '' when ansid=77978 then '' when ansid=77979 then '' when ansid=77980 then '' when ansid=77981 then '' when ansid=77982 then '' when ansid=77983 then '' when ansid=77984 then '' when ansid=77985 then '' when ansid=77986 then '' when ansid=77987 then '' when ansid=77988 then '' when ansid=77989 then '' when ansid=77990 then '' when ansid=77991 then '' when ansid=77992 then '' when ansid=77993 then '' when ansid=77994 then '' when ansid=77995 then '' when ansid=77996 then '' when ansid=77997 then '' when ansid=77998 then '' when ansid=77999 then '' when ansid=78000 then '' when ansid=78001 then '' when ansid=78002 then '' when ansid=78003 then '' when ansid=78004 then '' when ansid=78005 then '' when ansid=78006 then '' when ansid=78007 then '' when ansid=78008 then '' when ansid=78009 then '' when ansid=78010 then '' when ansid=78011 then '' when ansid=78012 then '' when ansid=78013 then '' when ansid=78014 then '' when ansid=78015 then '' when ansid=78016 then '' when ansid=78017 then '' when ansid=78018 then '' when ansid=78019 then '' when ansid=78020 then '' when ansid=78021 then '' when ansid=78022 then '' when ansid=78023 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 19:54:47'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE supvisstepid = '4764'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 19:54:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:54:47' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '3' when ansid=77927 then '1' when ansid=77929 then '450' when ansid=77931 then '25' when ansid=77933 then '25' when ansid=77935 then '500' when ansid=77937 then '1' when ansid=77939 then '1' when ansid=77941 then '' when ansid=77943 then '' when ansid=77945 then '' when ansid=77947 then '' when ansid=77949 then '' when ansid=77951 then '' when ansid=77953 then '' when ansid=77955 then '' when ansid=77957 then '' when ansid=77959 then '' when ansid=77961 then '' when ansid=77963 then '' when ansid=77965 then '' when ansid=77967 then '' when ansid=77969 then '' when ansid=77971 then '' when ansid=77973 then '' when ansid=77975 then '' when ansid=77977 then '' when ansid=77978 then '' when ansid=77979 then '' when ansid=77980 then '' when ansid=77981 then '' when ansid=77982 then '' when ansid=77983 then '' when ansid=77984 then '' when ansid=77985 then '' when ansid=77986 then '' when ansid=77987 then '' when ansid=77988 then '' when ansid=77989 then '' when ansid=77990 then '' when ansid=77991 then '' when ansid=77992 then '' when ansid=77993 then '' when ansid=77994 then '' when ansid=77995 then '' when ansid=77996 then '' when ansid=77997 then '' when ansid=77998 then '' when ansid=77999 then '' when ansid=78000 then '' when ansid=78001 then '' when ansid=78002 then '' when ansid=78003 then '' when ansid=78004 then '' when ansid=78005 then '' when ansid=78006 then '' when ansid=78007 then '' when ansid=78008 then '' when ansid=78009 then '' when ansid=78010 then '' when ansid=78011 then '' when ansid=78012 then '' when ansid=78013 then '' when ansid=78014 then '' when ansid=78015 then '' when ansid=78016 then '' when ansid=78017 then '' when ansid=78018 then '' when ansid=78019 then '' when ansid=78020 then '' when ansid=78021 then '' when ansid=78022 then '' when ansid=78023 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 19:55:40'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE supvisstepid = '4765'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 19:55:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:55:40' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '3' when ansid=77927 then '1' when ansid=77929 then '450' when ansid=77931 then '25' when ansid=77933 then '25' when ansid=77935 then '500' when ansid=77937 then '1' when ansid=77939 then '1' when ansid=77941 then '2' when ansid=77943 then '450' when ansid=77945 then '450' when ansid=77947 then '450' when ansid=77949 then '25' when ansid=77951 then '1' when ansid=77953 then '450' when ansid=77955 then '450' when ansid=77957 then '500' when ansid=77959 then '2' when ansid=77961 then '5' when ansid=77963 then '1' when ansid=77965 then '5' when ansid=77967 then '' when ansid=77969 then '' when ansid=77971 then '' when ansid=77973 then '' when ansid=77975 then '' when ansid=77977 then '' when ansid=77978 then '' when ansid=77979 then '' when ansid=77980 then '' when ansid=77981 then '' when ansid=77982 then '' when ansid=77983 then '' when ansid=77984 then '' when ansid=77985 then '' when ansid=77986 then '' when ansid=77987 then '' when ansid=77988 then '' when ansid=77989 then '' when ansid=77990 then '' when ansid=77991 then '' when ansid=77992 then '' when ansid=77993 then '' when ansid=77994 then '' when ansid=77995 then '' when ansid=77996 then '' when ansid=77997 then '' when ansid=77998 then '' when ansid=77999 then '' when ansid=78000 then '' when ansid=78001 then '' when ansid=78002 then '' when ansid=78003 then '' when ansid=78004 then '' when ansid=78005 then '' when ansid=78006 then '' when ansid=78007 then '' when ansid=78008 then '' when ansid=78009 then '' when ansid=78010 then '' when ansid=78011 then '' when ansid=78012 then '' when ansid=78013 then '' when ansid=78014 then '' when ansid=78015 then '' when ansid=78016 then '' when ansid=78017 then '' when ansid=78018 then '' when ansid=78019 then '' when ansid=78020 then '' when ansid=78021 then '' when ansid=78022 then '' when ansid=78023 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 19:57:58'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE supvisstepid = '4766'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 19:57:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:57:58' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '3' when ansid=77927 then '1' when ansid=77929 then '450' when ansid=77931 then '25' when ansid=77933 then '25' when ansid=77935 then '500' when ansid=77937 then '1' when ansid=77939 then '1' when ansid=77941 then '2' when ansid=77943 then '450' when ansid=77945 then '450' when ansid=77947 then '450' when ansid=77949 then '25' when ansid=77951 then '1' when ansid=77953 then '450' when ansid=77955 then '450' when ansid=77957 then '500' when ansid=77959 then '2' when ansid=77961 then '5' when ansid=77963 then '1' when ansid=77965 then '5' when ansid=77967 then '1' when ansid=77969 then '1' when ansid=77971 then '1' when ansid=77973 then '90' when ansid=77975 then '5' when ansid=77977 then '' when ansid=77978 then '' when ansid=77979 then '' when ansid=77980 then '' when ansid=77981 then '' when ansid=77982 then '' when ansid=77983 then '' when ansid=77984 then '' when ansid=77985 then '' when ansid=77986 then '' when ansid=77987 then '' when ansid=77988 then '' when ansid=77989 then '' when ansid=77990 then '' when ansid=77991 then '' when ansid=77992 then '' when ansid=77993 then '' when ansid=77994 then '' when ansid=77995 then '' when ansid=77996 then '' when ansid=77997 then '' when ansid=77998 then '' when ansid=77999 then '' when ansid=78000 then '' when ansid=78001 then '' when ansid=78002 then '' when ansid=78003 then '' when ansid=78004 then '' when ansid=78005 then '' when ansid=78006 then '' when ansid=78007 then '' when ansid=78008 then '' when ansid=78009 then '' when ansid=78010 then '' when ansid=78011 then '' when ansid=78012 then '' when ansid=78013 then '' when ansid=78014 then '' when ansid=78015 then '' when ansid=78016 then '' when ansid=78017 then '' when ansid=78018 then '' when ansid=78019 then '' when ansid=78020 then '' when ansid=78021 then '' when ansid=78022 then '' when ansid=78023 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 19:58:45'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE supvisstepid = '4767'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 19:58:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 19:58:45' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '3' when ansid=77927 then '1' when ansid=77929 then '450' when ansid=77931 then '25' when ansid=77933 then '25' when ansid=77935 then '500' when ansid=77937 then '1' when ansid=77939 then '1' when ansid=77941 then '2' when ansid=77943 then '450' when ansid=77945 then '450' when ansid=77947 then '450' when ansid=77949 then '25' when ansid=77951 then '1' when ansid=77953 then '450' when ansid=77955 then '450' when ansid=77957 then '500' when ansid=77959 then '2' when ansid=77961 then '5' when ansid=77963 then '1' when ansid=77965 then '5' when ansid=77967 then '1' when ansid=77969 then '1' when ansid=77971 then '1' when ansid=77973 then '90' when ansid=77975 then '5' when ansid=77977 then '2' when ansid=77978 then '2' when ansid=77979 then '4' when ansid=77980 then '3' when ansid=77981 then '' when ansid=77982 then '1' when ansid=77983 then '1' when ansid=77984 then '' when ansid=77985 then '1' when ansid=77986 then '' when ansid=77987 then '1' when ansid=77988 then '4' when ansid=77989 then '1' when ansid=77990 then '1' when ansid=77991 then 'Counsellor' when ansid=77992 then '1' when ansid=77993 then '' when ansid=77994 then '1' when ansid=77995 then '1' when ansid=77996 then '' when ansid=77997 then '1' when ansid=77998 then '1' when ansid=77999 then '1' when ansid=78000 then '1' when ansid=78001 then '1' when ansid=78002 then '1' when ansid=78003 then '3' when ansid=78004 then '1' when ansid=78005 then '1' when ansid=78006 then '1' when ansid=78007 then '' when ansid=78008 then '1' when ansid=78009 then '' when ansid=78010 then '1' when ansid=78011 then '1' when ansid=78012 then '1' when ansid=78013 then '' when ansid=78014 then '1' when ansid=78015 then '1' when ansid=78016 then '1' when ansid=78017 then '1' when ansid=78018 then '1' when ansid=78019 then '1' when ansid=78020 then 'No report' when ansid=78021 then 'No prev supervisory visit' when ansid=78022 then 'HSS activities are up to the mark' when ansid=78023 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 20:07:46'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE supvisstepid = '4768'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 20:07:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:07:46' WHERE visitfeedbackid = '3500'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE sitesupervision SET `siteid` = '147', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-01', `numofsamplecollected` = '20', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '744'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 1', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE onssid = '3304'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 2', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE onssid = '3305'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE onsitestaffs SET `staffname` = 'Staff 3', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE onssid = '3306'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE onssid = '3307'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77918 then '1' when ansid=77919 then '1' when ansid=77920 then '1' when ansid=77921 then '' when ansid=77922 then '' when ansid=77923 then '150' when ansid=77924 then '1' when ansid=77925 then '3' when ansid=77927 then '1' when ansid=77929 then '450' when ansid=77931 then '25' when ansid=77933 then '25' when ansid=77935 then '500' when ansid=77937 then '1' when ansid=77939 then '1' when ansid=77941 then '2' when ansid=77943 then '450' when ansid=77945 then '450' when ansid=77947 then '450' when ansid=77949 then '25' when ansid=77951 then '1' when ansid=77953 then '450' when ansid=77955 then '450' when ansid=77957 then '500' when ansid=77959 then '2' when ansid=77961 then '5' when ansid=77963 then '1' when ansid=77965 then '5' when ansid=77967 then '1' when ansid=77969 then '1' when ansid=77971 then '1' when ansid=77973 then '90' when ansid=77975 then '5' when ansid=77977 then '2' when ansid=77978 then '2' when ansid=77979 then '4' when ansid=77980 then '3' when ansid=77981 then '' when ansid=77982 then '1' when ansid=77983 then '1' when ansid=77984 then '' when ansid=77985 then '1' when ansid=77986 then '' when ansid=77987 then '1' when ansid=77988 then '4' when ansid=77989 then '1' when ansid=77990 then '1' when ansid=77991 then 'Counsellor' when ansid=77992 then '1' when ansid=77993 then '' when ansid=77994 then '1' when ansid=77995 then '1' when ansid=77996 then '' when ansid=77997 then '1' when ansid=77998 then '1' when ansid=77999 then '1' when ansid=78000 then '1' when ansid=78001 then '1' when ansid=78002 then '1' when ansid=78003 then '3' when ansid=78004 then '1' when ansid=78005 then '1' when ansid=78006 then '1' when ansid=78007 then '' when ansid=78008 then '1' when ansid=78009 then '' when ansid=78010 then '1' when ansid=78011 then '1' when ansid=78012 then '1' when ansid=78013 then '' when ansid=78014 then '1' when ansid=78015 then '1' when ansid=78016 then '1' when ansid=78017 then '1' when ansid=78018 then '1' when ansid=78019 then '1' when ansid=78020 then 'No report' when ansid=78021 then 'No prev supervisory visit' when ansid=78022 then 'HSS activities are up to the mark' when ansid=78023 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.50.149',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-04 20:10:53'\n\t\t\t\t\t\t\tWHERE ansid in ('77918','77919','77920','77921','77922','77923','77924','77925','77927','77929','77931','77933','77935','77937','77939','77941','77943','77945','77947','77949','77951','77953','77955','77957','77959','77961','77963','77965','77967','77969','77971','77973','77975','77977','77978','77979','77980','77981','77982','77983','77984','77985','77986','77987','77988','77989','77990','77991','77992','77993','77994','77995','77996','77997','77998','77999','78000','78001','78002','78003','78004','78005','78006','78007','78008','78009','78010','78011','78012','78013','78014','78015','78016','78017','78018','78019','78020','78021','78022','78023')"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE supvisstepid = '4769'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE visitfeedback SET `feedback` = 'Site in charge was not trained.', `recommendation` = 'Limited waste disposible bags. request SACS to look into this matter.', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE visitfeedbackid = '3496'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE visitfeedbackid = '3497'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE visitfeedbackid = '3498'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE visitfeedbackid = '3499'"} {"userId":"5","date":"2020-12-04 20:10:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.50.149', `modifiedby` = '5', `modifieddate` = '2020-12-04 20:10:53' WHERE visitfeedbackid = '3500'"}