{"userId":"405","date":"2021-04-12 10:33:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('405', '157.34.120.74', '2021-04-12 10:33:13')"}
{"userId":"405","date":"2021-04-12 10:33:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1311', '2021-04-10', '405', '157.34.120.74', '405', '2021-04-12 10:33:51')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1311', '2716', '405', '2021-04-12', '1', '157.34.120.74', '405', '2021-04-12 10:33:57', '', '')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2306', '0', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2306', '1', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2306', '2', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2306', '3', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2306', '', '', 'Array', '', 'Array', '', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2306', '', '', 'Array', '', 'Array', '', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2306', '', '', 'Array', '', 'Array', '', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2306', '', '', 'Array', '', 'Array', '', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:33:57","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2306', '157.34.120.74', '405', '2021-04-12 10:33:57')"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE sitesupervision SET `siteid` = '1311', `userid` = '405', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '235', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2306'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE onsitestaffs SET `staffname` = 'Ruma Bose', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE onssid = '9552'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE onsitestaffs SET `staffname` = 'Rakhi Ram Patel', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE onssid = '9553'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE onsitestaffs SET `staffname` = 'Heera Ratan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE onssid = '9554'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE onssid = '9555'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214373 then '2' when ansid=214374 then '4' when ansid=214375 then '1' when ansid=214376 then '0' when ansid=214377 then '0' when ansid=214378 then '4' when ansid=214379 then '3' when ansid=214380 then '' when ansid=214381 then '' when ansid=214382 then '' when ansid=214383 then '' when ansid=214384 then '' when ansid=214385 then '' when ansid=214386 then '' when ansid=214387 then '' when ansid=214388 then '' when ansid=214389 then '' when ansid=214390 then '' when ansid=214391 then '' when ansid=214392 then ''  when ansid=214393 then ''   when ansid=214394 then ''   when ansid=214395 then ''   when ansid=214396 then ''   when ansid=214397 then ''   when ansid=214398 then ''   when ansid=214399 then ''   when ansid=214400 then ''   when ansid=214401 then ''   when ansid=214402 then ''  when ansid=214403 then '' when ansid=214404 then '' when ansid=214405 then ''  when ansid=214406 then ''   when ansid=214407 then ''   when ansid=214408 then ''   when ansid=214409 then ''   when ansid=214410 then ''   when ansid=214411 then ''   when ansid=214412 then ''   when ansid=214413 then ''   when ansid=214414 then ''   when ansid=214415 then ''   when ansid=214416 then ''   when ansid=214417 then ''   when ansid=214418 then ''   when ansid=214419 then ''  when ansid=214420 then '' when ansid=214421 then '' when ansid=214422 then '' when ansid=214423 then '' when ansid=214424 then '' when ansid=214425 then '' when ansid=214426 then '' when ansid=214427 then '' when ansid=214428 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.120.74',\n\t\t\t\t\t\t\t\tmodifiedby =405,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 10:36:04'\n\t\t\t\t\t\t\tWHERE ansid in ('214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428')"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE supvisstepid = '11455'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE visitfeedbackid = '11306'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE visitfeedbackid = '11307'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE visitfeedbackid = '11308'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE visitfeedbackid = '11309'"}
{"userId":"405","date":"2021-04-12 10:36:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:04' WHERE visitfeedbackid = '11310'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE sitesupervision SET `siteid` = '1311', `userid` = '405', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '235', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2306'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE onsitestaffs SET `staffname` = 'Ruma Bose', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE onssid = '9552'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE onsitestaffs SET `staffname` = 'Rakhi Ram Patel', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE onssid = '9553'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE onsitestaffs SET `staffname` = 'Heera Ratan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE onssid = '9554'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE onssid = '9555'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214373 then '2' when ansid=214374 then '4' when ansid=214375 then '1' when ansid=214376 then '0' when ansid=214377 then '0' when ansid=214378 then '4' when ansid=214379 then '3' when ansid=214380 then '1' when ansid=214381 then '1' when ansid=214382 then '1' when ansid=214383 then '1' when ansid=214384 then '1' when ansid=214385 then '2' when ansid=214386 then '4' when ansid=214387 then '1' when ansid=214388 then '1' when ansid=214389 then '' when ansid=214390 then '' when ansid=214391 then '' when ansid=214392 then ''  when ansid=214393 then ''   when ansid=214394 then ''   when ansid=214395 then ''   when ansid=214396 then ''   when ansid=214397 then ''   when ansid=214398 then ''   when ansid=214399 then ''   when ansid=214400 then ''   when ansid=214401 then ''   when ansid=214402 then ''  when ansid=214403 then '' when ansid=214404 then '' when ansid=214405 then ''  when ansid=214406 then ''   when ansid=214407 then ''   when ansid=214408 then ''   when ansid=214409 then ''   when ansid=214410 then ''   when ansid=214411 then ''   when ansid=214412 then ''   when ansid=214413 then ''   when ansid=214414 then ''   when ansid=214415 then ''   when ansid=214416 then ''   when ansid=214417 then ''   when ansid=214418 then ''   when ansid=214419 then ''  when ansid=214420 then '' when ansid=214421 then '' when ansid=214422 then '' when ansid=214423 then '' when ansid=214424 then '' when ansid=214425 then '' when ansid=214426 then '' when ansid=214427 then '' when ansid=214428 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.120.74',\n\t\t\t\t\t\t\t\tmodifiedby =405,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 10:36:52'\n\t\t\t\t\t\t\tWHERE ansid in ('214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428')"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE supvisstepid = '11456'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE visitfeedbackid = '11306'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE visitfeedbackid = '11307'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE visitfeedbackid = '11308'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE visitfeedbackid = '11309'"}
{"userId":"405","date":"2021-04-12 10:36:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:36:52' WHERE visitfeedbackid = '11310'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE sitesupervision SET `siteid` = '1311', `userid` = '405', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '235', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2306'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE onsitestaffs SET `staffname` = 'Ruma Bose', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE onssid = '9552'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE onsitestaffs SET `staffname` = 'Rakhi Ram Patel', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE onssid = '9553'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE onsitestaffs SET `staffname` = 'Heera Ratan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE onssid = '9554'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE onssid = '9555'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214373 then '2' when ansid=214374 then '4' when ansid=214375 then '1' when ansid=214376 then '0' when ansid=214377 then '0' when ansid=214378 then '4' when ansid=214379 then '3' when ansid=214380 then '1' when ansid=214381 then '1' when ansid=214382 then '1' when ansid=214383 then '1' when ansid=214384 then '1' when ansid=214385 then '2' when ansid=214386 then '4' when ansid=214387 then '1' when ansid=214388 then '1' when ansid=214389 then '4' when ansid=214390 then '4' when ansid=214391 then '4' when ansid=214392 then '1'  when ansid=214393 then ''   when ansid=214394 then '1'   when ansid=214395 then ''   when ansid=214396 then '1'   when ansid=214397 then ''   when ansid=214398 then '1'   when ansid=214399 then ''   when ansid=214400 then '1'   when ansid=214401 then ''   when ansid=214402 then '1'  when ansid=214403 then '1' when ansid=214404 then '1' when ansid=214405 then '1'  when ansid=214406 then ''   when ansid=214407 then '1'   when ansid=214408 then ''   when ansid=214409 then '1'   when ansid=214410 then ''   when ansid=214411 then '1'   when ansid=214412 then ''   when ansid=214413 then '1'   when ansid=214414 then ''   when ansid=214415 then '1'   when ansid=214416 then ''   when ansid=214417 then '2'   when ansid=214418 then ''   when ansid=214419 then '2'  when ansid=214420 then '1' when ansid=214421 then '1' when ansid=214422 then '1' when ansid=214423 then '1' when ansid=214424 then '1' when ansid=214425 then 'No any' when ansid=214426 then 'No Any' when ansid=214427 then 'Recommended to Lab Technician to collect properly blood on DBS Card' when ansid=214428 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.120.74',\n\t\t\t\t\t\t\t\tmodifiedby =405,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 10:39:16'\n\t\t\t\t\t\t\tWHERE ansid in ('214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428')"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE supvisstepid = '11457'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE visitfeedbackid = '11306'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE visitfeedbackid = '11307'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE visitfeedbackid = '11308'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE visitfeedbackid = '11309'"}
{"userId":"405","date":"2021-04-12 10:39:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:39:16' WHERE visitfeedbackid = '11310'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE sitesupervision SET `siteid` = '1311', `userid` = '405', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '235', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2306'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE onsitestaffs SET `staffname` = 'Ruma Bose', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE onssid = '9552'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE onsitestaffs SET `staffname` = 'Rakhi Ram Patel', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE onssid = '9553'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE onsitestaffs SET `staffname` = 'Heera Ratan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE onssid = '9554'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE onssid = '9555'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214373 then '2' when ansid=214374 then '4' when ansid=214375 then '1' when ansid=214376 then '0' when ansid=214377 then '0' when ansid=214378 then '4' when ansid=214379 then '3' when ansid=214380 then '1' when ansid=214381 then '1' when ansid=214382 then '1' when ansid=214383 then '1' when ansid=214384 then '1' when ansid=214385 then '2' when ansid=214386 then '4' when ansid=214387 then '1' when ansid=214388 then '1' when ansid=214389 then '4' when ansid=214390 then '4' when ansid=214391 then '4' when ansid=214392 then '1'  when ansid=214393 then ''   when ansid=214394 then '1'   when ansid=214395 then ''   when ansid=214396 then '1'   when ansid=214397 then ''   when ansid=214398 then '1'   when ansid=214399 then ''   when ansid=214400 then '1'   when ansid=214401 then ''   when ansid=214402 then '1'  when ansid=214403 then '1' when ansid=214404 then '1' when ansid=214405 then '1'  when ansid=214406 then ''   when ansid=214407 then '1'   when ansid=214408 then ''   when ansid=214409 then '1'   when ansid=214410 then ''   when ansid=214411 then '1'   when ansid=214412 then ''   when ansid=214413 then '1'   when ansid=214414 then ''   when ansid=214415 then '1'   when ansid=214416 then ''   when ansid=214417 then '2'   when ansid=214418 then ''   when ansid=214419 then '2'  when ansid=214420 then '1' when ansid=214421 then '1' when ansid=214422 then '1' when ansid=214423 then '1' when ansid=214424 then '1' when ansid=214425 then 'No any' when ansid=214426 then 'No Any' when ansid=214427 then 'Recommended to Lab Technician to collect properly blood on DBS Card' when ansid=214428 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.120.74',\n\t\t\t\t\t\t\t\tmodifiedby =405,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 10:40:00'\n\t\t\t\t\t\t\tWHERE ansid in ('214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428')"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE supvisstepid = '11458'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE visitfeedback SET `feedback` = 'No Any', `recommendation` = 'Recommended to Site In-charge to dispatch the all collected Blood sample and record in every week as per guidline', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE visitfeedbackid = '11306'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE visitfeedback SET `feedback` = 'No Any', `recommendation` = 'No Any', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE visitfeedbackid = '11307'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE visitfeedback SET `feedback` = 'No Any', `recommendation` = 'No Any', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE visitfeedbackid = '11308'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE visitfeedback SET `feedback` = 'No Any', `recommendation` = 'No Any', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE visitfeedbackid = '11309'"}
{"userId":"405","date":"2021-04-12 10:40:00","query":"UPDATE visitfeedback SET `feedback` = 'No Any', `recommendation` = 'No Any', `ipaddress` = '157.34.120.74', `modifiedby` = '405', `modifieddate` = '2021-04-12 10:40:00' WHERE visitfeedbackid = '11310'"}
{"userId":"488","date":"2021-04-12 11:32:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('488', '112.133.207.122', '2021-04-12 11:32:37')"}
{"userId":"488","date":"2021-04-12 12:21:11","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('719', '2021-03-06', '488', '112.133.207.122', '488', '2021-04-12 12:21:11')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('719', '2717', '488', '2021-04-12', '1', '112.133.207.122', '488', '2021-04-12 12:21:32', '', '')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2307', '0', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2307', '1', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2307', '2', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2307', '3', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2307', '4', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2307', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2307', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2307', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2307', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:21:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2307', '112.133.207.122', '488', '2021-04-12 12:21:32')"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE onsitestaffs SET `staffname` = 'O.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '' when ansid=214430 then '' when ansid=214431 then '' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then ''   when ansid=214435 then ''  when ansid=214478 then '' when ansid=214480 then '' when ansid=214482 then '' when ansid=214484 then '' when ansid=214486 then '' when ansid=214488 then '' when ansid=214489 then '' when ansid=214490 then '' when ansid=214491 then ''  when ansid=214492 then ''   when ansid=214493 then ''  when ansid=214494 then ''  when ansid=214495 then ''   when ansid=214496 then ''   when ansid=214497 then ''   when ansid=214498 then ''  when ansid=214499 then '' when ansid=214500 then '' when ansid=214501 then ''  when ansid=214502 then ''   when ansid=214503 then ''   when ansid=214504 then ''   when ansid=214505 then ''  when ansid=214506 then ''  when ansid=214507 then ''   when ansid=214508 then ''  when ansid=214509 then '' when ansid=214510 then '' when ansid=214511 then '' when ansid=214512 then '' when ansid=214513 then '' when ansid=214514 then '' when ansid=214515 then '' when ansid=214516 then '' when ansid=214517 then ''  when ansid=214518 then ''   when ansid=214519 then ''   when ansid=214520 then ''   when ansid=214521 then ''  when ansid=214522 then '' when ansid=214523 then ''  when ansid=214524 then ''   when ansid=214525 then ''  when ansid=214526 then '' when ansid=214527 then '' when ansid=214528 then '' when ansid=214529 then '' when ansid=214530 then '' when ansid=214531 then '' when ansid=214532 then '' when ansid=214533 then '' when ansid=214534 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:23:23'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE supvisstepid = '11459'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:23:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:23' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE onsitestaffs SET `staffname` = 'O.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '' when ansid=214480 then '' when ansid=214482 then '' when ansid=214484 then '' when ansid=214486 then '' when ansid=214488 then '' when ansid=214489 then '' when ansid=214490 then '' when ansid=214491 then ''  when ansid=214492 then ''   when ansid=214493 then ''  when ansid=214494 then ''  when ansid=214495 then ''   when ansid=214496 then ''   when ansid=214497 then ''   when ansid=214498 then ''  when ansid=214499 then '' when ansid=214500 then '' when ansid=214501 then ''  when ansid=214502 then ''   when ansid=214503 then ''   when ansid=214504 then ''   when ansid=214505 then ''  when ansid=214506 then ''  when ansid=214507 then ''   when ansid=214508 then ''  when ansid=214509 then '' when ansid=214510 then '' when ansid=214511 then '' when ansid=214512 then '' when ansid=214513 then '' when ansid=214514 then '' when ansid=214515 then '' when ansid=214516 then '' when ansid=214517 then ''  when ansid=214518 then ''   when ansid=214519 then ''   when ansid=214520 then ''   when ansid=214521 then ''  when ansid=214522 then '' when ansid=214523 then ''  when ansid=214524 then ''   when ansid=214525 then ''  when ansid=214526 then '' when ansid=214527 then '' when ansid=214528 then '' when ansid=214529 then '' when ansid=214530 then '' when ansid=214531 then '' when ansid=214532 then '' when ansid=214533 then '' when ansid=214534 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:23:49'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE supvisstepid = '11460'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:23:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:23:49' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE onsitestaffs SET `staffname` = 'O.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '' when ansid=214489 then '' when ansid=214490 then '' when ansid=214491 then ''  when ansid=214492 then ''   when ansid=214493 then ''  when ansid=214494 then ''  when ansid=214495 then ''   when ansid=214496 then ''   when ansid=214497 then ''   when ansid=214498 then ''  when ansid=214499 then '' when ansid=214500 then '' when ansid=214501 then ''  when ansid=214502 then ''   when ansid=214503 then ''   when ansid=214504 then ''   when ansid=214505 then ''  when ansid=214506 then ''  when ansid=214507 then ''   when ansid=214508 then ''  when ansid=214509 then '' when ansid=214510 then '' when ansid=214511 then '' when ansid=214512 then '' when ansid=214513 then '' when ansid=214514 then '' when ansid=214515 then '' when ansid=214516 then '' when ansid=214517 then ''  when ansid=214518 then ''   when ansid=214519 then ''   when ansid=214520 then ''   when ansid=214521 then ''  when ansid=214522 then '' when ansid=214523 then ''  when ansid=214524 then ''   when ansid=214525 then ''  when ansid=214526 then '' when ansid=214527 then '' when ansid=214528 then '' when ansid=214529 then '' when ansid=214530 then '' when ansid=214531 then '' when ansid=214532 then '' when ansid=214533 then '' when ansid=214534 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:24:08'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE supvisstepid = '11461'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:24:08' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE onsitestaffs SET `staffname` = 'O.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '4' when ansid=214489 then '0' when ansid=214490 then '100' when ansid=214491 then '22'  when ansid=214492 then ''   when ansid=214493 then '1'  when ansid=214494 then '1'  when ansid=214495 then ''   when ansid=214496 then '1'   when ansid=214497 then ''   when ansid=214498 then '1'  when ansid=214499 then '10' when ansid=214500 then '1' when ansid=214501 then '1'  when ansid=214502 then 'Counsellor'   when ansid=214503 then '1'   when ansid=214504 then ''   when ansid=214505 then '1'  when ansid=214506 then '1'  when ansid=214507 then ''   when ansid=214508 then '1'  when ansid=214509 then '2' when ansid=214510 then '1' when ansid=214511 then '1' when ansid=214512 then '1' when ansid=214513 then '1' when ansid=214514 then '3' when ansid=214515 then '1' when ansid=214516 then '2' when ansid=214517 then '1'  when ansid=214518 then 'yet to dispatch'   when ansid=214519 then '5'   when ansid=214520 then 'yet to dispatch'   when ansid=214521 then '2'  when ansid=214522 then '1' when ansid=214523 then '1'  when ansid=214524 then ''   when ansid=214525 then '1'  when ansid=214526 then '1' when ansid=214527 then '3' when ansid=214528 then '3' when ansid=214529 then '1' when ansid=214530 then '0' when ansid=214531 then 'Serum vials are not in good qualityLabels are not issuesed so labelling is not done as per procedure' when ansid=214532 then 'No' when ansid=214533 then 'Lab technician not available, general technician only collecting blood samples.Referred Sacs to coordinate and do the needful for this site' when ansid=214534 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:33:16'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE supvisstepid = '11462'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:33:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:33:16' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE onsitestaffs SET `staffname` = 'B.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '4' when ansid=214489 then '0' when ansid=214490 then '100' when ansid=214491 then '22'  when ansid=214492 then ''   when ansid=214493 then '1'  when ansid=214494 then '1'  when ansid=214495 then ''   when ansid=214496 then '1'   when ansid=214497 then ''   when ansid=214498 then '1'  when ansid=214499 then '10' when ansid=214500 then '1' when ansid=214501 then '1'  when ansid=214502 then 'Counsellor'   when ansid=214503 then '1'   when ansid=214504 then ''   when ansid=214505 then '1'  when ansid=214506 then '1'  when ansid=214507 then ''   when ansid=214508 then '1'  when ansid=214509 then '2' when ansid=214510 then '1' when ansid=214511 then '1' when ansid=214512 then '1' when ansid=214513 then '1' when ansid=214514 then '3' when ansid=214515 then '1' when ansid=214516 then '2' when ansid=214517 then '1'  when ansid=214518 then 'yet to dispatch'   when ansid=214519 then '5'   when ansid=214520 then 'yet to dispatch'   when ansid=214521 then '2'  when ansid=214522 then '1' when ansid=214523 then '1'  when ansid=214524 then ''   when ansid=214525 then '1'  when ansid=214526 then '1' when ansid=214527 then '3' when ansid=214528 then '3' when ansid=214529 then '1' when ansid=214530 then '0' when ansid=214531 then 'Serum vials are not in good qualityLabels are not issuesed so labelling is not done as per procedure' when ansid=214532 then 'No' when ansid=214533 then 'Lab technician not available, general technician only collecting blood samples.Referred Sacs to coordinate and do the needful for this site' when ansid=214534 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:34:44'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE supvisstepid = '11459'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE visitfeedback SET `feedback` = 'Labels are not issued', `recommendation` = 'Coordinate with Sacs', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:34:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:44' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE onsitestaffs SET `staffname` = 'B.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '4' when ansid=214489 then '0' when ansid=214490 then '100' when ansid=214491 then '22'  when ansid=214492 then ''   when ansid=214493 then '1'  when ansid=214494 then '1'  when ansid=214495 then ''   when ansid=214496 then '1'   when ansid=214497 then ''   when ansid=214498 then '1'  when ansid=214499 then '10' when ansid=214500 then '1' when ansid=214501 then '1'  when ansid=214502 then 'Counsellor'   when ansid=214503 then '1'   when ansid=214504 then ''   when ansid=214505 then '1'  when ansid=214506 then '1'  when ansid=214507 then ''   when ansid=214508 then '1'  when ansid=214509 then '2' when ansid=214510 then '1' when ansid=214511 then '1' when ansid=214512 then '1' when ansid=214513 then '1' when ansid=214514 then '3' when ansid=214515 then '1' when ansid=214516 then '2' when ansid=214517 then '1'  when ansid=214518 then 'yet to dispatch'   when ansid=214519 then '5'   when ansid=214520 then 'yet to dispatch'   when ansid=214521 then '2'  when ansid=214522 then '1' when ansid=214523 then '1'  when ansid=214524 then ''   when ansid=214525 then '1'  when ansid=214526 then '1' when ansid=214527 then '3' when ansid=214528 then '3' when ansid=214529 then '1' when ansid=214530 then '0' when ansid=214531 then 'Serum vials are not in good qualityLabels are not issuesed so labelling is not done as per procedure' when ansid=214532 then 'No' when ansid=214533 then 'Lab technician not available, general technician only collecting blood samples.Referred Sacs to coordinate and do the needful for this site' when ansid=214534 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:34:47'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE supvisstepid = '11460'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE visitfeedback SET `feedback` = 'Labels are not issued', `recommendation` = 'Coordinate with Sacs', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:34:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:47' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE onsitestaffs SET `staffname` = 'B.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '4' when ansid=214489 then '0' when ansid=214490 then '100' when ansid=214491 then '22'  when ansid=214492 then ''   when ansid=214493 then '1'  when ansid=214494 then '1'  when ansid=214495 then ''   when ansid=214496 then '1'   when ansid=214497 then ''   when ansid=214498 then '1'  when ansid=214499 then '10' when ansid=214500 then '1' when ansid=214501 then '1'  when ansid=214502 then 'Counsellor'   when ansid=214503 then '1'   when ansid=214504 then ''   when ansid=214505 then '1'  when ansid=214506 then '1'  when ansid=214507 then ''   when ansid=214508 then '1'  when ansid=214509 then '2' when ansid=214510 then '1' when ansid=214511 then '1' when ansid=214512 then '1' when ansid=214513 then '1' when ansid=214514 then '3' when ansid=214515 then '1' when ansid=214516 then '2' when ansid=214517 then '1'  when ansid=214518 then 'yet to dispatch'   when ansid=214519 then '5'   when ansid=214520 then 'yet to dispatch'   when ansid=214521 then '2'  when ansid=214522 then '1' when ansid=214523 then '1'  when ansid=214524 then ''   when ansid=214525 then '1'  when ansid=214526 then '1' when ansid=214527 then '3' when ansid=214528 then '3' when ansid=214529 then '1' when ansid=214530 then '0' when ansid=214531 then 'Serum vials are not in good qualityLabels are not issuesed so labelling is not done as per procedure' when ansid=214532 then 'No' when ansid=214533 then 'Lab technician not available, general technician only collecting blood samples.Referred Sacs to coordinate and do the needful for this site' when ansid=214534 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:34:49'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE supvisstepid = '11461'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE visitfeedback SET `feedback` = 'Labels are not issued', `recommendation` = 'Coordinate with Sacs', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:34:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:34:49' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE sitesupervision SET `siteid` = '719', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-04-12', `numofsamplecollected` = '70', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27', `locationtype` = '2', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2307'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.K.Subramaniyan Raja', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE onssid = '9556'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE onsitestaffs SET `staffname` = 'B.Bharathi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE onssid = '9557'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE onssid = '9558'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE onssid = '9559'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214429 then '1' when ansid=214430 then '1' when ansid=214431 then '1' when ansid=214432 then '' when ansid=214433 then ''  when ansid=214434 then '337'   when ansid=214435 then '1'  when ansid=214478 then '1' when ansid=214480 then '1' when ansid=214482 then '1' when ansid=214484 then '3' when ansid=214486 then '1' when ansid=214488 then '4' when ansid=214489 then '0' when ansid=214490 then '100' when ansid=214491 then '22'  when ansid=214492 then ''   when ansid=214493 then '1'  when ansid=214494 then '1'  when ansid=214495 then ''   when ansid=214496 then '1'   when ansid=214497 then ''   when ansid=214498 then '1'  when ansid=214499 then '10' when ansid=214500 then '1' when ansid=214501 then '1'  when ansid=214502 then 'Counsellor'   when ansid=214503 then '1'   when ansid=214504 then ''   when ansid=214505 then '1'  when ansid=214506 then '1'  when ansid=214507 then ''   when ansid=214508 then '1'  when ansid=214509 then '2' when ansid=214510 then '1' when ansid=214511 then '1' when ansid=214512 then '1' when ansid=214513 then '1' when ansid=214514 then '3' when ansid=214515 then '1' when ansid=214516 then '2' when ansid=214517 then '1'  when ansid=214518 then 'yet to dispatch'   when ansid=214519 then '5'   when ansid=214520 then 'yet to dispatch'   when ansid=214521 then '2'  when ansid=214522 then '1' when ansid=214523 then '1'  when ansid=214524 then ''   when ansid=214525 then '1'  when ansid=214526 then '1' when ansid=214527 then '3' when ansid=214528 then '3' when ansid=214529 then '1' when ansid=214530 then '0' when ansid=214531 then 'Serum vials are not in good qualityLabels are not issuesed so labelling is not done as per procedure' when ansid=214532 then 'No' when ansid=214533 then 'Lab technician not available, general technician only collecting blood samples.Referred Sacs to coordinate and do the needful for this site' when ansid=214534 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:35:27'\n\t\t\t\t\t\t\tWHERE ansid in ('214429','214430','214431','214432','214433','214434','214435','214478','214480','214482','214484','214486','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534')"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE supvisstepid = '11463'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE visitfeedback SET `feedback` = 'Labels are not issued', `recommendation` = 'Coordinate with Sacs', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE visitfeedbackid = '11311'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE visitfeedbackid = '11312'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE visitfeedbackid = '11313'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE visitfeedbackid = '11314'"}
{"userId":"488","date":"2021-04-12 12:35:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:35:27' WHERE visitfeedbackid = '11315'"}
{"userId":"488","date":"2021-04-12 12:49:05","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('721', '2021-03-05', '488', '112.133.207.122', '488', '2021-04-12 12:49:05')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('721', '2718', '488', '2021-04-12', '1', '112.133.207.122', '488', '2021-04-12 12:49:09', '', '')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2308', '0', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2308', '1', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2308', '2', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2308', '3', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2308', '4', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2308', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2308', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2308', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2308', '', '', 'Array', '', 'Array', '', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:49:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2308', '112.133.207.122', '488', '2021-04-12 12:49:09')"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE sitesupervision SET `siteid` = '721', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-15', `numofsamplecollected` = '198', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2308'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Sandhya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE onssid = '9560'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE onsitestaffs SET `staffname` = 'B.Eswaramma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE onssid = '9561'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE onsitestaffs SET `staffname` = 'G.Sagendra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE onssid = '9562'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE onssid = '9563'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214535 then '' when ansid=214536 then '' when ansid=214537 then '' when ansid=214538 then '' when ansid=214539 then ''  when ansid=214540 then ''   when ansid=214541 then ''  when ansid=214584 then '' when ansid=214586 then '' when ansid=214588 then '' when ansid=214590 then '' when ansid=214592 then '' when ansid=214594 then '' when ansid=214595 then '' when ansid=214596 then '' when ansid=214597 then ''  when ansid=214598 then ''   when ansid=214599 then ''  when ansid=214600 then ''  when ansid=214601 then ''   when ansid=214602 then ''   when ansid=214603 then ''   when ansid=214604 then ''  when ansid=214605 then '' when ansid=214606 then '' when ansid=214607 then ''  when ansid=214608 then ''   when ansid=214609 then ''   when ansid=214610 then ''   when ansid=214611 then ''  when ansid=214612 then ''  when ansid=214613 then ''   when ansid=214614 then ''  when ansid=214615 then '' when ansid=214616 then '' when ansid=214617 then '' when ansid=214618 then '' when ansid=214619 then '' when ansid=214620 then '' when ansid=214621 then '' when ansid=214622 then '' when ansid=214623 then ''  when ansid=214624 then ''   when ansid=214625 then ''   when ansid=214626 then ''   when ansid=214627 then ''  when ansid=214628 then '' when ansid=214629 then ''  when ansid=214630 then ''   when ansid=214631 then ''  when ansid=214632 then '' when ansid=214633 then '' when ansid=214634 then '' when ansid=214635 then '' when ansid=214636 then '' when ansid=214637 then '' when ansid=214638 then '' when ansid=214639 then '' when ansid=214640 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:50:58'\n\t\t\t\t\t\t\tWHERE ansid in ('214535','214536','214537','214538','214539','214540','214541','214584','214586','214588','214590','214592','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640')"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE supvisstepid = '11464'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE visitfeedbackid = '11316'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE visitfeedbackid = '11317'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE visitfeedbackid = '11318'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE visitfeedbackid = '11319'"}
{"userId":"488","date":"2021-04-12 12:50:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:50:58' WHERE visitfeedbackid = '11320'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE sitesupervision SET `siteid` = '721', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-15', `numofsamplecollected` = '198', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2308'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Sandhya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE onssid = '9560'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'B.Eswaramma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE onssid = '9561'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE onsitestaffs SET `staffname` = 'G.Sagendra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE onssid = '9562'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE onssid = '9563'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214535 then '1' when ansid=214536 then '1' when ansid=214537 then '1' when ansid=214538 then '' when ansid=214539 then ''  when ansid=214540 then '401'   when ansid=214541 then '1'  when ansid=214584 then '' when ansid=214586 then '' when ansid=214588 then '' when ansid=214590 then '' when ansid=214592 then '' when ansid=214594 then '' when ansid=214595 then '' when ansid=214596 then '' when ansid=214597 then ''  when ansid=214598 then ''   when ansid=214599 then ''  when ansid=214600 then ''  when ansid=214601 then ''   when ansid=214602 then ''   when ansid=214603 then ''   when ansid=214604 then ''  when ansid=214605 then '' when ansid=214606 then '' when ansid=214607 then ''  when ansid=214608 then ''   when ansid=214609 then ''   when ansid=214610 then ''   when ansid=214611 then ''  when ansid=214612 then ''  when ansid=214613 then ''   when ansid=214614 then ''  when ansid=214615 then '' when ansid=214616 then '' when ansid=214617 then '' when ansid=214618 then '' when ansid=214619 then '' when ansid=214620 then '' when ansid=214621 then '' when ansid=214622 then '' when ansid=214623 then ''  when ansid=214624 then ''   when ansid=214625 then ''   when ansid=214626 then ''   when ansid=214627 then ''  when ansid=214628 then '' when ansid=214629 then ''  when ansid=214630 then ''   when ansid=214631 then ''  when ansid=214632 then '' when ansid=214633 then '' when ansid=214634 then '' when ansid=214635 then '' when ansid=214636 then '' when ansid=214637 then '' when ansid=214638 then '' when ansid=214639 then '' when ansid=214640 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:51:20'\n\t\t\t\t\t\t\tWHERE ansid in ('214535','214536','214537','214538','214539','214540','214541','214584','214586','214588','214590','214592','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640')"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE supvisstepid = '11465'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE visitfeedbackid = '11316'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE visitfeedbackid = '11317'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE visitfeedbackid = '11318'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE visitfeedbackid = '11319'"}
{"userId":"488","date":"2021-04-12 12:51:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:20' WHERE visitfeedbackid = '11320'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE sitesupervision SET `siteid` = '721', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-15', `numofsamplecollected` = '198', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2308'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Sandhya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE onssid = '9560'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE onsitestaffs SET `staffname` = 'B.Eswaramma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE onssid = '9561'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE onsitestaffs SET `staffname` = 'G.Sagendra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE onssid = '9562'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE onssid = '9563'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214535 then '1' when ansid=214536 then '1' when ansid=214537 then '1' when ansid=214538 then '' when ansid=214539 then ''  when ansid=214540 then '401'   when ansid=214541 then '1'  when ansid=214584 then '0' when ansid=214586 then '0' when ansid=214588 then '0' when ansid=214590 then '0' when ansid=214592 then '1' when ansid=214594 then '' when ansid=214595 then '' when ansid=214596 then '' when ansid=214597 then ''  when ansid=214598 then ''   when ansid=214599 then ''  when ansid=214600 then ''  when ansid=214601 then ''   when ansid=214602 then ''   when ansid=214603 then ''   when ansid=214604 then ''  when ansid=214605 then '' when ansid=214606 then '' when ansid=214607 then ''  when ansid=214608 then ''   when ansid=214609 then ''   when ansid=214610 then ''   when ansid=214611 then ''  when ansid=214612 then ''  when ansid=214613 then ''   when ansid=214614 then ''  when ansid=214615 then '' when ansid=214616 then '' when ansid=214617 then '' when ansid=214618 then '' when ansid=214619 then '' when ansid=214620 then '' when ansid=214621 then '' when ansid=214622 then '' when ansid=214623 then ''  when ansid=214624 then ''   when ansid=214625 then ''   when ansid=214626 then ''   when ansid=214627 then ''  when ansid=214628 then '' when ansid=214629 then ''  when ansid=214630 then ''   when ansid=214631 then ''  when ansid=214632 then '' when ansid=214633 then '' when ansid=214634 then '' when ansid=214635 then '' when ansid=214636 then '' when ansid=214637 then '' when ansid=214638 then '' when ansid=214639 then '' when ansid=214640 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '112.133.207.122',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:51:49'\n\t\t\t\t\t\t\tWHERE ansid in ('214535','214536','214537','214538','214539','214540','214541','214584','214586','214588','214590','214592','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640')"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE supvisstepid = '11466'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE visitfeedbackid = '11316'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE visitfeedbackid = '11317'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE visitfeedbackid = '11318'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE visitfeedbackid = '11319'"}
{"userId":"488","date":"2021-04-12 12:51:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '112.133.207.122', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:51:49' WHERE visitfeedbackid = '11320'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE sitesupervision SET `siteid` = '721', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-15', `numofsamplecollected` = '198', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2308'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Sandhya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE onssid = '9560'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE onsitestaffs SET `staffname` = 'B.Eswaramma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE onssid = '9561'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE onsitestaffs SET `staffname` = 'G.Sagendra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE onssid = '9562'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE onssid = '9563'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214535 then '1' when ansid=214536 then '1' when ansid=214537 then '1' when ansid=214538 then '' when ansid=214539 then ''  when ansid=214540 then '401'   when ansid=214541 then '1'  when ansid=214584 then '0' when ansid=214586 then '0' when ansid=214588 then '0' when ansid=214590 then '0' when ansid=214592 then '1' when ansid=214594 then '2' when ansid=214595 then '0' when ansid=214596 then '223' when ansid=214597 then '25'  when ansid=214598 then ''   when ansid=214599 then '1'  when ansid=214600 then '1'  when ansid=214601 then ''   when ansid=214602 then '1'   when ansid=214603 then ''   when ansid=214604 then '1'  when ansid=214605 then '10' when ansid=214606 then '1' when ansid=214607 then '1'  when ansid=214608 then 'Counsellor'   when ansid=214609 then '1'   when ansid=214610 then ''   when ansid=214611 then '1'  when ansid=214612 then '1'  when ansid=214613 then ''   when ansid=214614 then '1'  when ansid=214615 then '4' when ansid=214616 then '1' when ansid=214617 then '1' when ansid=214618 then '1' when ansid=214619 then '1' when ansid=214620 then '2' when ansid=214621 then '1' when ansid=214622 then '1' when ansid=214623 then '1'  when ansid=214624 then ''   when ansid=214625 then '3'   when ansid=214626 then ''   when ansid=214627 then '1'  when ansid=214628 then '1' when ansid=214629 then '1'  when ansid=214630 then ''   when ansid=214631 then '1'  when ansid=214632 then '1' when ansid=214633 then '1' when ansid=214634 then '1' when ansid=214635 then '1' when ansid=214636 then '0' when ansid=214637 then 'Materials are not issued' when ansid=214638 then 'DPM visited reported no problem' when ansid=214639 then 'Three forms found to be incomplete, instructed to fill completely as per guidelines' when ansid=214640 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:58:13'\n\t\t\t\t\t\t\tWHERE ansid in ('214535','214536','214537','214538','214539','214540','214541','214584','214586','214588','214590','214592','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640')"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE supvisstepid = '11467'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE visitfeedbackid = '11316'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE visitfeedbackid = '11317'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE visitfeedbackid = '11318'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE visitfeedbackid = '11319'"}
{"userId":"488","date":"2021-04-12 12:58:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:13' WHERE visitfeedbackid = '11320'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE sitesupervision SET `siteid` = '721', `userid` = '488', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-15', `numofsamplecollected` = '198', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2308'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr.Sandhya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE onssid = '9560'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE onsitestaffs SET `staffname` = 'B.Eswaramma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE onssid = '9561'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE onsitestaffs SET `staffname` = 'G.Sagendra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '5', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE onssid = '9562'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE onssid = '9563'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=214535 then '1' when ansid=214536 then '1' when ansid=214537 then '1' when ansid=214538 then '' when ansid=214539 then ''  when ansid=214540 then '401'   when ansid=214541 then '1'  when ansid=214584 then '0' when ansid=214586 then '0' when ansid=214588 then '0' when ansid=214590 then '0' when ansid=214592 then '1' when ansid=214594 then '2' when ansid=214595 then '0' when ansid=214596 then '223' when ansid=214597 then '25'  when ansid=214598 then ''   when ansid=214599 then '1'  when ansid=214600 then '1'  when ansid=214601 then ''   when ansid=214602 then '1'   when ansid=214603 then ''   when ansid=214604 then '1'  when ansid=214605 then '10' when ansid=214606 then '1' when ansid=214607 then '1'  when ansid=214608 then 'Counsellor'   when ansid=214609 then '1'   when ansid=214610 then ''   when ansid=214611 then '1'  when ansid=214612 then '1'  when ansid=214613 then ''   when ansid=214614 then '1'  when ansid=214615 then '4' when ansid=214616 then '1' when ansid=214617 then '1' when ansid=214618 then '1' when ansid=214619 then '1' when ansid=214620 then '2' when ansid=214621 then '1' when ansid=214622 then '1' when ansid=214623 then '1'  when ansid=214624 then ''   when ansid=214625 then '3'   when ansid=214626 then ''   when ansid=214627 then '1'  when ansid=214628 then '1' when ansid=214629 then '1'  when ansid=214630 then ''   when ansid=214631 then '1'  when ansid=214632 then '1' when ansid=214633 then '1' when ansid=214634 then '1' when ansid=214635 then '1' when ansid=214636 then '0' when ansid=214637 then 'Materials are not issued' when ansid=214638 then 'DPM visited reported no problem' when ansid=214639 then 'Three forms found to be incomplete, instructed to fill completely as per guidelines' when ansid=214640 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.190.202',\n\t\t\t\t\t\t\t\tmodifiedby =488,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-12 12:58:29'\n\t\t\t\t\t\t\tWHERE ansid in ('214535','214536','214537','214538','214539','214540','214541','214584','214586','214588','214590','214592','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640')"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE supvisstepid = '11468'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE visitfeedbackid = '11316'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE visitfeedbackid = '11317'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE visitfeedbackid = '11318'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE visitfeedbackid = '11319'"}
{"userId":"488","date":"2021-04-12 12:58:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.190.202', `modifiedby` = '488', `modifieddate` = '2021-04-12 12:58:29' WHERE visitfeedbackid = '11320'"}
{"userId":"488","date":"2021-04-12 12:59:31","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('737', '2021-03-06', '488', '14.139.190.202', '488', '2021-04-12 12:59:31')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('737', '2719', '488', '2021-04-12', '1', '14.139.190.202', '488', '2021-04-12 12:59:36', '', '')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2309', '0', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2309', '1', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2309', '2', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2309', '3', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2309', '4', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2309', '', '', 'Array', '', 'Array', '', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2309', '', '', 'Array', '', 'Array', '', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2309', '', '', 'Array', '', 'Array', '', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2309', '', '', 'Array', '', 'Array', '', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"488","date":"2021-04-12 12:59:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2309', '14.139.190.202', '488', '2021-04-12 12:59:36')"}
{"userId":"11","date":"2021-04-12 14:21:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('11', '112.133.207.122', '2021-04-12 14:21:17')"}
{"userId":"11","date":"2021-04-12 14:24:47","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Govt Headquarters Hospital Tirupathur (33713011)', '1', '35', '6', '716', '33713011', '', '', '112.133.207.122', '11', '2021-04-12 14:24:47')"}
{"userId":"11","date":"2021-04-12 14:26:28","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Chengalpattu Medical College Hospital (33711011)', '1', '35', '6', '715', '33711011', '', '', '14.139.190.202', '11', '2021-04-12 14:26:28')"}
{"userId":"11","date":"2021-04-12 14:32:44","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('CJWS (Subsite) (28089091)', '1', '2', '6', '11', '28089091', '2', '', '14.139.190.202', '11', '2021-04-12 14:32:44')"}
{"userId":"336","date":"2021-04-12 15:21:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('336', '14.139.229.114', '2021-04-12 15:21:58')"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE sitesupervision SET `siteid` = '626', `userid` = '336', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2304'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE onssid = '9544'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE onssid = '9545'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE onssid = '9546'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE onssid = '9547'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE supvisstepid = '11453'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE visitfeedback SET `feedback` = 'The sentinel personnel demanded for one printer as they have computer and internet connection', `recommendation` = 'For proper segregation of biomedical waste', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE visitfeedbackid = '11296'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE visitfeedback SET `feedback` = 'rest all was well done and in order with proper universal precautions and covid protocol', `recommendation` = 'On site training was given', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE visitfeedbackid = '11297'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE visitfeedbackid = '11298'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE visitfeedbackid = '11299'"}
{"userId":"336","date":"2021-04-12 15:34:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:34:38' WHERE visitfeedbackid = '11300'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE sitesupervision SET `siteid` = '638', `userid` = '336', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2305'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE onssid = '9548'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE onssid = '9549'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE onssid = '9550'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE onssid = '9551'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE supvisstepid = '11454'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE visitfeedback SET `feedback` = 'The distance of laboratory where the HSS samples are being collected is quite far and  in another building', `recommendation` = 'I would also recommend that if these two equipments are provided to sentinel personnel the samples can be taken as all other resources are there  the drop out of patients can be avoided', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE visitfeedbackid = '11301'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE visitfeedback SET `feedback` = 'To provide centrifuge machine and refrigerator so that the sample can be collected in the counseller room which is close to the ANC site.', `recommendation` = 'On site training given to the site personnel', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE visitfeedbackid = '11302'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE visitfeedbackid = '11303'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE visitfeedbackid = '11304'"}
{"userId":"336","date":"2021-04-12 15:42:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:44' WHERE visitfeedbackid = '11305'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE sitesupervision SET `siteid` = '638', `userid` = '336', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2305'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE onssid = '9548'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE onssid = '9549'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE onssid = '9550'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE onssid = '9551'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE supvisstepid = '11454'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE visitfeedback SET `feedback` = 'The distance of laboratory where the HSS samples are being collected is quite far and  in another building', `recommendation` = 'I would also recommend that if these two equipments are provided to sentinel personnel the samples can be taken as all other resources are there  the drop out of patients can be avoided', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE visitfeedbackid = '11301'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE visitfeedback SET `feedback` = 'To provide centrifuge machine and refrigerator so that the sample can be collected in the counseller room which is close to the ANC site.', `recommendation` = 'On site training given to the site personnel', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE visitfeedbackid = '11302'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE visitfeedbackid = '11303'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE visitfeedbackid = '11304'"}
{"userId":"336","date":"2021-04-12 15:42:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.229.114', `modifiedby` = '336', `modifieddate` = '2021-04-12 15:42:47' WHERE visitfeedbackid = '11305'"}