{"userId":"309","date":"2021-07-04 16:17:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('309', '114.79.170.162', '2021-07-04 16:17:08')"}
{"userId":"309","date":"2021-07-04 16:23:40","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1249', '2021-07-04', '309', '114.79.170.162', '309', '2021-07-04 16:23:40')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1249', '2806', '309', '2021-07-04', '1', '114.79.170.162', '309', '2021-07-04 16:23:50', '', '')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2405', '0', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2405', '1', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2405', '2', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2405', '3', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2405', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2405', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2405', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2405', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 16:23:50","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2405', '114.79.170.162', '309', '2021-07-04 16:23:50')"}
{"userId":"309","date":"2021-07-04 21:37:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('309', '114.79.170.162', '2021-07-04 21:37:49')"}
{"userId":"309","date":"2021-07-04 21:46:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1714', '2021-04-22', '309', '114.79.170.162', '309', '2021-07-04 21:46:36')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1714', '2807', '309', '2021-07-04', '1', '114.79.170.162', '309', '2021-07-04 21:46:42', '', '')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2406', '0', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2406', '1', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2406', '2', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2406', '3', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2406', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2406', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2406', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2406', '', '', 'Array', '', 'Array', '', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:46:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2406', '114.79.170.162', '309', '2021-07-04 21:46:42')"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE sitesupervision SET `siteid` = '1714', `userid` = '309', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-07-04', `numofsamplecollected` = '102', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2406'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE onsitestaffs SET `staffname` = 'Sachin Kadak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE onssid = '9952'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE onsitestaffs SET `staffname` = 'Ishwari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE onssid = '9953'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE onsitestaffs SET `staffname` = 'Sheetal Khakh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE onssid = '9954'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE onssid = '9955'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=222926 then '2' when ansid=222927 then '5' when ansid=222928 then '4' when ansid=222929 then '0' when ansid=222930 then '0' when ansid=222931 then '4' when ansid=222932 then '4' when ansid=222933 then '' when ansid=222934 then '' when ansid=222935 then '' when ansid=222936 then '' when ansid=222937 then '' when ansid=222938 then '' when ansid=222939 then '' when ansid=222940 then '' when ansid=222941 then '' when ansid=222942 then '' when ansid=222943 then '' when ansid=222944 then '' when ansid=222945 then ''  when ansid=222946 then ''   when ansid=222947 then ''   when ansid=222948 then ''   when ansid=222949 then ''   when ansid=222950 then ''   when ansid=222951 then ''   when ansid=222952 then ''   when ansid=222953 then ''   when ansid=222954 then ''   when ansid=222955 then ''  when ansid=222956 then '' when ansid=222957 then '' when ansid=222958 then ''  when ansid=222959 then ''   when ansid=222960 then ''   when ansid=222961 then ''   when ansid=222962 then ''   when ansid=222963 then ''   when ansid=222964 then ''   when ansid=222965 then ''   when ansid=222966 then ''   when ansid=222967 then ''   when ansid=222968 then ''   when ansid=222969 then ''   when ansid=222970 then ''   when ansid=222971 then ''   when ansid=222972 then ''  when ansid=222973 then '' when ansid=222974 then '' when ansid=222975 then '' when ansid=222976 then '' when ansid=222977 then '' when ansid=222978 then '' when ansid=222979 then '' when ansid=222980 then '' when ansid=222981 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '114.79.170.162',\r\n\t\t\t\t\t\t\t\tmodifiedby =309,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-07-04 21:59:13'\r\n\t\t\t\t\t\t\tWHERE ansid in ('222926','222927','222928','222929','222930','222931','222932','222933','222934','222935','222936','222937','222938','222939','222940','222941','222942','222943','222944','222945','222946','222947','222948','222949','222950','222951','222952','222953','222954','222955','222956','222957','222958','222959','222960','222961','222962','222963','222964','222965','222966','222967','222968','222969','222970','222971','222972','222973','222974','222975','222976','222977','222978','222979','222980','222981')"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE supvisstepid = '11920'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE visitfeedbackid = '11806'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE visitfeedbackid = '11807'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE visitfeedbackid = '11808'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE visitfeedbackid = '11809'"}
{"userId":"309","date":"2021-07-04 21:59:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 21:59:13' WHERE visitfeedbackid = '11810'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE sitesupervision SET `siteid` = '1714', `userid` = '309', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-07-04', `numofsamplecollected` = '102', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2406'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE onsitestaffs SET `staffname` = 'Sachin Kadak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE onssid = '9952'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE onsitestaffs SET `staffname` = 'Ishwari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE onssid = '9953'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE onsitestaffs SET `staffname` = 'Sheetal Khakh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE onssid = '9954'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE onssid = '9955'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=222926 then '2' when ansid=222927 then '5' when ansid=222928 then '4' when ansid=222929 then '0' when ansid=222930 then '0' when ansid=222931 then '4' when ansid=222932 then '4' when ansid=222933 then '3' when ansid=222934 then '2' when ansid=222935 then '2' when ansid=222936 then '2' when ansid=222937 then '1' when ansid=222938 then '2' when ansid=222939 then '4' when ansid=222940 then '4' when ansid=222941 then '3' when ansid=222942 then '' when ansid=222943 then '' when ansid=222944 then '' when ansid=222945 then ''  when ansid=222946 then ''   when ansid=222947 then ''   when ansid=222948 then ''   when ansid=222949 then ''   when ansid=222950 then ''   when ansid=222951 then ''   when ansid=222952 then ''   when ansid=222953 then ''   when ansid=222954 then ''   when ansid=222955 then ''  when ansid=222956 then '' when ansid=222957 then '' when ansid=222958 then ''  when ansid=222959 then ''   when ansid=222960 then ''   when ansid=222961 then ''   when ansid=222962 then ''   when ansid=222963 then ''   when ansid=222964 then ''   when ansid=222965 then ''   when ansid=222966 then ''   when ansid=222967 then ''   when ansid=222968 then ''   when ansid=222969 then ''   when ansid=222970 then ''   when ansid=222971 then ''   when ansid=222972 then ''  when ansid=222973 then '' when ansid=222974 then '' when ansid=222975 then '' when ansid=222976 then '' when ansid=222977 then '' when ansid=222978 then '' when ansid=222979 then '' when ansid=222980 then '' when ansid=222981 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '114.79.170.162',\r\n\t\t\t\t\t\t\t\tmodifiedby =309,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-07-04 22:17:16'\r\n\t\t\t\t\t\t\tWHERE ansid in ('222926','222927','222928','222929','222930','222931','222932','222933','222934','222935','222936','222937','222938','222939','222940','222941','222942','222943','222944','222945','222946','222947','222948','222949','222950','222951','222952','222953','222954','222955','222956','222957','222958','222959','222960','222961','222962','222963','222964','222965','222966','222967','222968','222969','222970','222971','222972','222973','222974','222975','222976','222977','222978','222979','222980','222981')"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE supvisstepid = '11921'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE visitfeedbackid = '11806'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE visitfeedbackid = '11807'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE visitfeedbackid = '11808'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE visitfeedbackid = '11809'"}
{"userId":"309","date":"2021-07-04 22:17:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:17:16' WHERE visitfeedbackid = '11810'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE sitesupervision SET `siteid` = '1714', `userid` = '309', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-07-04', `numofsamplecollected` = '102', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2406'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE onsitestaffs SET `staffname` = 'Sachin Kadak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE onssid = '9952'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE onsitestaffs SET `staffname` = 'Ishwari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE onssid = '9953'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE onsitestaffs SET `staffname` = 'Sheetal Khakh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE onssid = '9954'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE onssid = '9955'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=222926 then '2' when ansid=222927 then '5' when ansid=222928 then '4' when ansid=222929 then '0' when ansid=222930 then '0' when ansid=222931 then '4' when ansid=222932 then '4' when ansid=222933 then '3' when ansid=222934 then '2' when ansid=222935 then '2' when ansid=222936 then '2' when ansid=222937 then '1' when ansid=222938 then '2' when ansid=222939 then '4' when ansid=222940 then '4' when ansid=222941 then '3' when ansid=222942 then '3' when ansid=222943 then '7' when ansid=222944 then '10' when ansid=222945 then '1'  when ansid=222946 then ''   when ansid=222947 then '1'   when ansid=222948 then ''   when ansid=222949 then '1'   when ansid=222950 then ''   when ansid=222951 then '1'   when ansid=222952 then ''   when ansid=222953 then '1'   when ansid=222954 then ''   when ansid=222955 then '1'  when ansid=222956 then '1' when ansid=222957 then '1' when ansid=222958 then '1'  when ansid=222959 then ''   when ansid=222960 then '1'   when ansid=222961 then ''   when ansid=222962 then '1'   when ansid=222963 then ''   when ansid=222964 then '1'   when ansid=222965 then ''   when ansid=222966 then '1'   when ansid=222967 then ''   when ansid=222968 then '1'   when ansid=222969 then ''   when ansid=222970 then '3'   when ansid=222971 then ''   when ansid=222972 then '2'  when ansid=222973 then '1' when ansid=222974 then '2' when ansid=222975 then '1' when ansid=222976 then '1' when ansid=222977 then '1' when ansid=222978 then 'None' when ansid=222979 then 'None' when ansid=222980 then 'None' when ansid=222981 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '114.79.170.162',\r\n\t\t\t\t\t\t\t\tmodifiedby =309,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-07-04 22:23:49'\r\n\t\t\t\t\t\t\tWHERE ansid in ('222926','222927','222928','222929','222930','222931','222932','222933','222934','222935','222936','222937','222938','222939','222940','222941','222942','222943','222944','222945','222946','222947','222948','222949','222950','222951','222952','222953','222954','222955','222956','222957','222958','222959','222960','222961','222962','222963','222964','222965','222966','222967','222968','222969','222970','222971','222972','222973','222974','222975','222976','222977','222978','222979','222980','222981')"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE supvisstepid = '11922'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE visitfeedbackid = '11806'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE visitfeedbackid = '11807'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE visitfeedbackid = '11808'"}
{"userId":"309","date":"2021-07-04 22:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE visitfeedbackid = '11809'"}
{"userId":"309","date":"2021-07-04 22:23:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:49' WHERE visitfeedbackid = '11810'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE sitesupervision SET `siteid` = '1714', `userid` = '309', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-07-04', `numofsamplecollected` = '102', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2406'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE onsitestaffs SET `staffname` = 'Sachin Kadak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE onssid = '9952'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE onsitestaffs SET `staffname` = 'Ishwari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE onssid = '9953'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE onsitestaffs SET `staffname` = 'Sheetal Khakh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE onssid = '9954'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE onssid = '9955'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=222926 then '2' when ansid=222927 then '5' when ansid=222928 then '4' when ansid=222929 then '0' when ansid=222930 then '0' when ansid=222931 then '4' when ansid=222932 then '4' when ansid=222933 then '3' when ansid=222934 then '2' when ansid=222935 then '2' when ansid=222936 then '2' when ansid=222937 then '1' when ansid=222938 then '2' when ansid=222939 then '4' when ansid=222940 then '4' when ansid=222941 then '3' when ansid=222942 then '3' when ansid=222943 then '7' when ansid=222944 then '10' when ansid=222945 then '1'  when ansid=222946 then ''   when ansid=222947 then '1'   when ansid=222948 then ''   when ansid=222949 then '1'   when ansid=222950 then ''   when ansid=222951 then '1'   when ansid=222952 then ''   when ansid=222953 then '1'   when ansid=222954 then ''   when ansid=222955 then '1'  when ansid=222956 then '1' when ansid=222957 then '1' when ansid=222958 then '1'  when ansid=222959 then ''   when ansid=222960 then '1'   when ansid=222961 then ''   when ansid=222962 then '1'   when ansid=222963 then ''   when ansid=222964 then '1'   when ansid=222965 then ''   when ansid=222966 then '1'   when ansid=222967 then ''   when ansid=222968 then '1'   when ansid=222969 then ''   when ansid=222970 then '3'   when ansid=222971 then ''   when ansid=222972 then '2'  when ansid=222973 then '1' when ansid=222974 then '2' when ansid=222975 then '1' when ansid=222976 then '1' when ansid=222977 then '1' when ansid=222978 then 'None' when ansid=222979 then 'None' when ansid=222980 then 'None' when ansid=222981 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '114.79.170.162',\r\n\t\t\t\t\t\t\t\tmodifiedby =309,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2021-07-04 22:23:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('222926','222927','222928','222929','222930','222931','222932','222933','222934','222935','222936','222937','222938','222939','222940','222941','222942','222943','222944','222945','222946','222947','222948','222949','222950','222951','222952','222953','222954','222955','222956','222957','222958','222959','222960','222961','222962','222963','222964','222965','222966','222967','222968','222969','222970','222971','222972','222973','222974','222975','222976','222977','222978','222979','222980','222981')"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE supvisstepid = '11923'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE visitfeedbackid = '11806'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE visitfeedbackid = '11807'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE visitfeedbackid = '11808'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE visitfeedbackid = '11809'"}
{"userId":"309","date":"2021-07-04 22:23:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '114.79.170.162', `modifiedby` = '309', `modifieddate` = '2021-07-04 22:23:59' WHERE visitfeedbackid = '11810'"}