{"userId":"575","date":"2023-03-11 10:48:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.1', '2023-03-11 10:48:06')"} {"userId":null,"date":"2023-03-11 11:06:56","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('651', '590525', '0', '103.172.55.55', '', '2023-03-11 11:06:56')"} {"userId":null,"date":"2023-03-11 11:20:21","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('651', '965682', '0', '103.172.55.55', '', '2023-03-11 11:20:21')"} {"userId":null,"date":"2023-03-11 11:22:34","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('651', '608687', '0', '103.172.55.55', '', '2023-03-11 11:22:34')"} {"userId":"651","date":"2023-03-11 12:04:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('651', '103.172.55.55', '2023-03-11 12:04:22')"} {"userId":"651","date":"2023-03-11 15:41:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('651', '103.172.55.55', '2023-03-11 15:41:15')"} {"userId":"651","date":"2023-03-11 15:42:41","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:42:41' WHERE plansiteid = '3252'"} {"userId":"651","date":"2023-03-11 15:42:41","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:42:41' WHERE ssid = ''"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('963', '3251', '651', '2023-03-11', '1', '103.172.55.55', '651', '2023-03-11 15:47:01', '', '')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2822', '0', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2822', '1', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2822', '2', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2822', '3', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2822', '4', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2822', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2822', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2822', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2822', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:47:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2822', '103.172.55.55', '651', '2023-03-11 15:47:01')"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE sitesupervision SET `siteid` = '963', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '376', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2822'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anna Juliet', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE onssid = '11616'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE onsitestaffs SET `staffname` = 'Desichrist', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE onssid = '11617'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE onsitestaffs SET `staffname` = 'Kaviarasi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE onssid = '11618'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE onssid = '11619'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267458 then '' when ansid=267459 then '' when ansid=267460 then '' when ansid=267461 then '' when ansid=267462 then '' when ansid=267463 then '' when ansid=267464 then '' when ansid=267564 then '' when ansid=267565 then '' when ansid=267507 then '' when ansid=267509 then '' when ansid=267511 then '' when ansid=267513 then '' when ansid=267515 then '' when ansid=267517 then '' when ansid=267518 then '' when ansid=267519 then '' when ansid=267520 then '' when ansid=267521 then '' when ansid=267522 then '' when ansid=267523 then '' when ansid=267524 then '' when ansid=267525 then '' when ansid=267526 then '' when ansid=267527 then '' when ansid=267528 then '' when ansid=267529 then '' when ansid=267530 then '' when ansid=267531 then '' when ansid=267532 then '' when ansid=267533 then '' when ansid=267534 then '' when ansid=267535 then '' when ansid=267536 then '' when ansid=267537 then '' when ansid=267538 then '' when ansid=267539 then '' when ansid=267540 then '' when ansid=267541 then '' when ansid=267542 then '' when ansid=267543 then '' when ansid=267544 then '' when ansid=267545 then '' when ansid=267546 then '' when ansid=267547 then '' when ansid=267548 then '' when ansid=267549 then '' when ansid=267550 then '' when ansid=267551 then '' when ansid=267552 then '' when ansid=267553 then '' when ansid=267554 then '' when ansid=267555 then '' when ansid=267556 then '' when ansid=267557 then '' when ansid=267558 then '' when ansid=267559 then '' when ansid=267560 then '' when ansid=267561 then '' when ansid=267562 then '' when ansid=267563 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:48:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267458','267459','267460','267461','267462','267463','267464','267564','267565','267507','267509','267511','267513','267515','267517','267518','267519','267520','267521','267522','267523','267524','267525','267526','267527','267528','267529','267530','267531','267532','267533','267534','267535','267536','267537','267538','267539','267540','267541','267542','267543','267544','267545','267546','267547','267548','267549','267550','267551','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563')"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE supvisstepid = '13910'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE visitfeedbackid = '13886'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE visitfeedbackid = '13887'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE visitfeedbackid = '13888'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE visitfeedbackid = '13889'"} {"userId":"651","date":"2023-03-11 15:48:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:32' WHERE visitfeedbackid = '13890'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE sitesupervision SET `siteid` = '963', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '376', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2822'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anna Juliet', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE onssid = '11616'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE onsitestaffs SET `staffname` = 'Desichrist', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE onssid = '11617'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE onsitestaffs SET `staffname` = 'Kaviarasi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE onssid = '11618'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE onssid = '11619'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267458 then '1' when ansid=267459 then '1' when ansid=267460 then '1' when ansid=267461 then '' when ansid=267462 then '' when ansid=267463 then '' when ansid=267464 then '1' when ansid=267564 then '1' when ansid=267565 then '1' when ansid=267507 then '' when ansid=267509 then '' when ansid=267511 then '' when ansid=267513 then '' when ansid=267515 then '' when ansid=267517 then '' when ansid=267518 then '' when ansid=267519 then '' when ansid=267520 then '' when ansid=267521 then '' when ansid=267522 then '' when ansid=267523 then '' when ansid=267524 then '' when ansid=267525 then '' when ansid=267526 then '' when ansid=267527 then '' when ansid=267528 then '' when ansid=267529 then '' when ansid=267530 then '' when ansid=267531 then '' when ansid=267532 then '' when ansid=267533 then '' when ansid=267534 then '' when ansid=267535 then '' when ansid=267536 then '' when ansid=267537 then '' when ansid=267538 then '' when ansid=267539 then '' when ansid=267540 then '' when ansid=267541 then '' when ansid=267542 then '' when ansid=267543 then '' when ansid=267544 then '' when ansid=267545 then '' when ansid=267546 then '' when ansid=267547 then '' when ansid=267548 then '' when ansid=267549 then '' when ansid=267550 then '' when ansid=267551 then '' when ansid=267552 then '' when ansid=267553 then '' when ansid=267554 then '' when ansid=267555 then '' when ansid=267556 then '' when ansid=267557 then '' when ansid=267558 then '' when ansid=267559 then '' when ansid=267560 then '' when ansid=267561 then '' when ansid=267562 then '' when ansid=267563 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:48:47'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267458','267459','267460','267461','267462','267463','267464','267564','267565','267507','267509','267511','267513','267515','267517','267518','267519','267520','267521','267522','267523','267524','267525','267526','267527','267528','267529','267530','267531','267532','267533','267534','267535','267536','267537','267538','267539','267540','267541','267542','267543','267544','267545','267546','267547','267548','267549','267550','267551','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563')"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE supvisstepid = '13911'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE visitfeedbackid = '13886'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE visitfeedbackid = '13887'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE visitfeedbackid = '13888'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE visitfeedbackid = '13889'"} {"userId":"651","date":"2023-03-11 15:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:48:47' WHERE visitfeedbackid = '13890'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE sitesupervision SET `siteid` = '963', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '376', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2822'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anna Juliet', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE onssid = '11616'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE onsitestaffs SET `staffname` = 'Desichrist', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE onssid = '11617'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE onsitestaffs SET `staffname` = 'Kaviarasi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE onssid = '11618'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE onssid = '11619'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267458 then '1' when ansid=267459 then '1' when ansid=267460 then '1' when ansid=267461 then '' when ansid=267462 then '' when ansid=267463 then '' when ansid=267464 then '1' when ansid=267564 then '1' when ansid=267565 then '1' when ansid=267507 then '1' when ansid=267509 then '1' when ansid=267511 then '1' when ansid=267513 then '100' when ansid=267515 then '5' when ansid=267517 then '' when ansid=267518 then '' when ansid=267519 then '' when ansid=267520 then '' when ansid=267521 then '' when ansid=267522 then '' when ansid=267523 then '' when ansid=267524 then '' when ansid=267525 then '' when ansid=267526 then '' when ansid=267527 then '' when ansid=267528 then '' when ansid=267529 then '' when ansid=267530 then '' when ansid=267531 then '' when ansid=267532 then '' when ansid=267533 then '' when ansid=267534 then '' when ansid=267535 then '' when ansid=267536 then '' when ansid=267537 then '' when ansid=267538 then '' when ansid=267539 then '' when ansid=267540 then '' when ansid=267541 then '' when ansid=267542 then '' when ansid=267543 then '' when ansid=267544 then '' when ansid=267545 then '' when ansid=267546 then '' when ansid=267547 then '' when ansid=267548 then '' when ansid=267549 then '' when ansid=267550 then '' when ansid=267551 then '' when ansid=267552 then '' when ansid=267553 then '' when ansid=267554 then '' when ansid=267555 then '' when ansid=267556 then '' when ansid=267557 then '' when ansid=267558 then '' when ansid=267559 then '' when ansid=267560 then '' when ansid=267561 then '' when ansid=267562 then '' when ansid=267563 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:49:16'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267458','267459','267460','267461','267462','267463','267464','267564','267565','267507','267509','267511','267513','267515','267517','267518','267519','267520','267521','267522','267523','267524','267525','267526','267527','267528','267529','267530','267531','267532','267533','267534','267535','267536','267537','267538','267539','267540','267541','267542','267543','267544','267545','267546','267547','267548','267549','267550','267551','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563')"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE supvisstepid = '13912'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE visitfeedbackid = '13886'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE visitfeedbackid = '13887'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE visitfeedbackid = '13888'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE visitfeedbackid = '13889'"} {"userId":"651","date":"2023-03-11 15:49:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:49:16' WHERE visitfeedbackid = '13890'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE sitesupervision SET `siteid` = '963', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '376', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2822'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anna Juliet', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE onssid = '11616'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Desichrist', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE onssid = '11617'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Kaviarasi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE onssid = '11618'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE onssid = '11619'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267458 then '1' when ansid=267459 then '1' when ansid=267460 then '1' when ansid=267461 then '' when ansid=267462 then '' when ansid=267463 then '' when ansid=267464 then '1' when ansid=267564 then '1' when ansid=267565 then '1' when ansid=267507 then '1' when ansid=267509 then '1' when ansid=267511 then '1' when ansid=267513 then '100' when ansid=267515 then '5' when ansid=267517 then '2' when ansid=267518 then '1' when ansid=267519 then '800' when ansid=267520 then '140' when ansid=267521 then '' when ansid=267522 then '1' when ansid=267523 then '1' when ansid=267524 then '' when ansid=267525 then '1' when ansid=267526 then '' when ansid=267527 then '1' when ansid=267528 then '10' when ansid=267529 then '1' when ansid=267530 then '1' when ansid=267531 then 'Counselor' when ansid=267532 then '1' when ansid=267533 then '' when ansid=267534 then '1' when ansid=267535 then '1' when ansid=267536 then '' when ansid=267537 then '1' when ansid=267538 then '1' when ansid=267539 then '1' when ansid=267540 then '1' when ansid=267541 then '1' when ansid=267542 then '1' when ansid=267543 then '2' when ansid=267544 then '1' when ansid=267545 then '1' when ansid=267546 then '1' when ansid=267547 then '' when ansid=267548 then '3' when ansid=267549 then '' when ansid=267550 then '1' when ansid=267551 then '1' when ansid=267552 then '1' when ansid=267553 then '' when ansid=267554 then '1' when ansid=267555 then '1' when ansid=267556 then '1' when ansid=267557 then '1' when ansid=267558 then '1' when ansid=267559 then '0' when ansid=267560 then 'No' when ansid=267561 then 'No' when ansid=267562 then 'None' when ansid=267563 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:51:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267458','267459','267460','267461','267462','267463','267464','267564','267565','267507','267509','267511','267513','267515','267517','267518','267519','267520','267521','267522','267523','267524','267525','267526','267527','267528','267529','267530','267531','267532','267533','267534','267535','267536','267537','267538','267539','267540','267541','267542','267543','267544','267545','267546','267547','267548','267549','267550','267551','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563')"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE supvisstepid = '13913'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE visitfeedbackid = '13886'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE visitfeedbackid = '13887'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE visitfeedbackid = '13888'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE visitfeedbackid = '13889'"} {"userId":"651","date":"2023-03-11 15:51:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:51:34' WHERE visitfeedbackid = '13890'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE sitesupervision SET `siteid` = '963', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '376', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2822'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anna Juliet', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE onssid = '11616'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE onsitestaffs SET `staffname` = 'Desichrist', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE onssid = '11617'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE onsitestaffs SET `staffname` = 'Kaviarasi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE onssid = '11618'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE onssid = '11619'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267458 then '1' when ansid=267459 then '1' when ansid=267460 then '1' when ansid=267461 then '' when ansid=267462 then '' when ansid=267463 then '' when ansid=267464 then '1' when ansid=267564 then '1' when ansid=267565 then '1' when ansid=267507 then '1' when ansid=267509 then '1' when ansid=267511 then '1' when ansid=267513 then '100' when ansid=267515 then '5' when ansid=267517 then '2' when ansid=267518 then '1' when ansid=267519 then '800' when ansid=267520 then '140' when ansid=267521 then '' when ansid=267522 then '1' when ansid=267523 then '1' when ansid=267524 then '' when ansid=267525 then '1' when ansid=267526 then '' when ansid=267527 then '1' when ansid=267528 then '10' when ansid=267529 then '1' when ansid=267530 then '1' when ansid=267531 then 'Counselor' when ansid=267532 then '1' when ansid=267533 then '' when ansid=267534 then '1' when ansid=267535 then '1' when ansid=267536 then '' when ansid=267537 then '1' when ansid=267538 then '1' when ansid=267539 then '1' when ansid=267540 then '1' when ansid=267541 then '1' when ansid=267542 then '1' when ansid=267543 then '2' when ansid=267544 then '1' when ansid=267545 then '1' when ansid=267546 then '1' when ansid=267547 then '' when ansid=267548 then '3' when ansid=267549 then '' when ansid=267550 then '1' when ansid=267551 then '1' when ansid=267552 then '1' when ansid=267553 then '' when ansid=267554 then '1' when ansid=267555 then '1' when ansid=267556 then '1' when ansid=267557 then '1' when ansid=267558 then '1' when ansid=267559 then '0' when ansid=267560 then 'No' when ansid=267561 then 'No' when ansid=267562 then 'None' when ansid=267563 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:52:00'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267458','267459','267460','267461','267462','267463','267464','267564','267565','267507','267509','267511','267513','267515','267517','267518','267519','267520','267521','267522','267523','267524','267525','267526','267527','267528','267529','267530','267531','267532','267533','267534','267535','267536','267537','267538','267539','267540','267541','267542','267543','267544','267545','267546','267547','267548','267549','267550','267551','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563')"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE supvisstepid = '13914'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE visitfeedback SET `feedback` = 'No specific issue identified', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE visitfeedbackid = '13886'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE visitfeedbackid = '13887'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE visitfeedbackid = '13888'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE visitfeedbackid = '13889'"} {"userId":"651","date":"2023-03-11 15:52:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:52:00' WHERE visitfeedbackid = '13890'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE sitesupervision SET `siteid` = '964', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '286', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2726'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vani Gopal', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE onssid = '11232'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE onsitestaffs SET `staffname` = 'Devane', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE onssid = '11233'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE onsitestaffs SET `staffname` = 'Bharathi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE onssid = '11234'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE onssid = '11235'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=257246 then '' when ansid=257247 then '' when ansid=257248 then '' when ansid=257249 then '' when ansid=257250 then '' when ansid=257251 then '' when ansid=257252 then '' when ansid=257352 then '' when ansid=257353 then '' when ansid=257295 then '' when ansid=257297 then '' when ansid=257299 then '' when ansid=257301 then '' when ansid=257303 then '' when ansid=257305 then '' when ansid=257306 then '' when ansid=257307 then '' when ansid=257308 then '' when ansid=257309 then '' when ansid=257310 then '' when ansid=257311 then '' when ansid=257312 then '' when ansid=257313 then '' when ansid=257314 then '' when ansid=257315 then '' when ansid=257316 then '' when ansid=257317 then '' when ansid=257318 then '' when ansid=257319 then '' when ansid=257320 then '' when ansid=257321 then '' when ansid=257322 then '' when ansid=257323 then '' when ansid=257324 then '' when ansid=257325 then '' when ansid=257326 then '' when ansid=257327 then '' when ansid=257328 then '' when ansid=257329 then '' when ansid=257330 then '' when ansid=257331 then '' when ansid=257332 then '' when ansid=257333 then '' when ansid=257334 then '' when ansid=257335 then '' when ansid=257336 then '' when ansid=257337 then '' when ansid=257338 then '' when ansid=257339 then '' when ansid=257340 then '' when ansid=257341 then '' when ansid=257342 then '' when ansid=257343 then '' when ansid=257344 then '' when ansid=257345 then '' when ansid=257346 then '' when ansid=257347 then '' when ansid=257348 then '' when ansid=257349 then '' when ansid=257350 then '' when ansid=257351 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 15:55:38'\r\n\t\t\t\t\t\t\tWHERE ansid in ('257246','257247','257248','257249','257250','257251','257252','257352','257353','257295','257297','257299','257301','257303','257305','257306','257307','257308','257309','257310','257311','257312','257313','257314','257315','257316','257317','257318','257319','257320','257321','257322','257323','257324','257325','257326','257327','257328','257329','257330','257331','257332','257333','257334','257335','257336','257337','257338','257339','257340','257341','257342','257343','257344','257345','257346','257347','257348','257349','257350','257351')"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE supvisstepid = '13444'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE visitfeedbackid = '13406'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE visitfeedbackid = '13407'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE visitfeedbackid = '13408'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE visitfeedbackid = '13409'"} {"userId":"651","date":"2023-03-11 15:55:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 15:55:38' WHERE visitfeedbackid = '13410'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE sitesupervision SET `siteid` = '964', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '286', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2726'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vani Gopal', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE onssid = '11232'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE onsitestaffs SET `staffname` = 'Devane', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE onssid = '11233'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE onsitestaffs SET `staffname` = 'Bharathi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE onssid = '11234'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE onssid = '11235'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=257246 then '1' when ansid=257247 then '1' when ansid=257248 then '1' when ansid=257249 then '' when ansid=257250 then '' when ansid=257251 then '' when ansid=257252 then '1' when ansid=257352 then '1' when ansid=257353 then '1' when ansid=257295 then '' when ansid=257297 then '' when ansid=257299 then '' when ansid=257301 then '' when ansid=257303 then '' when ansid=257305 then '' when ansid=257306 then '' when ansid=257307 then '' when ansid=257308 then '' when ansid=257309 then '' when ansid=257310 then '' when ansid=257311 then '' when ansid=257312 then '' when ansid=257313 then '' when ansid=257314 then '' when ansid=257315 then '' when ansid=257316 then '' when ansid=257317 then '' when ansid=257318 then '' when ansid=257319 then '' when ansid=257320 then '' when ansid=257321 then '' when ansid=257322 then '' when ansid=257323 then '' when ansid=257324 then '' when ansid=257325 then '' when ansid=257326 then '' when ansid=257327 then '' when ansid=257328 then '' when ansid=257329 then '' when ansid=257330 then '' when ansid=257331 then '' when ansid=257332 then '' when ansid=257333 then '' when ansid=257334 then '' when ansid=257335 then '' when ansid=257336 then '' when ansid=257337 then '' when ansid=257338 then '' when ansid=257339 then '' when ansid=257340 then '' when ansid=257341 then '' when ansid=257342 then '' when ansid=257343 then '' when ansid=257344 then '' when ansid=257345 then '' when ansid=257346 then '' when ansid=257347 then '' when ansid=257348 then '' when ansid=257349 then '' when ansid=257350 then '' when ansid=257351 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:00:25'\r\n\t\t\t\t\t\t\tWHERE ansid in ('257246','257247','257248','257249','257250','257251','257252','257352','257353','257295','257297','257299','257301','257303','257305','257306','257307','257308','257309','257310','257311','257312','257313','257314','257315','257316','257317','257318','257319','257320','257321','257322','257323','257324','257325','257326','257327','257328','257329','257330','257331','257332','257333','257334','257335','257336','257337','257338','257339','257340','257341','257342','257343','257344','257345','257346','257347','257348','257349','257350','257351')"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE supvisstepid = '13445'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE visitfeedbackid = '13406'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE visitfeedbackid = '13407'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE visitfeedbackid = '13408'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE visitfeedbackid = '13409'"} {"userId":"651","date":"2023-03-11 16:00:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:25' WHERE visitfeedbackid = '13410'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE sitesupervision SET `siteid` = '964', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '286', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2726'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vani Gopal', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE onssid = '11232'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE onsitestaffs SET `staffname` = 'Devane', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE onssid = '11233'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE onsitestaffs SET `staffname` = 'Bharathi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE onssid = '11234'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE onssid = '11235'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=257246 then '1' when ansid=257247 then '1' when ansid=257248 then '1' when ansid=257249 then '' when ansid=257250 then '' when ansid=257251 then '' when ansid=257252 then '1' when ansid=257352 then '1' when ansid=257353 then '1' when ansid=257295 then '1' when ansid=257297 then '1' when ansid=257299 then '1' when ansid=257301 then '100' when ansid=257303 then '5' when ansid=257305 then '' when ansid=257306 then '' when ansid=257307 then '' when ansid=257308 then '' when ansid=257309 then '' when ansid=257310 then '' when ansid=257311 then '' when ansid=257312 then '' when ansid=257313 then '' when ansid=257314 then '' when ansid=257315 then '' when ansid=257316 then '' when ansid=257317 then '' when ansid=257318 then '' when ansid=257319 then '' when ansid=257320 then '' when ansid=257321 then '' when ansid=257322 then '' when ansid=257323 then '' when ansid=257324 then '' when ansid=257325 then '' when ansid=257326 then '' when ansid=257327 then '' when ansid=257328 then '' when ansid=257329 then '' when ansid=257330 then '' when ansid=257331 then '' when ansid=257332 then '' when ansid=257333 then '' when ansid=257334 then '' when ansid=257335 then '' when ansid=257336 then '' when ansid=257337 then '' when ansid=257338 then '' when ansid=257339 then '' when ansid=257340 then '' when ansid=257341 then '' when ansid=257342 then '' when ansid=257343 then '' when ansid=257344 then '' when ansid=257345 then '' when ansid=257346 then '' when ansid=257347 then '' when ansid=257348 then '' when ansid=257349 then '' when ansid=257350 then '' when ansid=257351 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:00:41'\r\n\t\t\t\t\t\t\tWHERE ansid in ('257246','257247','257248','257249','257250','257251','257252','257352','257353','257295','257297','257299','257301','257303','257305','257306','257307','257308','257309','257310','257311','257312','257313','257314','257315','257316','257317','257318','257319','257320','257321','257322','257323','257324','257325','257326','257327','257328','257329','257330','257331','257332','257333','257334','257335','257336','257337','257338','257339','257340','257341','257342','257343','257344','257345','257346','257347','257348','257349','257350','257351')"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE supvisstepid = '13446'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE visitfeedbackid = '13406'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE visitfeedbackid = '13407'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE visitfeedbackid = '13408'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE visitfeedbackid = '13409'"} {"userId":"651","date":"2023-03-11 16:00:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:00:41' WHERE visitfeedbackid = '13410'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE sitesupervision SET `siteid` = '964', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '286', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2726'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vani Gopal', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE onssid = '11232'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE onsitestaffs SET `staffname` = 'Devane', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE onssid = '11233'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE onsitestaffs SET `staffname` = 'Bharathi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE onssid = '11234'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE onssid = '11235'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=257246 then '1' when ansid=257247 then '1' when ansid=257248 then '1' when ansid=257249 then '' when ansid=257250 then '' when ansid=257251 then '' when ansid=257252 then '1' when ansid=257352 then '1' when ansid=257353 then '1' when ansid=257295 then '1' when ansid=257297 then '1' when ansid=257299 then '1' when ansid=257301 then '100' when ansid=257303 then '5' when ansid=257305 then '2' when ansid=257306 then '2' when ansid=257307 then '1200' when ansid=257308 then '300' when ansid=257309 then '' when ansid=257310 then '1' when ansid=257311 then '1' when ansid=257312 then '' when ansid=257313 then '1' when ansid=257314 then '' when ansid=257315 then '1' when ansid=257316 then '10' when ansid=257317 then '1' when ansid=257318 then '1' when ansid=257319 then 'Counselor' when ansid=257320 then '1' when ansid=257321 then '' when ansid=257322 then '1' when ansid=257323 then '1' when ansid=257324 then '' when ansid=257325 then '1' when ansid=257326 then '1' when ansid=257327 then '1' when ansid=257328 then '1' when ansid=257329 then '1' when ansid=257330 then '1' when ansid=257331 then '2' when ansid=257332 then '1' when ansid=257333 then '1' when ansid=257334 then '1' when ansid=257335 then '' when ansid=257336 then '3' when ansid=257337 then '' when ansid=257338 then '1' when ansid=257339 then '1' when ansid=257340 then '1' when ansid=257341 then '' when ansid=257342 then '1' when ansid=257343 then '1' when ansid=257344 then '1' when ansid=257345 then '1' when ansid=257346 then '1' when ansid=257347 then '0' when ansid=257348 then 'None' when ansid=257349 then 'None' when ansid=257350 then 'None' when ansid=257351 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:02:31'\r\n\t\t\t\t\t\t\tWHERE ansid in ('257246','257247','257248','257249','257250','257251','257252','257352','257353','257295','257297','257299','257301','257303','257305','257306','257307','257308','257309','257310','257311','257312','257313','257314','257315','257316','257317','257318','257319','257320','257321','257322','257323','257324','257325','257326','257327','257328','257329','257330','257331','257332','257333','257334','257335','257336','257337','257338','257339','257340','257341','257342','257343','257344','257345','257346','257347','257348','257349','257350','257351')"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE supvisstepid = '13447'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE visitfeedbackid = '13406'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE visitfeedbackid = '13407'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE visitfeedbackid = '13408'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE visitfeedbackid = '13409'"} {"userId":"651","date":"2023-03-11 16:02:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:02:31' WHERE visitfeedbackid = '13410'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE sitesupervision SET `siteid` = '964', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '286', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2726'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vani Gopal', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE onssid = '11232'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE onsitestaffs SET `staffname` = 'Devane', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE onssid = '11233'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE onsitestaffs SET `staffname` = 'Bharathi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE onssid = '11234'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE onssid = '11235'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=257246 then '1' when ansid=257247 then '1' when ansid=257248 then '1' when ansid=257249 then '' when ansid=257250 then '' when ansid=257251 then '' when ansid=257252 then '1' when ansid=257352 then '1' when ansid=257353 then '1' when ansid=257295 then '1' when ansid=257297 then '1' when ansid=257299 then '1' when ansid=257301 then '100' when ansid=257303 then '5' when ansid=257305 then '2' when ansid=257306 then '2' when ansid=257307 then '1200' when ansid=257308 then '300' when ansid=257309 then '' when ansid=257310 then '1' when ansid=257311 then '1' when ansid=257312 then '' when ansid=257313 then '1' when ansid=257314 then '' when ansid=257315 then '1' when ansid=257316 then '10' when ansid=257317 then '1' when ansid=257318 then '1' when ansid=257319 then 'Counselor' when ansid=257320 then '1' when ansid=257321 then '' when ansid=257322 then '1' when ansid=257323 then '1' when ansid=257324 then '' when ansid=257325 then '1' when ansid=257326 then '1' when ansid=257327 then '1' when ansid=257328 then '1' when ansid=257329 then '1' when ansid=257330 then '1' when ansid=257331 then '2' when ansid=257332 then '1' when ansid=257333 then '1' when ansid=257334 then '1' when ansid=257335 then '' when ansid=257336 then '3' when ansid=257337 then '' when ansid=257338 then '1' when ansid=257339 then '1' when ansid=257340 then '1' when ansid=257341 then '' when ansid=257342 then '1' when ansid=257343 then '1' when ansid=257344 then '1' when ansid=257345 then '1' when ansid=257346 then '1' when ansid=257347 then '0' when ansid=257348 then 'None' when ansid=257349 then 'None' when ansid=257350 then 'None' when ansid=257351 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:03:14'\r\n\t\t\t\t\t\t\tWHERE ansid in ('257246','257247','257248','257249','257250','257251','257252','257352','257353','257295','257297','257299','257301','257303','257305','257306','257307','257308','257309','257310','257311','257312','257313','257314','257315','257316','257317','257318','257319','257320','257321','257322','257323','257324','257325','257326','257327','257328','257329','257330','257331','257332','257333','257334','257335','257336','257337','257338','257339','257340','257341','257342','257343','257344','257345','257346','257347','257348','257349','257350','257351')"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE supvisstepid = '13448'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE visitfeedback SET `feedback` = 'The Site staff requested increase in number of samples per day from the current 10 per day. Discussed with RI and asked to continue with 10 samples pr day', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE visitfeedbackid = '13406'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE visitfeedbackid = '13407'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE visitfeedbackid = '13408'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE visitfeedbackid = '13409'"} {"userId":"651","date":"2023-03-11 16:03:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:03:14' WHERE visitfeedbackid = '13410'"} {"userId":"651","date":"2023-03-11 16:14:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('651', '103.172.55.55', '2023-03-11 16:14:21')"} {"userId":"651","date":"2023-03-11 16:15:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('651', '103.172.55.55', '2023-03-11 16:15:05')"} {"userId":"651","date":"2023-03-11 16:22:09","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('893', '2023-01-28', '651', '103.172.55.55', '651', '2023-03-11 16:22:09')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('893', '3286', '651', '2023-03-11', '1', '103.172.55.55', '651', '2023-03-11 16:22:14', '', '')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2823', '0', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2823', '1', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2823', '2', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2823', '3', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2823', '4', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2823', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2823', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2823', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2823', '', '', 'Array', '', 'Array', '', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:22:14","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2823', '103.172.55.55', '651', '2023-03-11 16:22:14')"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE sitesupervision SET `siteid` = '893', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-11', `numofsamplecollected` = '360', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36', `locationtype` = '1', `establishmentyear` = '1998', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2823'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Pandian', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE onssid = '11620'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'John Peter', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE onssid = '11621'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'Vasudevan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE onssid = '11622'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE onssid = '11623'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267566 then '' when ansid=267567 then '' when ansid=267568 then '' when ansid=267569 then '' when ansid=267570 then '' when ansid=267571 then '' when ansid=267572 then '' when ansid=267672 then '' when ansid=267673 then '' when ansid=267615 then '' when ansid=267617 then '' when ansid=267619 then '' when ansid=267621 then '' when ansid=267623 then '' when ansid=267625 then '' when ansid=267626 then '' when ansid=267627 then '' when ansid=267628 then '' when ansid=267629 then '' when ansid=267630 then '' when ansid=267631 then '' when ansid=267632 then '' when ansid=267633 then '' when ansid=267634 then '' when ansid=267635 then '' when ansid=267636 then '' when ansid=267637 then '' when ansid=267638 then '' when ansid=267639 then '' when ansid=267640 then '' when ansid=267641 then '' when ansid=267642 then '' when ansid=267643 then '' when ansid=267644 then '' when ansid=267645 then '' when ansid=267646 then '' when ansid=267647 then '' when ansid=267648 then '' when ansid=267649 then '' when ansid=267650 then '' when ansid=267651 then '' when ansid=267652 then '' when ansid=267653 then '' when ansid=267654 then '' when ansid=267655 then '' when ansid=267656 then '' when ansid=267657 then '' when ansid=267658 then '' when ansid=267659 then '' when ansid=267660 then '' when ansid=267661 then '' when ansid=267662 then '' when ansid=267663 then '' when ansid=267664 then '' when ansid=267665 then '' when ansid=267666 then '' when ansid=267667 then '' when ansid=267668 then '' when ansid=267669 then '' when ansid=267670 then '' when ansid=267671 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:23:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267566','267567','267568','267569','267570','267571','267572','267672','267673','267615','267617','267619','267621','267623','267625','267626','267627','267628','267629','267630','267631','267632','267633','267634','267635','267636','267637','267638','267639','267640','267641','267642','267643','267644','267645','267646','267647','267648','267649','267650','267651','267652','267653','267654','267655','267656','267657','267658','267659','267660','267661','267662','267663','267664','267665','267666','267667','267668','267669','267670','267671')"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE supvisstepid = '13915'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE visitfeedbackid = '13891'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE visitfeedbackid = '13892'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE visitfeedbackid = '13893'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE visitfeedbackid = '13894'"} {"userId":"651","date":"2023-03-11 16:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:36' WHERE visitfeedbackid = '13895'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE sitesupervision SET `siteid` = '893', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-11', `numofsamplecollected` = '360', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48', `locationtype` = '1', `establishmentyear` = '1998', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2823'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Pandian', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE onssid = '11620'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE onsitestaffs SET `staffname` = 'John Peter', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE onssid = '11621'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE onsitestaffs SET `staffname` = 'Vasudevan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE onssid = '11622'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE onssid = '11623'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267566 then '1' when ansid=267567 then '1' when ansid=267568 then '1' when ansid=267569 then '' when ansid=267570 then '' when ansid=267571 then '' when ansid=267572 then '1' when ansid=267672 then '1' when ansid=267673 then '1' when ansid=267615 then '' when ansid=267617 then '' when ansid=267619 then '' when ansid=267621 then '' when ansid=267623 then '' when ansid=267625 then '' when ansid=267626 then '' when ansid=267627 then '' when ansid=267628 then '' when ansid=267629 then '' when ansid=267630 then '' when ansid=267631 then '' when ansid=267632 then '' when ansid=267633 then '' when ansid=267634 then '' when ansid=267635 then '' when ansid=267636 then '' when ansid=267637 then '' when ansid=267638 then '' when ansid=267639 then '' when ansid=267640 then '' when ansid=267641 then '' when ansid=267642 then '' when ansid=267643 then '' when ansid=267644 then '' when ansid=267645 then '' when ansid=267646 then '' when ansid=267647 then '' when ansid=267648 then '' when ansid=267649 then '' when ansid=267650 then '' when ansid=267651 then '' when ansid=267652 then '' when ansid=267653 then '' when ansid=267654 then '' when ansid=267655 then '' when ansid=267656 then '' when ansid=267657 then '' when ansid=267658 then '' when ansid=267659 then '' when ansid=267660 then '' when ansid=267661 then '' when ansid=267662 then '' when ansid=267663 then '' when ansid=267664 then '' when ansid=267665 then '' when ansid=267666 then '' when ansid=267667 then '' when ansid=267668 then '' when ansid=267669 then '' when ansid=267670 then '' when ansid=267671 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:23:48'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267566','267567','267568','267569','267570','267571','267572','267672','267673','267615','267617','267619','267621','267623','267625','267626','267627','267628','267629','267630','267631','267632','267633','267634','267635','267636','267637','267638','267639','267640','267641','267642','267643','267644','267645','267646','267647','267648','267649','267650','267651','267652','267653','267654','267655','267656','267657','267658','267659','267660','267661','267662','267663','267664','267665','267666','267667','267668','267669','267670','267671')"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE supvisstepid = '13916'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE visitfeedbackid = '13891'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE visitfeedbackid = '13892'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE visitfeedbackid = '13893'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE visitfeedbackid = '13894'"} {"userId":"651","date":"2023-03-11 16:23:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:23:48' WHERE visitfeedbackid = '13895'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE sitesupervision SET `siteid` = '893', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-11', `numofsamplecollected` = '360', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10', `locationtype` = '1', `establishmentyear` = '1998', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2823'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Pandian', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE onssid = '11620'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE onsitestaffs SET `staffname` = 'John Peter', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE onssid = '11621'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE onsitestaffs SET `staffname` = 'Vasudevan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE onssid = '11622'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE onssid = '11623'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267566 then '1' when ansid=267567 then '1' when ansid=267568 then '1' when ansid=267569 then '' when ansid=267570 then '' when ansid=267571 then '' when ansid=267572 then '1' when ansid=267672 then '1' when ansid=267673 then '1' when ansid=267615 then '1' when ansid=267617 then '1' when ansid=267619 then '1' when ansid=267621 then '100' when ansid=267623 then '5' when ansid=267625 then '' when ansid=267626 then '' when ansid=267627 then '' when ansid=267628 then '' when ansid=267629 then '' when ansid=267630 then '' when ansid=267631 then '' when ansid=267632 then '' when ansid=267633 then '' when ansid=267634 then '' when ansid=267635 then '' when ansid=267636 then '' when ansid=267637 then '' when ansid=267638 then '' when ansid=267639 then '' when ansid=267640 then '' when ansid=267641 then '' when ansid=267642 then '' when ansid=267643 then '' when ansid=267644 then '' when ansid=267645 then '' when ansid=267646 then '' when ansid=267647 then '' when ansid=267648 then '' when ansid=267649 then '' when ansid=267650 then '' when ansid=267651 then '' when ansid=267652 then '' when ansid=267653 then '' when ansid=267654 then '' when ansid=267655 then '' when ansid=267656 then '' when ansid=267657 then '' when ansid=267658 then '' when ansid=267659 then '' when ansid=267660 then '' when ansid=267661 then '' when ansid=267662 then '' when ansid=267663 then '' when ansid=267664 then '' when ansid=267665 then '' when ansid=267666 then '' when ansid=267667 then '' when ansid=267668 then '' when ansid=267669 then '' when ansid=267670 then '' when ansid=267671 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:24:10'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267566','267567','267568','267569','267570','267571','267572','267672','267673','267615','267617','267619','267621','267623','267625','267626','267627','267628','267629','267630','267631','267632','267633','267634','267635','267636','267637','267638','267639','267640','267641','267642','267643','267644','267645','267646','267647','267648','267649','267650','267651','267652','267653','267654','267655','267656','267657','267658','267659','267660','267661','267662','267663','267664','267665','267666','267667','267668','267669','267670','267671')"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE supvisstepid = '13917'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE visitfeedbackid = '13891'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE visitfeedbackid = '13892'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE visitfeedbackid = '13893'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE visitfeedbackid = '13894'"} {"userId":"651","date":"2023-03-11 16:24:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:24:10' WHERE visitfeedbackid = '13895'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE sitesupervision SET `siteid` = '893', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-11', `numofsamplecollected` = '360', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57', `locationtype` = '1', `establishmentyear` = '1998', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2823'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Pandian', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE onssid = '11620'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE onsitestaffs SET `staffname` = 'John Peter', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE onssid = '11621'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE onsitestaffs SET `staffname` = 'Vasudevan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE onssid = '11622'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE onssid = '11623'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267566 then '1' when ansid=267567 then '1' when ansid=267568 then '1' when ansid=267569 then '' when ansid=267570 then '' when ansid=267571 then '' when ansid=267572 then '1' when ansid=267672 then '1' when ansid=267673 then '1' when ansid=267615 then '1' when ansid=267617 then '1' when ansid=267619 then '1' when ansid=267621 then '100' when ansid=267623 then '5' when ansid=267625 then '1' when ansid=267626 then '1' when ansid=267627 then '1400' when ansid=267628 then '180' when ansid=267629 then '' when ansid=267630 then '1' when ansid=267631 then '1' when ansid=267632 then '' when ansid=267633 then '1' when ansid=267634 then '' when ansid=267635 then '1' when ansid=267636 then '20' when ansid=267637 then '1' when ansid=267638 then '1' when ansid=267639 then 'Counselor' when ansid=267640 then '1' when ansid=267641 then '' when ansid=267642 then '1' when ansid=267643 then '1' when ansid=267644 then '' when ansid=267645 then '1' when ansid=267646 then '1' when ansid=267647 then '1' when ansid=267648 then '1' when ansid=267649 then '1' when ansid=267650 then '1' when ansid=267651 then '2' when ansid=267652 then '1' when ansid=267653 then '1' when ansid=267654 then '1' when ansid=267655 then '' when ansid=267656 then '3' when ansid=267657 then '' when ansid=267658 then '1' when ansid=267659 then '1' when ansid=267660 then '1' when ansid=267661 then '' when ansid=267662 then '1' when ansid=267663 then '1' when ansid=267664 then '1' when ansid=267665 then '1' when ansid=267666 then '1' when ansid=267667 then '0' when ansid=267668 then 'None' when ansid=267669 then 'Yes, No specific comment' when ansid=267670 then 'None' when ansid=267671 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:25:57'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267566','267567','267568','267569','267570','267571','267572','267672','267673','267615','267617','267619','267621','267623','267625','267626','267627','267628','267629','267630','267631','267632','267633','267634','267635','267636','267637','267638','267639','267640','267641','267642','267643','267644','267645','267646','267647','267648','267649','267650','267651','267652','267653','267654','267655','267656','267657','267658','267659','267660','267661','267662','267663','267664','267665','267666','267667','267668','267669','267670','267671')"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE supvisstepid = '13918'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE visitfeedbackid = '13891'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE visitfeedbackid = '13892'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE visitfeedbackid = '13893'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE visitfeedbackid = '13894'"} {"userId":"651","date":"2023-03-11 16:25:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:25:57' WHERE visitfeedbackid = '13895'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE sitesupervision SET `siteid` = '893', `userid` = '651', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-11', `numofsamplecollected` = '360', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14', `locationtype` = '1', `establishmentyear` = '1998', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2823'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Pandian', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE onssid = '11620'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE onsitestaffs SET `staffname` = 'John Peter', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE onssid = '11621'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE onsitestaffs SET `staffname` = 'Vasudevan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE onssid = '11622'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE onssid = '11623'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=267566 then '1' when ansid=267567 then '1' when ansid=267568 then '1' when ansid=267569 then '' when ansid=267570 then '' when ansid=267571 then '' when ansid=267572 then '1' when ansid=267672 then '1' when ansid=267673 then '1' when ansid=267615 then '1' when ansid=267617 then '1' when ansid=267619 then '1' when ansid=267621 then '100' when ansid=267623 then '5' when ansid=267625 then '1' when ansid=267626 then '1' when ansid=267627 then '1400' when ansid=267628 then '180' when ansid=267629 then '' when ansid=267630 then '1' when ansid=267631 then '1' when ansid=267632 then '' when ansid=267633 then '1' when ansid=267634 then '' when ansid=267635 then '1' when ansid=267636 then '20' when ansid=267637 then '1' when ansid=267638 then '1' when ansid=267639 then 'Counselor' when ansid=267640 then '1' when ansid=267641 then '' when ansid=267642 then '1' when ansid=267643 then '1' when ansid=267644 then '' when ansid=267645 then '1' when ansid=267646 then '1' when ansid=267647 then '1' when ansid=267648 then '1' when ansid=267649 then '1' when ansid=267650 then '1' when ansid=267651 then '2' when ansid=267652 then '1' when ansid=267653 then '1' when ansid=267654 then '1' when ansid=267655 then '' when ansid=267656 then '3' when ansid=267657 then '' when ansid=267658 then '1' when ansid=267659 then '1' when ansid=267660 then '1' when ansid=267661 then '' when ansid=267662 then '1' when ansid=267663 then '1' when ansid=267664 then '1' when ansid=267665 then '1' when ansid=267666 then '1' when ansid=267667 then '0' when ansid=267668 then 'None' when ansid=267669 then 'Yes, No specific comment' when ansid=267670 then 'None' when ansid=267671 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.172.55.55',\r\n\t\t\t\t\t\t\t\tmodifiedby =651,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-11 16:26:14'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267566','267567','267568','267569','267570','267571','267572','267672','267673','267615','267617','267619','267621','267623','267625','267626','267627','267628','267629','267630','267631','267632','267633','267634','267635','267636','267637','267638','267639','267640','267641','267642','267643','267644','267645','267646','267647','267648','267649','267650','267651','267652','267653','267654','267655','267656','267657','267658','267659','267660','267661','267662','267663','267664','267665','267666','267667','267668','267669','267670','267671')"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE supvisstepid = '13919'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE visitfeedback SET `feedback` = 'No specific issue identified', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE visitfeedbackid = '13891'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE visitfeedbackid = '13892'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE visitfeedbackid = '13893'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE visitfeedbackid = '13894'"} {"userId":"651","date":"2023-03-11 16:26:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.172.55.55', `modifiedby` = '651', `modifieddate` = '2023-03-11 16:26:14' WHERE visitfeedbackid = '13895'"}