{"userId":"5","date":"2020-12-16 11:21:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.220.169', '2020-12-16 11:21:21')"} {"userId":"5","date":"2020-12-16 11:21:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1062', '2020-12-16', '5', '117.205.220.169', '5', '2020-12-16 11:21:51')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1062', '939', '5', '2020-12-16', '1', '117.205.220.169', '5', '2020-12-16 11:21:55', '', '')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '0', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '1', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '2', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '3', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '4', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('751', '5', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('751', '', '', 'Array', '', 'Array', '', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('751', '', '', 'Array', '', 'Array', '', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('751', '', '', 'Array', '', 'Array', '', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('751', '', '', 'Array', '', 'Array', '', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:21:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('751', '117.205.220.169', '5', '2020-12-16 11:21:55')"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2020-12-16', `numofsamplecollected` = '50', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '450', `undertrialprisoners` = '400' WHERE ssid = '751'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE onsitestaffs SET `staffname` = 'hjjkk', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE onssid = '3332'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE onsitestaffs SET `staffname` = 'bjkbk.m', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE onssid = '3333'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE onsitestaffs SET `staffname` = 'bvjlmn;l', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE onssid = '3334'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE onsitestaffs SET `staffname` = 'nbk.l', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE onssid = '3335'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78648 then '' when ansid=78650 then '' when ansid=78652 then '' when ansid=78654 then '' when ansid=78656 then '' when ansid=78658 then '' when ansid=78660 then '' when ansid=78662 then '' when ansid=78664 then '' when ansid=78666 then '' when ansid=78668 then '' when ansid=78670 then '' when ansid=78672 then '' when ansid=78674 then '' when ansid=78676 then '' when ansid=78678 then '' when ansid=78680 then '' when ansid=78682 then '' when ansid=78684 then '' when ansid=78686 then '' when ansid=78688 then '' when ansid=78690 then '' when ansid=78692 then '' when ansid=78694 then '' when ansid=78696 then '' when ansid=78698 then '' when ansid=78700 then '' when ansid=78702 then '' when ansid=78704 then '' when ansid=78705 then '' when ansid=78706 then '' when ansid=78707 then '' when ansid=78708 then '' when ansid=78709 then '' when ansid=78710 then '' when ansid=78711 then '' when ansid=78712 then '' when ansid=78713 then '' when ansid=78714 then '' when ansid=78715 then '' when ansid=78716 then '' when ansid=78717 then '' when ansid=78718 then '' when ansid=78719 then '' when ansid=78720 then '' when ansid=78721 then '' when ansid=78722 then '' when ansid=78723 then '' when ansid=78724 then '' when ansid=78725 then '' when ansid=78726 then '' when ansid=78727 then '' when ansid=78728 then '' when ansid=78729 then '' when ansid=78730 then '' when ansid=78731 then '' when ansid=78732 then '' when ansid=78733 then '' when ansid=78734 then '' when ansid=78735 then '' when ansid=78736 then '' when ansid=78737 then '' when ansid=78738 then '' when ansid=78739 then '' when ansid=78740 then '' when ansid=78741 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 11:32:21'\n\t\t\t\t\t\t\tWHERE ansid in ('78648','78650','78652','78654','78656','78658','78660','78662','78664','78666','78668','78670','78672','78674','78676','78678','78680','78682','78684','78686','78688','78690','78692','78694','78696','78698','78700','78702','78704','78705','78706','78707','78708','78709','78710','78711','78712','78713','78714','78715','78716','78717','78718','78719','78720','78721','78722','78723','78724','78725','78726','78727','78728','78729','78730','78731','78732','78733','78734','78735','78736','78737','78738','78739','78740','78741')"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE supvisstepid = '4805'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE visitfeedbackid = '3531'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE visitfeedbackid = '3532'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE visitfeedbackid = '3533'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE visitfeedbackid = '3534'"} {"userId":"5","date":"2020-12-16 11:32:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:32:21' WHERE visitfeedbackid = '3535'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2020-12-16', `numofsamplecollected` = '50', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '450', `undertrialprisoners` = '400' WHERE ssid = '751'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE onsitestaffs SET `staffname` = 'hjjkk', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE onssid = '3332'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE onsitestaffs SET `staffname` = 'bjkbk.m', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE onssid = '3333'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE onsitestaffs SET `staffname` = 'bvjlmn;l', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE onssid = '3334'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE onsitestaffs SET `staffname` = 'nbk.l', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE onssid = '3335'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78648 then '3' when ansid=78650 then '1' when ansid=78652 then '450' when ansid=78654 then '20' when ansid=78656 then '20' when ansid=78658 then '2' when ansid=78660 then '450' when ansid=78662 then '1' when ansid=78664 then '1' when ansid=78666 then '1' when ansid=78668 then '' when ansid=78670 then '' when ansid=78672 then '' when ansid=78674 then '' when ansid=78676 then '' when ansid=78678 then '' when ansid=78680 then '' when ansid=78682 then '' when ansid=78684 then '' when ansid=78686 then '' when ansid=78688 then '' when ansid=78690 then '' when ansid=78692 then '' when ansid=78694 then '' when ansid=78696 then '' when ansid=78698 then '' when ansid=78700 then '' when ansid=78702 then '' when ansid=78704 then '' when ansid=78705 then '' when ansid=78706 then '' when ansid=78707 then '' when ansid=78708 then '' when ansid=78709 then '' when ansid=78710 then '' when ansid=78711 then '' when ansid=78712 then '' when ansid=78713 then '' when ansid=78714 then '' when ansid=78715 then '' when ansid=78716 then '' when ansid=78717 then '' when ansid=78718 then '' when ansid=78719 then '' when ansid=78720 then '' when ansid=78721 then '' when ansid=78722 then '' when ansid=78723 then '' when ansid=78724 then '' when ansid=78725 then '' when ansid=78726 then '' when ansid=78727 then '' when ansid=78728 then '' when ansid=78729 then '' when ansid=78730 then '' when ansid=78731 then '' when ansid=78732 then '' when ansid=78733 then '' when ansid=78734 then '' when ansid=78735 then '' when ansid=78736 then '' when ansid=78737 then '' when ansid=78738 then '' when ansid=78739 then '' when ansid=78740 then '' when ansid=78741 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 11:49:00'\n\t\t\t\t\t\t\tWHERE ansid in ('78648','78650','78652','78654','78656','78658','78660','78662','78664','78666','78668','78670','78672','78674','78676','78678','78680','78682','78684','78686','78688','78690','78692','78694','78696','78698','78700','78702','78704','78705','78706','78707','78708','78709','78710','78711','78712','78713','78714','78715','78716','78717','78718','78719','78720','78721','78722','78723','78724','78725','78726','78727','78728','78729','78730','78731','78732','78733','78734','78735','78736','78737','78738','78739','78740','78741')"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE supvisstepid = '4806'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE visitfeedbackid = '3531'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE visitfeedbackid = '3532'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE visitfeedbackid = '3533'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE visitfeedbackid = '3534'"} {"userId":"5","date":"2020-12-16 11:49:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:49:00' WHERE visitfeedbackid = '3535'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2020-12-16', `numofsamplecollected` = '50', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '450', `undertrialprisoners` = '400' WHERE ssid = '751'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE onsitestaffs SET `staffname` = 'hjjkk', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE onssid = '3332'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE onsitestaffs SET `staffname` = 'bjkbk.m', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE onssid = '3333'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE onsitestaffs SET `staffname` = 'bvjlmn;l', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE onssid = '3334'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE onsitestaffs SET `staffname` = 'nbk.l', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE onssid = '3335'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78648 then '3' when ansid=78650 then '1' when ansid=78652 then '450' when ansid=78654 then '20' when ansid=78656 then '20' when ansid=78658 then '2' when ansid=78660 then '450' when ansid=78662 then '1' when ansid=78664 then '1' when ansid=78666 then '1' when ansid=78668 then '4' when ansid=78670 then '450' when ansid=78672 then '450' when ansid=78674 then '450' when ansid=78676 then '20' when ansid=78678 then '1' when ansid=78680 then '450' when ansid=78682 then '450' when ansid=78684 then '500' when ansid=78686 then '2' when ansid=78688 then '5' when ansid=78690 then '1' when ansid=78692 then '5' when ansid=78694 then '' when ansid=78696 then '' when ansid=78698 then '' when ansid=78700 then '' when ansid=78702 then '' when ansid=78704 then '' when ansid=78705 then '' when ansid=78706 then '' when ansid=78707 then '' when ansid=78708 then '' when ansid=78709 then '' when ansid=78710 then '' when ansid=78711 then '' when ansid=78712 then '' when ansid=78713 then '' when ansid=78714 then '' when ansid=78715 then '' when ansid=78716 then '' when ansid=78717 then '' when ansid=78718 then '' when ansid=78719 then '' when ansid=78720 then '' when ansid=78721 then '' when ansid=78722 then '' when ansid=78723 then '' when ansid=78724 then '' when ansid=78725 then '' when ansid=78726 then '' when ansid=78727 then '' when ansid=78728 then '' when ansid=78729 then '' when ansid=78730 then '' when ansid=78731 then '' when ansid=78732 then '' when ansid=78733 then '' when ansid=78734 then '' when ansid=78735 then '' when ansid=78736 then '' when ansid=78737 then '' when ansid=78738 then '' when ansid=78739 then '' when ansid=78740 then '' when ansid=78741 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 11:51:36'\n\t\t\t\t\t\t\tWHERE ansid in ('78648','78650','78652','78654','78656','78658','78660','78662','78664','78666','78668','78670','78672','78674','78676','78678','78680','78682','78684','78686','78688','78690','78692','78694','78696','78698','78700','78702','78704','78705','78706','78707','78708','78709','78710','78711','78712','78713','78714','78715','78716','78717','78718','78719','78720','78721','78722','78723','78724','78725','78726','78727','78728','78729','78730','78731','78732','78733','78734','78735','78736','78737','78738','78739','78740','78741')"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE supvisstepid = '4807'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE visitfeedbackid = '3531'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE visitfeedbackid = '3532'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE visitfeedbackid = '3533'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE visitfeedbackid = '3534'"} {"userId":"5","date":"2020-12-16 11:51:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:51:36' WHERE visitfeedbackid = '3535'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2020-12-16', `numofsamplecollected` = '50', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '450', `undertrialprisoners` = '400' WHERE ssid = '751'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE onsitestaffs SET `staffname` = 'hjjkk', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE onssid = '3332'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE onsitestaffs SET `staffname` = 'bjkbk.m', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE onssid = '3333'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE onsitestaffs SET `staffname` = 'bvjlmn;l', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE onssid = '3334'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE onsitestaffs SET `staffname` = 'nbk.l', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE onssid = '3335'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78648 then '3' when ansid=78650 then '1' when ansid=78652 then '450' when ansid=78654 then '20' when ansid=78656 then '20' when ansid=78658 then '2' when ansid=78660 then '450' when ansid=78662 then '1' when ansid=78664 then '1' when ansid=78666 then '1' when ansid=78668 then '4' when ansid=78670 then '450' when ansid=78672 then '450' when ansid=78674 then '450' when ansid=78676 then '20' when ansid=78678 then '1' when ansid=78680 then '450' when ansid=78682 then '450' when ansid=78684 then '500' when ansid=78686 then '2' when ansid=78688 then '5' when ansid=78690 then '1' when ansid=78692 then '5' when ansid=78694 then '1' when ansid=78696 then '1' when ansid=78698 then '1' when ansid=78700 then '3' when ansid=78702 then '1' when ansid=78704 then '' when ansid=78705 then '' when ansid=78706 then '' when ansid=78707 then '' when ansid=78708 then '' when ansid=78709 then '' when ansid=78710 then '' when ansid=78711 then '' when ansid=78712 then '' when ansid=78713 then '' when ansid=78714 then '' when ansid=78715 then '' when ansid=78716 then '' when ansid=78717 then '' when ansid=78718 then '' when ansid=78719 then '' when ansid=78720 then '' when ansid=78721 then '' when ansid=78722 then '' when ansid=78723 then '' when ansid=78724 then '' when ansid=78725 then '' when ansid=78726 then '' when ansid=78727 then '' when ansid=78728 then '' when ansid=78729 then '' when ansid=78730 then '' when ansid=78731 then '' when ansid=78732 then '' when ansid=78733 then '' when ansid=78734 then '' when ansid=78735 then '' when ansid=78736 then '' when ansid=78737 then '' when ansid=78738 then '' when ansid=78739 then '' when ansid=78740 then '' when ansid=78741 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 11:53:02'\n\t\t\t\t\t\t\tWHERE ansid in ('78648','78650','78652','78654','78656','78658','78660','78662','78664','78666','78668','78670','78672','78674','78676','78678','78680','78682','78684','78686','78688','78690','78692','78694','78696','78698','78700','78702','78704','78705','78706','78707','78708','78709','78710','78711','78712','78713','78714','78715','78716','78717','78718','78719','78720','78721','78722','78723','78724','78725','78726','78727','78728','78729','78730','78731','78732','78733','78734','78735','78736','78737','78738','78739','78740','78741')"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE supvisstepid = '4808'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE visitfeedbackid = '3531'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE visitfeedbackid = '3532'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE visitfeedbackid = '3533'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE visitfeedbackid = '3534'"} {"userId":"5","date":"2020-12-16 11:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 11:53:02' WHERE visitfeedbackid = '3535'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2020-12-16', `numofsamplecollected` = '50', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '0', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '450', `undertrialprisoners` = '400' WHERE ssid = '751'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE onsitestaffs SET `staffname` = 'hjjkk', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE onssid = '3332'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE onsitestaffs SET `staffname` = 'bjkbk.m', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE onssid = '3333'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE onsitestaffs SET `staffname` = 'bvjlmn;l', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE onssid = '3334'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE onsitestaffs SET `staffname` = 'nbk.l', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE onssid = '3335'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78648 then '3' when ansid=78650 then '1' when ansid=78652 then '450' when ansid=78654 then '20' when ansid=78656 then '20' when ansid=78658 then '2' when ansid=78660 then '450' when ansid=78662 then '1' when ansid=78664 then '1' when ansid=78666 then '1' when ansid=78668 then '4' when ansid=78670 then '450' when ansid=78672 then '450' when ansid=78674 then '450' when ansid=78676 then '20' when ansid=78678 then '1' when ansid=78680 then '450' when ansid=78682 then '450' when ansid=78684 then '500' when ansid=78686 then '2' when ansid=78688 then '5' when ansid=78690 then '1' when ansid=78692 then '5' when ansid=78694 then '1' when ansid=78696 then '1' when ansid=78698 then '1' when ansid=78700 then '3' when ansid=78702 then '1' when ansid=78704 then '30' when ansid=78705 then '30' when ansid=78706 then '' when ansid=78707 then '1' when ansid=78708 then '' when ansid=78709 then '1' when ansid=78710 then '' when ansid=78711 then '1' when ansid=78712 then '6' when ansid=78713 then '1' when ansid=78714 then '' when ansid=78715 then '1' when ansid=78716 then '' when ansid=78717 then '1' when ansid=78718 then '1' when ansid=78719 then '1' when ansid=78720 then '3' when ansid=78721 then '1' when ansid=78722 then '1' when ansid=78723 then '1' when ansid=78724 then '1' when ansid=78725 then '1' when ansid=78726 then '1' when ansid=78727 then '1' when ansid=78728 then '1' when ansid=78729 then '1' when ansid=78730 then '1' when ansid=78731 then '1' when ansid=78732 then '' when ansid=78733 then '1' when ansid=78734 then '2' when ansid=78735 then '1' when ansid=78736 then '1' when ansid=78737 then '1' when ansid=78738 then '0' when ansid=78739 then 'fdgh' when ansid=78740 then 'dvdfh' when ansid=78741 then 'fdgdfhgf' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 12:23:54'\n\t\t\t\t\t\t\tWHERE ansid in ('78648','78650','78652','78654','78656','78658','78660','78662','78664','78666','78668','78670','78672','78674','78676','78678','78680','78682','78684','78686','78688','78690','78692','78694','78696','78698','78700','78702','78704','78705','78706','78707','78708','78709','78710','78711','78712','78713','78714','78715','78716','78717','78718','78719','78720','78721','78722','78723','78724','78725','78726','78727','78728','78729','78730','78731','78732','78733','78734','78735','78736','78737','78738','78739','78740','78741')"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE supvisstepid = '4809'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE visitfeedbackid = '3531'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE visitfeedbackid = '3532'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE visitfeedbackid = '3533'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE visitfeedbackid = '3534'"} {"userId":"5","date":"2020-12-16 12:23:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 12:23:54' WHERE visitfeedbackid = '3535'"} {"userId":"5","date":"2020-12-16 13:04:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.220.169', '2020-12-16 13:04:26')"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-15', `numofsamplecollected` = '20', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '749'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE onsitestaffs SET `staffname` = 'sdadsad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE onssid = '3324'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE onsitestaffs SET `staffname` = 'sadasdasd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE onssid = '3325'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE onsitestaffs SET `staffname` = 'asdsad', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE onssid = '3326'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE onssid = '3327'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78448 then '' when ansid=78449 then '' when ansid=78450 then '' when ansid=78451 then '' when ansid=78452 then '' when ansid=78453 then '' when ansid=78454 then '' when ansid=78455 then '' when ansid=78457 then '' when ansid=78459 then '' when ansid=78461 then '' when ansid=78463 then '' when ansid=78465 then '' when ansid=78467 then '' when ansid=78469 then '' when ansid=78471 then '' when ansid=78473 then '' when ansid=78475 then '' when ansid=78477 then '' when ansid=78479 then '' when ansid=78481 then '' when ansid=78483 then '' when ansid=78485 then '' when ansid=78487 then '' when ansid=78489 then '' when ansid=78491 then '' when ansid=78493 then '' when ansid=78495 then '' when ansid=78497 then '' when ansid=78499 then '' when ansid=78501 then '' when ansid=78503 then '' when ansid=78505 then '' when ansid=78507 then '' when ansid=78508 then '' when ansid=78509 then '' when ansid=78510 then '' when ansid=78511 then '' when ansid=78512 then '' when ansid=78513 then '' when ansid=78514 then '' when ansid=78515 then '' when ansid=78516 then '' when ansid=78517 then '' when ansid=78518 then '' when ansid=78519 then '' when ansid=78520 then '' when ansid=78521 then '' when ansid=78522 then '' when ansid=78523 then '' when ansid=78524 then '' when ansid=78525 then '' when ansid=78526 then '' when ansid=78527 then '' when ansid=78528 then '' when ansid=78529 then '' when ansid=78530 then '' when ansid=78531 then '' when ansid=78532 then '' when ansid=78533 then '' when ansid=78534 then '' when ansid=78535 then '' when ansid=78536 then '' when ansid=78537 then '' when ansid=78538 then '' when ansid=78539 then '' when ansid=78540 then '' when ansid=78541 then '' when ansid=78542 then '' when ansid=78543 then '' when ansid=78544 then '' when ansid=78545 then '' when ansid=78546 then '' when ansid=78547 then '' when ansid=78548 then '' when ansid=78549 then '' when ansid=78550 then '' when ansid=78551 then '' when ansid=78552 then '' when ansid=78553 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 13:07:19'\n\t\t\t\t\t\t\tWHERE ansid in ('78448','78449','78450','78451','78452','78453','78454','78455','78457','78459','78461','78463','78465','78467','78469','78471','78473','78475','78477','78479','78481','78483','78485','78487','78489','78491','78493','78495','78497','78499','78501','78503','78505','78507','78508','78509','78510','78511','78512','78513','78514','78515','78516','78517','78518','78519','78520','78521','78522','78523','78524','78525','78526','78527','78528','78529','78530','78531','78532','78533','78534','78535','78536','78537','78538','78539','78540','78541','78542','78543','78544','78545','78546','78547','78548','78549','78550','78551','78552','78553')"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE supvisstepid = '4792'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE visitfeedbackid = '3521'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE visitfeedbackid = '3522'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE visitfeedbackid = '3523'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE visitfeedbackid = '3524'"} {"userId":"5","date":"2020-12-16 13:07:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:07:19' WHERE visitfeedbackid = '3525'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE sitesupervision SET `siteid` = '173', `userid` = '5', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-12-15', `numofsamplecollected` = '20', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '749'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE onsitestaffs SET `staffname` = 'sdadsad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE onssid = '3324'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE onsitestaffs SET `staffname` = 'sadasdasd', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE onssid = '3325'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE onsitestaffs SET `staffname` = 'asdsad', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE onssid = '3326'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE onssid = '3327'"} {"userId":"5","date":"2020-12-16 13:29:52","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=78448 then '1' when ansid=78449 then '1' when ansid=78450 then '2' when ansid=78451 then '' when ansid=78452 then '' when ansid=78453 then '' when ansid=78454 then '' when ansid=78455 then '' when ansid=78457 then '' when ansid=78459 then '' when ansid=78461 then '' when ansid=78463 then '' when ansid=78465 then '' when ansid=78467 then '' when ansid=78469 then '' when ansid=78471 then '' when ansid=78473 then '' when ansid=78475 then '' when ansid=78477 then '' when ansid=78479 then '' when ansid=78481 then '' when ansid=78483 then '' when ansid=78485 then '' when ansid=78487 then '' when ansid=78489 then '' when ansid=78491 then '' when ansid=78493 then '' when ansid=78495 then '' when ansid=78497 then '' when ansid=78499 then '' when ansid=78501 then '' when ansid=78503 then '' when ansid=78505 then '' when ansid=78507 then '' when ansid=78508 then '' when ansid=78509 then '' when ansid=78510 then '' when ansid=78511 then '' when ansid=78512 then '' when ansid=78513 then '' when ansid=78514 then '' when ansid=78515 then '' when ansid=78516 then '' when ansid=78517 then '' when ansid=78518 then '' when ansid=78519 then '' when ansid=78520 then '' when ansid=78521 then '' when ansid=78522 then '' when ansid=78523 then '' when ansid=78524 then '' when ansid=78525 then '' when ansid=78526 then '' when ansid=78527 then '' when ansid=78528 then '' when ansid=78529 then '' when ansid=78530 then '' when ansid=78531 then '' when ansid=78532 then '' when ansid=78533 then '' when ansid=78534 then '' when ansid=78535 then '' when ansid=78536 then '' when ansid=78537 then '' when ansid=78538 then '' when ansid=78539 then '' when ansid=78540 then '' when ansid=78541 then '' when ansid=78542 then '' when ansid=78543 then '' when ansid=78544 then '' when ansid=78545 then '' when ansid=78546 then '' when ansid=78547 then '' when ansid=78548 then '' when ansid=78549 then '' when ansid=78550 then '' when ansid=78551 then '' when ansid=78552 then '' when ansid=78553 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.220.169',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-16 13:29:52'\n\t\t\t\t\t\t\tWHERE ansid in ('78448','78449','78450','78451','78452','78453','78454','78455','78457','78459','78461','78463','78465','78467','78469','78471','78473','78475','78477','78479','78481','78483','78485','78487','78489','78491','78493','78495','78497','78499','78501','78503','78505','78507','78508','78509','78510','78511','78512','78513','78514','78515','78516','78517','78518','78519','78520','78521','78522','78523','78524','78525','78526','78527','78528','78529','78530','78531','78532','78533','78534','78535','78536','78537','78538','78539','78540','78541','78542','78543','78544','78545','78546','78547','78548','78549','78550','78551','78552','78553')"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE supvisstepid = '4792'"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE visitfeedbackid = '3521'"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE visitfeedbackid = '3522'"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE visitfeedbackid = '3523'"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE visitfeedbackid = '3524'"} {"userId":"5","date":"2020-12-16 13:29:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.220.169', `modifiedby` = '5', `modifieddate` = '2020-12-16 13:29:52' WHERE visitfeedbackid = '3525'"} {"userId":"5","date":"2020-12-16 14:10:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '117.205.220.169', '2020-12-16 14:10:56')"} {"userId":"7","date":"2020-12-16 16:14:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2020-12-16 16:14:48')"} {"userId":"7","date":"2020-12-16 16:17:01","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Chakresh', 'Jain', 'drchakreshjain81@gmail.com', '9425330088', 'Asstt. Professor, PSM Department, Medical College, Rewa', 'MP SACS', 'fb51bc16cdbb1206b1d7223993474285', '4', '14.139.125.18', '7', '2020-12-16 16:17:01')"} {"userId":"7","date":"2020-12-16 16:17:01","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('301', '101', '21', '340', '5', '0', '14.139.125.18', '7', '2020-12-16 16:17:01')"} {"userId":"7","date":"2020-12-16 16:17:49","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Dhruvendra', 'Pandey', 'pandit.dhruv06@gmail.com', '8269075295', 'Associate Professor, Community Medicine Department, Medical College, Ratlam', 'MP SACS', '98b0e5d930f0c928b3e92e0a1133a888', '4', '14.139.125.18', '7', '2020-12-16 16:17:49')"} {"userId":"7","date":"2020-12-16 16:17:49","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('302', '101', '21', '339', '5', '0', '14.139.125.18', '7', '2020-12-16 16:17:49')"} {"userId":"7","date":"2020-12-16 16:18:43","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Neelam', 'Toppo', 'neelam.philips2011@gmail.com', '9981598198', 'Professor, Community Medicine, N.S.C.B. Medical College, Jabalpur', 'MP SACS', 'cccbbc3d685f56d0306afdd765ae68e0', '4', '14.139.125.18', '7', '2020-12-16 16:18:43')"} {"userId":"7","date":"2020-12-16 16:18:43","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('303', '101', '21', '327', '5', '0', '14.139.125.18', '7', '2020-12-16 16:18:43')"} {"userId":"7","date":"2020-12-16 16:20:05","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Aditya', 'Thakur', 'adityathakur701@gmail.com', '9926822544', 'Associate Professor, Community Medicine', 'MP SACS', '41ece6bda302f35ba65ec342f2b6168a', '4', '14.139.125.18', '7', '2020-12-16 16:20:05')"} {"userId":"7","date":"2020-12-16 16:20:05","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('304', '101', '21', '327', '5', '0', '14.139.125.18', '7', '2020-12-16 16:20:05')"} {"userId":"7","date":"2020-12-16 16:21:01","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr K P', 'Ranjan', 'drkpranjan@gmail.com', '9009021907', 'Asscociate Professor, Microbiology, G.R. Medical College, Gwalior', 'MP SACS', 'adf360073d48513409635291ba94f9a2', '4', '14.139.125.18', '7', '2020-12-16 16:21:01')"} {"userId":"7","date":"2020-12-16 16:21:01","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('305', '101', '21', '323', '5', '0', '14.139.125.18', '7', '2020-12-16 16:21:01')"} {"userId":"7","date":"2020-12-16 16:23:02","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr Harshad', 'Kale', 'mumbaimacs@gmail.com', '24100246', 'Project Director', 'Mumbai DACS', '68b510a3dd783733e01632b171964b95', '5', '14.139.125.18', '7', '2020-12-16 16:23:02')"} {"userId":"7","date":"2020-12-16 16:23:02","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('306', '101', '22', '371', '5', '0', '14.139.125.18', '7', '2020-12-16 16:23:02')"} {"userId":"7","date":"2020-12-16 16:24:02","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr Shachendra', 'Katkar', 'jdti.mdacs@gmail.com', '9869621270', 'MDACS', 'Mumbai DACS', 'b16f6d6bc47b9586dc9533124445601b', '5', '14.139.125.18', '7', '2020-12-16 16:24:02')"} {"userId":"7","date":"2020-12-16 16:24:02","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('307', '101', '22', '371', '5', '0', '14.139.125.18', '7', '2020-12-16 16:24:02')"} {"userId":"7","date":"2020-12-16 16:24:56","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Naina', 'Ingole', 'nayanaingole@gmail.com', '9821471788', 'Associate Professor, Microbiology dept, GSMC and KEMH, Mumbai', 'Mumbai DACS', '4818834f36ba2ddcb20e76062f284cb9', '4', '14.139.125.18', '7', '2020-12-16 16:24:56')"} {"userId":"7","date":"2020-12-16 16:24:56","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('308', '101', '22', '371', '5', '0', '14.139.125.18', '7', '2020-12-16 16:24:56')"} {"userId":"7","date":"2020-12-16 16:26:10","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Aritra Kimar', 'Bose', 'aritra3451@gmail.com', '9769120491', 'Assistant Profess, Department of Community Medicine,Topiwala National Medical College, Mumbai', 'Mumbai DACS', '6745e53a5fc69f9ecdda9b668bc8e58a', '4', '14.139.125.18', '7', '2020-12-16 16:26:10')"} {"userId":"7","date":"2020-12-16 16:26:10","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('309', '101', '22', '371', '5', '0', '14.139.125.18', '7', '2020-12-16 16:26:10')"} {"userId":"7","date":"2020-12-16 16:26:59","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Mridula', 'Solanki', 'drsolanki05@gmail.com', '9820203396', 'Associate Prof. Dept of Community Medicine, GS Medical College & KEM Hospital, Parel, Mumbai', 'Mumbai DACS', '82367e0088d8feb0874e5428fe21667f', '4', '14.139.125.18', '7', '2020-12-16 16:26:59')"} {"userId":"7","date":"2020-12-16 16:26:59","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('310', '101', '22', '371', '5', '0', '14.139.125.18', '7', '2020-12-16 16:26:59')"} {"userId":"7","date":"2020-12-16 16:28:22","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Atul', 'Desale', 'dr.a.v.desale@gmail.com', '8446146689', '"Assistant Professor, Dept of PSM, D Y Patil Medical College, Pune"', 'Maharashtra SACS', 'd14b6f5e8ace7d4783ecd1c850a60eb2', '4', '14.139.125.18', '7', '2020-12-16 16:28:22')"} {"userId":"7","date":"2020-12-16 16:28:22","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('311', '101', '22', '380', '5', '0', '14.139.125.18', '7', '2020-12-16 16:28:22')"} {"userId":"7","date":"2020-12-16 16:29:33","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Swati', 'Fulambarkar', 'drswatifulambarkar@gmail.com', '8888894153', 'Assistant Professor, Dept.of community Medicine,BJGMC and SGH, Pune', 'Maharashtra SACS', 'd3ff66e5c5c724af0c2844d884563830', '4', '14.139.125.18', '7', '2020-12-16 16:29:33')"} {"userId":"7","date":"2020-12-16 16:29:33","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('312', '101', '22', '380', '5', '0', '14.139.125.18', '7', '2020-12-16 16:29:33')"} {"userId":"7","date":"2020-12-16 16:32:28","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Kalpana', 'Kale', 'drkmkale@gmail.com', '9421792820', 'Associate Professor, Dept.of PSM Govt.Medical College, Miraj', 'Maharashtra SACS', '91f3f7962b6b56e68f91fd7ed15aa55f', '4', '14.139.125.18', '7', '2020-12-16 16:32:28')"} {"userId":"7","date":"2020-12-16 16:32:28","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('313', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2020-12-16 16:32:28')"} {"userId":"7","date":"2020-12-16 16:33:32","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Nandkeshav', 'Aswar', 'nandkeshavaswar@gmail.com', '9422863802', 'Associate Professor, Dept.of PSM Govt.Medical College, Miraj', 'Maharashtra SACS', 'fbc533a7f1e516618f822383fb6bacc0', '4', '14.139.125.18', '7', '2020-12-16 16:33:32')"} {"userId":"7","date":"2020-12-16 16:33:32","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('314', '101', '22', '383', '5', '0', '14.139.125.18', '7', '2020-12-16 16:33:32')"} {"userId":"7","date":"2020-12-16 16:36:10","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Madhuri', 'Suryawanshi', 'Dr.madhurijk@gmail.com', '8087482679', 'Assistant Professor, Dept of Microbiology Shri Bhausaheb Hire Govt Medical College Dhule', 'Maharashtra SACS', '6c231c3f00caee88c2156cbf6303610d', '4', '14.139.125.18', '7', '2020-12-16 16:36:10')"} {"userId":"7","date":"2020-12-16 16:36:10","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('315', '101', '22', '363', '5', '0', '14.139.125.18', '7', '2020-12-16 16:36:10')"} {"userId":"7","date":"2020-12-16 16:37:26","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Sarika', 'Patil', 'drdurgapjp@gmail.com', '8208489133', 'Assistant Professor, Department of Community Medicine', 'Maharashtra SACS', '839e0d3bf2302fd74f14c84c811241bd', '4', '14.139.125.18', '7', '2020-12-16 16:37:26')"} {"userId":"7","date":"2020-12-16 16:37:26","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('316', '101', '22', '363', '5', '0', '14.139.125.18', '7', '2020-12-16 16:37:26')"} {"userId":"7","date":"2020-12-16 16:38:28","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Durgesh', 'Deshmukh', 'deshmukhdurgesh08@gmail.com', '9823030557', 'Assistant Professor, Microbiology dept., GMC Yavatmal,', 'Maharashtra SACS', 'c3ae124ad9c398329d2e2269cf066fb1', '4', '14.139.125.18', '7', '2020-12-16 16:38:28')"} {"userId":"7","date":"2020-12-16 16:38:28","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('317', '101', '22', '390', '5', '0', '14.139.125.18', '7', '2020-12-16 16:38:28')"} {"userId":"7","date":"2020-12-16 16:39:33","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Niwrutti', 'Jiwane', 'dr.niwrutti.n.jiwane@gmail.com', '9511868391', 'Associate Professor, PSM Dept. GMC Chandrapur', 'Maharashtra SACS', '118a056e15be6d43a1b3383635c134b9', '4', '14.139.125.18', '7', '2020-12-16 16:39:33')"} {"userId":"7","date":"2020-12-16 16:39:33","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('318', '101', '22', '362', '5', '0', '14.139.125.18', '7', '2020-12-16 16:39:33')"} {"userId":"7","date":"2020-12-16 16:40:32","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Manoj', 'Talapalliwar', 'manojtalapalliwar@yahoo.com', '8275786200', 'Associate Professor,Dept.of Cummunity Medicine,GMC, Gondia', 'Maharashtra SACS', 'dfb17e530d64aed697534f7196bc5e5a', '4', '14.139.125.18', '7', '2020-12-16 16:40:32')"} {"userId":"7","date":"2020-12-16 16:40:32","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('319', '101', '22', '365', '5', '0', '14.139.125.18', '7', '2020-12-16 16:40:32')"} {"userId":"7","date":"2020-12-16 16:41:34","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Umesh', 'Kawalkar', 'umeshkawalkar01@gmail.com', '9730196442', 'Ass.Professor, Dept. of Cummunity Medicine, GMC Akola', 'Maharashtra SACS', 'cd2cd680cf047f3f5b16cf5855e06ce4', '4', '14.139.125.18', '7', '2020-12-16 16:41:34')"} {"userId":"7","date":"2020-12-16 16:41:34","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('320', '101', '22', '356', '5', '0', '14.139.125.18', '7', '2020-12-16 16:41:34')"} {"userId":"7","date":"2020-12-16 16:42:25","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Abhay', 'Gaidhane', 'abhaygaidhane@gmail.com', '9765404075', 'Professor, Community Medicine, JNMC, Sawangi (Meghe), Wardha', 'Maharashtra SACS', 'a22b5090e1d5f9537b6c820c498109f6', '4', '14.139.125.18', '7', '2020-12-16 16:42:25')"} {"userId":"7","date":"2020-12-16 16:42:25","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('321', '101', '22', '388', '5', '0', '14.139.125.18', '7', '2020-12-16 16:42:25')"} {"userId":"7","date":"2020-12-16 16:43:26","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Abhay', 'Chavan', 'dr.abchavan@rediffmail.com', '9158583182', 'Assistant Professor, GMC, Nagpur', 'Maharashtra SACS', '473e90eb18c8ceeff656a9b728afe56c', '4', '14.139.125.18', '7', '2020-12-16 16:43:26')"} {"userId":"7","date":"2020-12-16 16:43:26","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('322', '101', '22', '373', '5', '0', '14.139.125.18', '7', '2020-12-16 16:43:26')"} {"userId":"7","date":"2020-12-16 16:44:46","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr Prakash', 'Narwani', 'mersacs@yahoo.com', '9549650420', 'AD (M&E) and Focul Person HSS', 'Rajasthan SACS', '44319467c89297e4558be3b5b34f4b2d', '5', '14.139.125.18', '7', '2020-12-16 16:44:46')"} {"userId":"7","date":"2020-12-16 16:44:46","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('323', '101', '33', '502', '5', '0', '14.139.125.18', '7', '2020-12-16 16:44:46')"} {"userId":"7","date":"2020-12-16 16:45:45","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr Sunil', 'Kumar', 'ti.rsacs@gmail.com', '9414592426', 'JD(TI)', 'Rajasthan SACS', '021ed8c8d26fafc039f64d173795f7c0', '5', '14.139.125.18', '7', '2020-12-16 16:45:45')"} {"userId":"7","date":"2020-12-16 16:45:45","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('324', '101', '33', '502', '5', '0', '14.139.125.18', '7', '2020-12-16 16:45:45')"} {"userId":"7","date":"2020-12-16 16:46:38","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr Satveer', 'Lamba', 'jdbsrsacs1@gmail.com', '9413505385', 'AD(Basic Service)', 'Rajasthan SACS', 'af1fbd39c96eaa8aceeeb77c3559714a', '5', '14.139.125.18', '7', '2020-12-16 16:46:38')"} {"userId":"7","date":"2020-12-16 16:46:38","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('325', '101', '33', '502', '5', '0', '14.139.125.18', '7', '2020-12-16 16:46:38')"}