{"userId":"658","date":"2023-02-24 10:45:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('658', '157.38.137.157', '2023-02-24 10:45:44')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('650', '3118', '658', '2023-02-24', '1', '157.38.137.157', '658', '2023-02-24 10:50:36', '', '')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2801', '0', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2801', '1', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2801', '2', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2801', '3', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2801', '4', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2801', '', '', 'Array', '', 'Array', '', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2801', '', '', 'Array', '', 'Array', '', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2801', '', '', 'Array', '', 'Array', '', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2801', '', '', 'Array', '', 'Array', '', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"658","date":"2023-02-24 10:50:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2801', '157.38.137.157', '658', '2023-02-24 10:50:36')"} {"userId":"34","date":"2023-02-24 11:12:55","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '117.194.91.3', '2023-02-24 11:12:55')"} {"userId":"34","date":"2023-02-24 11:15:42","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1066', '2023-02-23', '34', '117.194.91.3', '34', '2023-02-24 11:15:42')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1066', '3268', '34', '2023-02-24', '0', '117.194.91.3', '34', '2023-02-24 11:15:48', '', '')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2802', '0', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2802', '', '', 'Array', '', 'Array', '', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2802', '', '', 'Array', '', 'Array', '', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2802', '', '', 'Array', '', 'Array', '', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2802', '', '', 'Array', '', 'Array', '', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:15:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2802', '117.194.91.3', '34', '2023-02-24 11:15:48')"} {"userId":"34","date":"2023-02-24 11:17:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '117.194.91.3', '2023-02-24 11:17:48')"} {"userId":"34","date":"2023-02-24 12:04:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('34', '117.214.72.158', '2023-02-24 12:04:59')"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE sitesupervision SET `siteid` = '1066', `userid` = '34', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2802'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE onssid = '11536'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE onssid = '11537'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE onssid = '11538'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE onssid = '11539'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE supvisstepid = '13812'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE visitfeedback SET `feedback` = 'Number of recruitment observed were very less.', `recommendation` = 'Follow up needed.', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE visitfeedbackid = '13786'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE visitfeedback SET `feedback` = 'The issue identified as less number of turn up from daily call of recruitment.', `recommendation` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE visitfeedbackid = '13787'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE visitfeedback SET `feedback` = 'Suggested to increase daily recruitment call.', `recommendation` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE visitfeedbackid = '13788'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE visitfeedback SET `feedback` = 'Also suggested to increase day of recruitment per week.', `recommendation` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE visitfeedbackid = '13789'"} {"userId":"34","date":"2023-02-24 12:11:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.72.158', `modifiedby` = '34', `modifieddate` = '2023-02-24 12:11:27' WHERE visitfeedbackid = '13790'"} {"userId":"658","date":"2023-02-24 14:08:03","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('658', '157.38.138.111', '2023-02-24 14:08:03')"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE sitesupervision SET `siteid` = '650', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '155', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2801'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Bharti', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE onssid = '11532'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE onsitestaffs SET `staffname` = 'Vandana Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE onssid = '11533'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE onsitestaffs SET `staffname` = 'Yoshada Kashyap', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE onssid = '11534'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE onssid = '11535'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265241 then '' when ansid=265242 then '' when ansid=265243 then '' when ansid=265244 then '' when ansid=265245 then '' when ansid=265246 then '' when ansid=265247 then '' when ansid=265347 then '' when ansid=265348 then '' when ansid=265290 then '' when ansid=265292 then '' when ansid=265294 then '' when ansid=265296 then '' when ansid=265298 then '' when ansid=265300 then '' when ansid=265301 then '' when ansid=265302 then '' when ansid=265303 then '' when ansid=265304 then '' when ansid=265305 then '' when ansid=265306 then '' when ansid=265307 then '' when ansid=265308 then '' when ansid=265309 then '' when ansid=265310 then '' when ansid=265311 then '' when ansid=265312 then '' when ansid=265313 then '' when ansid=265314 then '' when ansid=265315 then '' when ansid=265316 then '' when ansid=265317 then '' when ansid=265318 then '' when ansid=265319 then '' when ansid=265320 then '' when ansid=265321 then '' when ansid=265322 then '' when ansid=265323 then '' when ansid=265324 then '' when ansid=265325 then '' when ansid=265326 then '' when ansid=265327 then '' when ansid=265328 then '' when ansid=265329 then '' when ansid=265330 then '' when ansid=265331 then '' when ansid=265332 then '' when ansid=265333 then '' when ansid=265334 then '' when ansid=265335 then '' when ansid=265336 then '' when ansid=265337 then '' when ansid=265338 then '' when ansid=265339 then '' when ansid=265340 then '' when ansid=265341 then '' when ansid=265342 then '' when ansid=265343 then '' when ansid=265344 then '' when ansid=265345 then '' when ansid=265346 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:19:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265241','265242','265243','265244','265245','265246','265247','265347','265348','265290','265292','265294','265296','265298','265300','265301','265302','265303','265304','265305','265306','265307','265308','265309','265310','265311','265312','265313','265314','265315','265316','265317','265318','265319','265320','265321','265322','265323','265324','265325','265326','265327','265328','265329','265330','265331','265332','265333','265334','265335','265336','265337','265338','265339','265340','265341','265342','265343','265344','265345','265346')"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE supvisstepid = '13807'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE visitfeedbackid = '13781'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE visitfeedbackid = '13782'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE visitfeedbackid = '13783'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE visitfeedbackid = '13784'"} {"userId":"658","date":"2023-02-24 14:19:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:19:36' WHERE visitfeedbackid = '13785'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE sitesupervision SET `siteid` = '650', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '155', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2801'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Bharti', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE onssid = '11532'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Vandana Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE onssid = '11533'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Yoshada Kashyap', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE onssid = '11534'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE onssid = '11535'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265241 then '1' when ansid=265242 then '1' when ansid=265243 then '2' when ansid=265244 then '1' when ansid=265245 then '' when ansid=265246 then '719' when ansid=265247 then '1' when ansid=265347 then '1' when ansid=265348 then '1' when ansid=265290 then '' when ansid=265292 then '' when ansid=265294 then '' when ansid=265296 then '' when ansid=265298 then '' when ansid=265300 then '' when ansid=265301 then '' when ansid=265302 then '' when ansid=265303 then '' when ansid=265304 then '' when ansid=265305 then '' when ansid=265306 then '' when ansid=265307 then '' when ansid=265308 then '' when ansid=265309 then '' when ansid=265310 then '' when ansid=265311 then '' when ansid=265312 then '' when ansid=265313 then '' when ansid=265314 then '' when ansid=265315 then '' when ansid=265316 then '' when ansid=265317 then '' when ansid=265318 then '' when ansid=265319 then '' when ansid=265320 then '' when ansid=265321 then '' when ansid=265322 then '' when ansid=265323 then '' when ansid=265324 then '' when ansid=265325 then '' when ansid=265326 then '' when ansid=265327 then '' when ansid=265328 then '' when ansid=265329 then '' when ansid=265330 then '' when ansid=265331 then '' when ansid=265332 then '' when ansid=265333 then '' when ansid=265334 then '' when ansid=265335 then '' when ansid=265336 then '' when ansid=265337 then '' when ansid=265338 then '' when ansid=265339 then '' when ansid=265340 then '' when ansid=265341 then '' when ansid=265342 then '' when ansid=265343 then '' when ansid=265344 then '' when ansid=265345 then '' when ansid=265346 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:23:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265241','265242','265243','265244','265245','265246','265247','265347','265348','265290','265292','265294','265296','265298','265300','265301','265302','265303','265304','265305','265306','265307','265308','265309','265310','265311','265312','265313','265314','265315','265316','265317','265318','265319','265320','265321','265322','265323','265324','265325','265326','265327','265328','265329','265330','265331','265332','265333','265334','265335','265336','265337','265338','265339','265340','265341','265342','265343','265344','265345','265346')"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE supvisstepid = '13808'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE visitfeedbackid = '13781'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE visitfeedbackid = '13782'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE visitfeedbackid = '13783'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE visitfeedbackid = '13784'"} {"userId":"658","date":"2023-02-24 14:23:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:04' WHERE visitfeedbackid = '13785'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE sitesupervision SET `siteid` = '650', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '155', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2801'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Bharti', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE onssid = '11532'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE onsitestaffs SET `staffname` = 'Vandana Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE onssid = '11533'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE onsitestaffs SET `staffname` = 'Yoshada Kashyap', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE onssid = '11534'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE onssid = '11535'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265241 then '1' when ansid=265242 then '1' when ansid=265243 then '2' when ansid=265244 then '1' when ansid=265245 then '' when ansid=265246 then '719' when ansid=265247 then '1' when ansid=265347 then '1' when ansid=265348 then '1' when ansid=265290 then '2' when ansid=265292 then '1' when ansid=265294 then '1' when ansid=265296 then '3' when ansid=265298 then '5' when ansid=265300 then '' when ansid=265301 then '' when ansid=265302 then '' when ansid=265303 then '' when ansid=265304 then '' when ansid=265305 then '' when ansid=265306 then '' when ansid=265307 then '' when ansid=265308 then '' when ansid=265309 then '' when ansid=265310 then '' when ansid=265311 then '' when ansid=265312 then '' when ansid=265313 then '' when ansid=265314 then '' when ansid=265315 then '' when ansid=265316 then '' when ansid=265317 then '' when ansid=265318 then '' when ansid=265319 then '' when ansid=265320 then '' when ansid=265321 then '' when ansid=265322 then '' when ansid=265323 then '' when ansid=265324 then '' when ansid=265325 then '' when ansid=265326 then '' when ansid=265327 then '' when ansid=265328 then '' when ansid=265329 then '' when ansid=265330 then '' when ansid=265331 then '' when ansid=265332 then '' when ansid=265333 then '' when ansid=265334 then '' when ansid=265335 then '' when ansid=265336 then '' when ansid=265337 then '' when ansid=265338 then '' when ansid=265339 then '' when ansid=265340 then '' when ansid=265341 then '' when ansid=265342 then '' when ansid=265343 then '' when ansid=265344 then '' when ansid=265345 then '' when ansid=265346 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:23:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265241','265242','265243','265244','265245','265246','265247','265347','265348','265290','265292','265294','265296','265298','265300','265301','265302','265303','265304','265305','265306','265307','265308','265309','265310','265311','265312','265313','265314','265315','265316','265317','265318','265319','265320','265321','265322','265323','265324','265325','265326','265327','265328','265329','265330','265331','265332','265333','265334','265335','265336','265337','265338','265339','265340','265341','265342','265343','265344','265345','265346')"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE supvisstepid = '13809'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE visitfeedbackid = '13781'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE visitfeedbackid = '13782'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE visitfeedbackid = '13783'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE visitfeedbackid = '13784'"} {"userId":"658","date":"2023-02-24 14:23:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:23:24' WHERE visitfeedbackid = '13785'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE sitesupervision SET `siteid` = '650', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '155', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2801'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Bharti', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE onssid = '11532'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE onsitestaffs SET `staffname` = 'Vandana Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE onssid = '11533'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE onsitestaffs SET `staffname` = 'Yoshada Kashyap', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE onssid = '11534'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE onssid = '11535'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265241 then '1' when ansid=265242 then '1' when ansid=265243 then '2' when ansid=265244 then '1' when ansid=265245 then '' when ansid=265246 then '719' when ansid=265247 then '1' when ansid=265347 then '1' when ansid=265348 then '1' when ansid=265290 then '2' when ansid=265292 then '1' when ansid=265294 then '1' when ansid=265296 then '3' when ansid=265298 then '5' when ansid=265300 then '4' when ansid=265301 then '4' when ansid=265302 then '719' when ansid=265303 then '109' when ansid=265304 then '' when ansid=265305 then '1' when ansid=265306 then '1' when ansid=265307 then '' when ansid=265308 then '1' when ansid=265309 then '' when ansid=265310 then '1' when ansid=265311 then '8' when ansid=265312 then '1' when ansid=265313 then '1' when ansid=265314 then 'Counsellor' when ansid=265315 then '1' when ansid=265316 then '' when ansid=265317 then '1' when ansid=265318 then '1' when ansid=265319 then '' when ansid=265320 then '1' when ansid=265321 then '2' when ansid=265322 then '1' when ansid=265323 then '1' when ansid=265324 then '1' when ansid=265325 then '1' when ansid=265326 then '2' when ansid=265327 then '1' when ansid=265328 then '1' when ansid=265329 then '1' when ansid=265330 then '' when ansid=265331 then '3' when ansid=265332 then '' when ansid=265333 then '1' when ansid=265334 then '1' when ansid=265335 then '1' when ansid=265336 then '' when ansid=265337 then '1' when ansid=265338 then '1' when ansid=265339 then '1' when ansid=265340 then '2' when ansid=265341 then '1' when ansid=265342 then '0' when ansid=265343 then 'no issue' when ansid=265344 then 'visit by SST members on 23\/02\/23. No issues reported' when ansid=265345 then 'no' when ansid=265346 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:27:25'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265241','265242','265243','265244','265245','265246','265247','265347','265348','265290','265292','265294','265296','265298','265300','265301','265302','265303','265304','265305','265306','265307','265308','265309','265310','265311','265312','265313','265314','265315','265316','265317','265318','265319','265320','265321','265322','265323','265324','265325','265326','265327','265328','265329','265330','265331','265332','265333','265334','265335','265336','265337','265338','265339','265340','265341','265342','265343','265344','265345','265346')"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE supvisstepid = '13810'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE visitfeedbackid = '13781'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE visitfeedbackid = '13782'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE visitfeedbackid = '13783'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE visitfeedbackid = '13784'"} {"userId":"658","date":"2023-02-24 14:27:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:27:25' WHERE visitfeedbackid = '13785'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE sitesupervision SET `siteid` = '650', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '155', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2801'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Bharti', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE onssid = '11532'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE onsitestaffs SET `staffname` = 'Vandana Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE onssid = '11533'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE onsitestaffs SET `staffname` = 'Yoshada Kashyap', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE onssid = '11534'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE onssid = '11535'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265241 then '1' when ansid=265242 then '1' when ansid=265243 then '2' when ansid=265244 then '1' when ansid=265245 then '' when ansid=265246 then '719' when ansid=265247 then '1' when ansid=265347 then '1' when ansid=265348 then '1' when ansid=265290 then '2' when ansid=265292 then '1' when ansid=265294 then '1' when ansid=265296 then '3' when ansid=265298 then '5' when ansid=265300 then '4' when ansid=265301 then '4' when ansid=265302 then '719' when ansid=265303 then '109' when ansid=265304 then '' when ansid=265305 then '1' when ansid=265306 then '1' when ansid=265307 then '' when ansid=265308 then '1' when ansid=265309 then '' when ansid=265310 then '1' when ansid=265311 then '8' when ansid=265312 then '1' when ansid=265313 then '1' when ansid=265314 then 'Counsellor' when ansid=265315 then '1' when ansid=265316 then '' when ansid=265317 then '1' when ansid=265318 then '1' when ansid=265319 then '' when ansid=265320 then '1' when ansid=265321 then '2' when ansid=265322 then '1' when ansid=265323 then '1' when ansid=265324 then '1' when ansid=265325 then '1' when ansid=265326 then '2' when ansid=265327 then '1' when ansid=265328 then '1' when ansid=265329 then '1' when ansid=265330 then '' when ansid=265331 then '3' when ansid=265332 then '' when ansid=265333 then '1' when ansid=265334 then '1' when ansid=265335 then '1' when ansid=265336 then '' when ansid=265337 then '1' when ansid=265338 then '1' when ansid=265339 then '1' when ansid=265340 then '2' when ansid=265341 then '1' when ansid=265342 then '0' when ansid=265343 then 'no issue' when ansid=265344 then 'visit by SST members on 23\/02\/23. No issues reported' when ansid=265345 then 'no' when ansid=265346 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:28:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265241','265242','265243','265244','265245','265246','265247','265347','265348','265290','265292','265294','265296','265298','265300','265301','265302','265303','265304','265305','265306','265307','265308','265309','265310','265311','265312','265313','265314','265315','265316','265317','265318','265319','265320','265321','265322','265323','265324','265325','265326','265327','265328','265329','265330','265331','265332','265333','265334','265335','265336','265337','265338','265339','265340','265341','265342','265343','265344','265345','265346')"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE supvisstepid = '13811'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE visitfeedback SET `feedback` = 'No issues', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE visitfeedbackid = '13781'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE visitfeedback SET `feedback` = 'Signed Data form transportation sheet acknowledged by RI was not found', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE visitfeedbackid = '13782'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE visitfeedbackid = '13783'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE visitfeedbackid = '13784'"} {"userId":"658","date":"2023-02-24 14:28:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:28:24' WHERE visitfeedbackid = '13785'"} {"userId":"574","date":"2023-02-24 14:30:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.223', '2023-02-24 14:30:38')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('634', '3119', '658', '2023-02-24', '1', '157.38.138.111', '658', '2023-02-24 14:32:50', '', '')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2803', '0', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2803', '1', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2803', '2', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2803', '3', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2803', '4', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2803', '', '', 'Array', '', 'Array', '', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2803', '', '', 'Array', '', 'Array', '', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2803', '', '', 'Array', '', 'Array', '', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2803', '', '', 'Array', '', 'Array', '', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:32:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2803', '157.38.138.111', '658', '2023-02-24 14:32:50')"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE sitesupervision SET `siteid` = '634', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '142', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2803'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Chandresh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE onssid = '11540'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Manish Kr Garg', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '0', `remarks` = 'on site training received', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE onssid = '11541'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Ashutosh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE onssid = '11542'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE onssid = '11543'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265444 then '' when ansid=265445 then '' when ansid=265446 then '' when ansid=265447 then '' when ansid=265448 then '' when ansid=265449 then '' when ansid=265450 then '' when ansid=265550 then '' when ansid=265551 then '' when ansid=265493 then '' when ansid=265495 then '' when ansid=265497 then '' when ansid=265499 then '' when ansid=265501 then '' when ansid=265503 then '' when ansid=265504 then '' when ansid=265505 then '' when ansid=265506 then '' when ansid=265507 then '' when ansid=265508 then '' when ansid=265509 then '' when ansid=265510 then '' when ansid=265511 then '' when ansid=265512 then '' when ansid=265513 then '' when ansid=265514 then '' when ansid=265515 then '' when ansid=265516 then '' when ansid=265517 then '' when ansid=265518 then '' when ansid=265519 then '' when ansid=265520 then '' when ansid=265521 then '' when ansid=265522 then '' when ansid=265523 then '' when ansid=265524 then '' when ansid=265525 then '' when ansid=265526 then '' when ansid=265527 then '' when ansid=265528 then '' when ansid=265529 then '' when ansid=265530 then '' when ansid=265531 then '' when ansid=265532 then '' when ansid=265533 then '' when ansid=265534 then '' when ansid=265535 then '' when ansid=265536 then '' when ansid=265537 then '' when ansid=265538 then '' when ansid=265539 then '' when ansid=265540 then '' when ansid=265541 then '' when ansid=265542 then '' when ansid=265543 then '' when ansid=265544 then '' when ansid=265545 then '' when ansid=265546 then '' when ansid=265547 then '' when ansid=265548 then '' when ansid=265549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:35:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265444','265445','265446','265447','265448','265449','265450','265550','265551','265493','265495','265497','265499','265501','265503','265504','265505','265506','265507','265508','265509','265510','265511','265512','265513','265514','265515','265516','265517','265518','265519','265520','265521','265522','265523','265524','265525','265526','265527','265528','265529','265530','265531','265532','265533','265534','265535','265536','265537','265538','265539','265540','265541','265542','265543','265544','265545','265546','265547','265548','265549')"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE supvisstepid = '13813'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE visitfeedbackid = '13791'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE visitfeedbackid = '13792'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE visitfeedbackid = '13793'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE visitfeedbackid = '13794'"} {"userId":"658","date":"2023-02-24 14:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:35:39' WHERE visitfeedbackid = '13795'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE sitesupervision SET `siteid` = '634', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '142', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2803'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Chandresh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE onssid = '11540'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE onsitestaffs SET `staffname` = 'Manish Kr Garg', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '0', `remarks` = 'on site training received', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE onssid = '11541'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ashutosh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE onssid = '11542'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE onssid = '11543'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265444 then '2' when ansid=265445 then '1' when ansid=265446 then '1' when ansid=265447 then '' when ansid=265448 then '' when ansid=265449 then '315' when ansid=265450 then '1' when ansid=265550 then '1' when ansid=265551 then '1' when ansid=265493 then '' when ansid=265495 then '' when ansid=265497 then '' when ansid=265499 then '' when ansid=265501 then '' when ansid=265503 then '' when ansid=265504 then '' when ansid=265505 then '' when ansid=265506 then '' when ansid=265507 then '' when ansid=265508 then '' when ansid=265509 then '' when ansid=265510 then '' when ansid=265511 then '' when ansid=265512 then '' when ansid=265513 then '' when ansid=265514 then '' when ansid=265515 then '' when ansid=265516 then '' when ansid=265517 then '' when ansid=265518 then '' when ansid=265519 then '' when ansid=265520 then '' when ansid=265521 then '' when ansid=265522 then '' when ansid=265523 then '' when ansid=265524 then '' when ansid=265525 then '' when ansid=265526 then '' when ansid=265527 then '' when ansid=265528 then '' when ansid=265529 then '' when ansid=265530 then '' when ansid=265531 then '' when ansid=265532 then '' when ansid=265533 then '' when ansid=265534 then '' when ansid=265535 then '' when ansid=265536 then '' when ansid=265537 then '' when ansid=265538 then '' when ansid=265539 then '' when ansid=265540 then '' when ansid=265541 then '' when ansid=265542 then '' when ansid=265543 then '' when ansid=265544 then '' when ansid=265545 then '' when ansid=265546 then '' when ansid=265547 then '' when ansid=265548 then '' when ansid=265549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:36:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265444','265445','265446','265447','265448','265449','265450','265550','265551','265493','265495','265497','265499','265501','265503','265504','265505','265506','265507','265508','265509','265510','265511','265512','265513','265514','265515','265516','265517','265518','265519','265520','265521','265522','265523','265524','265525','265526','265527','265528','265529','265530','265531','265532','265533','265534','265535','265536','265537','265538','265539','265540','265541','265542','265543','265544','265545','265546','265547','265548','265549')"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE supvisstepid = '13814'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE visitfeedbackid = '13791'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE visitfeedbackid = '13792'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE visitfeedbackid = '13793'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE visitfeedbackid = '13794'"} {"userId":"658","date":"2023-02-24 14:36:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:20' WHERE visitfeedbackid = '13795'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE sitesupervision SET `siteid` = '634', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '142', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2803'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Chandresh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE onssid = '11540'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE onsitestaffs SET `staffname` = 'Manish Kr Garg', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '0', `remarks` = 'on site training received', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE onssid = '11541'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE onsitestaffs SET `staffname` = 'Ashutosh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE onssid = '11542'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE onssid = '11543'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265444 then '2' when ansid=265445 then '1' when ansid=265446 then '1' when ansid=265447 then '' when ansid=265448 then '' when ansid=265449 then '315' when ansid=265450 then '1' when ansid=265550 then '1' when ansid=265551 then '1' when ansid=265493 then '0' when ansid=265495 then '1' when ansid=265497 then '1' when ansid=265499 then '3' when ansid=265501 then '5' when ansid=265503 then '' when ansid=265504 then '' when ansid=265505 then '' when ansid=265506 then '' when ansid=265507 then '' when ansid=265508 then '' when ansid=265509 then '' when ansid=265510 then '' when ansid=265511 then '' when ansid=265512 then '' when ansid=265513 then '' when ansid=265514 then '' when ansid=265515 then '' when ansid=265516 then '' when ansid=265517 then '' when ansid=265518 then '' when ansid=265519 then '' when ansid=265520 then '' when ansid=265521 then '' when ansid=265522 then '' when ansid=265523 then '' when ansid=265524 then '' when ansid=265525 then '' when ansid=265526 then '' when ansid=265527 then '' when ansid=265528 then '' when ansid=265529 then '' when ansid=265530 then '' when ansid=265531 then '' when ansid=265532 then '' when ansid=265533 then '' when ansid=265534 then '' when ansid=265535 then '' when ansid=265536 then '' when ansid=265537 then '' when ansid=265538 then '' when ansid=265539 then '' when ansid=265540 then '' when ansid=265541 then '' when ansid=265542 then '' when ansid=265543 then '' when ansid=265544 then '' when ansid=265545 then '' when ansid=265546 then '' when ansid=265547 then '' when ansid=265548 then '' when ansid=265549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:36:41'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265444','265445','265446','265447','265448','265449','265450','265550','265551','265493','265495','265497','265499','265501','265503','265504','265505','265506','265507','265508','265509','265510','265511','265512','265513','265514','265515','265516','265517','265518','265519','265520','265521','265522','265523','265524','265525','265526','265527','265528','265529','265530','265531','265532','265533','265534','265535','265536','265537','265538','265539','265540','265541','265542','265543','265544','265545','265546','265547','265548','265549')"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE supvisstepid = '13815'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE visitfeedbackid = '13791'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE visitfeedbackid = '13792'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE visitfeedbackid = '13793'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE visitfeedbackid = '13794'"} {"userId":"658","date":"2023-02-24 14:36:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:36:41' WHERE visitfeedbackid = '13795'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE sitesupervision SET `siteid` = '634', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '142', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2803'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Chandresh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE onssid = '11540'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE onsitestaffs SET `staffname` = 'Manish Kr Garg', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '0', `remarks` = 'on site training received', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE onssid = '11541'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ashutosh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE onssid = '11542'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE onssid = '11543'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265444 then '2' when ansid=265445 then '1' when ansid=265446 then '1' when ansid=265447 then '' when ansid=265448 then '' when ansid=265449 then '315' when ansid=265450 then '1' when ansid=265550 then '1' when ansid=265551 then '1' when ansid=265493 then '0' when ansid=265495 then '1' when ansid=265497 then '1' when ansid=265499 then '3' when ansid=265501 then '5' when ansid=265503 then '3' when ansid=265504 then '2' when ansid=265505 then '315' when ansid=265506 then '19' when ansid=265507 then '' when ansid=265508 then '1' when ansid=265509 then '1' when ansid=265510 then 'ANC registration number as noticed in the HSS register was not consequitive but they informed that it was due to operational reasons & consequitive sampling was being maintained' when ansid=265511 then '2' when ansid=265512 then '' when ansid=265513 then '1' when ansid=265514 then '6' when ansid=265515 then '1' when ansid=265516 then '1' when ansid=265517 then 'Counsellor' when ansid=265518 then '1' when ansid=265519 then '' when ansid=265520 then '1' when ansid=265521 then '1' when ansid=265522 then '' when ansid=265523 then '1' when ansid=265524 then '1' when ansid=265525 then '1' when ansid=265526 then '1' when ansid=265527 then '1' when ansid=265528 then '1' when ansid=265529 then '3' when ansid=265530 then '1' when ansid=265531 then '1' when ansid=265532 then '1' when ansid=265533 then '' when ansid=265534 then '3' when ansid=265535 then '' when ansid=265536 then '1' when ansid=265537 then '1' when ansid=265538 then '1' when ansid=265539 then 'They have a puncture proof container' when ansid=265540 then '2' when ansid=265541 then '1' when ansid=265542 then '1' when ansid=265543 then '2' when ansid=265544 then '1' when ansid=265545 then '0' when ansid=265546 then 'none' when ansid=265547 then 'SST MEMBER Dr Rahul visited the site on 7\/02\/2023 and observed that the waiting area was not adequate, no display of flow chart, biomedical waste guidelines not followed etc. Most of the issues were taken care of except waiting area.' when ansid=265548 then 'ANC registration number as noticed in the HSS register was not consecutive but they informed that it was due to operational reasons & consecutive sampling was being maintained. Sample was taken before consent & filling of the Data Form. The client later refused to give consent.' when ansid=265549 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:50:46'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265444','265445','265446','265447','265448','265449','265450','265550','265551','265493','265495','265497','265499','265501','265503','265504','265505','265506','265507','265508','265509','265510','265511','265512','265513','265514','265515','265516','265517','265518','265519','265520','265521','265522','265523','265524','265525','265526','265527','265528','265529','265530','265531','265532','265533','265534','265535','265536','265537','265538','265539','265540','265541','265542','265543','265544','265545','265546','265547','265548','265549')"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE supvisstepid = '13816'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE visitfeedbackid = '13791'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE visitfeedbackid = '13792'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE visitfeedbackid = '13793'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE visitfeedbackid = '13794'"} {"userId":"658","date":"2023-02-24 14:50:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:50:46' WHERE visitfeedbackid = '13795'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE sitesupervision SET `siteid` = '634', `userid` = '658', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-25', `numofsamplecollected` = '142', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2803'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Chandresh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE onssid = '11540'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE onsitestaffs SET `staffname` = 'Manish Kr Garg', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '0', `remarks` = 'on site training received', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE onssid = '11541'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE onsitestaffs SET `staffname` = 'Ashutosh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE onssid = '11542'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE onssid = '11543'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=265444 then '2' when ansid=265445 then '1' when ansid=265446 then '1' when ansid=265447 then '' when ansid=265448 then '' when ansid=265449 then '315' when ansid=265450 then '1' when ansid=265550 then '1' when ansid=265551 then '1' when ansid=265493 then '0' when ansid=265495 then '1' when ansid=265497 then '1' when ansid=265499 then '3' when ansid=265501 then '5' when ansid=265503 then '3' when ansid=265504 then '2' when ansid=265505 then '315' when ansid=265506 then '19' when ansid=265507 then '' when ansid=265508 then '1' when ansid=265509 then '1' when ansid=265510 then 'ANC registration number as noticed in the HSS register was not consequitive but they informed that it was due to operational reasons & consequitive sampling was being maintained' when ansid=265511 then '2' when ansid=265512 then '' when ansid=265513 then '1' when ansid=265514 then '6' when ansid=265515 then '1' when ansid=265516 then '1' when ansid=265517 then 'Counsellor' when ansid=265518 then '1' when ansid=265519 then '' when ansid=265520 then '1' when ansid=265521 then '1' when ansid=265522 then '' when ansid=265523 then '1' when ansid=265524 then '1' when ansid=265525 then '1' when ansid=265526 then '1' when ansid=265527 then '1' when ansid=265528 then '1' when ansid=265529 then '3' when ansid=265530 then '1' when ansid=265531 then '1' when ansid=265532 then '1' when ansid=265533 then '' when ansid=265534 then '3' when ansid=265535 then '' when ansid=265536 then '1' when ansid=265537 then '1' when ansid=265538 then '1' when ansid=265539 then 'They have a puncture proof container' when ansid=265540 then '2' when ansid=265541 then '1' when ansid=265542 then '1' when ansid=265543 then '2' when ansid=265544 then '1' when ansid=265545 then '0' when ansid=265546 then 'none' when ansid=265547 then 'SST MEMBER Dr Rahul visited the site on 7\/02\/2023 and observed that the waiting area was not adequate, no display of flow chart, biomedical waste guidelines not followed etc. Most of the issues were taken care of except waiting area.' when ansid=265548 then 'ANC registration number as noticed in the HSS register was not consecutive but they informed that it was due to operational reasons & consecutive sampling was being maintained. Sample was taken before consent & filling of the Data Form. The client later refused to give consent.' when ansid=265549 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.38.138.111',\r\n\t\t\t\t\t\t\t\tmodifiedby =658,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-24 14:58:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('265444','265445','265446','265447','265448','265449','265450','265550','265551','265493','265495','265497','265499','265501','265503','265504','265505','265506','265507','265508','265509','265510','265511','265512','265513','265514','265515','265516','265517','265518','265519','265520','265521','265522','265523','265524','265525','265526','265527','265528','265529','265530','265531','265532','265533','265534','265535','265536','265537','265538','265539','265540','265541','265542','265543','265544','265545','265546','265547','265548','265549')"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE supvisstepid = '13817'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE visitfeedback SET `feedback` = 'Signed Data form transportation sheet acknowledged by RI was not found', `recommendation` = 'Asked to find out ways by which consequitive sampling could be maintained', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE visitfeedbackid = '13791'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE visitfeedback SET `feedback` = 'ANC registration number as noticed in the HSS register was not consequitive but they informed that it was due to operational reasons & consequitive sampling was being maintained', `recommendation` = 'To first take consent, then fill up data forms & at last take the blood sample.', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE visitfeedbackid = '13792'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE visitfeedback SET `feedback` = 'Waiting area not present', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE visitfeedbackid = '13793'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE visitfeedback SET `feedback` = 'Sample collected before filling of data forms & before taking consent.', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE visitfeedbackid = '13794'"} {"userId":"658","date":"2023-02-24 14:58:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.38.138.111', `modifiedby` = '658', `modifieddate` = '2023-02-24 14:58:04' WHERE visitfeedbackid = '13795'"}