{"userId":"631","date":"2023-09-10 12:01:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('631', '117.222.198.141', '2023-09-10 12:01:49')"} {"userId":"631","date":"2023-09-10 12:02:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('2062', '2023-09-09', '631', '117.222.198.141', '631', '2023-09-10 12:02:36')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('2062', '3298', '631', '2023-09-10', '1', '117.222.198.141', '631', '2023-09-10 12:02:46', '', '')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '0', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '1', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '2', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '3', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '4', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '5', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2833', '6', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2833', '', '', 'Array', '', 'Array', '', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2833', '', '', 'Array', '', 'Array', '', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2833', '', '', 'Array', '', 'Array', '', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2833', '', '', 'Array', '', 'Array', '', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('184', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('185', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('186', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('187', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('188', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('189', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('190', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('191', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('192', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('193', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('194', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('195', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('196', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('197', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('198', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('199', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('200', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('201', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('202', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('203', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('204', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('205', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('206', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('207', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('208', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('209', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('210', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('211', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('212', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('213', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('214', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('215', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('216', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('217', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('218', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('219', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('220', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('221', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('222', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('223', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('224', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('225', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('226', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('227', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('228', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('229', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('230', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('231', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('232', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('233', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('234', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('235', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('236', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('237', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('238', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('239', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('240', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('241', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('242', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('243', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('244', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('245', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('246', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('247', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('248', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('249', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('250', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('251', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('252', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('253', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('254', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('255', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('256', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('257', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('258', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('259', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('260', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('261', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('262', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('263', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('264', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('265', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('266', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('267', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('268', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('269', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('270', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('271', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('272', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('273', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('274', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('275', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('276', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('277', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('280', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('281', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('282', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('283', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('284', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('285', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('286', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('287', '2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2833', '117.222.198.141', '631', '2023-09-10 12:02:46')"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '' when ansid=268646 then '' when ansid=268647 then '' when ansid=268648 then '' when ansid=268649 then '' when ansid=268650 then '' when ansid=268651 then '' when ansid=268652 then '' when ansid=268653 then '' when ansid=268654 then '' when ansid=268655 then '' when ansid=268656 then '' when ansid=268657 then '' when ansid=268658 then '' when ansid=268721 then '' when ansid=268722 then '' when ansid=268723 then '' when ansid=268724 then '' when ansid=268725 then '' when ansid=268726 then '' when ansid=268659 then '' when ansid=268660 then '' when ansid=268661 then '' when ansid=268662 then '' when ansid=268663 then '' when ansid=268664 then '' when ansid=268665 then '' when ansid=268666 then '' when ansid=268667 then '' when ansid=268668 then '' when ansid=268669 then '' when ansid=268670 then '' when ansid=268671 then '' when ansid=268672 then '' when ansid=268673 then '' when ansid=268674 then '' when ansid=268675 then '' when ansid=268676 then '' when ansid=268677 then '' when ansid=268678 then '' when ansid=268679 then '' when ansid=268680 then '' when ansid=268681 then '' when ansid=268682 then '' when ansid=268683 then '' when ansid=268684 then '' when ansid=268685 then '' when ansid=268686 then '' when ansid=268687 then '' when ansid=268688 then '' when ansid=268689 then '' when ansid=268690 then '' when ansid=268691 then '' when ansid=268692 then '' when ansid=268693 then '' when ansid=268694 then '' when ansid=268695 then '' when ansid=268696 then '' when ansid=268697 then '' when ansid=268698 then '' when ansid=268699 then '' when ansid=268700 then '' when ansid=268701 then '' when ansid=268702 then '' when ansid=268703 then '' when ansid=268704 then '' when ansid=268705 then '' when ansid=268706 then '' when ansid=268707 then '' when ansid=268708 then '' when ansid=268727 then '' when ansid=268728 then '' when ansid=268709 then '' when ansid=268710 then '' when ansid=268711 then '' when ansid=268712 then '' when ansid=268713 then '' when ansid=268714 then '' when ansid=268715 then '' when ansid=268716 then '' when ansid=268717 then '' when ansid=268718 then '' when ansid=268719 then '' when ansid=268720 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:15:37'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE supvisstepid = '13966'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:15:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:37' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then '' when ansid=268648 then '' when ansid=268649 then '' when ansid=268650 then '' when ansid=268651 then '' when ansid=268652 then '' when ansid=268653 then '' when ansid=268654 then '' when ansid=268655 then '' when ansid=268656 then '' when ansid=268657 then '' when ansid=268658 then '' when ansid=268721 then '' when ansid=268722 then '' when ansid=268723 then '' when ansid=268724 then '' when ansid=268725 then '' when ansid=268726 then '' when ansid=268659 then '' when ansid=268660 then '' when ansid=268661 then '' when ansid=268662 then '' when ansid=268663 then '' when ansid=268664 then '' when ansid=268665 then '' when ansid=268666 then '' when ansid=268667 then '' when ansid=268668 then '' when ansid=268669 then '' when ansid=268670 then '' when ansid=268671 then '' when ansid=268672 then '' when ansid=268673 then '' when ansid=268674 then '' when ansid=268675 then '' when ansid=268676 then '' when ansid=268677 then '' when ansid=268678 then '' when ansid=268679 then '' when ansid=268680 then '' when ansid=268681 then '' when ansid=268682 then '' when ansid=268683 then '' when ansid=268684 then '' when ansid=268685 then '' when ansid=268686 then '' when ansid=268687 then '' when ansid=268688 then '' when ansid=268689 then '' when ansid=268690 then '' when ansid=268691 then '' when ansid=268692 then '' when ansid=268693 then '' when ansid=268694 then '' when ansid=268695 then '' when ansid=268696 then '' when ansid=268697 then '' when ansid=268698 then '' when ansid=268699 then '' when ansid=268700 then '' when ansid=268701 then '' when ansid=268702 then '' when ansid=268703 then '' when ansid=268704 then '' when ansid=268705 then '' when ansid=268706 then '' when ansid=268707 then '' when ansid=268708 then '' when ansid=268727 then '' when ansid=268728 then '' when ansid=268709 then '' when ansid=268710 then '' when ansid=268711 then '' when ansid=268712 then '' when ansid=268713 then '' when ansid=268714 then '' when ansid=268715 then '' when ansid=268716 then '' when ansid=268717 then '' when ansid=268718 then '' when ansid=268719 then '' when ansid=268720 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:15:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE supvisstepid = '13967'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:15:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:15:51' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then 'COMB\\'S TEST' when ansid=268648 then 'ARKRAY HEALTH CARE' when ansid=268649 then '4224' when ansid=268650 then '40000' when ansid=268651 then '6\/8\/24' when ansid=268652 then '2-8 C' when ansid=268653 then 'COMB\\'S TEST' when ansid=268654 then 'ARKRAY HEALTH CARE' when ansid=268655 then '4224' when ansid=268656 then '27510' when ansid=268657 then '6\/8\/24' when ansid=268658 then '2-8 C' when ansid=268721 then 'TPHA' when ansid=268722 then 'VIMEK BIOCONCEPT' when ansid=268723 then '4800' when ansid=268724 then '23021' when ansid=268725 then '7\/2024' when ansid=268726 then '2-8 C' when ansid=268659 then 'NA' when ansid=268660 then 'NA' when ansid=268661 then '00' when ansid=268662 then '00' when ansid=268663 then 'NA' when ansid=268664 then 'NA' when ansid=268665 then 'RAPID CARD TEST' when ansid=268666 then 'AVANTAR PERFORMANCE' when ansid=268667 then '4200' when ansid=268668 then '30122' when ansid=268669 then '08\/2024' when ansid=268670 then '2-8 C' when ansid=268671 then 'Q-LINE RAPID' when ansid=268672 then 'Q-LINE BIOKEN' when ansid=268673 then '4225' when ansid=268674 then '12016' when ansid=268675 then '11\/2024' when ansid=268676 then '2-8 C' when ansid=268677 then 'RPR NOT DONE AND HIV 1 AND 2 IN COMBOS KIT,TPHA AVAILABILITY WAS VERY DELAYED' when ansid=268678 then '' when ansid=268679 then '' when ansid=268680 then '' when ansid=268681 then '' when ansid=268682 then '' when ansid=268683 then '' when ansid=268684 then '' when ansid=268685 then '' when ansid=268686 then '' when ansid=268687 then '' when ansid=268688 then '' when ansid=268689 then '' when ansid=268690 then '' when ansid=268691 then '' when ansid=268692 then '' when ansid=268693 then '' when ansid=268694 then '' when ansid=268695 then '' when ansid=268696 then '' when ansid=268697 then '' when ansid=268698 then '' when ansid=268699 then '' when ansid=268700 then '' when ansid=268701 then '' when ansid=268702 then '' when ansid=268703 then '' when ansid=268704 then '' when ansid=268705 then '' when ansid=268706 then '' when ansid=268707 then '' when ansid=268708 then '' when ansid=268727 then '' when ansid=268728 then '' when ansid=268709 then '' when ansid=268710 then '' when ansid=268711 then '' when ansid=268712 then '' when ansid=268713 then '' when ansid=268714 then '' when ansid=268715 then '' when ansid=268716 then '' when ansid=268717 then '' when ansid=268718 then '' when ansid=268719 then '' when ansid=268720 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:27:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE supvisstepid = '13968'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:27:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:27:11' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then 'COMB\\'S TEST' when ansid=268648 then 'ARKRAY HEALTH CARE' when ansid=268649 then '4224' when ansid=268650 then '40000' when ansid=268651 then '6\/8\/24' when ansid=268652 then '2-8 C' when ansid=268653 then 'COMB\\'S TEST' when ansid=268654 then 'ARKRAY HEALTH CARE' when ansid=268655 then '4224' when ansid=268656 then '27510' when ansid=268657 then '6\/8\/24' when ansid=268658 then '2-8 C' when ansid=268721 then 'TPHA' when ansid=268722 then 'VIMEK BIOCONCEPT' when ansid=268723 then '4800' when ansid=268724 then '23021' when ansid=268725 then '7\/2024' when ansid=268726 then '2-8 C' when ansid=268659 then 'NA' when ansid=268660 then 'NA' when ansid=268661 then '00' when ansid=268662 then '00' when ansid=268663 then 'NA' when ansid=268664 then 'NA' when ansid=268665 then 'RAPID CARD TEST' when ansid=268666 then 'AVANTAR PERFORMANCE' when ansid=268667 then '4200' when ansid=268668 then '30122' when ansid=268669 then '08\/2024' when ansid=268670 then '2-8 C' when ansid=268671 then 'Q-LINE RAPID' when ansid=268672 then 'Q-LINE BIOKEN' when ansid=268673 then '4225' when ansid=268674 then '12016' when ansid=268675 then '11\/2024' when ansid=268676 then '2-8 C' when ansid=268677 then 'RPR NOT DONE AND HIV 1 AND 2 IN COMBOS KIT,TPHA AVAILABILITY WAS VERY DELAYED' when ansid=268678 then '1' when ansid=268679 then '1' when ansid=268680 then '1' when ansid=268681 then '1' when ansid=268682 then '1' when ansid=268683 then '1' when ansid=268684 then '1' when ansid=268685 then 'ALL ARE AVAILABLE ONLINE IN SOFT COPIES ,NO HARD COPY WAS AVAILABLE' when ansid=268686 then '' when ansid=268687 then '' when ansid=268688 then '' when ansid=268689 then '' when ansid=268690 then '' when ansid=268691 then '' when ansid=268692 then '' when ansid=268693 then '' when ansid=268694 then '' when ansid=268695 then '' when ansid=268696 then '' when ansid=268697 then '' when ansid=268698 then '' when ansid=268699 then '' when ansid=268700 then '' when ansid=268701 then '' when ansid=268702 then '' when ansid=268703 then '' when ansid=268704 then '' when ansid=268705 then '' when ansid=268706 then '' when ansid=268707 then '' when ansid=268708 then '' when ansid=268727 then '' when ansid=268728 then '' when ansid=268709 then '' when ansid=268710 then '' when ansid=268711 then '' when ansid=268712 then '' when ansid=268713 then '' when ansid=268714 then '' when ansid=268715 then '' when ansid=268716 then '' when ansid=268717 then '' when ansid=268718 then '' when ansid=268719 then '' when ansid=268720 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:28:41'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE supvisstepid = '13969'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:28:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:28:41' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then 'COMB\\'S TEST' when ansid=268648 then 'ARKRAY HEALTH CARE' when ansid=268649 then '4224' when ansid=268650 then '40000' when ansid=268651 then '6\/8\/24' when ansid=268652 then '2-8 C' when ansid=268653 then 'COMB\\'S TEST' when ansid=268654 then 'ARKRAY HEALTH CARE' when ansid=268655 then '4224' when ansid=268656 then '27510' when ansid=268657 then '6\/8\/24' when ansid=268658 then '2-8 C' when ansid=268721 then 'TPHA' when ansid=268722 then 'VIMEK BIOCONCEPT' when ansid=268723 then '4800' when ansid=268724 then '23021' when ansid=268725 then '7\/2024' when ansid=268726 then '2-8 C' when ansid=268659 then 'NA' when ansid=268660 then 'NA' when ansid=268661 then '00' when ansid=268662 then '00' when ansid=268663 then 'NA' when ansid=268664 then 'NA' when ansid=268665 then 'RAPID CARD TEST' when ansid=268666 then 'AVANTAR PERFORMANCE' when ansid=268667 then '4200' when ansid=268668 then '30122' when ansid=268669 then '08\/2024' when ansid=268670 then '2-8 C' when ansid=268671 then 'Q-LINE RAPID' when ansid=268672 then 'Q-LINE BIOKEN' when ansid=268673 then '4225' when ansid=268674 then '12016' when ansid=268675 then '11\/2024' when ansid=268676 then '2-8 C' when ansid=268677 then 'RPR NOT DONE AND HIV 1 AND 2 IN COMBOS KIT,TPHA AVAILABILITY WAS VERY DELAYED' when ansid=268678 then '1' when ansid=268679 then '1' when ansid=268680 then '1' when ansid=268681 then '1' when ansid=268682 then '1' when ansid=268683 then '1' when ansid=268684 then '1' when ansid=268685 then 'ALL ARE AVAILABLE ONLINE IN SOFT COPIES ,NO HARD COPY WAS AVAILABLE' when ansid=268686 then '01\/01\/23' when ansid=268687 then '31\/03\/23' when ansid=268688 then '3200' when ansid=268689 then '3200' when ansid=268690 then '3' when ansid=268691 then '01' when ansid=268692 then '00' when ansid=268693 then '20' when ansid=268694 then '00' when ansid=268695 then '20' when ansid=268696 then '42' when ansid=268697 then '400' when ansid=268698 then '400' when ansid=268699 then '00' when ansid=268700 then '15' when ansid=268701 then '00' when ansid=268702 then '44' when ansid=268703 then '00' when ansid=268704 then '05' when ansid=268705 then '48' when ansid=268706 then '1' when ansid=268707 then '' when ansid=268708 then '' when ansid=268727 then '' when ansid=268728 then '' when ansid=268709 then '' when ansid=268710 then '' when ansid=268711 then '' when ansid=268712 then '' when ansid=268713 then '' when ansid=268714 then '' when ansid=268715 then '' when ansid=268716 then '' when ansid=268717 then '' when ansid=268718 then '' when ansid=268719 then '' when ansid=268720 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:32:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE supvisstepid = '13970'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:32:19' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then 'COMB\\'S TEST' when ansid=268648 then 'ARKRAY HEALTH CARE' when ansid=268649 then '4224' when ansid=268650 then '40000' when ansid=268651 then '6\/8\/24' when ansid=268652 then '2-8 C' when ansid=268653 then 'COMB\\'S TEST' when ansid=268654 then 'ARKRAY HEALTH CARE' when ansid=268655 then '4224' when ansid=268656 then '27510' when ansid=268657 then '6\/8\/24' when ansid=268658 then '2-8 C' when ansid=268721 then 'TPHA' when ansid=268722 then 'VIMEK BIOCONCEPT' when ansid=268723 then '4800' when ansid=268724 then '23021' when ansid=268725 then '7\/2024' when ansid=268726 then '2-8 C' when ansid=268659 then 'NA' when ansid=268660 then 'NA' when ansid=268661 then '00' when ansid=268662 then '00' when ansid=268663 then 'NA' when ansid=268664 then 'NA' when ansid=268665 then 'RAPID CARD TEST' when ansid=268666 then 'AVANTAR PERFORMANCE' when ansid=268667 then '4200' when ansid=268668 then '30122' when ansid=268669 then '08\/2024' when ansid=268670 then '2-8 C' when ansid=268671 then 'Q-LINE RAPID' when ansid=268672 then 'Q-LINE BIOKEN' when ansid=268673 then '4225' when ansid=268674 then '12016' when ansid=268675 then '11\/2024' when ansid=268676 then '2-8 C' when ansid=268677 then 'RPR NOT DONE AND HIV 1 AND 2 IN COMBOS KIT,TPHA AVAILABILITY WAS VERY DELAYED' when ansid=268678 then '1' when ansid=268679 then '1' when ansid=268680 then '1' when ansid=268681 then '1' when ansid=268682 then '1' when ansid=268683 then '1' when ansid=268684 then '1' when ansid=268685 then 'ALL ARE AVAILABLE ONLINE IN SOFT COPIES ,NO HARD COPY WAS AVAILABLE' when ansid=268686 then '01\/01\/23' when ansid=268687 then '31\/03\/23' when ansid=268688 then '3200' when ansid=268689 then '3200' when ansid=268690 then '3' when ansid=268691 then '01' when ansid=268692 then '00' when ansid=268693 then '20' when ansid=268694 then '00' when ansid=268695 then '20' when ansid=268696 then '42' when ansid=268697 then '400' when ansid=268698 then '400' when ansid=268699 then '00' when ansid=268700 then '15' when ansid=268701 then '00' when ansid=268702 then '44' when ansid=268703 then '00' when ansid=268704 then '05' when ansid=268705 then '48' when ansid=268706 then '1' when ansid=268707 then '1' when ansid=268708 then '1' when ansid=268727 then '3600' when ansid=268728 then '64' when ansid=268709 then '00' when ansid=268710 then '1' when ansid=268711 then '1' when ansid=268712 then '1' when ansid=268713 then 'LAB TECHNICIAN' when ansid=268714 then 'LAB INCHARGE' when ansid=268715 then 'BY ONLINE ENTRY' when ansid=268716 then '1' when ansid=268717 then '1' when ansid=268718 then '1' when ansid=268719 then '1-DUE TO DELAY AVAILABILITY OF TPHA TEST KIT ,AGAIN HE HAS TO APPLIED FOR TPHA TEST AFTER STORAGE,.2- FACED STORAGE PROBLEMS DUE TO MISMATHCED SIZE OF STAND AND VIALS3.THEY USE THERMACOL BOXES ,ANY HOW THEY PUT THE VIALA IN THAT BOXES .' when ansid=268720 then 'PLEASE ARRANGE ALL THE LOGISTICS BEFORE THE START OF PROGRAMME AS PER SITE \/LAB REQUIRMENT.ONCE PROGRAMME STARTE IT IS VERY DEFFICULT TO MANAGE,AND IT CAN AFFECT QUALITY.' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:40:10'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE supvisstepid = '13971'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:40:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:40:10' WHERE visitfeedbackid = '13945'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE sitesupervision SET `siteid` = '2062', `userid` = '631', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '3600', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2833'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE onsitestaffs SET `staffname` = 'DR USHA BHATT', `staffdesigid` = '11', `isavailable` = '1', `exphss` = '15', `istrained` = '0', `remarks` = 'ON THE TRAINING DAY WAS NOT PRESENT', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE onssid = '11660'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE onsitestaffs SET `staffname` = 'MR DALIP SINGH', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE onssid = '11661'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE onssid = '11662'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE onssid = '11663'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=268627 then '7' when ansid=268628 then '2008' when ansid=268629 then '3600' when ansid=268630 then 'CHC JASPUR.district female hospital ,almora,DH BAGESHWER,CHC BAIJNZTH,CHC KHATIMA,CHC LOHAGHAT,FH HALDWANI,COMBINED HOSPITAL RAMNAGAR,DFH,PITHORAGHARH,DH RUDRAPUR,SUBDISTRICT JAIL HALDWANI' when ansid=268631 then '3600' when ansid=268632 then 'ONE SAMPLE FROM CHC JASPUR WAS HEMOLYSED AND TWO SAMPLE DROM DFH ALMORA WERE MISSING' when ansid=268633 then 'NA' when ansid=268634 then '00' when ansid=268635 then '' when ansid=268636 then 'NA' when ansid=268637 then '00' when ansid=268638 then '' when ansid=268639 then 'NA' when ansid=268640 then '00' when ansid=268641 then '' when ansid=268642 then 'NA' when ansid=268643 then '00' when ansid=268644 then '' when ansid=268645 then '1' when ansid=268646 then '1' when ansid=268647 then 'COMB\\'S TEST' when ansid=268648 then 'ARKRAY HEALTH CARE' when ansid=268649 then '4224' when ansid=268650 then '40000' when ansid=268651 then '6\/8\/24' when ansid=268652 then '2-8 C' when ansid=268653 then 'COMB\\'S TEST' when ansid=268654 then 'ARKRAY HEALTH CARE' when ansid=268655 then '4224' when ansid=268656 then '27510' when ansid=268657 then '6\/8\/24' when ansid=268658 then '2-8 C' when ansid=268721 then 'TPHA' when ansid=268722 then 'VIMEK BIOCONCEPT' when ansid=268723 then '4800' when ansid=268724 then '23021' when ansid=268725 then '7\/2024' when ansid=268726 then '2-8 C' when ansid=268659 then 'NA' when ansid=268660 then 'NA' when ansid=268661 then '00' when ansid=268662 then '00' when ansid=268663 then 'NA' when ansid=268664 then 'NA' when ansid=268665 then 'RAPID CARD TEST' when ansid=268666 then 'AVANTAR PERFORMANCE' when ansid=268667 then '4200' when ansid=268668 then '30122' when ansid=268669 then '08\/2024' when ansid=268670 then '2-8 C' when ansid=268671 then 'Q-LINE RAPID' when ansid=268672 then 'Q-LINE BIOKEN' when ansid=268673 then '4225' when ansid=268674 then '12016' when ansid=268675 then '11\/2024' when ansid=268676 then '2-8 C' when ansid=268677 then 'RPR NOT DONE AND HIV 1 AND 2 IN COMBOS KIT,TPHA AVAILABILITY WAS VERY DELAYED' when ansid=268678 then '1' when ansid=268679 then '1' when ansid=268680 then '1' when ansid=268681 then '1' when ansid=268682 then '1' when ansid=268683 then '1' when ansid=268684 then '1' when ansid=268685 then 'ALL ARE AVAILABLE ONLINE IN SOFT COPIES ,NO HARD COPY WAS AVAILABLE' when ansid=268686 then '01\/01\/23' when ansid=268687 then '31\/03\/23' when ansid=268688 then '3200' when ansid=268689 then '3200' when ansid=268690 then '3' when ansid=268691 then '01' when ansid=268692 then '00' when ansid=268693 then '20' when ansid=268694 then '00' when ansid=268695 then '20' when ansid=268696 then '42' when ansid=268697 then '400' when ansid=268698 then '400' when ansid=268699 then '00' when ansid=268700 then '15' when ansid=268701 then '00' when ansid=268702 then '44' when ansid=268703 then '00' when ansid=268704 then '05' when ansid=268705 then '48' when ansid=268706 then '1' when ansid=268707 then '1' when ansid=268708 then '1' when ansid=268727 then '3600' when ansid=268728 then '64' when ansid=268709 then '00' when ansid=268710 then '1' when ansid=268711 then '1' when ansid=268712 then '1' when ansid=268713 then 'LAB TECHNICIAN' when ansid=268714 then 'LAB INCHARGE' when ansid=268715 then 'BY ONLINE ENTRY' when ansid=268716 then '1' when ansid=268717 then '1' when ansid=268718 then '1' when ansid=268719 then '1-DUE TO DELAY AVAILABILITY OF TPHA TEST KIT ,AGAIN HE HAS TO APPLIED FOR TPHA TEST AFTER STORAGE,.2- FACED STORAGE PROBLEMS DUE TO MISMATHCED SIZE OF STAND AND VIALS3.THEY USE THERMACOL BOXES ,ANY HOW THEY PUT THE VIALA IN THAT BOXES .' when ansid=268720 then 'PLEASE ARRANGE ALL THE LOGISTICS BEFORE THE START OF PROGRAMME AS PER SITE \/LAB REQUIRMENT.ONCE PROGRAMME STARTE IT IS VERY DEFFICULT TO MANAGE,AND IT CAN AFFECT QUALITY.' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '117.222.198.141',\r\n\t\t\t\t\t\t\t\tmodifiedby =631,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-09-10 12:50:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('268627','268628','268629','268630','268631','268632','268633','268634','268635','268636','268637','268638','268639','268640','268641','268642','268643','268644','268645','268646','268647','268648','268649','268650','268651','268652','268653','268654','268655','268656','268657','268658','268721','268722','268723','268724','268725','268726','268659','268660','268661','268662','268663','268664','268665','268666','268667','268668','268669','268670','268671','268672','268673','268674','268675','268676','268677','268678','268679','268680','268681','268682','268683','268684','268685','268686','268687','268688','268689','268690','268691','268692','268693','268694','268695','268696','268697','268698','268699','268700','268701','268702','268703','268704','268705','268706','268707','268708','268727','268728','268709','268710','268711','268712','268713','268714','268715','268716','268717','268718','268719','268720')"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE supvisstepid = '13972'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE visitfeedback SET `feedback` = 'DELAYED AVAILABILTY OF LOGISTICS ,BUT SOME HOW THEY MANAGED THAT BY USING THE OTHER RESOURCES', `recommendation` = 'THERE SHOULD BE PREPLANNING OF LOGISTICS REQUIRED FOR THE WHOLE ACTIVITY AND SHOULD ARRANGE BEFOREHAND THE START OF PROGRAMME.', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE visitfeedbackid = '13941'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE visitfeedback SET `feedback` = 'STORAGE BOX OF PROPER SIZE NOT AVAILABLE ,,,THEY USED THE BOXES OF THERMACOL OF COVID -19 PROGRAMME.', `recommendation` = 'MONITORING OF CENTERS SHOULD BE DONE AT THE EARLY DURING THE PROGRAMME ,AND REQUIRED LOGISTICTS AHOULD BE ARRANGE AS SOON AS POSIIBLE AND THEN FOLLOWUP VISITS ALSO NEEDED.', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE visitfeedbackid = '13942'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE visitfeedbackid = '13943'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE visitfeedbackid = '13944'"} {"userId":"631","date":"2023-09-10 12:50:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.222.198.141', `modifiedby` = '631', `modifieddate` = '2023-09-10 12:50:33' WHERE visitfeedbackid = '13945'"}