{"userId":"2","date":"2019-03-12 10:48:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '106.223.28.201', '2019-03-12 10:48:33')"}
{"userId":"1","date":"2019-03-12 10:55:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '192.168.120.119', '2019-03-12 10:55:32')"}
{"userId":"1","date":"2019-03-12 11:24:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '192.168.120.111', '2019-03-12 11:24:19')"}
{"userId":"56","date":"2019-03-12 16:13:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('56', '117.197.139.155', '2019-03-12 16:13:00')"}
{"userId":"56","date":"2019-03-12 16:14:47","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('24', '2019-03-15', '56', '117.197.139.155', '56', '2019-03-12 16:14:47')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, ancservicedays, samplecollectiondays, samplecollectionstartdate, numofsamplecollected, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude, locationtype, establishmentyear) VALUES ('24', '826', '56', '', '', '2019-03-12', '', '1', '117.197.139.155', '56', '2019-03-12 16:14:55', '', '', '', '')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '0', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '1', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '2', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '3', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '4', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '5', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('647', '6', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('647', '', '', 'Array', '', 'Array', '', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('647', '', '', 'Array', '', 'Array', '', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('647', '', '', 'Array', '', 'Array', '', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('647', '', '', 'Array', '', 'Array', '', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:14:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"56","date":"2019-03-12 16:15:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('647', '117.197.139.155', '56', '2019-03-12 16:14:55')"}
{"userId":"43","date":"2019-03-12 21:13:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('43', '47.30.178.83', '2019-03-12 21:13:57')"}
{"userId":"2","date":"2019-03-12 21:43:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.161.115.46', '2019-03-12 21:43:47')"}
{"userId":"2","date":"2019-03-12 21:44:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '122.161.115.46', '2019-03-12 21:44:20')"}
{"userId":"2","date":"2019-03-12 21:45:13","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('275', '2019-03-09', '2', '122.161.115.46', '2', '2019-03-12 21:45:13')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, ancservicedays, samplecollectiondays, samplecollectionstartdate, numofsamplecollected, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude, locationtype, establishmentyear) VALUES ('275', '827', '2', '', '', '2019-03-12', '', '1', '122.161.115.46', '2', '2019-03-12 21:45:17', '', '', '', '')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '0', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '1', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '2', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '3', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '4', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '5', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('648', '6', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('648', '', '', 'Array', '', 'Array', '', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('648', '', '', 'Array', '', 'Array', '', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('648', '', '', 'Array', '', 'Array', '', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('648', '', '', 'Array', '', 'Array', '', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:45:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('648', '122.161.115.46', '2', '2019-03-12 21:45:17')"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '' when ansid=67929 then '' when ansid=67930 then '' when ansid=67931 then '' when ansid=67932 then ''  when ansid=67933 then ''   when ansid=67934 then ''  when ansid=67935 then '' when ansid=67937 then '' when ansid=67939 then '' when ansid=67941 then '' when ansid=67943 then '' when ansid=67945 then '' when ansid=67947 then '' when ansid=67949 then '' when ansid=67951 then '' when ansid=67953 then '' when ansid=67955 then '' when ansid=67957 then '' when ansid=67959 then '' when ansid=67961 then '' when ansid=67963 then '' when ansid=67965 then '' when ansid=67967 then '' when ansid=67969 then '' when ansid=67971 then '' when ansid=67973 then '' when ansid=67975 then '' when ansid=67977 then '' when ansid=67979 then '' when ansid=67981 then '' when ansid=67983 then '' when ansid=67985 then '' when ansid=67987 then '' when ansid=67988 then '' when ansid=67989 then '' when ansid=67990 then ''  when ansid=67991 then ''   when ansid=67992 then ''  when ansid=67993 then ''  when ansid=67994 then ''   when ansid=67995 then ''   when ansid=67996 then ''   when ansid=67997 then ''  when ansid=67998 then '' when ansid=67999 then '' when ansid=68000 then ''  when ansid=68001 then ''   when ansid=68002 then ''   when ansid=68003 then ''   when ansid=68004 then ''  when ansid=68005 then ''  when ansid=68006 then ''   when ansid=68007 then ''  when ansid=68008 then '' when ansid=68009 then '' when ansid=68010 then '' when ansid=68011 then '' when ansid=68012 then '' when ansid=68013 then '' when ansid=68014 then '' when ansid=68015 then '' when ansid=68016 then ''  when ansid=68017 then ''   when ansid=68018 then ''   when ansid=68019 then ''   when ansid=68020 then ''  when ansid=68021 then '' when ansid=68022 then ''  when ansid=68023 then ''   when ansid=68024 then ''  when ansid=68025 then '' when ansid=68026 then '' when ansid=68027 then '' when ansid=68028 then '' when ansid=68029 then '' when ansid=68030 then '' when ansid=68031 then '' when ansid=68032 then '' when ansid=68033 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 21:47:26'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE supvisstepid = '4154'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 21:47:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:47:26' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '' when ansid=67937 then '' when ansid=67939 then '' when ansid=67941 then '' when ansid=67943 then '' when ansid=67945 then '' when ansid=67947 then '' when ansid=67949 then '' when ansid=67951 then '' when ansid=67953 then '' when ansid=67955 then '' when ansid=67957 then '' when ansid=67959 then '' when ansid=67961 then '' when ansid=67963 then '' when ansid=67965 then '' when ansid=67967 then '' when ansid=67969 then '' when ansid=67971 then '' when ansid=67973 then '' when ansid=67975 then '' when ansid=67977 then '' when ansid=67979 then '' when ansid=67981 then '' when ansid=67983 then '' when ansid=67985 then '' when ansid=67987 then '' when ansid=67988 then '' when ansid=67989 then '' when ansid=67990 then ''  when ansid=67991 then ''   when ansid=67992 then ''  when ansid=67993 then ''  when ansid=67994 then ''   when ansid=67995 then ''   when ansid=67996 then ''   when ansid=67997 then ''  when ansid=67998 then '' when ansid=67999 then '' when ansid=68000 then ''  when ansid=68001 then ''   when ansid=68002 then ''   when ansid=68003 then ''   when ansid=68004 then ''  when ansid=68005 then ''  when ansid=68006 then ''   when ansid=68007 then ''  when ansid=68008 then '' when ansid=68009 then '' when ansid=68010 then '' when ansid=68011 then '' when ansid=68012 then '' when ansid=68013 then '' when ansid=68014 then '' when ansid=68015 then '' when ansid=68016 then ''  when ansid=68017 then ''   when ansid=68018 then ''   when ansid=68019 then ''   when ansid=68020 then ''  when ansid=68021 then '' when ansid=68022 then ''  when ansid=68023 then ''   when ansid=68024 then ''  when ansid=68025 then '' when ansid=68026 then '' when ansid=68027 then '' when ansid=68028 then '' when ansid=68029 then '' when ansid=68030 then '' when ansid=68031 then '' when ansid=68032 then '' when ansid=68033 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 21:48:15'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE supvisstepid = '4155'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 21:48:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:48:15' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 21:49:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '0' when ansid=67937 then '0' when ansid=67939 then '100' when ansid=67941 then '10' when ansid=67943 then '10' when ansid=67945 then '0' when ansid=67947 then '1' when ansid=67949 then '0' when ansid=67951 then '' when ansid=67953 then '' when ansid=67955 then '' when ansid=67957 then '' when ansid=67959 then '' when ansid=67961 then '' when ansid=67963 then '' when ansid=67965 then '' when ansid=67967 then '' when ansid=67969 then '' when ansid=67971 then '' when ansid=67973 then '' when ansid=67975 then '' when ansid=67977 then '' when ansid=67979 then '' when ansid=67981 then '' when ansid=67983 then '' when ansid=67985 then '' when ansid=67987 then '' when ansid=67988 then '' when ansid=67989 then '' when ansid=67990 then ''  when ansid=67991 then ''   when ansid=67992 then ''  when ansid=67993 then ''  when ansid=67994 then ''   when ansid=67995 then ''   when ansid=67996 then ''   when ansid=67997 then ''  when ansid=67998 then '' when ansid=67999 then '' when ansid=68000 then ''  when ansid=68001 then ''   when ansid=68002 then ''   when ansid=68003 then ''   when ansid=68004 then ''  when ansid=68005 then ''  when ansid=68006 then ''   when ansid=68007 then ''  when ansid=68008 then '' when ansid=68009 then '' when ansid=68010 then '' when ansid=68011 then '' when ansid=68012 then '' when ansid=68013 then '' when ansid=68014 then '' when ansid=68015 then '' when ansid=68016 then ''  when ansid=68017 then ''   when ansid=68018 then ''   when ansid=68019 then ''   when ansid=68020 then ''  when ansid=68021 then '' when ansid=68022 then ''  when ansid=68023 then ''   when ansid=68024 then ''  when ansid=68025 then '' when ansid=68026 then '' when ansid=68027 then '' when ansid=68028 then '' when ansid=68029 then '' when ansid=68030 then '' when ansid=68031 then '' when ansid=68032 then '' when ansid=68033 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 21:49:45'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE supvisstepid = '4156'"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 21:49:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:49:45' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '0' when ansid=67937 then '0' when ansid=67939 then '100' when ansid=67941 then '10' when ansid=67943 then '10' when ansid=67945 then '0' when ansid=67947 then '1' when ansid=67949 then '0' when ansid=67951 then '0' when ansid=67953 then '0' when ansid=67955 then '0' when ansid=67957 then '100' when ansid=67959 then '00' when ansid=67961 then '1' when ansid=67963 then '0' when ansid=67965 then '0' when ansid=67967 then '100' when ansid=67969 then '1' when ansid=67971 then '0' when ansid=67973 then '1' when ansid=67975 then '1' when ansid=67977 then '' when ansid=67979 then '' when ansid=67981 then '' when ansid=67983 then '' when ansid=67985 then '' when ansid=67987 then '' when ansid=67988 then '' when ansid=67989 then '' when ansid=67990 then ''  when ansid=67991 then ''   when ansid=67992 then ''  when ansid=67993 then ''  when ansid=67994 then ''   when ansid=67995 then ''   when ansid=67996 then ''   when ansid=67997 then ''  when ansid=67998 then '' when ansid=67999 then '' when ansid=68000 then ''  when ansid=68001 then ''   when ansid=68002 then ''   when ansid=68003 then ''   when ansid=68004 then ''  when ansid=68005 then ''  when ansid=68006 then ''   when ansid=68007 then ''  when ansid=68008 then '' when ansid=68009 then '' when ansid=68010 then '' when ansid=68011 then '' when ansid=68012 then '' when ansid=68013 then '' when ansid=68014 then '' when ansid=68015 then '' when ansid=68016 then ''  when ansid=68017 then ''   when ansid=68018 then ''   when ansid=68019 then ''   when ansid=68020 then ''  when ansid=68021 then '' when ansid=68022 then ''  when ansid=68023 then ''   when ansid=68024 then ''  when ansid=68025 then '' when ansid=68026 then '' when ansid=68027 then '' when ansid=68028 then '' when ansid=68029 then '' when ansid=68030 then '' when ansid=68031 then '' when ansid=68032 then '' when ansid=68033 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 21:50:27'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE supvisstepid = '4157'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 21:50:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:27' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 21:50:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '0' when ansid=67937 then '0' when ansid=67939 then '100' when ansid=67941 then '10' when ansid=67943 then '10' when ansid=67945 then '0' when ansid=67947 then '1' when ansid=67949 then '0' when ansid=67951 then '0' when ansid=67953 then '0' when ansid=67955 then '0' when ansid=67957 then '100' when ansid=67959 then '00' when ansid=67961 then '1' when ansid=67963 then '0' when ansid=67965 then '0' when ansid=67967 then '100' when ansid=67969 then '1' when ansid=67971 then '0' when ansid=67973 then '1' when ansid=67975 then '1' when ansid=67977 then '0' when ansid=67979 then '0' when ansid=67981 then '0' when ansid=67983 then '0' when ansid=67985 then '0' when ansid=67987 then '' when ansid=67988 then '' when ansid=67989 then '' when ansid=67990 then ''  when ansid=67991 then ''   when ansid=67992 then ''  when ansid=67993 then ''  when ansid=67994 then ''   when ansid=67995 then ''   when ansid=67996 then ''   when ansid=67997 then ''  when ansid=67998 then '' when ansid=67999 then '' when ansid=68000 then ''  when ansid=68001 then ''   when ansid=68002 then ''   when ansid=68003 then ''   when ansid=68004 then ''  when ansid=68005 then ''  when ansid=68006 then ''   when ansid=68007 then ''  when ansid=68008 then '' when ansid=68009 then '' when ansid=68010 then '' when ansid=68011 then '' when ansid=68012 then '' when ansid=68013 then '' when ansid=68014 then '' when ansid=68015 then '' when ansid=68016 then ''  when ansid=68017 then ''   when ansid=68018 then ''   when ansid=68019 then ''   when ansid=68020 then ''  when ansid=68021 then '' when ansid=68022 then ''  when ansid=68023 then ''   when ansid=68024 then ''  when ansid=68025 then '' when ansid=68026 then '' when ansid=68027 then '' when ansid=68028 then '' when ansid=68029 then '' when ansid=68030 then '' when ansid=68031 then '' when ansid=68032 then '' when ansid=68033 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 21:50:53'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE supvisstepid = '4158'"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 21:50:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 21:50:53' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01', `locationtype` = '2', `establishmentyear` = '2010' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '0' when ansid=67937 then '0' when ansid=67939 then '100' when ansid=67941 then '10' when ansid=67943 then '10' when ansid=67945 then '0' when ansid=67947 then '1' when ansid=67949 then '0' when ansid=67951 then '0' when ansid=67953 then '0' when ansid=67955 then '0' when ansid=67957 then '100' when ansid=67959 then '00' when ansid=67961 then '1' when ansid=67963 then '0' when ansid=67965 then '0' when ansid=67967 then '100' when ansid=67969 then '1' when ansid=67971 then '0' when ansid=67973 then '1' when ansid=67975 then '1' when ansid=67977 then '0' when ansid=67979 then '0' when ansid=67981 then '0' when ansid=67983 then '0' when ansid=67985 then '0' when ansid=67987 then '6' when ansid=67988 then '0' when ansid=67989 then '1000' when ansid=67990 then '107'  when ansid=67991 then 'No SOP followed'   when ansid=67992 then '2'  when ansid=67993 then '2'  when ansid=67994 then 'consecutiveness not followed'   when ansid=67995 then '2'   when ansid=67996 then 'consecutiveness not followed'   when ansid=67997 then '2'  when ansid=67998 then '10' when ansid=67999 then '2' when ansid=68000 then '1'  when ansid=68001 then 'Nurse'   when ansid=68002 then '1'   when ansid=68003 then 'incomplete datasheet'   when ansid=68004 then '2'  when ansid=68005 then '2'  when ansid=68006 then 'incomplete'   when ansid=68007 then '2'  when ansid=68008 then '5' when ansid=68009 then '2' when ansid=68010 then '1' when ansid=68011 then '2' when ansid=68012 then '1' when ansid=68013 then '3' when ansid=68014 then '1' when ansid=68015 then '1' when ansid=68016 then '1'  when ansid=68017 then ''   when ansid=68018 then '3'   when ansid=68019 then ''   when ansid=68020 then '1'  when ansid=68021 then '1' when ansid=68022 then '2'  when ansid=68023 then 'not available'   when ansid=68024 then '2'  when ansid=68025 then '2' when ansid=68026 then '1' when ansid=68027 then '1' when ansid=68028 then '2' when ansid=68029 then '0' when ansid=68030 then 'Consumables not supplied by district administration till 12th Feb.TO from SRL, BHU visited the site on 12th Feb and arranged the consumables' when ansid=68031 then 'TO of SRL BHU visited on 12th Feb.' when ansid=68032 then 'None of the personnel involved in HSS were trained for HSS 2019. An LT from a nearby PHC attended the training at UPSACS, but he did not handover the materials to the site personnel.Site incharge was not aware about eligibility criteria, consecutiveness not maintained. Ideal site to demonstrate problems - training not attended by any personnel; manual, chart, visit register, etc were not available. You think of any problem and you will find that problem.On site training was given to site incharge and LT.Recommendation: All collected samples should be destroyed and site should start sample collection after proper training of site personnel.' when ansid=68033 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 22:04:01'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE supvisstepid = '4159'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 22:04:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:04:01' WHERE visitfeedbackid = '3025'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE sitesupervision SET `siteid` = '275', `userid` = '2', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-12', `numofsamplecollected` = '80', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41', `locationtype` = '2', `establishmentyear` = '2010', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '648'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Anamika', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'none of the staff trained for HSS', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE onssid = '2920'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sangeeta', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE onssid = '2921'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE onsitestaffs SET `staffname` = 'Mr S Ansari', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE onssid = '2922'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE onssid = '2923'"}
{"userId":"2","date":"2019-03-12 22:05:41","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=67928 then '1' when ansid=67929 then '3' when ansid=67930 then '2' when ansid=67931 then '2' when ansid=67932 then '2'  when ansid=67933 then 'FICTC 140'   when ansid=67934 then '1'  when ansid=67935 then '0' when ansid=67937 then '0' when ansid=67939 then '100' when ansid=67941 then '10' when ansid=67943 then '10' when ansid=67945 then '0' when ansid=67947 then '1' when ansid=67949 then '0' when ansid=67951 then '0' when ansid=67953 then '0' when ansid=67955 then '0' when ansid=67957 then '100' when ansid=67959 then '00' when ansid=67961 then '1' when ansid=67963 then '0' when ansid=67965 then '0' when ansid=67967 then '100' when ansid=67969 then '1' when ansid=67971 then '0' when ansid=67973 then '1' when ansid=67975 then '1' when ansid=67977 then '0' when ansid=67979 then '0' when ansid=67981 then '0' when ansid=67983 then '0' when ansid=67985 then '0' when ansid=67987 then '6' when ansid=67988 then '0' when ansid=67989 then '1000' when ansid=67990 then '107'  when ansid=67991 then 'No SOP followed'   when ansid=67992 then '2'  when ansid=67993 then '2'  when ansid=67994 then 'consecutiveness not followed'   when ansid=67995 then '2'   when ansid=67996 then 'consecutiveness not followed'   when ansid=67997 then '2'  when ansid=67998 then '10' when ansid=67999 then '2' when ansid=68000 then '1'  when ansid=68001 then 'Nurse'   when ansid=68002 then '1'   when ansid=68003 then 'incomplete datasheet'   when ansid=68004 then '2'  when ansid=68005 then '2'  when ansid=68006 then 'incomplete'   when ansid=68007 then '2'  when ansid=68008 then '5' when ansid=68009 then '2' when ansid=68010 then '1' when ansid=68011 then '2' when ansid=68012 then '1' when ansid=68013 then '3' when ansid=68014 then '1' when ansid=68015 then '1' when ansid=68016 then '1'  when ansid=68017 then ''   when ansid=68018 then '3'   when ansid=68019 then ''   when ansid=68020 then '1'  when ansid=68021 then '1' when ansid=68022 then '2'  when ansid=68023 then 'not available'   when ansid=68024 then '2'  when ansid=68025 then '2' when ansid=68026 then '1' when ansid=68027 then '1' when ansid=68028 then '2' when ansid=68029 then '0' when ansid=68030 then 'Consumables not supplied by district administration till 12th Feb.TO from SRL, BHU visited the site on 12th Feb and arranged the consumables' when ansid=68031 then 'TO of SRL BHU visited on 12th Feb.' when ansid=68032 then 'None of the personnel involved in HSS were trained for HSS 2019. An LT from a nearby PHC attended the training at UPSACS, but he did not handover the materials to the site personnel.Site incharge was not aware about eligibility criteria, consecutiveness not maintained. Ideal site to demonstrate problems - training not attended by any personnel; manual, chart, visit register, etc were not available. You think of any problem and you will find that problem.On site training was given to site incharge and LT.Recommendation: All collected samples should be destroyed and site should start sample collection after proper training of site personnel.' when ansid=68033 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.115.46',\n\t\t\t\t\t\t\t\tmodifiedby =2,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-12 22:05:41'\n\t\t\t\t\t\t\tWHERE ansid in ('67928','67929','67930','67931','67932','67933','67934','67935','67937','67939','67941','67943','67945','67947','67949','67951','67953','67955','67957','67959','67961','67963','67965','67967','67969','67971','67973','67975','67977','67979','67981','67983','67985','67987','67988','67989','67990','67991','67992','67993','67994','67995','67996','67997','67998','67999','68000','68001','68002','68003','68004','68005','68006','68007','68008','68009','68010','68011','68012','68013','68014','68015','68016','68017','68018','68019','68020','68021','68022','68023','68024','68025','68026','68027','68028','68029','68030','68031','68032','68033')"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE supvisstepid = '4160'"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE visitfeedback SET `feedback` = 'All problems that can be imagined is present in this site.', `recommendation` = 'All collected samples should be destroyed and site should start sample collection after proper training of site personnel.', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE visitfeedbackid = '3021'"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE visitfeedback SET `feedback` = 'Site personnel not trained, consumables not available.', `recommendation` = 'Site to be visited again in next week to ensure the proper methodology is being followed', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE visitfeedbackid = '3022'"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE visitfeedback SET `feedback` = 'On site training was provided to the site incharge and LT', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE visitfeedbackid = '3023'"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE visitfeedbackid = '3024'"}
{"userId":"2","date":"2019-03-12 22:05:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.115.46', `modifiedby` = '2', `modifieddate` = '2019-03-12 22:05:41' WHERE visitfeedbackid = '3025'"}