{"userId":"544","date":"2023-02-20 09:54:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2023-02-20 09:54:15')"} {"userId":"574","date":"2023-02-20 11:46:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.223', '2023-02-20 11:46:46')"} {"userId":"574","date":"2023-02-20 11:56:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.223', '2023-02-20 11:56:38')"} {"userId":"646","date":"2023-02-20 13:19:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('646', '14.139.54.115', '2023-02-20 13:19:58')"} {"userId":"646","date":"2023-02-20 13:59:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('646', '139.167.232.128', '2023-02-20 13:59:04')"} {"userId":"646","date":"2023-02-20 14:02:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('304', '2023-01-10', '646', '139.167.232.128', '646', '2023-02-20 14:02:01')"} {"userId":"646","date":"2023-02-20 14:02:17","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('304', '2023-01-08', '646', '139.167.232.128', '646', '2023-02-20 14:02:17')"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '53' when ansid=247306 then '172' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '2' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '' when ansid=247346 then 'NA' when ansid=247347 then 'NA' when ansid=247348 then 'NA' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '139.167.232.128',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:02:52'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE supvisstepid = '13000'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '53' when ansid=247306 then '172' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '2' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '' when ansid=247346 then 'NA' when ansid=247347 then 'NA' when ansid=247348 then 'NA' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '139.167.232.128',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:02:52'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE supvisstepid = '12998'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:02:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:02:52' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '53' when ansid=247306 then '172' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '2' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '' when ansid=247346 then 'NA' when ansid=247347 then 'NA' when ansid=247348 then 'NA' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '139.167.232.128',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:04:23'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE supvisstepid = '12997'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:04:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:04:23' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '53' when ansid=247306 then '172' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '2' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '' when ansid=247346 then 'NA' when ansid=247347 then 'NA' when ansid=247348 then 'NA' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '139.167.232.128',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:05:01'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE supvisstepid = '12998'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:05:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:01' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '53' when ansid=247306 then '172' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '2' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '' when ansid=247346 then 'NA' when ansid=247347 then 'NA' when ansid=247348 then 'NA' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '139.167.232.128',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:05:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE supvisstepid = '12999'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:05:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '139.167.232.128', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:05:20' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '571' when ansid=247306 then '78' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '7.3' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '0' when ansid=247346 then 'Vacutainers used were of 4ml for blood sample collection. moreover, the aliquots were of 2ml only. the site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed to the CMS, UASACS from the surveillance site by the SST member for corrective action.' when ansid=247347 then 'No' when ansid=247348 then 'No' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:12:54'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE supvisstepid = '13000'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:12:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:12:54' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '571' when ansid=247306 then '78' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '7.3' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '0' when ansid=247346 then 'Vacutainers used were of 4ml for blood sample collection. moreover, the aliquots were of 2ml only. the site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed to the CMS, UASACS from the surveillance site by the SST member for corrective action.' when ansid=247347 then 'No' when ansid=247348 then 'No' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:13:35'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE supvisstepid = '13000'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:13:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:13:35' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE sitesupervision SET `siteid` = '304', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '49', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2633'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Archana Verma', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE onssid = '10860'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Vainu Sharma', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE onssid = '10861'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Provindra Singh', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE onssid = '10862'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE onssid = '10863'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247244 then '1' when ansid=247245 then '1' when ansid=247246 then '2' when ansid=247247 then '1' when ansid=247248 then '' when ansid=247249 then '250' when ansid=247250 then '1' when ansid=247350 then '1' when ansid=247351 then '1' when ansid=247293 then '1' when ansid=247295 then '1' when ansid=247297 then '1' when ansid=247299 then '3' when ansid=247301 then '1' when ansid=247303 then '4' when ansid=247304 then '2' when ansid=247305 then '571' when ansid=247306 then '78' when ansid=247307 then '' when ansid=247308 then '1' when ansid=247309 then '1' when ansid=247310 then '' when ansid=247311 then '1' when ansid=247312 then '' when ansid=247313 then '1' when ansid=247314 then '7.3' when ansid=247315 then '3' when ansid=247316 then '1' when ansid=247317 then 'counseller' when ansid=247318 then '1' when ansid=247319 then '' when ansid=247320 then '1' when ansid=247321 then '1' when ansid=247322 then '' when ansid=247323 then '1' when ansid=247324 then '3' when ansid=247325 then '1' when ansid=247326 then '1' when ansid=247327 then '1' when ansid=247328 then '1' when ansid=247329 then '2' when ansid=247330 then '1' when ansid=247331 then '1' when ansid=247332 then '1' when ansid=247333 then '' when ansid=247334 then '3' when ansid=247335 then 'thermocol box' when ansid=247336 then '2' when ansid=247337 then '1' when ansid=247338 then '1' when ansid=247339 then '' when ansid=247340 then '1' when ansid=247341 then '1' when ansid=247342 then '1' when ansid=247343 then '1' when ansid=247344 then '1' when ansid=247345 then '0' when ansid=247346 then 'Vacutainers used were of 4ml for blood sample collection. moreover, the aliquots were of 2ml only. the site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed to the CMS, UASACS from the surveillance site by the SST member for corrective action.' when ansid=247347 then 'No' when ansid=247348 then 'No' when ansid=247349 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:14:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247244','247245','247246','247247','247248','247249','247250','247350','247351','247293','247295','247297','247299','247301','247303','247304','247305','247306','247307','247308','247309','247310','247311','247312','247313','247314','247315','247316','247317','247318','247319','247320','247321','247322','247323','247324','247325','247326','247327','247328','247329','247330','247331','247332','247333','247334','247335','247336','247337','247338','247339','247340','247341','247342','247343','247344','247345','247346','247347','247348','247349')"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE supvisstepid = '13001'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE visitfeedback SET `feedback` = 'Vacutainers used were of 4ml for blood sample collection. moreover, the aliquots were of 2ml only. The site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE visitfeedbackid = '12941'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE visitfeedbackid = '12942'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE visitfeedbackid = '12943'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE visitfeedbackid = '12944'"} {"userId":"646","date":"2023-02-20 14:14:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:14:04' WHERE visitfeedbackid = '12945'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '' when ansid=247520 then '' when ansid=247521 then '' when ansid=247522 then '' when ansid=247523 then '' when ansid=247524 then '' when ansid=247525 then '' when ansid=247526 then '' when ansid=247527 then '' when ansid=247528 then '' when ansid=247529 then '' when ansid=247530 then '' when ansid=247531 then '' when ansid=247532 then '' when ansid=247533 then '' when ansid=247534 then '' when ansid=247535 then '' when ansid=247536 then '' when ansid=247537 then '' when ansid=247538 then '' when ansid=247539 then '' when ansid=247540 then '' when ansid=247541 then '' when ansid=247542 then '' when ansid=247543 then '' when ansid=247544 then '' when ansid=247545 then '' when ansid=247546 then '' when ansid=247547 then '' when ansid=247548 then '' when ansid=247549 then '' when ansid=247550 then '' when ansid=247551 then '' when ansid=247552 then '' when ansid=247553 then '' when ansid=247554 then '' when ansid=247555 then '' when ansid=247556 then '' when ansid=247557 then '' when ansid=247558 then '' when ansid=247559 then '' when ansid=247560 then '' when ansid=247561 then '' when ansid=247562 then '' when ansid=247563 then '' when ansid=247564 then '' when ansid=247565 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:16:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE supvisstepid = '13008'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '' when ansid=247520 then '' when ansid=247521 then '' when ansid=247522 then '' when ansid=247523 then '' when ansid=247524 then '' when ansid=247525 then '' when ansid=247526 then '' when ansid=247527 then '' when ansid=247528 then '' when ansid=247529 then '' when ansid=247530 then '' when ansid=247531 then '' when ansid=247532 then '' when ansid=247533 then '' when ansid=247534 then '' when ansid=247535 then '' when ansid=247536 then '' when ansid=247537 then '' when ansid=247538 then '' when ansid=247539 then '' when ansid=247540 then '' when ansid=247541 then '' when ansid=247542 then '' when ansid=247543 then '' when ansid=247544 then '' when ansid=247545 then '' when ansid=247546 then '' when ansid=247547 then '' when ansid=247548 then '' when ansid=247549 then '' when ansid=247550 then '' when ansid=247551 then '' when ansid=247552 then '' when ansid=247553 then '' when ansid=247554 then '' when ansid=247555 then '' when ansid=247556 then '' when ansid=247557 then '' when ansid=247558 then '' when ansid=247559 then '' when ansid=247560 then '' when ansid=247561 then '' when ansid=247562 then '' when ansid=247563 then '' when ansid=247564 then '' when ansid=247565 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:16:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE supvisstepid = '13007'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:16:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:16:36' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '' when ansid=247520 then '' when ansid=247521 then '' when ansid=247522 then '' when ansid=247523 then '' when ansid=247524 then '' when ansid=247525 then '' when ansid=247526 then '' when ansid=247527 then '' when ansid=247528 then '' when ansid=247529 then '' when ansid=247530 then '' when ansid=247531 then '' when ansid=247532 then '' when ansid=247533 then '' when ansid=247534 then '' when ansid=247535 then '' when ansid=247536 then '' when ansid=247537 then '' when ansid=247538 then '' when ansid=247539 then '' when ansid=247540 then '' when ansid=247541 then '' when ansid=247542 then '' when ansid=247543 then '' when ansid=247544 then '' when ansid=247545 then '' when ansid=247546 then '' when ansid=247547 then '' when ansid=247548 then '' when ansid=247549 then '' when ansid=247550 then '' when ansid=247551 then '' when ansid=247552 then '' when ansid=247553 then '' when ansid=247554 then '' when ansid=247555 then '' when ansid=247556 then '' when ansid=247557 then '' when ansid=247558 then '' when ansid=247559 then '' when ansid=247560 then '' when ansid=247561 then '' when ansid=247562 then '' when ansid=247563 then '' when ansid=247564 then '' when ansid=247565 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:17:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE supvisstepid = '13007'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:17:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:17:29' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '' when ansid=247520 then '' when ansid=247521 then '' when ansid=247522 then '' when ansid=247523 then '' when ansid=247524 then '' when ansid=247525 then '' when ansid=247526 then '' when ansid=247527 then '' when ansid=247528 then '' when ansid=247529 then '' when ansid=247530 then '' when ansid=247531 then '' when ansid=247532 then '' when ansid=247533 then '' when ansid=247534 then '' when ansid=247535 then '' when ansid=247536 then '' when ansid=247537 then '' when ansid=247538 then '' when ansid=247539 then '' when ansid=247540 then '' when ansid=247541 then '' when ansid=247542 then '' when ansid=247543 then '' when ansid=247544 then '' when ansid=247545 then '' when ansid=247546 then '' when ansid=247547 then '' when ansid=247548 then '' when ansid=247549 then '' when ansid=247550 then '' when ansid=247551 then '' when ansid=247552 then '' when ansid=247553 then '' when ansid=247554 then '' when ansid=247555 then '' when ansid=247556 then '' when ansid=247557 then '' when ansid=247558 then '' when ansid=247559 then '' when ansid=247560 then '' when ansid=247561 then '' when ansid=247562 then '' when ansid=247563 then '' when ansid=247564 then '' when ansid=247565 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:18:46'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE supvisstepid = '13008'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:18:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:18:46' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '' when ansid=247520 then '' when ansid=247521 then '' when ansid=247522 then '' when ansid=247523 then '' when ansid=247524 then '' when ansid=247525 then '' when ansid=247526 then '' when ansid=247527 then '' when ansid=247528 then '' when ansid=247529 then '' when ansid=247530 then '' when ansid=247531 then '' when ansid=247532 then '' when ansid=247533 then '' when ansid=247534 then '' when ansid=247535 then '' when ansid=247536 then '' when ansid=247537 then '' when ansid=247538 then '' when ansid=247539 then '' when ansid=247540 then '' when ansid=247541 then '' when ansid=247542 then '' when ansid=247543 then '' when ansid=247544 then '' when ansid=247545 then '' when ansid=247546 then '' when ansid=247547 then '' when ansid=247548 then '' when ansid=247549 then '' when ansid=247550 then '' when ansid=247551 then '' when ansid=247552 then '' when ansid=247553 then '' when ansid=247554 then '' when ansid=247555 then '' when ansid=247556 then '' when ansid=247557 then '' when ansid=247558 then '' when ansid=247559 then '' when ansid=247560 then '' when ansid=247561 then '' when ansid=247562 then '' when ansid=247563 then '' when ansid=247564 then '' when ansid=247565 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:19:18'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE supvisstepid = '13009'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:19:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:19:18' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '4' when ansid=247520 then '2' when ansid=247521 then '794' when ansid=247522 then '225' when ansid=247523 then '' when ansid=247524 then '1' when ansid=247525 then '1' when ansid=247526 then '' when ansid=247527 then '1' when ansid=247528 then '' when ansid=247529 then '1' when ansid=247530 then '0.28' when ansid=247531 then '1' when ansid=247532 then '1' when ansid=247533 then 'nursing officer' when ansid=247534 then '1' when ansid=247535 then '' when ansid=247536 then '1' when ansid=247537 then '1' when ansid=247538 then '' when ansid=247539 then '1' when ansid=247540 then '2' when ansid=247541 then '1' when ansid=247542 then '1' when ansid=247543 then '1' when ansid=247544 then '1' when ansid=247545 then '2' when ansid=247546 then '1' when ansid=247547 then '1' when ansid=247548 then '1' when ansid=247549 then '' when ansid=247550 then '3' when ansid=247551 then 'Chiller box' when ansid=247552 then '2' when ansid=247553 then '1' when ansid=247554 then '1' when ansid=247555 then '' when ansid=247556 then '1' when ansid=247557 then '1' when ansid=247558 then '1' when ansid=247559 then '1' when ansid=247560 then '1' when ansid=247561 then '0' when ansid=247562 then 'Vacutainers used were of 4ml for blood sample collection. Moreover, the aliquots were of 2ml only. The site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed to the UASACS from the surveillance site by the SST member for corrective action.' when ansid=247563 then 'No' when ansid=247564 then 'No' when ansid=247565 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:30:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE supvisstepid = '13010'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:30:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:11' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE sitesupervision SET `siteid` = '303', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '84', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2635'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Alpana', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '8', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE onssid = '10868'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Sushila', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE onssid = '10869'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Anuradha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE onssid = '10870'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE onssid = '10871'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=247460 then '1' when ansid=247461 then '1' when ansid=247462 then '2' when ansid=247463 then '1' when ansid=247464 then '' when ansid=247465 then '436' when ansid=247466 then '1' when ansid=247566 then '1' when ansid=247567 then '1' when ansid=247509 then '1' when ansid=247511 then '1' when ansid=247513 then '1' when ansid=247515 then '3' when ansid=247517 then '1' when ansid=247519 then '4' when ansid=247520 then '2' when ansid=247521 then '794' when ansid=247522 then '225' when ansid=247523 then '' when ansid=247524 then '1' when ansid=247525 then '1' when ansid=247526 then '' when ansid=247527 then '1' when ansid=247528 then '' when ansid=247529 then '1' when ansid=247530 then '0.28' when ansid=247531 then '1' when ansid=247532 then '1' when ansid=247533 then 'nursing officer' when ansid=247534 then '1' when ansid=247535 then '' when ansid=247536 then '1' when ansid=247537 then '1' when ansid=247538 then '' when ansid=247539 then '1' when ansid=247540 then '2' when ansid=247541 then '1' when ansid=247542 then '1' when ansid=247543 then '1' when ansid=247544 then '1' when ansid=247545 then '2' when ansid=247546 then '1' when ansid=247547 then '1' when ansid=247548 then '1' when ansid=247549 then '' when ansid=247550 then '3' when ansid=247551 then 'Chiller box' when ansid=247552 then '2' when ansid=247553 then '1' when ansid=247554 then '1' when ansid=247555 then '' when ansid=247556 then '1' when ansid=247557 then '1' when ansid=247558 then '1' when ansid=247559 then '1' when ansid=247560 then '1' when ansid=247561 then '0' when ansid=247562 then 'Vacutainers used were of 4ml for blood sample collection. Moreover, the aliquots were of 2ml only. The site incharge was informed to ensure the procurement of supplies and materials required for the surveillance as per NACO guidelines and it was informed to the UASACS from the surveillance site by the SST member for corrective action.' when ansid=247563 then 'No' when ansid=247564 then 'No' when ansid=247565 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:30:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('247460','247461','247462','247463','247464','247465','247466','247566','247567','247509','247511','247513','247515','247517','247519','247520','247521','247522','247523','247524','247525','247526','247527','247528','247529','247530','247531','247532','247533','247534','247535','247536','247537','247538','247539','247540','247541','247542','247543','247544','247545','247546','247547','247548','247549','247550','247551','247552','247553','247554','247555','247556','247557','247558','247559','247560','247561','247562','247563','247564','247565')"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE supvisstepid = '13011'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE visitfeedbackid = '12951'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE visitfeedbackid = '12952'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE visitfeedbackid = '12953'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE visitfeedbackid = '12954'"} {"userId":"646","date":"2023-02-20 14:30:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:30:29' WHERE visitfeedbackid = '12955'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr H.M', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '2' when ansid=251117 then '1' when ansid=251059 then '0' when ansid=251061 then '0' when ansid=251063 then '0' when ansid=251065 then '0' when ansid=251067 then '0' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '2' when ansid=251076 then '-' when ansid=251077 then '2' when ansid=251078 then '' when ansid=251079 then '2' when ansid=251080 then '' when ansid=251081 then '3' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then '' when ansid=251086 then '1' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '' when ansid=251112 then 'NA' when ansid=251113 then 'NA' when ansid=251114 then 'NA' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:32:30'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE supvisstepid = '13177'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:32:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:30' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE onsitestaffs SET `staffname` = 'Mr H.M', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '2' when ansid=251117 then '1' when ansid=251059 then '0' when ansid=251061 then '0' when ansid=251063 then '0' when ansid=251065 then '0' when ansid=251067 then '0' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '2' when ansid=251076 then '-' when ansid=251077 then '2' when ansid=251078 then '' when ansid=251079 then '2' when ansid=251080 then '' when ansid=251081 then '3' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then '' when ansid=251086 then '1' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '' when ansid=251112 then 'NA' when ansid=251113 then 'NA' when ansid=251114 then 'NA' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:32:31'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE supvisstepid = '13175'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:32:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:32:31' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Hiraballab Nautiyal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '2' when ansid=251117 then '1' when ansid=251059 then '0' when ansid=251061 then '0' when ansid=251063 then '0' when ansid=251065 then '0' when ansid=251067 then '0' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '2' when ansid=251076 then '-' when ansid=251077 then '2' when ansid=251078 then '' when ansid=251079 then '2' when ansid=251080 then '' when ansid=251081 then '3' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then '' when ansid=251086 then '1' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '' when ansid=251112 then 'NA' when ansid=251113 then 'NA' when ansid=251114 then 'NA' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:37:54'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE supvisstepid = '13174'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:37:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:37:54' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Hiraballab Nautiyal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '1' when ansid=251117 then '1' when ansid=251059 then '0' when ansid=251061 then '0' when ansid=251063 then '0' when ansid=251065 then '0' when ansid=251067 then '0' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '2' when ansid=251076 then '-' when ansid=251077 then '2' when ansid=251078 then '' when ansid=251079 then '2' when ansid=251080 then '' when ansid=251081 then '3' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then '' when ansid=251086 then '1' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '' when ansid=251112 then 'NA' when ansid=251113 then 'NA' when ansid=251114 then 'NA' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:38:31'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE supvisstepid = '13175'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:38:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:38:31' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Hiraballab Nautiyal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '1' when ansid=251117 then '1' when ansid=251059 then '1' when ansid=251061 then '1' when ansid=251063 then '1' when ansid=251065 then '3' when ansid=251067 then '1' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '2' when ansid=251076 then '-' when ansid=251077 then '2' when ansid=251078 then '' when ansid=251079 then '2' when ansid=251080 then '' when ansid=251081 then '3' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then '' when ansid=251086 then '1' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '' when ansid=251112 then 'NA' when ansid=251113 then 'NA' when ansid=251114 then 'NA' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:39:27'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE supvisstepid = '13176'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:39:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:39:27' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Hiraballab Nautiyal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '1' when ansid=251117 then '1' when ansid=251059 then '1' when ansid=251061 then '1' when ansid=251063 then '1' when ansid=251065 then '3' when ansid=251067 then '1' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '1' when ansid=251076 then '-' when ansid=251077 then '1' when ansid=251078 then '' when ansid=251079 then '1' when ansid=251080 then '0.46' when ansid=251081 then '1' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then 'Hepatitis and other parameters were filled of previous pregnancies by counseller as they were having records access of past' when ansid=251086 then '2' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '0' when ansid=251112 then 'NA' when ansid=251113 then 'No' when ansid=251114 then 'No' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:44:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE supvisstepid = '13177'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:44:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:44:40' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE sitesupervision SET `siteid` = '301', `userid` = '646', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '43', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2668'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Nidhi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE onssid = '11000'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Hiraballab Nautiyal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE onssid = '11001'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Pushpender', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE onssid = '11002'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE onssid = '11003'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=251010 then '1' when ansid=251011 then '1' when ansid=251012 then '2' when ansid=251013 then '1' when ansid=251014 then '' when ansid=251015 then '319' when ansid=251016 then '1' when ansid=251116 then '1' when ansid=251117 then '1' when ansid=251059 then '1' when ansid=251061 then '1' when ansid=251063 then '1' when ansid=251065 then '3' when ansid=251067 then '1' when ansid=251069 then '4' when ansid=251070 then '2' when ansid=251071 then '112' when ansid=251072 then '52' when ansid=251073 then '' when ansid=251074 then '1' when ansid=251075 then '1' when ansid=251076 then '-' when ansid=251077 then '1' when ansid=251078 then '' when ansid=251079 then '1' when ansid=251080 then '0.46' when ansid=251081 then '1' when ansid=251082 then '1' when ansid=251083 then 'counseller' when ansid=251084 then '1' when ansid=251085 then 'Hepatitis and other parameters were filled of previous pregnancies by counseller as they were having records access of past' when ansid=251086 then '2' when ansid=251087 then '1' when ansid=251088 then '' when ansid=251089 then '1' when ansid=251090 then '2' when ansid=251091 then '1' when ansid=251092 then '1' when ansid=251093 then '1' when ansid=251094 then '1' when ansid=251095 then '3' when ansid=251096 then '1' when ansid=251097 then '1' when ansid=251098 then '1' when ansid=251099 then '' when ansid=251100 then '3' when ansid=251101 then 'thermocol box' when ansid=251102 then '2' when ansid=251103 then '1' when ansid=251104 then '1' when ansid=251105 then '' when ansid=251106 then '1' when ansid=251107 then '1' when ansid=251108 then '3' when ansid=251109 then '3' when ansid=251110 then '1' when ansid=251111 then '0' when ansid=251112 then 'NA' when ansid=251113 then 'No' when ansid=251114 then 'No' when ansid=251115 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.54.115',\r\n\t\t\t\t\t\t\t\tmodifiedby =646,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-20 14:45:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('251010','251011','251012','251013','251014','251015','251016','251116','251117','251059','251061','251063','251065','251067','251069','251070','251071','251072','251073','251074','251075','251076','251077','251078','251079','251080','251081','251082','251083','251084','251085','251086','251087','251088','251089','251090','251091','251092','251093','251094','251095','251096','251097','251098','251099','251100','251101','251102','251103','251104','251105','251106','251107','251108','251109','251110','251111','251112','251113','251114','251115')"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE supvisstepid = '13178'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE visitfeedback SET `feedback` = 'Counseller was informed to ensure correct information to be filled in the forms', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE visitfeedbackid = '13116'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE visitfeedbackid = '13117'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE visitfeedbackid = '13118'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE visitfeedbackid = '13119'"} {"userId":"646","date":"2023-02-20 14:45:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.54.115', `modifiedby` = '646', `modifieddate` = '2023-02-20 14:45:33' WHERE visitfeedbackid = '13120'"} {"userId":"646","date":"2023-02-20 14:47:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('646', '14.139.54.115', '2023-02-20 14:47:09')"} {"userId":"574","date":"2023-02-20 15:00:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.223', '2023-02-20 15:00:20')"}