{"userId":"7","date":"2020-12-01 20:22:39","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '1.187.63.77', '2020-12-01 20:22:39')"}
{"userId":"7","date":"2020-12-01 20:24:05","query":"UPDATE usermst SET `password` = '25d55ad283aa400af464c76d713c07ad', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:24:05', `ipaddress` = '106.77.44.97' WHERE userid = '7'"}
{"userId":"7","date":"2020-12-01 20:26:32","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('521', '2020-12-01', '7', '1.187.60.216', '7', '2020-12-01 20:26:32')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('521', '926', '7', '2020-12-01', '1', '1.187.60.216', '7', '2020-12-01 20:27:21', '', '')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '0', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '1', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '2', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '3', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '4', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '5', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('738', '6', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('738', '', '', 'Array', '', 'Array', '', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('738', '', '', 'Array', '', 'Array', '', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('738', '', '', 'Array', '', 'Array', '', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('738', '', '', 'Array', '', 'Array', '', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:27:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('738', '1.187.60.216', '7', '2020-12-01 20:27:21')"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '' when ansid=77283 then '' when ansid=77284 then '' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then ''  when ansid=77289 then '' when ansid=77291 then '' when ansid=77293 then '' when ansid=77295 then '' when ansid=77297 then '' when ansid=77299 then '' when ansid=77301 then '' when ansid=77303 then '' when ansid=77305 then '' when ansid=77307 then '' when ansid=77309 then '' when ansid=77311 then '' when ansid=77313 then '' when ansid=77315 then '' when ansid=77317 then '' when ansid=77319 then '' when ansid=77321 then '' when ansid=77323 then '' when ansid=77325 then '' when ansid=77327 then '' when ansid=77329 then '' when ansid=77331 then '' when ansid=77333 then '' when ansid=77335 then '' when ansid=77337 then '' when ansid=77339 then '' when ansid=77341 then '' when ansid=77342 then '' when ansid=77343 then '' when ansid=77344 then ''  when ansid=77345 then ''   when ansid=77346 then ''  when ansid=77347 then ''  when ansid=77348 then ''   when ansid=77349 then ''   when ansid=77350 then ''   when ansid=77351 then ''  when ansid=77352 then '' when ansid=77353 then '' when ansid=77354 then ''  when ansid=77355 then ''   when ansid=77356 then ''   when ansid=77357 then ''   when ansid=77358 then ''  when ansid=77359 then ''  when ansid=77360 then ''   when ansid=77361 then ''  when ansid=77362 then '' when ansid=77363 then '' when ansid=77364 then '' when ansid=77365 then '' when ansid=77366 then '' when ansid=77367 then '' when ansid=77368 then '' when ansid=77369 then '' when ansid=77370 then ''  when ansid=77371 then ''   when ansid=77372 then ''   when ansid=77373 then ''   when ansid=77374 then ''  when ansid=77375 then '' when ansid=77376 then ''  when ansid=77377 then ''   when ansid=77378 then ''  when ansid=77379 then '' when ansid=77380 then '' when ansid=77381 then '' when ansid=77382 then '' when ansid=77383 then '' when ansid=77384 then '' when ansid=77385 then '' when ansid=77386 then '' when ansid=77387 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.63.77',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:29:40'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE supvisstepid = '4727'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:29:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.63.77', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:29:40' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:30:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '' when ansid=77291 then '' when ansid=77293 then '' when ansid=77295 then '' when ansid=77297 then '' when ansid=77299 then '' when ansid=77301 then '' when ansid=77303 then '' when ansid=77305 then '' when ansid=77307 then '' when ansid=77309 then '' when ansid=77311 then '' when ansid=77313 then '' when ansid=77315 then '' when ansid=77317 then '' when ansid=77319 then '' when ansid=77321 then '' when ansid=77323 then '' when ansid=77325 then '' when ansid=77327 then '' when ansid=77329 then '' when ansid=77331 then '' when ansid=77333 then '' when ansid=77335 then '' when ansid=77337 then '' when ansid=77339 then '' when ansid=77341 then '' when ansid=77342 then '' when ansid=77343 then '' when ansid=77344 then ''  when ansid=77345 then ''   when ansid=77346 then ''  when ansid=77347 then ''  when ansid=77348 then ''   when ansid=77349 then ''   when ansid=77350 then ''   when ansid=77351 then ''  when ansid=77352 then '' when ansid=77353 then '' when ansid=77354 then ''  when ansid=77355 then ''   when ansid=77356 then ''   when ansid=77357 then ''   when ansid=77358 then ''  when ansid=77359 then ''  when ansid=77360 then ''   when ansid=77361 then ''  when ansid=77362 then '' when ansid=77363 then '' when ansid=77364 then '' when ansid=77365 then '' when ansid=77366 then '' when ansid=77367 then '' when ansid=77368 then '' when ansid=77369 then '' when ansid=77370 then ''  when ansid=77371 then ''   when ansid=77372 then ''   when ansid=77373 then ''   when ansid=77374 then ''  when ansid=77375 then '' when ansid=77376 then ''  when ansid=77377 then ''   when ansid=77378 then ''  when ansid=77379 then '' when ansid=77380 then '' when ansid=77381 then '' when ansid=77382 then '' when ansid=77383 then '' when ansid=77384 then '' when ansid=77385 then '' when ansid=77386 then '' when ansid=77387 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.60.216',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:30:15'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE supvisstepid = '4728'"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:30:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:15' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '3' when ansid=77291 then '1' when ansid=77293 then '450' when ansid=77295 then '25' when ansid=77297 then '25' when ansid=77299 then '500' when ansid=77301 then '1' when ansid=77303 then '1' when ansid=77305 then '' when ansid=77307 then '' when ansid=77309 then '' when ansid=77311 then '' when ansid=77313 then '' when ansid=77315 then '' when ansid=77317 then '' when ansid=77319 then '' when ansid=77321 then '' when ansid=77323 then '' when ansid=77325 then '' when ansid=77327 then '' when ansid=77329 then '' when ansid=77331 then '' when ansid=77333 then '' when ansid=77335 then '' when ansid=77337 then '' when ansid=77339 then '' when ansid=77341 then '' when ansid=77342 then '' when ansid=77343 then '' when ansid=77344 then ''  when ansid=77345 then ''   when ansid=77346 then ''  when ansid=77347 then ''  when ansid=77348 then ''   when ansid=77349 then ''   when ansid=77350 then ''   when ansid=77351 then ''  when ansid=77352 then '' when ansid=77353 then '' when ansid=77354 then ''  when ansid=77355 then ''   when ansid=77356 then ''   when ansid=77357 then ''   when ansid=77358 then ''  when ansid=77359 then ''  when ansid=77360 then ''   when ansid=77361 then ''  when ansid=77362 then '' when ansid=77363 then '' when ansid=77364 then '' when ansid=77365 then '' when ansid=77366 then '' when ansid=77367 then '' when ansid=77368 then '' when ansid=77369 then '' when ansid=77370 then ''  when ansid=77371 then ''   when ansid=77372 then ''   when ansid=77373 then ''   when ansid=77374 then ''  when ansid=77375 then '' when ansid=77376 then ''  when ansid=77377 then ''   when ansid=77378 then ''  when ansid=77379 then '' when ansid=77380 then '' when ansid=77381 then '' when ansid=77382 then '' when ansid=77383 then '' when ansid=77384 then '' when ansid=77385 then '' when ansid=77386 then '' when ansid=77387 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.60.216',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:30:34'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE supvisstepid = '4729'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:30:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:34' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '3' when ansid=77291 then '1' when ansid=77293 then '450' when ansid=77295 then '25' when ansid=77297 then '25' when ansid=77299 then '500' when ansid=77301 then '1' when ansid=77303 then '1' when ansid=77305 then '2' when ansid=77307 then '450' when ansid=77309 then '200' when ansid=77311 then '400' when ansid=77313 then '25' when ansid=77315 then '1' when ansid=77317 then '450' when ansid=77319 then '450' when ansid=77321 then '500' when ansid=77323 then '2' when ansid=77325 then '5' when ansid=77327 then '1' when ansid=77329 then '5' when ansid=77331 then '' when ansid=77333 then '' when ansid=77335 then '' when ansid=77337 then '' when ansid=77339 then '' when ansid=77341 then '' when ansid=77342 then '' when ansid=77343 then '' when ansid=77344 then ''  when ansid=77345 then ''   when ansid=77346 then ''  when ansid=77347 then ''  when ansid=77348 then ''   when ansid=77349 then ''   when ansid=77350 then ''   when ansid=77351 then ''  when ansid=77352 then '' when ansid=77353 then '' when ansid=77354 then ''  when ansid=77355 then ''   when ansid=77356 then ''   when ansid=77357 then ''   when ansid=77358 then ''  when ansid=77359 then ''  when ansid=77360 then ''   when ansid=77361 then ''  when ansid=77362 then '' when ansid=77363 then '' when ansid=77364 then '' when ansid=77365 then '' when ansid=77366 then '' when ansid=77367 then '' when ansid=77368 then '' when ansid=77369 then '' when ansid=77370 then ''  when ansid=77371 then ''   when ansid=77372 then ''   when ansid=77373 then ''   when ansid=77374 then ''  when ansid=77375 then '' when ansid=77376 then ''  when ansid=77377 then ''   when ansid=77378 then ''  when ansid=77379 then '' when ansid=77380 then '' when ansid=77381 then '' when ansid=77382 then '' when ansid=77383 then '' when ansid=77384 then '' when ansid=77385 then '' when ansid=77386 then '' when ansid=77387 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.60.216',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:30:54'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE supvisstepid = '4730'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:30:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:30:54' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '3' when ansid=77291 then '1' when ansid=77293 then '450' when ansid=77295 then '25' when ansid=77297 then '25' when ansid=77299 then '500' when ansid=77301 then '1' when ansid=77303 then '1' when ansid=77305 then '2' when ansid=77307 then '450' when ansid=77309 then '200' when ansid=77311 then '400' when ansid=77313 then '25' when ansid=77315 then '1' when ansid=77317 then '450' when ansid=77319 then '450' when ansid=77321 then '500' when ansid=77323 then '2' when ansid=77325 then '5' when ansid=77327 then '1' when ansid=77329 then '5' when ansid=77331 then '1' when ansid=77333 then '1' when ansid=77335 then '1' when ansid=77337 then '250' when ansid=77339 then '7' when ansid=77341 then '' when ansid=77342 then '' when ansid=77343 then '' when ansid=77344 then ''  when ansid=77345 then ''   when ansid=77346 then ''  when ansid=77347 then ''  when ansid=77348 then ''   when ansid=77349 then ''   when ansid=77350 then ''   when ansid=77351 then ''  when ansid=77352 then '' when ansid=77353 then '' when ansid=77354 then ''  when ansid=77355 then ''   when ansid=77356 then ''   when ansid=77357 then ''   when ansid=77358 then ''  when ansid=77359 then ''  when ansid=77360 then ''   when ansid=77361 then ''  when ansid=77362 then '' when ansid=77363 then '' when ansid=77364 then '' when ansid=77365 then '' when ansid=77366 then '' when ansid=77367 then '' when ansid=77368 then '' when ansid=77369 then '' when ansid=77370 then ''  when ansid=77371 then ''   when ansid=77372 then ''   when ansid=77373 then ''   when ansid=77374 then ''  when ansid=77375 then '' when ansid=77376 then ''  when ansid=77377 then ''   when ansid=77378 then ''  when ansid=77379 then '' when ansid=77380 then '' when ansid=77381 then '' when ansid=77382 then '' when ansid=77383 then '' when ansid=77384 then '' when ansid=77385 then '' when ansid=77386 then '' when ansid=77387 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.60.216',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:31:17'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE supvisstepid = '4731'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:31:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.60.216', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:31:17' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '3' when ansid=77291 then '1' when ansid=77293 then '450' when ansid=77295 then '25' when ansid=77297 then '25' when ansid=77299 then '500' when ansid=77301 then '1' when ansid=77303 then '1' when ansid=77305 then '2' when ansid=77307 then '450' when ansid=77309 then '200' when ansid=77311 then '400' when ansid=77313 then '25' when ansid=77315 then '1' when ansid=77317 then '450' when ansid=77319 then '450' when ansid=77321 then '500' when ansid=77323 then '2' when ansid=77325 then '5' when ansid=77327 then '1' when ansid=77329 then '5' when ansid=77331 then '1' when ansid=77333 then '1' when ansid=77335 then '1' when ansid=77337 then '250' when ansid=77339 then '7' when ansid=77341 then '400' when ansid=77342 then '2' when ansid=77343 then '2' when ansid=77344 then '2'  when ansid=77345 then ''   when ansid=77346 then '1'  when ansid=77347 then '1'  when ansid=77348 then ''   when ansid=77349 then '1'   when ansid=77350 then ''   when ansid=77351 then '1'  when ansid=77352 then '20' when ansid=77353 then '1' when ansid=77354 then '1'  when ansid=77355 then ''   when ansid=77356 then '2'   when ansid=77357 then ''   when ansid=77358 then '1'  when ansid=77359 then '1'  when ansid=77360 then ''   when ansid=77361 then '1'  when ansid=77362 then '1' when ansid=77363 then '2' when ansid=77364 then '1' when ansid=77365 then '1' when ansid=77366 then '2' when ansid=77367 then '3' when ansid=77368 then '1' when ansid=77369 then '1' when ansid=77370 then '1'  when ansid=77371 then ''   when ansid=77372 then '1'   when ansid=77373 then ''   when ansid=77374 then '1'  when ansid=77375 then '1' when ansid=77376 then '1'  when ansid=77377 then ''   when ansid=77378 then '1'  when ansid=77379 then '1' when ansid=77380 then '1' when ansid=77381 then '1' when ansid=77382 then '1' when ansid=77383 then '0' when ansid=77384 then 'NA' when ansid=77385 then 'NA' when ansid=77386 then 'NA' when ansid=77387 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.59.7',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:41:10'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE supvisstepid = '4732'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:41:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:10' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE sitesupervision SET `siteid` = '521', `userid` = '7', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2020-01-01', `numofsamplecollected` = '2', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '738'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE onsitestaffs SET `staffname` = 'abc', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '-', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE onssid = '3280'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE onssid = '3281'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE onsitestaffs SET `staffname` = 'pqr', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE onssid = '3282'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE onssid = '3283'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=77282 then '1' when ansid=77283 then '1' when ansid=77284 then '1' when ansid=77285 then '' when ansid=77286 then ''  when ansid=77287 then ''   when ansid=77288 then '2'  when ansid=77289 then '3' when ansid=77291 then '1' when ansid=77293 then '450' when ansid=77295 then '25' when ansid=77297 then '25' when ansid=77299 then '500' when ansid=77301 then '1' when ansid=77303 then '1' when ansid=77305 then '2' when ansid=77307 then '450' when ansid=77309 then '200' when ansid=77311 then '400' when ansid=77313 then '25' when ansid=77315 then '1' when ansid=77317 then '450' when ansid=77319 then '450' when ansid=77321 then '500' when ansid=77323 then '2' when ansid=77325 then '5' when ansid=77327 then '1' when ansid=77329 then '5' when ansid=77331 then '1' when ansid=77333 then '1' when ansid=77335 then '1' when ansid=77337 then '250' when ansid=77339 then '7' when ansid=77341 then '400' when ansid=77342 then '2' when ansid=77343 then '2' when ansid=77344 then '2'  when ansid=77345 then ''   when ansid=77346 then '1'  when ansid=77347 then '1'  when ansid=77348 then ''   when ansid=77349 then '1'   when ansid=77350 then ''   when ansid=77351 then '1'  when ansid=77352 then '20' when ansid=77353 then '1' when ansid=77354 then '1'  when ansid=77355 then ''   when ansid=77356 then '2'   when ansid=77357 then ''   when ansid=77358 then '1'  when ansid=77359 then '1'  when ansid=77360 then ''   when ansid=77361 then '1'  when ansid=77362 then '1' when ansid=77363 then '2' when ansid=77364 then '1' when ansid=77365 then '1' when ansid=77366 then '2' when ansid=77367 then '3' when ansid=77368 then '1' when ansid=77369 then '1' when ansid=77370 then '1'  when ansid=77371 then ''   when ansid=77372 then '1'   when ansid=77373 then ''   when ansid=77374 then '1'  when ansid=77375 then '1' when ansid=77376 then '1'  when ansid=77377 then ''   when ansid=77378 then '1'  when ansid=77379 then '1' when ansid=77380 then '1' when ansid=77381 then '1' when ansid=77382 then '1' when ansid=77383 then '0' when ansid=77384 then 'NA' when ansid=77385 then 'NA' when ansid=77386 then 'NA' when ansid=77387 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '1.187.59.7',\n\t\t\t\t\t\t\t\tmodifiedby =7,\n\t\t\t\t\t\t\t\tmodifieddate = '2020-12-01 20:41:57'\n\t\t\t\t\t\t\tWHERE ansid in ('77282','77283','77284','77285','77286','77287','77288','77289','77291','77293','77295','77297','77299','77301','77303','77305','77307','77309','77311','77313','77315','77317','77319','77321','77323','77325','77327','77329','77331','77333','77335','77337','77339','77341','77342','77343','77344','77345','77346','77347','77348','77349','77350','77351','77352','77353','77354','77355','77356','77357','77358','77359','77360','77361','77362','77363','77364','77365','77366','77367','77368','77369','77370','77371','77372','77373','77374','77375','77376','77377','77378','77379','77380','77381','77382','77383','77384','77385','77386','77387')"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE supvisstepid = '4733'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE visitfeedbackid = '3466'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE visitfeedbackid = '3467'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE visitfeedbackid = '3468'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE visitfeedbackid = '3469'"}
{"userId":"7","date":"2020-12-01 20:41:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '1.187.59.7', `modifiedby` = '7', `modifieddate` = '2020-12-01 20:41:57' WHERE visitfeedbackid = '3470'"}
{"userId":"7","date":"2020-12-01 20:48:32","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Praphulla', 'Lakare', 'datasupervisor.hss.nari@gmail.com', '8796606939', 'Data Manager', 'ICMR-NARI', '3b16d2a79be5a12342c1d59391c57a35', '4', '1.187.60.216', '7', '2020-12-01 20:48:32')"}
{"userId":"7","date":"2020-12-01 20:48:32","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('246', '101', '22', '380', '5', '2763', '1.187.60.216', '7', '2020-12-01 20:48:32')"}
{"userId":"246","date":"2020-12-01 20:52:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('246', '1.187.59.7', '2020-12-01 20:52:13')"}
{"userId":"246","date":"2020-12-01 20:56:10","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('468', '2020-12-01', '246', '1.187.60.216', '246', '2020-12-01 20:56:10')"}
{"userId":"246","date":"2020-12-01 20:57:05","query":"UPDATE plannedsites SET `siteid` = '468', `visitdate` = '2020-12-02', `ipaddress` = '1.187.57.250', `modifiedby` = '246', `modifieddate` = '2020-12-01 20:57:05' WHERE plansiteid = '927'"}
{"userId":"246","date":"2020-12-01 20:57:20","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '1.187.57.250', `modifiedby` = '246', `modifieddate` = '2020-12-01 20:57:20' WHERE plansiteid = '927'"}
{"userId":"246","date":"2020-12-01 20:57:20","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '1.187.57.250', `modifiedby` = '246', `modifieddate` = '2020-12-01 20:57:20' WHERE ssid = ''"}