{"userId":"1","date":"2021-01-12 16:26:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '117.204.228.72', '2021-01-12 16:26:01')"}
{"userId":"1","date":"2021-01-12 16:34:54","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1097', '2021-01-12', '1', '49.34.4.154', '1', '2021-01-12 16:34:54')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1097', '942', '1', '2021-01-12', '1', '49.34.4.154', '1', '2021-01-12 16:35:01', '', '')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('754', '0', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('754', '1', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('754', '2', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('754', '3', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('754', '', '', 'Array', '', 'Array', '', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('754', '', '', 'Array', '', 'Array', '', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('754', '', '', 'Array', '', 'Array', '', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('754', '', '', 'Array', '', 'Array', '', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":"1","date":"2021-01-12 16:35:01","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('754', '49.34.4.154', '1', '2021-01-12 16:35:01')"}
{"userId":null,"date":"2021-01-12 16:38:00","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('243', '298097', '0', '103.57.84.249', '', '2021-01-12 16:38:00')"}
{"userId":null,"date":"2021-01-12 16:38:30","query":"UPDATE usermst SET `password` = '8009ca5f411da17abcb455d12fcaa0a7', `modifieddate` = '2021-01-12 16:38:30', `ipaddress` = '103.57.84.249' WHERE userid = '243'"}
{"userId":"243","date":"2021-01-12 16:38:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.57.84.249', '2021-01-12 16:38:45')"}
{"userId":"243","date":"2021-01-12 16:39:30","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1097', '2021-01-11', '243', '103.57.84.249', '243', '2021-01-12 16:39:30')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1097', '943', '243', '2021-01-12', '1', '103.57.84.249', '243', '2021-01-12 16:39:40', '', '')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('755', '0', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('755', '1', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('755', '2', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('755', '3', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('755', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('755', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('755', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('755', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:39:40","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('755', '103.57.84.249', '243', '2021-01-12 16:39:40')"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '10', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '755'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE onssid = '3348'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE onssid = '3349'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE onssid = '3350'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE onssid = '3351'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78956 then '1' when ansid=78957 then '1' when ansid=78958 then '1' when ansid=78959 then '5' when ansid=78960 then '10' when ansid=78961 then '1' when ansid=78962 then '1' when ansid=78963 then '' when ansid=78964 then '' when ansid=78965 then '' when ansid=78966 then '' when ansid=78967 then '' when ansid=78968 then '' when ansid=78969 then '' when ansid=78970 then '' when ansid=78971 then '' when ansid=78972 then '' when ansid=78973 then '' when ansid=78974 then '' when ansid=78975 then ''  when ansid=78976 then ''   when ansid=78977 then ''  when ansid=78978 then ''  when ansid=78979 then ''   when ansid=78980 then ''   when ansid=78981 then ''   when ansid=78982 then ''   when ansid=78983 then ''   when ansid=78984 then ''  when ansid=78985 then '' when ansid=78986 then '' when ansid=78987 then ''  when ansid=78988 then ''   when ansid=78989 then ''   when ansid=78990 then ''   when ansid=78991 then ''   when ansid=78992 then ''   when ansid=78993 then ''   when ansid=78994 then ''   when ansid=78995 then ''   when ansid=78996 then ''   when ansid=78997 then ''   when ansid=78998 then ''   when ansid=78999 then ''   when ansid=79000 then ''   when ansid=79001 then ''  when ansid=79002 then '' when ansid=79003 then '' when ansid=79004 then '' when ansid=79005 then '' when ansid=79006 then '' when ansid=79007 then '' when ansid=79008 then '' when ansid=79009 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.57.84.249',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 16:40:39'\n\t\t\t\t\t\t\tWHERE ansid in ('78956','78957','78958','78959','78960','78961','78962','78963','78964','78965','78966','78967','78968','78969','78970','78971','78972','78973','78974','78975','78976','78977','78978','78979','78980','78981','78982','78983','78984','78985','78986','78987','78988','78989','78990','78991','78992','78993','78994','78995','78996','78997','78998','78999','79000','79001','79002','79003','79004','79005','79006','79007','79008','79009')"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE supvisstepid = '4826'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE visitfeedbackid = '3551'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE visitfeedbackid = '3552'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE visitfeedbackid = '3553'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE visitfeedbackid = '3554'"}
{"userId":"243","date":"2021-01-12 16:40:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:40:39' WHERE visitfeedbackid = '3555'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '10', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '755'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE onssid = '3348'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE onssid = '3349'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE onssid = '3350'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE onssid = '3351'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78956 then '1' when ansid=78957 then '1' when ansid=78958 then '1' when ansid=78959 then '5' when ansid=78960 then '10' when ansid=78961 then '1' when ansid=78962 then '1' when ansid=78963 then '1' when ansid=78964 then '1' when ansid=78965 then '1' when ansid=78966 then '1' when ansid=78967 then '1' when ansid=78968 then '1' when ansid=78969 then '1' when ansid=78970 then '1' when ansid=78971 then '1' when ansid=78972 then '' when ansid=78973 then '' when ansid=78974 then '' when ansid=78975 then ''  when ansid=78976 then ''   when ansid=78977 then ''  when ansid=78978 then ''  when ansid=78979 then ''   when ansid=78980 then ''   when ansid=78981 then ''   when ansid=78982 then ''   when ansid=78983 then ''   when ansid=78984 then ''  when ansid=78985 then '' when ansid=78986 then '' when ansid=78987 then ''  when ansid=78988 then ''   when ansid=78989 then ''   when ansid=78990 then ''   when ansid=78991 then ''   when ansid=78992 then ''   when ansid=78993 then ''   when ansid=78994 then ''   when ansid=78995 then ''   when ansid=78996 then ''   when ansid=78997 then ''   when ansid=78998 then ''   when ansid=78999 then ''   when ansid=79000 then ''   when ansid=79001 then ''  when ansid=79002 then '' when ansid=79003 then '' when ansid=79004 then '' when ansid=79005 then '' when ansid=79006 then '' when ansid=79007 then '' when ansid=79008 then '' when ansid=79009 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.57.84.249',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 16:41:14'\n\t\t\t\t\t\t\tWHERE ansid in ('78956','78957','78958','78959','78960','78961','78962','78963','78964','78965','78966','78967','78968','78969','78970','78971','78972','78973','78974','78975','78976','78977','78978','78979','78980','78981','78982','78983','78984','78985','78986','78987','78988','78989','78990','78991','78992','78993','78994','78995','78996','78997','78998','78999','79000','79001','79002','79003','79004','79005','79006','79007','79008','79009')"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE supvisstepid = '4827'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE visitfeedbackid = '3551'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE visitfeedbackid = '3552'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE visitfeedbackid = '3553'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE visitfeedbackid = '3554'"}
{"userId":"243","date":"2021-01-12 16:41:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.57.84.249', `modifiedby` = '243', `modifieddate` = '2021-01-12 16:41:14' WHERE visitfeedbackid = '3555'"}
{"userId":"243","date":"2021-01-12 16:44:27","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('381', '2021-01-12', '243', '103.57.84.249', '243', '2021-01-12 16:44:27')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('381', '944', '243', '2021-01-12', '1', '103.57.84.249', '243', '2021-01-12 16:44:30', '', '')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '0', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '1', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '2', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '3', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '4', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '5', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('756', '6', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('756', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('756', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('756', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('756', '', '', 'Array', '', 'Array', '', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"243","date":"2021-01-12 16:44:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('756', '103.57.84.249', '243', '2021-01-12 16:44:30')"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '10', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '755'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE onssid = '3348'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE onssid = '3349'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE onssid = '3350'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE onssid = '3351'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78956 then '1' when ansid=78957 then '1' when ansid=78958 then '1' when ansid=78959 then '5' when ansid=78960 then '10' when ansid=78961 then '1' when ansid=78962 then '1' when ansid=78963 then '1' when ansid=78964 then '1' when ansid=78965 then '1' when ansid=78966 then '1' when ansid=78967 then '1' when ansid=78968 then '1' when ansid=78969 then '1' when ansid=78970 then '1' when ansid=78971 then '1' when ansid=78972 then '' when ansid=78973 then '' when ansid=78974 then '' when ansid=78975 then ''  when ansid=78976 then ''   when ansid=78977 then ''  when ansid=78978 then ''  when ansid=78979 then ''   when ansid=78980 then ''   when ansid=78981 then ''   when ansid=78982 then ''   when ansid=78983 then ''   when ansid=78984 then ''  when ansid=78985 then '' when ansid=78986 then '' when ansid=78987 then ''  when ansid=78988 then ''   when ansid=78989 then ''   when ansid=78990 then ''   when ansid=78991 then ''   when ansid=78992 then ''   when ansid=78993 then ''   when ansid=78994 then ''   when ansid=78995 then ''   when ansid=78996 then ''   when ansid=78997 then ''   when ansid=78998 then ''   when ansid=78999 then ''   when ansid=79000 then ''   when ansid=79001 then ''  when ansid=79002 then '' when ansid=79003 then '' when ansid=79004 then '' when ansid=79005 then '' when ansid=79006 then '' when ansid=79007 then '' when ansid=79008 then '' when ansid=79009 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.4.154',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 16:50:51'\n\t\t\t\t\t\t\tWHERE ansid in ('78956','78957','78958','78959','78960','78961','78962','78963','78964','78965','78966','78967','78968','78969','78970','78971','78972','78973','78974','78975','78976','78977','78978','78979','78980','78981','78982','78983','78984','78985','78986','78987','78988','78989','78990','78991','78992','78993','78994','78995','78996','78997','78998','78999','79000','79001','79002','79003','79004','79005','79006','79007','79008','79009')"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE supvisstepid = '4827'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE visitfeedbackid = '3551'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE visitfeedbackid = '3552'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE visitfeedbackid = '3553'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE visitfeedbackid = '3554'"}
{"userId":"1","date":"2021-01-12 16:50:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.4.154', `modifiedby` = '1', `modifieddate` = '2021-01-12 16:50:51' WHERE visitfeedbackid = '3555'"}
{"userId":"1","date":"2021-01-12 16:56:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.187.59', '2021-01-12 16:56:34')"}
{"userId":"1","date":"2021-01-12 20:49:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '117.204.225.41', '2021-01-12 20:49:44')"}
{"userId":"1","date":"2021-01-12 21:44:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.162.242', '2021-01-12 21:44:09')"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '99', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '754'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE onssid = '3344'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE onssid = '3345'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE onssid = '3346'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE onssid = '3347'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78902 then '1' when ansid=78903 then '2' when ansid=78904 then '1' when ansid=78905 then '66' when ansid=78906 then '9' when ansid=78907 then '3' when ansid=78908 then '2' when ansid=78909 then '' when ansid=78910 then '' when ansid=78911 then '' when ansid=78912 then '' when ansid=78913 then '' when ansid=78914 then '' when ansid=78915 then '' when ansid=78916 then '' when ansid=78917 then '' when ansid=78918 then '' when ansid=78919 then '' when ansid=78920 then '' when ansid=78921 then ''  when ansid=78922 then ''   when ansid=78923 then ''  when ansid=78924 then ''  when ansid=78925 then ''   when ansid=78926 then ''   when ansid=78927 then ''   when ansid=78928 then ''   when ansid=78929 then ''   when ansid=78930 then ''  when ansid=78931 then '' when ansid=78932 then '' when ansid=78933 then ''  when ansid=78934 then ''   when ansid=78935 then ''   when ansid=78936 then ''   when ansid=78937 then ''   when ansid=78938 then ''   when ansid=78939 then ''   when ansid=78940 then ''   when ansid=78941 then ''   when ansid=78942 then ''   when ansid=78943 then ''   when ansid=78944 then ''   when ansid=78945 then ''   when ansid=78946 then ''   when ansid=78947 then ''  when ansid=78948 then '' when ansid=78949 then '' when ansid=78950 then '' when ansid=78951 then '' when ansid=78952 then '' when ansid=78953 then '' when ansid=78954 then '' when ansid=78955 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.162.242',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 21:45:39'\n\t\t\t\t\t\t\tWHERE ansid in ('78902','78903','78904','78905','78906','78907','78908','78909','78910','78911','78912','78913','78914','78915','78916','78917','78918','78919','78920','78921','78922','78923','78924','78925','78926','78927','78928','78929','78930','78931','78932','78933','78934','78935','78936','78937','78938','78939','78940','78941','78942','78943','78944','78945','78946','78947','78948','78949','78950','78951','78952','78953','78954','78955')"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE supvisstepid = '4822'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE visitfeedbackid = '3546'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE visitfeedbackid = '3547'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE visitfeedbackid = '3548'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE visitfeedbackid = '3549'"}
{"userId":"1","date":"2021-01-12 21:45:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:39' WHERE visitfeedbackid = '3550'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '99', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '754'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE onssid = '3344'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE onssid = '3345'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE onssid = '3346'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE onssid = '3347'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78902 then '1' when ansid=78903 then '2' when ansid=78904 then '1' when ansid=78905 then '66' when ansid=78906 then '9' when ansid=78907 then '3' when ansid=78908 then '2' when ansid=78909 then '2' when ansid=78910 then '1' when ansid=78911 then '1' when ansid=78912 then '1' when ansid=78913 then '1' when ansid=78914 then '1' when ansid=78915 then '2' when ansid=78916 then '2' when ansid=78917 then '1' when ansid=78918 then '' when ansid=78919 then '' when ansid=78920 then '' when ansid=78921 then ''  when ansid=78922 then ''   when ansid=78923 then ''  when ansid=78924 then ''  when ansid=78925 then ''   when ansid=78926 then ''   when ansid=78927 then ''   when ansid=78928 then ''   when ansid=78929 then ''   when ansid=78930 then ''  when ansid=78931 then '' when ansid=78932 then '' when ansid=78933 then ''  when ansid=78934 then ''   when ansid=78935 then ''   when ansid=78936 then ''   when ansid=78937 then ''   when ansid=78938 then ''   when ansid=78939 then ''   when ansid=78940 then ''   when ansid=78941 then ''   when ansid=78942 then ''   when ansid=78943 then ''   when ansid=78944 then ''   when ansid=78945 then ''   when ansid=78946 then ''   when ansid=78947 then ''  when ansid=78948 then '' when ansid=78949 then '' when ansid=78950 then '' when ansid=78951 then '' when ansid=78952 then '' when ansid=78953 then '' when ansid=78954 then '' when ansid=78955 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.162.242',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 21:45:53'\n\t\t\t\t\t\t\tWHERE ansid in ('78902','78903','78904','78905','78906','78907','78908','78909','78910','78911','78912','78913','78914','78915','78916','78917','78918','78919','78920','78921','78922','78923','78924','78925','78926','78927','78928','78929','78930','78931','78932','78933','78934','78935','78936','78937','78938','78939','78940','78941','78942','78943','78944','78945','78946','78947','78948','78949','78950','78951','78952','78953','78954','78955')"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE supvisstepid = '4823'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE visitfeedbackid = '3546'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE visitfeedbackid = '3547'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE visitfeedbackid = '3548'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE visitfeedbackid = '3549'"}
{"userId":"1","date":"2021-01-12 21:45:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:45:53' WHERE visitfeedbackid = '3550'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '99', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '754'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE onssid = '3344'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE onssid = '3345'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE onssid = '3346'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE onssid = '3347'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78902 then '1' when ansid=78903 then '2' when ansid=78904 then '1' when ansid=78905 then '66' when ansid=78906 then '9' when ansid=78907 then '3' when ansid=78908 then '2' when ansid=78909 then '2' when ansid=78910 then '1' when ansid=78911 then '1' when ansid=78912 then '1' when ansid=78913 then '1' when ansid=78914 then '1' when ansid=78915 then '2' when ansid=78916 then '2' when ansid=78917 then '1' when ansid=78918 then '6' when ansid=78919 then '4' when ansid=78920 then '4' when ansid=78921 then '1'  when ansid=78922 then ''   when ansid=78923 then '1'  when ansid=78924 then '2'  when ansid=78925 then ''   when ansid=78926 then '1'   when ansid=78927 then ''   when ansid=78928 then '1'   when ansid=78929 then ''   when ansid=78930 then '2'  when ansid=78931 then '1' when ansid=78932 then '1' when ansid=78933 then '1'  when ansid=78934 then ''   when ansid=78935 then '2'   when ansid=78936 then ''   when ansid=78937 then '1'   when ansid=78938 then ''   when ansid=78939 then '1'   when ansid=78940 then ''   when ansid=78941 then '2'   when ansid=78942 then ''   when ansid=78943 then '2'   when ansid=78944 then ''   when ansid=78945 then '1'   when ansid=78946 then ''   when ansid=78947 then '1'  when ansid=78948 then '2' when ansid=78949 then '1' when ansid=78950 then '1' when ansid=78951 then '1' when ansid=78952 then '2' when ansid=78953 then 'test' when ansid=78954 then 'trt' when ansid=78955 then 'trd' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.162.242',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 21:46:34'\n\t\t\t\t\t\t\tWHERE ansid in ('78902','78903','78904','78905','78906','78907','78908','78909','78910','78911','78912','78913','78914','78915','78916','78917','78918','78919','78920','78921','78922','78923','78924','78925','78926','78927','78928','78929','78930','78931','78932','78933','78934','78935','78936','78937','78938','78939','78940','78941','78942','78943','78944','78945','78946','78947','78948','78949','78950','78951','78952','78953','78954','78955')"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE supvisstepid = '4824'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE visitfeedbackid = '3546'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE visitfeedbackid = '3547'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE visitfeedbackid = '3548'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE visitfeedbackid = '3549'"}
{"userId":"1","date":"2021-01-12 21:46:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:34' WHERE visitfeedbackid = '3550'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE sitesupervision SET `siteid` = '1097', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-12', `numofsamplecollected` = '99', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '754'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE onssid = '3344'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE onssid = '3345'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE onssid = '3346'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE onssid = '3347'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=78902 then '1' when ansid=78903 then '2' when ansid=78904 then '1' when ansid=78905 then '66' when ansid=78906 then '9' when ansid=78907 then '3' when ansid=78908 then '2' when ansid=78909 then '2' when ansid=78910 then '1' when ansid=78911 then '1' when ansid=78912 then '1' when ansid=78913 then '1' when ansid=78914 then '1' when ansid=78915 then '2' when ansid=78916 then '2' when ansid=78917 then '1' when ansid=78918 then '6' when ansid=78919 then '4' when ansid=78920 then '4' when ansid=78921 then '1'  when ansid=78922 then ''   when ansid=78923 then '1'  when ansid=78924 then '2'  when ansid=78925 then ''   when ansid=78926 then '1'   when ansid=78927 then ''   when ansid=78928 then '1'   when ansid=78929 then ''   when ansid=78930 then '2'  when ansid=78931 then '1' when ansid=78932 then '1' when ansid=78933 then '1'  when ansid=78934 then ''   when ansid=78935 then '2'   when ansid=78936 then ''   when ansid=78937 then '1'   when ansid=78938 then ''   when ansid=78939 then '1'   when ansid=78940 then ''   when ansid=78941 then '2'   when ansid=78942 then ''   when ansid=78943 then '2'   when ansid=78944 then ''   when ansid=78945 then '1'   when ansid=78946 then ''   when ansid=78947 then '1'  when ansid=78948 then '2' when ansid=78949 then '1' when ansid=78950 then '1' when ansid=78951 then '1' when ansid=78952 then '2' when ansid=78953 then 'test' when ansid=78954 then 'trt' when ansid=78955 then 'trd' end),\n\t\t\t\t\t\t\t\t ipaddress = '49.34.162.242',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-12 21:46:45'\n\t\t\t\t\t\t\tWHERE ansid in ('78902','78903','78904','78905','78906','78907','78908','78909','78910','78911','78912','78913','78914','78915','78916','78917','78918','78919','78920','78921','78922','78923','78924','78925','78926','78927','78928','78929','78930','78931','78932','78933','78934','78935','78936','78937','78938','78939','78940','78941','78942','78943','78944','78945','78946','78947','78948','78949','78950','78951','78952','78953','78954','78955')"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE supvisstepid = '4825'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE visitfeedbackid = '3546'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE visitfeedbackid = '3547'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE visitfeedbackid = '3548'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE visitfeedbackid = '3549'"}
{"userId":"1","date":"2021-01-12 21:46:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.34.162.242', `modifiedby` = '1', `modifieddate` = '2021-01-12 21:46:45' WHERE visitfeedbackid = '3550'"}
{"userId":"1","date":"2021-01-12 22:25:39","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.162.242', '2021-01-12 22:25:39')"}
{"userId":"1","date":"2021-01-12 23:27:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.176.204', '2021-01-12 23:27:10')"}