{"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE sitesupervision SET `siteid` = '332', `userid` = '378', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '194', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2110'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ankita', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE onssid = '8768'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE onsitestaffs SET `staffname` = 'Shashi Bhushan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE onssid = '8769'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE onsitestaffs SET `staffname` = 'Chandan Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE onssid = '8770'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE onssid = '8771'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199318 then '1' when ansid=199319 then '1' when ansid=199320 then '1' when ansid=199321 then '' when ansid=199322 then '' when ansid=199323 then '126' when ansid=199324 then '1' when ansid=199367 then '1' when ansid=199369 then '1' when ansid=199371 then '1' when ansid=199373 then '600' when ansid=199375 then '1' when ansid=199377 then '' when ansid=199378 then '' when ansid=199379 then '' when ansid=199380 then '' when ansid=199381 then '' when ansid=199382 then '' when ansid=199383 then '' when ansid=199384 then '' when ansid=199385 then '' when ansid=199386 then '' when ansid=199387 then '' when ansid=199388 then '' when ansid=199389 then '' when ansid=199390 then '' when ansid=199391 then '' when ansid=199392 then '' when ansid=199393 then '' when ansid=199394 then '' when ansid=199395 then '' when ansid=199396 then '' when ansid=199397 then '' when ansid=199398 then '' when ansid=199399 then '' when ansid=199400 then '' when ansid=199401 then '' when ansid=199402 then '' when ansid=199403 then '' when ansid=199404 then '' when ansid=199405 then '' when ansid=199406 then '' when ansid=199407 then '' when ansid=199408 then '' when ansid=199409 then '' when ansid=199410 then '' when ansid=199411 then '' when ansid=199412 then '' when ansid=199413 then '' when ansid=199414 then '' when ansid=199415 then '' when ansid=199416 then '' when ansid=199417 then '' when ansid=199418 then '' when ansid=199419 then '' when ansid=199420 then '' when ansid=199421 then '' when ansid=199422 then '' when ansid=199423 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.35.255.207',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 00:01:56'\n\t\t\t\t\t\t\tWHERE ansid in ('199318','199319','199320','199321','199322','199323','199324','199367','199369','199371','199373','199375','199377','199378','199379','199380','199381','199382','199383','199384','199385','199386','199387','199388','199389','199390','199391','199392','199393','199394','199395','199396','199397','199398','199399','199400','199401','199402','199403','199404','199405','199406','199407','199408','199409','199410','199411','199412','199413','199414','199415','199416','199417','199418','199419','199420','199421','199422','199423')"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE supvisstepid = '10618'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE visitfeedbackid = '10326'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE visitfeedbackid = '10327'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE visitfeedbackid = '10328'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE visitfeedbackid = '10329'"} {"userId":"378","date":"2021-03-21 00:01:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:01:56' WHERE visitfeedbackid = '10330'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE sitesupervision SET `siteid` = '332', `userid` = '378', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '194', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2110'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ankita', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE onssid = '8768'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE onsitestaffs SET `staffname` = 'Shashi Bhushan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE onssid = '8769'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE onsitestaffs SET `staffname` = 'Chandan Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE onssid = '8770'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE onssid = '8771'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199318 then '1' when ansid=199319 then '1' when ansid=199320 then '1' when ansid=199321 then '' when ansid=199322 then '' when ansid=199323 then '126' when ansid=199324 then '1' when ansid=199367 then '1' when ansid=199369 then '1' when ansid=199371 then '1' when ansid=199373 then '600' when ansid=199375 then '1' when ansid=199377 then '12' when ansid=199378 then '2' when ansid=199379 then '320' when ansid=199380 then '25' when ansid=199381 then '' when ansid=199382 then '1' when ansid=199383 then '1' when ansid=199384 then '' when ansid=199385 then '1' when ansid=199386 then '' when ansid=199387 then '1' when ansid=199388 then '8' when ansid=199389 then '1' when ansid=199390 then '1' when ansid=199391 then 'Counsellor' when ansid=199392 then '1' when ansid=199393 then '' when ansid=199394 then '1' when ansid=199395 then '1' when ansid=199396 then '' when ansid=199397 then '1' when ansid=199398 then '3' when ansid=199399 then '1' when ansid=199400 then '1' when ansid=199401 then '1' when ansid=199402 then '1' when ansid=199403 then '3' when ansid=199404 then '1' when ansid=199405 then '1' when ansid=199406 then '1' when ansid=199407 then '' when ansid=199408 then '3' when ansid=199409 then '' when ansid=199410 then '1' when ansid=199411 then '1' when ansid=199412 then '1' when ansid=199413 then '' when ansid=199414 then '1' when ansid=199415 then '1' when ansid=199416 then '1' when ansid=199417 then '1' when ansid=199418 then '1' when ansid=199419 then '0' when ansid=199420 then 'Lab. is situated in some distance in the hospital campus. It should be close to counselling room.' when ansid=199421 then 'No' when ansid=199422 then 'Lab. Tech.is overloaded with the assignment given by hospital.' when ansid=199423 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.42.185.40',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 00:16:40'\n\t\t\t\t\t\t\tWHERE ansid in ('199318','199319','199320','199321','199322','199323','199324','199367','199369','199371','199373','199375','199377','199378','199379','199380','199381','199382','199383','199384','199385','199386','199387','199388','199389','199390','199391','199392','199393','199394','199395','199396','199397','199398','199399','199400','199401','199402','199403','199404','199405','199406','199407','199408','199409','199410','199411','199412','199413','199414','199415','199416','199417','199418','199419','199420','199421','199422','199423')"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE supvisstepid = '10619'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE visitfeedbackid = '10326'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE visitfeedbackid = '10327'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE visitfeedbackid = '10328'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE visitfeedbackid = '10329'"} {"userId":"378","date":"2021-03-21 00:16:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:16:40' WHERE visitfeedbackid = '10330'"} {"userId":"378","date":"2021-03-21 00:36:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('378', '157.42.185.40', '2021-03-21 00:36:17')"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE sitesupervision SET `siteid` = '332', `userid` = '378', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '194', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2110'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ankita', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8768'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Shashi Bhushan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8769'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Chandan Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8770'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8771'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199318 then '1' when ansid=199319 then '1' when ansid=199320 then '1' when ansid=199321 then '' when ansid=199322 then '' when ansid=199323 then '126' when ansid=199324 then '1' when ansid=199367 then '1' when ansid=199369 then '1' when ansid=199371 then '1' when ansid=199373 then '600' when ansid=199375 then '1' when ansid=199377 then '12' when ansid=199378 then '2' when ansid=199379 then '320' when ansid=199380 then '25' when ansid=199381 then '' when ansid=199382 then '1' when ansid=199383 then '1' when ansid=199384 then '' when ansid=199385 then '1' when ansid=199386 then '' when ansid=199387 then '1' when ansid=199388 then '8' when ansid=199389 then '1' when ansid=199390 then '1' when ansid=199391 then 'Counsellor' when ansid=199392 then '1' when ansid=199393 then '' when ansid=199394 then '1' when ansid=199395 then '1' when ansid=199396 then '' when ansid=199397 then '1' when ansid=199398 then '3' when ansid=199399 then '1' when ansid=199400 then '1' when ansid=199401 then '1' when ansid=199402 then '1' when ansid=199403 then '3' when ansid=199404 then '1' when ansid=199405 then '1' when ansid=199406 then '1' when ansid=199407 then '' when ansid=199408 then '3' when ansid=199409 then '' when ansid=199410 then '1' when ansid=199411 then '1' when ansid=199412 then '1' when ansid=199413 then '' when ansid=199414 then '1' when ansid=199415 then '1' when ansid=199416 then '1' when ansid=199417 then '1' when ansid=199418 then '1' when ansid=199419 then '' when ansid=199420 then 'Lab. is situated in some distance in the hospital campus. It should be close to counselling room.' when ansid=199421 then 'No' when ansid=199422 then 'Lab. Tech.is overloaded with the assignment given by hospital.' when ansid=199423 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.35.255.207',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 00:37:54'\n\t\t\t\t\t\t\tWHERE ansid in ('199318','199319','199320','199321','199322','199323','199324','199367','199369','199371','199373','199375','199377','199378','199379','199380','199381','199382','199383','199384','199385','199386','199387','199388','199389','199390','199391','199392','199393','199394','199395','199396','199397','199398','199399','199400','199401','199402','199403','199404','199405','199406','199407','199408','199409','199410','199411','199412','199413','199414','199415','199416','199417','199418','199419','199420','199421','199422','199423')"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE supvisstepid = '10619'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10326'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10327'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10328'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10329'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10330'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE sitesupervision SET `siteid` = '332', `userid` = '378', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '194', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2110'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ankita', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8768'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Shashi Bhushan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8769'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Chandan Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8770'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE onssid = '8771'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199318 then '1' when ansid=199319 then '1' when ansid=199320 then '1' when ansid=199321 then '' when ansid=199322 then '' when ansid=199323 then '126' when ansid=199324 then '1' when ansid=199367 then '1' when ansid=199369 then '1' when ansid=199371 then '1' when ansid=199373 then '600' when ansid=199375 then '1' when ansid=199377 then '12' when ansid=199378 then '2' when ansid=199379 then '320' when ansid=199380 then '25' when ansid=199381 then '' when ansid=199382 then '1' when ansid=199383 then '1' when ansid=199384 then '' when ansid=199385 then '1' when ansid=199386 then '' when ansid=199387 then '1' when ansid=199388 then '8' when ansid=199389 then '1' when ansid=199390 then '1' when ansid=199391 then 'Counsellor' when ansid=199392 then '1' when ansid=199393 then '' when ansid=199394 then '1' when ansid=199395 then '1' when ansid=199396 then '' when ansid=199397 then '1' when ansid=199398 then '3' when ansid=199399 then '1' when ansid=199400 then '1' when ansid=199401 then '1' when ansid=199402 then '1' when ansid=199403 then '3' when ansid=199404 then '1' when ansid=199405 then '1' when ansid=199406 then '1' when ansid=199407 then '' when ansid=199408 then '3' when ansid=199409 then '' when ansid=199410 then '1' when ansid=199411 then '1' when ansid=199412 then '1' when ansid=199413 then '' when ansid=199414 then '1' when ansid=199415 then '1' when ansid=199416 then '1' when ansid=199417 then '1' when ansid=199418 then '1' when ansid=199419 then '' when ansid=199420 then 'Lab. is situated in some distance in the hospital campus. It should be close to counselling room.' when ansid=199421 then 'No' when ansid=199422 then 'Lab. Tech.is overloaded with the assignment given by hospital.' when ansid=199423 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.35.255.207',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 00:37:54'\n\t\t\t\t\t\t\tWHERE ansid in ('199318','199319','199320','199321','199322','199323','199324','199367','199369','199371','199373','199375','199377','199378','199379','199380','199381','199382','199383','199384','199385','199386','199387','199388','199389','199390','199391','199392','199393','199394','199395','199396','199397','199398','199399','199400','199401','199402','199403','199404','199405','199406','199407','199408','199409','199410','199411','199412','199413','199414','199415','199416','199417','199418','199419','199420','199421','199422','199423')"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE supvisstepid = '10617'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10326'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10327'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10328'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10329'"} {"userId":"378","date":"2021-03-21 00:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.35.255.207', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:37:54' WHERE visitfeedbackid = '10330'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE sitesupervision SET `siteid` = '332', `userid` = '378', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '194', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2110'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ankita', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE onssid = '8768'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE onsitestaffs SET `staffname` = 'Shashi Bhushan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE onssid = '8769'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE onsitestaffs SET `staffname` = 'Chandan Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE onssid = '8770'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE onssid = '8771'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199318 then '1' when ansid=199319 then '1' when ansid=199320 then '1' when ansid=199321 then '' when ansid=199322 then '' when ansid=199323 then '126' when ansid=199324 then '1' when ansid=199367 then '1' when ansid=199369 then '1' when ansid=199371 then '1' when ansid=199373 then '600' when ansid=199375 then '1' when ansid=199377 then '12' when ansid=199378 then '2' when ansid=199379 then '320' when ansid=199380 then '25' when ansid=199381 then '' when ansid=199382 then '1' when ansid=199383 then '1' when ansid=199384 then '' when ansid=199385 then '1' when ansid=199386 then '' when ansid=199387 then '1' when ansid=199388 then '8' when ansid=199389 then '1' when ansid=199390 then '1' when ansid=199391 then 'Counsellor' when ansid=199392 then '1' when ansid=199393 then '' when ansid=199394 then '1' when ansid=199395 then '1' when ansid=199396 then '' when ansid=199397 then '1' when ansid=199398 then '3' when ansid=199399 then '1' when ansid=199400 then '1' when ansid=199401 then '1' when ansid=199402 then '1' when ansid=199403 then '3' when ansid=199404 then '1' when ansid=199405 then '1' when ansid=199406 then '1' when ansid=199407 then '' when ansid=199408 then '3' when ansid=199409 then '' when ansid=199410 then '1' when ansid=199411 then '1' when ansid=199412 then '1' when ansid=199413 then '' when ansid=199414 then '1' when ansid=199415 then '1' when ansid=199416 then '1' when ansid=199417 then '1' when ansid=199418 then '1' when ansid=199419 then '' when ansid=199420 then 'Lab. is situated in some distance in the hospital campus. It should be close to counselling room.' when ansid=199421 then 'No' when ansid=199422 then 'Lab. Tech.is overloaded with the assignment given by hospital.' when ansid=199423 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.42.185.40',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 00:42:41'\n\t\t\t\t\t\t\tWHERE ansid in ('199318','199319','199320','199321','199322','199323','199324','199367','199369','199371','199373','199375','199377','199378','199379','199380','199381','199382','199383','199384','199385','199386','199387','199388','199389','199390','199391','199392','199393','199394','199395','199396','199397','199398','199399','199400','199401','199402','199403','199404','199405','199406','199407','199408','199409','199410','199411','199412','199413','199414','199415','199416','199417','199418','199419','199420','199421','199422','199423')"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE supvisstepid = '10620'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE visitfeedback SET `feedback` = 'Matter related to lab distance was discussed with Hospital Admin. According to Hospital Admin the construction work is on and it will be resolved after that.', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE visitfeedbackid = '10326'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE visitfeedbackid = '10327'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE visitfeedbackid = '10328'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE visitfeedbackid = '10329'"} {"userId":"378","date":"2021-03-21 00:42:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.185.40', `modifiedby` = '378', `modifieddate` = '2021-03-21 00:42:41' WHERE visitfeedbackid = '10330'"} {"userId":"477","date":"2021-03-21 05:44:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('477', '47.29.17.207', '2021-03-21 05:44:07')"} {"userId":"477","date":"2021-03-21 05:45:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('109', '2021-03-22', '477', '47.29.17.207', '477', '2021-03-21 05:45:01')"} {"userId":"477","date":"2021-03-21 05:45:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('108', '2021-03-23', '477', '47.29.17.207', '477', '2021-03-21 05:45:51')"} {"userId":"477","date":"2021-03-21 05:46:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1424', '2021-03-24', '477', '47.29.17.207', '477', '2021-03-21 05:46:36')"} {"userId":"477","date":"2021-03-21 05:49:40","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1427', '2021-03-25', '477', '47.29.17.207', '477', '2021-03-21 05:49:40')"} {"userId":"477","date":"2021-03-21 05:51:49","query":"UPDATE plannedsites SET `siteid` = '1408', `visitdate` = '2021-03-18', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 05:51:49' WHERE plansiteid = '2505'"} {"userId":"477","date":"2021-03-21 05:51:55","query":"UPDATE plannedsites SET `siteid` = '1408', `visitdate` = '2021-03-18', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 05:51:55' WHERE plansiteid = '2505'"} {"userId":"477","date":"2021-03-21 05:52:00","query":"UPDATE plannedsites SET `siteid` = '1408', `visitdate` = '2021-03-18', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 05:52:00' WHERE plansiteid = '2505'"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1408', '2505', '477', '2021-03-21', '1', '47.29.17.207', '477', '2021-03-21 05:52:22', '', '')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2111', '0', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2111', '1', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2111', '2', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2111', '3', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2111', '', '', 'Array', '', 'Array', '', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2111', '', '', 'Array', '', 'Array', '', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2111', '', '', 'Array', '', 'Array', '', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2111', '', '', 'Array', '', 'Array', '', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 05:52:22","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2111', '47.29.17.207', '477', '2021-03-21 05:52:22')"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE sitesupervision SET `siteid` = '1408', `userid` = '477', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-21', `numofsamplecollected` = '106', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2111'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE onsitestaffs SET `staffname` = 'Nirupama', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE onssid = '8772'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE onssid = '8773'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE onssid = '8774'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE onssid = '8775'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199424 then '2' when ansid=199425 then '1' when ansid=199426 then '1' when ansid=199427 then '5' when ansid=199428 then '3' when ansid=199429 then '2' when ansid=199430 then '1' when ansid=199431 then '' when ansid=199432 then '' when ansid=199433 then '' when ansid=199434 then '' when ansid=199435 then '' when ansid=199436 then '' when ansid=199437 then '' when ansid=199438 then '' when ansid=199439 then '' when ansid=199440 then '' when ansid=199441 then '' when ansid=199442 then '' when ansid=199443 then '' when ansid=199444 then '' when ansid=199445 then '' when ansid=199446 then '' when ansid=199447 then '' when ansid=199448 then '' when ansid=199449 then '' when ansid=199450 then '' when ansid=199451 then '' when ansid=199452 then '' when ansid=199453 then '' when ansid=199454 then '' when ansid=199455 then '' when ansid=199456 then '' when ansid=199457 then '' when ansid=199458 then '' when ansid=199459 then '' when ansid=199460 then '' when ansid=199461 then '' when ansid=199462 then '' when ansid=199463 then '' when ansid=199464 then '' when ansid=199465 then '' when ansid=199466 then '' when ansid=199467 then '' when ansid=199468 then '' when ansid=199469 then '' when ansid=199470 then '' when ansid=199471 then '' when ansid=199472 then '' when ansid=199473 then '' when ansid=199474 then '' when ansid=199475 then '' when ansid=199476 then '' when ansid=199477 then '' when ansid=199478 then '' when ansid=199479 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.17.207',\n\t\t\t\t\t\t\t\tmodifiedby =477,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 06:08:43'\n\t\t\t\t\t\t\tWHERE ansid in ('199424','199425','199426','199427','199428','199429','199430','199431','199432','199433','199434','199435','199436','199437','199438','199439','199440','199441','199442','199443','199444','199445','199446','199447','199448','199449','199450','199451','199452','199453','199454','199455','199456','199457','199458','199459','199460','199461','199462','199463','199464','199465','199466','199467','199468','199469','199470','199471','199472','199473','199474','199475','199476','199477','199478','199479')"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE supvisstepid = '10621'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE visitfeedbackid = '10331'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE visitfeedbackid = '10332'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE visitfeedbackid = '10333'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE visitfeedbackid = '10334'"} {"userId":"477","date":"2021-03-21 06:08:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:08:43' WHERE visitfeedbackid = '10335'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE sitesupervision SET `siteid` = '1408', `userid` = '477', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-21', `numofsamplecollected` = '106', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2111'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE onsitestaffs SET `staffname` = 'Nirupama', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE onssid = '8772'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE onssid = '8773'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE onssid = '8774'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE onssid = '8775'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199424 then '2' when ansid=199425 then '1' when ansid=199426 then '1' when ansid=199427 then '5' when ansid=199428 then '3' when ansid=199429 then '2' when ansid=199430 then '1' when ansid=199431 then '1' when ansid=199432 then '1' when ansid=199433 then '1' when ansid=199434 then '1' when ansid=199435 then '1' when ansid=199436 then '1' when ansid=199437 then '1' when ansid=199438 then '1' when ansid=199439 then '1' when ansid=199440 then '' when ansid=199441 then '' when ansid=199442 then '' when ansid=199443 then '' when ansid=199444 then '' when ansid=199445 then '' when ansid=199446 then '' when ansid=199447 then '' when ansid=199448 then '' when ansid=199449 then '' when ansid=199450 then '' when ansid=199451 then '' when ansid=199452 then '' when ansid=199453 then '' when ansid=199454 then '' when ansid=199455 then '' when ansid=199456 then '' when ansid=199457 then '' when ansid=199458 then '' when ansid=199459 then '' when ansid=199460 then '' when ansid=199461 then '' when ansid=199462 then '' when ansid=199463 then '' when ansid=199464 then '' when ansid=199465 then '' when ansid=199466 then '' when ansid=199467 then '' when ansid=199468 then '' when ansid=199469 then '' when ansid=199470 then '' when ansid=199471 then '' when ansid=199472 then '' when ansid=199473 then '' when ansid=199474 then '' when ansid=199475 then '' when ansid=199476 then '' when ansid=199477 then '' when ansid=199478 then '' when ansid=199479 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.17.207',\n\t\t\t\t\t\t\t\tmodifiedby =477,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 06:09:54'\n\t\t\t\t\t\t\tWHERE ansid in ('199424','199425','199426','199427','199428','199429','199430','199431','199432','199433','199434','199435','199436','199437','199438','199439','199440','199441','199442','199443','199444','199445','199446','199447','199448','199449','199450','199451','199452','199453','199454','199455','199456','199457','199458','199459','199460','199461','199462','199463','199464','199465','199466','199467','199468','199469','199470','199471','199472','199473','199474','199475','199476','199477','199478','199479')"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE supvisstepid = '10622'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE visitfeedbackid = '10331'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE visitfeedbackid = '10332'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE visitfeedbackid = '10333'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE visitfeedbackid = '10334'"} {"userId":"477","date":"2021-03-21 06:09:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:09:54' WHERE visitfeedbackid = '10335'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE sitesupervision SET `siteid` = '1408', `userid` = '477', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-21', `numofsamplecollected` = '106', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2111'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE onsitestaffs SET `staffname` = 'Nirupama', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE onssid = '8772'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE onssid = '8773'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE onssid = '8774'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE onssid = '8775'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199424 then '2' when ansid=199425 then '1' when ansid=199426 then '1' when ansid=199427 then '5' when ansid=199428 then '3' when ansid=199429 then '2' when ansid=199430 then '1' when ansid=199431 then '1' when ansid=199432 then '1' when ansid=199433 then '1' when ansid=199434 then '1' when ansid=199435 then '1' when ansid=199436 then '1' when ansid=199437 then '1' when ansid=199438 then '1' when ansid=199439 then '1' when ansid=199440 then '106' when ansid=199441 then '106' when ansid=199442 then '6' when ansid=199443 then '1' when ansid=199444 then '' when ansid=199445 then '1' when ansid=199446 then '' when ansid=199447 then '1' when ansid=199448 then '' when ansid=199449 then '1' when ansid=199450 then '' when ansid=199451 then '1' when ansid=199452 then '' when ansid=199453 then '2' when ansid=199454 then '1' when ansid=199455 then '1' when ansid=199456 then '1' when ansid=199457 then '' when ansid=199458 then '1' when ansid=199459 then '' when ansid=199460 then '1' when ansid=199461 then '' when ansid=199462 then '1' when ansid=199463 then '' when ansid=199464 then '1' when ansid=199465 then '' when ansid=199466 then '1' when ansid=199467 then '' when ansid=199468 then '2' when ansid=199469 then '' when ansid=199470 then '2' when ansid=199471 then '1' when ansid=199472 then '1' when ansid=199473 then '1' when ansid=199474 then '1' when ansid=199475 then '1' when ansid=199476 then 'no problem' when ansid=199477 then 'yes' when ansid=199478 then 'HSS is done properly.' when ansid=199479 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.17.207',\n\t\t\t\t\t\t\t\tmodifiedby =477,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 06:14:58'\n\t\t\t\t\t\t\tWHERE ansid in ('199424','199425','199426','199427','199428','199429','199430','199431','199432','199433','199434','199435','199436','199437','199438','199439','199440','199441','199442','199443','199444','199445','199446','199447','199448','199449','199450','199451','199452','199453','199454','199455','199456','199457','199458','199459','199460','199461','199462','199463','199464','199465','199466','199467','199468','199469','199470','199471','199472','199473','199474','199475','199476','199477','199478','199479')"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE supvisstepid = '10623'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE visitfeedbackid = '10331'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE visitfeedbackid = '10332'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE visitfeedbackid = '10333'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE visitfeedbackid = '10334'"} {"userId":"477","date":"2021-03-21 06:14:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:14:58' WHERE visitfeedbackid = '10335'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE sitesupervision SET `siteid` = '1408', `userid` = '477', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-21', `numofsamplecollected` = '106', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2111'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE onsitestaffs SET `staffname` = 'Nirupama', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE onssid = '8772'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE onssid = '8773'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE onssid = '8774'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE onssid = '8775'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199424 then '2' when ansid=199425 then '1' when ansid=199426 then '1' when ansid=199427 then '5' when ansid=199428 then '3' when ansid=199429 then '2' when ansid=199430 then '1' when ansid=199431 then '1' when ansid=199432 then '1' when ansid=199433 then '1' when ansid=199434 then '1' when ansid=199435 then '1' when ansid=199436 then '1' when ansid=199437 then '1' when ansid=199438 then '1' when ansid=199439 then '1' when ansid=199440 then '106' when ansid=199441 then '106' when ansid=199442 then '6' when ansid=199443 then '1' when ansid=199444 then '' when ansid=199445 then '1' when ansid=199446 then '' when ansid=199447 then '1' when ansid=199448 then '' when ansid=199449 then '1' when ansid=199450 then '' when ansid=199451 then '1' when ansid=199452 then '' when ansid=199453 then '2' when ansid=199454 then '1' when ansid=199455 then '1' when ansid=199456 then '1' when ansid=199457 then '' when ansid=199458 then '1' when ansid=199459 then '' when ansid=199460 then '1' when ansid=199461 then '' when ansid=199462 then '1' when ansid=199463 then '' when ansid=199464 then '1' when ansid=199465 then '' when ansid=199466 then '1' when ansid=199467 then '' when ansid=199468 then '2' when ansid=199469 then '' when ansid=199470 then '2' when ansid=199471 then '1' when ansid=199472 then '1' when ansid=199473 then '1' when ansid=199474 then '1' when ansid=199475 then '1' when ansid=199476 then 'no problem' when ansid=199477 then 'yes' when ansid=199478 then 'HSS is done properly.' when ansid=199479 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '47.29.17.207',\n\t\t\t\t\t\t\t\tmodifiedby =477,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 06:18:59'\n\t\t\t\t\t\t\tWHERE ansid in ('199424','199425','199426','199427','199428','199429','199430','199431','199432','199433','199434','199435','199436','199437','199438','199439','199440','199441','199442','199443','199444','199445','199446','199447','199448','199449','199450','199451','199452','199453','199454','199455','199456','199457','199458','199459','199460','199461','199462','199463','199464','199465','199466','199467','199468','199469','199470','199471','199472','199473','199474','199475','199476','199477','199478','199479')"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE supvisstepid = '10624'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE visitfeedbackid = '10331'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE visitfeedbackid = '10332'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE visitfeedbackid = '10333'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE visitfeedbackid = '10334'"} {"userId":"477","date":"2021-03-21 06:18:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:18:59' WHERE visitfeedbackid = '10335'"} {"userId":"477","date":"2021-03-21 06:19:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('477', '47.29.17.207', '2021-03-21 06:19:35')"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE sitesupervision SET `siteid` = '1408', `userid` = '477', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2107'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE onssid = '8756'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE onssid = '8757'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE onssid = '8758'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE onssid = '8759'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE supvisstepid = '10605'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE visitfeedbackid = '10311'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE visitfeedbackid = '10312'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE visitfeedbackid = '10313'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE visitfeedbackid = '10314'"} {"userId":"477","date":"2021-03-21 06:25:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '47.29.17.207', `modifiedby` = '477', `modifieddate` = '2021-03-21 06:25:20' WHERE visitfeedbackid = '10315'"} {"userId":"477","date":"2021-03-21 06:25:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('477', '47.29.17.207', '2021-03-21 06:25:42')"} {"userId":"477","date":"2021-03-21 06:27:12","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1425', '2021-03-04', '477', '47.29.17.207', '477', '2021-03-21 06:27:12')"} {"userId":"477","date":"2021-03-21 06:31:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('477', '47.29.17.207', '2021-03-21 06:31:15')"} {"userId":"378","date":"2021-03-21 09:41:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('378', '157.42.173.64', '2021-03-21 09:41:48')"} {"userId":"378","date":"2021-03-21 09:43:14","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1164', '2021-03-19', '378', '157.42.173.64', '378', '2021-03-21 09:43:14')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1164', '2513', '378', '2021-03-21', '1', '157.42.173.64', '378', '2021-03-21 09:43:36', '', '')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2112', '0', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2112', '1', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2112', '2', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2112', '3', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2112', '', '', 'Array', '', 'Array', '', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2112', '', '', 'Array', '', 'Array', '', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2112', '', '', 'Array', '', 'Array', '', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2112', '', '', 'Array', '', 'Array', '', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:43:36","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2112', '157.42.173.64', '378', '2021-03-21 09:43:36')"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE sitesupervision SET `siteid` = '1164', `userid` = '378', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-22', `numofsamplecollected` = '54', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2112'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE onsitestaffs SET `staffname` = 'Aditya Prakash', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE onssid = '8776'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Sinha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE onssid = '8777'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE onsitestaffs SET `staffname` = 'Md Fahim', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE onssid = '8778'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE onssid = '8779'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199480 then '2' when ansid=199481 then '1' when ansid=199482 then '3' when ansid=199483 then '24' when ansid=199484 then '24' when ansid=199485 then '1' when ansid=199486 then '2' when ansid=199487 then '' when ansid=199488 then '' when ansid=199489 then '' when ansid=199490 then '' when ansid=199491 then '' when ansid=199492 then '' when ansid=199493 then '' when ansid=199494 then '' when ansid=199495 then '' when ansid=199496 then '' when ansid=199497 then '' when ansid=199498 then '' when ansid=199499 then '' when ansid=199500 then '' when ansid=199501 then '' when ansid=199502 then '' when ansid=199503 then '' when ansid=199504 then '' when ansid=199505 then '' when ansid=199506 then '' when ansid=199507 then '' when ansid=199508 then '' when ansid=199509 then '' when ansid=199510 then '' when ansid=199511 then '' when ansid=199512 then '' when ansid=199513 then '' when ansid=199514 then '' when ansid=199515 then '' when ansid=199516 then '' when ansid=199517 then '' when ansid=199518 then '' when ansid=199519 then '' when ansid=199520 then '' when ansid=199521 then '' when ansid=199522 then '' when ansid=199523 then '' when ansid=199524 then '' when ansid=199525 then '' when ansid=199526 then '' when ansid=199527 then '' when ansid=199528 then '' when ansid=199529 then '' when ansid=199530 then '' when ansid=199531 then '' when ansid=199532 then '' when ansid=199533 then '' when ansid=199534 then '' when ansid=199535 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.42.105.104',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 09:51:02'\n\t\t\t\t\t\t\tWHERE ansid in ('199480','199481','199482','199483','199484','199485','199486','199487','199488','199489','199490','199491','199492','199493','199494','199495','199496','199497','199498','199499','199500','199501','199502','199503','199504','199505','199506','199507','199508','199509','199510','199511','199512','199513','199514','199515','199516','199517','199518','199519','199520','199521','199522','199523','199524','199525','199526','199527','199528','199529','199530','199531','199532','199533','199534','199535')"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE supvisstepid = '10625'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE visitfeedbackid = '10336'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE visitfeedbackid = '10337'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE visitfeedbackid = '10338'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE visitfeedbackid = '10339'"} {"userId":"378","date":"2021-03-21 09:51:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.105.104', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:51:02' WHERE visitfeedbackid = '10340'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE sitesupervision SET `siteid` = '1164', `userid` = '378', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-22', `numofsamplecollected` = '54', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2112'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE onsitestaffs SET `staffname` = 'Aditya Prakash', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE onssid = '8776'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Sinha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE onssid = '8777'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE onsitestaffs SET `staffname` = 'Md Fahim', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE onssid = '8778'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE onssid = '8779'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199480 then '2' when ansid=199481 then '1' when ansid=199482 then '3' when ansid=199483 then '24' when ansid=199484 then '24' when ansid=199485 then '1' when ansid=199486 then '2' when ansid=199487 then '1' when ansid=199488 then '1' when ansid=199489 then '1' when ansid=199490 then '1' when ansid=199491 then '1' when ansid=199492 then '1' when ansid=199493 then '1' when ansid=199494 then '1' when ansid=199495 then '1' when ansid=199496 then '' when ansid=199497 then '' when ansid=199498 then '' when ansid=199499 then '' when ansid=199500 then '' when ansid=199501 then '' when ansid=199502 then '' when ansid=199503 then '' when ansid=199504 then '' when ansid=199505 then '' when ansid=199506 then '' when ansid=199507 then '' when ansid=199508 then '' when ansid=199509 then '' when ansid=199510 then '' when ansid=199511 then '' when ansid=199512 then '' when ansid=199513 then '' when ansid=199514 then '' when ansid=199515 then '' when ansid=199516 then '' when ansid=199517 then '' when ansid=199518 then '' when ansid=199519 then '' when ansid=199520 then '' when ansid=199521 then '' when ansid=199522 then '' when ansid=199523 then '' when ansid=199524 then '' when ansid=199525 then '' when ansid=199526 then '' when ansid=199527 then '' when ansid=199528 then '' when ansid=199529 then '' when ansid=199530 then '' when ansid=199531 then '' when ansid=199532 then '' when ansid=199533 then '' when ansid=199534 then '' when ansid=199535 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.42.173.64',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 09:53:45'\n\t\t\t\t\t\t\tWHERE ansid in ('199480','199481','199482','199483','199484','199485','199486','199487','199488','199489','199490','199491','199492','199493','199494','199495','199496','199497','199498','199499','199500','199501','199502','199503','199504','199505','199506','199507','199508','199509','199510','199511','199512','199513','199514','199515','199516','199517','199518','199519','199520','199521','199522','199523','199524','199525','199526','199527','199528','199529','199530','199531','199532','199533','199534','199535')"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE supvisstepid = '10626'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE visitfeedbackid = '10336'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE visitfeedbackid = '10337'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE visitfeedbackid = '10338'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE visitfeedbackid = '10339'"} {"userId":"378","date":"2021-03-21 09:53:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 09:53:45' WHERE visitfeedbackid = '10340'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE sitesupervision SET `siteid` = '1164', `userid` = '378', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-22', `numofsamplecollected` = '54', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2112'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE onsitestaffs SET `staffname` = 'Aditya Prakash', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE onssid = '8776'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Sinha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE onssid = '8777'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE onsitestaffs SET `staffname` = 'Md Fahim', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE onssid = '8778'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE onssid = '8779'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199480 then '2' when ansid=199481 then '1' when ansid=199482 then '3' when ansid=199483 then '24' when ansid=199484 then '24' when ansid=199485 then '1' when ansid=199486 then '2' when ansid=199487 then '1' when ansid=199488 then '1' when ansid=199489 then '1' when ansid=199490 then '1' when ansid=199491 then '1' when ansid=199492 then '1' when ansid=199493 then '1' when ansid=199494 then '1' when ansid=199495 then '1' when ansid=199496 then '3' when ansid=199497 then '3' when ansid=199498 then '03' when ansid=199499 then '1' when ansid=199500 then '' when ansid=199501 then '1' when ansid=199502 then '' when ansid=199503 then '1' when ansid=199504 then '' when ansid=199505 then '1' when ansid=199506 then '' when ansid=199507 then '1' when ansid=199508 then '' when ansid=199509 then '1' when ansid=199510 then '1' when ansid=199511 then '1' when ansid=199512 then '1' when ansid=199513 then '' when ansid=199514 then '1' when ansid=199515 then '' when ansid=199516 then '1' when ansid=199517 then '' when ansid=199518 then '1' when ansid=199519 then '' when ansid=199520 then '2' when ansid=199521 then '' when ansid=199522 then '1' when ansid=199523 then '' when ansid=199524 then '1' when ansid=199525 then '' when ansid=199526 then '1' when ansid=199527 then '1' when ansid=199528 then '1' when ansid=199529 then '1' when ansid=199530 then '1' when ansid=199531 then '1' when ansid=199532 then 'No' when ansid=199533 then 'No' when ansid=199534 then 'Timely sending of DBS cards and Data Forms to Delhi.Sample no. should be written properly on the card mentioning site code,subsite no.,sample no. & date.Proper microplanning for sample collection with more meetings option.Lab SOP again explained to site personnel.Data Forms mistakes were indicated and subsequently rectified by the site personnel.B H W M was again explained.' when ansid=199535 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.42.173.64',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 10:22:47'\n\t\t\t\t\t\t\tWHERE ansid in ('199480','199481','199482','199483','199484','199485','199486','199487','199488','199489','199490','199491','199492','199493','199494','199495','199496','199497','199498','199499','199500','199501','199502','199503','199504','199505','199506','199507','199508','199509','199510','199511','199512','199513','199514','199515','199516','199517','199518','199519','199520','199521','199522','199523','199524','199525','199526','199527','199528','199529','199530','199531','199532','199533','199534','199535')"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE supvisstepid = '10627'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE visitfeedbackid = '10336'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE visitfeedbackid = '10337'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE visitfeedbackid = '10338'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE visitfeedbackid = '10339'"} {"userId":"378","date":"2021-03-21 10:22:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.42.173.64', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:22:47' WHERE visitfeedbackid = '10340'"} {"userId":"57","date":"2021-03-21 10:30:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '14.139.200.27', '2021-03-21 10:30:19')"} {"userId":"57","date":"2021-03-21 10:31:24","query":"UPDATE plannedsites SET `siteid` = '444', `visitdate` = '2021-03-19', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:31:24' WHERE plansiteid = '2454'"} {"userId":"57","date":"2021-03-21 10:32:19","query":"UPDATE plannedsites SET `siteid` = '444', `visitdate` = '2021-03-19', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:32:19' WHERE plansiteid = '2454'"} {"userId":"57","date":"2021-03-21 10:33:34","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('444', '2021-03-21', '57', '14.139.200.27', '57', '2021-03-21 10:33:34')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('444', '2514', '57', '2021-03-21', '1', '14.139.200.27', '57', '2021-03-21 10:33:42', '', '')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2113', '0', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2113', '1', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2113', '2', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2113', '3', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2113', '4', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2113', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2113', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2113', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2113', '', '', 'Array', '', 'Array', '', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"57","date":"2021-03-21 10:33:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2113', '14.139.200.27', '57', '2021-03-21 10:33:42')"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE sitesupervision SET `siteid` = '1164', `userid` = '378', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-22', `numofsamplecollected` = '54', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2112'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE onsitestaffs SET `staffname` = 'Aditya Prakash', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE onssid = '8776'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Sinha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE onssid = '8777'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE onsitestaffs SET `staffname` = 'Md Fahim', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE onssid = '8778'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE onssid = '8779'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199480 then '2' when ansid=199481 then '1' when ansid=199482 then '3' when ansid=199483 then '24' when ansid=199484 then '24' when ansid=199485 then '1' when ansid=199486 then '2' when ansid=199487 then '1' when ansid=199488 then '1' when ansid=199489 then '1' when ansid=199490 then '1' when ansid=199491 then '1' when ansid=199492 then '1' when ansid=199493 then '1' when ansid=199494 then '1' when ansid=199495 then '1' when ansid=199496 then '3' when ansid=199497 then '3' when ansid=199498 then '03' when ansid=199499 then '1' when ansid=199500 then '' when ansid=199501 then '1' when ansid=199502 then '' when ansid=199503 then '1' when ansid=199504 then '' when ansid=199505 then '1' when ansid=199506 then '' when ansid=199507 then '1' when ansid=199508 then '' when ansid=199509 then '1' when ansid=199510 then '1' when ansid=199511 then '1' when ansid=199512 then '1' when ansid=199513 then '' when ansid=199514 then '1' when ansid=199515 then '' when ansid=199516 then '1' when ansid=199517 then '' when ansid=199518 then '1' when ansid=199519 then '' when ansid=199520 then '2' when ansid=199521 then '' when ansid=199522 then '1' when ansid=199523 then '' when ansid=199524 then '1' when ansid=199525 then '' when ansid=199526 then '1' when ansid=199527 then '1' when ansid=199528 then '1' when ansid=199529 then '1' when ansid=199530 then '1' when ansid=199531 then '1' when ansid=199532 then 'No' when ansid=199533 then 'No' when ansid=199534 then 'Timely sending of DBS cards and Data Forms to Delhi.Sample no. should be written properly on the card mentioning site code,subsite no.,sample no. & date.Proper microplanning for sample collection with more meetings option.Lab SOP again explained to site personnel.Data Forms mistakes were indicated and subsequently rectified by the site personnel.B H W M was again explained.' when ansid=199535 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.35.240.220',\n\t\t\t\t\t\t\t\tmodifiedby =378,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 10:34:49'\n\t\t\t\t\t\t\tWHERE ansid in ('199480','199481','199482','199483','199484','199485','199486','199487','199488','199489','199490','199491','199492','199493','199494','199495','199496','199497','199498','199499','199500','199501','199502','199503','199504','199505','199506','199507','199508','199509','199510','199511','199512','199513','199514','199515','199516','199517','199518','199519','199520','199521','199522','199523','199524','199525','199526','199527','199528','199529','199530','199531','199532','199533','199534','199535')"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE supvisstepid = '10628'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE visitfeedback SET `feedback` = 'Directed for timely sending of DBS cards and Data Forms to Delhi. Some of Data forms were rectified after indication.', `recommendation` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE visitfeedbackid = '10336'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE visitfeedback SET `feedback` = 'Sample no. should be written properly on the card mentioning site code,subsite no.,sample no. & date.', `recommendation` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE visitfeedbackid = '10337'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE visitfeedback SET `feedback` = 'Proper microplanning for sample collection with more meetings option.', `recommendation` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE visitfeedbackid = '10338'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE visitfeedback SET `feedback` = 'Lab SOP again explained to site personnel.', `recommendation` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE visitfeedbackid = '10339'"} {"userId":"378","date":"2021-03-21 10:34:49","query":"UPDATE visitfeedback SET `feedback` = 'BHWM again explained to site personnel.', `recommendation` = '', `ipaddress` = '157.35.240.220', `modifiedby` = '378', `modifieddate` = '2021-03-21 10:34:49' WHERE visitfeedbackid = '10340'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '00', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '' when ansid=199537 then '' when ansid=199538 then '' when ansid=199539 then '' when ansid=199540 then '' when ansid=199541 then '' when ansid=199542 then '' when ansid=199585 then '' when ansid=199587 then '' when ansid=199589 then '' when ansid=199591 then '' when ansid=199593 then '' when ansid=199595 then '' when ansid=199596 then '' when ansid=199597 then '' when ansid=199598 then '' when ansid=199599 then '' when ansid=199600 then '' when ansid=199601 then '' when ansid=199602 then '' when ansid=199603 then '' when ansid=199604 then '' when ansid=199605 then '' when ansid=199606 then '' when ansid=199607 then '' when ansid=199608 then '' when ansid=199609 then '' when ansid=199610 then '' when ansid=199611 then '' when ansid=199612 then '' when ansid=199613 then '' when ansid=199614 then '' when ansid=199615 then '' when ansid=199616 then '' when ansid=199617 then '' when ansid=199618 then '' when ansid=199619 then '' when ansid=199620 then '' when ansid=199621 then '' when ansid=199622 then '' when ansid=199623 then '' when ansid=199624 then '' when ansid=199625 then '' when ansid=199626 then '' when ansid=199627 then '' when ansid=199628 then '' when ansid=199629 then '' when ansid=199630 then '' when ansid=199631 then '' when ansid=199632 then '' when ansid=199633 then '' when ansid=199634 then '' when ansid=199635 then '' when ansid=199636 then '' when ansid=199637 then '' when ansid=199638 then '' when ansid=199639 then '' when ansid=199640 then '' when ansid=199641 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 10:35:51'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE supvisstepid = '10629'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 10:35:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:35:51' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '00', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '' when ansid=199587 then '' when ansid=199589 then '' when ansid=199591 then '' when ansid=199593 then '' when ansid=199595 then '' when ansid=199596 then '' when ansid=199597 then '' when ansid=199598 then '' when ansid=199599 then '' when ansid=199600 then '' when ansid=199601 then '' when ansid=199602 then '' when ansid=199603 then '' when ansid=199604 then '' when ansid=199605 then '' when ansid=199606 then '' when ansid=199607 then '' when ansid=199608 then '' when ansid=199609 then '' when ansid=199610 then '' when ansid=199611 then '' when ansid=199612 then '' when ansid=199613 then '' when ansid=199614 then '' when ansid=199615 then '' when ansid=199616 then '' when ansid=199617 then '' when ansid=199618 then '' when ansid=199619 then '' when ansid=199620 then '' when ansid=199621 then '' when ansid=199622 then '' when ansid=199623 then '' when ansid=199624 then '' when ansid=199625 then '' when ansid=199626 then '' when ansid=199627 then '' when ansid=199628 then '' when ansid=199629 then '' when ansid=199630 then '' when ansid=199631 then '' when ansid=199632 then '' when ansid=199633 then '' when ansid=199634 then '' when ansid=199635 then '' when ansid=199636 then '' when ansid=199637 then '' when ansid=199638 then '' when ansid=199639 then '' when ansid=199640 then '' when ansid=199641 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 10:38:58'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE supvisstepid = '10630'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 10:38:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:38:58' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '00', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '' when ansid=199596 then '' when ansid=199597 then '' when ansid=199598 then '' when ansid=199599 then '' when ansid=199600 then '' when ansid=199601 then '' when ansid=199602 then '' when ansid=199603 then '' when ansid=199604 then '' when ansid=199605 then '' when ansid=199606 then '' when ansid=199607 then '' when ansid=199608 then '' when ansid=199609 then '' when ansid=199610 then '' when ansid=199611 then '' when ansid=199612 then '' when ansid=199613 then '' when ansid=199614 then '' when ansid=199615 then '' when ansid=199616 then '' when ansid=199617 then '' when ansid=199618 then '' when ansid=199619 then '' when ansid=199620 then '' when ansid=199621 then '' when ansid=199622 then '' when ansid=199623 then '' when ansid=199624 then '' when ansid=199625 then '' when ansid=199626 then '' when ansid=199627 then '' when ansid=199628 then '' when ansid=199629 then '' when ansid=199630 then '' when ansid=199631 then '' when ansid=199632 then '' when ansid=199633 then '' when ansid=199634 then '' when ansid=199635 then '' when ansid=199636 then '' when ansid=199637 then '' when ansid=199638 then '' when ansid=199639 then '' when ansid=199640 then '' when ansid=199641 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 10:39:36'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE supvisstepid = '10631'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 10:39:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 10:39:36' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '00', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '0' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:06:41'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE supvisstepid = '10632'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:06:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:06:41' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:16:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('57', '14.139.200.27', '2021-03-21 11:16:01')"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:16:45'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE supvisstepid = '10632'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:16:45'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE supvisstepid = '10630'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:16:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:16:45' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:17:15'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE supvisstepid = '10629'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:17:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:15' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:17:19'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE supvisstepid = '10630'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:17:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:19' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:17:23'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE supvisstepid = '10631'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:17:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:23' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '0' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:17:46'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE supvisstepid = '10632'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:17:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:17:46' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '0' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:19:08'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE supvisstepid = '10632'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE visitfeedback SET `feedback` = 'Space at the PPTCT was not adeqate.', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE visitfeedback SET `feedback` = 'No other issue identified.', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:19:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:08' WHERE visitfeedbackid = '10345'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE sitesupervision SET `siteid` = '444', `userid` = '57', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-02', `numofsamplecollected` = '252', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2113'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr B L Kumre', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE onssid = '8780'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Anand Kumar Shende', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE onssid = '8781'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Kaushalya sinha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '04', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE onssid = '8782'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE onssid = '8783'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=199536 then '1' when ansid=199537 then '3' when ansid=199538 then '2' when ansid=199539 then '2' when ansid=199540 then '2' when ansid=199541 then '440' when ansid=199542 then '1' when ansid=199585 then '1' when ansid=199587 then '1' when ansid=199589 then '1' when ansid=199591 then '3' when ansid=199593 then '5' when ansid=199595 then '2' when ansid=199596 then '20' when ansid=199597 then '600' when ansid=199598 then '36' when ansid=199599 then '' when ansid=199600 then '1' when ansid=199601 then '1' when ansid=199602 then '' when ansid=199603 then '1' when ansid=199604 then '' when ansid=199605 then '1' when ansid=199606 then '7' when ansid=199607 then '1' when ansid=199608 then '1' when ansid=199609 then 'Counsellor and was trained' when ansid=199610 then '1' when ansid=199611 then '' when ansid=199612 then '1' when ansid=199613 then '1' when ansid=199614 then '' when ansid=199615 then '1' when ansid=199616 then '4' when ansid=199617 then '1' when ansid=199618 then '1' when ansid=199619 then '1' when ansid=199620 then '1' when ansid=199621 then '2' when ansid=199622 then '1' when ansid=199623 then '1' when ansid=199624 then '1' when ansid=199625 then '' when ansid=199626 then '3' when ansid=199627 then '' when ansid=199628 then '1' when ansid=199629 then '1' when ansid=199630 then '1' when ansid=199631 then '' when ansid=199632 then '1' when ansid=199633 then '1' when ansid=199634 then '1' when ansid=199635 then '1' when ansid=199636 then '1' when ansid=199637 then '0' when ansid=199638 then 'Space for PPTCT was inadequate.' when ansid=199639 then 'Yes, an SST member has visited.' when ansid=199640 then 'NIL.The site was working as per guidelines.' when ansid=199641 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.200.27',\n\t\t\t\t\t\t\t\tmodifiedby =57,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-21 11:19:30'\n\t\t\t\t\t\t\tWHERE ansid in ('199536','199537','199538','199539','199540','199541','199542','199585','199587','199589','199591','199593','199595','199596','199597','199598','199599','199600','199601','199602','199603','199604','199605','199606','199607','199608','199609','199610','199611','199612','199613','199614','199615','199616','199617','199618','199619','199620','199621','199622','199623','199624','199625','199626','199627','199628','199629','199630','199631','199632','199633','199634','199635','199636','199637','199638','199639','199640','199641')"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE supvisstepid = '10633'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE visitfeedback SET `feedback` = 'Space at the PPTCT was not adeqate.', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE visitfeedbackid = '10341'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE visitfeedback SET `feedback` = 'No other issue identified.', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE visitfeedbackid = '10342'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE visitfeedbackid = '10343'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE visitfeedbackid = '10344'"} {"userId":"57","date":"2021-03-21 11:19:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.200.27', `modifiedby` = '57', `modifieddate` = '2021-03-21 11:19:30' WHERE visitfeedbackid = '10345'"}