{"userId":"123","date":"2019-03-26 10:11:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.62.60', '2019-03-26 10:11:06')"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '' when ansid=73193 then '' when ansid=73195 then '' when ansid=73197 then '' when ansid=73199 then '' when ansid=73201 then '' when ansid=73203 then '' when ansid=73205 then '' when ansid=73207 then '' when ansid=73209 then '' when ansid=73211 then '' when ansid=73213 then '' when ansid=73215 then '' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then '' when ansid=73231 then '' when ansid=73232 then '' when ansid=73233 then '' when ansid=73234 then '' when ansid=73235 then '' when ansid=73236 then '' when ansid=73237 then '' when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then '' when ansid=73241 then '' when ansid=73242 then '' when ansid=73243 then '' when ansid=73244 then '' when ansid=73245 then '' when ansid=73246 then '' when ansid=73247 then '' when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then '' when ansid=73257 then '' when ansid=73258 then '' when ansid=73259 then '' when ansid=73260 then '' when ansid=73261 then '' when ansid=73262 then '' when ansid=73263 then '' when ansid=73264 then '' when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:11:31'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE supvisstepid = '4481'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '' when ansid=73193 then '' when ansid=73195 then '' when ansid=73197 then '' when ansid=73199 then '' when ansid=73201 then '' when ansid=73203 then '' when ansid=73205 then '' when ansid=73207 then '' when ansid=73209 then '' when ansid=73211 then '' when ansid=73213 then '' when ansid=73215 then '' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then '' when ansid=73231 then '' when ansid=73232 then '' when ansid=73233 then '' when ansid=73234 then '' when ansid=73235 then '' when ansid=73236 then '' when ansid=73237 then '' when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then '' when ansid=73241 then '' when ansid=73242 then '' when ansid=73243 then '' when ansid=73244 then '' when ansid=73245 then '' when ansid=73246 then '' when ansid=73247 then '' when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then '' when ansid=73257 then '' when ansid=73258 then '' when ansid=73259 then '' when ansid=73260 then '' when ansid=73261 then '' when ansid=73262 then '' when ansid=73263 then '' when ansid=73264 then '' when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:11:31'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE supvisstepid = '4482'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:11:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:11:31' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:12:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '13' when ansid=73193 then '150' when ansid=73195 then '0' when ansid=73197 then '275' when ansid=73199 then '200' when ansid=73201 then '0' when ansid=73203 then '280' when ansid=73205 then '50' when ansid=73207 then '0' when ansid=73209 then '2' when ansid=73211 then '0' when ansid=73213 then '0' when ansid=73215 then '0' when ansid=73217 then '' when ansid=73219 then '' when ansid=73221 then '' when ansid=73223 then '' when ansid=73225 then '' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then '' when ansid=73231 then '' when ansid=73232 then '' when ansid=73233 then '' when ansid=73234 then '' when ansid=73235 then '' when ansid=73236 then '' when ansid=73237 then '' when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then '' when ansid=73241 then '' when ansid=73242 then '' when ansid=73243 then '' when ansid=73244 then '' when ansid=73245 then '' when ansid=73246 then '' when ansid=73247 then '' when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then '' when ansid=73257 then '' when ansid=73258 then '' when ansid=73259 then '' when ansid=73260 then '' when ansid=73261 then '' when ansid=73262 then '' when ansid=73263 then '' when ansid=73264 then '' when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:12:38'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE supvisstepid = '4484'"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:12:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:12:38' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:13:20","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '13' when ansid=73193 then '150' when ansid=73195 then '0' when ansid=73197 then '275' when ansid=73199 then '200' when ansid=73201 then '0' when ansid=73203 then '280' when ansid=73205 then '50' when ansid=73207 then '0' when ansid=73209 then '2' when ansid=73211 then '0' when ansid=73213 then '0' when ansid=73215 then '0' when ansid=73217 then '0' when ansid=73219 then '0' when ansid=73221 then '0' when ansid=73223 then '27' when ansid=73225 then '1' when ansid=73227 then '' when ansid=73228 then '' when ansid=73229 then '' when ansid=73230 then '' when ansid=73231 then '' when ansid=73232 then '' when ansid=73233 then '' when ansid=73234 then '' when ansid=73235 then '' when ansid=73236 then '' when ansid=73237 then '' when ansid=73238 then '' when ansid=73239 then '' when ansid=73240 then '' when ansid=73241 then '' when ansid=73242 then '' when ansid=73243 then '' when ansid=73244 then '' when ansid=73245 then '' when ansid=73246 then '' when ansid=73247 then '' when ansid=73248 then '' when ansid=73249 then '' when ansid=73250 then '' when ansid=73251 then '' when ansid=73252 then '' when ansid=73253 then '' when ansid=73254 then '' when ansid=73255 then '' when ansid=73256 then '' when ansid=73257 then '' when ansid=73258 then '' when ansid=73259 then '' when ansid=73260 then '' when ansid=73261 then '' when ansid=73262 then '' when ansid=73263 then '' when ansid=73264 then '' when ansid=73265 then '' when ansid=73266 then '' when ansid=73267 then '' when ansid=73268 then '' when ansid=73269 then '' when ansid=73270 then '' when ansid=73271 then '' when ansid=73272 then '' when ansid=73273 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:13:20'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE supvisstepid = '4485'"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:13:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:13:20' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:22:33","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '13' when ansid=73193 then '150' when ansid=73195 then '0' when ansid=73197 then '275' when ansid=73199 then '200' when ansid=73201 then '0' when ansid=73203 then '280' when ansid=73205 then '50' when ansid=73207 then '0' when ansid=73209 then '2' when ansid=73211 then '0' when ansid=73213 then '0' when ansid=73215 then '0' when ansid=73217 then '0' when ansid=73219 then '0' when ansid=73221 then '0' when ansid=73223 then '27' when ansid=73225 then '1' when ansid=73227 then '9' when ansid=73228 then '0' when ansid=73229 then '319' when ansid=73230 then '13' when ansid=73231 then '' when ansid=73232 then '1' when ansid=73233 then '1' when ansid=73234 then '' when ansid=73235 then '1' when ansid=73236 then '' when ansid=73237 then '1' when ansid=73238 then '5' when ansid=73239 then '1' when ansid=73240 then '1' when ansid=73241 then 'Staff nurse' when ansid=73242 then '1' when ansid=73243 then '' when ansid=73244 then '1' when ansid=73245 then '1' when ansid=73246 then '' when ansid=73247 then '1' when ansid=73248 then '2' when ansid=73249 then '1' when ansid=73250 then '1' when ansid=73251 then '1' when ansid=73252 then '1' when ansid=73253 then '2' when ansid=73254 then '1' when ansid=73255 then '1' when ansid=73256 then '1' when ansid=73257 then '' when ansid=73258 then '3' when ansid=73259 then '' when ansid=73260 then '1' when ansid=73261 then '1' when ansid=73262 then '1' when ansid=73263 then 'Non functioning' when ansid=73264 then '2' when ansid=73265 then '1' when ansid=73266 then '1' when ansid=73267 then '1' when ansid=73268 then '1' when ansid=73269 then '1' when ansid=73270 then 'one needle destroyer is needed.reimbursement of fare for sample transportation to testing lab from ANC site.' when ansid=73271 then 'SACS Manipur visited on 23\/02\/19.Non functioning of centrifuge was reported subsequently new machine was provided' when ansid=73272 then 'Lab needs to be well organised.Puncture proof container and needle destroyer to be provided.' when ansid=73273 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:22:33'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE supvisstepid = '4486'"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:22:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:22:33' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE sitesupervision SET `siteid` = '110', `userid` = '123', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-02-02', `numofsamplecollected` = '213', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19', `locationtype` = '2', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '698'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Yohen', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE onssid = '3120'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE onsitestaffs SET `staffname` = 'Erah Mongei', `staffdesigid` = '8', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE onssid = '3121'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE onsitestaffs SET `staffname` = 'Nimreiyao', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE onssid = '3122'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE onssid = '3123'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73168 then '1' when ansid=73169 then '1' when ansid=73170 then '1' when ansid=73171 then '' when ansid=73172 then '' when ansid=73173 then '' when ansid=73174 then '1' when ansid=73175 then '01' when ansid=73177 then '1' when ansid=73179 then '270' when ansid=73181 then '4' when ansid=73183 then '4' when ansid=73185 then '280' when ansid=73187 then '1' when ansid=73189 then '1' when ansid=73191 then '13' when ansid=73193 then '150' when ansid=73195 then '0' when ansid=73197 then '275' when ansid=73199 then '200' when ansid=73201 then '0' when ansid=73203 then '280' when ansid=73205 then '50' when ansid=73207 then '0' when ansid=73209 then '2' when ansid=73211 then '0' when ansid=73213 then '0' when ansid=73215 then '0' when ansid=73217 then '0' when ansid=73219 then '0' when ansid=73221 then '0' when ansid=73223 then '27' when ansid=73225 then '1' when ansid=73227 then '9' when ansid=73228 then '0' when ansid=73229 then '319' when ansid=73230 then '13' when ansid=73231 then '' when ansid=73232 then '1' when ansid=73233 then '1' when ansid=73234 then '' when ansid=73235 then '1' when ansid=73236 then '' when ansid=73237 then '1' when ansid=73238 then '5' when ansid=73239 then '1' when ansid=73240 then '1' when ansid=73241 then 'Staff nurse' when ansid=73242 then '1' when ansid=73243 then '' when ansid=73244 then '1' when ansid=73245 then '1' when ansid=73246 then '' when ansid=73247 then '1' when ansid=73248 then '2' when ansid=73249 then '1' when ansid=73250 then '1' when ansid=73251 then '1' when ansid=73252 then '1' when ansid=73253 then '2' when ansid=73254 then '1' when ansid=73255 then '1' when ansid=73256 then '1' when ansid=73257 then '' when ansid=73258 then '3' when ansid=73259 then '' when ansid=73260 then '1' when ansid=73261 then '1' when ansid=73262 then '1' when ansid=73263 then 'Non functioning' when ansid=73264 then '2' when ansid=73265 then '1' when ansid=73266 then '1' when ansid=73267 then '1' when ansid=73268 then '1' when ansid=73269 then '1' when ansid=73270 then 'one needle destroyer is needed.reimbursement of fare for sample transportation to testing lab from ANC site.' when ansid=73271 then 'SACS Manipur visited on 23\/02\/19.Non functioning of centrifuge was reported subsequently new machine was provided' when ansid=73272 then 'Lab needs to be well organised.Puncture proof container and needle destroyer to be provided.' when ansid=73273 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.56.62.60',\n\t\t\t\t\t\t\t\tmodifiedby =123,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:25:19'\n\t\t\t\t\t\t\tWHERE ansid in ('73168','73169','73170','73171','73172','73173','73174','73175','73177','73179','73181','73183','73185','73187','73189','73191','73193','73195','73197','73199','73201','73203','73205','73207','73209','73211','73213','73215','73217','73219','73221','73223','73225','73227','73228','73229','73230','73231','73232','73233','73234','73235','73236','73237','73238','73239','73240','73241','73242','73243','73244','73245','73246','73247','73248','73249','73250','73251','73252','73253','73254','73255','73256','73257','73258','73259','73260','73261','73262','73263','73264','73265','73266','73267','73268','73269','73270','73271','73272','73273')"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE supvisstepid = '4487'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE visitfeedback SET `feedback` = 'Puncture proof destroyer not used', `recommendation` = 'Puncture proof container to ne used', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE visitfeedbackid = '3271'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE visitfeedback SET `feedback` = 'Needle destroyer non functioning', `recommendation` = 'Provision pf neefle destroyer', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE visitfeedbackid = '3272'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE visitfeedbackid = '3273'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE visitfeedbackid = '3274'"} {"userId":"123","date":"2019-03-26 10:25:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.56.62.60', `modifiedby` = '123', `modifieddate` = '2019-03-26 10:25:19' WHERE visitfeedbackid = '3275'"} {"userId":"123","date":"2019-03-26 10:26:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('123', '27.56.62.60', '2019-03-26 10:26:10')"} {"userId":"33","date":"2019-03-26 10:44:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('33', '14.139.218.146', '2019-03-26 10:44:24')"} {"userId":"33","date":"2019-03-26 10:45:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('33', '14.139.218.146', '2019-03-26 10:45:10')"} {"userId":"33","date":"2019-03-26 10:48:10","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1065', '2019-03-18', '33', '14.139.218.146', '33', '2019-03-26 10:48:10')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1065', '880', '33', '2019-03-26', '1', '14.139.218.146', '33', '2019-03-26 10:48:22', '', '')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '0', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '1', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '2', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '3', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '4', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('699', '5', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('699', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 10:48:27')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('699', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 10:48:27')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('699', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 10:48:27')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('699', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 10:48:27')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:48:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:49:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:50:48","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('699', '14.139.218.146', '33', '2019-03-26 10:48:22')"} {"userId":"33","date":"2019-03-26 10:53:00","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 10:53:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:01' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 10:53:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:01' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 10:53:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:01' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 10:53:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:01' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 10:53:01","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '' when ansid=73276 then '' when ansid=73278 then '' when ansid=73280 then '' when ansid=73282 then '' when ansid=73284 then '' when ansid=73286 then '' when ansid=73288 then '' when ansid=73290 then '' when ansid=73292 then '' when ansid=73294 then '' when ansid=73296 then '' when ansid=73298 then '' when ansid=73300 then '' when ansid=73302 then '' when ansid=73304 then '' when ansid=73306 then '' when ansid=73308 then '' when ansid=73310 then '' when ansid=73312 then '' when ansid=73314 then '' when ansid=73316 then '' when ansid=73318 then '' when ansid=73320 then '' when ansid=73322 then '' when ansid=73324 then '' when ansid=73326 then '' when ansid=73328 then '' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:53:00'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE supvisstepid = '4488'"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 10:53:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:53:00' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 10:55:08","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 10:55:12","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:12' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 10:55:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:12' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 10:55:13","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:13' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 10:55:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:13' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '' when ansid=73296 then '' when ansid=73298 then '' when ansid=73300 then '' when ansid=73302 then '' when ansid=73304 then '' when ansid=73306 then '' when ansid=73308 then '' when ansid=73310 then '' when ansid=73312 then '' when ansid=73314 then '' when ansid=73316 then '' when ansid=73318 then '' when ansid=73320 then '' when ansid=73322 then '' when ansid=73324 then '' when ansid=73326 then '' when ansid=73328 then '' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 10:55:08'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE supvisstepid = '4489'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 10:55:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 10:55:08' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 11:38:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('33', '14.139.218.146', '2019-03-26 11:38:50')"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 11:39:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '' when ansid=73296 then '' when ansid=73298 then '' when ansid=73300 then '' when ansid=73302 then '' when ansid=73304 then '' when ansid=73306 then '' when ansid=73308 then '' when ansid=73310 then '' when ansid=73312 then '' when ansid=73314 then '' when ansid=73316 then '' when ansid=73318 then '' when ansid=73320 then '' when ansid=73322 then '' when ansid=73324 then '' when ansid=73326 then '' when ansid=73328 then '' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 11:39:53'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE supvisstepid = '4489'"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 11:39:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:39:53' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '' when ansid=73296 then '' when ansid=73298 then '' when ansid=73300 then '' when ansid=73302 then '' when ansid=73304 then '' when ansid=73306 then '' when ansid=73308 then '' when ansid=73310 then '' when ansid=73312 then '' when ansid=73314 then '' when ansid=73316 then '' when ansid=73318 then '' when ansid=73320 then '' when ansid=73322 then '' when ansid=73324 then '' when ansid=73326 then '' when ansid=73328 then '' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 11:41:00'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 11:41:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE supvisstepid = '4489'"} {"userId":"33","date":"2019-03-26 11:41:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 11:41:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 11:41:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 11:41:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 11:41:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:41:00' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '' when ansid=73322 then '' when ansid=73324 then '' when ansid=73326 then '' when ansid=73328 then '' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 11:42:27'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE supvisstepid = '4490'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 11:42:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:42:27' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '' when ansid=73331 then '' when ansid=73332 then '' when ansid=73333 then '' when ansid=73334 then '' when ansid=73335 then '' when ansid=73336 then '' when ansid=73337 then '' when ansid=73338 then '' when ansid=73339 then '' when ansid=73340 then '' when ansid=73341 then '' when ansid=73342 then '' when ansid=73343 then '' when ansid=73344 then '' when ansid=73345 then '' when ansid=73346 then '' when ansid=73347 then '' when ansid=73348 then '' when ansid=73349 then '' when ansid=73350 then '' when ansid=73351 then '' when ansid=73352 then '' when ansid=73353 then '' when ansid=73354 then '' when ansid=73355 then '' when ansid=73356 then '' when ansid=73357 then '' when ansid=73358 then '' when ansid=73359 then '' when ansid=73360 then '' when ansid=73361 then '' when ansid=73362 then '' when ansid=73363 then '' when ansid=73364 then '' when ansid=73365 then '' when ansid=73366 then '' when ansid=73367 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 11:43:33'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE supvisstepid = '4491'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 11:43:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 11:43:33' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 12:01:42","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '2' when ansid=73331 then '2' when ansid=73332 then '' when ansid=73333 then '1' when ansid=73334 then '' when ansid=73335 then '1' when ansid=73336 then '' when ansid=73337 then '1' when ansid=73338 then '8' when ansid=73339 then '1' when ansid=73340 then 'Counsellor' when ansid=73341 then '1' when ansid=73342 then 'Few issues with completeness' when ansid=73343 then '2' when ansid=73344 then '1' when ansid=73345 then '2' when ansid=73346 then '3' when ansid=73347 then '1' when ansid=73348 then '1' when ansid=73349 then '1' when ansid=73350 then '3' when ansid=73351 then '1' when ansid=73352 then '1' when ansid=73353 then '1' when ansid=73354 then '5' when ansid=73355 then '1' when ansid=73356 then '1' when ansid=73357 then '1' when ansid=73358 then '' when ansid=73359 then '1' when ansid=73360 then '1' when ansid=73361 then '1' when ansid=73362 then '2' when ansid=73363 then '1' when ansid=73364 then '0' when ansid=73365 then '1.Co-operation with inmates. 2. Few logistics like tube racks were not provided and vacutainers were of compromised quality.' when ansid=73366 then 'no..' when ansid=73367 then '1.Few HSS forms were incomplete and inconsistent.2. In consent forms, signature of counsellor were missing in some.3. Samples have not been transported to SRL after February 2019 due to lack of cold space in SRL.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 12:01:42'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE supvisstepid = '4492'"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 12:01:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:01:42' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:46:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('33', '14.139.218.146', '2019-03-26 12:46:01')"} {"userId":"33","date":"2019-03-26 12:46:07","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 12:46:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 12:46:07","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 12:46:07","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 12:46:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '2' when ansid=73331 then '2' when ansid=73332 then '' when ansid=73333 then '1' when ansid=73334 then '' when ansid=73335 then '1' when ansid=73336 then '' when ansid=73337 then '1' when ansid=73338 then '8' when ansid=73339 then '1' when ansid=73340 then 'Counsellor' when ansid=73341 then '1' when ansid=73342 then 'Few issues with completeness' when ansid=73343 then '2' when ansid=73344 then '1' when ansid=73345 then '2' when ansid=73346 then '3' when ansid=73347 then '1' when ansid=73348 then '1' when ansid=73349 then '1' when ansid=73350 then '3' when ansid=73351 then '1' when ansid=73352 then '1' when ansid=73353 then '1' when ansid=73354 then '5' when ansid=73355 then '1' when ansid=73356 then '1' when ansid=73357 then '1' when ansid=73358 then '' when ansid=73359 then '1' when ansid=73360 then '1' when ansid=73361 then '1' when ansid=73362 then '2' when ansid=73363 then '1' when ansid=73364 then '' when ansid=73365 then '1.Co-operation with inmates. 2. Few logistics like tube racks were not provided and vacutainers were of compromised quality.' when ansid=73366 then 'no..' when ansid=73367 then '1.Few HSS forms were incomplete and inconsistent.2. In consent forms, signature of counsellor were missing in some.3. Samples have not been transported to SRL after February 2019 due to lack of cold space in SRL.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 12:46:07'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE supvisstepid = '4491'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:07' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 12:46:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '2' when ansid=73331 then '2' when ansid=73332 then '' when ansid=73333 then '1' when ansid=73334 then '' when ansid=73335 then '1' when ansid=73336 then '' when ansid=73337 then '1' when ansid=73338 then '8' when ansid=73339 then '1' when ansid=73340 then 'Counsellor' when ansid=73341 then '1' when ansid=73342 then 'Few issues with completeness' when ansid=73343 then '2' when ansid=73344 then '1' when ansid=73345 then '2' when ansid=73346 then '3' when ansid=73347 then '1' when ansid=73348 then '1' when ansid=73349 then '1' when ansid=73350 then '3' when ansid=73351 then '1' when ansid=73352 then '1' when ansid=73353 then '1' when ansid=73354 then '5' when ansid=73355 then '1' when ansid=73356 then '1' when ansid=73357 then '1' when ansid=73358 then '' when ansid=73359 then '1' when ansid=73360 then '1' when ansid=73361 then '1' when ansid=73362 then '2' when ansid=73363 then '1' when ansid=73364 then '' when ansid=73365 then '1.Co-operation with inmates. 2. Few logistics like tube racks were not provided and vacutainers were of compromised quality.' when ansid=73366 then 'no..' when ansid=73367 then '1.Few HSS forms were incomplete and inconsistent.2. In consent forms, signature of counsellor were missing in some.3. Samples have not been transported to SRL after February 2019 due to lack of cold space in SRL.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 12:46:08'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE supvisstepid = '4489'"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 12:46:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:08' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 12:46:17","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '2' when ansid=73331 then '2' when ansid=73332 then '' when ansid=73333 then '1' when ansid=73334 then '' when ansid=73335 then '1' when ansid=73336 then '' when ansid=73337 then '1' when ansid=73338 then '8' when ansid=73339 then '1' when ansid=73340 then 'Counsellor' when ansid=73341 then '1' when ansid=73342 then 'Few issues with completeness' when ansid=73343 then '2' when ansid=73344 then '1' when ansid=73345 then '2' when ansid=73346 then '3' when ansid=73347 then '1' when ansid=73348 then '1' when ansid=73349 then '1' when ansid=73350 then '3' when ansid=73351 then '1' when ansid=73352 then '1' when ansid=73353 then '1' when ansid=73354 then '5' when ansid=73355 then '1' when ansid=73356 then '1' when ansid=73357 then '1' when ansid=73358 then '' when ansid=73359 then '1' when ansid=73360 then '1' when ansid=73361 then '1' when ansid=73362 then '2' when ansid=73363 then '1' when ansid=73364 then '00' when ansid=73365 then '1.Co-operation with inmates. 2. Few logistics like tube racks were not provided and vacutainers were of compromised quality.' when ansid=73366 then 'no..' when ansid=73367 then '1.Few HSS forms were incomplete and inconsistent.2. In consent forms, signature of counsellor were missing in some.3. Samples have not been transported to SRL after February 2019 due to lack of cold space in SRL.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 12:46:17'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE supvisstepid = '4492'"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 12:46:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:46:17' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE sitesupervision SET `siteid` = '1065', `userid` = '33', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-15', `numofsamplecollected` = '71', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1482', `undertrialprisoners` = '1580', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '699'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Harish', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE onssid = '3124'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. RK Lal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE onssid = '3125'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Abhay Mishra', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE onssid = '3126'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE onssid = '3127'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73274 then '3' when ansid=73276 then '0' when ansid=73278 then '450' when ansid=73280 then '25' when ansid=73282 then '25' when ansid=73284 then '1' when ansid=73286 then '450' when ansid=73288 then '1' when ansid=73290 then '1' when ansid=73292 then '1' when ansid=73294 then '2' when ansid=73296 then '450' when ansid=73298 then '0' when ansid=73300 then '450' when ansid=73302 then '4' when ansid=73304 then '1' when ansid=73306 then '450' when ansid=73308 then '450' when ansid=73310 then '500' when ansid=73312 then '2' when ansid=73314 then '0' when ansid=73316 then '1' when ansid=73318 then '1' when ansid=73320 then '0' when ansid=73322 then '1' when ansid=73324 then '1' when ansid=73326 then '3' when ansid=73328 then '1' when ansid=73330 then '2' when ansid=73331 then '2' when ansid=73332 then '' when ansid=73333 then '1' when ansid=73334 then '' when ansid=73335 then '1' when ansid=73336 then '' when ansid=73337 then '1' when ansid=73338 then '8' when ansid=73339 then '1' when ansid=73340 then 'Counsellor' when ansid=73341 then '1' when ansid=73342 then 'Few issues with completeness' when ansid=73343 then '2' when ansid=73344 then '1' when ansid=73345 then '2' when ansid=73346 then '3' when ansid=73347 then '1' when ansid=73348 then '1' when ansid=73349 then '1' when ansid=73350 then '3' when ansid=73351 then '1' when ansid=73352 then '1' when ansid=73353 then '1' when ansid=73354 then '5' when ansid=73355 then '1' when ansid=73356 then '1' when ansid=73357 then '1' when ansid=73358 then '' when ansid=73359 then '1' when ansid=73360 then '1' when ansid=73361 then '1' when ansid=73362 then '2' when ansid=73363 then '1' when ansid=73364 then '00' when ansid=73365 then '1.Co-operation with inmates. 2. Few logistics like tube racks were not provided and vacutainers were of compromised quality.' when ansid=73366 then 'no..' when ansid=73367 then '1.Few HSS forms were incomplete and inconsistent.2. In consent forms, signature of counsellor were missing in some.3. Samples have not been transported to SRL after February 2019 due to lack of cold space in SRL.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 12:55:46'\n\t\t\t\t\t\t\tWHERE ansid in ('73274','73276','73278','73280','73282','73284','73286','73288','73290','73292','73294','73296','73298','73300','73302','73304','73306','73308','73310','73312','73314','73316','73318','73320','73322','73324','73326','73328','73330','73331','73332','73333','73334','73335','73336','73337','73338','73339','73340','73341','73342','73343','73344','73345','73346','73347','73348','73349','73350','73351','73352','73353','73354','73355','73356','73357','73358','73359','73360','73361','73362','73363','73364','73365','73366','73367')"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE supvisstepid = '4493'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE visitfeedback SET `feedback` = 'Few HSS forms were inconsistent and incomplete for which on site training was given and correction was done.', `recommendation` = 'In HSS register, date column should be added.', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE visitfeedbackid = '3276'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE visitfeedback SET `feedback` = 'Few issues were with HSS register which was also corrected on the spot.', `recommendation` = 'Repeat visit should be made to note the compliance of previous visit.', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE visitfeedbackid = '3277'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE visitfeedback SET `feedback` = 'Samples were asked to dispatch at the earliest.', `recommendation` = 'Logistics should be purchased of good quality to meet the expectations of the project.', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE visitfeedbackid = '3278'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE visitfeedback SET `feedback` = 'In few consent forms, Signature of Counsellor was missing which was rectified.', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE visitfeedbackid = '3279'"} {"userId":"33","date":"2019-03-26 12:55:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 12:55:46' WHERE visitfeedbackid = '3280'"} {"userId":"33","date":"2019-03-26 12:56:43","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('329', '2019-03-15', '33', '14.139.218.146', '33', '2019-03-26 12:56:43')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('329', '881', '33', '2019-03-26', '1', '14.139.218.146', '33', '2019-03-26 12:56:47', '', '')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '0', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '1', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '2', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '3', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '4', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '5', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('700', '6', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('700', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('700', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('700', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('700', '', '', 'Array', '', 'Array', '', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:54","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:56:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 12:57:11","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('700', '14.139.218.146', '33', '2019-03-26 12:56:47')"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:01:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '' when ansid=73369 then '' when ansid=73370 then '' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '' when ansid=73375 then '' when ansid=73377 then '' when ansid=73379 then '' when ansid=73381 then '' when ansid=73383 then '' when ansid=73385 then '' when ansid=73387 then '' when ansid=73389 then '' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:01:46'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE supvisstepid = '4494'"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:01:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:01:46' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '' when ansid=73377 then '' when ansid=73379 then '' when ansid=73381 then '' when ansid=73383 then '' when ansid=73385 then '' when ansid=73387 then '' when ansid=73389 then '' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:02:46'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE supvisstepid = '4495'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:02:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:02:46' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:41:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('33', '14.139.218.146', '2019-03-26 13:41:29')"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '' when ansid=73377 then '' when ansid=73379 then '' when ansid=73381 then '' when ansid=73383 then '' when ansid=73385 then '' when ansid=73387 then '' when ansid=73389 then '' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:41:51'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE supvisstepid = '4495'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:41:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:41:51' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '' when ansid=73377 then '' when ansid=73379 then '' when ansid=73381 then '' when ansid=73383 then '' when ansid=73385 then '' when ansid=73387 then '' when ansid=73389 then '' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:42:06'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE supvisstepid = '4494'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:42:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:06' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:42:10","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '' when ansid=73377 then '' when ansid=73379 then '' when ansid=73381 then '' when ansid=73383 then '' when ansid=73385 then '' when ansid=73387 then '' when ansid=73389 then '' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:42:10'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE supvisstepid = '4495'"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:42:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:10' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '3' when ansid=73377 then '1' when ansid=73379 then '450' when ansid=73381 then '30' when ansid=73383 then '30' when ansid=73385 then '1' when ansid=73387 then '1' when ansid=73389 then '1' when ansid=73391 then '' when ansid=73393 then '' when ansid=73395 then '' when ansid=73397 then '' when ansid=73399 then '' when ansid=73401 then '' when ansid=73403 then '' when ansid=73405 then '' when ansid=73407 then '' when ansid=73409 then '' when ansid=73411 then '' when ansid=73413 then '' when ansid=73415 then '' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:42:51'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE supvisstepid = '4496'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:42:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:42:51' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '3' when ansid=73377 then '1' when ansid=73379 then '450' when ansid=73381 then '30' when ansid=73383 then '30' when ansid=73385 then '1' when ansid=73387 then '1' when ansid=73389 then '1' when ansid=73391 then '2' when ansid=73393 then '450' when ansid=73395 then '0' when ansid=73397 then '450' when ansid=73399 then '09' when ansid=73401 then '1' when ansid=73403 then '450' when ansid=73405 then '450' when ansid=73407 then '500' when ansid=73409 then '2' when ansid=73411 then '5' when ansid=73413 then '1' when ansid=73415 then '5' when ansid=73417 then '' when ansid=73419 then '' when ansid=73421 then '' when ansid=73423 then '' when ansid=73425 then '' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:43:44'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE supvisstepid = '4497'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:43:44","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:43:44' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:44:07","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '3' when ansid=73377 then '1' when ansid=73379 then '450' when ansid=73381 then '30' when ansid=73383 then '30' when ansid=73385 then '1' when ansid=73387 then '1' when ansid=73389 then '1' when ansid=73391 then '2' when ansid=73393 then '450' when ansid=73395 then '0' when ansid=73397 then '450' when ansid=73399 then '09' when ansid=73401 then '1' when ansid=73403 then '450' when ansid=73405 then '450' when ansid=73407 then '500' when ansid=73409 then '2' when ansid=73411 then '5' when ansid=73413 then '1' when ansid=73415 then '5' when ansid=73417 then '1' when ansid=73419 then '0' when ansid=73421 then '0' when ansid=73423 then '0' when ansid=73425 then '1' when ansid=73427 then '' when ansid=73428 then '' when ansid=73429 then '' when ansid=73430 then '' when ansid=73431 then '' when ansid=73432 then '' when ansid=73433 then '' when ansid=73434 then '' when ansid=73435 then '' when ansid=73436 then '' when ansid=73437 then '' when ansid=73438 then '' when ansid=73439 then '' when ansid=73440 then '' when ansid=73441 then '' when ansid=73442 then '' when ansid=73443 then '' when ansid=73444 then '' when ansid=73445 then '' when ansid=73446 then '' when ansid=73447 then '' when ansid=73448 then '' when ansid=73449 then '' when ansid=73450 then '' when ansid=73451 then '' when ansid=73452 then '' when ansid=73453 then '' when ansid=73454 then '' when ansid=73455 then '' when ansid=73456 then '' when ansid=73457 then '' when ansid=73458 then '' when ansid=73459 then '' when ansid=73460 then '' when ansid=73461 then '' when ansid=73462 then '' when ansid=73463 then '' when ansid=73464 then '' when ansid=73465 then '' when ansid=73466 then '' when ansid=73467 then '' when ansid=73468 then '' when ansid=73469 then '' when ansid=73470 then '' when ansid=73471 then '' when ansid=73472 then '' when ansid=73473 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:44:07'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE supvisstepid = '4498'"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:44:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:44:07' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '3' when ansid=73377 then '1' when ansid=73379 then '450' when ansid=73381 then '30' when ansid=73383 then '30' when ansid=73385 then '1' when ansid=73387 then '1' when ansid=73389 then '1' when ansid=73391 then '2' when ansid=73393 then '450' when ansid=73395 then '0' when ansid=73397 then '450' when ansid=73399 then '09' when ansid=73401 then '1' when ansid=73403 then '450' when ansid=73405 then '450' when ansid=73407 then '500' when ansid=73409 then '2' when ansid=73411 then '5' when ansid=73413 then '1' when ansid=73415 then '5' when ansid=73417 then '1' when ansid=73419 then '0' when ansid=73421 then '0' when ansid=73423 then '0' when ansid=73425 then '1' when ansid=73427 then '4' when ansid=73428 then '4' when ansid=73429 then '3583' when ansid=73430 then '450' when ansid=73431 then '' when ansid=73432 then '1' when ansid=73433 then '1' when ansid=73434 then '' when ansid=73435 then '1' when ansid=73436 then '' when ansid=73437 then '1' when ansid=73438 then '14' when ansid=73439 then '1' when ansid=73440 then '1' when ansid=73441 then 'Counsellor' when ansid=73442 then '1' when ansid=73443 then '' when ansid=73444 then '1' when ansid=73445 then '1' when ansid=73446 then 'Few issues' when ansid=73447 then '2' when ansid=73448 then '1' when ansid=73449 then '1' when ansid=73450 then '1' when ansid=73451 then '1' when ansid=73452 then '1' when ansid=73453 then '2' when ansid=73454 then '1' when ansid=73455 then '1' when ansid=73456 then '1' when ansid=73457 then '' when ansid=73458 then '3' when ansid=73459 then '' when ansid=73460 then '1' when ansid=73461 then '1' when ansid=73462 then '2' when ansid=73463 then 'Not in practice' when ansid=73464 then '2' when ansid=73465 then '2' when ansid=73466 then '1' when ansid=73467 then '1' when ansid=73468 then '1' when ansid=73469 then '00' when ansid=73470 then 'Logistics were not of satisfactory quality eg vacutainer' when ansid=73471 then 'No' when ansid=73472 then 'Few issues with HSS register , corrected onsite. BMW management was not proper, onsite training was given.' when ansid=73473 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:49:29'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE supvisstepid = '4499'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:49:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:49:29' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE sitesupervision SET `siteid` = '329', `userid` = '33', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-01-11', `numofsamplecollected` = '375', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38', `locationtype` = '1', `establishmentyear` = '2004', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '700'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shashi Bala Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '6', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE onssid = '3128'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE onsitestaffs SET `staffname` = 'Rashmi Kumari', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE onssid = '3129'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE onsitestaffs SET `staffname` = 'Sweety Minz', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE onssid = '3130'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE onssid = '3131'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=73368 then '1' when ansid=73369 then '1' when ansid=73370 then '1' when ansid=73371 then '' when ansid=73372 then '' when ansid=73373 then '' when ansid=73374 then '1' when ansid=73375 then '3' when ansid=73377 then '1' when ansid=73379 then '450' when ansid=73381 then '30' when ansid=73383 then '30' when ansid=73385 then '1' when ansid=73387 then '1' when ansid=73389 then '1' when ansid=73391 then '2' when ansid=73393 then '450' when ansid=73395 then '0' when ansid=73397 then '450' when ansid=73399 then '09' when ansid=73401 then '1' when ansid=73403 then '450' when ansid=73405 then '450' when ansid=73407 then '500' when ansid=73409 then '2' when ansid=73411 then '5' when ansid=73413 then '1' when ansid=73415 then '5' when ansid=73417 then '1' when ansid=73419 then '0' when ansid=73421 then '0' when ansid=73423 then '0' when ansid=73425 then '1' when ansid=73427 then '4' when ansid=73428 then '4' when ansid=73429 then '3583' when ansid=73430 then '450' when ansid=73431 then '' when ansid=73432 then '1' when ansid=73433 then '1' when ansid=73434 then '' when ansid=73435 then '1' when ansid=73436 then '' when ansid=73437 then '1' when ansid=73438 then '14' when ansid=73439 then '1' when ansid=73440 then '1' when ansid=73441 then 'Counsellor' when ansid=73442 then '1' when ansid=73443 then '' when ansid=73444 then '1' when ansid=73445 then '1' when ansid=73446 then 'Few issues' when ansid=73447 then '2' when ansid=73448 then '1' when ansid=73449 then '1' when ansid=73450 then '1' when ansid=73451 then '1' when ansid=73452 then '1' when ansid=73453 then '2' when ansid=73454 then '1' when ansid=73455 then '1' when ansid=73456 then '1' when ansid=73457 then '' when ansid=73458 then '3' when ansid=73459 then '' when ansid=73460 then '1' when ansid=73461 then '1' when ansid=73462 then '2' when ansid=73463 then 'Not in practice' when ansid=73464 then '2' when ansid=73465 then '2' when ansid=73466 then '1' when ansid=73467 then '1' when ansid=73468 then '1' when ansid=73469 then '00' when ansid=73470 then 'Logistics were not of satisfactory quality eg vacutainer' when ansid=73471 then 'No' when ansid=73472 then 'Few issues with HSS register , corrected onsite. BMW management was not proper, onsite training was given.' when ansid=73473 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.218.146',\n\t\t\t\t\t\t\t\tmodifiedby =33,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-03-26 13:50:38'\n\t\t\t\t\t\t\tWHERE ansid in ('73368','73369','73370','73371','73372','73373','73374','73375','73377','73379','73381','73383','73385','73387','73389','73391','73393','73395','73397','73399','73401','73403','73405','73407','73409','73411','73413','73415','73417','73419','73421','73423','73425','73427','73428','73429','73430','73431','73432','73433','73434','73435','73436','73437','73438','73439','73440','73441','73442','73443','73444','73445','73446','73447','73448','73449','73450','73451','73452','73453','73454','73455','73456','73457','73458','73459','73460','73461','73462','73463','73464','73465','73466','73467','73468','73469','73470','73471','73472','73473')"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE supvisstepid = '4500'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE visitfeedback SET `feedback` = 'BMW training was given as it was not practiced ideally.', `recommendation` = 'Logistics should be purchased of good quality to meet the expectations of the project.', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE visitfeedbackid = '3281'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE visitfeedback SET `feedback` = 'Few issues with HSS register which was resolved onsite.', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE visitfeedbackid = '3282'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE visitfeedbackid = '3283'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE visitfeedbackid = '3284'"} {"userId":"33","date":"2019-03-26 13:50:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.218.146', `modifiedby` = '33', `modifieddate` = '2019-03-26 13:50:38' WHERE visitfeedbackid = '3285'"} {"userId":"33","date":"2019-03-26 13:51:49","query":"INSERT INTO actiontakenmst (ssid, atrdate, userid, ipaddress, createdby, createddate) VALUES ('700', '2019-03-26', '33', '14.139.218.146', '33', '2019-03-26 13:51:49')"} {"userId":"33","date":"2019-03-26 13:51:49","query":"INSERT INTO visitactiontaken (actionid, visitfeedbackid, atr, ipaddress, createdby, createddate) VALUES ('6', '3281', '', '14.139.218.146', '33', '2019-03-26 13:51:49')"}