{"userId":"87","date":"2021-04-02 11:26:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('87', '27.62.144.226', '2021-04-02 11:26:10')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1774', '2578', '87', '2021-04-02', '1', '27.62.144.226', '87', '2021-04-02 11:27:26', '', '')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2279', '0', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2279', '1', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2279', '2', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2279', '3', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2279', '', '', 'Array', '', 'Array', '', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2279', '', '', 'Array', '', 'Array', '', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2279', '', '', 'Array', '', 'Array', '', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2279', '', '', 'Array', '', 'Array', '', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:27:26","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2279', '27.62.144.226', '87', '2021-04-02 11:27:26')"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE sitesupervision SET `siteid` = '1774', `userid` = '87', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '145', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '2100', `undertrialprisoners` = '1100' WHERE ssid = '2279'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shradha Das', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE onssid = '9444'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE onsitestaffs SET `staffname` = 'Vinod Maravi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE onssid = '9445'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE onsitestaffs SET `staffname` = 'Majid Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE onssid = '9446'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE onssid = '9447'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212118 then '' when ansid=212120 then '' when ansid=212122 then '' when ansid=212124 then '' when ansid=212126 then '' when ansid=212128 then '' when ansid=212129 then ''  when ansid=212130 then ''   when ansid=212131 then ''   when ansid=212132 then ''   when ansid=212133 then ''   when ansid=212134 then ''   when ansid=212135 then ''  when ansid=212136 then '' when ansid=212137 then ''  when ansid=212138 then ''   when ansid=212139 then ''   when ansid=212140 then ''   when ansid=212141 then ''  when ansid=212142 then ''  when ansid=212143 then ''   when ansid=212144 then ''  when ansid=212145 then '' when ansid=212146 then '' when ansid=212147 then '' when ansid=212148 then '' when ansid=212149 then '' when ansid=212150 then '' when ansid=212151 then '' when ansid=212152 then '' when ansid=212153 then '' when ansid=212154 then '' when ansid=212155 then '' when ansid=212156 then ''  when ansid=212157 then ''   when ansid=212158 then ''  when ansid=212159 then '' when ansid=212160 then '' when ansid=212161 then '' when ansid=212162 then '' when ansid=212163 then '' when ansid=212164 then '' when ansid=212165 then '' when ansid=212166 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.144.226',\n\t\t\t\t\t\t\t\tmodifiedby =87,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 11:30:51'\n\t\t\t\t\t\t\tWHERE ansid in ('212118','212120','212122','212124','212126','212128','212129','212130','212131','212132','212133','212134','212135','212136','212137','212138','212139','212140','212141','212142','212143','212144','212145','212146','212147','212148','212149','212150','212151','212152','212153','212154','212155','212156','212157','212158','212159','212160','212161','212162','212163','212164','212165','212166')"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE supvisstepid = '11344'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE visitfeedbackid = '11171'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE visitfeedbackid = '11172'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE visitfeedbackid = '11173'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE visitfeedbackid = '11174'"}
{"userId":"87","date":"2021-04-02 11:30:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:30:51' WHERE visitfeedbackid = '11175'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE sitesupervision SET `siteid` = '1774', `userid` = '87', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '145', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '2100', `undertrialprisoners` = '1100' WHERE ssid = '2279'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shradha Das', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE onssid = '9444'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE onsitestaffs SET `staffname` = 'Vinod Maravi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE onssid = '9445'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE onsitestaffs SET `staffname` = 'Majid Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE onssid = '9446'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE onssid = '9447'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212118 then '1' when ansid=212120 then '1' when ansid=212122 then '1' when ansid=212124 then '3' when ansid=212126 then '1' when ansid=212128 then '' when ansid=212129 then ''  when ansid=212130 then ''   when ansid=212131 then ''   when ansid=212132 then ''   when ansid=212133 then ''   when ansid=212134 then ''   when ansid=212135 then ''  when ansid=212136 then '' when ansid=212137 then ''  when ansid=212138 then ''   when ansid=212139 then ''   when ansid=212140 then ''   when ansid=212141 then ''  when ansid=212142 then ''  when ansid=212143 then ''   when ansid=212144 then ''  when ansid=212145 then '' when ansid=212146 then '' when ansid=212147 then '' when ansid=212148 then '' when ansid=212149 then '' when ansid=212150 then '' when ansid=212151 then '' when ansid=212152 then '' when ansid=212153 then '' when ansid=212154 then '' when ansid=212155 then '' when ansid=212156 then ''  when ansid=212157 then ''   when ansid=212158 then ''  when ansid=212159 then '' when ansid=212160 then '' when ansid=212161 then '' when ansid=212162 then '' when ansid=212163 then '' when ansid=212164 then '' when ansid=212165 then '' when ansid=212166 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.144.226',\n\t\t\t\t\t\t\t\tmodifiedby =87,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 11:31:42'\n\t\t\t\t\t\t\tWHERE ansid in ('212118','212120','212122','212124','212126','212128','212129','212130','212131','212132','212133','212134','212135','212136','212137','212138','212139','212140','212141','212142','212143','212144','212145','212146','212147','212148','212149','212150','212151','212152','212153','212154','212155','212156','212157','212158','212159','212160','212161','212162','212163','212164','212165','212166')"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE supvisstepid = '11345'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE visitfeedbackid = '11171'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE visitfeedbackid = '11172'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE visitfeedbackid = '11173'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE visitfeedbackid = '11174'"}
{"userId":"87","date":"2021-04-02 11:31:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:31:42' WHERE visitfeedbackid = '11175'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE sitesupervision SET `siteid` = '1774', `userid` = '87', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '145', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '2100', `undertrialprisoners` = '1100' WHERE ssid = '2279'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shradha Das', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE onssid = '9444'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE onsitestaffs SET `staffname` = 'Vinod Maravi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE onssid = '9445'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE onsitestaffs SET `staffname` = 'Majid Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE onssid = '9446'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE onssid = '9447'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212118 then '1' when ansid=212120 then '1' when ansid=212122 then '1' when ansid=212124 then '3' when ansid=212126 then '1' when ansid=212128 then '9' when ansid=212129 then '9'  when ansid=212130 then ''   when ansid=212131 then '1'   when ansid=212132 then ''   when ansid=212133 then '1'   when ansid=212134 then ''   when ansid=212135 then '1'  when ansid=212136 then '15' when ansid=212137 then '2'  when ansid=212138 then 'Counselor'   when ansid=212139 then '2'   when ansid=212140 then ''   when ansid=212141 then '1'  when ansid=212142 then '1'  when ansid=212143 then ''   when ansid=212144 then '1'  when ansid=212145 then '1' when ansid=212146 then '1' when ansid=212147 then '1' when ansid=212148 then '1' when ansid=212149 then '4' when ansid=212150 then '1' when ansid=212151 then '1' when ansid=212152 then '1' when ansid=212153 then '3' when ansid=212154 then '1' when ansid=212155 then '1' when ansid=212156 then '1'  when ansid=212157 then ''   when ansid=212158 then '1'  when ansid=212159 then '1' when ansid=212160 then '1' when ansid=212161 then '2' when ansid=212162 then '1' when ansid=212163 then '0' when ansid=212164 then 'Not any specific problem regarding transportation of samples . because Central Jail is near Medical College. Not any issue regarding the supplies and materials required for surveillance.' when ansid=212165 then 'no .' when ansid=212166 then 'at least one visit also required.' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.144.226',\n\t\t\t\t\t\t\t\tmodifiedby =87,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 11:39:08'\n\t\t\t\t\t\t\tWHERE ansid in ('212118','212120','212122','212124','212126','212128','212129','212130','212131','212132','212133','212134','212135','212136','212137','212138','212139','212140','212141','212142','212143','212144','212145','212146','212147','212148','212149','212150','212151','212152','212153','212154','212155','212156','212157','212158','212159','212160','212161','212162','212163','212164','212165','212166')"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE supvisstepid = '11346'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE visitfeedbackid = '11171'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE visitfeedbackid = '11172'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE visitfeedbackid = '11173'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE visitfeedbackid = '11174'"}
{"userId":"87","date":"2021-04-02 11:39:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:08' WHERE visitfeedbackid = '11175'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE sitesupervision SET `siteid` = '1774', `userid` = '87', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '145', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '2100', `undertrialprisoners` = '1100', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2279'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shradha Das', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE onssid = '9444'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE onsitestaffs SET `staffname` = 'Vinod Maravi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE onssid = '9445'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE onsitestaffs SET `staffname` = 'Majid Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE onssid = '9446'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE onssid = '9447'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212118 then '1' when ansid=212120 then '1' when ansid=212122 then '1' when ansid=212124 then '3' when ansid=212126 then '1' when ansid=212128 then '9' when ansid=212129 then '9'  when ansid=212130 then ''   when ansid=212131 then '1'   when ansid=212132 then ''   when ansid=212133 then '1'   when ansid=212134 then ''   when ansid=212135 then '1'  when ansid=212136 then '15' when ansid=212137 then '2'  when ansid=212138 then 'Counselor'   when ansid=212139 then '2'   when ansid=212140 then ''   when ansid=212141 then '1'  when ansid=212142 then '1'  when ansid=212143 then ''   when ansid=212144 then '1'  when ansid=212145 then '1' when ansid=212146 then '1' when ansid=212147 then '1' when ansid=212148 then '1' when ansid=212149 then '4' when ansid=212150 then '1' when ansid=212151 then '1' when ansid=212152 then '1' when ansid=212153 then '3' when ansid=212154 then '1' when ansid=212155 then '1' when ansid=212156 then '1'  when ansid=212157 then ''   when ansid=212158 then '1'  when ansid=212159 then '1' when ansid=212160 then '1' when ansid=212161 then '2' when ansid=212162 then '1' when ansid=212163 then '0' when ansid=212164 then 'Not any specific problem regarding transportation of samples . because Central Jail is near Medical College. Not any issue regarding the supplies and materials required for surveillance.' when ansid=212165 then 'no .' when ansid=212166 then 'at least one visit also required.' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.144.226',\n\t\t\t\t\t\t\t\tmodifiedby =87,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 11:39:18'\n\t\t\t\t\t\t\tWHERE ansid in ('212118','212120','212122','212124','212126','212128','212129','212130','212131','212132','212133','212134','212135','212136','212137','212138','212139','212140','212141','212142','212143','212144','212145','212146','212147','212148','212149','212150','212151','212152','212153','212154','212155','212156','212157','212158','212159','212160','212161','212162','212163','212164','212165','212166')"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE supvisstepid = '11347'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE visitfeedbackid = '11171'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE visitfeedbackid = '11172'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE visitfeedbackid = '11173'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE visitfeedbackid = '11174'"}
{"userId":"87","date":"2021-04-02 11:39:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.144.226', `modifiedby` = '87', `modifieddate` = '2021-04-02 11:39:18' WHERE visitfeedbackid = '11175'"}
{"userId":"435","date":"2021-04-02 11:53:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('435', '49.36.141.144', '2021-04-02 11:53:14')"}
{"userId":"310","date":"2021-04-02 16:09:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '152.57.38.89', '2021-04-02 16:09:12')"}
{"userId":"310","date":"2021-04-02 16:10:48","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1254', '2021-03-22', '310', '152.57.38.89', '310', '2021-04-02 16:10:48')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1254', '2691', '310', '2021-04-02', '1', '152.57.38.89', '310', '2021-04-02 16:10:55', '', '')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2280', '0', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2280', '1', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2280', '2', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2280', '3', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2280', '', '', 'Array', '', 'Array', '', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2280', '', '', 'Array', '', 'Array', '', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2280', '', '', 'Array', '', 'Array', '', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2280', '', '', 'Array', '', 'Array', '', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:10:55","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2280', '152.57.38.89', '310', '2021-04-02 16:10:55')"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '28', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '' when ansid=212175 then '' when ansid=212176 then '' when ansid=212177 then '' when ansid=212178 then '' when ansid=212179 then '' when ansid=212180 then '' when ansid=212181 then '' when ansid=212182 then '' when ansid=212183 then '' when ansid=212184 then '' when ansid=212185 then '' when ansid=212186 then ''  when ansid=212187 then ''   when ansid=212188 then ''   when ansid=212189 then ''   when ansid=212190 then ''   when ansid=212191 then ''   when ansid=212192 then ''   when ansid=212193 then ''   when ansid=212194 then ''   when ansid=212195 then ''   when ansid=212196 then ''  when ansid=212197 then '' when ansid=212198 then '' when ansid=212199 then ''  when ansid=212200 then ''   when ansid=212201 then ''   when ansid=212202 then ''   when ansid=212203 then ''   when ansid=212204 then ''   when ansid=212205 then ''   when ansid=212206 then ''   when ansid=212207 then ''   when ansid=212208 then ''   when ansid=212209 then ''   when ansid=212210 then ''   when ansid=212211 then ''   when ansid=212212 then ''   when ansid=212213 then ''  when ansid=212214 then '' when ansid=212215 then '' when ansid=212216 then '' when ansid=212217 then '' when ansid=212218 then '' when ansid=212219 then '' when ansid=212220 then '' when ansid=212221 then '' when ansid=212222 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.38.89',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:17:20'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE supvisstepid = '11348'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:17:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:17:20' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '28', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '' when ansid=212184 then '' when ansid=212185 then '' when ansid=212186 then ''  when ansid=212187 then ''   when ansid=212188 then ''   when ansid=212189 then ''   when ansid=212190 then ''   when ansid=212191 then ''   when ansid=212192 then ''   when ansid=212193 then ''   when ansid=212194 then ''   when ansid=212195 then ''   when ansid=212196 then ''  when ansid=212197 then '' when ansid=212198 then '' when ansid=212199 then ''  when ansid=212200 then ''   when ansid=212201 then ''   when ansid=212202 then ''   when ansid=212203 then ''   when ansid=212204 then ''   when ansid=212205 then ''   when ansid=212206 then ''   when ansid=212207 then ''   when ansid=212208 then ''   when ansid=212209 then ''   when ansid=212210 then ''   when ansid=212211 then ''   when ansid=212212 then ''   when ansid=212213 then ''  when ansid=212214 then '' when ansid=212215 then '' when ansid=212216 then '' when ansid=212217 then '' when ansid=212218 then '' when ansid=212219 then '' when ansid=212220 then '' when ansid=212221 then '' when ansid=212222 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.38.89',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:18:45'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE supvisstepid = '11349'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:18:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:18:45' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '' when ansid=212184 then '' when ansid=212185 then '' when ansid=212186 then ''  when ansid=212187 then ''   when ansid=212188 then ''   when ansid=212189 then ''   when ansid=212190 then ''   when ansid=212191 then ''   when ansid=212192 then ''   when ansid=212193 then ''   when ansid=212194 then ''   when ansid=212195 then ''   when ansid=212196 then ''  when ansid=212197 then '' when ansid=212198 then '' when ansid=212199 then ''  when ansid=212200 then ''   when ansid=212201 then ''   when ansid=212202 then ''   when ansid=212203 then ''   when ansid=212204 then ''   when ansid=212205 then ''   when ansid=212206 then ''   when ansid=212207 then ''   when ansid=212208 then ''   when ansid=212209 then ''   when ansid=212210 then ''   when ansid=212211 then ''   when ansid=212212 then ''   when ansid=212213 then ''  when ansid=212214 then '' when ansid=212215 then '' when ansid=212216 then '' when ansid=212217 then '' when ansid=212218 then '' when ansid=212219 then '' when ansid=212220 then '' when ansid=212221 then '' when ansid=212222 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.38.89',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:20:48'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE supvisstepid = '11348'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:20:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:48' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '' when ansid=212184 then '' when ansid=212185 then '' when ansid=212186 then ''  when ansid=212187 then ''   when ansid=212188 then ''   when ansid=212189 then ''   when ansid=212190 then ''   when ansid=212191 then ''   when ansid=212192 then ''   when ansid=212193 then ''   when ansid=212194 then ''   when ansid=212195 then ''   when ansid=212196 then ''  when ansid=212197 then '' when ansid=212198 then '' when ansid=212199 then ''  when ansid=212200 then ''   when ansid=212201 then ''   when ansid=212202 then ''   when ansid=212203 then ''   when ansid=212204 then ''   when ansid=212205 then ''   when ansid=212206 then ''   when ansid=212207 then ''   when ansid=212208 then ''   when ansid=212209 then ''   when ansid=212210 then ''   when ansid=212211 then ''   when ansid=212212 then ''   when ansid=212213 then ''  when ansid=212214 then '' when ansid=212215 then '' when ansid=212216 then '' when ansid=212217 then '' when ansid=212218 then '' when ansid=212219 then '' when ansid=212220 then '' when ansid=212221 then '' when ansid=212222 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.38.89',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:20:56'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE supvisstepid = '11349'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:20:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.38.89', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:20:56' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '30' when ansid=212184 then '2' when ansid=212185 then '5' when ansid=212186 then '1'  when ansid=212187 then ''   when ansid=212188 then '1'   when ansid=212189 then ''   when ansid=212190 then '1'   when ansid=212191 then ''   when ansid=212192 then '1'   when ansid=212193 then ''   when ansid=212194 then '1'   when ansid=212195 then ''   when ansid=212196 then '1'  when ansid=212197 then '1' when ansid=212198 then '1' when ansid=212199 then '1'  when ansid=212200 then ''   when ansid=212201 then '1'   when ansid=212202 then ''   when ansid=212203 then '1'   when ansid=212204 then ''   when ansid=212205 then '1'   when ansid=212206 then ''   when ansid=212207 then '1'   when ansid=212208 then ''   when ansid=212209 then '1'   when ansid=212210 then 'Not yet sent, will be sending once in 2 weeks'   when ansid=212211 then '4'   when ansid=212212 then ''   when ansid=212213 then '2'  when ansid=212214 then '1' when ansid=212215 then '2' when ansid=212216 then '1' when ansid=212217 then '1' when ansid=212218 then '1' when ansid=212219 then 'No envelopes provided for data forms transportation. Told to purchase.' when ansid=212220 then 'None' when ansid=212221 then 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.PM asked if more than 5 samples could be taken per day. Told to restrict to only 5 samples per day for better quality of samples & data form entries.Otherwise all site personnel doing good work & site functioning well.' when ansid=212222 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.37.153',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:45:58'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE supvisstepid = '11350'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:45:58' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '30' when ansid=212184 then '2' when ansid=212185 then '5' when ansid=212186 then '1'  when ansid=212187 then ''   when ansid=212188 then '1'   when ansid=212189 then ''   when ansid=212190 then '1'   when ansid=212191 then ''   when ansid=212192 then '1'   when ansid=212193 then ''   when ansid=212194 then '1'   when ansid=212195 then ''   when ansid=212196 then '1'  when ansid=212197 then '1' when ansid=212198 then '1' when ansid=212199 then '1'  when ansid=212200 then ''   when ansid=212201 then '1'   when ansid=212202 then ''   when ansid=212203 then '1'   when ansid=212204 then ''   when ansid=212205 then '1'   when ansid=212206 then ''   when ansid=212207 then '1'   when ansid=212208 then ''   when ansid=212209 then '1'   when ansid=212210 then 'Not yet sent, will be sending once in 2 weeks'   when ansid=212211 then '4'   when ansid=212212 then ''   when ansid=212213 then '2'  when ansid=212214 then '1' when ansid=212215 then '2' when ansid=212216 then '1' when ansid=212217 then '1' when ansid=212218 then '1' when ansid=212219 then 'No envelopes provided for data forms transportation. Told to purchase.' when ansid=212220 then 'None' when ansid=212221 then 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.PM asked if more than 5 samples could be taken per day. Told to restrict to only 5 samples per day for better quality of samples & data form entries.Otherwise all site personnel doing good work & site functioning well.' when ansid=212222 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.37.153',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:51:20'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE supvisstepid = '11350'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE visitfeedback SET `feedback` = 'No envelopes provided for data forms transportation.', `recommendation` = 'Told to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Counselor was explained to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counselor to make all corrections.', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:51:20' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '30' when ansid=212184 then '2' when ansid=212185 then '5' when ansid=212186 then '1'  when ansid=212187 then ''   when ansid=212188 then '1'   when ansid=212189 then ''   when ansid=212190 then '1'   when ansid=212191 then ''   when ansid=212192 then '1'   when ansid=212193 then ''   when ansid=212194 then '1'   when ansid=212195 then ''   when ansid=212196 then '1'  when ansid=212197 then '1' when ansid=212198 then '1' when ansid=212199 then '1'  when ansid=212200 then ''   when ansid=212201 then '1'   when ansid=212202 then ''   when ansid=212203 then '1'   when ansid=212204 then ''   when ansid=212205 then '1'   when ansid=212206 then ''   when ansid=212207 then '1'   when ansid=212208 then ''   when ansid=212209 then '1'   when ansid=212210 then 'Not yet sent, will be sending once in 2 weeks'   when ansid=212211 then '4'   when ansid=212212 then ''   when ansid=212213 then '2'  when ansid=212214 then '1' when ansid=212215 then '2' when ansid=212216 then '1' when ansid=212217 then '1' when ansid=212218 then '1' when ansid=212219 then 'No envelopes provided for data forms transportation. Told to purchase.' when ansid=212220 then 'None' when ansid=212221 then 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.PM asked if more than 5 samples could be taken per day. Told to restrict to only 5 samples per day for better quality of samples & data form entries.Otherwise all site personnel doing good work & site functioning well.' when ansid=212222 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.37.153',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:52:53'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE supvisstepid = '11350'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE visitfeedback SET `feedback` = 'No envelopes provided for data forms transportation.', `recommendation` = 'Told to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Counselor was explained to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counselor to make all corrections.', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE visitfeedback SET `feedback` = 'PM asked if more than 5 samples could be taken per day.', `recommendation` = 'Told to restrict to only 5 samples per day for better quality of samples & data form entries.', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.37.153', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:52:53' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '30' when ansid=212184 then '2' when ansid=212185 then '5' when ansid=212186 then '1'  when ansid=212187 then ''   when ansid=212188 then '1'   when ansid=212189 then ''   when ansid=212190 then '1'   when ansid=212191 then ''   when ansid=212192 then '1'   when ansid=212193 then ''   when ansid=212194 then '1'   when ansid=212195 then ''   when ansid=212196 then '1'  when ansid=212197 then '1' when ansid=212198 then '1' when ansid=212199 then '1'  when ansid=212200 then ''   when ansid=212201 then '1'   when ansid=212202 then ''   when ansid=212203 then '1'   when ansid=212204 then ''   when ansid=212205 then '1'   when ansid=212206 then ''   when ansid=212207 then '1'   when ansid=212208 then ''   when ansid=212209 then '1'   when ansid=212210 then 'Not yet sent, will be sending once in 2 weeks'   when ansid=212211 then '4'   when ansid=212212 then ''   when ansid=212213 then '2'  when ansid=212214 then '1' when ansid=212215 then '2' when ansid=212216 then '1' when ansid=212217 then '1' when ansid=212218 then '1' when ansid=212219 then 'No envelopes provided for data forms transportation. Told to purchase.' when ansid=212220 then 'None' when ansid=212221 then 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.PM asked if more than 5 samples could be taken per day. Told to restrict to only 5 samples per day for better quality of samples & data form entries.Otherwise all site personnel doing good work & site functioning well.' when ansid=212222 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.52.230',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:55:35'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE supvisstepid = '11350'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE visitfeedback SET `feedback` = 'No envelopes provided for data forms transportation.', `recommendation` = 'Told to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Counselor was explained to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counselor to make all corrections.', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE visitfeedback SET `feedback` = 'PM asked if more than 5 samples could be taken per day.', `recommendation` = 'Told to restrict to only 5 samples per day for better quality of samples & data form entries.', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:55:35","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work & site functioning well.', `recommendation` = '', `ipaddress` = '152.57.52.230', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:55:35' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE sitesupervision SET `siteid` = '1254', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '30', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2280'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Ramdas Ovhal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'PM of Gaurabai AMS Unit 2', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE onssid = '9448'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rasika Gavde', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE onssid = '9449'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Yogita Koval', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE onssid = '9450'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE onssid = '9451'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212167 then '2' when ansid=212168 then '1' when ansid=212169 then '3' when ansid=212170 then '0' when ansid=212171 then '0' when ansid=212172 then '2' when ansid=212173 then '2' when ansid=212174 then '1' when ansid=212175 then '1' when ansid=212176 then '1' when ansid=212177 then '1' when ansid=212178 then '1' when ansid=212179 then '1' when ansid=212180 then '1' when ansid=212181 then '1' when ansid=212182 then '1' when ansid=212183 then '30' when ansid=212184 then '2' when ansid=212185 then '5' when ansid=212186 then '1'  when ansid=212187 then ''   when ansid=212188 then '1'   when ansid=212189 then ''   when ansid=212190 then '1'   when ansid=212191 then ''   when ansid=212192 then '1'   when ansid=212193 then ''   when ansid=212194 then '1'   when ansid=212195 then ''   when ansid=212196 then '1'  when ansid=212197 then '1' when ansid=212198 then '1' when ansid=212199 then '1'  when ansid=212200 then ''   when ansid=212201 then '1'   when ansid=212202 then ''   when ansid=212203 then '1'   when ansid=212204 then ''   when ansid=212205 then '1'   when ansid=212206 then ''   when ansid=212207 then '1'   when ansid=212208 then ''   when ansid=212209 then '1'   when ansid=212210 then 'Not yet sent, will be sending once in 2 weeks'   when ansid=212211 then '4'   when ansid=212212 then ''   when ansid=212213 then '2'  when ansid=212214 then '1' when ansid=212215 then '2' when ansid=212216 then '1' when ansid=212217 then '1' when ansid=212218 then '1' when ansid=212219 then 'No envelopes provided for data forms transportation. Told to purchase.' when ansid=212220 then 'None' when ansid=212221 then 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.PM asked if more than 5 samples could be taken per day. Told to restrict to only 5 samples per day for better quality of samples & data form entries.Otherwise all site personnel doing good work & site functioning well.' when ansid=212222 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.46.236',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 16:58:19'\n\t\t\t\t\t\t\tWHERE ansid in ('212167','212168','212169','212170','212171','212172','212173','212174','212175','212176','212177','212178','212179','212180','212181','212182','212183','212184','212185','212186','212187','212188','212189','212190','212191','212192','212193','212194','212195','212196','212197','212198','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222')"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE supvisstepid = '11351'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE visitfeedback SET `feedback` = 'No envelopes provided for data forms transportation.', `recommendation` = 'Told to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE visitfeedbackid = '11176'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Counselor was explained to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counselor to make all corrections.', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE visitfeedbackid = '11177'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE visitfeedback SET `feedback` = 'Some corrections were needed in certain questions in the data forms.', `recommendation` = 'Told counselor to make some corrections in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE visitfeedbackid = '11178'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE visitfeedback SET `feedback` = 'PM asked if more than 5 samples could be taken per day.', `recommendation` = 'Told PM to restrict to only 5 samples per day for better quality of samples & data form entries.', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE visitfeedbackid = '11179'"}
{"userId":"310","date":"2021-04-02 16:58:19","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work & site functioning well.', `recommendation` = '', `ipaddress` = '152.57.46.236', `modifiedby` = '310', `modifieddate` = '2021-04-02 16:58:19' WHERE visitfeedbackid = '11180'"}
{"userId":"310","date":"2021-04-02 17:07:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '152.57.51.207', '2021-04-02 17:07:46')"}
{"userId":"310","date":"2021-04-02 17:08:56","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1250', '2021-03-24', '310', '152.57.41.60', '310', '2021-04-02 17:08:56')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1250', '2692', '310', '2021-04-02', '1', '152.57.44.17', '310', '2021-04-02 17:09:10', '', '')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2281', '0', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2281', '1', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2281', '2', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2281', '3', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2281', '', '', 'Array', '', 'Array', '', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2281', '', '', 'Array', '', 'Array', '', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2281', '', '', 'Array', '', 'Array', '', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2281', '', '', 'Array', '', 'Array', '', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:09:10","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2281', '152.57.44.17', '310', '2021-04-02 17:09:10')"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '' when ansid=212231 then '' when ansid=212232 then '' when ansid=212233 then '' when ansid=212234 then '' when ansid=212235 then '' when ansid=212236 then '' when ansid=212237 then '' when ansid=212238 then '' when ansid=212239 then '' when ansid=212240 then '' when ansid=212241 then '' when ansid=212242 then ''  when ansid=212243 then ''   when ansid=212244 then ''   when ansid=212245 then ''   when ansid=212246 then ''   when ansid=212247 then ''   when ansid=212248 then ''   when ansid=212249 then ''   when ansid=212250 then ''   when ansid=212251 then ''   when ansid=212252 then ''  when ansid=212253 then '' when ansid=212254 then '' when ansid=212255 then ''  when ansid=212256 then ''   when ansid=212257 then ''   when ansid=212258 then ''   when ansid=212259 then ''   when ansid=212260 then ''   when ansid=212261 then ''   when ansid=212262 then ''   when ansid=212263 then ''   when ansid=212264 then ''   when ansid=212265 then ''   when ansid=212266 then ''   when ansid=212267 then ''   when ansid=212268 then ''   when ansid=212269 then ''  when ansid=212270 then '' when ansid=212271 then '' when ansid=212272 then '' when ansid=212273 then '' when ansid=212274 then '' when ansid=212275 then '' when ansid=212276 then '' when ansid=212277 then '' when ansid=212278 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.33.11',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 17:16:46'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE supvisstepid = '11352'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 17:16:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:16:46' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '1' when ansid=212231 then '1' when ansid=212232 then '1' when ansid=212233 then '1' when ansid=212234 then '1' when ansid=212235 then '1' when ansid=212236 then '1' when ansid=212237 then '1' when ansid=212238 then '1' when ansid=212239 then '' when ansid=212240 then '' when ansid=212241 then '' when ansid=212242 then ''  when ansid=212243 then ''   when ansid=212244 then ''   when ansid=212245 then ''   when ansid=212246 then ''   when ansid=212247 then ''   when ansid=212248 then ''   when ansid=212249 then ''   when ansid=212250 then ''   when ansid=212251 then ''   when ansid=212252 then ''  when ansid=212253 then '' when ansid=212254 then '' when ansid=212255 then ''  when ansid=212256 then ''   when ansid=212257 then ''   when ansid=212258 then ''   when ansid=212259 then ''   when ansid=212260 then ''   when ansid=212261 then ''   when ansid=212262 then ''   when ansid=212263 then ''   when ansid=212264 then ''   when ansid=212265 then ''   when ansid=212266 then ''   when ansid=212267 then ''   when ansid=212268 then ''   when ansid=212269 then ''  when ansid=212270 then '' when ansid=212271 then '' when ansid=212272 then '' when ansid=212273 then '' when ansid=212274 then '' when ansid=212275 then '' when ansid=212276 then '' when ansid=212277 then '' when ansid=212278 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.33.11',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 17:17:39'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE supvisstepid = '11353'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 17:17:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.33.11', `modifiedby` = '310', `modifieddate` = '2021-04-02 17:17:39' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 18:50:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '152.57.40.106', '2021-04-02 18:50:08')"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '1' when ansid=212231 then '1' when ansid=212232 then '1' when ansid=212233 then '1' when ansid=212234 then '1' when ansid=212235 then '1' when ansid=212236 then '1' when ansid=212237 then '1' when ansid=212238 then '1' when ansid=212239 then '46' when ansid=212240 then '1' when ansid=212241 then '5' when ansid=212242 then '1'  when ansid=212243 then ''   when ansid=212244 then '1'   when ansid=212245 then ''   when ansid=212246 then '1'   when ansid=212247 then ''   when ansid=212248 then '1'   when ansid=212249 then ''   when ansid=212250 then '1'   when ansid=212251 then ''   when ansid=212252 then '1'  when ansid=212253 then '1' when ansid=212254 then '1' when ansid=212255 then '1'  when ansid=212256 then ''   when ansid=212257 then '1'   when ansid=212258 then ''   when ansid=212259 then '1'   when ansid=212260 then ''   when ansid=212261 then '1'   when ansid=212262 then ''   when ansid=212263 then '1'   when ansid=212264 then ''   when ansid=212265 then '1'   when ansid=212266 then ''   when ansid=212267 then '3'   when ansid=212268 then ''   when ansid=212269 then '2'  when ansid=212270 then '1' when ansid=212271 then '2' when ansid=212272 then '1' when ansid=212273 then '1' when ansid=212274 then '1' when ansid=212275 then 'No bio-hazard stickers provided. Flow chart displayed was one from previous years. Told to procure new one from MDACSEnvelopes for data forms transportation not provided. Asked to purchase. Money also not provided.' when ansid=212276 then 'MDACS-PO Smita had visited ,' when ansid=212277 then 'HSS register - Counsellor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Counselor had some queries in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.Otherwise all site personnel doing good work.' when ansid=212278 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 18:52:12'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE supvisstepid = '11352'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE visitfeedback SET `feedback` = 'No bio-hazard stickers provided. Flow chart displayed was one from previous years.  Envelopes for data forms transportation not provided.  Money also not provided.', `recommendation` = 'Told to procure  bio-hazard stickers &  new flow chart  from MDACS. Asked to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Told counselor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE visitfeedback SET `feedback` = 'Counselor had some queries in certain questions in the data forms.', `recommendation` = 'Took onsite training & sorted out the queries. Also emphasized on skip patterns.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work.', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 18:52:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:12' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '1' when ansid=212231 then '1' when ansid=212232 then '1' when ansid=212233 then '1' when ansid=212234 then '1' when ansid=212235 then '1' when ansid=212236 then '1' when ansid=212237 then '1' when ansid=212238 then '1' when ansid=212239 then '46' when ansid=212240 then '1' when ansid=212241 then '5' when ansid=212242 then '1'  when ansid=212243 then ''   when ansid=212244 then '1'   when ansid=212245 then ''   when ansid=212246 then '1'   when ansid=212247 then ''   when ansid=212248 then '1'   when ansid=212249 then ''   when ansid=212250 then '1'   when ansid=212251 then ''   when ansid=212252 then '1'  when ansid=212253 then '1' when ansid=212254 then '1' when ansid=212255 then '1'  when ansid=212256 then ''   when ansid=212257 then '1'   when ansid=212258 then ''   when ansid=212259 then '1'   when ansid=212260 then ''   when ansid=212261 then '1'   when ansid=212262 then ''   when ansid=212263 then '1'   when ansid=212264 then ''   when ansid=212265 then '1'   when ansid=212266 then ''   when ansid=212267 then '3'   when ansid=212268 then ''   when ansid=212269 then '2'  when ansid=212270 then '1' when ansid=212271 then '2' when ansid=212272 then '1' when ansid=212273 then '1' when ansid=212274 then '1' when ansid=212275 then 'No bio-hazard stickers provided. Flow chart displayed was one from previous years. Told to procure new one from MDACSEnvelopes for data forms transportation not provided. Asked to purchase. Money also not provided.' when ansid=212276 then 'MDACS-PO Smita had visited ,' when ansid=212277 then 'HSS register - Counsellor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Counselor had some queries in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.Otherwise all site personnel doing good work.' when ansid=212278 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 18:52:18'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE supvisstepid = '11353'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE visitfeedback SET `feedback` = 'No bio-hazard stickers provided. Flow chart displayed was one from previous years.  Envelopes for data forms transportation not provided.  Money also not provided.', `recommendation` = 'Told to procure  bio-hazard stickers &  new flow chart  from MDACS. Asked to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Told counselor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE visitfeedback SET `feedback` = 'Counselor had some queries in certain questions in the data forms.', `recommendation` = 'Took onsite training & sorted out the queries. Also emphasized on skip patterns.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work.', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 18:52:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:18' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '1' when ansid=212231 then '1' when ansid=212232 then '1' when ansid=212233 then '1' when ansid=212234 then '1' when ansid=212235 then '1' when ansid=212236 then '1' when ansid=212237 then '1' when ansid=212238 then '1' when ansid=212239 then '46' when ansid=212240 then '1' when ansid=212241 then '5' when ansid=212242 then '1'  when ansid=212243 then ''   when ansid=212244 then '1'   when ansid=212245 then ''   when ansid=212246 then '1'   when ansid=212247 then ''   when ansid=212248 then '1'   when ansid=212249 then ''   when ansid=212250 then '1'   when ansid=212251 then ''   when ansid=212252 then '1'  when ansid=212253 then '1' when ansid=212254 then '1' when ansid=212255 then '1'  when ansid=212256 then ''   when ansid=212257 then '1'   when ansid=212258 then ''   when ansid=212259 then '1'   when ansid=212260 then ''   when ansid=212261 then '1'   when ansid=212262 then ''   when ansid=212263 then '1'   when ansid=212264 then ''   when ansid=212265 then '1'   when ansid=212266 then ''   when ansid=212267 then '3'   when ansid=212268 then ''   when ansid=212269 then '2'  when ansid=212270 then '1' when ansid=212271 then '2' when ansid=212272 then '1' when ansid=212273 then '1' when ansid=212274 then '1' when ansid=212275 then 'No bio-hazard stickers provided. Flow chart displayed was one from previous years. Told to procure new one from MDACSEnvelopes for data forms transportation not provided. Asked to purchase. Money also not provided.' when ansid=212276 then 'MDACS-PO Smita had visited ,' when ansid=212277 then 'HSS register - Counsellor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Counselor had some queries in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.Otherwise all site personnel doing good work.' when ansid=212278 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 18:52:35'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE supvisstepid = '11354'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE visitfeedback SET `feedback` = 'No bio-hazard stickers provided. Flow chart displayed was one from previous years.  Envelopes for data forms transportation not provided.  Money also not provided.', `recommendation` = 'Told to procure  bio-hazard stickers &  new flow chart  from MDACS. Asked to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Told counselor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE visitfeedback SET `feedback` = 'Counselor had some queries in certain questions in the data forms.', `recommendation` = 'Took onsite training & sorted out the queries. Also emphasized on skip patterns.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work.', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 18:52:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:52:35' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE sitesupervision SET `siteid` = '1250', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-08', `numofsamplecollected` = '46', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2281'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Ujwala Bhavsar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE onssid = '9452'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Komal Choudhari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE onssid = '9453'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sabita Nag', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE onssid = '9454'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE onssid = '9455'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212223 then '2' when ansid=212224 then '1' when ansid=212225 then '3' when ansid=212226 then '0' when ansid=212227 then '0' when ansid=212228 then '2' when ansid=212229 then '2' when ansid=212230 then '1' when ansid=212231 then '1' when ansid=212232 then '1' when ansid=212233 then '1' when ansid=212234 then '1' when ansid=212235 then '1' when ansid=212236 then '1' when ansid=212237 then '1' when ansid=212238 then '1' when ansid=212239 then '46' when ansid=212240 then '1' when ansid=212241 then '5' when ansid=212242 then '1'  when ansid=212243 then ''   when ansid=212244 then '1'   when ansid=212245 then ''   when ansid=212246 then '1'   when ansid=212247 then ''   when ansid=212248 then '1'   when ansid=212249 then ''   when ansid=212250 then '1'   when ansid=212251 then ''   when ansid=212252 then '1'  when ansid=212253 then '1' when ansid=212254 then '1' when ansid=212255 then '1'  when ansid=212256 then ''   when ansid=212257 then '1'   when ansid=212258 then ''   when ansid=212259 then '1'   when ansid=212260 then ''   when ansid=212261 then '1'   when ansid=212262 then ''   when ansid=212263 then '1'   when ansid=212264 then ''   when ansid=212265 then '1'   when ansid=212266 then ''   when ansid=212267 then '3'   when ansid=212268 then ''   when ansid=212269 then '2'  when ansid=212270 then '1' when ansid=212271 then '2' when ansid=212272 then '1' when ansid=212273 then '1' when ansid=212274 then '1' when ansid=212275 then 'No bio-hazard stickers provided. Flow chart displayed was one from previous years. Told to procure new one from MDACSEnvelopes for data forms transportation not provided. Asked to purchase. Money also not provided.' when ansid=212276 then 'MDACS-PO Smita had visited ,' when ansid=212277 then 'HSS register - Counsellor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.. Told counsellor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections. Counselor had some queries in certain questions in the data forms. Took onsite training & sorted out the queries. Also emphasized on skip patterns.Otherwise all site personnel doing good work.' when ansid=212278 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 18:53:08'\n\t\t\t\t\t\t\tWHERE ansid in ('212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278')"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE supvisstepid = '11355'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE visitfeedback SET `feedback` = 'No bio-hazard stickers provided. Flow chart displayed was one from previous years.  Envelopes for data forms transportation not provided.  Money also not provided.', `recommendation` = 'Told to procure  bio-hazard stickers &  new flow chart  from MDACS. Asked to purchase envelopes for data forms transportation.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE visitfeedbackid = '11181'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE visitfeedback SET `feedback` = 'HSS register - Counselor had entered only Random listed candidates who were recruited for HSS on the days of sample collection.', `recommendation` = 'Told counselor to enter all the Random listed KPs nos in the HSS register & write sample no. in front of those recruited on particular days they come & consent to participate in HSS. Told Counsellor to make all corrections.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE visitfeedbackid = '11182'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE visitfeedback SET `feedback` = 'Counselor had some queries in certain questions in the data forms.', `recommendation` = 'Took onsite training & sorted out the queries. Also emphasized on skip patterns.', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE visitfeedbackid = '11183'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE visitfeedback SET `feedback` = 'Otherwise all site personnel doing good work.', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE visitfeedbackid = '11184'"}
{"userId":"310","date":"2021-04-02 18:53:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 18:53:08' WHERE visitfeedbackid = '11185'"}
{"userId":"310","date":"2021-04-02 18:55:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '152.57.40.106', '2021-04-02 18:55:26')"}
{"userId":"310","date":"2021-04-02 19:00:31","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1256', '2021-03-24', '310', '152.57.40.106', '310', '2021-04-02 19:00:31')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1256', '2693', '310', '2021-04-02', '1', '152.57.40.106', '310', '2021-04-02 19:00:43', '', '')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2282', '0', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2282', '1', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2282', '2', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2282', '3', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2282', '', '', 'Array', '', 'Array', '', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2282', '', '', 'Array', '', 'Array', '', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2282', '', '', 'Array', '', 'Array', '', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2282', '', '', 'Array', '', 'Array', '', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:00:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2282', '152.57.40.106', '310', '2021-04-02 19:00:43')"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '' when ansid=212287 then '' when ansid=212288 then '' when ansid=212289 then '' when ansid=212290 then '' when ansid=212291 then '' when ansid=212292 then '' when ansid=212293 then '' when ansid=212294 then '' when ansid=212295 then '' when ansid=212296 then '' when ansid=212297 then '' when ansid=212298 then ''  when ansid=212299 then ''   when ansid=212300 then ''   when ansid=212301 then ''   when ansid=212302 then ''   when ansid=212303 then ''   when ansid=212304 then ''   when ansid=212305 then ''   when ansid=212306 then ''   when ansid=212307 then ''   when ansid=212308 then ''  when ansid=212309 then '' when ansid=212310 then '' when ansid=212311 then ''  when ansid=212312 then ''   when ansid=212313 then ''   when ansid=212314 then ''   when ansid=212315 then ''   when ansid=212316 then ''   when ansid=212317 then ''   when ansid=212318 then ''   when ansid=212319 then ''   when ansid=212320 then ''   when ansid=212321 then ''   when ansid=212322 then ''   when ansid=212323 then ''   when ansid=212324 then ''   when ansid=212325 then ''  when ansid=212326 then '' when ansid=212327 then '' when ansid=212328 then '' when ansid=212329 then '' when ansid=212330 then '' when ansid=212331 then '' when ansid=212332 then '' when ansid=212333 then '' when ansid=212334 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 19:05:12'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE supvisstepid = '11356'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 19:05:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:05:12' WHERE visitfeedbackid = '11190'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '1' when ansid=212287 then '1' when ansid=212288 then '1' when ansid=212289 then '1' when ansid=212290 then '1' when ansid=212291 then '2' when ansid=212292 then '4' when ansid=212293 then '4' when ansid=212294 then '3' when ansid=212295 then '' when ansid=212296 then '' when ansid=212297 then '' when ansid=212298 then ''  when ansid=212299 then ''   when ansid=212300 then ''   when ansid=212301 then ''   when ansid=212302 then ''   when ansid=212303 then ''   when ansid=212304 then ''   when ansid=212305 then ''   when ansid=212306 then ''   when ansid=212307 then ''   when ansid=212308 then ''  when ansid=212309 then '' when ansid=212310 then '' when ansid=212311 then ''  when ansid=212312 then ''   when ansid=212313 then ''   when ansid=212314 then ''   when ansid=212315 then ''   when ansid=212316 then ''   when ansid=212317 then ''   when ansid=212318 then ''   when ansid=212319 then ''   when ansid=212320 then ''   when ansid=212321 then ''   when ansid=212322 then ''   when ansid=212323 then ''   when ansid=212324 then ''   when ansid=212325 then ''  when ansid=212326 then '' when ansid=212327 then '' when ansid=212328 then '' when ansid=212329 then '' when ansid=212330 then '' when ansid=212331 then '' when ansid=212332 then '' when ansid=212333 then '' when ansid=212334 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.40.106',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 19:06:32'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE supvisstepid = '11357'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 19:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.40.106', `modifiedby` = '310', `modifieddate` = '2021-04-02 19:06:32' WHERE visitfeedbackid = '11190'"}
{"userId":"310","date":"2021-04-02 20:36:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '152.57.50.207', '2021-04-02 20:36:35')"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '1' when ansid=212287 then '1' when ansid=212288 then '1' when ansid=212289 then '1' when ansid=212290 then '1' when ansid=212291 then '2' when ansid=212292 then '4' when ansid=212293 then '4' when ansid=212294 then '3' when ansid=212295 then '5' when ansid=212296 then '2' when ansid=212297 then '5' when ansid=212298 then '1'  when ansid=212299 then ''   when ansid=212300 then '1'   when ansid=212301 then ''   when ansid=212302 then '1'   when ansid=212303 then ''   when ansid=212304 then '1'   when ansid=212305 then ''   when ansid=212306 then '1'   when ansid=212307 then ''   when ansid=212308 then '1'  when ansid=212309 then '1' when ansid=212310 then '1' when ansid=212311 then '1'  when ansid=212312 then ''   when ansid=212313 then '1'   when ansid=212314 then ''   when ansid=212315 then '1'   when ansid=212316 then ''   when ansid=212317 then '1'   when ansid=212318 then 'only yellow bags seen, red & black bags not provided'   when ansid=212319 then '2'   when ansid=212320 then 'Site was camp based, packaging done at NGO office, but asked LT who told about packaging process which was as per guidelines'   when ansid=212321 then '3'   when ansid=212322 then 'once in 2 weeks'   when ansid=212323 then '4'   when ansid=212324 then ''   when ansid=212325 then '2'  when ansid=212326 then '1' when ansid=212327 then '2' when ansid=212328 then '1' when ansid=212329 then '1' when ansid=212330 then '1' when ansid=212331 then 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided. Asked to procure from SACS\/RI or purchase' when ansid=212332 then 'None' when ansid=212333 then 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidatesAll site personnel doing excellent work.Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.' when ansid=212334 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.50.207',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 20:37:12'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE supvisstepid = '11356'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE visitfeedback SET `feedback` = 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided.', `recommendation` = 'Asked to procure non available items in feedback 1  from SACS\/RI or purchase.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE visitfeedback SET `feedback` = 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.', `recommendation` = 'Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE visitfeedback SET `feedback` = 'Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidates.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE visitfeedback SET `feedback` = 'All site personnel doing excellent work.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 20:37:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:12' WHERE visitfeedbackid = '11190'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '1' when ansid=212287 then '1' when ansid=212288 then '1' when ansid=212289 then '1' when ansid=212290 then '1' when ansid=212291 then '2' when ansid=212292 then '4' when ansid=212293 then '4' when ansid=212294 then '3' when ansid=212295 then '5' when ansid=212296 then '2' when ansid=212297 then '5' when ansid=212298 then '1'  when ansid=212299 then ''   when ansid=212300 then '1'   when ansid=212301 then ''   when ansid=212302 then '1'   when ansid=212303 then ''   when ansid=212304 then '1'   when ansid=212305 then ''   when ansid=212306 then '1'   when ansid=212307 then ''   when ansid=212308 then '1'  when ansid=212309 then '1' when ansid=212310 then '1' when ansid=212311 then '1'  when ansid=212312 then ''   when ansid=212313 then '1'   when ansid=212314 then ''   when ansid=212315 then '1'   when ansid=212316 then ''   when ansid=212317 then '1'   when ansid=212318 then 'only yellow bags seen, red & black bags not provided'   when ansid=212319 then '2'   when ansid=212320 then 'Site was camp based, packaging done at NGO office, but asked LT who told about packaging process which was as per guidelines'   when ansid=212321 then '3'   when ansid=212322 then 'once in 2 weeks'   when ansid=212323 then '4'   when ansid=212324 then ''   when ansid=212325 then '2'  when ansid=212326 then '1' when ansid=212327 then '2' when ansid=212328 then '1' when ansid=212329 then '1' when ansid=212330 then '1' when ansid=212331 then 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided. Asked to procure from SACS\/RI or purchase' when ansid=212332 then 'None' when ansid=212333 then 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidatesAll site personnel doing excellent work.Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.' when ansid=212334 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.50.207',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 20:37:19'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE supvisstepid = '11357'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE visitfeedback SET `feedback` = 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided.', `recommendation` = 'Asked to procure non available items in feedback 1  from SACS\/RI or purchase.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE visitfeedback SET `feedback` = 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.', `recommendation` = 'Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE visitfeedback SET `feedback` = 'Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidates.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE visitfeedback SET `feedback` = 'All site personnel doing excellent work.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 20:37:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:19' WHERE visitfeedbackid = '11190'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '1' when ansid=212287 then '1' when ansid=212288 then '1' when ansid=212289 then '1' when ansid=212290 then '1' when ansid=212291 then '2' when ansid=212292 then '4' when ansid=212293 then '4' when ansid=212294 then '3' when ansid=212295 then '5' when ansid=212296 then '2' when ansid=212297 then '5' when ansid=212298 then '1'  when ansid=212299 then ''   when ansid=212300 then '1'   when ansid=212301 then ''   when ansid=212302 then '1'   when ansid=212303 then ''   when ansid=212304 then '1'   when ansid=212305 then ''   when ansid=212306 then '1'   when ansid=212307 then ''   when ansid=212308 then '1'  when ansid=212309 then '1' when ansid=212310 then '1' when ansid=212311 then '1'  when ansid=212312 then ''   when ansid=212313 then '1'   when ansid=212314 then ''   when ansid=212315 then '1'   when ansid=212316 then ''   when ansid=212317 then '1'   when ansid=212318 then 'only yellow bags seen, red & black bags not provided'   when ansid=212319 then '2'   when ansid=212320 then 'Site was camp based, packaging done at NGO office, but asked LT who told about packaging process which was as per guidelines'   when ansid=212321 then '3'   when ansid=212322 then 'once in 2 weeks'   when ansid=212323 then '4'   when ansid=212324 then ''   when ansid=212325 then '2'  when ansid=212326 then '1' when ansid=212327 then '2' when ansid=212328 then '1' when ansid=212329 then '1' when ansid=212330 then '1' when ansid=212331 then 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided. Asked to procure from SACS\/RI or purchase' when ansid=212332 then 'None' when ansid=212333 then 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidatesAll site personnel doing excellent work.Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.' when ansid=212334 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.50.207',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 20:37:28'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE supvisstepid = '11358'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE visitfeedback SET `feedback` = 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided.', `recommendation` = 'Asked to procure non available items in feedback 1  from SACS\/RI or purchase.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE visitfeedback SET `feedback` = 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.', `recommendation` = 'Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE visitfeedback SET `feedback` = 'Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidates.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE visitfeedback SET `feedback` = 'All site personnel doing excellent work.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 20:37:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:28' WHERE visitfeedbackid = '11190'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE sitesupervision SET `siteid` = '1256', `userid` = '310', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-05', `numofsamplecollected` = '37', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2282'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Prashant Gaonkar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'PM of RSP (NGO),Dahisar', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE onssid = '9456'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Arpit Yadav', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE onssid = '9457'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Vrushali Naik', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE onssid = '9458'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE onssid = '9459'"}
{"userId":"310","date":"2021-04-02 20:37:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212279 then '2' when ansid=212280 then '4' when ansid=212281 then '3' when ansid=212282 then '0' when ansid=212283 then '0' when ansid=212284 then '4' when ansid=212285 then '4' when ansid=212286 then '1' when ansid=212287 then '1' when ansid=212288 then '1' when ansid=212289 then '1' when ansid=212290 then '1' when ansid=212291 then '2' when ansid=212292 then '4' when ansid=212293 then '4' when ansid=212294 then '3' when ansid=212295 then '5' when ansid=212296 then '2' when ansid=212297 then '5' when ansid=212298 then '1'  when ansid=212299 then ''   when ansid=212300 then '1'   when ansid=212301 then ''   when ansid=212302 then '1'   when ansid=212303 then ''   when ansid=212304 then '1'   when ansid=212305 then ''   when ansid=212306 then '1'   when ansid=212307 then ''   when ansid=212308 then '1'  when ansid=212309 then '1' when ansid=212310 then '1' when ansid=212311 then '1'  when ansid=212312 then ''   when ansid=212313 then '1'   when ansid=212314 then ''   when ansid=212315 then '1'   when ansid=212316 then ''   when ansid=212317 then '1'   when ansid=212318 then 'only yellow bags seen, red & black bags not provided'   when ansid=212319 then '2'   when ansid=212320 then 'Site was camp based, packaging done at NGO office, but asked LT who told about packaging process which was as per guidelines'   when ansid=212321 then '3'   when ansid=212322 then 'once in 2 weeks'   when ansid=212323 then '4'   when ansid=212324 then ''   when ansid=212325 then '2'  when ansid=212326 then '1' when ansid=212327 then '2' when ansid=212328 then '1' when ansid=212329 then '1' when ansid=212330 then '1' when ansid=212331 then 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided. Asked to procure from SACS\/RI or purchase' when ansid=212332 then 'None' when ansid=212333 then 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidatesAll site personnel doing excellent work.Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.' when ansid=212334 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '152.57.50.207',\n\t\t\t\t\t\t\t\tmodifiedby =310,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-02 20:37:46'\n\t\t\t\t\t\t\tWHERE ansid in ('212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334')"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE supvisstepid = '11359'"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE visitfeedback SET `feedback` = 'Red & Black bags for bio medical waste disposal, small zip lock bags  for individual DBS cards, big box for DBS card storage not provided.', `recommendation` = 'Asked to procure non available items in feedback 1  from SACS\/RI or purchase.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE visitfeedbackid = '11186'"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE visitfeedback SET `feedback` = 'First day of HSS 7 samples were taken. Told to stick to only 5 samples per day. Since then only 5 per day pattern is being followed.', `recommendation` = 'Told counselor to give NGO\\'s programme information to all HRGs even if not eligible for HSS & ensure them of availability of services needed by them.', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE visitfeedbackid = '11187'"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE visitfeedback SET `feedback` = 'Rest of the HSS protocol points also followed well. All SMMs were entered in the HSS register & sample number given to 5 eligible candidates.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE visitfeedbackid = '11188'"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE visitfeedback SET `feedback` = 'All site personnel doing excellent work.', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE visitfeedbackid = '11189'"}
{"userId":"310","date":"2021-04-02 20:37:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '152.57.50.207', `modifiedby` = '310', `modifieddate` = '2021-04-02 20:37:46' WHERE visitfeedbackid = '11190'"}