{"userId":"243","date":"2020-10-12 21:26:51","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '182.68.195.247', '2020-10-12 21:26:51')"} {"userId":"243","date":"2020-10-12 21:29:57","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('174', '2020-10-14', '243', '182.68.195.247', '243', '2020-10-12 21:29:57')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('174', '922', '243', '2020-10-12', '1', '182.68.195.247', '243', '2020-10-12 21:30:16', '', '')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '0', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '1', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '2', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '3', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '4', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '5', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('736', '6', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('736', '', '', 'Array', '', 'Array', '', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('736', '', '', 'Array', '', 'Array', '', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('736', '', '', 'Array', '', 'Array', '', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('736', '', '', 'Array', '', 'Array', '', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:30:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('736', '182.68.195.247', '243', '2020-10-12 21:30:16')"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '' when ansid=77071 then '' when ansid=77072 then '' when ansid=77073 then '' when ansid=77074 then '' when ansid=77075 then '' when ansid=77076 then '' when ansid=77077 then '' when ansid=77079 then '' when ansid=77081 then '' when ansid=77083 then '' when ansid=77085 then '' when ansid=77087 then '' when ansid=77089 then '' when ansid=77091 then '' when ansid=77093 then '' when ansid=77095 then '' when ansid=77097 then '' when ansid=77099 then '' when ansid=77101 then '' when ansid=77103 then '' when ansid=77105 then '' when ansid=77107 then '' when ansid=77109 then '' when ansid=77111 then '' when ansid=77113 then '' when ansid=77115 then '' when ansid=77117 then '' when ansid=77119 then '' when ansid=77121 then '' when ansid=77123 then '' when ansid=77125 then '' when ansid=77127 then '' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:31:50'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE supvisstepid = '4713'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:31:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:31:50' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '' when ansid=77079 then '' when ansid=77081 then '' when ansid=77083 then '' when ansid=77085 then '' when ansid=77087 then '' when ansid=77089 then '' when ansid=77091 then '' when ansid=77093 then '' when ansid=77095 then '' when ansid=77097 then '' when ansid=77099 then '' when ansid=77101 then '' when ansid=77103 then '' when ansid=77105 then '' when ansid=77107 then '' when ansid=77109 then '' when ansid=77111 then '' when ansid=77113 then '' when ansid=77115 then '' when ansid=77117 then '' when ansid=77119 then '' when ansid=77121 then '' when ansid=77123 then '' when ansid=77125 then '' when ansid=77127 then '' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:32:16'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE supvisstepid = '4714'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:32:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:16' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '' when ansid=77079 then '' when ansid=77081 then '' when ansid=77083 then '' when ansid=77085 then '' when ansid=77087 then '' when ansid=77089 then '' when ansid=77091 then '' when ansid=77093 then '' when ansid=77095 then '' when ansid=77097 then '' when ansid=77099 then '' when ansid=77101 then '' when ansid=77103 then '' when ansid=77105 then '' when ansid=77107 then '' when ansid=77109 then '' when ansid=77111 then '' when ansid=77113 then '' when ansid=77115 then '' when ansid=77117 then '' when ansid=77119 then '' when ansid=77121 then '' when ansid=77123 then '' when ansid=77125 then '' when ansid=77127 then '' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:32:33'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE supvisstepid = '4714'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:32:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:32:33' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '' when ansid=77095 then '' when ansid=77097 then '' when ansid=77099 then '' when ansid=77101 then '' when ansid=77103 then '' when ansid=77105 then '' when ansid=77107 then '' when ansid=77109 then '' when ansid=77111 then '' when ansid=77113 then '' when ansid=77115 then '' when ansid=77117 then '' when ansid=77119 then '' when ansid=77121 then '' when ansid=77123 then '' when ansid=77125 then '' when ansid=77127 then '' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:33:07'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE supvisstepid = '4715'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:33:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:07' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '' when ansid=77121 then '' when ansid=77123 then '' when ansid=77125 then '' when ansid=77127 then '' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:33:59'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE supvisstepid = '4716'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:33:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:33:59' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '' when ansid=77130 then '' when ansid=77131 then '' when ansid=77132 then '' when ansid=77133 then '' when ansid=77134 then '' when ansid=77135 then '' when ansid=77136 then '' when ansid=77137 then '' when ansid=77138 then '' when ansid=77139 then '' when ansid=77140 then '' when ansid=77141 then '' when ansid=77142 then '' when ansid=77143 then '' when ansid=77144 then '' when ansid=77145 then '' when ansid=77146 then '' when ansid=77147 then '' when ansid=77148 then '' when ansid=77149 then '' when ansid=77150 then '' when ansid=77151 then '' when ansid=77152 then '' when ansid=77153 then '' when ansid=77154 then '' when ansid=77155 then '' when ansid=77156 then '' when ansid=77157 then '' when ansid=77158 then '' when ansid=77159 then '' when ansid=77160 then '' when ansid=77161 then '' when ansid=77162 then '' when ansid=77163 then '' when ansid=77164 then '' when ansid=77165 then '' when ansid=77166 then '' when ansid=77167 then '' when ansid=77168 then '' when ansid=77169 then '' when ansid=77170 then '' when ansid=77171 then '' when ansid=77172 then '' when ansid=77173 then '' when ansid=77174 then '' when ansid=77175 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:34:25'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE supvisstepid = '4717'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:34:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:34:25' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:36:58'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE supvisstepid = '4718'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:36:58' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:43:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '182.68.195.247', '2020-10-12 21:43:47')"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:47:14'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE supvisstepid = '4718'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:47:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:14' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:47:15'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE supvisstepid = '4714'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:47:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:15' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE onssid = '3272'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE onssid = '3273'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE onssid = '3274'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE onssid = '3275'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 21:47:16'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE supvisstepid = '4716'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE visitfeedbackid = '3456'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE visitfeedbackid = '3457'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE visitfeedbackid = '3458'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE visitfeedbackid = '3459'"} {"userId":"243","date":"2020-10-12 21:47:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '243', `modifieddate` = '2020-10-12 21:47:16' WHERE visitfeedbackid = '3460'"} {"userId":"243","date":"2020-10-12 21:59:59","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('ni aiims', 'aiims', 'niaiims.hss@gmail.com', '9999999999', 'abcd', '', '25d55ad283aa400af464c76d713c07ad', '5', '182.68.195.247', '243', '2020-10-12 21:59:59')"} {"userId":"243","date":"2020-10-12 21:59:59","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('244', '101', '3', '17', '2', '299', '182.68.195.247', '243', '2020-10-12 21:59:59')"} {"userId":"244","date":"2020-10-12 22:01:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('244', '182.68.195.247', '2020-10-12 22:01:28')"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '244', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE onssid = '3272'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE onssid = '3273'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE onssid = '3274'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE onssid = '3275'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =244,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 22:03:02'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE supvisstepid = '4718'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE visitfeedbackid = '3456'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE visitfeedbackid = '3457'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE visitfeedbackid = '3458'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE visitfeedbackid = '3459'"} {"userId":"244","date":"2020-10-12 22:03:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:02' WHERE visitfeedbackid = '3460'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '244', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3272'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3273'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3274'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3275'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =244,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 22:03:03'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE supvisstepid = '4714'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3456'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3457'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3458'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3459'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3460'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '244', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '736'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3272'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3273'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3274'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE onssid = '3275'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =244,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 22:03:03'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE supvisstepid = '4716'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3456'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3457'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3458'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3459'"} {"userId":"244","date":"2020-10-12 22:03:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:03:03' WHERE visitfeedbackid = '3460'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE sitesupervision SET `siteid` = '174', `userid` = '244', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-10-12', `numofsamplecollected` = '100', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '736'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE onssid = '3272'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE onssid = '3273'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE onssid = '3274'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE onssid = '3275'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=77070 then '1' when ansid=77071 then '1' when ansid=77072 then '2' when ansid=77073 then '2' when ansid=77074 then '1' when ansid=77075 then '' when ansid=77076 then '1' when ansid=77077 then '3' when ansid=77079 then '1' when ansid=77081 then '450' when ansid=77083 then '20' when ansid=77085 then '20' when ansid=77087 then '50' when ansid=77089 then '1' when ansid=77091 then '1' when ansid=77093 then '2' when ansid=77095 then '450' when ansid=77097 then '50' when ansid=77099 then '50' when ansid=77101 then '30' when ansid=77103 then '1' when ansid=77105 then '450' when ansid=77107 then '450' when ansid=77109 then '500' when ansid=77111 then '2' when ansid=77113 then '5' when ansid=77115 then '1' when ansid=77117 then '5' when ansid=77119 then '1' when ansid=77121 then '1' when ansid=77123 then '1' when ansid=77125 then '3' when ansid=77127 then '5' when ansid=77129 then '2' when ansid=77130 then '2' when ansid=77131 then '100' when ansid=77132 then '4' when ansid=77133 then '' when ansid=77134 then '1' when ansid=77135 then '1' when ansid=77136 then '' when ansid=77137 then '1' when ansid=77138 then '' when ansid=77139 then '1' when ansid=77140 then '10' when ansid=77141 then '1' when ansid=77142 then '1' when ansid=77143 then '1' when ansid=77144 then '1' when ansid=77145 then '' when ansid=77146 then '1' when ansid=77147 then '1' when ansid=77148 then '' when ansid=77149 then '1' when ansid=77150 then '1' when ansid=77151 then '1' when ansid=77152 then '1' when ansid=77153 then '1' when ansid=77154 then '1' when ansid=77155 then '1' when ansid=77156 then '1' when ansid=77157 then '1' when ansid=77158 then '1' when ansid=77159 then '' when ansid=77160 then '1' when ansid=77161 then '' when ansid=77162 then '1' when ansid=77163 then '1' when ansid=77164 then '1' when ansid=77165 then '' when ansid=77166 then '1' when ansid=77167 then '1' when ansid=77168 then '1' when ansid=77169 then '1' when ansid=77170 then '1' when ansid=77171 then '10' when ansid=77172 then '1234' when ansid=77173 then '1234' when ansid=77174 then '1234' when ansid=77175 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '182.68.195.247',\n\t\t\t\t\t\t\t\tmodifiedby =244,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-10-12 22:04:02'\n\t\t\t\t\t\t\tWHERE ansid in ('77070','77071','77072','77073','77074','77075','77076','77077','77079','77081','77083','77085','77087','77089','77091','77093','77095','77097','77099','77101','77103','77105','77107','77109','77111','77113','77115','77117','77119','77121','77123','77125','77127','77129','77130','77131','77132','77133','77134','77135','77136','77137','77138','77139','77140','77141','77142','77143','77144','77145','77146','77147','77148','77149','77150','77151','77152','77153','77154','77155','77156','77157','77158','77159','77160','77161','77162','77163','77164','77165','77166','77167','77168','77169','77170','77171','77172','77173','77174','77175')"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE supvisstepid = '4719'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE visitfeedbackid = '3456'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE visitfeedbackid = '3457'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE visitfeedbackid = '3458'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE visitfeedbackid = '3459'"} {"userId":"244","date":"2020-10-12 22:04:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '182.68.195.247', `modifiedby` = '244', `modifieddate` = '2020-10-12 22:04:02' WHERE visitfeedbackid = '3460'"}