{"userId":"628","date":"2023-01-08 10:41:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('628', '223.181.32.194', '2023-01-08 10:41:44')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1853', '2847', '628', '2023-01-08', '1', '223.181.32.194', '628', '2023-01-08 10:42:53', '', '')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2457', '0', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2457', '1', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2457', '2', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2457', '3', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2457', '4', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2457', '', '', 'Array', '', 'Array', '', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2457', '', '', 'Array', '', 'Array', '', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2457', '', '', 'Array', '', 'Array', '', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2457', '', '', 'Array', '', 'Array', '', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:42:53","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2457', '223.181.32.194', '628', '2023-01-08 10:42:53')"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '' when ansid=228237 then '' when ansid=228238 then '' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then ''   when ansid=228242 then ''  when ansid=228342 then '' when ansid=228343 then '' when ansid=228285 then '' when ansid=228287 then '' when ansid=228289 then '' when ansid=228291 then '' when ansid=228293 then '' when ansid=228295 then '' when ansid=228296 then '' when ansid=228297 then '' when ansid=228298 then ''  when ansid=228299 then ''   when ansid=228300 then ''  when ansid=228301 then ''  when ansid=228302 then ''   when ansid=228303 then ''   when ansid=228304 then ''   when ansid=228305 then ''  when ansid=228306 then '' when ansid=228307 then '' when ansid=228308 then ''  when ansid=228309 then ''   when ansid=228310 then ''   when ansid=228311 then ''   when ansid=228312 then ''  when ansid=228313 then ''  when ansid=228314 then ''   when ansid=228315 then ''  when ansid=228316 then '' when ansid=228317 then '' when ansid=228318 then '' when ansid=228319 then '' when ansid=228320 then '' when ansid=228321 then '' when ansid=228322 then '' when ansid=228323 then '' when ansid=228324 then ''  when ansid=228325 then ''   when ansid=228326 then ''   when ansid=228327 then ''   when ansid=228328 then ''  when ansid=228329 then '' when ansid=228330 then ''  when ansid=228331 then ''   when ansid=228332 then ''  when ansid=228333 then '' when ansid=228334 then '' when ansid=228335 then '' when ansid=228336 then '' when ansid=228337 then '' when ansid=228338 then '' when ansid=228339 then '' when ansid=228340 then '' when ansid=228341 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 10:45:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE supvisstepid = '12157'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 10:45:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:45:20' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '' when ansid=228287 then '' when ansid=228289 then '' when ansid=228291 then '' when ansid=228293 then '' when ansid=228295 then '' when ansid=228296 then '' when ansid=228297 then '' when ansid=228298 then ''  when ansid=228299 then ''   when ansid=228300 then ''  when ansid=228301 then ''  when ansid=228302 then ''   when ansid=228303 then ''   when ansid=228304 then ''   when ansid=228305 then ''  when ansid=228306 then '' when ansid=228307 then '' when ansid=228308 then ''  when ansid=228309 then ''   when ansid=228310 then ''   when ansid=228311 then ''   when ansid=228312 then ''  when ansid=228313 then ''  when ansid=228314 then ''   when ansid=228315 then ''  when ansid=228316 then '' when ansid=228317 then '' when ansid=228318 then '' when ansid=228319 then '' when ansid=228320 then '' when ansid=228321 then '' when ansid=228322 then '' when ansid=228323 then '' when ansid=228324 then ''  when ansid=228325 then ''   when ansid=228326 then ''   when ansid=228327 then ''   when ansid=228328 then ''  when ansid=228329 then '' when ansid=228330 then ''  when ansid=228331 then ''   when ansid=228332 then ''  when ansid=228333 then '' when ansid=228334 then '' when ansid=228335 then '' when ansid=228336 then '' when ansid=228337 then '' when ansid=228338 then '' when ansid=228339 then '' when ansid=228340 then '' when ansid=228341 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 10:46:13'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE supvisstepid = '12158'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 10:46:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:46:13' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '1' when ansid=228287 then '1' when ansid=228289 then '0' when ansid=228291 then '2' when ansid=228293 then '1' when ansid=228295 then '' when ansid=228296 then '' when ansid=228297 then '' when ansid=228298 then ''  when ansid=228299 then ''   when ansid=228300 then ''  when ansid=228301 then ''  when ansid=228302 then ''   when ansid=228303 then ''   when ansid=228304 then ''   when ansid=228305 then ''  when ansid=228306 then '' when ansid=228307 then '' when ansid=228308 then ''  when ansid=228309 then ''   when ansid=228310 then ''   when ansid=228311 then ''   when ansid=228312 then ''  when ansid=228313 then ''  when ansid=228314 then ''   when ansid=228315 then ''  when ansid=228316 then '' when ansid=228317 then '' when ansid=228318 then '' when ansid=228319 then '' when ansid=228320 then '' when ansid=228321 then '' when ansid=228322 then '' when ansid=228323 then '' when ansid=228324 then ''  when ansid=228325 then ''   when ansid=228326 then ''   when ansid=228327 then ''   when ansid=228328 then ''  when ansid=228329 then '' when ansid=228330 then ''  when ansid=228331 then ''   when ansid=228332 then ''  when ansid=228333 then '' when ansid=228334 then '' when ansid=228335 then '' when ansid=228336 then '' when ansid=228337 then '' when ansid=228338 then '' when ansid=228339 then '' when ansid=228340 then '' when ansid=228341 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 10:47:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE supvisstepid = '12159'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 10:47:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 10:47:42' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '1' when ansid=228287 then '1' when ansid=228289 then '0' when ansid=228291 then '2' when ansid=228293 then '1' when ansid=228295 then '6' when ansid=228296 then '3' when ansid=228297 then '6' when ansid=228298 then '12'  when ansid=228299 then ''   when ansid=228300 then '1'  when ansid=228301 then '1'  when ansid=228302 then ''   when ansid=228303 then '1'   when ansid=228304 then ''   when ansid=228305 then '1'  when ansid=228306 then '' when ansid=228307 then '1' when ansid=228308 then '1'  when ansid=228309 then 'Counsellor'   when ansid=228310 then '1'   when ansid=228311 then ''   when ansid=228312 then '1'  when ansid=228313 then '1'  when ansid=228314 then ''   when ansid=228315 then '1'  when ansid=228316 then '3' when ansid=228317 then '1' when ansid=228318 then '1' when ansid=228319 then '1' when ansid=228320 then '1' when ansid=228321 then '2' when ansid=228322 then '1' when ansid=228323 then '1' when ansid=228324 then '1'  when ansid=228325 then 'will dispatch once in 15 days'   when ansid=228326 then '5'   when ansid=228327 then 'will dispatch in thermocol box with gel pack'   when ansid=228328 then '2'  when ansid=228329 then '1' when ansid=228330 then '1'  when ansid=228331 then ''   when ansid=228332 then '1'  when ansid=228333 then '2' when ansid=228334 then '3' when ansid=228335 then '3' when ansid=228336 then '1' when ansid=228337 then '' when ansid=228338 then 'some materials still to be reach' when ansid=228339 then 'No' when ansid=228340 then 'All the colour coded Biomedical Waste Bins\/Bags should be made available with proper segregation of waste' when ansid=228341 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 11:03:10'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE supvisstepid = '12157'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 11:03:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:10' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '1' when ansid=228287 then '1' when ansid=228289 then '0' when ansid=228291 then '2' when ansid=228293 then '1' when ansid=228295 then '6' when ansid=228296 then '3' when ansid=228297 then '6' when ansid=228298 then '12'  when ansid=228299 then ''   when ansid=228300 then '1'  when ansid=228301 then '1'  when ansid=228302 then ''   when ansid=228303 then '1'   when ansid=228304 then ''   when ansid=228305 then '1'  when ansid=228306 then '' when ansid=228307 then '1' when ansid=228308 then '1'  when ansid=228309 then 'Counsellor'   when ansid=228310 then '1'   when ansid=228311 then ''   when ansid=228312 then '1'  when ansid=228313 then '1'  when ansid=228314 then ''   when ansid=228315 then '1'  when ansid=228316 then '3' when ansid=228317 then '1' when ansid=228318 then '1' when ansid=228319 then '1' when ansid=228320 then '1' when ansid=228321 then '2' when ansid=228322 then '1' when ansid=228323 then '1' when ansid=228324 then '1'  when ansid=228325 then 'will dispatch once in 15 days'   when ansid=228326 then '5'   when ansid=228327 then 'will dispatch in thermocol box with gel pack'   when ansid=228328 then '2'  when ansid=228329 then '1' when ansid=228330 then '1'  when ansid=228331 then ''   when ansid=228332 then '1'  when ansid=228333 then '2' when ansid=228334 then '3' when ansid=228335 then '3' when ansid=228336 then '1' when ansid=228337 then '' when ansid=228338 then 'some materials still to be reach' when ansid=228339 then 'No' when ansid=228340 then 'All the colour coded Biomedical Waste Bins\/Bags should be made available with proper segregation of waste' when ansid=228341 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 11:03:25'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE supvisstepid = '12158'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 11:03:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:25' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '1' when ansid=228287 then '1' when ansid=228289 then '0' when ansid=228291 then '2' when ansid=228293 then '1' when ansid=228295 then '6' when ansid=228296 then '3' when ansid=228297 then '6' when ansid=228298 then '12'  when ansid=228299 then ''   when ansid=228300 then '1'  when ansid=228301 then '1'  when ansid=228302 then ''   when ansid=228303 then '1'   when ansid=228304 then ''   when ansid=228305 then '1'  when ansid=228306 then '' when ansid=228307 then '1' when ansid=228308 then '1'  when ansid=228309 then 'Counsellor'   when ansid=228310 then '1'   when ansid=228311 then ''   when ansid=228312 then '1'  when ansid=228313 then '1'  when ansid=228314 then ''   when ansid=228315 then '1'  when ansid=228316 then '3' when ansid=228317 then '1' when ansid=228318 then '1' when ansid=228319 then '1' when ansid=228320 then '1' when ansid=228321 then '2' when ansid=228322 then '1' when ansid=228323 then '1' when ansid=228324 then '1'  when ansid=228325 then 'will dispatch once in 15 days'   when ansid=228326 then '5'   when ansid=228327 then 'will dispatch in thermocol box with gel pack'   when ansid=228328 then '2'  when ansid=228329 then '1' when ansid=228330 then '1'  when ansid=228331 then ''   when ansid=228332 then '1'  when ansid=228333 then '2' when ansid=228334 then '3' when ansid=228335 then '3' when ansid=228336 then '1' when ansid=228337 then '' when ansid=228338 then 'some materials still to be reach' when ansid=228339 then 'No' when ansid=228340 then 'All the colour coded Biomedical Waste Bins\/Bags should be made available with proper segregation of waste' when ansid=228341 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 11:03:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE supvisstepid = '12159'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 11:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:03:29' WHERE visitfeedbackid = '12065'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE sitesupervision SET `siteid` = '1853', `userid` = '628', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-06', `numofsamplecollected` = '00', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2457'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE onsitestaffs SET `staffname` = 'Priya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE onssid = '10156'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE onsitestaffs SET `staffname` = 'Nidhi Bisht', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE onssid = '10157'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE onsitestaffs SET `staffname` = 'Rekha Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE onssid = '10158'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE onssid = '10159'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=228236 then '1' when ansid=228237 then '1' when ansid=228238 then '1' when ansid=228239 then '' when ansid=228240 then ''  when ansid=228241 then '120'   when ansid=228242 then '1'  when ansid=228342 then '1' when ansid=228343 then '1' when ansid=228285 then '1' when ansid=228287 then '1' when ansid=228289 then '0' when ansid=228291 then '2' when ansid=228293 then '1' when ansid=228295 then '6' when ansid=228296 then '3' when ansid=228297 then '6' when ansid=228298 then '12'  when ansid=228299 then ''   when ansid=228300 then '1'  when ansid=228301 then '1'  when ansid=228302 then ''   when ansid=228303 then '1'   when ansid=228304 then ''   when ansid=228305 then '1'  when ansid=228306 then '3' when ansid=228307 then '1' when ansid=228308 then '1'  when ansid=228309 then 'Counsellor'   when ansid=228310 then '1'   when ansid=228311 then ''   when ansid=228312 then '1'  when ansid=228313 then '1'  when ansid=228314 then ''   when ansid=228315 then '1'  when ansid=228316 then '3' when ansid=228317 then '1' when ansid=228318 then '1' when ansid=228319 then '1' when ansid=228320 then '1' when ansid=228321 then '2' when ansid=228322 then '1' when ansid=228323 then '1' when ansid=228324 then '1'  when ansid=228325 then 'will dispatch once in 15 days'   when ansid=228326 then '5'   when ansid=228327 then 'will dispatch in thermocol box with gel pack'   when ansid=228328 then '2'  when ansid=228329 then '1' when ansid=228330 then '1'  when ansid=228331 then ''   when ansid=228332 then '1'  when ansid=228333 then '2' when ansid=228334 then '3' when ansid=228335 then '3' when ansid=228336 then '1' when ansid=228337 then '0' when ansid=228338 then 'some materials still to reach' when ansid=228339 then 'No' when ansid=228340 then 'All the colour coded Biomedical Waste Bins\/Bags should be made available with proper segregation of waste' when ansid=228341 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '223.181.32.194',\r\n\t\t\t\t\t\t\t\tmodifiedby =628,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 11:08:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('228236','228237','228238','228239','228240','228241','228242','228342','228343','228285','228287','228289','228291','228293','228295','228296','228297','228298','228299','228300','228301','228302','228303','228304','228305','228306','228307','228308','228309','228310','228311','228312','228313','228314','228315','228316','228317','228318','228319','228320','228321','228322','228323','228324','228325','228326','228327','228328','228329','228330','228331','228332','228333','228334','228335','228336','228337','228338','228339','228340','228341')"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE supvisstepid = '12160'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE visitfeedbackid = '12061'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE visitfeedbackid = '12062'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE visitfeedbackid = '12063'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE visitfeedbackid = '12064'"}
{"userId":"628","date":"2023-01-08 11:08:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.181.32.194', `modifiedby` = '628', `modifieddate` = '2023-01-08 11:08:11' WHERE visitfeedbackid = '12065'"}
{"userId":"521","date":"2023-01-08 16:46:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '157.47.61.221', '2023-01-08 16:46:07')"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE sitesupervision SET `siteid` = '727', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '27', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2451'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Bharati', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE onssid = '10132'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs JM Jyothi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE onssid = '10133'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Jubeda', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE onssid = '10134'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE onssid = '10135'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227588 then '' when ansid=227589 then '' when ansid=227590 then '' when ansid=227591 then '' when ansid=227592 then ''  when ansid=227593 then ''   when ansid=227594 then ''  when ansid=227694 then '' when ansid=227695 then '' when ansid=227637 then '' when ansid=227639 then '' when ansid=227641 then '' when ansid=227643 then '' when ansid=227645 then '' when ansid=227647 then '' when ansid=227648 then '' when ansid=227649 then '' when ansid=227650 then ''  when ansid=227651 then ''   when ansid=227652 then ''  when ansid=227653 then ''  when ansid=227654 then ''   when ansid=227655 then ''   when ansid=227656 then ''   when ansid=227657 then ''  when ansid=227658 then '' when ansid=227659 then '' when ansid=227660 then ''  when ansid=227661 then ''   when ansid=227662 then ''   when ansid=227663 then ''   when ansid=227664 then ''  when ansid=227665 then ''  when ansid=227666 then ''   when ansid=227667 then ''  when ansid=227668 then '' when ansid=227669 then '' when ansid=227670 then '' when ansid=227671 then '' when ansid=227672 then '' when ansid=227673 then '' when ansid=227674 then '' when ansid=227675 then '' when ansid=227676 then ''  when ansid=227677 then ''   when ansid=227678 then ''   when ansid=227679 then ''   when ansid=227680 then ''  when ansid=227681 then '' when ansid=227682 then ''  when ansid=227683 then ''   when ansid=227684 then ''  when ansid=227685 then '' when ansid=227686 then '' when ansid=227687 then '' when ansid=227688 then '' when ansid=227689 then '' when ansid=227690 then '' when ansid=227691 then '' when ansid=227692 then '' when ansid=227693 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 16:48:41'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227588','227589','227590','227591','227592','227593','227594','227694','227695','227637','227639','227641','227643','227645','227647','227648','227649','227650','227651','227652','227653','227654','227655','227656','227657','227658','227659','227660','227661','227662','227663','227664','227665','227666','227667','227668','227669','227670','227671','227672','227673','227674','227675','227676','227677','227678','227679','227680','227681','227682','227683','227684','227685','227686','227687','227688','227689','227690','227691','227692','227693')"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE supvisstepid = '12127'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE visitfeedbackid = '12031'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE visitfeedbackid = '12032'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE visitfeedbackid = '12033'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE visitfeedbackid = '12034'"}
{"userId":"521","date":"2023-01-08 16:48:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:48:41' WHERE visitfeedbackid = '12035'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE sitesupervision SET `siteid` = '727', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '27', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2451'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Bharati', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE onssid = '10132'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs JM Jyothi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE onssid = '10133'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Jubeda', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE onssid = '10134'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE onssid = '10135'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227588 then '1' when ansid=227589 then '1' when ansid=227590 then '1' when ansid=227591 then '' when ansid=227592 then ''  when ansid=227593 then '705'   when ansid=227594 then '1'  when ansid=227694 then '1' when ansid=227695 then '1' when ansid=227637 then '' when ansid=227639 then '' when ansid=227641 then '' when ansid=227643 then '' when ansid=227645 then '' when ansid=227647 then '' when ansid=227648 then '' when ansid=227649 then '' when ansid=227650 then ''  when ansid=227651 then ''   when ansid=227652 then ''  when ansid=227653 then ''  when ansid=227654 then ''   when ansid=227655 then ''   when ansid=227656 then ''   when ansid=227657 then ''  when ansid=227658 then '' when ansid=227659 then '' when ansid=227660 then ''  when ansid=227661 then ''   when ansid=227662 then ''   when ansid=227663 then ''   when ansid=227664 then ''  when ansid=227665 then ''  when ansid=227666 then ''   when ansid=227667 then ''  when ansid=227668 then '' when ansid=227669 then '' when ansid=227670 then '' when ansid=227671 then '' when ansid=227672 then '' when ansid=227673 then '' when ansid=227674 then '' when ansid=227675 then '' when ansid=227676 then ''  when ansid=227677 then ''   when ansid=227678 then ''   when ansid=227679 then ''   when ansid=227680 then ''  when ansid=227681 then '' when ansid=227682 then ''  when ansid=227683 then ''   when ansid=227684 then ''  when ansid=227685 then '' when ansid=227686 then '' when ansid=227687 then '' when ansid=227688 then '' when ansid=227689 then '' when ansid=227690 then '' when ansid=227691 then '' when ansid=227692 then '' when ansid=227693 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 16:49:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227588','227589','227590','227591','227592','227593','227594','227694','227695','227637','227639','227641','227643','227645','227647','227648','227649','227650','227651','227652','227653','227654','227655','227656','227657','227658','227659','227660','227661','227662','227663','227664','227665','227666','227667','227668','227669','227670','227671','227672','227673','227674','227675','227676','227677','227678','227679','227680','227681','227682','227683','227684','227685','227686','227687','227688','227689','227690','227691','227692','227693')"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE supvisstepid = '12128'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE visitfeedbackid = '12031'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE visitfeedbackid = '12032'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE visitfeedbackid = '12033'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE visitfeedbackid = '12034'"}
{"userId":"521","date":"2023-01-08 16:49:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:20' WHERE visitfeedbackid = '12035'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE sitesupervision SET `siteid` = '727', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '27', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2451'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Bharati', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE onssid = '10132'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs JM Jyothi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE onssid = '10133'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Jubeda', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE onssid = '10134'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE onssid = '10135'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227588 then '1' when ansid=227589 then '1' when ansid=227590 then '1' when ansid=227591 then '' when ansid=227592 then ''  when ansid=227593 then '705'   when ansid=227594 then '1'  when ansid=227694 then '1' when ansid=227695 then '1' when ansid=227637 then '1' when ansid=227639 then '1' when ansid=227641 then '0' when ansid=227643 then '100' when ansid=227645 then '5' when ansid=227647 then '' when ansid=227648 then '' when ansid=227649 then '' when ansid=227650 then ''  when ansid=227651 then ''   when ansid=227652 then ''  when ansid=227653 then ''  when ansid=227654 then ''   when ansid=227655 then ''   when ansid=227656 then ''   when ansid=227657 then ''  when ansid=227658 then '' when ansid=227659 then '' when ansid=227660 then ''  when ansid=227661 then ''   when ansid=227662 then ''   when ansid=227663 then ''   when ansid=227664 then ''  when ansid=227665 then ''  when ansid=227666 then ''   when ansid=227667 then ''  when ansid=227668 then '' when ansid=227669 then '' when ansid=227670 then '' when ansid=227671 then '' when ansid=227672 then '' when ansid=227673 then '' when ansid=227674 then '' when ansid=227675 then '' when ansid=227676 then ''  when ansid=227677 then ''   when ansid=227678 then ''   when ansid=227679 then ''   when ansid=227680 then ''  when ansid=227681 then '' when ansid=227682 then ''  when ansid=227683 then ''   when ansid=227684 then ''  when ansid=227685 then '' when ansid=227686 then '' when ansid=227687 then '' when ansid=227688 then '' when ansid=227689 then '' when ansid=227690 then '' when ansid=227691 then '' when ansid=227692 then '' when ansid=227693 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 16:49:38'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227588','227589','227590','227591','227592','227593','227594','227694','227695','227637','227639','227641','227643','227645','227647','227648','227649','227650','227651','227652','227653','227654','227655','227656','227657','227658','227659','227660','227661','227662','227663','227664','227665','227666','227667','227668','227669','227670','227671','227672','227673','227674','227675','227676','227677','227678','227679','227680','227681','227682','227683','227684','227685','227686','227687','227688','227689','227690','227691','227692','227693')"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE supvisstepid = '12129'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE visitfeedbackid = '12031'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE visitfeedbackid = '12032'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE visitfeedbackid = '12033'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE visitfeedbackid = '12034'"}
{"userId":"521","date":"2023-01-08 16:49:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:49:38' WHERE visitfeedbackid = '12035'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE sitesupervision SET `siteid` = '727', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '27', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2451'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Bharati', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE onssid = '10132'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs JM Jyothi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE onssid = '10133'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Jubeda', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE onssid = '10134'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE onssid = '10135'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227588 then '1' when ansid=227589 then '1' when ansid=227590 then '1' when ansid=227591 then '' when ansid=227592 then ''  when ansid=227593 then '705'   when ansid=227594 then '1'  when ansid=227694 then '1' when ansid=227695 then '1' when ansid=227637 then '1' when ansid=227639 then '1' when ansid=227641 then '0' when ansid=227643 then '100' when ansid=227645 then '5' when ansid=227647 then '27' when ansid=227648 then '1' when ansid=227649 then '210' when ansid=227650 then '210'  when ansid=227651 then ''   when ansid=227652 then '1'  when ansid=227653 then '1'  when ansid=227654 then ''   when ansid=227655 then '1'   when ansid=227656 then ''   when ansid=227657 then '1'  when ansid=227658 then '10' when ansid=227659 then '1' when ansid=227660 then '2'  when ansid=227661 then 'Counsellor'   when ansid=227662 then '1'   when ansid=227663 then ''   when ansid=227664 then '1'  when ansid=227665 then '1'  when ansid=227666 then ''   when ansid=227667 then '1'  when ansid=227668 then '1' when ansid=227669 then '1' when ansid=227670 then '1' when ansid=227671 then '1' when ansid=227672 then '1' when ansid=227673 then '1' when ansid=227674 then '1' when ansid=227675 then '1' when ansid=227676 then '1'  when ansid=227677 then ''   when ansid=227678 then '3'   when ansid=227679 then ''   when ansid=227680 then '1'  when ansid=227681 then '1' when ansid=227682 then '1'  when ansid=227683 then ''   when ansid=227684 then '1'  when ansid=227685 then '1' when ansid=227686 then '3' when ansid=227687 then '3' when ansid=227688 then '1' when ansid=227689 then '0' when ansid=227690 then 'No' when ansid=227691 then 'No' when ansid=227692 then '1. All the staffs are well trained2. All the documentation is properly maintained.3. LT should send only the required quantity of samples to the SRL; the excess can be used for routine testing.4. The site cod sticker should be sticked vertically in the tubes.5. Few efforts can be made for privacy during data collection' when ansid=227693 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 16:59:17'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227588','227589','227590','227591','227592','227593','227594','227694','227695','227637','227639','227641','227643','227645','227647','227648','227649','227650','227651','227652','227653','227654','227655','227656','227657','227658','227659','227660','227661','227662','227663','227664','227665','227666','227667','227668','227669','227670','227671','227672','227673','227674','227675','227676','227677','227678','227679','227680','227681','227682','227683','227684','227685','227686','227687','227688','227689','227690','227691','227692','227693')"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE supvisstepid = '12130'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE visitfeedbackid = '12031'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE visitfeedbackid = '12032'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE visitfeedbackid = '12033'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE visitfeedbackid = '12034'"}
{"userId":"521","date":"2023-01-08 16:59:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 16:59:17' WHERE visitfeedbackid = '12035'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE sitesupervision SET `siteid` = '727', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '27', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2451'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Bharati', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE onssid = '10132'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs JM Jyothi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE onssid = '10133'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Jubeda', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE onssid = '10134'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE onssid = '10135'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227588 then '1' when ansid=227589 then '1' when ansid=227590 then '1' when ansid=227591 then '' when ansid=227592 then ''  when ansid=227593 then '705'   when ansid=227594 then '1'  when ansid=227694 then '1' when ansid=227695 then '1' when ansid=227637 then '1' when ansid=227639 then '1' when ansid=227641 then '0' when ansid=227643 then '100' when ansid=227645 then '5' when ansid=227647 then '27' when ansid=227648 then '1' when ansid=227649 then '210' when ansid=227650 then '210'  when ansid=227651 then ''   when ansid=227652 then '1'  when ansid=227653 then '1'  when ansid=227654 then ''   when ansid=227655 then '1'   when ansid=227656 then ''   when ansid=227657 then '1'  when ansid=227658 then '10' when ansid=227659 then '1' when ansid=227660 then '2'  when ansid=227661 then 'Counsellor'   when ansid=227662 then '1'   when ansid=227663 then ''   when ansid=227664 then '1'  when ansid=227665 then '1'  when ansid=227666 then ''   when ansid=227667 then '1'  when ansid=227668 then '1' when ansid=227669 then '1' when ansid=227670 then '1' when ansid=227671 then '1' when ansid=227672 then '1' when ansid=227673 then '1' when ansid=227674 then '1' when ansid=227675 then '1' when ansid=227676 then '1'  when ansid=227677 then ''   when ansid=227678 then '3'   when ansid=227679 then ''   when ansid=227680 then '1'  when ansid=227681 then '1' when ansid=227682 then '1'  when ansid=227683 then ''   when ansid=227684 then '1'  when ansid=227685 then '1' when ansid=227686 then '3' when ansid=227687 then '3' when ansid=227688 then '1' when ansid=227689 then '0' when ansid=227690 then 'No' when ansid=227691 then 'No' when ansid=227692 then '1. All the staffs are well trained2. All the documentation is properly maintained.3. LT should send only the required quantity of samples to the SRL; the excess can be used for routine testing.4. The site cod sticker should be sticked vertically in the tubes.5. Few efforts can be made for privacy during data collection' when ansid=227693 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 17:13:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227588','227589','227590','227591','227592','227593','227594','227694','227695','227637','227639','227641','227643','227645','227647','227648','227649','227650','227651','227652','227653','227654','227655','227656','227657','227658','227659','227660','227661','227662','227663','227664','227665','227666','227667','227668','227669','227670','227671','227672','227673','227674','227675','227676','227677','227678','227679','227680','227681','227682','227683','227684','227685','227686','227687','227688','227689','227690','227691','227692','227693')"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE supvisstepid = '12131'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE visitfeedback SET `feedback` = 'LT is making only one aliquot, and sending 3 ml sample to SRL and the ANC mother is been pricked again for routine testing.', `recommendation` = 'Again oriented about the guidelines to the LT to make 3 aliquiot , 2 ml to be sent to SRL,  remaining sample for routine testing  and for PPTCT', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE visitfeedbackid = '12031'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE visitfeedback SET `feedback` = 'The site cod sticker were sticked horizontally, which were hiding sample code for few samples', `recommendation` = 'The site cod sticker should be sticked vertically', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE visitfeedbackid = '12032'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE visitfeedback SET `feedback` = 'Privacy was a concern during data collection', `recommendation` = 'It was recommended to arrange screen or a separate  room for it', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE visitfeedbackid = '12033'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE visitfeedbackid = '12034'"}
{"userId":"521","date":"2023-01-08 17:13:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:13:51' WHERE visitfeedbackid = '12035'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '' when ansid=227481 then '' when ansid=227482 then '' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then ''   when ansid=227486 then ''  when ansid=227586 then '' when ansid=227587 then '' when ansid=227529 then '' when ansid=227531 then '' when ansid=227533 then '' when ansid=227535 then '' when ansid=227537 then '' when ansid=227539 then '' when ansid=227540 then '' when ansid=227541 then '' when ansid=227542 then ''  when ansid=227543 then ''   when ansid=227544 then ''  when ansid=227545 then ''  when ansid=227546 then ''   when ansid=227547 then ''   when ansid=227548 then ''   when ansid=227549 then ''  when ansid=227550 then '' when ansid=227551 then '' when ansid=227552 then ''  when ansid=227553 then ''   when ansid=227554 then ''   when ansid=227555 then ''   when ansid=227556 then ''  when ansid=227557 then ''  when ansid=227558 then ''   when ansid=227559 then ''  when ansid=227560 then '' when ansid=227561 then '' when ansid=227562 then '' when ansid=227563 then '' when ansid=227564 then '' when ansid=227565 then '' when ansid=227566 then '' when ansid=227567 then '' when ansid=227568 then ''  when ansid=227569 then ''   when ansid=227570 then ''   when ansid=227571 then ''   when ansid=227572 then ''  when ansid=227573 then '' when ansid=227574 then ''  when ansid=227575 then ''   when ansid=227576 then ''  when ansid=227577 then '' when ansid=227578 then '' when ansid=227579 then '' when ansid=227580 then '' when ansid=227581 then '' when ansid=227582 then '' when ansid=227583 then '' when ansid=227584 then '' when ansid=227585 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 17:14:23'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE supvisstepid = '12122'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 17:14:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:14:23' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '' when ansid=227531 then '' when ansid=227533 then '' when ansid=227535 then '' when ansid=227537 then '' when ansid=227539 then '' when ansid=227540 then '' when ansid=227541 then '' when ansid=227542 then ''  when ansid=227543 then ''   when ansid=227544 then ''  when ansid=227545 then ''  when ansid=227546 then ''   when ansid=227547 then ''   when ansid=227548 then ''   when ansid=227549 then ''  when ansid=227550 then '' when ansid=227551 then '' when ansid=227552 then ''  when ansid=227553 then ''   when ansid=227554 then ''   when ansid=227555 then ''   when ansid=227556 then ''  when ansid=227557 then ''  when ansid=227558 then ''   when ansid=227559 then ''  when ansid=227560 then '' when ansid=227561 then '' when ansid=227562 then '' when ansid=227563 then '' when ansid=227564 then '' when ansid=227565 then '' when ansid=227566 then '' when ansid=227567 then '' when ansid=227568 then ''  when ansid=227569 then ''   when ansid=227570 then ''   when ansid=227571 then ''   when ansid=227572 then ''  when ansid=227573 then '' when ansid=227574 then ''  when ansid=227575 then ''   when ansid=227576 then ''  when ansid=227577 then '' when ansid=227578 then '' when ansid=227579 then '' when ansid=227580 then '' when ansid=227581 then '' when ansid=227582 then '' when ansid=227583 then '' when ansid=227584 then '' when ansid=227585 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 17:15:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE supvisstepid = '12123'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 17:15:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:15:59' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '1' when ansid=227531 then '1' when ansid=227533 then '0' when ansid=227535 then '100' when ansid=227537 then '5' when ansid=227539 then '' when ansid=227540 then '' when ansid=227541 then '' when ansid=227542 then ''  when ansid=227543 then ''   when ansid=227544 then ''  when ansid=227545 then ''  when ansid=227546 then ''   when ansid=227547 then ''   when ansid=227548 then ''   when ansid=227549 then ''  when ansid=227550 then '' when ansid=227551 then '' when ansid=227552 then ''  when ansid=227553 then ''   when ansid=227554 then ''   when ansid=227555 then ''   when ansid=227556 then ''  when ansid=227557 then ''  when ansid=227558 then ''   when ansid=227559 then ''  when ansid=227560 then '' when ansid=227561 then '' when ansid=227562 then '' when ansid=227563 then '' when ansid=227564 then '' when ansid=227565 then '' when ansid=227566 then '' when ansid=227567 then '' when ansid=227568 then ''  when ansid=227569 then ''   when ansid=227570 then ''   when ansid=227571 then ''   when ansid=227572 then ''  when ansid=227573 then '' when ansid=227574 then ''  when ansid=227575 then ''   when ansid=227576 then ''  when ansid=227577 then '' when ansid=227578 then '' when ansid=227579 then '' when ansid=227580 then '' when ansid=227581 then '' when ansid=227582 then '' when ansid=227583 then '' when ansid=227584 then '' when ansid=227585 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.61.221',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 17:16:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE supvisstepid = '12124'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 17:16:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.61.221', `modifiedby` = '521', `modifieddate` = '2023-01-08 17:16:19' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 19:41:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '157.47.53.147', '2023-01-08 19:41:10')"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '1' when ansid=227531 then '1' when ansid=227533 then '0' when ansid=227535 then '100' when ansid=227537 then '5' when ansid=227539 then '' when ansid=227540 then '' when ansid=227541 then '' when ansid=227542 then ''  when ansid=227543 then ''   when ansid=227544 then ''  when ansid=227545 then ''  when ansid=227546 then ''   when ansid=227547 then ''   when ansid=227548 then ''   when ansid=227549 then ''  when ansid=227550 then '' when ansid=227551 then '' when ansid=227552 then ''  when ansid=227553 then ''   when ansid=227554 then ''   when ansid=227555 then ''   when ansid=227556 then ''  when ansid=227557 then ''  when ansid=227558 then ''   when ansid=227559 then ''  when ansid=227560 then '' when ansid=227561 then '' when ansid=227562 then '' when ansid=227563 then '' when ansid=227564 then '' when ansid=227565 then '' when ansid=227566 then '' when ansid=227567 then '' when ansid=227568 then ''  when ansid=227569 then ''   when ansid=227570 then ''   when ansid=227571 then ''   when ansid=227572 then ''  when ansid=227573 then '' when ansid=227574 then ''  when ansid=227575 then ''   when ansid=227576 then ''  when ansid=227577 then '' when ansid=227578 then '' when ansid=227579 then '' when ansid=227580 then '' when ansid=227581 then '' when ansid=227582 then '' when ansid=227583 then '' when ansid=227584 then '' when ansid=227585 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.53.147',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 19:42:00'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE supvisstepid = '12122'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '1' when ansid=227531 then '1' when ansid=227533 then '0' when ansid=227535 then '100' when ansid=227537 then '5' when ansid=227539 then '' when ansid=227540 then '' when ansid=227541 then '' when ansid=227542 then ''  when ansid=227543 then ''   when ansid=227544 then ''  when ansid=227545 then ''  when ansid=227546 then ''   when ansid=227547 then ''   when ansid=227548 then ''   when ansid=227549 then ''  when ansid=227550 then '' when ansid=227551 then '' when ansid=227552 then ''  when ansid=227553 then ''   when ansid=227554 then ''   when ansid=227555 then ''   when ansid=227556 then ''  when ansid=227557 then ''  when ansid=227558 then ''   when ansid=227559 then ''  when ansid=227560 then '' when ansid=227561 then '' when ansid=227562 then '' when ansid=227563 then '' when ansid=227564 then '' when ansid=227565 then '' when ansid=227566 then '' when ansid=227567 then '' when ansid=227568 then ''  when ansid=227569 then ''   when ansid=227570 then ''   when ansid=227571 then ''   when ansid=227572 then ''  when ansid=227573 then '' when ansid=227574 then ''  when ansid=227575 then ''   when ansid=227576 then ''  when ansid=227577 then '' when ansid=227578 then '' when ansid=227579 then '' when ansid=227580 then '' when ansid=227581 then '' when ansid=227582 then '' when ansid=227583 then '' when ansid=227584 then '' when ansid=227585 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.53.147',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 19:42:00'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE supvisstepid = '12123'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 19:42:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:42:00' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '1' when ansid=227531 then '1' when ansid=227533 then '0' when ansid=227535 then '100' when ansid=227537 then '5' when ansid=227539 then '12' when ansid=227540 then '0' when ansid=227541 then '12' when ansid=227542 then '12'  when ansid=227543 then ''   when ansid=227544 then '1'  when ansid=227545 then '1'  when ansid=227546 then ''   when ansid=227547 then '1'   when ansid=227548 then ''   when ansid=227549 then '1'  when ansid=227550 then '6' when ansid=227551 then '1' when ansid=227552 then '1'  when ansid=227553 then 'Counsellor'   when ansid=227554 then '1'   when ansid=227555 then ''   when ansid=227556 then '1'  when ansid=227557 then '1'  when ansid=227558 then ''   when ansid=227559 then '1'  when ansid=227560 then '3' when ansid=227561 then '1' when ansid=227562 then '1' when ansid=227563 then '1' when ansid=227564 then '1' when ansid=227565 then '1' when ansid=227566 then '1' when ansid=227567 then '1' when ansid=227568 then '1'  when ansid=227569 then ''   when ansid=227570 then '3'   when ansid=227571 then ''   when ansid=227572 then '1'  when ansid=227573 then '1' when ansid=227574 then '1'  when ansid=227575 then ''   when ansid=227576 then '1'  when ansid=227577 then '1' when ansid=227578 then '3' when ansid=227579 then '3' when ansid=227580 then '1' when ansid=227581 then '0' when ansid=227582 then 'no' when ansid=227583 then 'no' when ansid=227584 then 'There is an issue noticed in sample serum separation; micro peptides need to be used.' when ansid=227585 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.53.147',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 19:47:18'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE supvisstepid = '12125'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 19:47:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:18' WHERE visitfeedbackid = '12030'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE sitesupervision SET `siteid` = '1824', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '12', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2450'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.S Satya Deepthi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE onssid = '10128'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. K Henumathe Rao', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE onssid = '10129'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. J Vamsee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE onssid = '10130'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE onssid = '10131'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=227480 then '1' when ansid=227481 then '1' when ansid=227482 then '1' when ansid=227483 then '' when ansid=227484 then ''  when ansid=227485 then '87'   when ansid=227486 then '1'  when ansid=227586 then '1' when ansid=227587 then '1' when ansid=227529 then '1' when ansid=227531 then '1' when ansid=227533 then '0' when ansid=227535 then '100' when ansid=227537 then '5' when ansid=227539 then '12' when ansid=227540 then '0' when ansid=227541 then '12' when ansid=227542 then '12'  when ansid=227543 then ''   when ansid=227544 then '1'  when ansid=227545 then '1'  when ansid=227546 then ''   when ansid=227547 then '1'   when ansid=227548 then ''   when ansid=227549 then '1'  when ansid=227550 then '6' when ansid=227551 then '1' when ansid=227552 then '1'  when ansid=227553 then 'Counsellor'   when ansid=227554 then '1'   when ansid=227555 then ''   when ansid=227556 then '1'  when ansid=227557 then '1'  when ansid=227558 then ''   when ansid=227559 then '1'  when ansid=227560 then '3' when ansid=227561 then '1' when ansid=227562 then '1' when ansid=227563 then '1' when ansid=227564 then '1' when ansid=227565 then '1' when ansid=227566 then '1' when ansid=227567 then '1' when ansid=227568 then '1'  when ansid=227569 then ''   when ansid=227570 then '3'   when ansid=227571 then ''   when ansid=227572 then '1'  when ansid=227573 then '1' when ansid=227574 then '1'  when ansid=227575 then ''   when ansid=227576 then '1'  when ansid=227577 then '1' when ansid=227578 then '3' when ansid=227579 then '3' when ansid=227580 then '1' when ansid=227581 then '0' when ansid=227582 then 'no' when ansid=227583 then 'no' when ansid=227584 then 'There is an issue noticed in sample serum separation; micro peptides need to be used.' when ansid=227585 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.47.53.147',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-08 19:47:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('227480','227481','227482','227483','227484','227485','227486','227586','227587','227529','227531','227533','227535','227537','227539','227540','227541','227542','227543','227544','227545','227546','227547','227548','227549','227550','227551','227552','227553','227554','227555','227556','227557','227558','227559','227560','227561','227562','227563','227564','227565','227566','227567','227568','227569','227570','227571','227572','227573','227574','227575','227576','227577','227578','227579','227580','227581','227582','227583','227584','227585')"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE supvisstepid = '12126'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'There is an issue noticed in sample serum separation; micro peptides need to be used.', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE visitfeedbackid = '12026'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE visitfeedbackid = '12027'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE visitfeedbackid = '12028'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE visitfeedbackid = '12029'"}
{"userId":"521","date":"2023-01-08 19:47:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.47.53.147', `modifiedby` = '521', `modifieddate` = '2023-01-08 19:47:34' WHERE visitfeedbackid = '12030'"}
{"userId":"313","date":"2023-01-08 19:52:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('313', '117.211.135.108', '2023-01-08 19:52:09')"}
{"userId":"313","date":"2023-01-08 19:55:33","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('600', '2023-01-09', '313', '117.211.135.108', '313', '2023-01-08 19:55:33')"}
{"userId":"313","date":"2023-01-08 19:55:43","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('599', '2023-01-09', '313', '117.211.135.108', '313', '2023-01-08 19:55:43')"}
{"userId":"313","date":"2023-01-08 19:55:49","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('598', '2023-01-09', '313', '117.211.135.108', '313', '2023-01-08 19:55:49')"}
{"userId":"313","date":"2023-01-08 19:57:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('597', '2023-01-11', '313', '117.211.135.108', '313', '2023-01-08 19:57:01')"}
{"userId":"313","date":"2023-01-08 19:57:34","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('562', '2023-01-11', '313', '117.211.135.108', '313', '2023-01-08 19:57:34')"}
{"userId":"313","date":"2023-01-08 19:58:20","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('559', '2023-01-19', '313', '117.211.135.108', '313', '2023-01-08 19:58:20')"}
{"userId":"313","date":"2023-01-08 19:58:29","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('560', '2023-01-19', '313', '117.211.135.108', '313', '2023-01-08 19:58:29')"}
{"userId":"313","date":"2023-01-08 19:58:46","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('561', '2023-01-19', '313', '117.211.135.108', '313', '2023-01-08 19:58:46')"}
{"userId":"313","date":"2023-01-08 20:00:05","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('596', '2023-01-16', '313', '117.211.135.108', '313', '2023-01-08 20:00:05')"}
{"userId":"313","date":"2023-01-08 20:02:58","query":"UPDATE plannedsites SET `siteid` = '561', `visitdate` = '2023-01-16', `ipaddress` = '117.211.135.108', `modifiedby` = '313', `modifieddate` = '2023-01-08 20:02:58' WHERE plansiteid = '2898'"}
{"userId":"543","date":"2023-01-08 20:06:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '152.58.234.61', '2023-01-08 20:06:08')"}
{"userId":"543","date":"2023-01-08 20:07:09","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('737', '2023-01-09', '543', '152.58.234.61', '543', '2023-01-08 20:07:09')"}
{"userId":"543","date":"2023-01-08 20:07:35","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1826', '2023-01-09', '543', '152.58.234.61', '543', '2023-01-08 20:07:35')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('737', '2900', '543', '2023-01-08', '0', '152.58.234.61', '543', '2023-01-08 20:08:46', '', '')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2458', '0', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2458', '', '', 'Array', '', 'Array', '', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2458', '', '', 'Array', '', 'Array', '', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2458', '', '', 'Array', '', 'Array', '', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2458', '', '', 'Array', '', 'Array', '', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:08:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2458', '152.58.234.61', '543', '2023-01-08 20:08:46')"}
{"userId":"543","date":"2023-01-08 20:56:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '152.58.233.109', '2023-01-08 20:56:25')"}