{"userId":"1","date":"2021-04-26 12:39:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '10.10.1.7', '2021-04-26 12:39:57')"}
{"userId":"1","date":"2021-04-26 12:55:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '10.10.1.7', '2021-04-26 12:55:57')"}
{"userId":"1","date":"2021-04-26 12:57:05","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('2', '2021-04-26', '1', '10.10.1.7', '1', '2021-04-26 12:57:05')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('2', '2768', '1', '2021-04-26', '1', '10.10.1.7', '1', '2021-04-26 12:57:09', '', '')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2355', '0', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2355', '1', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2355', '2', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2355', '3', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2355', '4', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2355', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2355', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2355', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2355', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 12:57:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2355', '10.10.1.7', '1', '2021-04-26 12:57:09')"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE sitesupervision SET `siteid` = '2', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2021-02-24', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2355'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE onssid = '9748'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE onssid = '9749'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE onssid = '9750'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE onssid = '9751'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218582 then '' when ansid=218583 then '' when ansid=218584 then '' when ansid=218585 then '' when ansid=218586 then ''  when ansid=218587 then ''   when ansid=218588 then ''  when ansid=218631 then '' when ansid=218633 then '' when ansid=218635 then '' when ansid=218637 then '' when ansid=218639 then '' when ansid=218641 then '' when ansid=218642 then '' when ansid=218643 then '' when ansid=218644 then ''  when ansid=218645 then ''   when ansid=218646 then ''  when ansid=218647 then ''  when ansid=218648 then ''   when ansid=218649 then ''   when ansid=218650 then ''   when ansid=218651 then ''  when ansid=218652 then '' when ansid=218653 then '' when ansid=218654 then ''  when ansid=218655 then ''   when ansid=218656 then ''   when ansid=218657 then ''   when ansid=218658 then ''  when ansid=218659 then ''  when ansid=218660 then ''   when ansid=218661 then ''  when ansid=218662 then '' when ansid=218663 then '' when ansid=218664 then '' when ansid=218665 then '' when ansid=218666 then '' when ansid=218667 then '' when ansid=218668 then '' when ansid=218669 then '' when ansid=218670 then ''  when ansid=218671 then ''   when ansid=218672 then ''   when ansid=218673 then ''   when ansid=218674 then ''  when ansid=218675 then '' when ansid=218676 then ''  when ansid=218677 then ''   when ansid=218678 then ''  when ansid=218679 then '' when ansid=218680 then '' when ansid=218681 then '' when ansid=218682 then '' when ansid=218683 then '' when ansid=218684 then '' when ansid=218685 then '' when ansid=218686 then '' when ansid=218687 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:11:21'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218582','218583','218584','218585','218586','218587','218588','218631','218633','218635','218637','218639','218641','218642','218643','218644','218645','218646','218647','218648','218649','218650','218651','218652','218653','218654','218655','218656','218657','218658','218659','218660','218661','218662','218663','218664','218665','218666','218667','218668','218669','218670','218671','218672','218673','218674','218675','218676','218677','218678','218679','218680','218681','218682','218683','218684','218685','218686','218687')"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE supvisstepid = '11684'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE visitfeedbackid = '11551'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE visitfeedbackid = '11552'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE visitfeedbackid = '11553'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE visitfeedbackid = '11554'"}
{"userId":"1","date":"2021-04-26 13:11:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:11:21' WHERE visitfeedbackid = '11555'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE sitesupervision SET `siteid` = '2', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2021-02-24', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2355'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '222', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE onssid = '9748'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '2', `istrained` = '1', `remarks` = '33', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE onssid = '9749'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE onssid = '9750'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE onssid = '9751'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218582 then '' when ansid=218583 then '' when ansid=218584 then '' when ansid=218585 then '' when ansid=218586 then ''  when ansid=218587 then ''   when ansid=218588 then ''  when ansid=218631 then '' when ansid=218633 then '' when ansid=218635 then '' when ansid=218637 then '' when ansid=218639 then '' when ansid=218641 then '' when ansid=218642 then '' when ansid=218643 then '' when ansid=218644 then ''  when ansid=218645 then ''   when ansid=218646 then ''  when ansid=218647 then ''  when ansid=218648 then ''   when ansid=218649 then ''   when ansid=218650 then ''   when ansid=218651 then ''  when ansid=218652 then '' when ansid=218653 then '' when ansid=218654 then ''  when ansid=218655 then ''   when ansid=218656 then ''   when ansid=218657 then ''   when ansid=218658 then ''  when ansid=218659 then ''  when ansid=218660 then ''   when ansid=218661 then ''  when ansid=218662 then '' when ansid=218663 then '' when ansid=218664 then '' when ansid=218665 then '' when ansid=218666 then '' when ansid=218667 then '' when ansid=218668 then '' when ansid=218669 then '' when ansid=218670 then ''  when ansid=218671 then ''   when ansid=218672 then ''   when ansid=218673 then ''   when ansid=218674 then ''  when ansid=218675 then '' when ansid=218676 then ''  when ansid=218677 then ''   when ansid=218678 then ''  when ansid=218679 then '' when ansid=218680 then '' when ansid=218681 then '' when ansid=218682 then '' when ansid=218683 then '' when ansid=218684 then '' when ansid=218685 then '' when ansid=218686 then '' when ansid=218687 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:12:00'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218582','218583','218584','218585','218586','218587','218588','218631','218633','218635','218637','218639','218641','218642','218643','218644','218645','218646','218647','218648','218649','218650','218651','218652','218653','218654','218655','218656','218657','218658','218659','218660','218661','218662','218663','218664','218665','218666','218667','218668','218669','218670','218671','218672','218673','218674','218675','218676','218677','218678','218679','218680','218681','218682','218683','218684','218685','218686','218687')"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE supvisstepid = '11684'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE visitfeedbackid = '11551'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE visitfeedbackid = '11552'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE visitfeedbackid = '11553'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE visitfeedbackid = '11554'"}
{"userId":"1","date":"2021-04-26 13:12:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:00' WHERE visitfeedbackid = '11555'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE sitesupervision SET `siteid` = '2', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2021-02-24', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2355'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '222', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE onssid = '9748'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '2', `istrained` = '1', `remarks` = '33', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE onssid = '9749'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE onssid = '9750'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE onssid = '9751'"}
{"userId":"1","date":"2021-04-26 13:12:22","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218582 then '1' when ansid=218583 then '1' when ansid=218584 then '1' when ansid=218585 then '' when ansid=218586 then ''  when ansid=218587 then ''   when ansid=218588 then ''  when ansid=218631 then '' when ansid=218633 then '' when ansid=218635 then '' when ansid=218637 then '' when ansid=218639 then '' when ansid=218641 then '' when ansid=218642 then '' when ansid=218643 then '' when ansid=218644 then ''  when ansid=218645 then ''   when ansid=218646 then ''  when ansid=218647 then ''  when ansid=218648 then ''   when ansid=218649 then ''   when ansid=218650 then ''   when ansid=218651 then ''  when ansid=218652 then '' when ansid=218653 then '' when ansid=218654 then ''  when ansid=218655 then ''   when ansid=218656 then ''   when ansid=218657 then ''   when ansid=218658 then ''  when ansid=218659 then ''  when ansid=218660 then ''   when ansid=218661 then ''  when ansid=218662 then '' when ansid=218663 then '' when ansid=218664 then '' when ansid=218665 then '' when ansid=218666 then '' when ansid=218667 then '' when ansid=218668 then '' when ansid=218669 then '' when ansid=218670 then ''  when ansid=218671 then ''   when ansid=218672 then ''   when ansid=218673 then ''   when ansid=218674 then ''  when ansid=218675 then '' when ansid=218676 then ''  when ansid=218677 then ''   when ansid=218678 then ''  when ansid=218679 then '' when ansid=218680 then '' when ansid=218681 then '' when ansid=218682 then '' when ansid=218683 then '' when ansid=218684 then '' when ansid=218685 then '' when ansid=218686 then '' when ansid=218687 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:12:22'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218582','218583','218584','218585','218586','218587','218588','218631','218633','218635','218637','218639','218641','218642','218643','218644','218645','218646','218647','218648','218649','218650','218651','218652','218653','218654','218655','218656','218657','218658','218659','218660','218661','218662','218663','218664','218665','218666','218667','218668','218669','218670','218671','218672','218673','218674','218675','218676','218677','218678','218679','218680','218681','218682','218683','218684','218685','218686','218687')"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE supvisstepid = '11685'"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE visitfeedbackid = '11551'"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE visitfeedbackid = '11552'"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE visitfeedbackid = '11553'"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE visitfeedbackid = '11554'"}
{"userId":"1","date":"2021-04-26 13:12:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:12:22' WHERE visitfeedbackid = '11555'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE sitesupervision SET `siteid` = '2', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2021-02-24', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2355'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '222', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE onssid = '9748'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '2', `istrained` = '1', `remarks` = '33', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE onssid = '9749'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE onssid = '9750'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE onssid = '9751'"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218582 then '1' when ansid=218583 then '1' when ansid=218584 then '1' when ansid=218585 then '' when ansid=218586 then ''  when ansid=218587 then ''   when ansid=218588 then ''  when ansid=218631 then '' when ansid=218633 then '' when ansid=218635 then '' when ansid=218637 then '' when ansid=218639 then '' when ansid=218641 then '' when ansid=218642 then '' when ansid=218643 then '' when ansid=218644 then ''  when ansid=218645 then ''   when ansid=218646 then ''  when ansid=218647 then ''  when ansid=218648 then ''   when ansid=218649 then ''   when ansid=218650 then ''   when ansid=218651 then ''  when ansid=218652 then '' when ansid=218653 then '' when ansid=218654 then ''  when ansid=218655 then ''   when ansid=218656 then ''   when ansid=218657 then ''   when ansid=218658 then ''  when ansid=218659 then ''  when ansid=218660 then ''   when ansid=218661 then ''  when ansid=218662 then '' when ansid=218663 then '' when ansid=218664 then '' when ansid=218665 then '' when ansid=218666 then '' when ansid=218667 then '' when ansid=218668 then '' when ansid=218669 then '' when ansid=218670 then ''  when ansid=218671 then ''   when ansid=218672 then ''   when ansid=218673 then ''   when ansid=218674 then ''  when ansid=218675 then '' when ansid=218676 then ''  when ansid=218677 then ''   when ansid=218678 then ''  when ansid=218679 then '' when ansid=218680 then '' when ansid=218681 then '' when ansid=218682 then '' when ansid=218683 then '' when ansid=218684 then '' when ansid=218685 then '' when ansid=218686 then '' when ansid=218687 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:13:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218582','218583','218584','218585','218586','218587','218588','218631','218633','218635','218637','218639','218641','218642','218643','218644','218645','218646','218647','218648','218649','218650','218651','218652','218653','218654','218655','218656','218657','218658','218659','218660','218661','218662','218663','218664','218665','218666','218667','218668','218669','218670','218671','218672','218673','218674','218675','218676','218677','218678','218679','218680','218681','218682','218683','218684','218685','218686','218687')"}
{"userId":"1","date":"2021-04-26 13:13:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE supvisstepid = '11684'"}
{"userId":"1","date":"2021-04-26 13:13:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE visitfeedbackid = '11551'"}
{"userId":"1","date":"2021-04-26 13:13:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE visitfeedbackid = '11552'"}
{"userId":"1","date":"2021-04-26 13:13:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE visitfeedbackid = '11553'"}
{"userId":"1","date":"2021-04-26 13:13:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE visitfeedbackid = '11554'"}
{"userId":"1","date":"2021-04-26 13:13:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:13:05' WHERE visitfeedbackid = '11555'"}
{"userId":"1","date":"2021-04-26 13:15:29","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('160', '2021-04-26', '1', '10.10.1.7', '1', '2021-04-26 13:15:29')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('160', '2769', '1', '2021-04-26', '1', '10.10.1.7', '1', '2021-04-26 13:15:32', '', '')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2356', '0', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2356', '1', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2356', '2', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2356', '3', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2356', '4', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2356', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2356', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2356', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2356', '', '', 'Array', '', 'Array', '', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:15:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2356', '10.10.1.7', '1', '2021-04-26 13:15:32')"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '' when ansid=218689 then '' when ansid=218690 then '' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then ''   when ansid=218694 then ''  when ansid=218737 then '' when ansid=218739 then '' when ansid=218741 then '' when ansid=218743 then '' when ansid=218745 then '' when ansid=218747 then '' when ansid=218748 then '' when ansid=218749 then '' when ansid=218750 then ''  when ansid=218751 then ''   when ansid=218752 then ''  when ansid=218753 then ''  when ansid=218754 then ''   when ansid=218755 then ''   when ansid=218756 then ''   when ansid=218757 then ''  when ansid=218758 then '' when ansid=218759 then '' when ansid=218760 then ''  when ansid=218761 then ''   when ansid=218762 then ''   when ansid=218763 then ''   when ansid=218764 then ''  when ansid=218765 then ''  when ansid=218766 then ''   when ansid=218767 then ''  when ansid=218768 then '' when ansid=218769 then '' when ansid=218770 then '' when ansid=218771 then '' when ansid=218772 then '' when ansid=218773 then '' when ansid=218774 then '' when ansid=218775 then '' when ansid=218776 then ''  when ansid=218777 then ''   when ansid=218778 then ''   when ansid=218779 then ''   when ansid=218780 then ''  when ansid=218781 then '' when ansid=218782 then ''  when ansid=218783 then ''   when ansid=218784 then ''  when ansid=218785 then '' when ansid=218786 then '' when ansid=218787 then '' when ansid=218788 then '' when ansid=218789 then '' when ansid=218790 then '' when ansid=218791 then '' when ansid=218792 then '' when ansid=218793 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:17:16'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE supvisstepid = '11689'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:17:16' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '' when ansid=218739 then '' when ansid=218741 then '' when ansid=218743 then '' when ansid=218745 then '' when ansid=218747 then '' when ansid=218748 then '' when ansid=218749 then '' when ansid=218750 then ''  when ansid=218751 then ''   when ansid=218752 then ''  when ansid=218753 then ''  when ansid=218754 then ''   when ansid=218755 then ''   when ansid=218756 then ''   when ansid=218757 then ''  when ansid=218758 then '' when ansid=218759 then '' when ansid=218760 then ''  when ansid=218761 then ''   when ansid=218762 then ''   when ansid=218763 then ''   when ansid=218764 then ''  when ansid=218765 then ''  when ansid=218766 then ''   when ansid=218767 then ''  when ansid=218768 then '' when ansid=218769 then '' when ansid=218770 then '' when ansid=218771 then '' when ansid=218772 then '' when ansid=218773 then '' when ansid=218774 then '' when ansid=218775 then '' when ansid=218776 then ''  when ansid=218777 then ''   when ansid=218778 then ''   when ansid=218779 then ''   when ansid=218780 then ''  when ansid=218781 then '' when ansid=218782 then ''  when ansid=218783 then ''   when ansid=218784 then ''  when ansid=218785 then '' when ansid=218786 then '' when ansid=218787 then '' when ansid=218788 then '' when ansid=218789 then '' when ansid=218790 then '' when ansid=218791 then '' when ansid=218792 then '' when ansid=218793 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:18:26'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE supvisstepid = '11690'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:18:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:18:26' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '' when ansid=218748 then '' when ansid=218749 then '' when ansid=218750 then ''  when ansid=218751 then ''   when ansid=218752 then ''  when ansid=218753 then ''  when ansid=218754 then ''   when ansid=218755 then ''   when ansid=218756 then ''   when ansid=218757 then ''  when ansid=218758 then '' when ansid=218759 then '' when ansid=218760 then ''  when ansid=218761 then ''   when ansid=218762 then ''   when ansid=218763 then ''   when ansid=218764 then ''  when ansid=218765 then ''  when ansid=218766 then ''   when ansid=218767 then ''  when ansid=218768 then '' when ansid=218769 then '' when ansid=218770 then '' when ansid=218771 then '' when ansid=218772 then '' when ansid=218773 then '' when ansid=218774 then '' when ansid=218775 then '' when ansid=218776 then ''  when ansid=218777 then ''   when ansid=218778 then ''   when ansid=218779 then ''   when ansid=218780 then ''  when ansid=218781 then '' when ansid=218782 then ''  when ansid=218783 then ''   when ansid=218784 then ''  when ansid=218785 then '' when ansid=218786 then '' when ansid=218787 then '' when ansid=218788 then '' when ansid=218789 then '' when ansid=218790 then '' when ansid=218791 then '' when ansid=218792 then '' when ansid=218793 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:20:38'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE supvisstepid = '11691'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:20:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:20:38' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '0' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:48:07'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE supvisstepid = '11692'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:48:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:07' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:48:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '0' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:48:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE supvisstepid = '11693'"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:48:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:48:28' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:49:43'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE supvisstepid = '11689'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:49:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:49:43' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:50:18'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE supvisstepid = '11690'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:50:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:18' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:50:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE supvisstepid = '11691'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:50:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:50:39' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '0' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:52:21'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE supvisstepid = '11692'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:52:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:21' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:52:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE supvisstepid = '11689'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:52:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:33' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:52:35'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE supvisstepid = '11690'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:52:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:35' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:52:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE supvisstepid = '11691'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:52:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:52:40' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '0' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:53:01'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE supvisstepid = '11692'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:53:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:01' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:53:17'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE supvisstepid = '11689'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:53:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:17' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:53:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE supvisstepid = '11690'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:53:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:19' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:53:21'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE supvisstepid = '11691'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:21' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE sitesupervision SET `siteid` = '160', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2021-02-21', `numofsamplecollected` = '114', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2356'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '3333', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE onssid = '9752'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '6', `istrained` = '1', `remarks` = '4444', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE onssid = '9753'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE onssid = '9754'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE onssid = '9755'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=218688 then '1' when ansid=218689 then '1' when ansid=218690 then '1' when ansid=218691 then '' when ansid=218692 then ''  when ansid=218693 then '304'   when ansid=218694 then '1'  when ansid=218737 then '0' when ansid=218739 then '1' when ansid=218741 then '2' when ansid=218743 then '0' when ansid=218745 then '1' when ansid=218747 then '20' when ansid=218748 then '10' when ansid=218749 then '173' when ansid=218750 then '58'  when ansid=218751 then ''   when ansid=218752 then '1'  when ansid=218753 then '1'  when ansid=218754 then ''   when ansid=218755 then '1'   when ansid=218756 then 'an lhotu'   when ansid=218757 then '2'  when ansid=218758 then '14' when ansid=218759 then '1' when ansid=218760 then '1'  when ansid=218761 then 'Counsellor'   when ansid=218762 then '1'   when ansid=218763 then ''   when ansid=218764 then '1'  when ansid=218765 then '1'  when ansid=218766 then 'ANC registration number not filled in some cases'   when ansid=218767 then '2'  when ansid=218768 then '4' when ansid=218769 then '1' when ansid=218770 then '1' when ansid=218771 then '1' when ansid=218772 then '1' when ansid=218773 then '2' when ansid=218774 then '1' when ansid=218775 then '1' when ansid=218776 then '1'  when ansid=218777 then ''   when ansid=218778 then '3'   when ansid=218779 then ''   when ansid=218780 then '1'  when ansid=218781 then '1' when ansid=218782 then '1'  when ansid=218783 then 'Not connected to electricity because of no plug point'   when ansid=218784 then '2'  when ansid=218785 then '2' when ansid=218786 then '1' when ansid=218787 then '3' when ansid=218788 then '1' when ansid=218789 then '0' when ansid=218790 then 'Gloves and biomedical waste bags will be supplied from state shortly' when ansid=218791 then 'No' when ansid=218792 then 'Improper disposal of biomedical waste,use of hypochlorite solution,timely despatch of data forms,dataforms properly countersigned by site-in-charge' when ansid=218793 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '10.10.1.7',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-26 13:53:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('218688','218689','218690','218691','218692','218693','218694','218737','218739','218741','218743','218745','218747','218748','218749','218750','218751','218752','218753','218754','218755','218756','218757','218758','218759','218760','218761','218762','218763','218764','218765','218766','218767','218768','218769','218770','218771','218772','218773','218774','218775','218776','218777','218778','218779','218780','218781','218782','218783','218784','218785','218786','218787','218788','218789','218790','218791','218792','218793')"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE supvisstepid = '11692'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback1', `recommendation` = '1 Test Recommendations One', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE visitfeedbackid = '11556'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE visitfeedback SET `feedback` = 'This is test for feedback2', `recommendation` = '1 Test Recommendations two', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE visitfeedbackid = '11557'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE visitfeedbackid = '11558'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE visitfeedbackid = '11559'"}
{"userId":"1","date":"2021-04-26 13:53:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '10.10.1.7', `modifiedby` = '1', `modifieddate` = '2021-04-26 13:53:34' WHERE visitfeedbackid = '11560'"}
{"userId":"1","date":"2021-04-26 20:04:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '10.10.1.7', '2021-04-26 20:04:33')"}
{"userId":"1","date":"2021-04-26 22:25:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '10.10.1.7', '2021-04-26 22:25:00')"}