{"userId":"574","date":"2023-02-13 10:24:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.65', '2023-02-13 10:24:00')"} {"userId":"674","date":"2023-02-13 11:32:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('674', '47.11.243.176', '2023-02-13 11:32:31')"} {"userId":"674","date":"2023-02-13 11:33:43","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1095', '2023-02-13', '674', '47.11.243.176', '674', '2023-02-13 11:33:43')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1095', '3256', '674', '2023-02-13', '1', '47.11.243.176', '674', '2023-02-13 11:33:51', '', '')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2789', '0', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2789', '1', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2789', '2', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2789', '3', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2789', '4', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2789', '', '', 'Array', '', 'Array', '', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2789', '', '', 'Array', '', 'Array', '', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2789', '', '', 'Array', '', 'Array', '', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2789', '', '', 'Array', '', 'Array', '', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:33:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2789', '47.11.243.176', '674', '2023-02-13 11:33:51')"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE sitesupervision SET `siteid` = '1095', `userid` = '674', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2023-02-13', `numofsamplecollected` = '122', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27', `locationtype` = '2', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2789'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Jyothi MC', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE onssid = '11484'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE onsitestaffs SET `staffname` = 'G Venkateshwar Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '18', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE onssid = '11485'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE onsitestaffs SET `staffname` = 'Farida Beebi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE onssid = '11486'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE onssid = '11487'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263977 then '' when ansid=263978 then '' when ansid=263979 then '' when ansid=263980 then '' when ansid=263981 then '' when ansid=263982 then '' when ansid=263983 then '' when ansid=264083 then '' when ansid=264084 then '' when ansid=264026 then '' when ansid=264028 then '' when ansid=264030 then '' when ansid=264032 then '' when ansid=264034 then '' when ansid=264036 then '' when ansid=264037 then '' when ansid=264038 then '' when ansid=264039 then '' when ansid=264040 then '' when ansid=264041 then '' when ansid=264042 then '' when ansid=264043 then '' when ansid=264044 then '' when ansid=264045 then '' when ansid=264046 then '' when ansid=264047 then '' when ansid=264048 then '' when ansid=264049 then '' when ansid=264050 then '' when ansid=264051 then '' when ansid=264052 then '' when ansid=264053 then '' when ansid=264054 then '' when ansid=264055 then '' when ansid=264056 then '' when ansid=264057 then '' when ansid=264058 then '' when ansid=264059 then '' when ansid=264060 then '' when ansid=264061 then '' when ansid=264062 then '' when ansid=264063 then '' when ansid=264064 then '' when ansid=264065 then '' when ansid=264066 then '' when ansid=264067 then '' when ansid=264068 then '' when ansid=264069 then '' when ansid=264070 then '' when ansid=264071 then '' when ansid=264072 then '' when ansid=264073 then '' when ansid=264074 then '' when ansid=264075 then '' when ansid=264076 then '' when ansid=264077 then '' when ansid=264078 then '' when ansid=264079 then '' when ansid=264080 then '' when ansid=264081 then '' when ansid=264082 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '47.11.243.176',\r\n\t\t\t\t\t\t\t\tmodifiedby =674,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 11:37:27'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263977','263978','263979','263980','263981','263982','263983','264083','264084','264026','264028','264030','264032','264034','264036','264037','264038','264039','264040','264041','264042','264043','264044','264045','264046','264047','264048','264049','264050','264051','264052','264053','264054','264055','264056','264057','264058','264059','264060','264061','264062','264063','264064','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264075','264076','264077','264078','264079','264080','264081','264082')"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE supvisstepid = '13751'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE visitfeedbackid = '13721'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE visitfeedbackid = '13722'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE visitfeedbackid = '13723'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE visitfeedbackid = '13724'"} {"userId":"674","date":"2023-02-13 11:37:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:37:27' WHERE visitfeedbackid = '13725'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE sitesupervision SET `siteid` = '1095', `userid` = '674', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2023-02-13', `numofsamplecollected` = '122', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20', `locationtype` = '2', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2789'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Jyothi MC', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE onssid = '11484'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'G Venkateshwar Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '18', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE onssid = '11485'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE onsitestaffs SET `staffname` = 'Farida Beebi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE onssid = '11486'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE onssid = '11487'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263977 then '1' when ansid=263978 then '1' when ansid=263979 then '1' when ansid=263980 then '' when ansid=263981 then '' when ansid=263982 then '80' when ansid=263983 then '1' when ansid=264083 then '1' when ansid=264084 then '1' when ansid=264026 then '' when ansid=264028 then '' when ansid=264030 then '' when ansid=264032 then '' when ansid=264034 then '' when ansid=264036 then '' when ansid=264037 then '' when ansid=264038 then '' when ansid=264039 then '' when ansid=264040 then '' when ansid=264041 then '' when ansid=264042 then '' when ansid=264043 then '' when ansid=264044 then '' when ansid=264045 then '' when ansid=264046 then '' when ansid=264047 then '' when ansid=264048 then '' when ansid=264049 then '' when ansid=264050 then '' when ansid=264051 then '' when ansid=264052 then '' when ansid=264053 then '' when ansid=264054 then '' when ansid=264055 then '' when ansid=264056 then '' when ansid=264057 then '' when ansid=264058 then '' when ansid=264059 then '' when ansid=264060 then '' when ansid=264061 then '' when ansid=264062 then '' when ansid=264063 then '' when ansid=264064 then '' when ansid=264065 then '' when ansid=264066 then '' when ansid=264067 then '' when ansid=264068 then '' when ansid=264069 then '' when ansid=264070 then '' when ansid=264071 then '' when ansid=264072 then '' when ansid=264073 then '' when ansid=264074 then '' when ansid=264075 then '' when ansid=264076 then '' when ansid=264077 then '' when ansid=264078 then '' when ansid=264079 then '' when ansid=264080 then '' when ansid=264081 then '' when ansid=264082 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '47.11.243.176',\r\n\t\t\t\t\t\t\t\tmodifiedby =674,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 11:43:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263977','263978','263979','263980','263981','263982','263983','264083','264084','264026','264028','264030','264032','264034','264036','264037','264038','264039','264040','264041','264042','264043','264044','264045','264046','264047','264048','264049','264050','264051','264052','264053','264054','264055','264056','264057','264058','264059','264060','264061','264062','264063','264064','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264075','264076','264077','264078','264079','264080','264081','264082')"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE supvisstepid = '13752'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE visitfeedbackid = '13721'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE visitfeedbackid = '13722'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE visitfeedbackid = '13723'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE visitfeedbackid = '13724'"} {"userId":"674","date":"2023-02-13 11:43:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:43:20' WHERE visitfeedbackid = '13725'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE sitesupervision SET `siteid` = '1095', `userid` = '674', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2023-02-13', `numofsamplecollected` = '122', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20', `locationtype` = '2', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2789'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Jyothi MC', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE onssid = '11484'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE onsitestaffs SET `staffname` = 'G Venkateshwar Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '18', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE onssid = '11485'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE onsitestaffs SET `staffname` = 'Farida Beebi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE onssid = '11486'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE onssid = '11487'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263977 then '1' when ansid=263978 then '1' when ansid=263979 then '1' when ansid=263980 then '' when ansid=263981 then '' when ansid=263982 then '80' when ansid=263983 then '1' when ansid=264083 then '1' when ansid=264084 then '1' when ansid=264026 then '1' when ansid=264028 then '1' when ansid=264030 then '25' when ansid=264032 then '90' when ansid=264034 then '5' when ansid=264036 then '' when ansid=264037 then '' when ansid=264038 then '' when ansid=264039 then '' when ansid=264040 then '' when ansid=264041 then '' when ansid=264042 then '' when ansid=264043 then '' when ansid=264044 then '' when ansid=264045 then '' when ansid=264046 then '' when ansid=264047 then '' when ansid=264048 then '' when ansid=264049 then '' when ansid=264050 then '' when ansid=264051 then '' when ansid=264052 then '' when ansid=264053 then '' when ansid=264054 then '' when ansid=264055 then '' when ansid=264056 then '' when ansid=264057 then '' when ansid=264058 then '' when ansid=264059 then '' when ansid=264060 then '' when ansid=264061 then '' when ansid=264062 then '' when ansid=264063 then '' when ansid=264064 then '' when ansid=264065 then '' when ansid=264066 then '' when ansid=264067 then '' when ansid=264068 then '' when ansid=264069 then '' when ansid=264070 then '' when ansid=264071 then '' when ansid=264072 then '' when ansid=264073 then '' when ansid=264074 then '' when ansid=264075 then '' when ansid=264076 then '' when ansid=264077 then '' when ansid=264078 then '' when ansid=264079 then '' when ansid=264080 then '' when ansid=264081 then '' when ansid=264082 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '47.11.243.176',\r\n\t\t\t\t\t\t\t\tmodifiedby =674,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 11:47:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263977','263978','263979','263980','263981','263982','263983','264083','264084','264026','264028','264030','264032','264034','264036','264037','264038','264039','264040','264041','264042','264043','264044','264045','264046','264047','264048','264049','264050','264051','264052','264053','264054','264055','264056','264057','264058','264059','264060','264061','264062','264063','264064','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264075','264076','264077','264078','264079','264080','264081','264082')"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE supvisstepid = '13753'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE visitfeedbackid = '13721'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE visitfeedbackid = '13722'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE visitfeedbackid = '13723'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE visitfeedbackid = '13724'"} {"userId":"674","date":"2023-02-13 11:47:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 11:47:20' WHERE visitfeedbackid = '13725'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE sitesupervision SET `siteid` = '1095', `userid` = '674', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2023-02-13', `numofsamplecollected` = '122', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05', `locationtype` = '2', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2789'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Jyothi MC', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE onssid = '11484'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE onsitestaffs SET `staffname` = 'G Venkateshwar Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '18', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE onssid = '11485'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE onsitestaffs SET `staffname` = 'Farida Beebi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE onssid = '11486'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE onssid = '11487'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263977 then '1' when ansid=263978 then '1' when ansid=263979 then '1' when ansid=263980 then '' when ansid=263981 then '' when ansid=263982 then '80' when ansid=263983 then '1' when ansid=264083 then '1' when ansid=264084 then '1' when ansid=264026 then '1' when ansid=264028 then '1' when ansid=264030 then '25' when ansid=264032 then '90' when ansid=264034 then '5' when ansid=264036 then '2' when ansid=264037 then '2' when ansid=264038 then '122' when ansid=264039 then '12' when ansid=264040 then '' when ansid=264041 then '1' when ansid=264042 then '1' when ansid=264043 then '' when ansid=264044 then '1' when ansid=264045 then '' when ansid=264046 then '1' when ansid=264047 then '3' when ansid=264048 then '2' when ansid=264049 then '1' when ansid=264050 then 'G Venkateshwar Rao' when ansid=264051 then '1' when ansid=264052 then '' when ansid=264053 then '1' when ansid=264054 then '1' when ansid=264055 then '' when ansid=264056 then '1' when ansid=264057 then '2' when ansid=264058 then '1' when ansid=264059 then '1' when ansid=264060 then '1' when ansid=264061 then '1' when ansid=264062 then '2' when ansid=264063 then '1' when ansid=264064 then '1' when ansid=264065 then '1' when ansid=264066 then '' when ansid=264067 then '3' when ansid=264068 then '' when ansid=264069 then '1' when ansid=264070 then '1' when ansid=264071 then '1' when ansid=264072 then '' when ansid=264073 then '1' when ansid=264074 then '1' when ansid=264075 then '1' when ansid=264076 then '3' when ansid=264077 then '1' when ansid=264078 then '00' when ansid=264079 then 'Nil' when ansid=264080 then 'No' when ansid=264081 then 'No' when ansid=264082 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '47.11.243.176',\r\n\t\t\t\t\t\t\t\tmodifiedby =674,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 12:00:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263977','263978','263979','263980','263981','263982','263983','264083','264084','264026','264028','264030','264032','264034','264036','264037','264038','264039','264040','264041','264042','264043','264044','264045','264046','264047','264048','264049','264050','264051','264052','264053','264054','264055','264056','264057','264058','264059','264060','264061','264062','264063','264064','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264075','264076','264077','264078','264079','264080','264081','264082')"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE supvisstepid = '13754'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE visitfeedbackid = '13721'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE visitfeedbackid = '13722'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE visitfeedbackid = '13723'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE visitfeedbackid = '13724'"} {"userId":"674","date":"2023-02-13 12:00:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:05' WHERE visitfeedbackid = '13725'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE sitesupervision SET `siteid` = '1095', `userid` = '674', `ancservicedays` = '2', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2023-02-13', `numofsamplecollected` = '122', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49', `locationtype` = '2', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2789'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Jyothi MC', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE onssid = '11484'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE onsitestaffs SET `staffname` = 'G Venkateshwar Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '18', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE onssid = '11485'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE onsitestaffs SET `staffname` = 'Farida Beebi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '13', `istrained` = '1', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE onssid = '11486'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE onssid = '11487'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263977 then '1' when ansid=263978 then '1' when ansid=263979 then '1' when ansid=263980 then '' when ansid=263981 then '' when ansid=263982 then '80' when ansid=263983 then '1' when ansid=264083 then '1' when ansid=264084 then '1' when ansid=264026 then '1' when ansid=264028 then '1' when ansid=264030 then '25' when ansid=264032 then '90' when ansid=264034 then '5' when ansid=264036 then '2' when ansid=264037 then '2' when ansid=264038 then '122' when ansid=264039 then '12' when ansid=264040 then '' when ansid=264041 then '1' when ansid=264042 then '1' when ansid=264043 then '' when ansid=264044 then '1' when ansid=264045 then '' when ansid=264046 then '1' when ansid=264047 then '3' when ansid=264048 then '2' when ansid=264049 then '1' when ansid=264050 then 'G Venkateshwar Rao' when ansid=264051 then '1' when ansid=264052 then '' when ansid=264053 then '1' when ansid=264054 then '1' when ansid=264055 then '' when ansid=264056 then '1' when ansid=264057 then '2' when ansid=264058 then '1' when ansid=264059 then '1' when ansid=264060 then '1' when ansid=264061 then '1' when ansid=264062 then '2' when ansid=264063 then '1' when ansid=264064 then '1' when ansid=264065 then '1' when ansid=264066 then '' when ansid=264067 then '3' when ansid=264068 then '' when ansid=264069 then '1' when ansid=264070 then '1' when ansid=264071 then '1' when ansid=264072 then '' when ansid=264073 then '1' when ansid=264074 then '1' when ansid=264075 then '1' when ansid=264076 then '3' when ansid=264077 then '1' when ansid=264078 then '00' when ansid=264079 then 'Nil' when ansid=264080 then 'No' when ansid=264081 then 'No' when ansid=264082 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '47.11.243.176',\r\n\t\t\t\t\t\t\t\tmodifiedby =674,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 12:00:49'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263977','263978','263979','263980','263981','263982','263983','264083','264084','264026','264028','264030','264032','264034','264036','264037','264038','264039','264040','264041','264042','264043','264044','264045','264046','264047','264048','264049','264050','264051','264052','264053','264054','264055','264056','264057','264058','264059','264060','264061','264062','264063','264064','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264075','264076','264077','264078','264079','264080','264081','264082')"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE supvisstepid = '13755'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE visitfeedback SET `feedback` = 'No issue identified', `recommendation` = 'Nil', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE visitfeedbackid = '13721'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE visitfeedbackid = '13722'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE visitfeedbackid = '13723'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE visitfeedbackid = '13724'"} {"userId":"674","date":"2023-02-13 12:00:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.11.243.176', `modifiedby` = '674', `modifieddate` = '2023-02-13 12:00:49' WHERE visitfeedbackid = '13725'"} {"userId":"574","date":"2023-02-13 15:36:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.65', '2023-02-13 15:36:40')"} {"userId":"647","date":"2023-02-13 21:04:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('647', '103.95.82.241', '2023-02-13 21:04:10')"} {"userId":"647","date":"2023-02-13 21:08:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('647', '103.95.82.241', '2023-02-13 21:08:46')"} {"userId":"601","date":"2023-02-13 21:09:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('601', '49.36.111.169', '2023-02-13 21:09:14')"} {"userId":"601","date":"2023-02-13 21:11:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('601', '49.36.111.169', '2023-02-13 21:11:42')"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '' when ansid=261741 then '' when ansid=261742 then '' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '' when ansid=261846 then '' when ansid=261847 then '' when ansid=261789 then '' when ansid=261791 then '' when ansid=261793 then '' when ansid=261795 then '' when ansid=261797 then '' when ansid=261799 then '' when ansid=261800 then '' when ansid=261801 then '' when ansid=261802 then '' when ansid=261803 then '' when ansid=261804 then '' when ansid=261805 then '' when ansid=261806 then '' when ansid=261807 then '' when ansid=261808 then '' when ansid=261809 then '' when ansid=261810 then '' when ansid=261811 then '' when ansid=261812 then '' when ansid=261813 then '' when ansid=261814 then '' when ansid=261815 then '' when ansid=261816 then '' when ansid=261817 then '' when ansid=261818 then '' when ansid=261819 then '' when ansid=261820 then '' when ansid=261821 then '' when ansid=261822 then '' when ansid=261823 then '' when ansid=261824 then '' when ansid=261825 then '' when ansid=261826 then '' when ansid=261827 then '' when ansid=261828 then '' when ansid=261829 then '' when ansid=261830 then '' when ansid=261831 then '' when ansid=261832 then '' when ansid=261833 then '' when ansid=261834 then '' when ansid=261835 then '' when ansid=261836 then '' when ansid=261837 then '' when ansid=261838 then '' when ansid=261839 then '' when ansid=261840 then '' when ansid=261841 then '' when ansid=261842 then '' when ansid=261843 then '' when ansid=261844 then '' when ansid=261845 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:18:47'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE supvisstepid = '13644'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:18:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:18:47' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '1' when ansid=261741 then '1' when ansid=261742 then '1' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '1' when ansid=261846 then '1' when ansid=261847 then '1' when ansid=261789 then '' when ansid=261791 then '' when ansid=261793 then '' when ansid=261795 then '' when ansid=261797 then '' when ansid=261799 then '' when ansid=261800 then '' when ansid=261801 then '' when ansid=261802 then '' when ansid=261803 then '' when ansid=261804 then '' when ansid=261805 then '' when ansid=261806 then '' when ansid=261807 then '' when ansid=261808 then '' when ansid=261809 then '' when ansid=261810 then '' when ansid=261811 then '' when ansid=261812 then '' when ansid=261813 then '' when ansid=261814 then '' when ansid=261815 then '' when ansid=261816 then '' when ansid=261817 then '' when ansid=261818 then '' when ansid=261819 then '' when ansid=261820 then '' when ansid=261821 then '' when ansid=261822 then '' when ansid=261823 then '' when ansid=261824 then '' when ansid=261825 then '' when ansid=261826 then '' when ansid=261827 then '' when ansid=261828 then '' when ansid=261829 then '' when ansid=261830 then '' when ansid=261831 then '' when ansid=261832 then '' when ansid=261833 then '' when ansid=261834 then '' when ansid=261835 then '' when ansid=261836 then '' when ansid=261837 then '' when ansid=261838 then '' when ansid=261839 then '' when ansid=261840 then '' when ansid=261841 then '' when ansid=261842 then '' when ansid=261843 then '' when ansid=261844 then '' when ansid=261845 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:19:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE supvisstepid = '13645'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:19:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:19:33' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '1' when ansid=261741 then '1' when ansid=261742 then '1' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '1' when ansid=261846 then '1' when ansid=261847 then '1' when ansid=261789 then '1' when ansid=261791 then '1' when ansid=261793 then '1' when ansid=261795 then '90' when ansid=261797 then '1' when ansid=261799 then '' when ansid=261800 then '' when ansid=261801 then '' when ansid=261802 then '' when ansid=261803 then '' when ansid=261804 then '' when ansid=261805 then '' when ansid=261806 then '' when ansid=261807 then '' when ansid=261808 then '' when ansid=261809 then '' when ansid=261810 then '' when ansid=261811 then '' when ansid=261812 then '' when ansid=261813 then '' when ansid=261814 then '' when ansid=261815 then '' when ansid=261816 then '' when ansid=261817 then '' when ansid=261818 then '' when ansid=261819 then '' when ansid=261820 then '' when ansid=261821 then '' when ansid=261822 then '' when ansid=261823 then '' when ansid=261824 then '' when ansid=261825 then '' when ansid=261826 then '' when ansid=261827 then '' when ansid=261828 then '' when ansid=261829 then '' when ansid=261830 then '' when ansid=261831 then '' when ansid=261832 then '' when ansid=261833 then '' when ansid=261834 then '' when ansid=261835 then '' when ansid=261836 then '' when ansid=261837 then '' when ansid=261838 then '' when ansid=261839 then '' when ansid=261840 then '' when ansid=261841 then '' when ansid=261842 then '' when ansid=261843 then '' when ansid=261844 then '' when ansid=261845 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:21:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE supvisstepid = '13646'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:21:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:21:11' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '1' when ansid=261741 then '1' when ansid=261742 then '1' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '1' when ansid=261846 then '1' when ansid=261847 then '1' when ansid=261789 then '1' when ansid=261791 then '1' when ansid=261793 then '1' when ansid=261795 then '90' when ansid=261797 then '1' when ansid=261799 then '6' when ansid=261800 then '2' when ansid=261801 then '183' when ansid=261802 then '110' when ansid=261803 then '' when ansid=261804 then '1' when ansid=261805 then '1' when ansid=261806 then '' when ansid=261807 then '1' when ansid=261808 then '' when ansid=261809 then '1' when ansid=261810 then '8' when ansid=261811 then '1' when ansid=261812 then '1' when ansid=261813 then 'Counselor' when ansid=261814 then '1' when ansid=261815 then '' when ansid=261816 then '1' when ansid=261817 then '1' when ansid=261818 then '' when ansid=261819 then '1' when ansid=261820 then '4' when ansid=261821 then '1' when ansid=261822 then '1' when ansid=261823 then '1' when ansid=261824 then '1' when ansid=261825 then '3' when ansid=261826 then '1' when ansid=261827 then '1' when ansid=261828 then '1' when ansid=261829 then '' when ansid=261830 then '3' when ansid=261831 then '' when ansid=261832 then '1' when ansid=261833 then '1' when ansid=261834 then '1' when ansid=261835 then '' when ansid=261836 then '1' when ansid=261837 then '1' when ansid=261838 then '1' when ansid=261839 then '2' when ansid=261840 then '1' when ansid=261841 then '0' when ansid=261842 then 'No' when ansid=261843 then '3rd January, K.V.R. Sailaya, DPM DAPCU visited the facility, On 9th Jan, Dr. Y. Padmasri SST member visited and on 13th Mr. Badri DAPCU visited the facility. The observants has no action points' when ansid=261844 then 'The HSS is conducted well according to guidelines. However, Lab Technician will be attending state level training program. By estimating the shortage of sample at the end of 3 months, they may increase one extra sample to compensate the target in the end of the period' when ansid=261845 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:36:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE supvisstepid = '13646'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:36:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:36:40' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '1' when ansid=261741 then '1' when ansid=261742 then '1' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '1' when ansid=261846 then '1' when ansid=261847 then '1' when ansid=261789 then '1' when ansid=261791 then '1' when ansid=261793 then '1' when ansid=261795 then '90' when ansid=261797 then '1' when ansid=261799 then '6' when ansid=261800 then '2' when ansid=261801 then '183' when ansid=261802 then '110' when ansid=261803 then '' when ansid=261804 then '1' when ansid=261805 then '1' when ansid=261806 then '' when ansid=261807 then '1' when ansid=261808 then '' when ansid=261809 then '1' when ansid=261810 then '8' when ansid=261811 then '1' when ansid=261812 then '1' when ansid=261813 then 'Counselor' when ansid=261814 then '1' when ansid=261815 then '' when ansid=261816 then '1' when ansid=261817 then '1' when ansid=261818 then '' when ansid=261819 then '1' when ansid=261820 then '4' when ansid=261821 then '1' when ansid=261822 then '1' when ansid=261823 then '1' when ansid=261824 then '1' when ansid=261825 then '3' when ansid=261826 then '1' when ansid=261827 then '1' when ansid=261828 then '1' when ansid=261829 then '' when ansid=261830 then '3' when ansid=261831 then '' when ansid=261832 then '1' when ansid=261833 then '1' when ansid=261834 then '1' when ansid=261835 then '' when ansid=261836 then '1' when ansid=261837 then '1' when ansid=261838 then '1' when ansid=261839 then '2' when ansid=261840 then '1' when ansid=261841 then '0' when ansid=261842 then 'No' when ansid=261843 then '3rd January, K.V.R. Sailaya, DPM DAPCU visited the facility, On 9th Jan, Dr. Y. Padmasri SST member visited and on 13th Mr. Badri DAPCU visited the facility. The observants has no action points' when ansid=261844 then 'The HSS is conducted well according to guidelines. However, Lab Technician will be attending state level training program. By estimating the shortage of sample at the end of 3 months, they may increase one extra sample to compensate the target in the end of the period' when ansid=261845 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:37:01'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE supvisstepid = '13647'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:37:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:37:01' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE sitesupervision SET `siteid` = '746', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '183', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39', `locationtype` = '2', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '28.5533739', `endlongitude` = '77.1785222' WHERE ssid = '2768'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. P. usha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE onssid = '11400'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE onsitestaffs SET `staffname` = 'M.V. Ravi Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE onssid = '11401'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE onsitestaffs SET `staffname` = 'K. Kalavati', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE onssid = '11402'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Ch. Asha Lata', `staffdesigid` = '', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE onssid = '11403'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261740 then '1' when ansid=261741 then '1' when ansid=261742 then '1' when ansid=261743 then '' when ansid=261744 then '' when ansid=261745 then '' when ansid=261746 then '1' when ansid=261846 then '1' when ansid=261847 then '1' when ansid=261789 then '1' when ansid=261791 then '1' when ansid=261793 then '1' when ansid=261795 then '90' when ansid=261797 then '1' when ansid=261799 then '6' when ansid=261800 then '2' when ansid=261801 then '183' when ansid=261802 then '110' when ansid=261803 then '' when ansid=261804 then '1' when ansid=261805 then '1' when ansid=261806 then '' when ansid=261807 then '1' when ansid=261808 then '' when ansid=261809 then '1' when ansid=261810 then '8' when ansid=261811 then '1' when ansid=261812 then '1' when ansid=261813 then 'Counselor' when ansid=261814 then '1' when ansid=261815 then '' when ansid=261816 then '1' when ansid=261817 then '1' when ansid=261818 then '' when ansid=261819 then '1' when ansid=261820 then '4' when ansid=261821 then '1' when ansid=261822 then '1' when ansid=261823 then '1' when ansid=261824 then '1' when ansid=261825 then '3' when ansid=261826 then '1' when ansid=261827 then '1' when ansid=261828 then '1' when ansid=261829 then '' when ansid=261830 then '3' when ansid=261831 then '' when ansid=261832 then '1' when ansid=261833 then '1' when ansid=261834 then '1' when ansid=261835 then '' when ansid=261836 then '1' when ansid=261837 then '1' when ansid=261838 then '1' when ansid=261839 then '2' when ansid=261840 then '1' when ansid=261841 then '0' when ansid=261842 then 'No' when ansid=261843 then '3rd January, K.V.R. Sailaya, DPM DAPCU visited the facility, On 9th Jan, Dr. Y. Padmasri SST member visited and on 13th Mr. Badri DAPCU visited the facility. The observants has no action points' when ansid=261844 then 'The HSS is conducted well according to guidelines. However, Lab Technician will be attending state level training program. By estimating the shortage of sample at the end of 3 months, they may increase one extra sample to compensate the target in the end of the period' when ansid=261845 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:42:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261740','261741','261742','261743','261744','261745','261746','261846','261847','261789','261791','261793','261795','261797','261799','261800','261801','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845')"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE supvisstepid = '13648'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE visitfeedback SET `feedback` = 'Possible shortage of sample target due to absence of a few days by Lab tech who would attending state level training', `recommendation` = 'Advised to estimate the number of sample fall short due to absence of lab technician and according increase one\/two sample per day within the the time line to reach the target', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE visitfeedbackid = '13616'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE visitfeedbackid = '13617'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE visitfeedbackid = '13618'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE visitfeedbackid = '13619'"} {"userId":"647","date":"2023-02-13 21:42:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:42:39' WHERE visitfeedbackid = '13620'"} {"userId":"647","date":"2023-02-13 21:45:21","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1866', '2023-02-09', '647', '103.95.82.241', '647', '2023-02-13 21:45:21')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1866', '3257', '647', '2023-02-13', '1', '103.95.82.241', '647', '2023-02-13 21:45:33', '', '')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '0', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '1', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '2', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '3', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '4', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '5', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2790', '6', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2790', '', '', 'Array', '', 'Array', '', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2790', '', '', 'Array', '', 'Array', '', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2790', '', '', 'Array', '', 'Array', '', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2790', '', '', 'Array', '', 'Array', '', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('184', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('185', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('186', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('187', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('188', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('189', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('190', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('191', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('192', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('193', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('194', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('195', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('196', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('197', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('198', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('199', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('200', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('201', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('202', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('203', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('204', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('205', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('206', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('207', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('208', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('209', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('210', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('211', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('212', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('213', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('214', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('215', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('216', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('217', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('218', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('219', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('220', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('221', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('222', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('223', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('224', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('225', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('226', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('227', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('228', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('229', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('230', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('231', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('232', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('233', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('234', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('235', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('236', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('237', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('238', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('239', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('240', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('241', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('242', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('243', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('244', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('245', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('246', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('247', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('248', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('249', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('250', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('251', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('252', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('253', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('254', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('255', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('256', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('257', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('258', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('259', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('260', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('261', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('262', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('263', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('264', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('265', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('266', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('267', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('268', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('269', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('270', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('271', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('272', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('273', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('274', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('275', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('276', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('277', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('280', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('281', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('282', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('283', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('284', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('285', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('286', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('287', '2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:45:33","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2790', '103.95.82.241', '647', '2023-02-13 21:45:33')"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then 'CoombAids' when ansid=263477 then 'ARKRAY- Prv.ltd' when ansid=263478 then '3792' when ansid=263479 then '27670' when ansid=263480 then '10\/9\/24' when ansid=263481 then '2-8 degree' when ansid=263482 then 'Standard' when ansid=263483 then 'ARKRAY PVT.LTD' when ansid=263484 then '50' when ansid=263485 then '57088' when ansid=263486 then '8\/24' when ansid=263487 then '2-8 degree' when ansid=263550 then 'Not available, procurement under process' when ansid=263551 then '-' when ansid=263552 then '' when ansid=263553 then '' when ansid=263554 then '-' when ansid=263555 then '-' when ansid=263488 then '-' when ansid=263489 then '-' when ansid=263490 then '' when ansid=263491 then '' when ansid=263492 then '-' when ansid=263493 then '-' when ansid=263494 then 'NACO' when ansid=263495 then 'Avauter' when ansid=263496 then '3800' when ansid=263497 then '0122' when ansid=263498 then '8\/24' when ansid=263499 then '2-8degree' when ansid=263500 then 'Q.Line' when ansid=263501 then 'Q-Line Bio tech Prv.ltd' when ansid=263502 then '3775' when ansid=263503 then '016' when ansid=263504 then '11\/2024' when ansid=263505 then '2-8 degree' when ansid=263506 then '' when ansid=263507 then '' when ansid=263508 then '' when ansid=263509 then '' when ansid=263510 then '' when ansid=263511 then '' when ansid=263512 then '' when ansid=263513 then '' when ansid=263514 then '' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:51:45'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE supvisstepid = '13729'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-13 21:51:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:51:45' WHERE visitfeedbackid = '13700'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then 'CoombAids' when ansid=263477 then 'ARKRAY- Prv.ltd' when ansid=263478 then '3792' when ansid=263479 then '27670' when ansid=263480 then '10\/9\/24' when ansid=263481 then '2-8 degree' when ansid=263482 then 'Standard' when ansid=263483 then 'ARKRAY PVT.LTD' when ansid=263484 then '50' when ansid=263485 then '57088' when ansid=263486 then '8\/24' when ansid=263487 then '2-8 degree' when ansid=263550 then 'Not available, procurement under process' when ansid=263551 then '-' when ansid=263552 then '0' when ansid=263553 then '0' when ansid=263554 then '-' when ansid=263555 then '-' when ansid=263488 then '-' when ansid=263489 then '-' when ansid=263490 then '0' when ansid=263491 then '0' when ansid=263492 then '-' when ansid=263493 then '-' when ansid=263494 then 'NACO' when ansid=263495 then 'Avauter' when ansid=263496 then '3800' when ansid=263497 then '0122' when ansid=263498 then '8\/24' when ansid=263499 then '2-8degree' when ansid=263500 then 'Q.Line' when ansid=263501 then 'Q-Line Bio tech Prv.ltd' when ansid=263502 then '3775' when ansid=263503 then '016' when ansid=263504 then '11\/2024' when ansid=263505 then '2-8 degree' when ansid=263506 then '' when ansid=263507 then '' when ansid=263508 then '' when ansid=263509 then '' when ansid=263510 then '' when ansid=263511 then '' when ansid=263512 then '' when ansid=263513 then '' when ansid=263514 then '' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:53:13'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE supvisstepid = '13730'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-13 21:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:53:13' WHERE visitfeedbackid = '13700'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then 'CoombAids' when ansid=263477 then 'ARKRAY- Prv.ltd' when ansid=263478 then '3792' when ansid=263479 then '27670' when ansid=263480 then '10\/9\/24' when ansid=263481 then '2-8 degree' when ansid=263482 then 'Standard' when ansid=263483 then 'ARKRAY PVT.LTD' when ansid=263484 then '50' when ansid=263485 then '57088' when ansid=263486 then '8\/24' when ansid=263487 then '2-8 degree' when ansid=263550 then 'Not available, procurement under process' when ansid=263551 then '-' when ansid=263552 then '0' when ansid=263553 then '0' when ansid=263554 then '-' when ansid=263555 then '-' when ansid=263488 then '-' when ansid=263489 then '-' when ansid=263490 then '0' when ansid=263491 then '0' when ansid=263492 then '-' when ansid=263493 then '-' when ansid=263494 then 'NACO' when ansid=263495 then 'Avauter' when ansid=263496 then '3800' when ansid=263497 then '0122' when ansid=263498 then '8\/24' when ansid=263499 then '2-8degree' when ansid=263500 then 'Q.Line' when ansid=263501 then 'Q-Line Bio tech Prv.ltd' when ansid=263502 then '3775' when ansid=263503 then '016' when ansid=263504 then '11\/2024' when ansid=263505 then '2-8 degree' when ansid=263506 then '' when ansid=263507 then '1' when ansid=263508 then '1' when ansid=263509 then '1' when ansid=263510 then '1' when ansid=263511 then '1' when ansid=263512 then '1' when ansid=263513 then '1' when ansid=263514 then 'No comment' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:54:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE supvisstepid = '13731'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-13 21:54:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:54:33' WHERE visitfeedbackid = '13700'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then 'CoombAids' when ansid=263477 then 'ARKRAY- Prv.ltd' when ansid=263478 then '3792' when ansid=263479 then '27670' when ansid=263480 then '10\/9\/24' when ansid=263481 then '2-8 degree' when ansid=263482 then 'Standard' when ansid=263483 then 'ARKRAY PVT.LTD' when ansid=263484 then '50' when ansid=263485 then '57088' when ansid=263486 then '8\/24' when ansid=263487 then '2-8 degree' when ansid=263550 then 'Not available, procurement under process' when ansid=263551 then '-' when ansid=263552 then '0' when ansid=263553 then '0' when ansid=263554 then '-' when ansid=263555 then '-' when ansid=263488 then '-' when ansid=263489 then '-' when ansid=263490 then '0' when ansid=263491 then '0' when ansid=263492 then '-' when ansid=263493 then '-' when ansid=263494 then 'NACO' when ansid=263495 then 'Avauter' when ansid=263496 then '3800' when ansid=263497 then '0122' when ansid=263498 then '8\/24' when ansid=263499 then '2-8degree' when ansid=263500 then 'Q.Line' when ansid=263501 then 'Q-Line Bio tech Prv.ltd' when ansid=263502 then '3775' when ansid=263503 then '016' when ansid=263504 then '11\/2024' when ansid=263505 then '2-8 degree' when ansid=263506 then '' when ansid=263507 then '1' when ansid=263508 then '1' when ansid=263509 then '1' when ansid=263510 then '1' when ansid=263511 then '1' when ansid=263512 then '1' when ansid=263513 then '1' when ansid=263514 then 'No comment' when ansid=263515 then '7\/1\/2023' when ansid=263516 then '9\/2\/2023' when ansid=263517 then '1600' when ansid=263518 then '177' when ansid=263519 then '0' when ansid=263520 then '0' when ansid=263521 then '0' when ansid=263522 then '0' when ansid=263523 then '0' when ansid=263524 then '0' when ansid=263525 then '0' when ansid=263526 then '0' when ansid=263527 then '0' when ansid=263528 then '0' when ansid=263529 then '0' when ansid=263530 then '0' when ansid=263531 then '0' when ansid=263532 then '0' when ansid=263533 then '0' when ansid=263534 then '0' when ansid=263535 then '1' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.241',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-13 21:58:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE supvisstepid = '13732'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-13 21:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.241', `modifiedby` = '647', `modifieddate` = '2023-02-13 21:58:28' WHERE visitfeedbackid = '13700'"}