{"userId":"57","date":"2023-04-24 09:51:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '117.99.235.105', '2023-04-24 09:51:53')"} {"userId":"57","date":"2023-04-24 09:56:22","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('2011', '2023-04-19', '57', '14.139.200.27', '57', '2023-04-24 09:56:22')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('2011', '3294', '57', '2023-04-24', '1', '14.139.200.27', '57', '2023-04-24 09:56:29', '', '')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '0', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '1', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '2', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '3', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '4', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '5', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2829', '6', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2829', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2829', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2829', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2829', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('184', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('185', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('186', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('187', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('188', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('189', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('190', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('191', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('192', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('193', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('194', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('195', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('196', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('197', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('198', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('199', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('200', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('201', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('202', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('203', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('204', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('205', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('206', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('207', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('208', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('209', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('210', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('211', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('212', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('213', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('214', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('215', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('216', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('217', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('218', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('219', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('220', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('221', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('222', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('223', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('224', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('225', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('226', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('227', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('228', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('229', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('230', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('231', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('232', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('233', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('234', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('235', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('236', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('237', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('238', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('239', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('240', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('241', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('242', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('243', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('244', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('245', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('246', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('247', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('248', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('249', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('250', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('251', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('252', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('253', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('254', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('255', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('256', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('257', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('258', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('259', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('260', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('261', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('262', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('263', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('264', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('265', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('266', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('267', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('268', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('269', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('270', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('271', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('272', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('273', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('274', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('275', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('276', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('277', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('280', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('281', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('282', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('283', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('284', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('285', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('286', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('287', '2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 09:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2829', '14.139.200.27', '57', '2023-04-24 09:56:29')"} {"userId":"57","date":"2023-04-24 20:21:11","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '103.18.74.24', '2023-04-24 20:21:11')"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '' when ansid=268233 then '' when ansid=268234 then '' when ansid=268235 then '' when ansid=268236 then '' when ansid=268237 then '' when ansid=268238 then '' when ansid=268239 then '' when ansid=268240 then '' when ansid=268241 then '' when ansid=268242 then '' when ansid=268243 then '' when ansid=268244 then '' when ansid=268245 then '' when ansid=268308 then '' when ansid=268309 then '' when ansid=268310 then '' when ansid=268311 then '' when ansid=268312 then '' when ansid=268313 then '' when ansid=268246 then '' when ansid=268247 then '' when ansid=268248 then '' when ansid=268249 then '' when ansid=268250 then '' when ansid=268251 then '' when ansid=268252 then '' when ansid=268253 then '' when ansid=268254 then '' when ansid=268255 then '' when ansid=268256 then '' when ansid=268257 then '' when ansid=268258 then '' when ansid=268259 then '' when ansid=268260 then '' when ansid=268261 then '' when ansid=268262 then '' when ansid=268263 then '' when ansid=268264 then '' when ansid=268265 then '' when ansid=268266 then '' when ansid=268267 then '' when ansid=268268 then '' when ansid=268269 then '' when ansid=268270 then '' when ansid=268271 then '' when ansid=268272 then '' when ansid=268273 then '' when ansid=268274 then '' when ansid=268275 then '' when ansid=268276 then '' when ansid=268277 then '' when ansid=268278 then '' when ansid=268279 then '' when ansid=268280 then '' when ansid=268281 then '' when ansid=268282 then '' when ansid=268283 then '' when ansid=268284 then '' when ansid=268285 then '' when ansid=268286 then '' when ansid=268287 then '' when ansid=268288 then '' when ansid=268289 then '' when ansid=268290 then '' when ansid=268291 then '' when ansid=268292 then '' when ansid=268293 then '' when ansid=268294 then '' when ansid=268295 then '' when ansid=268314 then '' when ansid=268315 then '' when ansid=268296 then '' when ansid=268297 then '' when ansid=268298 then '' when ansid=268299 then '' when ansid=268300 then '' when ansid=268301 then '' when ansid=268302 then '' when ansid=268303 then '' when ansid=268304 then '' when ansid=268305 then '' when ansid=268306 then '' when ansid=268307 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:35:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE supvisstepid = '13945'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:35:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:33' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then '' when ansid=268235 then '' when ansid=268236 then '' when ansid=268237 then '' when ansid=268238 then '' when ansid=268239 then '' when ansid=268240 then '' when ansid=268241 then '' when ansid=268242 then '' when ansid=268243 then '' when ansid=268244 then '' when ansid=268245 then '' when ansid=268308 then '' when ansid=268309 then '' when ansid=268310 then '' when ansid=268311 then '' when ansid=268312 then '' when ansid=268313 then '' when ansid=268246 then '' when ansid=268247 then '' when ansid=268248 then '' when ansid=268249 then '' when ansid=268250 then '' when ansid=268251 then '' when ansid=268252 then '' when ansid=268253 then '' when ansid=268254 then '' when ansid=268255 then '' when ansid=268256 then '' when ansid=268257 then '' when ansid=268258 then '' when ansid=268259 then '' when ansid=268260 then '' when ansid=268261 then '' when ansid=268262 then '' when ansid=268263 then '' when ansid=268264 then '' when ansid=268265 then '' when ansid=268266 then '' when ansid=268267 then '' when ansid=268268 then '' when ansid=268269 then '' when ansid=268270 then '' when ansid=268271 then '' when ansid=268272 then '' when ansid=268273 then '' when ansid=268274 then '' when ansid=268275 then '' when ansid=268276 then '' when ansid=268277 then '' when ansid=268278 then '' when ansid=268279 then '' when ansid=268280 then '' when ansid=268281 then '' when ansid=268282 then '' when ansid=268283 then '' when ansid=268284 then '' when ansid=268285 then '' when ansid=268286 then '' when ansid=268287 then '' when ansid=268288 then '' when ansid=268289 then '' when ansid=268290 then '' when ansid=268291 then '' when ansid=268292 then '' when ansid=268293 then '' when ansid=268294 then '' when ansid=268295 then '' when ansid=268314 then '' when ansid=268315 then '' when ansid=268296 then '' when ansid=268297 then '' when ansid=268298 then '' when ansid=268299 then '' when ansid=268300 then '' when ansid=268301 then '' when ansid=268302 then '' when ansid=268303 then '' when ansid=268304 then '' when ansid=268305 then '' when ansid=268306 then '' when ansid=268307 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:35:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE supvisstepid = '13946'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:35:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:35:39' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '' when ansid=268266 then '' when ansid=268267 then '' when ansid=268268 then '' when ansid=268269 then '' when ansid=268270 then '' when ansid=268271 then '' when ansid=268272 then '' when ansid=268273 then '' when ansid=268274 then '' when ansid=268275 then '' when ansid=268276 then '' when ansid=268277 then '' when ansid=268278 then '' when ansid=268279 then '' when ansid=268280 then '' when ansid=268281 then '' when ansid=268282 then '' when ansid=268283 then '' when ansid=268284 then '' when ansid=268285 then '' when ansid=268286 then '' when ansid=268287 then '' when ansid=268288 then '' when ansid=268289 then '' when ansid=268290 then '' when ansid=268291 then '' when ansid=268292 then '' when ansid=268293 then '' when ansid=268294 then '' when ansid=268295 then '' when ansid=268314 then '' when ansid=268315 then '' when ansid=268296 then '' when ansid=268297 then '' when ansid=268298 then '' when ansid=268299 then '' when ansid=268300 then '' when ansid=268301 then '' when ansid=268302 then '' when ansid=268303 then '' when ansid=268304 then '' when ansid=268305 then '' when ansid=268306 then '' when ansid=268307 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:37:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE supvisstepid = '13947'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:37:58' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '1' when ansid=268266 then '1' when ansid=268267 then '1' when ansid=268268 then '1' when ansid=268269 then '1' when ansid=268270 then '1' when ansid=268271 then '1' when ansid=268272 then 'No sample testing was started as there were no kits available.' when ansid=268273 then '' when ansid=268274 then '' when ansid=268275 then '' when ansid=268276 then '' when ansid=268277 then '' when ansid=268278 then '' when ansid=268279 then '' when ansid=268280 then '' when ansid=268281 then '' when ansid=268282 then '' when ansid=268283 then '' when ansid=268284 then '' when ansid=268285 then '' when ansid=268286 then '' when ansid=268287 then '' when ansid=268288 then '' when ansid=268289 then '' when ansid=268290 then '' when ansid=268291 then '' when ansid=268292 then '' when ansid=268293 then '' when ansid=268294 then '' when ansid=268295 then '' when ansid=268314 then '' when ansid=268315 then '' when ansid=268296 then '' when ansid=268297 then '' when ansid=268298 then '' when ansid=268299 then '' when ansid=268300 then '' when ansid=268301 then '' when ansid=268302 then '' when ansid=268303 then '' when ansid=268304 then '' when ansid=268305 then '' when ansid=268306 then '' when ansid=268307 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:39:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE supvisstepid = '13948'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:39:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:39:58' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '1' when ansid=268266 then '1' when ansid=268267 then '1' when ansid=268268 then '1' when ansid=268269 then '1' when ansid=268270 then '1' when ansid=268271 then '1' when ansid=268272 then 'No sample testing was started as there were no kits available.' when ansid=268273 then '13\/03\/2023' when ansid=268274 then '19\/04\/2023' when ansid=268275 then '930' when ansid=268276 then '0' when ansid=268277 then '14' when ansid=268278 then '0' when ansid=268279 then '0' when ansid=268280 then '0' when ansid=268281 then '0' when ansid=268282 then '0' when ansid=268283 then '0' when ansid=268284 then '0' when ansid=268285 then '0' when ansid=268286 then '0' when ansid=268287 then '0' when ansid=268288 then '0' when ansid=268289 then '0' when ansid=268290 then '0' when ansid=268291 then '0' when ansid=268292 then '0' when ansid=268293 then '1' when ansid=268294 then '' when ansid=268295 then '' when ansid=268314 then '' when ansid=268315 then '' when ansid=268296 then '' when ansid=268297 then '' when ansid=268298 then '' when ansid=268299 then '' when ansid=268300 then '' when ansid=268301 then '' when ansid=268302 then '' when ansid=268303 then '' when ansid=268304 then '' when ansid=268305 then '' when ansid=268306 then '' when ansid=268307 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:41:45'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE supvisstepid = '13949'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:41:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:41:45' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '1' when ansid=268266 then '1' when ansid=268267 then '1' when ansid=268268 then '1' when ansid=268269 then '1' when ansid=268270 then '1' when ansid=268271 then '1' when ansid=268272 then 'No sample testing was started as there were no kits available.' when ansid=268273 then '13\/03\/2023' when ansid=268274 then '19\/04\/2023' when ansid=268275 then '930' when ansid=268276 then '0' when ansid=268277 then '14' when ansid=268278 then '0' when ansid=268279 then '0' when ansid=268280 then '0' when ansid=268281 then '0' when ansid=268282 then '0' when ansid=268283 then '0' when ansid=268284 then '0' when ansid=268285 then '0' when ansid=268286 then '0' when ansid=268287 then '0' when ansid=268288 then '0' when ansid=268289 then '0' when ansid=268290 then '0' when ansid=268291 then '0' when ansid=268292 then '0' when ansid=268293 then '1' when ansid=268294 then '1' when ansid=268295 then '1' when ansid=268314 then '0' when ansid=268315 then '0' when ansid=268296 then '0' when ansid=268297 then '1' when ansid=268298 then '1' when ansid=268299 then '1' when ansid=268300 then 'Lab technician' when ansid=268301 then 'Technical Officer and Head of department Microbiology' when ansid=268302 then '0' when ansid=268303 then '1' when ansid=268304 then '1' when ansid=268305 then '1' when ansid=268306 then 'No testing was done due to the unavailability of kits. They are using the help of VRDL Lab deep freezer to store samples as they have not adequate storage space.' when ansid=268307 then 'NA' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:45:31'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE supvisstepid = '13950'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:45:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:31' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '1' when ansid=268266 then '1' when ansid=268267 then '1' when ansid=268268 then '1' when ansid=268269 then '1' when ansid=268270 then '1' when ansid=268271 then '1' when ansid=268272 then 'No sample testing was started as there were no kits available.' when ansid=268273 then '13\/03\/2023' when ansid=268274 then '19\/04\/2023' when ansid=268275 then '930' when ansid=268276 then '0' when ansid=268277 then '14' when ansid=268278 then '0' when ansid=268279 then '0' when ansid=268280 then '0' when ansid=268281 then '0' when ansid=268282 then '0' when ansid=268283 then '0' when ansid=268284 then '0' when ansid=268285 then '0' when ansid=268286 then '0' when ansid=268287 then '0' when ansid=268288 then '0' when ansid=268289 then '0' when ansid=268290 then '0' when ansid=268291 then '0' when ansid=268292 then '0' when ansid=268293 then '1' when ansid=268294 then '1' when ansid=268295 then '1' when ansid=268314 then '0' when ansid=268315 then '0' when ansid=268296 then '0' when ansid=268297 then '1' when ansid=268298 then '1' when ansid=268299 then '1' when ansid=268300 then 'Lab technician' when ansid=268301 then 'Technical Officer and Head of department Microbiology' when ansid=268302 then '0' when ansid=268303 then '1' when ansid=268304 then '1' when ansid=268305 then '1' when ansid=268306 then 'No testing was done due to the unavailability of kits. They are using the help of VRDL Lab deep freezer to store samples as they have not adequate storage space.' when ansid=268307 then 'NA' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:45:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE supvisstepid = '13950'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:45:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:45:51' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE sitesupervision SET `siteid` = '2011', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-03-13', `numofsamplecollected` = '930', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2829'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE onsitestaffs SET `staffname` = 'Roshan Singh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE onssid = '11644'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE onsitestaffs SET `staffname` = 'L C Martina', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE onssid = '11645'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Supriya Laifangbam', `staffdesigid` = '', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE onssid = '11646'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE onssid = '11647'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268214 then '6' when ansid=268215 then '2007' when ansid=268216 then '0' when ansid=268217 then 'ANC site- JNIMS' when ansid=268218 then '228' when ansid=268219 then '' when ansid=268220 then 'ANC Bishnupur' when ansid=268221 then '193' when ansid=268222 then '' when ansid=268223 then 'ANC JIRIBAM' when ansid=268224 then '48' when ansid=268225 then '' when ansid=268226 then 'ANC,WANGOI' when ansid=268227 then '77' when ansid=268228 then '' when ansid=268229 then 'ANC SITE- CHURACHANDPUR, SDH-MOREH, PHC-MOREH, PHC- TENGNOUPAL, CHANDEL, PHC- KOMLATHABI, PHC- CHAPICARONG, DH-SENAPATI, CHC-MAO,LAMKA NURSING HOME,NAZARETH' when ansid=268230 then '384' when ansid=268231 then 'No samples were received from ANC_Churachandpur and PHC- chapikarong. 14 samples were rejected from ANC_PHC_Tengnoupal as the samples were sent on the same day of collection.' when ansid=268232 then '1' when ansid=268233 then '1' when ansid=268234 then 'NA' when ansid=268235 then 'NA' when ansid=268236 then '0' when ansid=268237 then '0' when ansid=268238 then '0' when ansid=268239 then '0' when ansid=268240 then 'NA' when ansid=268241 then 'NA' when ansid=268242 then '0' when ansid=268243 then '0' when ansid=268244 then '0' when ansid=268245 then '0' when ansid=268308 then 'NA' when ansid=268309 then 'NA' when ansid=268310 then '0' when ansid=268311 then '0' when ansid=268312 then '0' when ansid=268313 then '0' when ansid=268246 then 'NA' when ansid=268247 then 'NA' when ansid=268248 then '0' when ansid=268249 then '0' when ansid=268250 then '0' when ansid=268251 then '0' when ansid=268252 then 'NA' when ansid=268253 then 'NA' when ansid=268254 then '0' when ansid=268255 then '0' when ansid=268256 then '0' when ansid=268257 then '0' when ansid=268258 then 'NA' when ansid=268259 then 'NA' when ansid=268260 then '0' when ansid=268261 then '0' when ansid=268262 then '0' when ansid=268263 then '0' when ansid=268264 then '' when ansid=268265 then '1' when ansid=268266 then '1' when ansid=268267 then '1' when ansid=268268 then '1' when ansid=268269 then '1' when ansid=268270 then '1' when ansid=268271 then '1' when ansid=268272 then 'No sample testing was started as there were no kits available.' when ansid=268273 then '13\/03\/2023' when ansid=268274 then '19\/04\/2023' when ansid=268275 then '930' when ansid=268276 then '0' when ansid=268277 then '14' when ansid=268278 then '0' when ansid=268279 then '0' when ansid=268280 then '0' when ansid=268281 then '0' when ansid=268282 then '0' when ansid=268283 then '0' when ansid=268284 then '0' when ansid=268285 then '0' when ansid=268286 then '0' when ansid=268287 then '0' when ansid=268288 then '0' when ansid=268289 then '0' when ansid=268290 then '0' when ansid=268291 then '0' when ansid=268292 then '0' when ansid=268293 then '1' when ansid=268294 then '1' when ansid=268295 then '1' when ansid=268314 then '0' when ansid=268315 then '0' when ansid=268296 then '0' when ansid=268297 then '1' when ansid=268298 then '1' when ansid=268299 then '1' when ansid=268300 then 'Lab technician' when ansid=268301 then 'Technical Officer and Head of department Microbiology' when ansid=268302 then '0' when ansid=268303 then '1' when ansid=268304 then '1' when ansid=268305 then '1' when ansid=268306 then 'No testing was done due to the unavailability of kits. They are using the help of VRDL Lab deep freezer to store samples as they have not adequate storage space.' when ansid=268307 then 'NA' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 20:55:12'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268214','268215','268216','268217','268218','268219','268220','268221','268222','268223','268224','268225','268226','268227','268228','268229','268230','268231','268232','268233','268234','268235','268236','268237','268238','268239','268240','268241','268242','268243','268244','268245','268308','268309','268310','268311','268312','268313','268246','268247','268248','268249','268250','268251','268252','268253','268254','268255','268256','268257','268258','268259','268260','268261','268262','268263','268264','268265','268266','268267','268268','268269','268270','268271','268272','268273','268274','268275','268276','268277','268278','268279','268280','268281','268282','268283','268284','268285','268286','268287','268288','268289','268290','268291','268292','268293','268294','268295','268314','268315','268296','268297','268298','268299','268300','268301','268302','268303','268304','268305','268306','268307')"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE supvisstepid = '13951'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE visitfeedback SET `feedback` = 'No testing was done due to the unavailability of kits. They are using the help of VRDL Lab deep freezer to store samples as they have not adequate storage space. This issue was discussed with SACS official.', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE visitfeedbackid = '13921'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE visitfeedbackid = '13922'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE visitfeedbackid = '13923'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE visitfeedbackid = '13924'"} {"userId":"57","date":"2023-04-24 20:55:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 20:55:12' WHERE visitfeedbackid = '13925'"} {"userId":"57","date":"2023-04-24 20:56:26","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1062', '2023-04-19', '57', '103.18.74.24', '57', '2023-04-24 20:56:26')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1062', '3295', '57', '2023-04-24', '1', '103.18.74.24', '57', '2023-04-24 20:56:29', '', '')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2830', '0', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2830', '1', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2830', '2', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2830', '3', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2830', '', '', 'Array', '', 'Array', '', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2830', '', '', 'Array', '', 'Array', '', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2830', '', '', 'Array', '', 'Array', '', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2830', '', '', 'Array', '', 'Array', '', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 20:56:29","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2830', '103.18.74.24', '57', '2023-04-24 20:56:29')"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-04-13', `numofsamplecollected` = '13', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '3', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '166', `undertrialprisoners` = '569' WHERE ssid = '2830'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amarjit Metei', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE onssid = '11648'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE onsitestaffs SET `staffname` = 'A Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE onssid = '11649'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE onsitestaffs SET `staffname` = 'Sunita Devi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE onssid = '11650'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE onssid = '11651'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268362 then '' when ansid=268364 then '' when ansid=268366 then '' when ansid=268368 then '' when ansid=268370 then '' when ansid=268372 then '' when ansid=268373 then '' when ansid=268374 then '' when ansid=268375 then '' when ansid=268376 then '' when ansid=268377 then '' when ansid=268378 then '' when ansid=268379 then '' when ansid=268380 then '' when ansid=268381 then '' when ansid=268382 then '' when ansid=268383 then '' when ansid=268384 then '' when ansid=268385 then '' when ansid=268386 then '' when ansid=268387 then '' when ansid=268388 then '' when ansid=268389 then '' when ansid=268390 then '' when ansid=268391 then '' when ansid=268392 then '' when ansid=268393 then '' when ansid=268394 then '' when ansid=268395 then '' when ansid=268396 then '' when ansid=268397 then '' when ansid=268398 then '' when ansid=268399 then '' when ansid=268400 then '' when ansid=268401 then '' when ansid=268402 then '' when ansid=268403 then '' when ansid=268404 then '' when ansid=268405 then '' when ansid=268406 then '' when ansid=268407 then '' when ansid=268408 then '' when ansid=268409 then '' when ansid=268410 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 21:00:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268362','268364','268366','268368','268370','268372','268373','268374','268375','268376','268377','268378','268379','268380','268381','268382','268383','268384','268385','268386','268387','268388','268389','268390','268391','268392','268393','268394','268395','268396','268397','268398','268399','268400','268401','268402','268403','268404','268405','268406','268407','268408','268409','268410')"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE supvisstepid = '13952'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE visitfeedbackid = '13926'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE visitfeedbackid = '13927'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE visitfeedbackid = '13928'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE visitfeedbackid = '13929'"} {"userId":"57","date":"2023-04-24 21:00:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:00:51' WHERE visitfeedbackid = '13930'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-04-13', `numofsamplecollected` = '13', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '3', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '166', `undertrialprisoners` = '569' WHERE ssid = '2830'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amarjit Metei', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE onssid = '11648'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE onsitestaffs SET `staffname` = 'A Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE onssid = '11649'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE onsitestaffs SET `staffname` = 'Sunita Devi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE onssid = '11650'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE onssid = '11651'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268362 then '1' when ansid=268364 then '1' when ansid=268366 then '1' when ansid=268368 then '3' when ansid=268370 then '5' when ansid=268372 then '' when ansid=268373 then '' when ansid=268374 then '' when ansid=268375 then '' when ansid=268376 then '' when ansid=268377 then '' when ansid=268378 then '' when ansid=268379 then '' when ansid=268380 then '' when ansid=268381 then '' when ansid=268382 then '' when ansid=268383 then '' when ansid=268384 then '' when ansid=268385 then '' when ansid=268386 then '' when ansid=268387 then '' when ansid=268388 then '' when ansid=268389 then '' when ansid=268390 then '' when ansid=268391 then '' when ansid=268392 then '' when ansid=268393 then '' when ansid=268394 then '' when ansid=268395 then '' when ansid=268396 then '' when ansid=268397 then '' when ansid=268398 then '' when ansid=268399 then '' when ansid=268400 then '' when ansid=268401 then '' when ansid=268402 then '' when ansid=268403 then '' when ansid=268404 then '' when ansid=268405 then '' when ansid=268406 then '' when ansid=268407 then '' when ansid=268408 then '' when ansid=268409 then '' when ansid=268410 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 21:01:08'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268362','268364','268366','268368','268370','268372','268373','268374','268375','268376','268377','268378','268379','268380','268381','268382','268383','268384','268385','268386','268387','268388','268389','268390','268391','268392','268393','268394','268395','268396','268397','268398','268399','268400','268401','268402','268403','268404','268405','268406','268407','268408','268409','268410')"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE supvisstepid = '13953'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE visitfeedbackid = '13926'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE visitfeedbackid = '13927'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE visitfeedbackid = '13928'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE visitfeedbackid = '13929'"} {"userId":"57","date":"2023-04-24 21:01:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:01:08' WHERE visitfeedbackid = '13930'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-04-13', `numofsamplecollected` = '13', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '3', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '166', `undertrialprisoners` = '569' WHERE ssid = '2830'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amarjit Metei', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE onssid = '11648'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'A Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE onssid = '11649'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'Sunita Devi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE onssid = '11650'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE onssid = '11651'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268362 then '1' when ansid=268364 then '1' when ansid=268366 then '1' when ansid=268368 then '3' when ansid=268370 then '5' when ansid=268372 then '3' when ansid=268373 then '0' when ansid=268374 then '' when ansid=268375 then '1' when ansid=268376 then '' when ansid=268377 then '1' when ansid=268378 then '' when ansid=268379 then '1' when ansid=268380 then '10' when ansid=268381 then '1' when ansid=268382 then 'Counselor' when ansid=268383 then '1' when ansid=268384 then '' when ansid=268385 then '1' when ansid=268386 then '1' when ansid=268387 then 'Counsellor was not understanding about information to be filled in the column no.6' when ansid=268388 then '2' when ansid=268389 then '1' when ansid=268390 then '1' when ansid=268391 then '1' when ansid=268392 then '1' when ansid=268393 then '1' when ansid=268394 then '1' when ansid=268395 then '1' when ansid=268396 then '1' when ansid=268397 then '3' when ansid=268398 then '1' when ansid=268399 then '1' when ansid=268400 then '1' when ansid=268401 then '' when ansid=268402 then '1' when ansid=268403 then '1' when ansid=268404 then '1' when ansid=268405 then '1' when ansid=268406 then '1' when ansid=268407 then '0' when ansid=268408 then 'NIL' when ansid=268409 then 'No' when ansid=268410 then 'NIL' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 21:04:52'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268362','268364','268366','268368','268370','268372','268373','268374','268375','268376','268377','268378','268379','268380','268381','268382','268383','268384','268385','268386','268387','268388','268389','268390','268391','268392','268393','268394','268395','268396','268397','268398','268399','268400','268401','268402','268403','268404','268405','268406','268407','268408','268409','268410')"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE supvisstepid = '13954'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE visitfeedbackid = '13926'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE visitfeedbackid = '13927'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE visitfeedbackid = '13928'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE visitfeedbackid = '13929'"} {"userId":"57","date":"2023-04-24 21:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:04:52' WHERE visitfeedbackid = '13930'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-04-13', `numofsamplecollected` = '13', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '3', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '166', `undertrialprisoners` = '569' WHERE ssid = '2830'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amarjit Metei', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE onssid = '11648'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE onsitestaffs SET `staffname` = 'A Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE onssid = '11649'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE onsitestaffs SET `staffname` = 'Sunita Devi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE onssid = '11650'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE onssid = '11651'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268362 then '1' when ansid=268364 then '1' when ansid=268366 then '1' when ansid=268368 then '3' when ansid=268370 then '5' when ansid=268372 then '3' when ansid=268373 then '0' when ansid=268374 then '' when ansid=268375 then '1' when ansid=268376 then '' when ansid=268377 then '1' when ansid=268378 then '' when ansid=268379 then '1' when ansid=268380 then '10' when ansid=268381 then '1' when ansid=268382 then 'Counselor' when ansid=268383 then '1' when ansid=268384 then '' when ansid=268385 then '1' when ansid=268386 then '1' when ansid=268387 then 'Counsellor was not understanding about information to be filled in the column no.6' when ansid=268388 then '2' when ansid=268389 then '1' when ansid=268390 then '1' when ansid=268391 then '1' when ansid=268392 then '1' when ansid=268393 then '1' when ansid=268394 then '1' when ansid=268395 then '1' when ansid=268396 then '1' when ansid=268397 then '3' when ansid=268398 then '1' when ansid=268399 then '1' when ansid=268400 then '1' when ansid=268401 then '' when ansid=268402 then '1' when ansid=268403 then '1' when ansid=268404 then '1' when ansid=268405 then '1' when ansid=268406 then '1' when ansid=268407 then '0' when ansid=268408 then 'NIL' when ansid=268409 then 'No' when ansid=268410 then 'NIL' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 21:05:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268362','268364','268366','268368','268370','268372','268373','268374','268375','268376','268377','268378','268379','268380','268381','268382','268383','268384','268385','268386','268387','268388','268389','268390','268391','268392','268393','268394','268395','268396','268397','268398','268399','268400','268401','268402','268403','268404','268405','268406','268407','268408','268409','268410')"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE supvisstepid = '13954'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE visitfeedbackid = '13926'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE visitfeedbackid = '13927'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE visitfeedbackid = '13928'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE visitfeedbackid = '13929'"} {"userId":"57","date":"2023-04-24 21:05:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:05:33' WHERE visitfeedbackid = '13930'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE sitesupervision SET `siteid` = '1062', `userid` = '57', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-04-13', `numofsamplecollected` = '13', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '3', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '166', `undertrialprisoners` = '569', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2830'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amarjit Metei', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE onssid = '11648'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'A Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE onssid = '11649'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE onsitestaffs SET `staffname` = 'Sunita Devi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE onssid = '11650'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE onssid = '11651'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268362 then '1' when ansid=268364 then '1' when ansid=268366 then '1' when ansid=268368 then '3' when ansid=268370 then '5' when ansid=268372 then '3' when ansid=268373 then '0' when ansid=268374 then '' when ansid=268375 then '1' when ansid=268376 then '' when ansid=268377 then '1' when ansid=268378 then '' when ansid=268379 then '1' when ansid=268380 then '10' when ansid=268381 then '1' when ansid=268382 then 'Counselor' when ansid=268383 then '1' when ansid=268384 then '' when ansid=268385 then '1' when ansid=268386 then '1' when ansid=268387 then 'Counsellor was not understanding about information to be filled in the column no.6' when ansid=268388 then '2' when ansid=268389 then '1' when ansid=268390 then '1' when ansid=268391 then '1' when ansid=268392 then '1' when ansid=268393 then '1' when ansid=268394 then '1' when ansid=268395 then '1' when ansid=268396 then '1' when ansid=268397 then '3' when ansid=268398 then '1' when ansid=268399 then '1' when ansid=268400 then '1' when ansid=268401 then '' when ansid=268402 then '1' when ansid=268403 then '1' when ansid=268404 then '1' when ansid=268405 then '1' when ansid=268406 then '1' when ansid=268407 then '0' when ansid=268408 then 'NIL' when ansid=268409 then 'No' when ansid=268410 then 'NIL' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.18.74.24',\r\n\t\t\t\t\t\t\t\tmodifiedby =57,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-04-24 21:06:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268362','268364','268366','268368','268370','268372','268373','268374','268375','268376','268377','268378','268379','268380','268381','268382','268383','268384','268385','268386','268387','268388','268389','268390','268391','268392','268393','268394','268395','268396','268397','268398','268399','268400','268401','268402','268403','268404','268405','268406','268407','268408','268409','268410')"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE supvisstepid = '13955'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE visitfeedback SET `feedback` = 'Counsellor was not understanding about information to be filled in the column no.6. Onsite training was given.', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE visitfeedbackid = '13926'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE visitfeedbackid = '13927'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE visitfeedbackid = '13928'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE visitfeedbackid = '13929'"} {"userId":"57","date":"2023-04-24 21:06:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.18.74.24', `modifiedby` = '57', `modifieddate` = '2023-04-24 21:06:32' WHERE visitfeedbackid = '13930'"}