{"userId":"520","date":"2022-11-24 07:01:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('520', '122.179.101.3', '2022-11-24 07:01:33')"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2418'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE onssid = '10000'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE onssid = '10001'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE onssid = '10002'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE onssid = '10003'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224137 then '' when ansid=224138 then '' when ansid=224139 then '' when ansid=224140 then '' when ansid=224141 then '' when ansid=224142 then '' when ansid=224143 then '' when ansid=224186 then '' when ansid=224188 then '' when ansid=224190 then '' when ansid=224192 then '' when ansid=224194 then '' when ansid=224196 then '' when ansid=224197 then '' when ansid=224198 then '' when ansid=224199 then '' when ansid=224200 then '' when ansid=224201 then '' when ansid=224202 then '' when ansid=224203 then '' when ansid=224204 then '' when ansid=224205 then '' when ansid=224206 then '' when ansid=224207 then '' when ansid=224208 then '' when ansid=224209 then '' when ansid=224210 then '' when ansid=224211 then '' when ansid=224212 then '' when ansid=224213 then '' when ansid=224214 then '' when ansid=224215 then '' when ansid=224216 then '' when ansid=224217 then '' when ansid=224218 then '' when ansid=224219 then '' when ansid=224220 then '' when ansid=224221 then '' when ansid=224222 then '' when ansid=224223 then '' when ansid=224224 then '' when ansid=224225 then '' when ansid=224226 then '' when ansid=224227 then '' when ansid=224228 then '' when ansid=224229 then '' when ansid=224230 then '' when ansid=224231 then '' when ansid=224232 then '' when ansid=224233 then '' when ansid=224234 then '' when ansid=224235 then '' when ansid=224236 then '' when ansid=224237 then '' when ansid=224238 then '' when ansid=224239 then '' when ansid=224240 then '' when ansid=224241 then '' when ansid=224242 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:02:22'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE supvisstepid = '11970'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE visitfeedbackid = '11866'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE visitfeedbackid = '11867'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE visitfeedbackid = '11868'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE visitfeedbackid = '11869'"} {"userId":"520","date":"2022-11-24 07:02:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:22' WHERE visitfeedbackid = '11870'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2418'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE onssid = '10000'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE onssid = '10001'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE onssid = '10002'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE onssid = '10003'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224137 then '1' when ansid=224138 then '1' when ansid=224139 then '1' when ansid=224140 then '' when ansid=224141 then '' when ansid=224142 then '' when ansid=224143 then '2' when ansid=224186 then '' when ansid=224188 then '' when ansid=224190 then '' when ansid=224192 then '' when ansid=224194 then '' when ansid=224196 then '' when ansid=224197 then '' when ansid=224198 then '' when ansid=224199 then '' when ansid=224200 then '' when ansid=224201 then '' when ansid=224202 then '' when ansid=224203 then '' when ansid=224204 then '' when ansid=224205 then '' when ansid=224206 then '' when ansid=224207 then '' when ansid=224208 then '' when ansid=224209 then '' when ansid=224210 then '' when ansid=224211 then '' when ansid=224212 then '' when ansid=224213 then '' when ansid=224214 then '' when ansid=224215 then '' when ansid=224216 then '' when ansid=224217 then '' when ansid=224218 then '' when ansid=224219 then '' when ansid=224220 then '' when ansid=224221 then '' when ansid=224222 then '' when ansid=224223 then '' when ansid=224224 then '' when ansid=224225 then '' when ansid=224226 then '' when ansid=224227 then '' when ansid=224228 then '' when ansid=224229 then '' when ansid=224230 then '' when ansid=224231 then '' when ansid=224232 then '' when ansid=224233 then '' when ansid=224234 then '' when ansid=224235 then '' when ansid=224236 then '' when ansid=224237 then '' when ansid=224238 then '' when ansid=224239 then '' when ansid=224240 then '' when ansid=224241 then '' when ansid=224242 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:02:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE supvisstepid = '11971'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE visitfeedbackid = '11866'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE visitfeedbackid = '11867'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE visitfeedbackid = '11868'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE visitfeedbackid = '11869'"} {"userId":"520","date":"2022-11-24 07:02:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:39' WHERE visitfeedbackid = '11870'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2418'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE onssid = '10000'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE onssid = '10001'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE onssid = '10002'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE onssid = '10003'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224137 then '1' when ansid=224138 then '1' when ansid=224139 then '1' when ansid=224140 then '' when ansid=224141 then '' when ansid=224142 then '' when ansid=224143 then '2' when ansid=224186 then '10' when ansid=224188 then '1' when ansid=224190 then '2' when ansid=224192 then '34' when ansid=224194 then '5' when ansid=224196 then '' when ansid=224197 then '' when ansid=224198 then '' when ansid=224199 then '' when ansid=224200 then '' when ansid=224201 then '' when ansid=224202 then '' when ansid=224203 then '' when ansid=224204 then '' when ansid=224205 then '' when ansid=224206 then '' when ansid=224207 then '' when ansid=224208 then '' when ansid=224209 then '' when ansid=224210 then '' when ansid=224211 then '' when ansid=224212 then '' when ansid=224213 then '' when ansid=224214 then '' when ansid=224215 then '' when ansid=224216 then '' when ansid=224217 then '' when ansid=224218 then '' when ansid=224219 then '' when ansid=224220 then '' when ansid=224221 then '' when ansid=224222 then '' when ansid=224223 then '' when ansid=224224 then '' when ansid=224225 then '' when ansid=224226 then '' when ansid=224227 then '' when ansid=224228 then '' when ansid=224229 then '' when ansid=224230 then '' when ansid=224231 then '' when ansid=224232 then '' when ansid=224233 then '' when ansid=224234 then '' when ansid=224235 then '' when ansid=224236 then '' when ansid=224237 then '' when ansid=224238 then '' when ansid=224239 then '' when ansid=224240 then '' when ansid=224241 then '' when ansid=224242 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:02:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE supvisstepid = '11972'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE visitfeedbackid = '11866'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE visitfeedbackid = '11867'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE visitfeedbackid = '11868'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE visitfeedbackid = '11869'"} {"userId":"520","date":"2022-11-24 07:02:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:02:59' WHERE visitfeedbackid = '11870'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2418'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE onssid = '10000'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE onssid = '10001'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE onssid = '10002'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE onssid = '10003'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224137 then '1' when ansid=224138 then '1' when ansid=224139 then '1' when ansid=224140 then '' when ansid=224141 then '' when ansid=224142 then '' when ansid=224143 then '2' when ansid=224186 then '10' when ansid=224188 then '1' when ansid=224190 then '2' when ansid=224192 then '34' when ansid=224194 then '5' when ansid=224196 then '100' when ansid=224197 then '100' when ansid=224198 then '120' when ansid=224199 then '5' when ansid=224200 then '' when ansid=224201 then '1' when ansid=224202 then '1' when ansid=224203 then '' when ansid=224204 then '1' when ansid=224205 then '' when ansid=224206 then '1' when ansid=224207 then '120' when ansid=224208 then '1' when ansid=224209 then '1' when ansid=224210 then 'Counsellor' when ansid=224211 then '1' when ansid=224212 then '' when ansid=224213 then '1' when ansid=224214 then '1' when ansid=224215 then '' when ansid=224216 then '1' when ansid=224217 then '2' when ansid=224218 then '1' when ansid=224219 then '1' when ansid=224220 then '1' when ansid=224221 then '2' when ansid=224222 then '2' when ansid=224223 then '1' when ansid=224224 then '1' when ansid=224225 then '1' when ansid=224226 then '' when ansid=224227 then '1' when ansid=224228 then '' when ansid=224229 then '1' when ansid=224230 then '1' when ansid=224231 then '1' when ansid=224232 then '' when ansid=224233 then '1' when ansid=224234 then '1' when ansid=224235 then '1' when ansid=224236 then '2' when ansid=224237 then '1' when ansid=224238 then '2' when ansid=224239 then 'No' when ansid=224240 then 'No' when ansid=224241 then 'No' when ansid=224242 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:04:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE supvisstepid = '11973'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE visitfeedbackid = '11866'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE visitfeedbackid = '11867'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE visitfeedbackid = '11868'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE visitfeedbackid = '11869'"} {"userId":"520","date":"2022-11-24 07:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:04:59' WHERE visitfeedbackid = '11870'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-21', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2418'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Garima', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = 'yes', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE onssid = '10000'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE onssid = '10001'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE onssid = '10002'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE onssid = '10003'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224137 then '1' when ansid=224138 then '1' when ansid=224139 then '1' when ansid=224140 then '' when ansid=224141 then '' when ansid=224142 then '' when ansid=224143 then '2' when ansid=224186 then '10' when ansid=224188 then '1' when ansid=224190 then '2' when ansid=224192 then '34' when ansid=224194 then '5' when ansid=224196 then '100' when ansid=224197 then '100' when ansid=224198 then '120' when ansid=224199 then '5' when ansid=224200 then '' when ansid=224201 then '1' when ansid=224202 then '1' when ansid=224203 then '' when ansid=224204 then '1' when ansid=224205 then '' when ansid=224206 then '1' when ansid=224207 then '120' when ansid=224208 then '1' when ansid=224209 then '1' when ansid=224210 then 'Counsellor' when ansid=224211 then '1' when ansid=224212 then '' when ansid=224213 then '1' when ansid=224214 then '1' when ansid=224215 then '' when ansid=224216 then '1' when ansid=224217 then '2' when ansid=224218 then '1' when ansid=224219 then '1' when ansid=224220 then '1' when ansid=224221 then '2' when ansid=224222 then '2' when ansid=224223 then '1' when ansid=224224 then '1' when ansid=224225 then '1' when ansid=224226 then '' when ansid=224227 then '1' when ansid=224228 then '' when ansid=224229 then '1' when ansid=224230 then '1' when ansid=224231 then '1' when ansid=224232 then '' when ansid=224233 then '1' when ansid=224234 then '1' when ansid=224235 then '1' when ansid=224236 then '2' when ansid=224237 then '1' when ansid=224238 then '2' when ansid=224239 then 'No' when ansid=224240 then 'No' when ansid=224241 then 'No' when ansid=224242 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:05:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224137','224138','224139','224140','224141','224142','224143','224186','224188','224190','224192','224194','224196','224197','224198','224199','224200','224201','224202','224203','224204','224205','224206','224207','224208','224209','224210','224211','224212','224213','224214','224215','224216','224217','224218','224219','224220','224221','224222','224223','224224','224225','224226','224227','224228','224229','224230','224231','224232','224233','224234','224235','224236','224237','224238','224239','224240','224241','224242')"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE supvisstepid = '11974'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE visitfeedback SET `feedback` = 'No feedbacks', `recommendation` = 'No recommendations', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE visitfeedbackid = '11866'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE visitfeedbackid = '11867'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE visitfeedbackid = '11868'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE visitfeedbackid = '11869'"} {"userId":"520","date":"2022-11-24 07:05:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:05:28' WHERE visitfeedbackid = '11870'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '' when ansid=224244 then '' when ansid=224245 then '' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '' when ansid=224292 then '' when ansid=224294 then '' when ansid=224296 then '' when ansid=224298 then '' when ansid=224300 then '' when ansid=224302 then '' when ansid=224303 then '' when ansid=224304 then '' when ansid=224305 then '' when ansid=224306 then '' when ansid=224307 then '' when ansid=224308 then '' when ansid=224309 then '' when ansid=224310 then '' when ansid=224311 then '' when ansid=224312 then '' when ansid=224313 then '' when ansid=224314 then '' when ansid=224315 then '' when ansid=224316 then '' when ansid=224317 then '' when ansid=224318 then '' when ansid=224319 then '' when ansid=224320 then '' when ansid=224321 then '' when ansid=224322 then '' when ansid=224323 then '' when ansid=224324 then '' when ansid=224325 then '' when ansid=224326 then '' when ansid=224327 then '' when ansid=224328 then '' when ansid=224329 then '' when ansid=224330 then '' when ansid=224331 then '' when ansid=224332 then '' when ansid=224333 then '' when ansid=224334 then '' when ansid=224335 then '' when ansid=224336 then '' when ansid=224337 then '' when ansid=224338 then '' when ansid=224339 then '' when ansid=224340 then '' when ansid=224341 then '' when ansid=224342 then '' when ansid=224343 then '' when ansid=224344 then '' when ansid=224345 then '' when ansid=224346 then '' when ansid=224347 then '' when ansid=224348 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:07:13'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE supvisstepid = '11975'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:07:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:07:13' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '' when ansid=224244 then '' when ansid=224245 then '' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '' when ansid=224292 then '' when ansid=224294 then '' when ansid=224296 then '' when ansid=224298 then '' when ansid=224300 then '' when ansid=224302 then '' when ansid=224303 then '' when ansid=224304 then '' when ansid=224305 then '' when ansid=224306 then '' when ansid=224307 then '' when ansid=224308 then '' when ansid=224309 then '' when ansid=224310 then '' when ansid=224311 then '' when ansid=224312 then '' when ansid=224313 then '' when ansid=224314 then '' when ansid=224315 then '' when ansid=224316 then '' when ansid=224317 then '' when ansid=224318 then '' when ansid=224319 then '' when ansid=224320 then '' when ansid=224321 then '' when ansid=224322 then '' when ansid=224323 then '' when ansid=224324 then '' when ansid=224325 then '' when ansid=224326 then '' when ansid=224327 then '' when ansid=224328 then '' when ansid=224329 then '' when ansid=224330 then '' when ansid=224331 then '' when ansid=224332 then '' when ansid=224333 then '' when ansid=224334 then '' when ansid=224335 then '' when ansid=224336 then '' when ansid=224337 then '' when ansid=224338 then '' when ansid=224339 then '' when ansid=224340 then '' when ansid=224341 then '' when ansid=224342 then '' when ansid=224343 then '' when ansid=224344 then '' when ansid=224345 then '' when ansid=224346 then '' when ansid=224347 then '' when ansid=224348 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:08:37'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE supvisstepid = '11975'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:08:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:37' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '1' when ansid=224244 then '1' when ansid=224245 then '1' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '2' when ansid=224292 then '' when ansid=224294 then '' when ansid=224296 then '' when ansid=224298 then '' when ansid=224300 then '' when ansid=224302 then '' when ansid=224303 then '' when ansid=224304 then '' when ansid=224305 then '' when ansid=224306 then '' when ansid=224307 then '' when ansid=224308 then '' when ansid=224309 then '' when ansid=224310 then '' when ansid=224311 then '' when ansid=224312 then '' when ansid=224313 then '' when ansid=224314 then '' when ansid=224315 then '' when ansid=224316 then '' when ansid=224317 then '' when ansid=224318 then '' when ansid=224319 then '' when ansid=224320 then '' when ansid=224321 then '' when ansid=224322 then '' when ansid=224323 then '' when ansid=224324 then '' when ansid=224325 then '' when ansid=224326 then '' when ansid=224327 then '' when ansid=224328 then '' when ansid=224329 then '' when ansid=224330 then '' when ansid=224331 then '' when ansid=224332 then '' when ansid=224333 then '' when ansid=224334 then '' when ansid=224335 then '' when ansid=224336 then '' when ansid=224337 then '' when ansid=224338 then '' when ansid=224339 then '' when ansid=224340 then '' when ansid=224341 then '' when ansid=224342 then '' when ansid=224343 then '' when ansid=224344 then '' when ansid=224345 then '' when ansid=224346 then '' when ansid=224347 then '' when ansid=224348 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:08:50'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE supvisstepid = '11976'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:08:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:50' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '1' when ansid=224244 then '1' when ansid=224245 then '1' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '2' when ansid=224292 then '1' when ansid=224294 then '1' when ansid=224296 then '1' when ansid=224298 then '1' when ansid=224300 then '1' when ansid=224302 then '' when ansid=224303 then '' when ansid=224304 then '' when ansid=224305 then '' when ansid=224306 then '' when ansid=224307 then '' when ansid=224308 then '' when ansid=224309 then '' when ansid=224310 then '' when ansid=224311 then '' when ansid=224312 then '' when ansid=224313 then '' when ansid=224314 then '' when ansid=224315 then '' when ansid=224316 then '' when ansid=224317 then '' when ansid=224318 then '' when ansid=224319 then '' when ansid=224320 then '' when ansid=224321 then '' when ansid=224322 then '' when ansid=224323 then '' when ansid=224324 then '' when ansid=224325 then '' when ansid=224326 then '' when ansid=224327 then '' when ansid=224328 then '' when ansid=224329 then '' when ansid=224330 then '' when ansid=224331 then '' when ansid=224332 then '' when ansid=224333 then '' when ansid=224334 then '' when ansid=224335 then '' when ansid=224336 then '' when ansid=224337 then '' when ansid=224338 then '' when ansid=224339 then '' when ansid=224340 then '' when ansid=224341 then '' when ansid=224342 then '' when ansid=224343 then '' when ansid=224344 then '' when ansid=224345 then '' when ansid=224346 then '' when ansid=224347 then '' when ansid=224348 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:08:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE supvisstepid = '11977'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:08:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:08:58' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '1' when ansid=224244 then '1' when ansid=224245 then '1' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '2' when ansid=224292 then '1' when ansid=224294 then '1' when ansid=224296 then '1' when ansid=224298 then '1' when ansid=224300 then '1' when ansid=224302 then '12' when ansid=224303 then '12' when ansid=224304 then '12' when ansid=224305 then '12' when ansid=224306 then '' when ansid=224307 then '1' when ansid=224308 then '1' when ansid=224309 then '' when ansid=224310 then '1' when ansid=224311 then '' when ansid=224312 then '1' when ansid=224313 then '2' when ansid=224314 then '1' when ansid=224315 then '1' when ansid=224316 then '' when ansid=224317 then '1' when ansid=224318 then '' when ansid=224319 then '1' when ansid=224320 then '1' when ansid=224321 then '' when ansid=224322 then '1' when ansid=224323 then '1' when ansid=224324 then '1' when ansid=224325 then '1' when ansid=224326 then '1' when ansid=224327 then '2' when ansid=224328 then '1' when ansid=224329 then '1' when ansid=224330 then '1' when ansid=224331 then '1' when ansid=224332 then '' when ansid=224333 then '1' when ansid=224334 then '' when ansid=224335 then '1' when ansid=224336 then '1' when ansid=224337 then '1' when ansid=224338 then '' when ansid=224339 then '1' when ansid=224340 then '1' when ansid=224341 then '1' when ansid=224342 then '2' when ansid=224343 then '1' when ansid=224344 then '12' when ansid=224345 then 'no' when ansid=224346 then 'no' when ansid=224347 then 'no' when ansid=224348 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:10:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE supvisstepid = '11978'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:10:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:24' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE sitesupervision SET `siteid` = '475', `userid` = '520', `ancservicedays` = '1', `samplecollectiondays` = '1', `samplecollectionstartdate` = '2022-11-23', `numofsamplecollected` = '100', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2419'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Ajay', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'No remarks', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE onssid = '10004'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE onssid = '10005'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE onssid = '10006'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE onssid = '10007'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224243 then '1' when ansid=224244 then '1' when ansid=224245 then '1' when ansid=224246 then '' when ansid=224247 then '' when ansid=224248 then '' when ansid=224249 then '2' when ansid=224292 then '1' when ansid=224294 then '1' when ansid=224296 then '1' when ansid=224298 then '1' when ansid=224300 then '1' when ansid=224302 then '12' when ansid=224303 then '12' when ansid=224304 then '12' when ansid=224305 then '12' when ansid=224306 then '' when ansid=224307 then '1' when ansid=224308 then '1' when ansid=224309 then '' when ansid=224310 then '1' when ansid=224311 then '' when ansid=224312 then '1' when ansid=224313 then '2' when ansid=224314 then '1' when ansid=224315 then '1' when ansid=224316 then '' when ansid=224317 then '1' when ansid=224318 then '' when ansid=224319 then '1' when ansid=224320 then '1' when ansid=224321 then '' when ansid=224322 then '1' when ansid=224323 then '1' when ansid=224324 then '1' when ansid=224325 then '1' when ansid=224326 then '1' when ansid=224327 then '2' when ansid=224328 then '1' when ansid=224329 then '1' when ansid=224330 then '1' when ansid=224331 then '1' when ansid=224332 then '' when ansid=224333 then '1' when ansid=224334 then '' when ansid=224335 then '1' when ansid=224336 then '1' when ansid=224337 then '1' when ansid=224338 then '' when ansid=224339 then '1' when ansid=224340 then '1' when ansid=224341 then '1' when ansid=224342 then '2' when ansid=224343 then '1' when ansid=224344 then '12' when ansid=224345 then 'no' when ansid=224346 then 'no' when ansid=224347 then 'no' when ansid=224348 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '122.179.101.3',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 07:10:50'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224243','224244','224245','224246','224247','224248','224249','224292','224294','224296','224298','224300','224302','224303','224304','224305','224306','224307','224308','224309','224310','224311','224312','224313','224314','224315','224316','224317','224318','224319','224320','224321','224322','224323','224324','224325','224326','224327','224328','224329','224330','224331','224332','224333','224334','224335','224336','224337','224338','224339','224340','224341','224342','224343','224344','224345','224346','224347','224348')"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE supvisstepid = '11979'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE visitfeedback SET `feedback` = 'No', `recommendation` = 'no', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE visitfeedbackid = '11871'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE visitfeedbackid = '11872'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE visitfeedbackid = '11873'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE visitfeedbackid = '11874'"} {"userId":"520","date":"2022-11-24 07:10:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.179.101.3', `modifiedby` = '520', `modifieddate` = '2022-11-24 07:10:50' WHERE visitfeedbackid = '11875'"} {"userId":"520","date":"2022-11-24 10:31:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('520', '43.241.25.50', '2022-11-24 10:31:29')"} {"userId":"520","date":"2022-11-24 10:32:42","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('488', '2022-11-30', '520', '43.241.25.50', '520', '2022-11-24 10:32:42')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('488', '2821', '520', '2022-11-24', '1', '43.241.25.50', '520', '2022-11-24 10:33:08', '', '')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2420', '0', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2420', '1', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2420', '2', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2420', '3', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2420', '4', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2420', '', '', 'Array', '', 'Array', '', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2420', '', '', 'Array', '', 'Array', '', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2420', '', '', 'Array', '', 'Array', '', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2420', '', '', 'Array', '', 'Array', '', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:33:08","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2420', '43.241.25.50', '520', '2022-11-24 10:33:08')"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE sitesupervision SET `siteid` = '488', `userid` = '520', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-24', `numofsamplecollected` = '5', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2420'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE onssid = '10008'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE onssid = '10009'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE onssid = '10010'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE onssid = '10011'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224349 then '' when ansid=224350 then '' when ansid=224351 then '' when ansid=224352 then '' when ansid=224353 then '' when ansid=224354 then '' when ansid=224355 then '' when ansid=224398 then '' when ansid=224400 then '' when ansid=224402 then '' when ansid=224404 then '' when ansid=224406 then '' when ansid=224408 then '' when ansid=224409 then '' when ansid=224410 then '' when ansid=224411 then '' when ansid=224412 then '' when ansid=224413 then '' when ansid=224414 then '' when ansid=224415 then '' when ansid=224416 then '' when ansid=224417 then '' when ansid=224418 then '' when ansid=224419 then '' when ansid=224420 then '' when ansid=224421 then '' when ansid=224422 then '' when ansid=224423 then '' when ansid=224424 then '' when ansid=224425 then '' when ansid=224426 then '' when ansid=224427 then '' when ansid=224428 then '' when ansid=224429 then '' when ansid=224430 then '' when ansid=224431 then '' when ansid=224432 then '' when ansid=224433 then '' when ansid=224434 then '' when ansid=224435 then '' when ansid=224436 then '' when ansid=224437 then '' when ansid=224438 then '' when ansid=224439 then '' when ansid=224440 then '' when ansid=224441 then '' when ansid=224442 then '' when ansid=224443 then '' when ansid=224444 then '' when ansid=224445 then '' when ansid=224446 then '' when ansid=224447 then '' when ansid=224448 then '' when ansid=224449 then '' when ansid=224450 then '' when ansid=224451 then '' when ansid=224452 then '' when ansid=224453 then '' when ansid=224454 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '43.241.25.50',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 10:35:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224349','224350','224351','224352','224353','224354','224355','224398','224400','224402','224404','224406','224408','224409','224410','224411','224412','224413','224414','224415','224416','224417','224418','224419','224420','224421','224422','224423','224424','224425','224426','224427','224428','224429','224430','224431','224432','224433','224434','224435','224436','224437','224438','224439','224440','224441','224442','224443','224444','224445','224446','224447','224448','224449','224450','224451','224452','224453','224454')"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE supvisstepid = '11980'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE visitfeedbackid = '11876'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE visitfeedbackid = '11877'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE visitfeedbackid = '11878'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE visitfeedbackid = '11879'"} {"userId":"520","date":"2022-11-24 10:35:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:05' WHERE visitfeedbackid = '11880'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE sitesupervision SET `siteid` = '488', `userid` = '520', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-24', `numofsamplecollected` = '5', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2420'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE onssid = '10008'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE onssid = '10009'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE onssid = '10010'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE onssid = '10011'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224349 then '1' when ansid=224350 then '1' when ansid=224351 then '1' when ansid=224352 then '' when ansid=224353 then '' when ansid=224354 then '' when ansid=224355 then '1' when ansid=224398 then '' when ansid=224400 then '' when ansid=224402 then '' when ansid=224404 then '' when ansid=224406 then '' when ansid=224408 then '' when ansid=224409 then '' when ansid=224410 then '' when ansid=224411 then '' when ansid=224412 then '' when ansid=224413 then '' when ansid=224414 then '' when ansid=224415 then '' when ansid=224416 then '' when ansid=224417 then '' when ansid=224418 then '' when ansid=224419 then '' when ansid=224420 then '' when ansid=224421 then '' when ansid=224422 then '' when ansid=224423 then '' when ansid=224424 then '' when ansid=224425 then '' when ansid=224426 then '' when ansid=224427 then '' when ansid=224428 then '' when ansid=224429 then '' when ansid=224430 then '' when ansid=224431 then '' when ansid=224432 then '' when ansid=224433 then '' when ansid=224434 then '' when ansid=224435 then '' when ansid=224436 then '' when ansid=224437 then '' when ansid=224438 then '' when ansid=224439 then '' when ansid=224440 then '' when ansid=224441 then '' when ansid=224442 then '' when ansid=224443 then '' when ansid=224444 then '' when ansid=224445 then '' when ansid=224446 then '' when ansid=224447 then '' when ansid=224448 then '' when ansid=224449 then '' when ansid=224450 then '' when ansid=224451 then '' when ansid=224452 then '' when ansid=224453 then '' when ansid=224454 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '43.241.25.50',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 10:35:35'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224349','224350','224351','224352','224353','224354','224355','224398','224400','224402','224404','224406','224408','224409','224410','224411','224412','224413','224414','224415','224416','224417','224418','224419','224420','224421','224422','224423','224424','224425','224426','224427','224428','224429','224430','224431','224432','224433','224434','224435','224436','224437','224438','224439','224440','224441','224442','224443','224444','224445','224446','224447','224448','224449','224450','224451','224452','224453','224454')"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE supvisstepid = '11981'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE visitfeedbackid = '11876'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE visitfeedbackid = '11877'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE visitfeedbackid = '11878'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE visitfeedbackid = '11879'"} {"userId":"520","date":"2022-11-24 10:35:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:35:35' WHERE visitfeedbackid = '11880'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE sitesupervision SET `siteid` = '488', `userid` = '520', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-24', `numofsamplecollected` = '5', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2420'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE onssid = '10008'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE onssid = '10009'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE onssid = '10010'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE onssid = '10011'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224349 then '1' when ansid=224350 then '1' when ansid=224351 then '1' when ansid=224352 then '' when ansid=224353 then '' when ansid=224354 then '' when ansid=224355 then '1' when ansid=224398 then '400' when ansid=224400 then '3' when ansid=224402 then '3' when ansid=224404 then '3' when ansid=224406 then '5' when ansid=224408 then '' when ansid=224409 then '' when ansid=224410 then '' when ansid=224411 then '' when ansid=224412 then '' when ansid=224413 then '' when ansid=224414 then '' when ansid=224415 then '' when ansid=224416 then '' when ansid=224417 then '' when ansid=224418 then '' when ansid=224419 then '' when ansid=224420 then '' when ansid=224421 then '' when ansid=224422 then '' when ansid=224423 then '' when ansid=224424 then '' when ansid=224425 then '' when ansid=224426 then '' when ansid=224427 then '' when ansid=224428 then '' when ansid=224429 then '' when ansid=224430 then '' when ansid=224431 then '' when ansid=224432 then '' when ansid=224433 then '' when ansid=224434 then '' when ansid=224435 then '' when ansid=224436 then '' when ansid=224437 then '' when ansid=224438 then '' when ansid=224439 then '' when ansid=224440 then '' when ansid=224441 then '' when ansid=224442 then '' when ansid=224443 then '' when ansid=224444 then '' when ansid=224445 then '' when ansid=224446 then '' when ansid=224447 then '' when ansid=224448 then '' when ansid=224449 then '' when ansid=224450 then '' when ansid=224451 then '' when ansid=224452 then '' when ansid=224453 then '' when ansid=224454 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '43.241.25.50',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 10:36:08'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224349','224350','224351','224352','224353','224354','224355','224398','224400','224402','224404','224406','224408','224409','224410','224411','224412','224413','224414','224415','224416','224417','224418','224419','224420','224421','224422','224423','224424','224425','224426','224427','224428','224429','224430','224431','224432','224433','224434','224435','224436','224437','224438','224439','224440','224441','224442','224443','224444','224445','224446','224447','224448','224449','224450','224451','224452','224453','224454')"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE supvisstepid = '11982'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE visitfeedbackid = '11876'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE visitfeedbackid = '11877'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE visitfeedbackid = '11878'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE visitfeedbackid = '11879'"} {"userId":"520","date":"2022-11-24 10:36:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:36:08' WHERE visitfeedbackid = '11880'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE sitesupervision SET `siteid` = '488', `userid` = '520', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-24', `numofsamplecollected` = '5', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2420'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE onssid = '10008'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE onssid = '10009'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE onssid = '10010'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE onssid = '10011'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224349 then '1' when ansid=224350 then '1' when ansid=224351 then '1' when ansid=224352 then '' when ansid=224353 then '' when ansid=224354 then '' when ansid=224355 then '1' when ansid=224398 then '400' when ansid=224400 then '3' when ansid=224402 then '3' when ansid=224404 then '3' when ansid=224406 then '5' when ansid=224408 then '7' when ansid=224409 then '20' when ansid=224410 then '35' when ansid=224411 then '100' when ansid=224412 then '' when ansid=224413 then '1' when ansid=224414 then '1' when ansid=224415 then '' when ansid=224416 then '1' when ansid=224417 then '' when ansid=224418 then '1' when ansid=224419 then '8' when ansid=224420 then '1' when ansid=224421 then '1' when ansid=224422 then '' when ansid=224423 then '1' when ansid=224424 then '' when ansid=224425 then '1' when ansid=224426 then '1' when ansid=224427 then '' when ansid=224428 then '1' when ansid=224429 then '1' when ansid=224430 then '1' when ansid=224431 then '1' when ansid=224432 then '2' when ansid=224433 then '1' when ansid=224434 then '3' when ansid=224435 then '1' when ansid=224436 then '1' when ansid=224437 then '1' when ansid=224438 then '' when ansid=224439 then '3' when ansid=224440 then '' when ansid=224441 then '1' when ansid=224442 then '1' when ansid=224443 then '1' when ansid=224444 then '' when ansid=224445 then '1' when ansid=224446 then '2' when ansid=224447 then '1' when ansid=224448 then '1' when ansid=224449 then '1' when ansid=224450 then '5' when ansid=224451 then 'no' when ansid=224452 then 'no' when ansid=224453 then 'no' when ansid=224454 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '43.241.25.50',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 10:40:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224349','224350','224351','224352','224353','224354','224355','224398','224400','224402','224404','224406','224408','224409','224410','224411','224412','224413','224414','224415','224416','224417','224418','224419','224420','224421','224422','224423','224424','224425','224426','224427','224428','224429','224430','224431','224432','224433','224434','224435','224436','224437','224438','224439','224440','224441','224442','224443','224444','224445','224446','224447','224448','224449','224450','224451','224452','224453','224454')"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE supvisstepid = '11983'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE visitfeedbackid = '11876'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE visitfeedbackid = '11877'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE visitfeedbackid = '11878'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE visitfeedbackid = '11879'"} {"userId":"520","date":"2022-11-24 10:40:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:40:34' WHERE visitfeedbackid = '11880'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE sitesupervision SET `siteid` = '488', `userid` = '520', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-11-24', `numofsamplecollected` = '5', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2420'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE onsitestaffs SET `staffname` = 'xyz', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE onssid = '10008'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE onssid = '10009'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE onssid = '10010'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE onssid = '10011'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=224349 then '1' when ansid=224350 then '1' when ansid=224351 then '1' when ansid=224352 then '' when ansid=224353 then '' when ansid=224354 then '' when ansid=224355 then '1' when ansid=224398 then '400' when ansid=224400 then '3' when ansid=224402 then '3' when ansid=224404 then '3' when ansid=224406 then '5' when ansid=224408 then '7' when ansid=224409 then '20' when ansid=224410 then '35' when ansid=224411 then '100' when ansid=224412 then '' when ansid=224413 then '1' when ansid=224414 then '1' when ansid=224415 then '' when ansid=224416 then '1' when ansid=224417 then '' when ansid=224418 then '1' when ansid=224419 then '8' when ansid=224420 then '1' when ansid=224421 then '1' when ansid=224422 then '' when ansid=224423 then '1' when ansid=224424 then '' when ansid=224425 then '1' when ansid=224426 then '1' when ansid=224427 then '' when ansid=224428 then '1' when ansid=224429 then '1' when ansid=224430 then '1' when ansid=224431 then '1' when ansid=224432 then '2' when ansid=224433 then '1' when ansid=224434 then '3' when ansid=224435 then '1' when ansid=224436 then '1' when ansid=224437 then '1' when ansid=224438 then '' when ansid=224439 then '3' when ansid=224440 then '' when ansid=224441 then '1' when ansid=224442 then '1' when ansid=224443 then '1' when ansid=224444 then '' when ansid=224445 then '1' when ansid=224446 then '2' when ansid=224447 then '1' when ansid=224448 then '1' when ansid=224449 then '1' when ansid=224450 then '5' when ansid=224451 then 'no' when ansid=224452 then 'no' when ansid=224453 then 'no' when ansid=224454 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '43.241.25.50',\r\n\t\t\t\t\t\t\t\tmodifiedby =520,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-11-24 10:41:55'\r\n\t\t\t\t\t\t\tWHERE ansid in ('224349','224350','224351','224352','224353','224354','224355','224398','224400','224402','224404','224406','224408','224409','224410','224411','224412','224413','224414','224415','224416','224417','224418','224419','224420','224421','224422','224423','224424','224425','224426','224427','224428','224429','224430','224431','224432','224433','224434','224435','224436','224437','224438','224439','224440','224441','224442','224443','224444','224445','224446','224447','224448','224449','224450','224451','224452','224453','224454')"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE supvisstepid = '11984'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE visitfeedback SET `feedback` = 'satisfactory', `recommendation` = 'no', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE visitfeedbackid = '11876'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE visitfeedbackid = '11877'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE visitfeedbackid = '11878'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE visitfeedbackid = '11879'"} {"userId":"520","date":"2022-11-24 10:41:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '43.241.25.50', `modifiedby` = '520', `modifieddate` = '2022-11-24 10:41:55' WHERE visitfeedbackid = '11880'"}