{"userId":"30","date":"2019-04-20 09:33:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('30', '117.214.48.208', '2019-04-20 09:33:35')"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '' when ansid=76259 then '' when ansid=76260 then '' when ansid=76261 then '' when ansid=76262 then ''  when ansid=76263 then ''   when ansid=76264 then ''  when ansid=76265 then '' when ansid=76267 then '' when ansid=76269 then '' when ansid=76271 then '' when ansid=76273 then '' when ansid=76275 then '' when ansid=76277 then '' when ansid=76279 then '' when ansid=76281 then '' when ansid=76283 then '' when ansid=76285 then '' when ansid=76287 then '' when ansid=76289 then '' when ansid=76291 then '' when ansid=76293 then '' when ansid=76295 then '' when ansid=76297 then '' when ansid=76299 then '' when ansid=76301 then '' when ansid=76303 then '' when ansid=76305 then '' when ansid=76307 then '' when ansid=76309 then '' when ansid=76311 then '' when ansid=76313 then '' when ansid=76315 then '' when ansid=76317 then '' when ansid=76318 then '' when ansid=76319 then '' when ansid=76320 then ''  when ansid=76321 then ''   when ansid=76322 then ''  when ansid=76323 then ''  when ansid=76324 then ''   when ansid=76325 then ''   when ansid=76326 then ''   when ansid=76327 then ''  when ansid=76328 then '' when ansid=76329 then '' when ansid=76330 then ''  when ansid=76331 then ''   when ansid=76332 then ''   when ansid=76333 then ''   when ansid=76334 then ''  when ansid=76335 then ''  when ansid=76336 then ''   when ansid=76337 then ''  when ansid=76338 then '' when ansid=76339 then '' when ansid=76340 then '' when ansid=76341 then '' when ansid=76342 then '' when ansid=76343 then '' when ansid=76344 then '' when ansid=76345 then '' when ansid=76346 then ''  when ansid=76347 then ''   when ansid=76348 then ''   when ansid=76349 then ''   when ansid=76350 then ''  when ansid=76351 then '' when ansid=76352 then ''  when ansid=76353 then ''   when ansid=76354 then ''  when ansid=76355 then '' when ansid=76356 then '' when ansid=76357 then '' when ansid=76358 then '' when ansid=76359 then '' when ansid=76360 then '' when ansid=76361 then '' when ansid=76362 then '' when ansid=76363 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:41:34'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE supvisstepid = '4666'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:41:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:41:34' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '' when ansid=76267 then '' when ansid=76269 then '' when ansid=76271 then '' when ansid=76273 then '' when ansid=76275 then '' when ansid=76277 then '' when ansid=76279 then '' when ansid=76281 then '' when ansid=76283 then '' when ansid=76285 then '' when ansid=76287 then '' when ansid=76289 then '' when ansid=76291 then '' when ansid=76293 then '' when ansid=76295 then '' when ansid=76297 then '' when ansid=76299 then '' when ansid=76301 then '' when ansid=76303 then '' when ansid=76305 then '' when ansid=76307 then '' when ansid=76309 then '' when ansid=76311 then '' when ansid=76313 then '' when ansid=76315 then '' when ansid=76317 then '' when ansid=76318 then '' when ansid=76319 then '' when ansid=76320 then ''  when ansid=76321 then ''   when ansid=76322 then ''  when ansid=76323 then ''  when ansid=76324 then ''   when ansid=76325 then ''   when ansid=76326 then ''   when ansid=76327 then ''  when ansid=76328 then '' when ansid=76329 then '' when ansid=76330 then ''  when ansid=76331 then ''   when ansid=76332 then ''   when ansid=76333 then ''   when ansid=76334 then ''  when ansid=76335 then ''  when ansid=76336 then ''   when ansid=76337 then ''  when ansid=76338 then '' when ansid=76339 then '' when ansid=76340 then '' when ansid=76341 then '' when ansid=76342 then '' when ansid=76343 then '' when ansid=76344 then '' when ansid=76345 then '' when ansid=76346 then ''  when ansid=76347 then ''   when ansid=76348 then ''   when ansid=76349 then ''   when ansid=76350 then ''  when ansid=76351 then '' when ansid=76352 then ''  when ansid=76353 then ''   when ansid=76354 then ''  when ansid=76355 then '' when ansid=76356 then '' when ansid=76357 then '' when ansid=76358 then '' when ansid=76359 then '' when ansid=76360 then '' when ansid=76361 then '' when ansid=76362 then '' when ansid=76363 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:42:31'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE supvisstepid = '4667'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:42:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:42:31' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '2' when ansid=76267 then '2' when ansid=76269 then '450' when ansid=76271 then '1' when ansid=76273 then '1' when ansid=76275 then '450' when ansid=76277 then '1' when ansid=76279 then '1' when ansid=76281 then '' when ansid=76283 then '' when ansid=76285 then '' when ansid=76287 then '' when ansid=76289 then '' when ansid=76291 then '' when ansid=76293 then '' when ansid=76295 then '' when ansid=76297 then '' when ansid=76299 then '' when ansid=76301 then '' when ansid=76303 then '' when ansid=76305 then '' when ansid=76307 then '' when ansid=76309 then '' when ansid=76311 then '' when ansid=76313 then '' when ansid=76315 then '' when ansid=76317 then '' when ansid=76318 then '' when ansid=76319 then '' when ansid=76320 then ''  when ansid=76321 then ''   when ansid=76322 then ''  when ansid=76323 then ''  when ansid=76324 then ''   when ansid=76325 then ''   when ansid=76326 then ''   when ansid=76327 then ''  when ansid=76328 then '' when ansid=76329 then '' when ansid=76330 then ''  when ansid=76331 then ''   when ansid=76332 then ''   when ansid=76333 then ''   when ansid=76334 then ''  when ansid=76335 then ''  when ansid=76336 then ''   when ansid=76337 then ''  when ansid=76338 then '' when ansid=76339 then '' when ansid=76340 then '' when ansid=76341 then '' when ansid=76342 then '' when ansid=76343 then '' when ansid=76344 then '' when ansid=76345 then '' when ansid=76346 then ''  when ansid=76347 then ''   when ansid=76348 then ''   when ansid=76349 then ''   when ansid=76350 then ''  when ansid=76351 then '' when ansid=76352 then ''  when ansid=76353 then ''   when ansid=76354 then ''  when ansid=76355 then '' when ansid=76356 then '' when ansid=76357 then '' when ansid=76358 then '' when ansid=76359 then '' when ansid=76360 then '' when ansid=76361 then '' when ansid=76362 then '' when ansid=76363 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:43:05'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE supvisstepid = '4668'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:43:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:05' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '2' when ansid=76267 then '2' when ansid=76269 then '450' when ansid=76271 then '1' when ansid=76273 then '1' when ansid=76275 then '450' when ansid=76277 then '1' when ansid=76279 then '1' when ansid=76281 then '2' when ansid=76283 then '400' when ansid=76285 then '400' when ansid=76287 then '400' when ansid=76289 then '25' when ansid=76291 then '1' when ansid=76293 then '0' when ansid=76295 then '500' when ansid=76297 then '500' when ansid=76299 then '2' when ansid=76301 then '4' when ansid=76303 then '1' when ansid=76305 then '1' when ansid=76307 then '' when ansid=76309 then '' when ansid=76311 then '' when ansid=76313 then '' when ansid=76315 then '' when ansid=76317 then '' when ansid=76318 then '' when ansid=76319 then '' when ansid=76320 then ''  when ansid=76321 then ''   when ansid=76322 then ''  when ansid=76323 then ''  when ansid=76324 then ''   when ansid=76325 then ''   when ansid=76326 then ''   when ansid=76327 then ''  when ansid=76328 then '' when ansid=76329 then '' when ansid=76330 then ''  when ansid=76331 then ''   when ansid=76332 then ''   when ansid=76333 then ''   when ansid=76334 then ''  when ansid=76335 then ''  when ansid=76336 then ''   when ansid=76337 then ''  when ansid=76338 then '' when ansid=76339 then '' when ansid=76340 then '' when ansid=76341 then '' when ansid=76342 then '' when ansid=76343 then '' when ansid=76344 then '' when ansid=76345 then '' when ansid=76346 then ''  when ansid=76347 then ''   when ansid=76348 then ''   when ansid=76349 then ''   when ansid=76350 then ''  when ansid=76351 then '' when ansid=76352 then ''  when ansid=76353 then ''   when ansid=76354 then ''  when ansid=76355 then '' when ansid=76356 then '' when ansid=76357 then '' when ansid=76358 then '' when ansid=76359 then '' when ansid=76360 then '' when ansid=76361 then '' when ansid=76362 then '' when ansid=76363 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:43:46'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE supvisstepid = '4669'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:43:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:43:46' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:44:06","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '2' when ansid=76267 then '2' when ansid=76269 then '450' when ansid=76271 then '1' when ansid=76273 then '1' when ansid=76275 then '450' when ansid=76277 then '1' when ansid=76279 then '1' when ansid=76281 then '2' when ansid=76283 then '400' when ansid=76285 then '400' when ansid=76287 then '400' when ansid=76289 then '25' when ansid=76291 then '1' when ansid=76293 then '0' when ansid=76295 then '500' when ansid=76297 then '500' when ansid=76299 then '2' when ansid=76301 then '4' when ansid=76303 then '1' when ansid=76305 then '1' when ansid=76307 then '1' when ansid=76309 then '1' when ansid=76311 then '0' when ansid=76313 then '0' when ansid=76315 then '1' when ansid=76317 then '' when ansid=76318 then '' when ansid=76319 then '' when ansid=76320 then ''  when ansid=76321 then ''   when ansid=76322 then ''  when ansid=76323 then ''  when ansid=76324 then ''   when ansid=76325 then ''   when ansid=76326 then ''   when ansid=76327 then ''  when ansid=76328 then '' when ansid=76329 then '' when ansid=76330 then ''  when ansid=76331 then ''   when ansid=76332 then ''   when ansid=76333 then ''   when ansid=76334 then ''  when ansid=76335 then ''  when ansid=76336 then ''   when ansid=76337 then ''  when ansid=76338 then '' when ansid=76339 then '' when ansid=76340 then '' when ansid=76341 then '' when ansid=76342 then '' when ansid=76343 then '' when ansid=76344 then '' when ansid=76345 then '' when ansid=76346 then ''  when ansid=76347 then ''   when ansid=76348 then ''   when ansid=76349 then ''   when ansid=76350 then ''  when ansid=76351 then '' when ansid=76352 then ''  when ansid=76353 then ''   when ansid=76354 then ''  when ansid=76355 then '' when ansid=76356 then '' when ansid=76357 then '' when ansid=76358 then '' when ansid=76359 then '' when ansid=76360 then '' when ansid=76361 then '' when ansid=76362 then '' when ansid=76363 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:44:06'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE supvisstepid = '4670'"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:44:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:44:06' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '2' when ansid=76267 then '2' when ansid=76269 then '450' when ansid=76271 then '1' when ansid=76273 then '1' when ansid=76275 then '450' when ansid=76277 then '1' when ansid=76279 then '1' when ansid=76281 then '2' when ansid=76283 then '400' when ansid=76285 then '400' when ansid=76287 then '400' when ansid=76289 then '25' when ansid=76291 then '1' when ansid=76293 then '0' when ansid=76295 then '500' when ansid=76297 then '500' when ansid=76299 then '2' when ansid=76301 then '4' when ansid=76303 then '1' when ansid=76305 then '1' when ansid=76307 then '1' when ansid=76309 then '1' when ansid=76311 then '0' when ansid=76313 then '0' when ansid=76315 then '1' when ansid=76317 then '4' when ansid=76318 then '3' when ansid=76319 then '750' when ansid=76320 then '222'  when ansid=76321 then ''   when ansid=76322 then '1'  when ansid=76323 then '1'  when ansid=76324 then ''   when ansid=76325 then '1'   when ansid=76326 then ''   when ansid=76327 then '1'  when ansid=76328 then '8' when ansid=76329 then '1' when ansid=76330 then '1'  when ansid=76331 then 'Counsellor'   when ansid=76332 then '1'   when ansid=76333 then ''   when ansid=76334 then '1'  when ansid=76335 then '1'  when ansid=76336 then ''   when ansid=76337 then '1'  when ansid=76338 then '4' when ansid=76339 then '1' when ansid=76340 then '1' when ansid=76341 then '1' when ansid=76342 then '2' when ansid=76343 then '1' when ansid=76344 then '1' when ansid=76345 then '2' when ansid=76346 then '1'  when ansid=76347 then ''   when ansid=76348 then '4'   when ansid=76349 then 'Cold box'   when ansid=76350 then '2'  when ansid=76351 then '1' when ansid=76352 then '1'  when ansid=76353 then ''   when ansid=76354 then '1'  when ansid=76355 then '2' when ansid=76356 then '1' when ansid=76357 then '2' when ansid=76358 then '1' when ansid=76359 then '00' when ansid=76360 then '-Testing lab asked the lab technician of Madhubani to avoid pasting label on serum vials and write the details of sample on the paper already pasted on vial.-Due to physical separation, the consecutiveness of clients was difficult to maintain.' when ansid=76361 then 'No' when ansid=76362 then 'Consellor should visit ANC clinic and orient staff there to send all ANC cases to PPTCT center for HSS with support from ASHA. Recruitment of clients was done at PPTCTC center.' when ansid=76363 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:50:44'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE supvisstepid = '4671'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:50:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:50:44' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE sitesupervision SET `siteid` = '357', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '86', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '728'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay Narayan Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE onssid = '3240'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE onsitestaffs SET `staffname` = 'Sarita Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE onssid = '3241'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE onsitestaffs SET `staffname` = 'Vishnu Deo Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE onssid = '3242'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE onssid = '3243'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76258 then '2' when ansid=76259 then '1' when ansid=76260 then '2' when ansid=76261 then '2' when ansid=76262 then '1'  when ansid=76263 then '222'   when ansid=76264 then '1'  when ansid=76265 then '2' when ansid=76267 then '2' when ansid=76269 then '450' when ansid=76271 then '1' when ansid=76273 then '1' when ansid=76275 then '450' when ansid=76277 then '1' when ansid=76279 then '1' when ansid=76281 then '2' when ansid=76283 then '400' when ansid=76285 then '400' when ansid=76287 then '400' when ansid=76289 then '25' when ansid=76291 then '1' when ansid=76293 then '0' when ansid=76295 then '500' when ansid=76297 then '500' when ansid=76299 then '2' when ansid=76301 then '4' when ansid=76303 then '1' when ansid=76305 then '1' when ansid=76307 then '1' when ansid=76309 then '1' when ansid=76311 then '0' when ansid=76313 then '0' when ansid=76315 then '1' when ansid=76317 then '4' when ansid=76318 then '3' when ansid=76319 then '750' when ansid=76320 then '222'  when ansid=76321 then ''   when ansid=76322 then '1'  when ansid=76323 then '1'  when ansid=76324 then ''   when ansid=76325 then '1'   when ansid=76326 then ''   when ansid=76327 then '1'  when ansid=76328 then '8' when ansid=76329 then '1' when ansid=76330 then '1'  when ansid=76331 then 'Counsellor'   when ansid=76332 then '1'   when ansid=76333 then ''   when ansid=76334 then '1'  when ansid=76335 then '1'  when ansid=76336 then ''   when ansid=76337 then '1'  when ansid=76338 then '4' when ansid=76339 then '1' when ansid=76340 then '1' when ansid=76341 then '1' when ansid=76342 then '2' when ansid=76343 then '1' when ansid=76344 then '1' when ansid=76345 then '2' when ansid=76346 then '1'  when ansid=76347 then ''   when ansid=76348 then '4'   when ansid=76349 then 'Cold box'   when ansid=76350 then '2'  when ansid=76351 then '1' when ansid=76352 then '1'  when ansid=76353 then ''   when ansid=76354 then '1'  when ansid=76355 then '2' when ansid=76356 then '1' when ansid=76357 then '2' when ansid=76358 then '1' when ansid=76359 then '00' when ansid=76360 then '-Testing lab asked the lab technician of Madhubani to avoid pasting label on serum vials and write the details of sample on the paper already pasted on vial.-Due to physical separation, the consecutiveness of clients was difficult to maintain.' when ansid=76361 then 'No' when ansid=76362 then 'Consellor should visit ANC clinic and orient staff there to send all ANC cases to PPTCT center for HSS with support from ASHA. Recruitment of clients was done at PPTCTC center.' when ansid=76363 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 09:52:19'\n\t\t\t\t\t\t\tWHERE ansid in ('76258','76259','76260','76261','76262','76263','76264','76265','76267','76269','76271','76273','76275','76277','76279','76281','76283','76285','76287','76289','76291','76293','76295','76297','76299','76301','76303','76305','76307','76309','76311','76313','76315','76317','76318','76319','76320','76321','76322','76323','76324','76325','76326','76327','76328','76329','76330','76331','76332','76333','76334','76335','76336','76337','76338','76339','76340','76341','76342','76343','76344','76345','76346','76347','76348','76349','76350','76351','76352','76353','76354','76355','76356','76357','76358','76359','76360','76361','76362','76363')"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE supvisstepid = '4672'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE visitfeedback SET `feedback` = 'Consecutiveness of clients was not maintained as ANC clinic staff were not aware. Orientation was done.', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE visitfeedbackid = '3416'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE visitfeedback SET `feedback` = 'LT was writing sample details on vial itself. He was asked to follow the guidelines.', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE visitfeedbackid = '3417'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE visitfeedbackid = '3418'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE visitfeedbackid = '3419'"}
{"userId":"30","date":"2019-04-20 09:52:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 09:52:19' WHERE visitfeedbackid = '3420'"}
{"userId":"30","date":"2019-04-20 09:52:51","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('372', '911', '30', '2019-04-20', '1', '117.214.48.208', '30', '2019-04-20 09:52:51', '', '')"}
{"userId":"30","date":"2019-04-20 09:52:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '0', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '1', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '2', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '3', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '4', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '5', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('731', '6', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('731', '', '', 'Array', '', 'Array', '', '117.214.48.208', '30', '2019-04-20 09:52:52')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('731', '', '', 'Array', '', 'Array', '', '117.214.48.208', '30', '2019-04-20 09:52:52')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('731', '', '', 'Array', '', 'Array', '', '117.214.48.208', '30', '2019-04-20 09:52:52')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('731', '', '', 'Array', '', 'Array', '', '117.214.48.208', '30', '2019-04-20 09:52:52')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:52:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 09:53:05","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('731', '117.214.48.208', '30', '2019-04-20 09:52:51')"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:26:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '' when ansid=76553 then '' when ansid=76554 then '' when ansid=76555 then '' when ansid=76556 then ''  when ansid=76557 then ''   when ansid=76558 then ''  when ansid=76559 then '' when ansid=76561 then '' when ansid=76563 then '' when ansid=76565 then '' when ansid=76567 then '' when ansid=76569 then '' when ansid=76571 then '' when ansid=76573 then '' when ansid=76575 then '' when ansid=76577 then '' when ansid=76579 then '' when ansid=76581 then '' when ansid=76583 then '' when ansid=76585 then '' when ansid=76587 then '' when ansid=76589 then '' when ansid=76591 then '' when ansid=76593 then '' when ansid=76595 then '' when ansid=76597 then '' when ansid=76599 then '' when ansid=76601 then '' when ansid=76603 then '' when ansid=76605 then '' when ansid=76607 then '' when ansid=76609 then '' when ansid=76611 then '' when ansid=76612 then '' when ansid=76613 then '' when ansid=76614 then ''  when ansid=76615 then ''   when ansid=76616 then ''  when ansid=76617 then ''  when ansid=76618 then ''   when ansid=76619 then ''   when ansid=76620 then ''   when ansid=76621 then ''  when ansid=76622 then '' when ansid=76623 then '' when ansid=76624 then ''  when ansid=76625 then ''   when ansid=76626 then ''   when ansid=76627 then ''   when ansid=76628 then ''  when ansid=76629 then ''  when ansid=76630 then ''   when ansid=76631 then ''  when ansid=76632 then '' when ansid=76633 then '' when ansid=76634 then '' when ansid=76635 then '' when ansid=76636 then '' when ansid=76637 then '' when ansid=76638 then '' when ansid=76639 then '' when ansid=76640 then ''  when ansid=76641 then ''   when ansid=76642 then ''   when ansid=76643 then ''   when ansid=76644 then ''  when ansid=76645 then '' when ansid=76646 then ''  when ansid=76647 then ''   when ansid=76648 then ''  when ansid=76649 then '' when ansid=76650 then '' when ansid=76651 then '' when ansid=76652 then '' when ansid=76653 then '' when ansid=76654 then '' when ansid=76655 then '' when ansid=76656 then '' when ansid=76657 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:26:08'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE supvisstepid = '4685'"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:26:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:08' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '' when ansid=76561 then '' when ansid=76563 then '' when ansid=76565 then '' when ansid=76567 then '' when ansid=76569 then '' when ansid=76571 then '' when ansid=76573 then '' when ansid=76575 then '' when ansid=76577 then '' when ansid=76579 then '' when ansid=76581 then '' when ansid=76583 then '' when ansid=76585 then '' when ansid=76587 then '' when ansid=76589 then '' when ansid=76591 then '' when ansid=76593 then '' when ansid=76595 then '' when ansid=76597 then '' when ansid=76599 then '' when ansid=76601 then '' when ansid=76603 then '' when ansid=76605 then '' when ansid=76607 then '' when ansid=76609 then '' when ansid=76611 then '' when ansid=76612 then '' when ansid=76613 then '' when ansid=76614 then ''  when ansid=76615 then ''   when ansid=76616 then ''  when ansid=76617 then ''  when ansid=76618 then ''   when ansid=76619 then ''   when ansid=76620 then ''   when ansid=76621 then ''  when ansid=76622 then '' when ansid=76623 then '' when ansid=76624 then ''  when ansid=76625 then ''   when ansid=76626 then ''   when ansid=76627 then ''   when ansid=76628 then ''  when ansid=76629 then ''  when ansid=76630 then ''   when ansid=76631 then ''  when ansid=76632 then '' when ansid=76633 then '' when ansid=76634 then '' when ansid=76635 then '' when ansid=76636 then '' when ansid=76637 then '' when ansid=76638 then '' when ansid=76639 then '' when ansid=76640 then ''  when ansid=76641 then ''   when ansid=76642 then ''   when ansid=76643 then ''   when ansid=76644 then ''  when ansid=76645 then '' when ansid=76646 then ''  when ansid=76647 then ''   when ansid=76648 then ''  when ansid=76649 then '' when ansid=76650 then '' when ansid=76651 then '' when ansid=76652 then '' when ansid=76653 then '' when ansid=76654 then '' when ansid=76655 then '' when ansid=76656 then '' when ansid=76657 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:26:48'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE supvisstepid = '4686'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:26:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:26:48' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '' when ansid=76577 then '' when ansid=76579 then '' when ansid=76581 then '' when ansid=76583 then '' when ansid=76585 then '' when ansid=76587 then '' when ansid=76589 then '' when ansid=76591 then '' when ansid=76593 then '' when ansid=76595 then '' when ansid=76597 then '' when ansid=76599 then '' when ansid=76601 then '' when ansid=76603 then '' when ansid=76605 then '' when ansid=76607 then '' when ansid=76609 then '' when ansid=76611 then '' when ansid=76612 then '' when ansid=76613 then '' when ansid=76614 then ''  when ansid=76615 then ''   when ansid=76616 then ''  when ansid=76617 then ''  when ansid=76618 then ''   when ansid=76619 then ''   when ansid=76620 then ''   when ansid=76621 then ''  when ansid=76622 then '' when ansid=76623 then '' when ansid=76624 then ''  when ansid=76625 then ''   when ansid=76626 then ''   when ansid=76627 then ''   when ansid=76628 then ''  when ansid=76629 then ''  when ansid=76630 then ''   when ansid=76631 then ''  when ansid=76632 then '' when ansid=76633 then '' when ansid=76634 then '' when ansid=76635 then '' when ansid=76636 then '' when ansid=76637 then '' when ansid=76638 then '' when ansid=76639 then '' when ansid=76640 then ''  when ansid=76641 then ''   when ansid=76642 then ''   when ansid=76643 then ''   when ansid=76644 then ''  when ansid=76645 then '' when ansid=76646 then ''  when ansid=76647 then ''   when ansid=76648 then ''  when ansid=76649 then '' when ansid=76650 then '' when ansid=76651 then '' when ansid=76652 then '' when ansid=76653 then '' when ansid=76654 then '' when ansid=76655 then '' when ansid=76656 then '' when ansid=76657 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:27:13'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE supvisstepid = '4687'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:27:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:27:13' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:28:07","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '' when ansid=76603 then '' when ansid=76605 then '' when ansid=76607 then '' when ansid=76609 then '' when ansid=76611 then '' when ansid=76612 then '' when ansid=76613 then '' when ansid=76614 then ''  when ansid=76615 then ''   when ansid=76616 then ''  when ansid=76617 then ''  when ansid=76618 then ''   when ansid=76619 then ''   when ansid=76620 then ''   when ansid=76621 then ''  when ansid=76622 then '' when ansid=76623 then '' when ansid=76624 then ''  when ansid=76625 then ''   when ansid=76626 then ''   when ansid=76627 then ''   when ansid=76628 then ''  when ansid=76629 then ''  when ansid=76630 then ''   when ansid=76631 then ''  when ansid=76632 then '' when ansid=76633 then '' when ansid=76634 then '' when ansid=76635 then '' when ansid=76636 then '' when ansid=76637 then '' when ansid=76638 then '' when ansid=76639 then '' when ansid=76640 then ''  when ansid=76641 then ''   when ansid=76642 then ''   when ansid=76643 then ''   when ansid=76644 then ''  when ansid=76645 then '' when ansid=76646 then ''  when ansid=76647 then ''   when ansid=76648 then ''  when ansid=76649 then '' when ansid=76650 then '' when ansid=76651 then '' when ansid=76652 then '' when ansid=76653 then '' when ansid=76654 then '' when ansid=76655 then '' when ansid=76656 then '' when ansid=76657 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:28:07'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE supvisstepid = '4688'"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:28:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:07' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:28:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '' when ansid=76612 then '' when ansid=76613 then '' when ansid=76614 then ''  when ansid=76615 then ''   when ansid=76616 then ''  when ansid=76617 then ''  when ansid=76618 then ''   when ansid=76619 then ''   when ansid=76620 then ''   when ansid=76621 then ''  when ansid=76622 then '' when ansid=76623 then '' when ansid=76624 then ''  when ansid=76625 then ''   when ansid=76626 then ''   when ansid=76627 then ''   when ansid=76628 then ''  when ansid=76629 then ''  when ansid=76630 then ''   when ansid=76631 then ''  when ansid=76632 then '' when ansid=76633 then '' when ansid=76634 then '' when ansid=76635 then '' when ansid=76636 then '' when ansid=76637 then '' when ansid=76638 then '' when ansid=76639 then '' when ansid=76640 then ''  when ansid=76641 then ''   when ansid=76642 then ''   when ansid=76643 then ''   when ansid=76644 then ''  when ansid=76645 then '' when ansid=76646 then ''  when ansid=76647 then ''   when ansid=76648 then ''  when ansid=76649 then '' when ansid=76650 then '' when ansid=76651 then '' when ansid=76652 then '' when ansid=76653 then '' when ansid=76654 then '' when ansid=76655 then '' when ansid=76656 then '' when ansid=76657 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:28:28'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE supvisstepid = '4689'"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:28:28' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:37:57","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:58' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:58' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:58' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:58' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '0' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:37:57'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE supvisstepid = '4690'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:37:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:37:57' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 10:39:30","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '0' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.208',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 10:39:30'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 10:39:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE supvisstepid = '4690'"}
{"userId":"30","date":"2019-04-20 10:39:32","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 10:39:32","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 10:39:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 10:39:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 10:39:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.208', `modifiedby` = '30', `modifieddate` = '2019-04-20 10:39:30' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 19:19:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('30', '117.214.54.80', '2019-04-20 19:19:16')"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 19:19:30","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.54.80',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 19:19:30'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE supvisstepid = '4690'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:30' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.54.80',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 19:19:31'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE supvisstepid = '4686'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 19:19:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.54.80',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 19:19:31'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE supvisstepid = '4688'"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 19:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:19:31' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 19:20:52","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:55' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:55' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:55' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:55' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '0' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.54.80',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 19:20:52'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE supvisstepid = '4690'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 19:20:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:20:52' WHERE visitfeedbackid = '3435'"}
{"userId":"30","date":"2019-04-20 19:24:26","query":"UPDATE sitesupervision SET `siteid` = '372', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '163', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '731'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Vasudeo Prasad', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:27' WHERE onssid = '3252'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE onsitestaffs SET `staffname` = 'Manju Kumari Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:27' WHERE onssid = '3253'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE onsitestaffs SET `staffname` = 'Md. Hussain', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:27' WHERE onssid = '3254'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:27' WHERE onssid = '3255'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76552 then '1' when ansid=76553 then '2' when ansid=76554 then '2' when ansid=76555 then '1' when ansid=76556 then ''  when ansid=76557 then '507'   when ansid=76558 then '1'  when ansid=76559 then '2' when ansid=76561 then '0' when ansid=76563 then '450' when ansid=76565 then '5' when ansid=76567 then '5' when ansid=76569 then '450' when ansid=76571 then '1' when ansid=76573 then '1' when ansid=76575 then '2' when ansid=76577 then '400' when ansid=76579 then '400' when ansid=76581 then '0' when ansid=76583 then '16' when ansid=76585 then '1' when ansid=76587 then '0' when ansid=76589 then '420' when ansid=76591 then '400' when ansid=76593 then '2' when ansid=76595 then '2' when ansid=76597 then '1' when ansid=76599 then '3' when ansid=76601 then '0' when ansid=76603 then '1' when ansid=76605 then '0' when ansid=76607 then '0' when ansid=76609 then '1' when ansid=76611 then '2' when ansid=76612 then '2' when ansid=76613 then '107' when ansid=76614 then '17'  when ansid=76615 then ''   when ansid=76616 then '1'  when ansid=76617 then '1'  when ansid=76618 then ''   when ansid=76619 then '1'   when ansid=76620 then ''   when ansid=76621 then '1'  when ansid=76622 then '10' when ansid=76623 then '1' when ansid=76624 then '1'  when ansid=76625 then 'Counsellor'   when ansid=76626 then '1'   when ansid=76627 then ''   when ansid=76628 then '1'  when ansid=76629 then '1'  when ansid=76630 then ''   when ansid=76631 then '2'  when ansid=76632 then '4' when ansid=76633 then '2' when ansid=76634 then '1' when ansid=76635 then '1' when ansid=76636 then '2' when ansid=76637 then '1' when ansid=76638 then '1' when ansid=76639 then '1' when ansid=76640 then '1'  when ansid=76641 then ''   when ansid=76642 then '4'   when ansid=76643 then 'Cold box'   when ansid=76644 then '2'  when ansid=76645 then '1' when ansid=76646 then '2'  when ansid=76647 then 'Not working'   when ansid=76648 then '2'  when ansid=76649 then '2' when ansid=76650 then '3' when ansid=76651 then '2' when ansid=76652 then '1' when ansid=76653 then '0' when ansid=76654 then '-Flow chart was not provided. Staff were told to photocopy the flowchart from manual and paste in work place.- PPTCT center did not have refrigerator and centrifuge machine. They used equipment available in patho lab.-OPD complex is locked at 12 pm and there was problem in serum separation. Lab technician was directed to collect sample up to 11.30 AM and must separate serum on the same day and store in refrigerator.' when ansid=76655 then 'No' when ansid=76656 then 'HSS register was not filled properly. ANC records were not maintained properly.' when ansid=76657 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.54.80',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-20 19:24:26'\n\t\t\t\t\t\t\tWHERE ansid in ('76552','76553','76554','76555','76556','76557','76558','76559','76561','76563','76565','76567','76569','76571','76573','76575','76577','76579','76581','76583','76585','76587','76589','76591','76593','76595','76597','76599','76601','76603','76605','76607','76609','76611','76612','76613','76614','76615','76616','76617','76618','76619','76620','76621','76622','76623','76624','76625','76626','76627','76628','76629','76630','76631','76632','76633','76634','76635','76636','76637','76638','76639','76640','76641','76642','76643','76644','76645','76646','76647','76648','76649','76650','76651','76652','76653','76654','76655','76656','76657')"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE supvisstepid = '4691'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE visitfeedback SET `feedback` = 'HSS register was not filled properly. Counsellor was oriented.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE visitfeedbackid = '3431'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE visitfeedback SET `feedback` = 'Flow chart not available. Staff were advised to get the photocopy of book done.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE visitfeedbackid = '3432'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE visitfeedback SET `feedback` = 'No refrigerator and centrifuge machine in PPTCT center. Help of patho lab was taken. Staff of patho lab were oriented and were supportive.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE visitfeedbackid = '3433'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE visitfeedback SET `feedback` = 'OPD complex is locked at 12 PM. Local arrangement was advised for sample collection, serum separation and preservation in cold chain on the same day as per guidelines.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE visitfeedbackid = '3434'"}
{"userId":"30","date":"2019-04-20 19:24:27","query":"UPDATE visitfeedback SET `feedback` = 'Site incharge will retire in April and was advised to orient the new incharge.', `recommendation` = '', `ipaddress` = '117.214.54.80', `modifiedby` = '30', `modifieddate` = '2019-04-20 19:24:26' WHERE visitfeedbackid = '3435'"}
{"userId":"53","date":"2019-04-20 19:28:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('53', '42.110.209.28', '2019-04-20 19:28:04')"}