{"userId":"471","date":"2021-03-27 11:59:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('471', '157.39.43.109', '2021-03-27 11:59:58')"}
{"userId":"471","date":"2021-03-27 12:00:59","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1469', '2021-02-17', '471', '157.39.43.109', '471', '2021-03-27 12:00:59')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1469', '2596', '471', '2021-03-27', '1', '157.39.43.109', '471', '2021-03-27 12:01:09', '', '')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2193', '0', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2193', '1', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2193', '2', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2193', '3', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2193', '', '', 'Array', '', 'Array', '', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2193', '', '', 'Array', '', 'Array', '', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2193', '', '', 'Array', '', 'Array', '', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2193', '', '', 'Array', '', 'Array', '', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:01:09","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2193', '157.39.43.109', '471', '2021-03-27 12:01:09')"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE sitesupervision SET `siteid` = '1469', `userid` = '471', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-17', `numofsamplecollected` = '3', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2193'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Kanwarvir', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE onssid = '9100'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Kuldeep Kur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE onssid = '9101'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE onsitestaffs SET `staffname` = 'Miss Nisha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE onssid = '9102'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE onssid = '9103'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205928 then '2' when ansid=205929 then '1' when ansid=205930 then '1' when ansid=205931 then '0' when ansid=205932 then '0' when ansid=205933 then '3' when ansid=205934 then '3' when ansid=205935 then '' when ansid=205936 then '' when ansid=205937 then '' when ansid=205938 then '' when ansid=205939 then '' when ansid=205940 then '' when ansid=205941 then '' when ansid=205942 then '' when ansid=205943 then '' when ansid=205944 then '' when ansid=205945 then '' when ansid=205946 then '' when ansid=205947 then ''  when ansid=205948 then ''   when ansid=205949 then ''   when ansid=205950 then ''   when ansid=205951 then ''   when ansid=205952 then ''   when ansid=205953 then ''   when ansid=205954 then ''   when ansid=205955 then ''   when ansid=205956 then ''   when ansid=205957 then ''  when ansid=205958 then '' when ansid=205959 then '' when ansid=205960 then ''  when ansid=205961 then ''   when ansid=205962 then ''   when ansid=205963 then ''   when ansid=205964 then ''   when ansid=205965 then ''   when ansid=205966 then ''   when ansid=205967 then ''   when ansid=205968 then ''   when ansid=205969 then ''   when ansid=205970 then ''   when ansid=205971 then ''   when ansid=205972 then ''   when ansid=205973 then ''   when ansid=205974 then ''  when ansid=205975 then '' when ansid=205976 then '' when ansid=205977 then '' when ansid=205978 then '' when ansid=205979 then '' when ansid=205980 then '' when ansid=205981 then '' when ansid=205982 then '' when ansid=205983 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.43.109',\n\t\t\t\t\t\t\t\tmodifiedby =471,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 12:24:19'\n\t\t\t\t\t\t\tWHERE ansid in ('205928','205929','205930','205931','205932','205933','205934','205935','205936','205937','205938','205939','205940','205941','205942','205943','205944','205945','205946','205947','205948','205949','205950','205951','205952','205953','205954','205955','205956','205957','205958','205959','205960','205961','205962','205963','205964','205965','205966','205967','205968','205969','205970','205971','205972','205973','205974','205975','205976','205977','205978','205979','205980','205981','205982','205983')"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE supvisstepid = '10978'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE visitfeedbackid = '10741'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE visitfeedbackid = '10742'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE visitfeedbackid = '10743'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE visitfeedbackid = '10744'"}
{"userId":"471","date":"2021-03-27 12:24:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:24:19' WHERE visitfeedbackid = '10745'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE sitesupervision SET `siteid` = '1469', `userid` = '471', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-17', `numofsamplecollected` = '3', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2193'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Kanwarvir', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE onssid = '9100'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Kuldeep Kur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE onssid = '9101'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE onsitestaffs SET `staffname` = 'Miss Nisha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE onssid = '9102'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE onssid = '9103'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205928 then '2' when ansid=205929 then '1' when ansid=205930 then '1' when ansid=205931 then '0' when ansid=205932 then '0' when ansid=205933 then '3' when ansid=205934 then '3' when ansid=205935 then '1' when ansid=205936 then '1' when ansid=205937 then '1' when ansid=205938 then '1' when ansid=205939 then '1' when ansid=205940 then '1' when ansid=205941 then '1' when ansid=205942 then '1' when ansid=205943 then '1' when ansid=205944 then '' when ansid=205945 then '' when ansid=205946 then '' when ansid=205947 then ''  when ansid=205948 then ''   when ansid=205949 then ''   when ansid=205950 then ''   when ansid=205951 then ''   when ansid=205952 then ''   when ansid=205953 then ''   when ansid=205954 then ''   when ansid=205955 then ''   when ansid=205956 then ''   when ansid=205957 then ''  when ansid=205958 then '' when ansid=205959 then '' when ansid=205960 then ''  when ansid=205961 then ''   when ansid=205962 then ''   when ansid=205963 then ''   when ansid=205964 then ''   when ansid=205965 then ''   when ansid=205966 then ''   when ansid=205967 then ''   when ansid=205968 then ''   when ansid=205969 then ''   when ansid=205970 then ''   when ansid=205971 then ''   when ansid=205972 then ''   when ansid=205973 then ''   when ansid=205974 then ''  when ansid=205975 then '' when ansid=205976 then '' when ansid=205977 then '' when ansid=205978 then '' when ansid=205979 then '' when ansid=205980 then '' when ansid=205981 then '' when ansid=205982 then '' when ansid=205983 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.43.109',\n\t\t\t\t\t\t\t\tmodifiedby =471,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 12:25:02'\n\t\t\t\t\t\t\tWHERE ansid in ('205928','205929','205930','205931','205932','205933','205934','205935','205936','205937','205938','205939','205940','205941','205942','205943','205944','205945','205946','205947','205948','205949','205950','205951','205952','205953','205954','205955','205956','205957','205958','205959','205960','205961','205962','205963','205964','205965','205966','205967','205968','205969','205970','205971','205972','205973','205974','205975','205976','205977','205978','205979','205980','205981','205982','205983')"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE supvisstepid = '10979'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE visitfeedbackid = '10741'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE visitfeedbackid = '10742'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE visitfeedbackid = '10743'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE visitfeedbackid = '10744'"}
{"userId":"471","date":"2021-03-27 12:25:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:25:02' WHERE visitfeedbackid = '10745'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE sitesupervision SET `siteid` = '1469', `userid` = '471', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-17', `numofsamplecollected` = '3', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2193'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Kanwarvir', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE onssid = '9100'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Kuldeep Kur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE onssid = '9101'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE onsitestaffs SET `staffname` = 'Miss Nisha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE onssid = '9102'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE onssid = '9103'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205928 then '2' when ansid=205929 then '1' when ansid=205930 then '1' when ansid=205931 then '0' when ansid=205932 then '0' when ansid=205933 then '3' when ansid=205934 then '3' when ansid=205935 then '1' when ansid=205936 then '1' when ansid=205937 then '1' when ansid=205938 then '1' when ansid=205939 then '1' when ansid=205940 then '1' when ansid=205941 then '1' when ansid=205942 then '1' when ansid=205943 then '1' when ansid=205944 then '2' when ansid=205945 then '2' when ansid=205946 then '5' when ansid=205947 then '1'  when ansid=205948 then ''   when ansid=205949 then '1'   when ansid=205950 then ''   when ansid=205951 then '1'   when ansid=205952 then ''   when ansid=205953 then '1'   when ansid=205954 then ''   when ansid=205955 then '1'   when ansid=205956 then ''   when ansid=205957 then '1'  when ansid=205958 then '1' when ansid=205959 then '1' when ansid=205960 then '1'  when ansid=205961 then ''   when ansid=205962 then '1'   when ansid=205963 then ''   when ansid=205964 then '1'   when ansid=205965 then ''   when ansid=205966 then '1'   when ansid=205967 then ''   when ansid=205968 then '1'   when ansid=205969 then ''   when ansid=205970 then '1'   when ansid=205971 then ''   when ansid=205972 then '2'   when ansid=205973 then ''   when ansid=205974 then '2'  when ansid=205975 then '1' when ansid=205976 then '1' when ansid=205977 then '1' when ansid=205978 then '1' when ansid=205979 then '1' when ansid=205980 then 'During visit, big zip lock bags were not supplied by Punjab SACS' when ansid=205981 then 'No' when ansid=205982 then 'HSS staff is first time conducting surveillance. They were trained again at supervision time.' when ansid=205983 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.43.109',\n\t\t\t\t\t\t\t\tmodifiedby =471,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 12:35:23'\n\t\t\t\t\t\t\tWHERE ansid in ('205928','205929','205930','205931','205932','205933','205934','205935','205936','205937','205938','205939','205940','205941','205942','205943','205944','205945','205946','205947','205948','205949','205950','205951','205952','205953','205954','205955','205956','205957','205958','205959','205960','205961','205962','205963','205964','205965','205966','205967','205968','205969','205970','205971','205972','205973','205974','205975','205976','205977','205978','205979','205980','205981','205982','205983')"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE supvisstepid = '10980'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE visitfeedbackid = '10741'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE visitfeedbackid = '10742'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE visitfeedbackid = '10743'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE visitfeedbackid = '10744'"}
{"userId":"471","date":"2021-03-27 12:35:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:23' WHERE visitfeedbackid = '10745'"}
{"userId":"471","date":"2021-03-27 12:35:39","query":"UPDATE sitesupervision SET `siteid` = '1469', `userid` = '471', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-17', `numofsamplecollected` = '3', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2193'"}
{"userId":"471","date":"2021-03-27 12:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Kanwarvir', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE onssid = '9100'"}
{"userId":"471","date":"2021-03-27 12:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs Kuldeep Kur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE onssid = '9101'"}
{"userId":"471","date":"2021-03-27 12:35:39","query":"UPDATE onsitestaffs SET `staffname` = 'Miss Nisha', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE onssid = '9102'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:40' WHERE onssid = '9103'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205928 then '2' when ansid=205929 then '1' when ansid=205930 then '1' when ansid=205931 then '0' when ansid=205932 then '0' when ansid=205933 then '3' when ansid=205934 then '3' when ansid=205935 then '1' when ansid=205936 then '1' when ansid=205937 then '1' when ansid=205938 then '1' when ansid=205939 then '1' when ansid=205940 then '1' when ansid=205941 then '1' when ansid=205942 then '1' when ansid=205943 then '1' when ansid=205944 then '2' when ansid=205945 then '2' when ansid=205946 then '5' when ansid=205947 then '1'  when ansid=205948 then ''   when ansid=205949 then '1'   when ansid=205950 then ''   when ansid=205951 then '1'   when ansid=205952 then ''   when ansid=205953 then '1'   when ansid=205954 then ''   when ansid=205955 then '1'   when ansid=205956 then ''   when ansid=205957 then '1'  when ansid=205958 then '1' when ansid=205959 then '1' when ansid=205960 then '1'  when ansid=205961 then ''   when ansid=205962 then '1'   when ansid=205963 then ''   when ansid=205964 then '1'   when ansid=205965 then ''   when ansid=205966 then '1'   when ansid=205967 then ''   when ansid=205968 then '1'   when ansid=205969 then ''   when ansid=205970 then '1'   when ansid=205971 then ''   when ansid=205972 then '2'   when ansid=205973 then ''   when ansid=205974 then '2'  when ansid=205975 then '1' when ansid=205976 then '1' when ansid=205977 then '1' when ansid=205978 then '1' when ansid=205979 then '1' when ansid=205980 then 'During visit, big zip lock bags were not supplied by Punjab SACS' when ansid=205981 then 'No' when ansid=205982 then 'HSS staff is first time conducting surveillance. They were trained again at supervision time.' when ansid=205983 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.39.43.109',\n\t\t\t\t\t\t\t\tmodifiedby =471,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 12:35:39'\n\t\t\t\t\t\t\tWHERE ansid in ('205928','205929','205930','205931','205932','205933','205934','205935','205936','205937','205938','205939','205940','205941','205942','205943','205944','205945','205946','205947','205948','205949','205950','205951','205952','205953','205954','205955','205956','205957','205958','205959','205960','205961','205962','205963','205964','205965','205966','205967','205968','205969','205970','205971','205972','205973','205974','205975','205976','205977','205978','205979','205980','205981','205982','205983')"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE supvisstepid = '10981'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE visitfeedback SET `feedback` = 'No', `recommendation` = 'No', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE visitfeedbackid = '10741'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE visitfeedbackid = '10742'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE visitfeedbackid = '10743'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE visitfeedbackid = '10744'"}
{"userId":"471","date":"2021-03-27 12:35:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.39.43.109', `modifiedby` = '471', `modifieddate` = '2021-03-27 12:35:39' WHERE visitfeedbackid = '10745'"}
{"userId":"75","date":"2021-03-27 13:23:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('75', '117.197.157.167', '2021-03-27 13:23:08')"}
{"userId":"403","date":"2021-03-27 14:54:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('403', '27.56.208.124', '2021-03-27 14:54:44')"}
{"userId":"403","date":"2021-03-27 14:55:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1304', '2021-03-27', '403', '27.56.208.124', '403', '2021-03-27 14:55:36')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1304', '2597', '403', '2021-03-27', '1', '27.56.208.124', '403', '2021-03-27 14:55:44', '', '')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2194', '0', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2194', '1', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2194', '2', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2194', '3', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2194', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2194', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2194', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2194', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:55:44","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2194', '27.56.208.124', '403', '2021-03-27 14:55:44')"}
{"userId":"403","date":"2021-03-27 14:56:20","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1305', '2021-03-27', '403', '27.56.208.124', '403', '2021-03-27 14:56:20')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1305', '2598', '403', '2021-03-27', '1', '27.56.208.124', '403', '2021-03-27 14:56:52', '', '')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2195', '0', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2195', '1', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2195', '2', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2195', '3', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2195', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2195', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2195', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2195', '', '', 'Array', '', 'Array', '', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"403","date":"2021-03-27 14:56:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2195', '27.56.208.124', '403', '2021-03-27 14:56:52')"}
{"userId":"207","date":"2021-03-27 15:19:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('207', '117.201.157.107', '2021-03-27 15:19:18')"}
{"userId":"207","date":"2021-03-27 15:20:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('954', '2021-03-27', '207', '117.201.157.107', '207', '2021-03-27 15:20:08')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('954', '2599', '207', '2021-03-27', '1', '117.201.157.107', '207', '2021-03-27 15:20:13', '', '')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2196', '0', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2196', '1', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2196', '2', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2196', '3', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2196', '4', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2196', '', '', 'Array', '', 'Array', '', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2196', '', '', 'Array', '', 'Array', '', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2196', '', '', 'Array', '', 'Array', '', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2196', '', '', 'Array', '', 'Array', '', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:20:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2196', '117.201.157.107', '207', '2021-03-27 15:20:13')"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE sitesupervision SET `siteid` = '954', `userid` = '207', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '301', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2196'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sankarlal Jain', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '6', `istrained` = '0', `remarks` = 'Off', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE onssid = '9112'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Manasi Behera', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE onssid = '9113'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Laba Kumar Rout', `staffdesigid` = '', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE onssid = '9114'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE onssid = '9115'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206096 then '' when ansid=206097 then '' when ansid=206098 then '' when ansid=206099 then '' when ansid=206100 then ''  when ansid=206101 then ''   when ansid=206102 then ''  when ansid=206145 then '' when ansid=206147 then '' when ansid=206149 then '' when ansid=206151 then '' when ansid=206153 then '' when ansid=206155 then '' when ansid=206156 then '' when ansid=206157 then '' when ansid=206158 then ''  when ansid=206159 then ''   when ansid=206160 then ''  when ansid=206161 then ''  when ansid=206162 then ''   when ansid=206163 then ''   when ansid=206164 then ''   when ansid=206165 then ''  when ansid=206166 then '' when ansid=206167 then '' when ansid=206168 then ''  when ansid=206169 then ''   when ansid=206170 then ''   when ansid=206171 then ''   when ansid=206172 then ''  when ansid=206173 then ''  when ansid=206174 then ''   when ansid=206175 then ''  when ansid=206176 then '' when ansid=206177 then '' when ansid=206178 then '' when ansid=206179 then '' when ansid=206180 then '' when ansid=206181 then '' when ansid=206182 then '' when ansid=206183 then '' when ansid=206184 then ''  when ansid=206185 then ''   when ansid=206186 then ''   when ansid=206187 then ''   when ansid=206188 then ''  when ansid=206189 then '' when ansid=206190 then ''  when ansid=206191 then ''   when ansid=206192 then ''  when ansid=206193 then '' when ansid=206194 then '' when ansid=206195 then '' when ansid=206196 then '' when ansid=206197 then '' when ansid=206198 then '' when ansid=206199 then '' when ansid=206200 then '' when ansid=206201 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.201.157.107',\n\t\t\t\t\t\t\t\tmodifiedby =207,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 15:23:36'\n\t\t\t\t\t\t\tWHERE ansid in ('206096','206097','206098','206099','206100','206101','206102','206145','206147','206149','206151','206153','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201')"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE supvisstepid = '10990'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE visitfeedbackid = '10756'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE visitfeedbackid = '10757'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE visitfeedbackid = '10758'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE visitfeedbackid = '10759'"}
{"userId":"207","date":"2021-03-27 15:23:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:23:36' WHERE visitfeedbackid = '10760'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE sitesupervision SET `siteid` = '954', `userid` = '207', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '301', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2196'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sankarlal Jain', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '6', `istrained` = '0', `remarks` = 'Off', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE onssid = '9112'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Manasi Behera', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE onssid = '9113'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Laba Kumar Rout', `staffdesigid` = '', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE onssid = '9114'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE onssid = '9115'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206096 then '1' when ansid=206097 then '1' when ansid=206098 then '1' when ansid=206099 then '' when ansid=206100 then ''  when ansid=206101 then ''   when ansid=206102 then '1'  when ansid=206145 then '' when ansid=206147 then '' when ansid=206149 then '' when ansid=206151 then '' when ansid=206153 then '' when ansid=206155 then '' when ansid=206156 then '' when ansid=206157 then '' when ansid=206158 then ''  when ansid=206159 then ''   when ansid=206160 then ''  when ansid=206161 then ''  when ansid=206162 then ''   when ansid=206163 then ''   when ansid=206164 then ''   when ansid=206165 then ''  when ansid=206166 then '' when ansid=206167 then '' when ansid=206168 then ''  when ansid=206169 then ''   when ansid=206170 then ''   when ansid=206171 then ''   when ansid=206172 then ''  when ansid=206173 then ''  when ansid=206174 then ''   when ansid=206175 then ''  when ansid=206176 then '' when ansid=206177 then '' when ansid=206178 then '' when ansid=206179 then '' when ansid=206180 then '' when ansid=206181 then '' when ansid=206182 then '' when ansid=206183 then '' when ansid=206184 then ''  when ansid=206185 then ''   when ansid=206186 then ''   when ansid=206187 then ''   when ansid=206188 then ''  when ansid=206189 then '' when ansid=206190 then ''  when ansid=206191 then ''   when ansid=206192 then ''  when ansid=206193 then '' when ansid=206194 then '' when ansid=206195 then '' when ansid=206196 then '' when ansid=206197 then '' when ansid=206198 then '' when ansid=206199 then '' when ansid=206200 then '' when ansid=206201 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.201.157.107',\n\t\t\t\t\t\t\t\tmodifiedby =207,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 15:28:13'\n\t\t\t\t\t\t\tWHERE ansid in ('206096','206097','206098','206099','206100','206101','206102','206145','206147','206149','206151','206153','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201')"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE supvisstepid = '10991'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE visitfeedbackid = '10756'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE visitfeedbackid = '10757'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE visitfeedbackid = '10758'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE visitfeedbackid = '10759'"}
{"userId":"207","date":"2021-03-27 15:28:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:13' WHERE visitfeedbackid = '10760'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE sitesupervision SET `siteid` = '954', `userid` = '207', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '301', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2196'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sankarlal Jain', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '6', `istrained` = '0', `remarks` = 'Off', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE onssid = '9112'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Manasi Behera', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE onssid = '9113'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Laba Kumar Rout', `staffdesigid` = '', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE onssid = '9114'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE onssid = '9115'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206096 then '1' when ansid=206097 then '1' when ansid=206098 then '1' when ansid=206099 then '' when ansid=206100 then ''  when ansid=206101 then ''   when ansid=206102 then '1'  when ansid=206145 then '1' when ansid=206147 then '1' when ansid=206149 then '1' when ansid=206151 then '3' when ansid=206153 then '1' when ansid=206155 then '' when ansid=206156 then '' when ansid=206157 then '' when ansid=206158 then ''  when ansid=206159 then ''   when ansid=206160 then ''  when ansid=206161 then ''  when ansid=206162 then ''   when ansid=206163 then ''   when ansid=206164 then ''   when ansid=206165 then ''  when ansid=206166 then '' when ansid=206167 then '' when ansid=206168 then ''  when ansid=206169 then ''   when ansid=206170 then ''   when ansid=206171 then ''   when ansid=206172 then ''  when ansid=206173 then ''  when ansid=206174 then ''   when ansid=206175 then ''  when ansid=206176 then '' when ansid=206177 then '' when ansid=206178 then '' when ansid=206179 then '' when ansid=206180 then '' when ansid=206181 then '' when ansid=206182 then '' when ansid=206183 then '' when ansid=206184 then ''  when ansid=206185 then ''   when ansid=206186 then ''   when ansid=206187 then ''   when ansid=206188 then ''  when ansid=206189 then '' when ansid=206190 then ''  when ansid=206191 then ''   when ansid=206192 then ''  when ansid=206193 then '' when ansid=206194 then '' when ansid=206195 then '' when ansid=206196 then '' when ansid=206197 then '' when ansid=206198 then '' when ansid=206199 then '' when ansid=206200 then '' when ansid=206201 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.201.157.107',\n\t\t\t\t\t\t\t\tmodifiedby =207,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 15:28:29'\n\t\t\t\t\t\t\tWHERE ansid in ('206096','206097','206098','206099','206100','206101','206102','206145','206147','206149','206151','206153','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201')"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE supvisstepid = '10992'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE visitfeedbackid = '10756'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE visitfeedbackid = '10757'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE visitfeedbackid = '10758'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE visitfeedbackid = '10759'"}
{"userId":"207","date":"2021-03-27 15:28:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:28:29' WHERE visitfeedbackid = '10760'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE sitesupervision SET `siteid` = '954', `userid` = '207', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '301', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2196'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sankarlal Jain', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '6', `istrained` = '0', `remarks` = 'Off', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE onssid = '9112'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Manasi Behera', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE onssid = '9113'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Laba Kumar Rout', `staffdesigid` = '', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE onssid = '9114'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE onssid = '9115'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206096 then '1' when ansid=206097 then '1' when ansid=206098 then '1' when ansid=206099 then '' when ansid=206100 then ''  when ansid=206101 then ''   when ansid=206102 then '1'  when ansid=206145 then '1' when ansid=206147 then '1' when ansid=206149 then '1' when ansid=206151 then '3' when ansid=206153 then '1' when ansid=206155 then '3' when ansid=206156 then '3' when ansid=206157 then '534' when ansid=206158 then '30'  when ansid=206159 then ''   when ansid=206160 then '1'  when ansid=206161 then '1'  when ansid=206162 then ''   when ansid=206163 then '1'   when ansid=206164 then ''   when ansid=206165 then '1'  when ansid=206166 then '8' when ansid=206167 then '1' when ansid=206168 then '1'  when ansid=206169 then 'Counseller'   when ansid=206170 then '1'   when ansid=206171 then ''   when ansid=206172 then '1'  when ansid=206173 then '1'  when ansid=206174 then ''   when ansid=206175 then '1'  when ansid=206176 then '1' when ansid=206177 then '1' when ansid=206178 then '1' when ansid=206179 then '1' when ansid=206180 then '1' when ansid=206181 then '2' when ansid=206182 then '1' when ansid=206183 then '1' when ansid=206184 then '1'  when ansid=206185 then ''   when ansid=206186 then '3'   when ansid=206187 then ''   when ansid=206188 then '1'  when ansid=206189 then '1' when ansid=206190 then '1'  when ansid=206191 then ''   when ansid=206192 then '1'  when ansid=206193 then '1' when ansid=206194 then '1' when ansid=206195 then '1' when ansid=206196 then '1' when ansid=206197 then '0' when ansid=206198 then 'Nil' when ansid=206199 then 'Dr Ganesh  RIDr Arun       SST' when ansid=206200 then 'No issues' when ansid=206201 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.201.157.107',\n\t\t\t\t\t\t\t\tmodifiedby =207,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 15:46:39'\n\t\t\t\t\t\t\tWHERE ansid in ('206096','206097','206098','206099','206100','206101','206102','206145','206147','206149','206151','206153','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201')"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE supvisstepid = '10993'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE visitfeedbackid = '10756'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE visitfeedbackid = '10757'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE visitfeedbackid = '10758'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE visitfeedbackid = '10759'"}
{"userId":"207","date":"2021-03-27 15:46:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:46:39' WHERE visitfeedbackid = '10760'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE sitesupervision SET `siteid` = '954', `userid` = '207', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '301', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2196'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sankarlal Jain', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '6', `istrained` = '0', `remarks` = 'Off', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE onssid = '9112'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Manasi Behera', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE onssid = '9113'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Laba Kumar Rout', `staffdesigid` = '', `isavailable` = '1', `exphss` = '7', `istrained` = '1', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE onssid = '9114'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE onssid = '9115'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206096 then '1' when ansid=206097 then '1' when ansid=206098 then '1' when ansid=206099 then '' when ansid=206100 then ''  when ansid=206101 then ''   when ansid=206102 then '1'  when ansid=206145 then '1' when ansid=206147 then '1' when ansid=206149 then '1' when ansid=206151 then '3' when ansid=206153 then '1' when ansid=206155 then '3' when ansid=206156 then '3' when ansid=206157 then '534' when ansid=206158 then '30'  when ansid=206159 then ''   when ansid=206160 then '1'  when ansid=206161 then '1'  when ansid=206162 then ''   when ansid=206163 then '1'   when ansid=206164 then ''   when ansid=206165 then '1'  when ansid=206166 then '8' when ansid=206167 then '1' when ansid=206168 then '1'  when ansid=206169 then 'Counseller'   when ansid=206170 then '1'   when ansid=206171 then ''   when ansid=206172 then '1'  when ansid=206173 then '1'  when ansid=206174 then ''   when ansid=206175 then '1'  when ansid=206176 then '1' when ansid=206177 then '1' when ansid=206178 then '1' when ansid=206179 then '1' when ansid=206180 then '1' when ansid=206181 then '2' when ansid=206182 then '1' when ansid=206183 then '1' when ansid=206184 then '1'  when ansid=206185 then ''   when ansid=206186 then '3'   when ansid=206187 then ''   when ansid=206188 then '1'  when ansid=206189 then '1' when ansid=206190 then '1'  when ansid=206191 then ''   when ansid=206192 then '1'  when ansid=206193 then '1' when ansid=206194 then '1' when ansid=206195 then '1' when ansid=206196 then '1' when ansid=206197 then '0' when ansid=206198 then 'Nil' when ansid=206199 then 'Dr Ganesh  RIDr Arun       SST' when ansid=206200 then 'No issues' when ansid=206201 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.201.157.107',\n\t\t\t\t\t\t\t\tmodifiedby =207,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 15:47:10'\n\t\t\t\t\t\t\tWHERE ansid in ('206096','206097','206098','206099','206100','206101','206102','206145','206147','206149','206151','206153','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201')"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE supvisstepid = '10994'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE visitfeedback SET `feedback` = 'NIL', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE visitfeedbackid = '10756'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE visitfeedbackid = '10757'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE visitfeedbackid = '10758'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE visitfeedbackid = '10759'"}
{"userId":"207","date":"2021-03-27 15:47:10","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.201.157.107', `modifiedby` = '207', `modifieddate` = '2021-03-27 15:47:10' WHERE visitfeedbackid = '10760'"}
{"userId":"407","date":"2021-03-27 23:14:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('407', '27.62.220.144', '2021-03-27 23:14:35')"}
{"userId":"407","date":"2021-03-27 23:15:09","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1306', '2021-03-27', '407', '27.62.220.144', '407', '2021-03-27 23:15:09')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1306', '2600', '407', '2021-03-27', '1', '27.62.220.144', '407', '2021-03-27 23:15:16', '', '')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2197', '0', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2197', '1', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2197', '2', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2197', '3', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2197', '', '', 'Array', '', 'Array', '', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2197', '', '', 'Array', '', 'Array', '', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2197', '', '', 'Array', '', 'Array', '', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2197', '', '', 'Array', '', 'Array', '', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:15:17","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2197', '27.62.220.144', '407', '2021-03-27 23:15:16')"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE sitesupervision SET `siteid` = '1306', `userid` = '407', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-27', `numofsamplecollected` = '06', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2197'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE onsitestaffs SET `staffname` = 'Nivedita Jaiswal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE onssid = '9116'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE onsitestaffs SET `staffname` = 'Devendra Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE onssid = '9117'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE onsitestaffs SET `staffname` = 'Ganesh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE onssid = '9118'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE onssid = '9119'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206202 then '2' when ansid=206203 then '3' when ansid=206204 then '5' when ansid=206205 then '0' when ansid=206206 then '0' when ansid=206207 then '1' when ansid=206208 then '1' when ansid=206209 then '' when ansid=206210 then '' when ansid=206211 then '' when ansid=206212 then '' when ansid=206213 then '' when ansid=206214 then '' when ansid=206215 then '' when ansid=206216 then '' when ansid=206217 then '' when ansid=206218 then '' when ansid=206219 then '' when ansid=206220 then '' when ansid=206221 then ''  when ansid=206222 then ''   when ansid=206223 then ''   when ansid=206224 then ''   when ansid=206225 then ''   when ansid=206226 then ''   when ansid=206227 then ''   when ansid=206228 then ''   when ansid=206229 then ''   when ansid=206230 then ''   when ansid=206231 then ''  when ansid=206232 then '' when ansid=206233 then '' when ansid=206234 then ''  when ansid=206235 then ''   when ansid=206236 then ''   when ansid=206237 then ''   when ansid=206238 then ''   when ansid=206239 then ''   when ansid=206240 then ''   when ansid=206241 then ''   when ansid=206242 then ''   when ansid=206243 then ''   when ansid=206244 then ''   when ansid=206245 then ''   when ansid=206246 then ''   when ansid=206247 then ''   when ansid=206248 then ''  when ansid=206249 then '' when ansid=206250 then '' when ansid=206251 then '' when ansid=206252 then '' when ansid=206253 then '' when ansid=206254 then '' when ansid=206255 then '' when ansid=206256 then '' when ansid=206257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.220.144',\n\t\t\t\t\t\t\t\tmodifiedby =407,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 23:21:09'\n\t\t\t\t\t\t\tWHERE ansid in ('206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257')"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE supvisstepid = '10995'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE visitfeedbackid = '10761'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE visitfeedbackid = '10762'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE visitfeedbackid = '10763'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE visitfeedbackid = '10764'"}
{"userId":"407","date":"2021-03-27 23:21:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:09' WHERE visitfeedbackid = '10765'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE sitesupervision SET `siteid` = '1306', `userid` = '407', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-27', `numofsamplecollected` = '06', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2197'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE onsitestaffs SET `staffname` = 'Nivedita Jaiswal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE onssid = '9116'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE onsitestaffs SET `staffname` = 'Devendra Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE onssid = '9117'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE onsitestaffs SET `staffname` = 'Ganesh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE onssid = '9118'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE onssid = '9119'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206202 then '2' when ansid=206203 then '3' when ansid=206204 then '5' when ansid=206205 then '0' when ansid=206206 then '0' when ansid=206207 then '1' when ansid=206208 then '1' when ansid=206209 then '1' when ansid=206210 then '1' when ansid=206211 then '1' when ansid=206212 then '1' when ansid=206213 then '1' when ansid=206214 then '1' when ansid=206215 then '1' when ansid=206216 then '1' when ansid=206217 then '1' when ansid=206218 then '' when ansid=206219 then '' when ansid=206220 then '' when ansid=206221 then ''  when ansid=206222 then ''   when ansid=206223 then ''   when ansid=206224 then ''   when ansid=206225 then ''   when ansid=206226 then ''   when ansid=206227 then ''   when ansid=206228 then ''   when ansid=206229 then ''   when ansid=206230 then ''   when ansid=206231 then ''  when ansid=206232 then '' when ansid=206233 then '' when ansid=206234 then ''  when ansid=206235 then ''   when ansid=206236 then ''   when ansid=206237 then ''   when ansid=206238 then ''   when ansid=206239 then ''   when ansid=206240 then ''   when ansid=206241 then ''   when ansid=206242 then ''   when ansid=206243 then ''   when ansid=206244 then ''   when ansid=206245 then ''   when ansid=206246 then ''   when ansid=206247 then ''   when ansid=206248 then ''  when ansid=206249 then '' when ansid=206250 then '' when ansid=206251 then '' when ansid=206252 then '' when ansid=206253 then '' when ansid=206254 then '' when ansid=206255 then '' when ansid=206256 then '' when ansid=206257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.220.144',\n\t\t\t\t\t\t\t\tmodifiedby =407,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 23:21:58'\n\t\t\t\t\t\t\tWHERE ansid in ('206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257')"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE supvisstepid = '10996'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE visitfeedbackid = '10761'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE visitfeedbackid = '10762'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE visitfeedbackid = '10763'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE visitfeedbackid = '10764'"}
{"userId":"407","date":"2021-03-27 23:21:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:21:58' WHERE visitfeedbackid = '10765'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE sitesupervision SET `siteid` = '1306', `userid` = '407', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-27', `numofsamplecollected` = '06', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2197'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE onsitestaffs SET `staffname` = 'Nivedita Jaiswal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE onssid = '9116'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE onsitestaffs SET `staffname` = 'Devendra Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE onssid = '9117'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE onsitestaffs SET `staffname` = 'Ganesh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE onssid = '9118'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE onssid = '9119'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206202 then '2' when ansid=206203 then '3' when ansid=206204 then '5' when ansid=206205 then '0' when ansid=206206 then '0' when ansid=206207 then '1' when ansid=206208 then '1' when ansid=206209 then '1' when ansid=206210 then '1' when ansid=206211 then '1' when ansid=206212 then '1' when ansid=206213 then '1' when ansid=206214 then '1' when ansid=206215 then '1' when ansid=206216 then '1' when ansid=206217 then '1' when ansid=206218 then '06' when ansid=206219 then '03' when ansid=206220 then '02' when ansid=206221 then '1'  when ansid=206222 then ''   when ansid=206223 then '1'   when ansid=206224 then ''   when ansid=206225 then '1'   when ansid=206226 then ''   when ansid=206227 then '1'   when ansid=206228 then ''   when ansid=206229 then '1'   when ansid=206230 then ''   when ansid=206231 then '1'  when ansid=206232 then '1' when ansid=206233 then '1' when ansid=206234 then '1'  when ansid=206235 then ''   when ansid=206236 then '1'   when ansid=206237 then ''   when ansid=206238 then '1'   when ansid=206239 then ''   when ansid=206240 then '1'   when ansid=206241 then ''   when ansid=206242 then '1'   when ansid=206243 then ''   when ansid=206244 then '1'   when ansid=206245 then ''   when ansid=206246 then '2'   when ansid=206247 then ''   when ansid=206248 then '2'  when ansid=206249 then '1' when ansid=206250 then '1' when ansid=206251 then '1' when ansid=206252 then '1' when ansid=206253 then '1' when ansid=206254 then '1) no problem transporting 02    ) no required to surveillance materials' when ansid=206255 then 'HSS Register not data fill  & no  proper register  maintained according formats .' when ansid=206256 then 'Recommended to Blood collect to proper DBS Card 5 pick proper fill .' when ansid=206257 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.220.144',\n\t\t\t\t\t\t\t\tmodifiedby =407,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 23:31:14'\n\t\t\t\t\t\t\tWHERE ansid in ('206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257')"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE supvisstepid = '10997'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE visitfeedbackid = '10761'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE visitfeedbackid = '10762'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE visitfeedbackid = '10763'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE visitfeedbackid = '10764'"}
{"userId":"407","date":"2021-03-27 23:31:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:14' WHERE visitfeedbackid = '10765'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE sitesupervision SET `siteid` = '1306', `userid` = '407', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-27', `numofsamplecollected` = '06', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2197'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE onsitestaffs SET `staffname` = 'Nivedita Jaiswal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE onssid = '9116'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE onsitestaffs SET `staffname` = 'Devendra Pandey', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE onssid = '9117'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE onsitestaffs SET `staffname` = 'Ganesh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE onssid = '9118'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE onssid = '9119'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206202 then '2' when ansid=206203 then '3' when ansid=206204 then '5' when ansid=206205 then '0' when ansid=206206 then '0' when ansid=206207 then '1' when ansid=206208 then '1' when ansid=206209 then '1' when ansid=206210 then '1' when ansid=206211 then '1' when ansid=206212 then '1' when ansid=206213 then '1' when ansid=206214 then '1' when ansid=206215 then '1' when ansid=206216 then '1' when ansid=206217 then '1' when ansid=206218 then '06' when ansid=206219 then '03' when ansid=206220 then '02' when ansid=206221 then '1'  when ansid=206222 then ''   when ansid=206223 then '1'   when ansid=206224 then ''   when ansid=206225 then '1'   when ansid=206226 then ''   when ansid=206227 then '1'   when ansid=206228 then ''   when ansid=206229 then '1'   when ansid=206230 then ''   when ansid=206231 then '1'  when ansid=206232 then '1' when ansid=206233 then '1' when ansid=206234 then '1'  when ansid=206235 then ''   when ansid=206236 then '1'   when ansid=206237 then ''   when ansid=206238 then '1'   when ansid=206239 then ''   when ansid=206240 then '1'   when ansid=206241 then ''   when ansid=206242 then '1'   when ansid=206243 then ''   when ansid=206244 then '1'   when ansid=206245 then ''   when ansid=206246 then '2'   when ansid=206247 then ''   when ansid=206248 then '2'  when ansid=206249 then '1' when ansid=206250 then '1' when ansid=206251 then '1' when ansid=206252 then '1' when ansid=206253 then '1' when ansid=206254 then '1) no problem transporting 02    ) no required to surveillance materials' when ansid=206255 then 'HSS Register not data fill  & no  proper register  maintained according formats .' when ansid=206256 then 'Recommended to Blood collect to proper DBS Card 5 pick proper fill .' when ansid=206257 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '27.62.220.144',\n\t\t\t\t\t\t\t\tmodifiedby =407,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-03-27 23:31:26'\n\t\t\t\t\t\t\tWHERE ansid in ('206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257')"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE supvisstepid = '10998'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE visitfeedbackid = '10761'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE visitfeedbackid = '10762'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE visitfeedbackid = '10763'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE visitfeedbackid = '10764'"}
{"userId":"407","date":"2021-03-27 23:31:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '27.62.220.144', `modifiedby` = '407', `modifieddate` = '2021-03-27 23:31:26' WHERE visitfeedbackid = '10765'"}
{"userId":"407","date":"2021-03-27 23:31:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('407', '27.62.220.144', '2021-03-27 23:31:57')"}
{"userId":"310","date":"2021-03-27 23:53:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '157.33.26.170', '2021-03-27 23:53:27')"}
{"userId":"310","date":"2021-03-27 23:57:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('310', '157.33.26.170', '2021-03-27 23:57:57')"}
{"userId":"310","date":"2021-03-27 23:59:02","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1240', '2021-02-26', '310', '157.33.26.170', '310', '2021-03-27 23:59:02')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1240', '2601', '310', '2021-03-27', '1', '157.33.26.170', '310', '2021-03-27 23:59:07', '', '')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2198', '0', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2198', '1', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2198', '2', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2198', '3', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2198', '', '', 'Array', '', 'Array', '', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2198', '', '', 'Array', '', 'Array', '', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2198', '', '', 'Array', '', 'Array', '', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2198', '', '', 'Array', '', 'Array', '', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}
{"userId":"310","date":"2021-03-27 23:59:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2198', '157.33.26.170', '310', '2021-03-27 23:59:07')"}