{"userId":"45","date":"2019-03-24 15:14:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('45', '117.205.104.108', '2019-03-24 15:14:34')"}
{"userId":"45","date":"2019-03-24 15:14:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('45', '117.205.104.108', '2019-03-24 15:14:35')"}
{"userId":"45","date":"2019-03-24 15:19:32","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1070', '2019-03-01', '45', '117.205.104.108', '45', '2019-03-24 15:19:32')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1070', '872', '45', '2019-03-24', '1', '117.205.104.108', '45', '2019-03-24 15:31:18', '', '')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '0', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '1', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '2', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '3', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '4', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('694', '5', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('694', '', '', 'Array', '', 'Array', '', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('694', '', '', 'Array', '', 'Array', '', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('694', '', '', 'Array', '', 'Array', '', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('694', '', '', 'Array', '', 'Array', '', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:31:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('694', '117.205.104.108', '45', '2019-03-24 15:31:18')"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 15:37:57","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '' when ansid=72758 then '' when ansid=72760 then '' when ansid=72762 then '' when ansid=72764 then '' when ansid=72766 then '' when ansid=72768 then '' when ansid=72770 then '' when ansid=72772 then '' when ansid=72774 then '' when ansid=72776 then '' when ansid=72778 then '' when ansid=72780 then '' when ansid=72782 then '' when ansid=72784 then '' when ansid=72786 then '' when ansid=72788 then '' when ansid=72790 then '' when ansid=72792 then '' when ansid=72794 then '' when ansid=72796 then '' when ansid=72798 then '' when ansid=72800 then '' when ansid=72802 then '' when ansid=72804 then '' when ansid=72806 then '' when ansid=72808 then '' when ansid=72810 then '' when ansid=72812 then '' when ansid=72813 then ''  when ansid=72814 then ''   when ansid=72815 then ''   when ansid=72816 then ''   when ansid=72817 then ''   when ansid=72818 then ''   when ansid=72819 then ''  when ansid=72820 then '' when ansid=72821 then ''  when ansid=72822 then ''   when ansid=72823 then ''   when ansid=72824 then ''   when ansid=72825 then ''  when ansid=72826 then '' when ansid=72827 then '' when ansid=72828 then '' when ansid=72829 then '' when ansid=72830 then '' when ansid=72831 then '' when ansid=72832 then '' when ansid=72833 then '' when ansid=72834 then '' when ansid=72835 then '' when ansid=72836 then '' when ansid=72837 then '' when ansid=72838 then '' when ansid=72839 then ''  when ansid=72840 then ''   when ansid=72841 then ''  when ansid=72842 then '' when ansid=72843 then '' when ansid=72844 then '' when ansid=72845 then '' when ansid=72846 then '' when ansid=72847 then '' when ansid=72848 then '' when ansid=72849 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 15:37:57'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE supvisstepid = '4472'"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 15:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:37:57' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '' when ansid=72778 then '' when ansid=72780 then '' when ansid=72782 then '' when ansid=72784 then '' when ansid=72786 then '' when ansid=72788 then '' when ansid=72790 then '' when ansid=72792 then '' when ansid=72794 then '' when ansid=72796 then '' when ansid=72798 then '' when ansid=72800 then '' when ansid=72802 then '' when ansid=72804 then '' when ansid=72806 then '' when ansid=72808 then '' when ansid=72810 then '' when ansid=72812 then '' when ansid=72813 then ''  when ansid=72814 then ''   when ansid=72815 then ''   when ansid=72816 then ''   when ansid=72817 then ''   when ansid=72818 then ''   when ansid=72819 then ''  when ansid=72820 then '' when ansid=72821 then ''  when ansid=72822 then ''   when ansid=72823 then ''   when ansid=72824 then ''   when ansid=72825 then ''  when ansid=72826 then '' when ansid=72827 then '' when ansid=72828 then '' when ansid=72829 then '' when ansid=72830 then '' when ansid=72831 then '' when ansid=72832 then '' when ansid=72833 then '' when ansid=72834 then '' when ansid=72835 then '' when ansid=72836 then '' when ansid=72837 then '' when ansid=72838 then '' when ansid=72839 then ''  when ansid=72840 then ''   when ansid=72841 then ''  when ansid=72842 then '' when ansid=72843 then '' when ansid=72844 then '' when ansid=72845 then '' when ansid=72846 then '' when ansid=72847 then '' when ansid=72848 then '' when ansid=72849 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 15:41:14'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE supvisstepid = '4473'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 15:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:41:14' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '2' when ansid=72778 then '100' when ansid=72780 then '0' when ansid=72782 then '500' when ansid=72784 then '400' when ansid=72786 then '1' when ansid=72788 then '500' when ansid=72790 then '400' when ansid=72792 then '1' when ansid=72794 then '1' when ansid=72796 then '5' when ansid=72798 then '1' when ansid=72800 then '4' when ansid=72802 then '' when ansid=72804 then '' when ansid=72806 then '' when ansid=72808 then '' when ansid=72810 then '' when ansid=72812 then '' when ansid=72813 then ''  when ansid=72814 then ''   when ansid=72815 then ''   when ansid=72816 then ''   when ansid=72817 then ''   when ansid=72818 then ''   when ansid=72819 then ''  when ansid=72820 then '' when ansid=72821 then ''  when ansid=72822 then ''   when ansid=72823 then ''   when ansid=72824 then ''   when ansid=72825 then ''  when ansid=72826 then '' when ansid=72827 then '' when ansid=72828 then '' when ansid=72829 then '' when ansid=72830 then '' when ansid=72831 then '' when ansid=72832 then '' when ansid=72833 then '' when ansid=72834 then '' when ansid=72835 then '' when ansid=72836 then '' when ansid=72837 then '' when ansid=72838 then '' when ansid=72839 then ''  when ansid=72840 then ''   when ansid=72841 then ''  when ansid=72842 then '' when ansid=72843 then '' when ansid=72844 then '' when ansid=72845 then '' when ansid=72846 then '' when ansid=72847 then '' when ansid=72848 then '' when ansid=72849 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 15:44:19'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE supvisstepid = '4474'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 15:44:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:44:19' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '2' when ansid=72778 then '100' when ansid=72780 then '0' when ansid=72782 then '500' when ansid=72784 then '400' when ansid=72786 then '1' when ansid=72788 then '500' when ansid=72790 then '400' when ansid=72792 then '1' when ansid=72794 then '1' when ansid=72796 then '5' when ansid=72798 then '1' when ansid=72800 then '4' when ansid=72802 then '1' when ansid=72804 then '1' when ansid=72806 then '0' when ansid=72808 then '3' when ansid=72810 then '1' when ansid=72812 then '' when ansid=72813 then ''  when ansid=72814 then ''   when ansid=72815 then ''   when ansid=72816 then ''   when ansid=72817 then ''   when ansid=72818 then ''   when ansid=72819 then ''  when ansid=72820 then '' when ansid=72821 then ''  when ansid=72822 then ''   when ansid=72823 then ''   when ansid=72824 then ''   when ansid=72825 then ''  when ansid=72826 then '' when ansid=72827 then '' when ansid=72828 then '' when ansid=72829 then '' when ansid=72830 then '' when ansid=72831 then '' when ansid=72832 then '' when ansid=72833 then '' when ansid=72834 then '' when ansid=72835 then '' when ansid=72836 then '' when ansid=72837 then '' when ansid=72838 then '' when ansid=72839 then ''  when ansid=72840 then ''   when ansid=72841 then ''  when ansid=72842 then '' when ansid=72843 then '' when ansid=72844 then '' when ansid=72845 then '' when ansid=72846 then '' when ansid=72847 then '' when ansid=72848 then '' when ansid=72849 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 15:45:32'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE supvisstepid = '4475'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 15:45:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 15:45:32' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '2' when ansid=72778 then '100' when ansid=72780 then '0' when ansid=72782 then '500' when ansid=72784 then '400' when ansid=72786 then '1' when ansid=72788 then '500' when ansid=72790 then '400' when ansid=72792 then '1' when ansid=72794 then '1' when ansid=72796 then '5' when ansid=72798 then '1' when ansid=72800 then '4' when ansid=72802 then '1' when ansid=72804 then '1' when ansid=72806 then '0' when ansid=72808 then '3' when ansid=72810 then '1' when ansid=72812 then '8' when ansid=72813 then '2'  when ansid=72814 then ''   when ansid=72815 then '1'   when ansid=72816 then ''   when ansid=72817 then '1'   when ansid=72818 then ''   when ansid=72819 then '1'  when ansid=72820 then '10' when ansid=72821 then '1'  when ansid=72822 then 'councillar'   when ansid=72823 then '1'   when ansid=72824 then 'Yes'   when ansid=72825 then '1'  when ansid=72826 then '1' when ansid=72827 then '1' when ansid=72828 then '2' when ansid=72829 then '1' when ansid=72830 then '1' when ansid=72831 then '2' when ansid=72832 then '1' when ansid=72833 then '2' when ansid=72834 then '1' when ansid=72835 then '1' when ansid=72836 then '3' when ansid=72837 then '2' when ansid=72838 then '1' when ansid=72839 then '1'  when ansid=72840 then ''   when ansid=72841 then '1'  when ansid=72842 then '2' when ansid=72843 then '1' when ansid=72844 then '2' when ansid=72845 then '1' when ansid=72846 then '0' when ansid=72847 then 'NIL' when ansid=72848 then 'None' when ansid=72849 then 'Data forms not checked by L.T. for completeness. Gloves not discarded after each sample collection. Puncture proof jar not used for disposal of Sharps. Destroyed needle being recapped manually & hub cutter not used, No Surplus consumables provided. Cryovials Labels were stamped. Behavioural Questions in the Data forms need to be modified. HSS staff need to read operational manual & follow accordingly' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 16:04:52'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE supvisstepid = '4476'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 16:04:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:04:52' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '2' when ansid=72778 then '100' when ansid=72780 then '0' when ansid=72782 then '500' when ansid=72784 then '400' when ansid=72786 then '1' when ansid=72788 then '500' when ansid=72790 then '400' when ansid=72792 then '1' when ansid=72794 then '1' when ansid=72796 then '5' when ansid=72798 then '1' when ansid=72800 then '4' when ansid=72802 then '1' when ansid=72804 then '1' when ansid=72806 then '0' when ansid=72808 then '3' when ansid=72810 then '1' when ansid=72812 then '8' when ansid=72813 then '2'  when ansid=72814 then ''   when ansid=72815 then '1'   when ansid=72816 then ''   when ansid=72817 then '1'   when ansid=72818 then ''   when ansid=72819 then '1'  when ansid=72820 then '10' when ansid=72821 then '1'  when ansid=72822 then 'councillar'   when ansid=72823 then '1'   when ansid=72824 then 'Yes'   when ansid=72825 then '1'  when ansid=72826 then '1' when ansid=72827 then '1' when ansid=72828 then '2' when ansid=72829 then '1' when ansid=72830 then '1' when ansid=72831 then '2' when ansid=72832 then '1' when ansid=72833 then '2' when ansid=72834 then '1' when ansid=72835 then '1' when ansid=72836 then '3' when ansid=72837 then '2' when ansid=72838 then '1' when ansid=72839 then '1'  when ansid=72840 then ''   when ansid=72841 then '1'  when ansid=72842 then '2' when ansid=72843 then '1' when ansid=72844 then '2' when ansid=72845 then '1' when ansid=72846 then '0' when ansid=72847 then 'NIL' when ansid=72848 then 'None' when ansid=72849 then 'Data forms not checked by L.T. for completeness. Gloves not discarded after each sample collection. Puncture proof jar not used for disposal of Sharps. Destroyed needle being recapped manually & hub cutter not used, No Surplus consumables provided. Cryovials Labels were stamped. Behavioural Questions in the Data forms need to be modified. HSS staff need to read operational manual & follow accordingly' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 16:29:12'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE supvisstepid = '4476'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE visitfeedback SET `feedback` = 'Data forms not being checked by L.T. before sample collection', `recommendation` = 'Behavioural section of Data form  To Be looked up by R.I.', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE visitfeedback SET `feedback` = 'Universal Safety Precautions not followed', `recommendation` = 'Adequate supply of consumables to be taken up by UPSACS', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE visitfeedback SET `feedback` = 'Samples stored in freezer chamber of refrigerator.', `recommendation` = 'SOP of Sample collection & storage of serum samples & Bio medical waste disposal to be followed by HSS site staff', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE visitfeedback SET `feedback` = 'no surplus consumables provided eg 400 Cryovials for 400 samples', `recommendation` = 'HSS site staff should read the operational manual.', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 16:29:12","query":"UPDATE visitfeedback SET `feedback` = 'Behavioural aspect of Data Forms need to be looked up', `recommendation` = 'Training of Site Incharge is also recommended', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:29:12' WHERE visitfeedbackid = '3255'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE sitesupervision SET `siteid` = '1070', `userid` = '45', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-18', `numofsamplecollected` = '98', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1790', `undertrialprisoners` = '25', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '694'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr G C Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE onssid = '3104'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Satish Gangwar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE onssid = '3105'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr K P Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE onssid = '3106'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE onssid = '3107'"}
{"userId":"45","date":"2019-03-24 16:30:01","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=72756 then '2' when ansid=72758 then '0' when ansid=72760 then '400' when ansid=72762 then '2' when ansid=72764 then '2' when ansid=72766 then '1' when ansid=72768 then '400' when ansid=72770 then '1' when ansid=72772 then '1' when ansid=72774 then '1' when ansid=72776 then '2' when ansid=72778 then '100' when ansid=72780 then '0' when ansid=72782 then '500' when ansid=72784 then '400' when ansid=72786 then '1' when ansid=72788 then '500' when ansid=72790 then '400' when ansid=72792 then '1' when ansid=72794 then '1' when ansid=72796 then '5' when ansid=72798 then '1' when ansid=72800 then '4' when ansid=72802 then '1' when ansid=72804 then '1' when ansid=72806 then '0' when ansid=72808 then '3' when ansid=72810 then '1' when ansid=72812 then '8' when ansid=72813 then '2'  when ansid=72814 then ''   when ansid=72815 then '1'   when ansid=72816 then ''   when ansid=72817 then '1'   when ansid=72818 then ''   when ansid=72819 then '1'  when ansid=72820 then '10' when ansid=72821 then '1'  when ansid=72822 then 'councillar'   when ansid=72823 then '1'   when ansid=72824 then 'Yes'   when ansid=72825 then '1'  when ansid=72826 then '1' when ansid=72827 then '1' when ansid=72828 then '2' when ansid=72829 then '1' when ansid=72830 then '1' when ansid=72831 then '2' when ansid=72832 then '1' when ansid=72833 then '2' when ansid=72834 then '1' when ansid=72835 then '1' when ansid=72836 then '3' when ansid=72837 then '2' when ansid=72838 then '1' when ansid=72839 then '1'  when ansid=72840 then ''   when ansid=72841 then '1'  when ansid=72842 then '2' when ansid=72843 then '1' when ansid=72844 then '2' when ansid=72845 then '1' when ansid=72846 then '0' when ansid=72847 then 'NIL' when ansid=72848 then 'None' when ansid=72849 then 'Data forms not checked by L.T. for completeness. Gloves not discarded after each sample collection. Puncture proof jar not used for disposal of Sharps. Destroyed needle being recapped manually & hub cutter not used, No Surplus consumables provided. Cryovials Labels were stamped. Behavioural Questions in the Data forms need to be modified. HSS staff need to read operational manual & follow accordingly' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.205.104.108',\n\t\t\t\t\t\t\t\tmodifiedby =45,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-24 16:30:01'\n\t\t\t\t\t\t\tWHERE ansid in ('72756','72758','72760','72762','72764','72766','72768','72770','72772','72774','72776','72778','72780','72782','72784','72786','72788','72790','72792','72794','72796','72798','72800','72802','72804','72806','72808','72810','72812','72813','72814','72815','72816','72817','72818','72819','72820','72821','72822','72823','72824','72825','72826','72827','72828','72829','72830','72831','72832','72833','72834','72835','72836','72837','72838','72839','72840','72841','72842','72843','72844','72845','72846','72847','72848','72849')"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE supvisstepid = '4477'"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE visitfeedback SET `feedback` = 'Data forms not being checked by L.T. before sample collection', `recommendation` = 'Behavioural section of Data form  To Be looked up by R.I.', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE visitfeedbackid = '3251'"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE visitfeedback SET `feedback` = 'Universal Safety Precautions not followed', `recommendation` = 'Adequate supply of consumables to be taken up by UPSACS', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE visitfeedbackid = '3252'"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE visitfeedback SET `feedback` = 'Samples stored in freezer chamber of refrigerator.', `recommendation` = 'SOP of Sample collection & storage of serum samples & Bio medical waste disposal to be followed by HSS site staff', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE visitfeedbackid = '3253'"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE visitfeedback SET `feedback` = 'no surplus consumables provided eg 400 Cryovials for 400 samples', `recommendation` = 'HSS site staff should read the operational manual.', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE visitfeedbackid = '3254'"}
{"userId":"45","date":"2019-03-24 16:30:02","query":"UPDATE visitfeedback SET `feedback` = 'Behavioural aspect of Data Forms need to be looked up', `recommendation` = 'Training of Site Incharge is also recommended', `ipaddress` = '117.205.104.108', `modifiedby` = '45', `modifieddate` = '2019-03-24 16:30:01' WHERE visitfeedbackid = '3255'"}
{"userId":"2","date":"2019-03-24 20:22:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.161.115.46', '2019-03-24 20:22:31')"}
{"userId":"2","date":"2019-03-24 22:02:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.161.115.46', '2019-03-24 22:02:06')"}