{"userId":"136","date":"2019-04-01 10:59:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('136', '103.43.83.46', '2019-04-01 10:59:26')"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 11:00:22'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE supvisstepid = '675'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 11:00:22","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 11:00:22'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE supvisstepid = '676'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:22' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 11:00:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 11:00:23'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE supvisstepid = '678'"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 11:00:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 11:00:23' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 12:18:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('136', '103.43.83.46', '2019-04-01 12:18:54')"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 12:19:32'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE supvisstepid = '675'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 12:19:32","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 12:19:32'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE supvisstepid = '676'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:32' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 12:19:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '' when ansid=10981 then '' when ansid=10982 then '' when ansid=10983 then ''  when ansid=10984 then ''   when ansid=10985 then ''  when ansid=10986 then ''  when ansid=10987 then ''   when ansid=10988 then ''   when ansid=10989 then ''   when ansid=10990 then ''  when ansid=10991 then '' when ansid=10992 then '' when ansid=10993 then ''  when ansid=10994 then ''   when ansid=10995 then ''   when ansid=10996 then ''   when ansid=10997 then ''  when ansid=10998 then ''  when ansid=10999 then ''   when ansid=11000 then ''  when ansid=11001 then '' when ansid=11002 then '' when ansid=11003 then '' when ansid=11004 then '' when ansid=11005 then '' when ansid=11006 then '' when ansid=11007 then '' when ansid=11008 then '' when ansid=11009 then ''  when ansid=11010 then ''   when ansid=11011 then ''   when ansid=11012 then ''   when ansid=11013 then ''  when ansid=11014 then '' when ansid=11015 then ''  when ansid=11016 then ''   when ansid=11017 then ''  when ansid=11018 then '' when ansid=11019 then '' when ansid=11020 then '' when ansid=11021 then '' when ansid=11022 then '' when ansid=11023 then '' when ansid=11024 then '' when ansid=11025 then '' when ansid=11026 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 12:19:34'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE supvisstepid = '678'"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 12:19:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:19:34' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 12:25:50","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '0' when ansid=10981 then '0' when ansid=10982 then '80' when ansid=10983 then '60'  when ansid=10984 then ''   when ansid=10985 then '1'  when ansid=10986 then '1'  when ansid=10987 then ''   when ansid=10988 then '1'   when ansid=10989 then ''   when ansid=10990 then '1'  when ansid=10991 then '12' when ansid=10992 then '1' when ansid=10993 then '1'  when ansid=10994 then 'Counselor'   when ansid=10995 then '1'   when ansid=10996 then 'Sample collection was not done for absence of lab tech'   when ansid=10997 then '2'  when ansid=10998 then '1'  when ansid=10999 then ''   when ansid=11000 then '1'  when ansid=11001 then '4' when ansid=11002 then '1' when ansid=11003 then '1' when ansid=11004 then '1' when ansid=11005 then '1' when ansid=11006 then '3' when ansid=11007 then '1' when ansid=11008 then '1' when ansid=11009 then '1'  when ansid=11010 then ''   when ansid=11011 then '3'   when ansid=11012 then ''   when ansid=11013 then '1'  when ansid=11014 then '1' when ansid=11015 then '1'  when ansid=11016 then 'Not available at the site'   when ansid=11017 then '2'  when ansid=11018 then '1' when ansid=11019 then '3' when ansid=11020 then '3' when ansid=11021 then '1' when ansid=11022 then '0' when ansid=11023 then 'Lab technician was on leave for illness' when ansid=11024 then 'Site in charge' when ansid=11025 then 'Nil' when ansid=11026 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 12:25:50'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE supvisstepid = '680'"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 12:25:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:25:50' WHERE visitfeedbackid = '345'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE sitesupervision SET `siteid` = '966', `userid` = '136', `ancservicedays` = '0', `samplecollectiondays` = '2', `samplecollectionstartdate` = '2019-01-09', `numofsamplecollected` = '28', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '109'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Surojit Baskey', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '0', `remarks` = 'Need to be sensitised', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE onssid = '469'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE onsitestaffs SET `staffname` = 'Sutapa Ganguly', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE onssid = '470'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE onsitestaffs SET `staffname` = 'Tanuja Sultana', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE onssid = '471'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE onssid = '472'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE onssid = '473'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=10921 then '1' when ansid=10922 then '1' when ansid=10923 then '2' when ansid=10924 then '1' when ansid=10925 then ''  when ansid=10926 then ''   when ansid=10927 then '1'  when ansid=10928 then '1' when ansid=10930 then '1' when ansid=10932 then '250' when ansid=10934 then '20' when ansid=10936 then '20' when ansid=10938 then '250' when ansid=10940 then '1' when ansid=10942 then '1' when ansid=10944 then '2' when ansid=10946 then '250' when ansid=10948 then '250' when ansid=10950 then '250' when ansid=10952 then '0' when ansid=10954 then '1' when ansid=10956 then '250' when ansid=10958 then '250' when ansid=10960 then '250' when ansid=10962 then '2' when ansid=10964 then '3' when ansid=10966 then '1' when ansid=10968 then '3' when ansid=10970 then '0' when ansid=10972 then '1' when ansid=10974 then '0' when ansid=10976 then '3' when ansid=10978 then '5' when ansid=10980 then '0' when ansid=10981 then '0' when ansid=10982 then '80' when ansid=10983 then '60'  when ansid=10984 then ''   when ansid=10985 then '1'  when ansid=10986 then '1'  when ansid=10987 then ''   when ansid=10988 then '1'   when ansid=10989 then ''   when ansid=10990 then '1'  when ansid=10991 then '12' when ansid=10992 then '1' when ansid=10993 then '1'  when ansid=10994 then 'Counselor'   when ansid=10995 then '1'   when ansid=10996 then 'Sample collection was not done for absence of lab tech'   when ansid=10997 then '2'  when ansid=10998 then '1'  when ansid=10999 then ''   when ansid=11000 then '1'  when ansid=11001 then '4' when ansid=11002 then '1' when ansid=11003 then '1' when ansid=11004 then '1' when ansid=11005 then '1' when ansid=11006 then '3' when ansid=11007 then '1' when ansid=11008 then '1' when ansid=11009 then '1'  when ansid=11010 then ''   when ansid=11011 then '3'   when ansid=11012 then ''   when ansid=11013 then '1'  when ansid=11014 then '1' when ansid=11015 then '1'  when ansid=11016 then 'Not available at the site'   when ansid=11017 then '2'  when ansid=11018 then '1' when ansid=11019 then '3' when ansid=11020 then '3' when ansid=11021 then '1' when ansid=11022 then '0' when ansid=11023 then 'Lab technician was on leave for illness' when ansid=11024 then 'Site in charge' when ansid=11025 then 'Nil' when ansid=11026 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.43.83.46',\n\t\t\t\t\t\t\t\tmodifiedby =136,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 12:27:54'\n\t\t\t\t\t\t\tWHERE ansid in ('10921','10922','10923','10924','10925','10926','10927','10928','10930','10932','10934','10936','10938','10940','10942','10944','10946','10948','10950','10952','10954','10956','10958','10960','10962','10964','10966','10968','10970','10972','10974','10976','10978','10980','10981','10982','10983','10984','10985','10986','10987','10988','10989','10990','10991','10992','10993','10994','10995','10996','10997','10998','10999','11000','11001','11002','11003','11004','11005','11006','11007','11008','11009','11010','11011','11012','11013','11014','11015','11016','11017','11018','11019','11020','11021','11022','11023','11024','11025','11026')"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE supvisstepid = '681'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE visitfeedback SET `feedback` = 'Site in charge was not trained', `recommendation` = 'Issues were discussed with superintendent for sensitization of medical officers', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE visitfeedbackid = '341'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE visitfeedback SET `feedback` = 'Lab technician was absent for illness', `recommendation` = 'Superintendent was requested to arrange for lab technician', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE visitfeedbackid = '342'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE visitfeedbackid = '343'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE visitfeedbackid = '344'"}
{"userId":"136","date":"2019-04-01 12:27:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.43.83.46', `modifiedby` = '136', `modifieddate` = '2019-04-01 12:27:54' WHERE visitfeedbackid = '345'"}
{"userId":"75","date":"2019-04-01 16:40:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('75', '117.208.92.95', '2019-04-01 16:40:59')"}
{"userId":"75","date":"2019-04-01 16:42:55","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('58', '2019-03-29', '75', '117.208.92.95', '75', '2019-04-01 16:42:55')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('58', '892', '75', '2019-04-01', '0', '117.208.92.95', '75', '2019-04-01 16:43:27', '', '')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('710', '0', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('710', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('710', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('710', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('710', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:43:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:44:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('710', '117.208.92.95', '75', '2019-04-01 16:43:27')"}
{"userId":"75","date":"2019-04-01 16:45:22","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1050', '2019-03-29', '75', '117.208.92.95', '75', '2019-04-01 16:45:22')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1050', '893', '75', '2019-04-01', '1', '117.208.92.95', '75', '2019-04-01 16:51:19', '', '')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '0', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '1', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '2', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '3', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '4', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('711', '5', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('711', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('711', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('711', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('711', '', '', 'Array', '', 'Array', '', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:51:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('711', '117.208.92.95', '75', '2019-04-01 16:51:19')"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '' when ansid=74500 then '' when ansid=74502 then '' when ansid=74504 then '' when ansid=74506 then '' when ansid=74508 then '' when ansid=74510 then '' when ansid=74512 then '' when ansid=74514 then '' when ansid=74516 then '' when ansid=74518 then '' when ansid=74520 then '' when ansid=74522 then '' when ansid=74524 then '' when ansid=74526 then '' when ansid=74528 then '' when ansid=74530 then '' when ansid=74532 then '' when ansid=74534 then '' when ansid=74536 then '' when ansid=74538 then '' when ansid=74540 then '' when ansid=74542 then '' when ansid=74544 then '' when ansid=74546 then '' when ansid=74548 then '' when ansid=74550 then '' when ansid=74552 then '' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 16:54:24'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE supvisstepid = '4556'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 16:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:54:24' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 16:55:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '' when ansid=74520 then '' when ansid=74522 then '' when ansid=74524 then '' when ansid=74526 then '' when ansid=74528 then '' when ansid=74530 then '' when ansid=74532 then '' when ansid=74534 then '' when ansid=74536 then '' when ansid=74538 then '' when ansid=74540 then '' when ansid=74542 then '' when ansid=74544 then '' when ansid=74546 then '' when ansid=74548 then '' when ansid=74550 then '' when ansid=74552 then '' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 16:55:40'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE supvisstepid = '4557'"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 16:55:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:55:40' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 16:58:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '' when ansid=74546 then '' when ansid=74548 then '' when ansid=74550 then '' when ansid=74552 then '' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 16:58:08'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE supvisstepid = '4558'"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 16:58:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:58:08' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '1' when ansid=74546 then '0' when ansid=74548 then '0' when ansid=74550 then '60' when ansid=74552 then '1' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 16:59:39'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE supvisstepid = '4559'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 16:59:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 16:59:39' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 17:50:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('75', '117.208.92.95', '2019-04-01 17:50:45')"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 17:51:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '1' when ansid=74546 then '0' when ansid=74548 then '0' when ansid=74550 then '60' when ansid=74552 then '1' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 17:51:15'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE supvisstepid = '4559'"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 17:51:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:15' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '1' when ansid=74546 then '0' when ansid=74548 then '0' when ansid=74550 then '60' when ansid=74552 then '1' when ansid=74554 then '' when ansid=74555 then ''  when ansid=74556 then ''   when ansid=74557 then ''   when ansid=74558 then ''   when ansid=74559 then ''   when ansid=74560 then ''   when ansid=74561 then ''  when ansid=74562 then '' when ansid=74563 then ''  when ansid=74564 then ''   when ansid=74565 then ''   when ansid=74566 then ''   when ansid=74567 then ''  when ansid=74568 then '' when ansid=74569 then '' when ansid=74570 then '' when ansid=74571 then '' when ansid=74572 then '' when ansid=74573 then '' when ansid=74574 then '' when ansid=74575 then '' when ansid=74576 then '' when ansid=74577 then '' when ansid=74578 then '' when ansid=74579 then '' when ansid=74580 then '' when ansid=74581 then ''  when ansid=74582 then ''   when ansid=74583 then ''  when ansid=74584 then '' when ansid=74585 then '' when ansid=74586 then '' when ansid=74587 then '' when ansid=74588 then '' when ansid=74589 then '' when ansid=74590 then '' when ansid=74591 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 17:51:19'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE supvisstepid = '4557'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 17:51:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 17:51:19' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 18:00:16","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '1' when ansid=74546 then '0' when ansid=74548 then '0' when ansid=74550 then '60' when ansid=74552 then '1' when ansid=74554 then '4' when ansid=74555 then '2'  when ansid=74556 then ''   when ansid=74557 then '1'   when ansid=74558 then ''   when ansid=74559 then '1'   when ansid=74560 then ''   when ansid=74561 then '1'  when ansid=74562 then '6' when ansid=74563 then '2'  when ansid=74564 then 'Counsellor'   when ansid=74565 then '1'   when ansid=74566 then ''   when ansid=74567 then '1'  when ansid=74568 then '1' when ansid=74569 then '1' when ansid=74570 then '1' when ansid=74571 then '1' when ansid=74572 then '1' when ansid=74573 then '1' when ansid=74574 then '1' when ansid=74575 then '1' when ansid=74576 then '1' when ansid=74577 then '1' when ansid=74578 then '3' when ansid=74579 then '1' when ansid=74580 then '1' when ansid=74581 then '1'  when ansid=74582 then ''   when ansid=74583 then '1'  when ansid=74584 then '1' when ansid=74585 then '1' when ansid=74586 then '1' when ansid=74587 then '1' when ansid=74588 then '0' when ansid=74589 then 'Some of the consumables were also made available by the Jail authorities from supplies of their lab to be used under HSS.' when ansid=74590 then '1 visit by RI and 1 visit by PSACS. It was suggested to have meetings with jail authorities, health staff and HSS staff to ensure better coordination. The meetings with the concerned staff were made to share the microplanning strategy and HSS staff was suggested to share list of 20 inmates to be recruited the next day in advance so that the announcements for recruiting inmates were coordinated well on the day of recruitment,' when ansid=74591 then 'The staff was sensitized on documentation in HSS register. Flow chart was not available at the site but the staff carried manuals along to the prison clinic site.' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 18:00:16'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE supvisstepid = '4560'"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 18:00:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:00:16' WHERE visitfeedbackid = '3340'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE sitesupervision SET `siteid` = '1050', `userid` = '75', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-27', `numofsamplecollected` = '100', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19', `locationtype` = '2', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '1300', `undertrialprisoners` = '2100', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '711'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE onsitestaffs SET `staffname` = 'Raj Kumar', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE onssid = '3172'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE onsitestaffs SET `staffname` = 'Asha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE onssid = '3173'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE onsitestaffs SET `staffname` = 'Avinder', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE onssid = '3174'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE onssid = '3175'"}
{"userId":"75","date":"2019-04-01 18:04:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=74498 then '3' when ansid=74500 then '0' when ansid=74502 then '400' when ansid=74504 then '0' when ansid=74506 then '0' when ansid=74508 then '600' when ansid=74510 then '400' when ansid=74512 then '1' when ansid=74514 then '1' when ansid=74516 then '1' when ansid=74518 then '2' when ansid=74520 then '350' when ansid=74522 then '0' when ansid=74524 then '400' when ansid=74526 then '250' when ansid=74528 then '1' when ansid=74530 then '400' when ansid=74532 then '400' when ansid=74534 then '400' when ansid=74536 then '0' when ansid=74538 then '5' when ansid=74540 then '0' when ansid=74542 then '3' when ansid=74544 then '1' when ansid=74546 then '0' when ansid=74548 then '0' when ansid=74550 then '60' when ansid=74552 then '1' when ansid=74554 then '4' when ansid=74555 then '2'  when ansid=74556 then ''   when ansid=74557 then '1'   when ansid=74558 then ''   when ansid=74559 then '1'   when ansid=74560 then ''   when ansid=74561 then '1'  when ansid=74562 then '6' when ansid=74563 then '2'  when ansid=74564 then 'Counsellor'   when ansid=74565 then '1'   when ansid=74566 then ''   when ansid=74567 then '1'  when ansid=74568 then '1' when ansid=74569 then '1' when ansid=74570 then '1' when ansid=74571 then '1' when ansid=74572 then '1' when ansid=74573 then '1' when ansid=74574 then '1' when ansid=74575 then '1' when ansid=74576 then '1' when ansid=74577 then '1' when ansid=74578 then '3' when ansid=74579 then '1' when ansid=74580 then '1' when ansid=74581 then '1'  when ansid=74582 then ''   when ansid=74583 then '1'  when ansid=74584 then '1' when ansid=74585 then '1' when ansid=74586 then '1' when ansid=74587 then '1' when ansid=74588 then '0' when ansid=74589 then 'Some of the consumables were also made available by the Jail authorities from supplies of their lab to be used under HSS.' when ansid=74590 then '1 visit by RI and 1 visit by PSACS. It was suggested to have meetings with jail authorities, health staff and HSS staff to ensure better coordination. The meetings with the concerned staff were made to share the microplanning strategy and HSS staff was suggested to share list of 20 inmates to be recruited the next day in advance so that the announcements for recruiting inmates were coordinated well on the day of recruitment,' when ansid=74591 then 'The staff was sensitized on documentation in HSS register. Flow chart was not available at the site but the staff carried manuals along to the prison clinic site.' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.208.92.95',\n\t\t\t\t\t\t\t\tmodifiedby =75,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-01 18:04:19'\n\t\t\t\t\t\t\tWHERE ansid in ('74498','74500','74502','74504','74506','74508','74510','74512','74514','74516','74518','74520','74522','74524','74526','74528','74530','74532','74534','74536','74538','74540','74542','74544','74546','74548','74550','74552','74554','74555','74556','74557','74558','74559','74560','74561','74562','74563','74564','74565','74566','74567','74568','74569','74570','74571','74572','74573','74574','74575','74576','74577','74578','74579','74580','74581','74582','74583','74584','74585','74586','74587','74588','74589','74590','74591')"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE supvisstepid = '4561'"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE visitfeedback SET `feedback` = 'Documentation of HSS register improved', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE visitfeedbackid = '3336'"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE visitfeedback SET `feedback` = 'meetings with jail authorites and health staff conducted to ensure better coordination', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE visitfeedbackid = '3337'"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE visitfeedback SET `feedback` = 'microplanning strategy improved and shared with the concerned jail authority staff (announcement cell, e-prison) to ensure availability of the inmates on the day of recruitment.', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE visitfeedbackid = '3338'"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE visitfeedbackid = '3339'"}
{"userId":"75","date":"2019-04-01 18:04:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.208.92.95', `modifiedby` = '75', `modifieddate` = '2019-04-01 18:04:19' WHERE visitfeedbackid = '3340'"}