{"userId":null,"date":"2021-02-07 10:07:22","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('42', '487534', '0', '120.59.41.114', '', '2021-02-07 10:07:22')"} {"userId":null,"date":"2021-02-07 10:10:11","query":"UPDATE usermst SET `password` = 'b071802c7f880383596c6b9edc861418', `modifieddate` = '2021-02-07 10:10:11', `ipaddress` = '120.59.41.114' WHERE userid = '42'"} {"userId":"309","date":"2021-02-07 10:24:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('309', '114.79.185.181', '2021-02-07 10:24:20')"} {"userId":"42","date":"2021-02-07 10:34:39","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('42', '120.59.41.114', '2021-02-07 10:34:39')"} {"userId":"309","date":"2021-02-07 10:48:22","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '114.79.185.181', `modifiedby` = '309', `modifieddate` = '2021-02-07 10:48:22' WHERE plansiteid = '1093'"} {"userId":"309","date":"2021-02-07 10:48:22","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '114.79.185.181', `modifiedby` = '309', `modifieddate` = '2021-02-07 10:48:22' WHERE ssid = ''"} {"userId":"309","date":"2021-02-07 10:48:46","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('622', '2021-02-09', '309', '114.79.185.181', '309', '2021-02-07 10:48:46')"} {"userId":"309","date":"2021-02-07 10:49:02","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('625', '2021-02-09', '309', '114.79.185.181', '309', '2021-02-07 10:49:02')"} {"userId":"2","date":"2021-02-07 19:37:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.161.180.120', '2021-02-07 19:37:02')"} {"userId":"357","date":"2021-02-07 20:20:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('357', '47.247.65.187', '2021-02-07 20:20:42')"} {"userId":"357","date":"2021-02-07 20:21:47","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('703', '2021-02-06', '357', '47.247.65.187', '357', '2021-02-07 20:21:47')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('703', '1102', '357', '2021-02-07', '1', '47.247.65.187', '357', '2021-02-07 20:21:59', '', '')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('808', '0', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('808', '1', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('808', '2', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('808', '3', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('808', '4', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('808', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('808', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('808', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('808', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":"357","date":"2021-02-07 20:21:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('808', '47.247.65.187', '357', '2021-02-07 20:21:59')"} {"userId":null,"date":"2021-02-07 20:24:18","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('25', '203622', '0', '47.9.66.41', '', '2021-02-07 20:24:18')"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '' when ansid=83570 then '' when ansid=83571 then '' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '' when ansid=83575 then '' when ansid=83618 then '' when ansid=83620 then '' when ansid=83622 then '' when ansid=83624 then '' when ansid=83626 then '' when ansid=83628 then '' when ansid=83629 then '' when ansid=83630 then '' when ansid=83631 then '' when ansid=83632 then '' when ansid=83633 then '' when ansid=83634 then '' when ansid=83635 then '' when ansid=83636 then '' when ansid=83637 then '' when ansid=83638 then '' when ansid=83639 then '' when ansid=83640 then '' when ansid=83641 then '' when ansid=83642 then '' when ansid=83643 then '' when ansid=83644 then '' when ansid=83645 then '' when ansid=83646 then '' when ansid=83647 then '' when ansid=83648 then '' when ansid=83649 then '' when ansid=83650 then '' when ansid=83651 then '' when ansid=83652 then '' when ansid=83653 then '' when ansid=83654 then '' when ansid=83655 then '' when ansid=83656 then '' when ansid=83657 then '' when ansid=83658 then '' when ansid=83659 then '' when ansid=83660 then '' when ansid=83661 then '' when ansid=83662 then '' when ansid=83663 then '' when ansid=83664 then '' when ansid=83665 then '' when ansid=83666 then '' when ansid=83667 then '' when ansid=83668 then '' when ansid=83669 then '' when ansid=83670 then '' when ansid=83671 then '' when ansid=83672 then '' when ansid=83673 then '' when ansid=83674 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:25:26'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE supvisstepid = '5038'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:25:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:26' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '' when ansid=83620 then '' when ansid=83622 then '' when ansid=83624 then '' when ansid=83626 then '' when ansid=83628 then '' when ansid=83629 then '' when ansid=83630 then '' when ansid=83631 then '' when ansid=83632 then '' when ansid=83633 then '' when ansid=83634 then '' when ansid=83635 then '' when ansid=83636 then '' when ansid=83637 then '' when ansid=83638 then '' when ansid=83639 then '' when ansid=83640 then '' when ansid=83641 then '' when ansid=83642 then '' when ansid=83643 then '' when ansid=83644 then '' when ansid=83645 then '' when ansid=83646 then '' when ansid=83647 then '' when ansid=83648 then '' when ansid=83649 then '' when ansid=83650 then '' when ansid=83651 then '' when ansid=83652 then '' when ansid=83653 then '' when ansid=83654 then '' when ansid=83655 then '' when ansid=83656 then '' when ansid=83657 then '' when ansid=83658 then '' when ansid=83659 then '' when ansid=83660 then '' when ansid=83661 then '' when ansid=83662 then '' when ansid=83663 then '' when ansid=83664 then '' when ansid=83665 then '' when ansid=83666 then '' when ansid=83667 then '' when ansid=83668 then '' when ansid=83669 then '' when ansid=83670 then '' when ansid=83671 then '' when ansid=83672 then '' when ansid=83673 then '' when ansid=83674 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:25:54'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE supvisstepid = '5039'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:25:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:25:54' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '1' when ansid=83620 then '1' when ansid=83622 then '1' when ansid=83624 then '3' when ansid=83626 then '5' when ansid=83628 then '' when ansid=83629 then '' when ansid=83630 then '' when ansid=83631 then '' when ansid=83632 then '' when ansid=83633 then '' when ansid=83634 then '' when ansid=83635 then '' when ansid=83636 then '' when ansid=83637 then '' when ansid=83638 then '' when ansid=83639 then '' when ansid=83640 then '' when ansid=83641 then '' when ansid=83642 then '' when ansid=83643 then '' when ansid=83644 then '' when ansid=83645 then '' when ansid=83646 then '' when ansid=83647 then '' when ansid=83648 then '' when ansid=83649 then '' when ansid=83650 then '' when ansid=83651 then '' when ansid=83652 then '' when ansid=83653 then '' when ansid=83654 then '' when ansid=83655 then '' when ansid=83656 then '' when ansid=83657 then '' when ansid=83658 then '' when ansid=83659 then '' when ansid=83660 then '' when ansid=83661 then '' when ansid=83662 then '' when ansid=83663 then '' when ansid=83664 then '' when ansid=83665 then '' when ansid=83666 then '' when ansid=83667 then '' when ansid=83668 then '' when ansid=83669 then '' when ansid=83670 then '' when ansid=83671 then '' when ansid=83672 then '' when ansid=83673 then '' when ansid=83674 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:26:34'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE supvisstepid = '5040'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:26:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:26:34' WHERE visitfeedbackid = '3820'"} {"userId":null,"date":"2021-02-07 20:26:46","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('25', '969248', '0', '47.9.66.41', '', '2021-02-07 20:26:46')"} {"userId":null,"date":"2021-02-07 20:27:31","query":"UPDATE usermst SET `password` = '6c44e5cd17f0019c64b042e4a745412a', `modifieddate` = '2021-02-07 20:27:31', `ipaddress` = '47.9.66.41' WHERE userid = '25'"} {"userId":"25","date":"2021-02-07 20:27:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('25', '47.9.66.41', '2021-02-07 20:27:49')"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '1' when ansid=83620 then '1' when ansid=83622 then '1' when ansid=83624 then '3' when ansid=83626 then '5' when ansid=83628 then '10' when ansid=83629 then '10' when ansid=83630 then '121' when ansid=83631 then '32' when ansid=83632 then '' when ansid=83633 then '1' when ansid=83634 then '1' when ansid=83635 then '' when ansid=83636 then '1' when ansid=83637 then '' when ansid=83638 then '1' when ansid=83639 then '6' when ansid=83640 then '1' when ansid=83641 then '1' when ansid=83642 then 'Nurse' when ansid=83643 then '1' when ansid=83644 then '' when ansid=83645 then '1' when ansid=83646 then '1' when ansid=83647 then '' when ansid=83648 then '1' when ansid=83649 then '2' when ansid=83650 then '1' when ansid=83651 then '1' when ansid=83652 then '1' when ansid=83653 then '1' when ansid=83654 then '2' when ansid=83655 then '1' when ansid=83656 then '1' when ansid=83657 then '1' when ansid=83658 then '' when ansid=83659 then '3' when ansid=83660 then 'Thermocol box' when ansid=83661 then '2' when ansid=83662 then '1' when ansid=83663 then '1' when ansid=83664 then '' when ansid=83665 then '1' when ansid=83666 then '2' when ansid=83667 then '2' when ansid=83668 then '2' when ansid=83669 then '1' when ansid=83670 then '0' when ansid=83671 then '1.The facility was not provided any IEC material for display as they were distributed by MPSACS Office in Bhopal.But due to Covid 19 Pandemic the whole training was conducted online & personnel involved in HSS activity in DH-Sehore did not visited Bhopal office.Hence they had no IEC material available for display.2.There are 2 lab technicians one provided by ICTC & other by hospital administration.The two of them work all 7 days a week.In some untoward event the HSS lab technician Ms Kamini Goud is required to work at some other place or as replacement to absentee in ICTC lab or she may herself be on leave.In these situation NURSE\/COUNSELLOR is concerned that in her absence HSS work maybe compromised.So she asked the monitoring team to convey authorities not to post Lab Technician Kamini Goud to any other lab till HSS is going on.3.No micro pipette was used to draw blood instead rubber or plastic dropper was used.4. Refrigerator was not locked instead the whole room in which it was placed was locked.5.The black bag was not used for BMW collection instead yellow, red & blue bags & containers were used.' when ansid=83672 then 'Yes by Dr Anshuli Trivedi HSS 2019.The facility was not visited by any other visitor from RI\/SACS \/others.' when ansid=83673 then '' when ansid=83674 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:45:54'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE supvisstepid = '5040'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:45:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:45:54' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '1' when ansid=83620 then '1' when ansid=83622 then '1' when ansid=83624 then '3' when ansid=83626 then '5' when ansid=83628 then '10' when ansid=83629 then '10' when ansid=83630 then '121' when ansid=83631 then '32' when ansid=83632 then '' when ansid=83633 then '1' when ansid=83634 then '1' when ansid=83635 then '' when ansid=83636 then '1' when ansid=83637 then '' when ansid=83638 then '1' when ansid=83639 then '6' when ansid=83640 then '1' when ansid=83641 then '1' when ansid=83642 then 'Nurse' when ansid=83643 then '1' when ansid=83644 then '' when ansid=83645 then '1' when ansid=83646 then '1' when ansid=83647 then '' when ansid=83648 then '1' when ansid=83649 then '2' when ansid=83650 then '1' when ansid=83651 then '1' when ansid=83652 then '1' when ansid=83653 then '1' when ansid=83654 then '2' when ansid=83655 then '1' when ansid=83656 then '1' when ansid=83657 then '1' when ansid=83658 then '' when ansid=83659 then '3' when ansid=83660 then 'Thermocol box' when ansid=83661 then '2' when ansid=83662 then '1' when ansid=83663 then '1' when ansid=83664 then '' when ansid=83665 then '1' when ansid=83666 then '2' when ansid=83667 then '2' when ansid=83668 then '2' when ansid=83669 then '1' when ansid=83670 then '0' when ansid=83671 then '1.The facility was not provided any IEC material for display as they were distributed by MPSACS Office in Bhopal.But due to Covid 19 Pandemic the whole training was conducted online & personnel involved in HSS activity in DH-Sehore did not visited Bhopal office.Hence they had no IEC material available for display.2.There are 2 lab technicians one provided by ICTC & other by hospital administration.The two of them work all 7 days a week.In some untoward event the HSS lab technician Ms Kamini Goud is required to work at some other place or as replacement to absentee in ICTC lab or she may herself be on leave.In these situation NURSE\/COUNSELLOR is concerned that in her absence HSS work maybe compromised.So she asked the monitoring team to convey authorities not to post Lab Technician Kamini Goud to any other lab till HSS is going on.3.No micro pipette was used to draw blood instead rubber or plastic dropper was used.4. Refrigerator was not locked instead the whole room in which it was placed was locked.5.The black bag was not used for BMW collection instead yellow, red & blue bags & containers were used.' when ansid=83672 then 'Yes by Dr Anshuli Trivedi HSS 2019.The facility was not visited by any other visitor from RI\/SACS \/others.' when ansid=83673 then 'Overall working at ANC site in DH Sehore was satisfactory' when ansid=83674 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:46:40'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE supvisstepid = '5041'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:46:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:46:40' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '1' when ansid=83620 then '1' when ansid=83622 then '1' when ansid=83624 then '3' when ansid=83626 then '5' when ansid=83628 then '10' when ansid=83629 then '10' when ansid=83630 then '121' when ansid=83631 then '32' when ansid=83632 then '' when ansid=83633 then '1' when ansid=83634 then '1' when ansid=83635 then '' when ansid=83636 then '1' when ansid=83637 then '' when ansid=83638 then '1' when ansid=83639 then '6' when ansid=83640 then '1' when ansid=83641 then '1' when ansid=83642 then 'Nurse' when ansid=83643 then '1' when ansid=83644 then '' when ansid=83645 then '1' when ansid=83646 then '1' when ansid=83647 then '' when ansid=83648 then '1' when ansid=83649 then '2' when ansid=83650 then '1' when ansid=83651 then '1' when ansid=83652 then '1' when ansid=83653 then '1' when ansid=83654 then '2' when ansid=83655 then '1' when ansid=83656 then '1' when ansid=83657 then '1' when ansid=83658 then '' when ansid=83659 then '3' when ansid=83660 then 'Thermocol box' when ansid=83661 then '2' when ansid=83662 then '1' when ansid=83663 then '1' when ansid=83664 then '' when ansid=83665 then '1' when ansid=83666 then '2' when ansid=83667 then '2' when ansid=83668 then '2' when ansid=83669 then '1' when ansid=83670 then '0' when ansid=83671 then '1.The facility was not provided any IEC material for display as they were distributed by MPSACS Office in Bhopal.But due to Covid 19 Pandemic the whole training was conducted online & personnel involved in HSS activity in DH-Sehore did not visited Bhopal office.Hence they had no IEC material available for display.2.There are 2 lab technicians one provided by ICTC & other by hospital administration.The two of them work all 7 days a week.In some untoward event the HSS lab technician Ms Kamini Goud is required to work at some other place or as replacement to absentee in ICTC lab or she may herself be on leave.In these situation NURSE\/COUNSELLOR is concerned that in her absence HSS work maybe compromised.So she asked the monitoring team to convey authorities not to post Lab Technician Kamini Goud to any other lab till HSS is going on.3.No micro pipette was used to draw blood instead rubber or plastic dropper was used.4. Refrigerator was not locked instead the whole room in which it was placed was locked.5.The black bag was not used for BMW collection instead yellow, red & blue bags & containers were used.' when ansid=83672 then 'Yes by Dr Anshuli Trivedi HSS 2019.The facility was not visited by any other visitor from RI\/SACS \/others.' when ansid=83673 then 'Overall working at ANC site in DH Sehore was satisfactory' when ansid=83674 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:48:13'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE supvisstepid = '5041'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:48:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:13' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE sitesupervision SET `siteid` = '703', `userid` = '357', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '30', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21', `locationtype` = '1', `establishmentyear` = '2013', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '808'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sujata Parmar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE onssid = '3560'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Pushpa Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '9', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE onssid = '3561'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE onsitestaffs SET `staffname` = 'Kamini Goud', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE onssid = '3562'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE onssid = '3563'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83569 then '1' when ansid=83570 then '2' when ansid=83571 then '1' when ansid=83572 then '' when ansid=83573 then '' when ansid=83574 then '544' when ansid=83575 then '1' when ansid=83618 then '1' when ansid=83620 then '1' when ansid=83622 then '1' when ansid=83624 then '3' when ansid=83626 then '5' when ansid=83628 then '10' when ansid=83629 then '10' when ansid=83630 then '121' when ansid=83631 then '32' when ansid=83632 then '' when ansid=83633 then '1' when ansid=83634 then '1' when ansid=83635 then '' when ansid=83636 then '1' when ansid=83637 then '' when ansid=83638 then '1' when ansid=83639 then '6' when ansid=83640 then '1' when ansid=83641 then '1' when ansid=83642 then 'Nurse' when ansid=83643 then '1' when ansid=83644 then '' when ansid=83645 then '1' when ansid=83646 then '1' when ansid=83647 then '' when ansid=83648 then '1' when ansid=83649 then '2' when ansid=83650 then '1' when ansid=83651 then '1' when ansid=83652 then '1' when ansid=83653 then '1' when ansid=83654 then '2' when ansid=83655 then '1' when ansid=83656 then '1' when ansid=83657 then '1' when ansid=83658 then '' when ansid=83659 then '3' when ansid=83660 then 'Thermocol box' when ansid=83661 then '2' when ansid=83662 then '1' when ansid=83663 then '1' when ansid=83664 then '' when ansid=83665 then '1' when ansid=83666 then '2' when ansid=83667 then '2' when ansid=83668 then '2' when ansid=83669 then '1' when ansid=83670 then '0' when ansid=83671 then '1.The facility was not provided any IEC material for display as they were distributed by MPSACS Office in Bhopal.But due to Covid 19 Pandemic the whole training was conducted online & personnel involved in HSS activity in DH-Sehore did not visited Bhopal office.Hence they had no IEC material available for display.2.There are 2 lab technicians one provided by ICTC & other by hospital administration.The two of them work all 7 days a week.In some untoward event the HSS lab technician Ms Kamini Goud is required to work at some other place or as replacement to absentee in ICTC lab or she may herself be on leave.In these situation NURSE\/COUNSELLOR is concerned that in her absence HSS work maybe compromised.So she asked the monitoring team to convey authorities not to post Lab Technician Kamini Goud to any other lab till HSS is going on.3.No micro pipette was used to draw blood instead rubber or plastic dropper was used.4. Refrigerator was not locked instead the whole room in which it was placed was locked.5.The black bag was not used for BMW collection instead yellow, red & blue bags & containers were used.' when ansid=83672 then 'Yes by Dr Anshuli Trivedi HSS 2019.The facility was not visited by any other visitor from RI\/SACS \/others.' when ansid=83673 then 'Overall working at ANC site in DH Sehore was satisfactory' when ansid=83674 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:48:21'\n\t\t\t\t\t\t\tWHERE ansid in ('83569','83570','83571','83572','83573','83574','83575','83618','83620','83622','83624','83626','83628','83629','83630','83631','83632','83633','83634','83635','83636','83637','83638','83639','83640','83641','83642','83643','83644','83645','83646','83647','83648','83649','83650','83651','83652','83653','83654','83655','83656','83657','83658','83659','83660','83661','83662','83663','83664','83665','83666','83667','83668','83669','83670','83671','83672','83673','83674')"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE supvisstepid = '5042'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE visitfeedbackid = '3816'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE visitfeedbackid = '3817'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE visitfeedbackid = '3818'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE visitfeedbackid = '3819'"} {"userId":"357","date":"2021-02-07 20:48:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:48:21' WHERE visitfeedbackid = '3820'"} {"userId":"357","date":"2021-02-07 20:49:44","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1194', '2021-02-05', '357', '47.247.65.187', '357', '2021-02-07 20:49:44')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1194', '1103', '357', '2021-02-07', '1', '47.247.65.187', '357', '2021-02-07 20:49:48', '', '')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('809', '0', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('809', '1', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('809', '2', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('809', '3', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('809', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('809', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('809', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('809', '', '', 'Array', '', 'Array', '', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:49:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('809', '47.247.65.187', '357', '2021-02-07 20:49:48')"} {"userId":"357","date":"2021-02-07 20:55:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('357', '47.247.65.187', '2021-02-07 20:55:33')"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '' when ansid=83683 then '' when ansid=83684 then '' when ansid=83685 then '' when ansid=83686 then '' when ansid=83687 then '' when ansid=83688 then '' when ansid=83689 then '' when ansid=83690 then '' when ansid=83691 then '' when ansid=83692 then '' when ansid=83693 then '' when ansid=83694 then '' when ansid=83695 then '' when ansid=83696 then '' when ansid=83697 then '' when ansid=83698 then '' when ansid=83699 then '' when ansid=83700 then '' when ansid=83701 then '' when ansid=83702 then '' when ansid=83703 then '' when ansid=83704 then '' when ansid=83705 then '' when ansid=83706 then '' when ansid=83707 then '' when ansid=83708 then '' when ansid=83709 then '' when ansid=83710 then '' when ansid=83711 then '' when ansid=83712 then '' when ansid=83713 then '' when ansid=83714 then '' when ansid=83715 then '' when ansid=83716 then '' when ansid=83717 then '' when ansid=83718 then '' when ansid=83719 then '' when ansid=83720 then '' when ansid=83721 then '' when ansid=83722 then '' when ansid=83723 then '' when ansid=83724 then '' when ansid=83725 then '' when ansid=83726 then '' when ansid=83727 then '' when ansid=83728 then '' when ansid=83729 then '' when ansid=83730 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:58:59'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE supvisstepid = '5043'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 20:58:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:58:59' WHERE visitfeedbackid = '3825'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '1' when ansid=83683 then '1' when ansid=83684 then '1' when ansid=83685 then '1' when ansid=83686 then '1' when ansid=83687 then '1' when ansid=83688 then '1' when ansid=83689 then '1' when ansid=83690 then '1' when ansid=83691 then '' when ansid=83692 then '' when ansid=83693 then '' when ansid=83694 then '' when ansid=83695 then '' when ansid=83696 then '' when ansid=83697 then '' when ansid=83698 then '' when ansid=83699 then '' when ansid=83700 then '' when ansid=83701 then '' when ansid=83702 then '' when ansid=83703 then '' when ansid=83704 then '' when ansid=83705 then '' when ansid=83706 then '' when ansid=83707 then '' when ansid=83708 then '' when ansid=83709 then '' when ansid=83710 then '' when ansid=83711 then '' when ansid=83712 then '' when ansid=83713 then '' when ansid=83714 then '' when ansid=83715 then '' when ansid=83716 then '' when ansid=83717 then '' when ansid=83718 then '' when ansid=83719 then '' when ansid=83720 then '' when ansid=83721 then '' when ansid=83722 then '' when ansid=83723 then '' when ansid=83724 then '' when ansid=83725 then '' when ansid=83726 then '' when ansid=83727 then '' when ansid=83728 then '' when ansid=83729 then '' when ansid=83730 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 20:59:38'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE supvisstepid = '5044'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 20:59:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 20:59:38' WHERE visitfeedbackid = '3825'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '1' when ansid=83683 then '1' when ansid=83684 then '1' when ansid=83685 then '1' when ansid=83686 then '1' when ansid=83687 then '1' when ansid=83688 then '1' when ansid=83689 then '1' when ansid=83690 then '1' when ansid=83691 then '10' when ansid=83692 then '4' when ansid=83693 then '3' when ansid=83694 then '1' when ansid=83695 then '' when ansid=83696 then '1' when ansid=83697 then '' when ansid=83698 then '1' when ansid=83699 then '' when ansid=83700 then '1' when ansid=83701 then '' when ansid=83702 then '1' when ansid=83703 then '' when ansid=83704 then '2' when ansid=83705 then '1' when ansid=83706 then '1' when ansid=83707 then '1' when ansid=83708 then '' when ansid=83709 then '1' when ansid=83710 then '' when ansid=83711 then '1' when ansid=83712 then '' when ansid=83713 then '1' when ansid=83714 then '' when ansid=83715 then '1' when ansid=83716 then '' when ansid=83717 then '1' when ansid=83718 then '' when ansid=83719 then '2' when ansid=83720 then '' when ansid=83721 then '2' when ansid=83722 then '2' when ansid=83723 then '2' when ansid=83724 then '1' when ansid=83725 then '1' when ansid=83726 then '1' when ansid=83727 then '1. There is o designated lab technician therefore site incharge & nurse draw blood from attendees.2.There is no availability of a secure almirahs or cupboard to securely store documents.There is a open metal rack which could not be locked.The whole room i.e. the nurses station is locked in her absence.But this was not acceptable as the documents are prone to damage & disclosure due to improper storage.' when ansid=83728 then 'Dr Bhawna Pawar MPSACS visited the site on 05.02.21.The team discussed above mentioned issues with her & seek help from MPSACS to reslove them.' when ansid=83729 then 'none' when ansid=83730 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 21:07:55'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE supvisstepid = '5044'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 21:07:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:07:55' WHERE visitfeedbackid = '3825'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '1' when ansid=83683 then '1' when ansid=83684 then '1' when ansid=83685 then '1' when ansid=83686 then '1' when ansid=83687 then '1' when ansid=83688 then '1' when ansid=83689 then '1' when ansid=83690 then '1' when ansid=83691 then '10' when ansid=83692 then '4' when ansid=83693 then '3' when ansid=83694 then '1' when ansid=83695 then '' when ansid=83696 then '1' when ansid=83697 then '' when ansid=83698 then '1' when ansid=83699 then '' when ansid=83700 then '1' when ansid=83701 then '' when ansid=83702 then '1' when ansid=83703 then '' when ansid=83704 then '2' when ansid=83705 then '1' when ansid=83706 then '1' when ansid=83707 then '1' when ansid=83708 then '' when ansid=83709 then '1' when ansid=83710 then '' when ansid=83711 then '1' when ansid=83712 then '' when ansid=83713 then '1' when ansid=83714 then '' when ansid=83715 then '1' when ansid=83716 then '' when ansid=83717 then '1' when ansid=83718 then '' when ansid=83719 then '2' when ansid=83720 then '' when ansid=83721 then '2' when ansid=83722 then '2' when ansid=83723 then '2' when ansid=83724 then '1' when ansid=83725 then '1' when ansid=83726 then '1' when ansid=83727 then '1. There is o designated lab technician therefore site incharge & nurse draw blood from attendees.2.There is no availability of a secure almirahs or cupboard to securely store documents.There is a open metal rack which could not be locked.The whole room i.e. the nurses station is locked in her absence.But this was not acceptable as the documents are prone to damage & disclosure due to improper storage.' when ansid=83728 then 'Dr Bhawna Pawar MPSACS visited the site on 05.02.21.The team discussed above mentioned issues with her & seek help from MPSACS to reslove them.' when ansid=83729 then 'Instead of using needles facility was using single use lancet.' when ansid=83730 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 21:08:47'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE supvisstepid = '5045'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 21:08:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:08:47' WHERE visitfeedbackid = '3825'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '1' when ansid=83683 then '1' when ansid=83684 then '1' when ansid=83685 then '1' when ansid=83686 then '1' when ansid=83687 then '1' when ansid=83688 then '1' when ansid=83689 then '1' when ansid=83690 then '1' when ansid=83691 then '10' when ansid=83692 then '4' when ansid=83693 then '3' when ansid=83694 then '1' when ansid=83695 then '' when ansid=83696 then '1' when ansid=83697 then '' when ansid=83698 then '1' when ansid=83699 then '' when ansid=83700 then '1' when ansid=83701 then '' when ansid=83702 then '1' when ansid=83703 then '' when ansid=83704 then '2' when ansid=83705 then '1' when ansid=83706 then '1' when ansid=83707 then '1' when ansid=83708 then '' when ansid=83709 then '1' when ansid=83710 then '' when ansid=83711 then '1' when ansid=83712 then '' when ansid=83713 then '1' when ansid=83714 then '' when ansid=83715 then '1' when ansid=83716 then '' when ansid=83717 then '1' when ansid=83718 then '' when ansid=83719 then '2' when ansid=83720 then '' when ansid=83721 then '2' when ansid=83722 then '2' when ansid=83723 then '2' when ansid=83724 then '1' when ansid=83725 then '1' when ansid=83726 then '1' when ansid=83727 then '1. There is no designated lab technician therefore site incharge & nurse draw blood from attendees.2.There is no availability of a secure almirahs or cupboard to securely store documents.There is a open metal rack which could not be locked.The whole room i.e. the nurses station is locked in her absence.But this was not acceptable as the documents are prone to damage & disclosure due to improper storage.' when ansid=83728 then 'Dr Bhawna Pawar MPSACS visited the site on 05.02.21.The team discussed above mentioned issues with her & seek help from MPSACS to resolve them.' when ansid=83729 then 'Instead of using needles facility was using single use lancet.' when ansid=83730 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 21:10:06'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE supvisstepid = '5045'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 21:10:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:06' WHERE visitfeedbackid = '3825'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE sitesupervision SET `siteid` = '1194', `userid` = '357', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '10', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '809'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Rajesh Chouhan', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE onssid = '3564'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE onsitestaffs SET `staffname` = 'Amrita Saroj', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE onssid = '3565'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE onsitestaffs SET `staffname` = 'Not Available', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE onssid = '3566'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE onssid = '3567'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=83675 then '2' when ansid=83676 then '1' when ansid=83677 then '1' when ansid=83678 then '0' when ansid=83679 then '0' when ansid=83680 then '3' when ansid=83681 then '3' when ansid=83682 then '1' when ansid=83683 then '1' when ansid=83684 then '1' when ansid=83685 then '1' when ansid=83686 then '1' when ansid=83687 then '1' when ansid=83688 then '1' when ansid=83689 then '1' when ansid=83690 then '1' when ansid=83691 then '10' when ansid=83692 then '4' when ansid=83693 then '3' when ansid=83694 then '1' when ansid=83695 then '' when ansid=83696 then '1' when ansid=83697 then '' when ansid=83698 then '1' when ansid=83699 then '' when ansid=83700 then '1' when ansid=83701 then '' when ansid=83702 then '1' when ansid=83703 then '' when ansid=83704 then '2' when ansid=83705 then '1' when ansid=83706 then '1' when ansid=83707 then '1' when ansid=83708 then '' when ansid=83709 then '1' when ansid=83710 then '' when ansid=83711 then '1' when ansid=83712 then '' when ansid=83713 then '1' when ansid=83714 then '' when ansid=83715 then '1' when ansid=83716 then '' when ansid=83717 then '1' when ansid=83718 then '' when ansid=83719 then '2' when ansid=83720 then '' when ansid=83721 then '2' when ansid=83722 then '2' when ansid=83723 then '2' when ansid=83724 then '1' when ansid=83725 then '1' when ansid=83726 then '1' when ansid=83727 then '1. There is no designated lab technician therefore site incharge & nurse draw blood from attendees.2.There is no availability of a secure almirahs or cupboard to securely store documents.There is a open metal rack which could not be locked.The whole room i.e. the nurses station is locked in her absence.But this was not acceptable as the documents are prone to damage & disclosure due to improper storage.' when ansid=83728 then 'Dr Bhawna Pawar MPSACS visited the site on 05.02.21.The team discussed above mentioned issues with her & seek help from MPSACS to resolve them.' when ansid=83729 then 'Instead of using needles facility was using single use lancet.' when ansid=83730 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.247.65.187',\n\t\t\t\t\t\t\t\tmodifiedby =357,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-02-07 21:10:32'\n\t\t\t\t\t\t\tWHERE ansid in ('83675','83676','83677','83678','83679','83680','83681','83682','83683','83684','83685','83686','83687','83688','83689','83690','83691','83692','83693','83694','83695','83696','83697','83698','83699','83700','83701','83702','83703','83704','83705','83706','83707','83708','83709','83710','83711','83712','83713','83714','83715','83716','83717','83718','83719','83720','83721','83722','83723','83724','83725','83726','83727','83728','83729','83730')"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE supvisstepid = '5046'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE visitfeedbackid = '3821'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE visitfeedbackid = '3822'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE visitfeedbackid = '3823'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE visitfeedbackid = '3824'"} {"userId":"357","date":"2021-02-07 21:10:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.247.65.187', `modifiedby` = '357', `modifieddate` = '2021-02-07 21:10:32' WHERE visitfeedbackid = '3825'"}