{"userId":"7","date":"2022-11-21 16:47:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '42.108.237.58', '2022-11-21 16:47:14')"}
{"userId":"7","date":"2022-11-21 16:48:23","query":"UPDATE usermst SET `ipaddress` = '42.108.237.58', `modifiedby` = '7', `modifieddate` = '2022-11-21 16:48:23', `isdeleted` = '1' WHERE userid = '519'"}
{"userId":"7","date":"2022-11-21 16:58:06","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Aditi', 'Kulkarni', 'juniorconsultant.hss@gmail.com', '9538245885', 'Concultant', 'NARI', '036d9ba6c1d4a22f7ce827a8ef74674e', '4', '42.108.237.58', '7', '2022-11-21 16:58:06')"}
{"userId":"7","date":"2022-11-21 16:58:06","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('520', '101', '22', '380', '5', '2764', '42.108.237.58', '7', '2022-11-21 16:58:06')"}
{"userId":"520","date":"2022-11-21 16:59:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('520', '42.108.237.58', '2022-11-21 16:59:04')"}
{"userId":"520","date":"2022-11-21 17:01:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('520', '42.108.237.58', '2022-11-21 17:01:49')"}
{"userId":"520","date":"2022-11-21 17:02:17","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('475', '2022-11-30', '520', '42.108.237.58', '520', '2022-11-21 17:02:17')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('475', '2819', '520', '2022-11-21', '1', '42.108.237.58', '520', '2022-11-21 17:02:46', '', '')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2418', '0', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2418', '1', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2418', '2', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2418', '3', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2418', '4', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2418', '', '', 'Array', '', 'Array', '', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2418', '', '', 'Array', '', 'Array', '', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2418', '', '', 'Array', '', 'Array', '', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2418', '', '', 'Array', '', 'Array', '', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:02:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2418', '42.108.237.58', '520', '2022-11-21 17:02:46')"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2418'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE onssid = '10000'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE onssid = '10001'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE onssid = '10002'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE onssid = '10003'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=224137 then '' when ansid=224138 then '' when ansid=224139 then '' when ansid=224140 then '' when ansid=224141 then ''  when ansid=224142 then ''   when ansid=224143 then ''  when ansid=224186 then '' when ansid=224188 then '' when ansid=224190 then '' when ansid=224192 then '' when ansid=224194 then '' when ansid=224196 then '' when ansid=224197 then '' when ansid=224198 then '' when ansid=224199 then ''  when ansid=224200 then ''   when ansid=224201 then ''  when ansid=224202 then ''  when ansid=224203 then ''   when ansid=224204 then ''   when ansid=224205 then ''   when ansid=224206 then ''  when ansid=224207 then '' when ansid=224208 then '' when ansid=224209 then ''  when ansid=224210 then ''   when ansid=224211 then ''   when ansid=224212 then ''   when ansid=224213 then ''  when ansid=224214 then ''  when ansid=224215 then ''   when ansid=224216 then ''  when ansid=224217 then '' when ansid=224218 then '' when ansid=224219 then '' when ansid=224220 then '' when ansid=224221 then '' when ansid=224222 then '' when ansid=224223 then '' when ansid=224224 then '' when ansid=224225 then ''  when ansid=224226 then ''   when ansid=224227 then ''   when ansid=224228 then ''   when ansid=224229 then ''  when ansid=224230 then '' when ansid=224231 then ''  when ansid=224232 then ''   when ansid=224233 then ''  when ansid=224234 then '' when ansid=224235 then '' when ansid=224236 then '' when ansid=224237 then '' when ansid=224238 then '' when ansid=224239 then '' when ansid=224240 then '' when ansid=224241 then '' when ansid=224242 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '42.108.237.58',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-21 17:04:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE supvisstepid = '11970'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE visitfeedbackid = '11866'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE visitfeedbackid = '11867'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE visitfeedbackid = '11868'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE visitfeedbackid = '11869'"}
{"userId":"520","date":"2022-11-21 17:04:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '42.108.237.58', `modifiedby` = '520', `modifieddate` = '2022-11-21 17:04:34' WHERE visitfeedbackid = '11870'"}