{"userId":"542","date":"2023-02-04 09:50:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('542', '14.139.206.130', '2023-02-04 09:50:02')"} {"userId":"543","date":"2023-02-04 11:22:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '14.139.206.130', '2023-02-04 11:22:50')"} {"userId":"30","date":"2023-02-04 11:28:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('30', '110.235.232.63', '2023-02-04 11:28:17')"} {"userId":"27","date":"2023-02-04 11:30:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('27', '110.235.232.63', '2023-02-04 11:30:47')"} {"userId":"680","date":"2023-02-04 22:34:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '49.37.73.172', '2023-02-04 22:34:40')"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE sitesupervision SET `siteid` = '336', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '109', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2759'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rita Kashyap', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11364'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kamakhya Narayan Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11365'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Narendra Das', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11366'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11367'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260782 then '1' when ansid=260783 then '1' when ansid=260784 then '2' when ansid=260785 then '2' when ansid=260786 then '1' when ansid=260787 then 'ICTC' when ansid=260788 then '1' when ansid=260888 then '1' when ansid=260889 then '1' when ansid=260831 then '1' when ansid=260833 then '0' when ansid=260835 then '0' when ansid=260837 then '3' when ansid=260839 then '1' when ansid=260841 then '' when ansid=260842 then '' when ansid=260843 then '' when ansid=260844 then '' when ansid=260845 then '' when ansid=260846 then '' when ansid=260847 then '' when ansid=260848 then '' when ansid=260849 then '' when ansid=260850 then '' when ansid=260851 then '' when ansid=260852 then '' when ansid=260853 then '' when ansid=260854 then '' when ansid=260855 then '' when ansid=260856 then '' when ansid=260857 then '' when ansid=260858 then '' when ansid=260859 then '' when ansid=260860 then '' when ansid=260861 then '' when ansid=260862 then '' when ansid=260863 then '' when ansid=260864 then '' when ansid=260865 then '' when ansid=260866 then '' when ansid=260867 then '' when ansid=260868 then '' when ansid=260869 then '' when ansid=260870 then '' when ansid=260871 then '' when ansid=260872 then '' when ansid=260873 then '' when ansid=260874 then '' when ansid=260875 then '' when ansid=260876 then '' when ansid=260877 then '' when ansid=260878 then '' when ansid=260879 then '' when ansid=260880 then '' when ansid=260881 then '' when ansid=260882 then '' when ansid=260883 then '' when ansid=260884 then '' when ansid=260885 then '' when ansid=260886 then '' when ansid=260887 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 22:36:14'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260782','260783','260784','260785','260786','260787','260788','260888','260889','260831','260833','260835','260837','260839','260841','260842','260843','260844','260845','260846','260847','260848','260849','260850','260851','260852','260853','260854','260855','260856','260857','260858','260859','260860','260861','260862','260863','260864','260865','260866','260867','260868','260869','260870','260871','260872','260873','260874','260875','260876','260877','260878','260879','260880','260881','260882','260883','260884','260885','260886','260887')"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE supvisstepid = '13610'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13571'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13572'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13573'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13574'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13575'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE sitesupervision SET `siteid` = '336', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '109', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2759'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rita Kashyap', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11364'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kamakhya Narayan Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11365'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Narendra Das', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11366'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE onssid = '11367'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260782 then '1' when ansid=260783 then '1' when ansid=260784 then '2' when ansid=260785 then '2' when ansid=260786 then '1' when ansid=260787 then 'ICTC' when ansid=260788 then '1' when ansid=260888 then '1' when ansid=260889 then '1' when ansid=260831 then '1' when ansid=260833 then '0' when ansid=260835 then '0' when ansid=260837 then '3' when ansid=260839 then '1' when ansid=260841 then '' when ansid=260842 then '' when ansid=260843 then '' when ansid=260844 then '' when ansid=260845 then '' when ansid=260846 then '' when ansid=260847 then '' when ansid=260848 then '' when ansid=260849 then '' when ansid=260850 then '' when ansid=260851 then '' when ansid=260852 then '' when ansid=260853 then '' when ansid=260854 then '' when ansid=260855 then '' when ansid=260856 then '' when ansid=260857 then '' when ansid=260858 then '' when ansid=260859 then '' when ansid=260860 then '' when ansid=260861 then '' when ansid=260862 then '' when ansid=260863 then '' when ansid=260864 then '' when ansid=260865 then '' when ansid=260866 then '' when ansid=260867 then '' when ansid=260868 then '' when ansid=260869 then '' when ansid=260870 then '' when ansid=260871 then '' when ansid=260872 then '' when ansid=260873 then '' when ansid=260874 then '' when ansid=260875 then '' when ansid=260876 then '' when ansid=260877 then '' when ansid=260878 then '' when ansid=260879 then '' when ansid=260880 then '' when ansid=260881 then '' when ansid=260882 then '' when ansid=260883 then '' when ansid=260884 then '' when ansid=260885 then '' when ansid=260886 then '' when ansid=260887 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 22:36:14'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260782','260783','260784','260785','260786','260787','260788','260888','260889','260831','260833','260835','260837','260839','260841','260842','260843','260844','260845','260846','260847','260848','260849','260850','260851','260852','260853','260854','260855','260856','260857','260858','260859','260860','260861','260862','260863','260864','260865','260866','260867','260868','260869','260870','260871','260872','260873','260874','260875','260876','260877','260878','260879','260880','260881','260882','260883','260884','260885','260886','260887')"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE supvisstepid = '13609'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13571'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13572'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13573'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13574'"} {"userId":"680","date":"2023-02-04 22:36:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:36:14' WHERE visitfeedbackid = '13575'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE sitesupervision SET `siteid` = '336', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '109', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2759'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rita Kashyap', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE onssid = '11364'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kamakhya Narayan Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE onssid = '11365'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Narendra Das', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE onssid = '11366'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE onssid = '11367'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260782 then '1' when ansid=260783 then '1' when ansid=260784 then '2' when ansid=260785 then '2' when ansid=260786 then '1' when ansid=260787 then 'ICTC' when ansid=260788 then '1' when ansid=260888 then '1' when ansid=260889 then '1' when ansid=260831 then '1' when ansid=260833 then '0' when ansid=260835 then '0' when ansid=260837 then '3' when ansid=260839 then '1' when ansid=260841 then '0' when ansid=260842 then '0' when ansid=260843 then '134' when ansid=260844 then '21' when ansid=260845 then '' when ansid=260846 then '1' when ansid=260847 then '1' when ansid=260848 then '' when ansid=260849 then '1' when ansid=260850 then '' when ansid=260851 then '1' when ansid=260852 then '15' when ansid=260853 then '3' when ansid=260854 then '1' when ansid=260855 then 'counsellor' when ansid=260856 then '1' when ansid=260857 then '' when ansid=260858 then '1' when ansid=260859 then '1' when ansid=260860 then '' when ansid=260861 then '1' when ansid=260862 then '3' when ansid=260863 then '1' when ansid=260864 then '1' when ansid=260865 then '1' when ansid=260866 then '2' when ansid=260867 then '2' when ansid=260868 then '1' when ansid=260869 then '1' when ansid=260870 then '1' when ansid=260871 then '' when ansid=260872 then '3' when ansid=260873 then '' when ansid=260874 then '1' when ansid=260875 then '1' when ansid=260876 then '1' when ansid=260877 then '' when ansid=260878 then '1' when ansid=260879 then '1' when ansid=260880 then '1' when ansid=260881 then '1' when ansid=260882 then '1' when ansid=260883 then '0' when ansid=260884 then 'NO' when ansid=260885 then 'NO' when ansid=260886 then 'HSS activity was not taking place on the day of visit due to leave of Lab Technician' when ansid=260887 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 22:44:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260782','260783','260784','260785','260786','260787','260788','260888','260889','260831','260833','260835','260837','260839','260841','260842','260843','260844','260845','260846','260847','260848','260849','260850','260851','260852','260853','260854','260855','260856','260857','260858','260859','260860','260861','260862','260863','260864','260865','260866','260867','260868','260869','260870','260871','260872','260873','260874','260875','260876','260877','260878','260879','260880','260881','260882','260883','260884','260885','260886','260887')"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE supvisstepid = '13612'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE visitfeedbackid = '13571'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE visitfeedbackid = '13572'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE visitfeedbackid = '13573'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE visitfeedbackid = '13574'"} {"userId":"680","date":"2023-02-04 22:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:44:33' WHERE visitfeedbackid = '13575'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE sitesupervision SET `siteid` = '336', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-09', `numofsamplecollected` = '109', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24', `locationtype` = '1', `establishmentyear` = '2012', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2759'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rita Kashyap', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE onssid = '11364'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kamakhya Narayan Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE onssid = '11365'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Narendra Das', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '10', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE onssid = '11366'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE onssid = '11367'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260782 then '1' when ansid=260783 then '1' when ansid=260784 then '2' when ansid=260785 then '2' when ansid=260786 then '1' when ansid=260787 then 'ICTC' when ansid=260788 then '1' when ansid=260888 then '1' when ansid=260889 then '1' when ansid=260831 then '1' when ansid=260833 then '0' when ansid=260835 then '0' when ansid=260837 then '3' when ansid=260839 then '1' when ansid=260841 then '0' when ansid=260842 then '0' when ansid=260843 then '134' when ansid=260844 then '21' when ansid=260845 then '' when ansid=260846 then '1' when ansid=260847 then '1' when ansid=260848 then '' when ansid=260849 then '1' when ansid=260850 then '' when ansid=260851 then '1' when ansid=260852 then '15' when ansid=260853 then '3' when ansid=260854 then '1' when ansid=260855 then 'counsellor' when ansid=260856 then '1' when ansid=260857 then '' when ansid=260858 then '1' when ansid=260859 then '1' when ansid=260860 then '' when ansid=260861 then '1' when ansid=260862 then '3' when ansid=260863 then '1' when ansid=260864 then '1' when ansid=260865 then '1' when ansid=260866 then '2' when ansid=260867 then '2' when ansid=260868 then '1' when ansid=260869 then '1' when ansid=260870 then '1' when ansid=260871 then '' when ansid=260872 then '3' when ansid=260873 then '' when ansid=260874 then '1' when ansid=260875 then '1' when ansid=260876 then '1' when ansid=260877 then '' when ansid=260878 then '1' when ansid=260879 then '1' when ansid=260880 then '1' when ansid=260881 then '1' when ansid=260882 then '1' when ansid=260883 then '0' when ansid=260884 then 'NO' when ansid=260885 then 'NO' when ansid=260886 then 'HSS activity was not taking place on the day of visit due to leave of Lab Technician' when ansid=260887 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 22:58:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260782','260783','260784','260785','260786','260787','260788','260888','260889','260831','260833','260835','260837','260839','260841','260842','260843','260844','260845','260846','260847','260848','260849','260850','260851','260852','260853','260854','260855','260856','260857','260858','260859','260860','260861','260862','260863','260864','260865','260866','260867','260868','260869','260870','260871','260872','260873','260874','260875','260876','260877','260878','260879','260880','260881','260882','260883','260884','260885','260886','260887')"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE supvisstepid = '13613'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE visitfeedback SET `feedback` = '1. Biomedical waste management part was not up to mark.', `recommendation` = '1. There was few error in the data form which was made clear on spot', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE visitfeedbackid = '13571'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE visitfeedback SET `feedback` = '2. Lab Technician was on leave for 4 days. Therefore HSS activity was not taking place', `recommendation` = '2. Doubts about biomedical waste management cleared', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE visitfeedbackid = '13572'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE visitfeedback SET `feedback` = '3. ICTC was about 1km away in different building from the ANC clinic where blood sample were being collected', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE visitfeedbackid = '13573'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE visitfeedbackid = '13574'"} {"userId":"680","date":"2023-02-04 22:58:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 22:58:24' WHERE visitfeedbackid = '13575'"} {"userId":"680","date":"2023-02-04 23:08:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('323', '2023-01-31', '680', '49.37.73.172', '680', '2023-02-04 23:08:08')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('323', '3224', '680', '2023-02-04', '1', '49.37.73.172', '680', '2023-02-04 23:08:18', '', '')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2760', '0', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2760', '1', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2760', '2', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2760', '3', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2760', '4', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2760', '', '', 'Array', '', 'Array', '', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2760', '', '', 'Array', '', 'Array', '', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2760', '', '', 'Array', '', 'Array', '', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2760', '', '', 'Array', '', 'Array', '', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:08:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2760', '49.37.73.172', '680', '2023-02-04 23:08:18')"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE sitesupervision SET `siteid` = '323', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '208', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2760'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shilpa Tigga', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE onssid = '11368'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Yugant Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE onssid = '11369'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dhaneshwar Mahto', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE onssid = '11370'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE onssid = '11371'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260890 then '' when ansid=260891 then '' when ansid=260892 then '' when ansid=260893 then '' when ansid=260894 then '' when ansid=260895 then '' when ansid=260896 then '' when ansid=260996 then '' when ansid=260997 then '' when ansid=260939 then '' when ansid=260941 then '' when ansid=260943 then '' when ansid=260945 then '' when ansid=260947 then '' when ansid=260949 then '' when ansid=260950 then '' when ansid=260951 then '' when ansid=260952 then '' when ansid=260953 then '' when ansid=260954 then '' when ansid=260955 then '' when ansid=260956 then '' when ansid=260957 then '' when ansid=260958 then '' when ansid=260959 then '' when ansid=260960 then '' when ansid=260961 then '' when ansid=260962 then '' when ansid=260963 then '' when ansid=260964 then '' when ansid=260965 then '' when ansid=260966 then '' when ansid=260967 then '' when ansid=260968 then '' when ansid=260969 then '' when ansid=260970 then '' when ansid=260971 then '' when ansid=260972 then '' when ansid=260973 then '' when ansid=260974 then '' when ansid=260975 then '' when ansid=260976 then '' when ansid=260977 then '' when ansid=260978 then '' when ansid=260979 then '' when ansid=260980 then '' when ansid=260981 then '' when ansid=260982 then '' when ansid=260983 then '' when ansid=260984 then '' when ansid=260985 then '' when ansid=260986 then '' when ansid=260987 then '' when ansid=260988 then '' when ansid=260989 then '' when ansid=260990 then '' when ansid=260991 then '' when ansid=260992 then '' when ansid=260993 then '' when ansid=260994 then '' when ansid=260995 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 23:12:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260890','260891','260892','260893','260894','260895','260896','260996','260997','260939','260941','260943','260945','260947','260949','260950','260951','260952','260953','260954','260955','260956','260957','260958','260959','260960','260961','260962','260963','260964','260965','260966','260967','260968','260969','260970','260971','260972','260973','260974','260975','260976','260977','260978','260979','260980','260981','260982','260983','260984','260985','260986','260987','260988','260989','260990','260991','260992','260993','260994','260995')"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE supvisstepid = '13614'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE visitfeedbackid = '13576'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE visitfeedbackid = '13577'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE visitfeedbackid = '13578'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE visitfeedbackid = '13579'"} {"userId":"680","date":"2023-02-04 23:12:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:12:19' WHERE visitfeedbackid = '13580'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE sitesupervision SET `siteid` = '323', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '208', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2760'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shilpa Tigga', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE onssid = '11368'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Yugant Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE onssid = '11369'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dhaneshwar Mahto', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE onssid = '11370'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE onssid = '11371'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260890 then '1' when ansid=260891 then '1' when ansid=260892 then '2' when ansid=260893 then '1' when ansid=260894 then '' when ansid=260895 then 'ICTC' when ansid=260896 then '1' when ansid=260996 then '1' when ansid=260997 then '1' when ansid=260939 then '' when ansid=260941 then '' when ansid=260943 then '' when ansid=260945 then '' when ansid=260947 then '' when ansid=260949 then '' when ansid=260950 then '' when ansid=260951 then '' when ansid=260952 then '' when ansid=260953 then '' when ansid=260954 then '' when ansid=260955 then '' when ansid=260956 then '' when ansid=260957 then '' when ansid=260958 then '' when ansid=260959 then '' when ansid=260960 then '' when ansid=260961 then '' when ansid=260962 then '' when ansid=260963 then '' when ansid=260964 then '' when ansid=260965 then '' when ansid=260966 then '' when ansid=260967 then '' when ansid=260968 then '' when ansid=260969 then '' when ansid=260970 then '' when ansid=260971 then '' when ansid=260972 then '' when ansid=260973 then '' when ansid=260974 then '' when ansid=260975 then '' when ansid=260976 then '' when ansid=260977 then '' when ansid=260978 then '' when ansid=260979 then '' when ansid=260980 then '' when ansid=260981 then '' when ansid=260982 then '' when ansid=260983 then '' when ansid=260984 then '' when ansid=260985 then '' when ansid=260986 then '' when ansid=260987 then '' when ansid=260988 then '' when ansid=260989 then '' when ansid=260990 then '' when ansid=260991 then '' when ansid=260992 then '' when ansid=260993 then '' when ansid=260994 then '' when ansid=260995 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 23:13:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260890','260891','260892','260893','260894','260895','260896','260996','260997','260939','260941','260943','260945','260947','260949','260950','260951','260952','260953','260954','260955','260956','260957','260958','260959','260960','260961','260962','260963','260964','260965','260966','260967','260968','260969','260970','260971','260972','260973','260974','260975','260976','260977','260978','260979','260980','260981','260982','260983','260984','260985','260986','260987','260988','260989','260990','260991','260992','260993','260994','260995')"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE supvisstepid = '13615'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE visitfeedbackid = '13576'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE visitfeedbackid = '13577'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE visitfeedbackid = '13578'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE visitfeedbackid = '13579'"} {"userId":"680","date":"2023-02-04 23:13:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:13:36' WHERE visitfeedbackid = '13580'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE sitesupervision SET `siteid` = '323', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '208', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2760'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shilpa Tigga', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE onssid = '11368'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Yugant Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE onssid = '11369'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dhaneshwar Mahto', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE onssid = '11370'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE onssid = '11371'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260890 then '1' when ansid=260891 then '1' when ansid=260892 then '2' when ansid=260893 then '1' when ansid=260894 then '' when ansid=260895 then 'ICTC' when ansid=260896 then '1' when ansid=260996 then '1' when ansid=260997 then '1' when ansid=260939 then '1' when ansid=260941 then '0' when ansid=260943 then '0' when ansid=260945 then '03' when ansid=260947 then '1' when ansid=260949 then '' when ansid=260950 then '' when ansid=260951 then '' when ansid=260952 then '' when ansid=260953 then '' when ansid=260954 then '' when ansid=260955 then '' when ansid=260956 then '' when ansid=260957 then '' when ansid=260958 then '' when ansid=260959 then '' when ansid=260960 then '' when ansid=260961 then '' when ansid=260962 then '' when ansid=260963 then '' when ansid=260964 then '' when ansid=260965 then '' when ansid=260966 then '' when ansid=260967 then '' when ansid=260968 then '' when ansid=260969 then '' when ansid=260970 then '' when ansid=260971 then '' when ansid=260972 then '' when ansid=260973 then '' when ansid=260974 then '' when ansid=260975 then '' when ansid=260976 then '' when ansid=260977 then '' when ansid=260978 then '' when ansid=260979 then '' when ansid=260980 then '' when ansid=260981 then '' when ansid=260982 then '' when ansid=260983 then '' when ansid=260984 then '' when ansid=260985 then '' when ansid=260986 then '' when ansid=260987 then '' when ansid=260988 then '' when ansid=260989 then '' when ansid=260990 then '' when ansid=260991 then '' when ansid=260992 then '' when ansid=260993 then '' when ansid=260994 then '' when ansid=260995 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 23:14:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260890','260891','260892','260893','260894','260895','260896','260996','260997','260939','260941','260943','260945','260947','260949','260950','260951','260952','260953','260954','260955','260956','260957','260958','260959','260960','260961','260962','260963','260964','260965','260966','260967','260968','260969','260970','260971','260972','260973','260974','260975','260976','260977','260978','260979','260980','260981','260982','260983','260984','260985','260986','260987','260988','260989','260990','260991','260992','260993','260994','260995')"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE supvisstepid = '13616'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE visitfeedbackid = '13576'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE visitfeedbackid = '13577'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE visitfeedbackid = '13578'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE visitfeedbackid = '13579'"} {"userId":"680","date":"2023-02-04 23:14:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:14:11' WHERE visitfeedbackid = '13580'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE sitesupervision SET `siteid` = '323', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '208', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2760'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shilpa Tigga', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE onssid = '11368'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Yugant Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE onssid = '11369'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dhaneshwar Mahto', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE onssid = '11370'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE onssid = '11371'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260890 then '1' when ansid=260891 then '1' when ansid=260892 then '2' when ansid=260893 then '1' when ansid=260894 then '' when ansid=260895 then 'ICTC' when ansid=260896 then '1' when ansid=260996 then '1' when ansid=260997 then '1' when ansid=260939 then '1' when ansid=260941 then '0' when ansid=260943 then '0' when ansid=260945 then '03' when ansid=260947 then '1' when ansid=260949 then '3' when ansid=260950 then '2' when ansid=260951 then '1027' when ansid=260952 then '91' when ansid=260953 then '' when ansid=260954 then '1' when ansid=260955 then '1' when ansid=260956 then '' when ansid=260957 then '1' when ansid=260958 then '' when ansid=260959 then '1' when ansid=260960 then '12' when ansid=260961 then '3' when ansid=260962 then '1' when ansid=260963 then 'counsellor' when ansid=260964 then '1' when ansid=260965 then '' when ansid=260966 then '1' when ansid=260967 then '1' when ansid=260968 then '' when ansid=260969 then '1' when ansid=260970 then '3' when ansid=260971 then '1' when ansid=260972 then '1' when ansid=260973 then '1' when ansid=260974 then '2' when ansid=260975 then '2' when ansid=260976 then '1' when ansid=260977 then '1' when ansid=260978 then '1' when ansid=260979 then '' when ansid=260980 then '3' when ansid=260981 then '' when ansid=260982 then '1' when ansid=260983 then '1' when ansid=260984 then '1' when ansid=260985 then '' when ansid=260986 then '1' when ansid=260987 then '2' when ansid=260988 then '1' when ansid=260989 then '1' when ansid=260990 then '1' when ansid=260991 then '0' when ansid=260992 then 'NO' when ansid=260993 then 'NO' when ansid=260994 then 'Biomedical waste management was not up to mark' when ansid=260995 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 23:23:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260890','260891','260892','260893','260894','260895','260896','260996','260997','260939','260941','260943','260945','260947','260949','260950','260951','260952','260953','260954','260955','260956','260957','260958','260959','260960','260961','260962','260963','260964','260965','260966','260967','260968','260969','260970','260971','260972','260973','260974','260975','260976','260977','260978','260979','260980','260981','260982','260983','260984','260985','260986','260987','260988','260989','260990','260991','260992','260993','260994','260995')"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE supvisstepid = '13617'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE visitfeedbackid = '13576'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE visitfeedbackid = '13577'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE visitfeedbackid = '13578'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE visitfeedbackid = '13579'"} {"userId":"680","date":"2023-02-04 23:23:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:23:34' WHERE visitfeedbackid = '13580'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE sitesupervision SET `siteid` = '323', `userid` = '680', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-05', `numofsamplecollected` = '208', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30', `locationtype` = '1', `establishmentyear` = '2011', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2760'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Shilpa Tigga', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '02', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE onssid = '11368'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Yugant Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE onssid = '11369'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Dhaneshwar Mahto', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE onssid = '11370'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE onssid = '11371'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=260890 then '1' when ansid=260891 then '1' when ansid=260892 then '2' when ansid=260893 then '1' when ansid=260894 then '' when ansid=260895 then 'ICTC' when ansid=260896 then '1' when ansid=260996 then '1' when ansid=260997 then '1' when ansid=260939 then '1' when ansid=260941 then '0' when ansid=260943 then '0' when ansid=260945 then '03' when ansid=260947 then '1' when ansid=260949 then '3' when ansid=260950 then '2' when ansid=260951 then '1027' when ansid=260952 then '91' when ansid=260953 then '' when ansid=260954 then '1' when ansid=260955 then '1' when ansid=260956 then '' when ansid=260957 then '1' when ansid=260958 then '' when ansid=260959 then '1' when ansid=260960 then '12' when ansid=260961 then '3' when ansid=260962 then '1' when ansid=260963 then 'counsellor' when ansid=260964 then '1' when ansid=260965 then '' when ansid=260966 then '1' when ansid=260967 then '1' when ansid=260968 then '' when ansid=260969 then '1' when ansid=260970 then '3' when ansid=260971 then '1' when ansid=260972 then '1' when ansid=260973 then '1' when ansid=260974 then '2' when ansid=260975 then '2' when ansid=260976 then '1' when ansid=260977 then '1' when ansid=260978 then '1' when ansid=260979 then '' when ansid=260980 then '3' when ansid=260981 then '' when ansid=260982 then '1' when ansid=260983 then '1' when ansid=260984 then '1' when ansid=260985 then '' when ansid=260986 then '1' when ansid=260987 then '2' when ansid=260988 then '1' when ansid=260989 then '1' when ansid=260990 then '1' when ansid=260991 then '0' when ansid=260992 then 'NO' when ansid=260993 then 'NO' when ansid=260994 then 'Biomedical waste management was not up to mark' when ansid=260995 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '49.37.73.172',\r\n\t\t\t\t\t\t\t\tmodifiedby =680,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-04 23:27:30'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260890','260891','260892','260893','260894','260895','260896','260996','260997','260939','260941','260943','260945','260947','260949','260950','260951','260952','260953','260954','260955','260956','260957','260958','260959','260960','260961','260962','260963','260964','260965','260966','260967','260968','260969','260970','260971','260972','260973','260974','260975','260976','260977','260978','260979','260980','260981','260982','260983','260984','260985','260986','260987','260988','260989','260990','260991','260992','260993','260994','260995')"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE supvisstepid = '13618'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE visitfeedback SET `feedback` = '1. size of sample collection vial was not proper as told by L.T', `recommendation` = 'Given knowledge about segregation of biomedical waste in different color coded bins', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE visitfeedbackid = '13576'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE visitfeedback SET `feedback` = '1. Biomedical waste management part was not up to mark.', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE visitfeedbackid = '13577'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE visitfeedback SET `feedback` = '3. White translucent and blue translucent containers were not available', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE visitfeedbackid = '13578'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE visitfeedbackid = '13579'"} {"userId":"680","date":"2023-02-04 23:27:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '49.37.73.172', `modifiedby` = '680', `modifieddate` = '2023-02-04 23:27:30' WHERE visitfeedbackid = '13580'"}