{"userId":"435","date":"2021-04-03 09:02:51","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('435', '103.211.54.139', '2021-04-03 09:02:51')"} {"userId":"383","date":"2021-04-03 09:37:35","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('383', '59.89.57.2', '2021-04-03 09:37:35')"} {"userId":"383","date":"2021-04-03 09:38:38","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-03 09:38:38' WHERE plansiteid = '2038'"} {"userId":"383","date":"2021-04-03 09:38:38","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-03 09:38:38' WHERE ssid = ''"} {"userId":"383","date":"2021-04-03 09:39:14","query":"UPDATE plannedsites SET `siteid` = '1100', `visitdate` = '2021-04-03', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-03 09:39:14' WHERE plansiteid = '2032'"} {"userId":"333","date":"2021-04-03 10:23:51","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('333', '14.139.228.90', '2021-04-03 10:23:51')"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE sitesupervision SET `siteid` = '1083', `userid` = '333', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '134', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '538', `undertrialprisoners` = '692' WHERE ssid = '2275'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE onsitestaffs SET `staffname` = 'Shyam Sunder Trivedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE onssid = '9428'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE onsitestaffs SET `staffname` = 'Dilip Singh Panwar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE onssid = '9429'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE onsitestaffs SET `staffname` = 'Anil Arya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE onssid = '9430'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE onsitestaffs SET `staffname` = 'Kumud Goswami', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE onssid = '9431'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=211755 then '' when ansid=211757 then '' when ansid=211759 then '' when ansid=211761 then '' when ansid=211763 then '' when ansid=211765 then '' when ansid=211766 then '' when ansid=211767 then '' when ansid=211768 then '' when ansid=211769 then '' when ansid=211770 then '' when ansid=211771 then '' when ansid=211772 then '' when ansid=211773 then '' when ansid=211774 then '' when ansid=211775 then '' when ansid=211776 then '' when ansid=211777 then '' when ansid=211778 then '' when ansid=211779 then '' when ansid=211780 then '' when ansid=211781 then '' when ansid=211782 then '' when ansid=211783 then '' when ansid=211784 then '' when ansid=211785 then '' when ansid=211786 then '' when ansid=211787 then '' when ansid=211788 then '' when ansid=211789 then '' when ansid=211790 then '' when ansid=211791 then '' when ansid=211792 then '' when ansid=211793 then '' when ansid=211794 then '' when ansid=211795 then '' when ansid=211796 then '' when ansid=211797 then '' when ansid=211798 then '' when ansid=211799 then '' when ansid=211800 then '' when ansid=211801 then '' when ansid=211802 then '' when ansid=211803 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.228.90',\n\t\t\t\t\t\t\t\tmodifiedby =333,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 10:27:27'\n\t\t\t\t\t\t\tWHERE ansid in ('211755','211757','211759','211761','211763','211765','211766','211767','211768','211769','211770','211771','211772','211773','211774','211775','211776','211777','211778','211779','211780','211781','211782','211783','211784','211785','211786','211787','211788','211789','211790','211791','211792','211793','211794','211795','211796','211797','211798','211799','211800','211801','211802','211803')"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE supvisstepid = '11326'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE visitfeedbackid = '11151'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE visitfeedbackid = '11152'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE visitfeedbackid = '11153'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE visitfeedbackid = '11154'"} {"userId":"333","date":"2021-04-03 10:27:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:27:27' WHERE visitfeedbackid = '11155'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE sitesupervision SET `siteid` = '1083', `userid` = '333', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '134', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '538', `undertrialprisoners` = '692' WHERE ssid = '2275'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE onsitestaffs SET `staffname` = 'Shyam Sunder Trivedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE onssid = '9428'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dilip Singh Panwar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE onssid = '9429'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE onsitestaffs SET `staffname` = 'Anil Arya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE onssid = '9430'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE onsitestaffs SET `staffname` = 'Kumud Goswami', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE onssid = '9431'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=211755 then '1' when ansid=211757 then '0' when ansid=211759 then '0' when ansid=211761 then '30' when ansid=211763 then '1' when ansid=211765 then '' when ansid=211766 then '' when ansid=211767 then '' when ansid=211768 then '' when ansid=211769 then '' when ansid=211770 then '' when ansid=211771 then '' when ansid=211772 then '' when ansid=211773 then '' when ansid=211774 then '' when ansid=211775 then '' when ansid=211776 then '' when ansid=211777 then '' when ansid=211778 then '' when ansid=211779 then '' when ansid=211780 then '' when ansid=211781 then '' when ansid=211782 then '' when ansid=211783 then '' when ansid=211784 then '' when ansid=211785 then '' when ansid=211786 then '' when ansid=211787 then '' when ansid=211788 then '' when ansid=211789 then '' when ansid=211790 then '' when ansid=211791 then '' when ansid=211792 then '' when ansid=211793 then '' when ansid=211794 then '' when ansid=211795 then '' when ansid=211796 then '' when ansid=211797 then '' when ansid=211798 then '' when ansid=211799 then '' when ansid=211800 then '' when ansid=211801 then '' when ansid=211802 then '' when ansid=211803 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.228.90',\n\t\t\t\t\t\t\t\tmodifiedby =333,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 10:29:24'\n\t\t\t\t\t\t\tWHERE ansid in ('211755','211757','211759','211761','211763','211765','211766','211767','211768','211769','211770','211771','211772','211773','211774','211775','211776','211777','211778','211779','211780','211781','211782','211783','211784','211785','211786','211787','211788','211789','211790','211791','211792','211793','211794','211795','211796','211797','211798','211799','211800','211801','211802','211803')"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE supvisstepid = '11327'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE visitfeedbackid = '11151'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE visitfeedbackid = '11152'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE visitfeedbackid = '11153'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE visitfeedbackid = '11154'"} {"userId":"333","date":"2021-04-03 10:29:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:29:24' WHERE visitfeedbackid = '11155'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE sitesupervision SET `siteid` = '1083', `userid` = '333', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '134', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '538', `undertrialprisoners` = '692' WHERE ssid = '2275'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE onsitestaffs SET `staffname` = 'Shyam Sunder Trivedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE onssid = '9428'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dilip Singh Panwar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE onssid = '9429'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE onsitestaffs SET `staffname` = 'Anil Arya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE onssid = '9430'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE onsitestaffs SET `staffname` = 'Kumud Goswami', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE onssid = '9431'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=211755 then '1' when ansid=211757 then '0' when ansid=211759 then '0' when ansid=211761 then '30' when ansid=211763 then '1' when ansid=211765 then '8' when ansid=211766 then '5' when ansid=211767 then '' when ansid=211768 then '1' when ansid=211769 then '' when ansid=211770 then '1' when ansid=211771 then '' when ansid=211772 then '1' when ansid=211773 then '8' when ansid=211774 then '1' when ansid=211775 then 'counselor' when ansid=211776 then '1' when ansid=211777 then '' when ansid=211778 then '1' when ansid=211779 then '1' when ansid=211780 then '' when ansid=211781 then '1' when ansid=211782 then '1' when ansid=211783 then '1' when ansid=211784 then '1' when ansid=211785 then '1' when ansid=211786 then '1' when ansid=211787 then '1' when ansid=211788 then '1' when ansid=211789 then '1' when ansid=211790 then '3' when ansid=211791 then '1' when ansid=211792 then '1' when ansid=211793 then '1' when ansid=211794 then '' when ansid=211795 then '1' when ansid=211796 then '1' when ansid=211797 then '1' when ansid=211798 then '2' when ansid=211799 then '1' when ansid=211800 then '0' when ansid=211801 then 'centrifuge Machine not working properly, takes more time for serum separation. Knobs for adjusting speed are not working.' when ansid=211802 then 'Not in this round of surveillance.' when ansid=211803 then 'work is going on smoothly. Data form transportation sheet available but not acknowledged by regional institute.Biomedical waste disposal done as per guidelines, deficiency in material are arranged at local level.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.228.90',\n\t\t\t\t\t\t\t\tmodifiedby =333,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 10:51:30'\n\t\t\t\t\t\t\tWHERE ansid in ('211755','211757','211759','211761','211763','211765','211766','211767','211768','211769','211770','211771','211772','211773','211774','211775','211776','211777','211778','211779','211780','211781','211782','211783','211784','211785','211786','211787','211788','211789','211790','211791','211792','211793','211794','211795','211796','211797','211798','211799','211800','211801','211802','211803')"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE supvisstepid = '11328'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE visitfeedbackid = '11151'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE visitfeedbackid = '11152'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE visitfeedbackid = '11153'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE visitfeedbackid = '11154'"} {"userId":"333","date":"2021-04-03 10:51:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:51:30' WHERE visitfeedbackid = '11155'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE sitesupervision SET `siteid` = '1083', `userid` = '333', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-03-15', `numofsamplecollected` = '134', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '1', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '538', `undertrialprisoners` = '692', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2275'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Shyam Sunder Trivedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE onssid = '9428'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dilip Singh Panwar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE onssid = '9429'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Anil Arya', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE onssid = '9430'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE onsitestaffs SET `staffname` = 'Kumud Goswami', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE onssid = '9431'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=211755 then '1' when ansid=211757 then '0' when ansid=211759 then '0' when ansid=211761 then '30' when ansid=211763 then '1' when ansid=211765 then '8' when ansid=211766 then '5' when ansid=211767 then '' when ansid=211768 then '1' when ansid=211769 then '' when ansid=211770 then '1' when ansid=211771 then '' when ansid=211772 then '1' when ansid=211773 then '8' when ansid=211774 then '1' when ansid=211775 then 'counselor' when ansid=211776 then '1' when ansid=211777 then '' when ansid=211778 then '1' when ansid=211779 then '1' when ansid=211780 then '' when ansid=211781 then '1' when ansid=211782 then '1' when ansid=211783 then '1' when ansid=211784 then '1' when ansid=211785 then '1' when ansid=211786 then '1' when ansid=211787 then '1' when ansid=211788 then '1' when ansid=211789 then '1' when ansid=211790 then '3' when ansid=211791 then '1' when ansid=211792 then '1' when ansid=211793 then '1' when ansid=211794 then '' when ansid=211795 then '1' when ansid=211796 then '1' when ansid=211797 then '1' when ansid=211798 then '2' when ansid=211799 then '1' when ansid=211800 then '0' when ansid=211801 then 'centrifuge Machine not working properly, takes more time for serum separation. Knobs for adjusting speed are not working.' when ansid=211802 then 'Not in this round of surveillance.' when ansid=211803 then 'work is going on smoothly. Data form transportation sheet available but not acknowledged by regional institute.Biomedical waste disposal done as per guidelines, deficiency in material are arranged at local level.' end),\n\t\t\t\t\t\t\t\t ipaddress = '14.139.228.90',\n\t\t\t\t\t\t\t\tmodifiedby =333,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 10:52:53'\n\t\t\t\t\t\t\tWHERE ansid in ('211755','211757','211759','211761','211763','211765','211766','211767','211768','211769','211770','211771','211772','211773','211774','211775','211776','211777','211778','211779','211780','211781','211782','211783','211784','211785','211786','211787','211788','211789','211790','211791','211792','211793','211794','211795','211796','211797','211798','211799','211800','211801','211802','211803')"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE supvisstepid = '11329'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE visitfeedbackid = '11151'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE visitfeedbackid = '11152'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE visitfeedbackid = '11153'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE visitfeedbackid = '11154'"} {"userId":"333","date":"2021-04-03 10:52:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.228.90', `modifiedby` = '333', `modifieddate` = '2021-04-03 10:52:53' WHERE visitfeedbackid = '11155'"} {"userId":"406","date":"2021-04-03 11:28:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('406', '157.34.107.143', '2021-04-03 11:28:46')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1304', '2660', '406', '2021-04-03', '1', '157.34.107.143', '406', '2021-04-03 11:29:03', '', '')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2283', '0', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2283', '1', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2283', '2', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2283', '3', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2283', '', '', 'Array', '', 'Array', '', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2283', '', '', 'Array', '', 'Array', '', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2283', '', '', 'Array', '', 'Array', '', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2283', '', '', 'Array', '', 'Array', '', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"406","date":"2021-04-03 11:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2283', '157.34.107.143', '406', '2021-04-03 11:29:03')"} {"userId":"333","date":"2021-04-03 11:32:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('333', '14.139.228.90', '2021-04-03 11:32:42')"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE sitesupervision SET `siteid` = '1304', `userid` = '406', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-03', `numofsamplecollected` = '204', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2283'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE onsitestaffs SET `staffname` = 'Ravindra Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE onssid = '9460'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE onsitestaffs SET `staffname` = 'Suraj Prasad', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE onssid = '9461'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE onsitestaffs SET `staffname` = 'Nitesh Sao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE onssid = '9462'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE onssid = '9463'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=212335 then '2' when ansid=212336 then '2' when ansid=212337 then '2' when ansid=212338 then '0' when ansid=212339 then '0' when ansid=212340 then '3' when ansid=212341 then '3' when ansid=212342 then '' when ansid=212343 then '' when ansid=212344 then '' when ansid=212345 then '' when ansid=212346 then '' when ansid=212347 then '' when ansid=212348 then '' when ansid=212349 then '' when ansid=212350 then '' when ansid=212351 then '' when ansid=212352 then '' when ansid=212353 then '' when ansid=212354 then '' when ansid=212355 then '' when ansid=212356 then '' when ansid=212357 then '' when ansid=212358 then '' when ansid=212359 then '' when ansid=212360 then '' when ansid=212361 then '' when ansid=212362 then '' when ansid=212363 then '' when ansid=212364 then '' when ansid=212365 then '' when ansid=212366 then '' when ansid=212367 then '' when ansid=212368 then '' when ansid=212369 then '' when ansid=212370 then '' when ansid=212371 then '' when ansid=212372 then '' when ansid=212373 then '' when ansid=212374 then '' when ansid=212375 then '' when ansid=212376 then '' when ansid=212377 then '' when ansid=212378 then '' when ansid=212379 then '' when ansid=212380 then '' when ansid=212381 then '' when ansid=212382 then '' when ansid=212383 then '' when ansid=212384 then '' when ansid=212385 then '' when ansid=212386 then '' when ansid=212387 then '' when ansid=212388 then '' when ansid=212389 then '' when ansid=212390 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.107.143',\n\t\t\t\t\t\t\t\tmodifiedby =406,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 11:39:41'\n\t\t\t\t\t\t\tWHERE ansid in ('212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390')"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE supvisstepid = '11360'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE visitfeedbackid = '11191'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE visitfeedbackid = '11192'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE visitfeedbackid = '11193'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE visitfeedbackid = '11194'"} {"userId":"406","date":"2021-04-03 11:39:41","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:39:41' WHERE visitfeedbackid = '11195'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE sitesupervision SET `siteid` = '1304', `userid` = '406', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-03', `numofsamplecollected` = '204', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2283'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE onsitestaffs SET `staffname` = 'Ravindra Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE onssid = '9460'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE onsitestaffs SET `staffname` = 'Suraj Prasad', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE onssid = '9461'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE onsitestaffs SET `staffname` = 'Nitesh Sao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE onssid = '9462'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE onssid = '9463'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=212335 then '2' when ansid=212336 then '2' when ansid=212337 then '2' when ansid=212338 then '0' when ansid=212339 then '0' when ansid=212340 then '3' when ansid=212341 then '3' when ansid=212342 then '1' when ansid=212343 then '1' when ansid=212344 then '1' when ansid=212345 then '1' when ansid=212346 then '1' when ansid=212347 then '1' when ansid=212348 then '1' when ansid=212349 then '3' when ansid=212350 then '1' when ansid=212351 then '' when ansid=212352 then '' when ansid=212353 then '' when ansid=212354 then '' when ansid=212355 then '' when ansid=212356 then '' when ansid=212357 then '' when ansid=212358 then '' when ansid=212359 then '' when ansid=212360 then '' when ansid=212361 then '' when ansid=212362 then '' when ansid=212363 then '' when ansid=212364 then '' when ansid=212365 then '' when ansid=212366 then '' when ansid=212367 then '' when ansid=212368 then '' when ansid=212369 then '' when ansid=212370 then '' when ansid=212371 then '' when ansid=212372 then '' when ansid=212373 then '' when ansid=212374 then '' when ansid=212375 then '' when ansid=212376 then '' when ansid=212377 then '' when ansid=212378 then '' when ansid=212379 then '' when ansid=212380 then '' when ansid=212381 then '' when ansid=212382 then '' when ansid=212383 then '' when ansid=212384 then '' when ansid=212385 then '' when ansid=212386 then '' when ansid=212387 then '' when ansid=212388 then '' when ansid=212389 then '' when ansid=212390 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.107.143',\n\t\t\t\t\t\t\t\tmodifiedby =406,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 11:40:36'\n\t\t\t\t\t\t\tWHERE ansid in ('212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390')"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE supvisstepid = '11361'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE visitfeedbackid = '11191'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE visitfeedbackid = '11192'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE visitfeedbackid = '11193'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE visitfeedbackid = '11194'"} {"userId":"406","date":"2021-04-03 11:40:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:40:36' WHERE visitfeedbackid = '11195'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE sitesupervision SET `siteid` = '1304', `userid` = '406', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-03', `numofsamplecollected` = '204', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2283'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE onsitestaffs SET `staffname` = 'Ravindra Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE onssid = '9460'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE onsitestaffs SET `staffname` = 'Suraj Prasad', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE onssid = '9461'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE onsitestaffs SET `staffname` = 'Nitesh Sao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE onssid = '9462'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE onssid = '9463'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=212335 then '2' when ansid=212336 then '2' when ansid=212337 then '2' when ansid=212338 then '0' when ansid=212339 then '0' when ansid=212340 then '3' when ansid=212341 then '3' when ansid=212342 then '1' when ansid=212343 then '1' when ansid=212344 then '1' when ansid=212345 then '1' when ansid=212346 then '1' when ansid=212347 then '1' when ansid=212348 then '1' when ansid=212349 then '3' when ansid=212350 then '1' when ansid=212351 then '11' when ansid=212352 then '0' when ansid=212353 then '5' when ansid=212354 then '1' when ansid=212355 then '' when ansid=212356 then '1' when ansid=212357 then '' when ansid=212358 then '1' when ansid=212359 then '' when ansid=212360 then '1' when ansid=212361 then '' when ansid=212362 then '1' when ansid=212363 then '' when ansid=212364 then '1' when ansid=212365 then '1' when ansid=212366 then '1' when ansid=212367 then '1' when ansid=212368 then '' when ansid=212369 then '1' when ansid=212370 then '' when ansid=212371 then '1' when ansid=212372 then '' when ansid=212373 then '1' when ansid=212374 then '' when ansid=212375 then '1' when ansid=212376 then '' when ansid=212377 then '1' when ansid=212378 then '' when ansid=212379 then '2' when ansid=212380 then '' when ansid=212381 then '2' when ansid=212382 then '2' when ansid=212383 then '2' when ansid=212384 then '1' when ansid=212385 then '1' when ansid=212386 then '1' when ansid=212387 then 'No Any aspect searching the bubble envelop' when ansid=212388 then 'No Any' when ansid=212389 then '1) Checked the 11 data forms and it is observed that the circle has not made properly. 2) And also site in charges signature missing.' when ansid=212390 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.107.143',\n\t\t\t\t\t\t\t\tmodifiedby =406,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 11:47:27'\n\t\t\t\t\t\t\tWHERE ansid in ('212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390')"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE supvisstepid = '11362'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE visitfeedbackid = '11191'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE visitfeedbackid = '11192'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE visitfeedbackid = '11193'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE visitfeedbackid = '11194'"} {"userId":"406","date":"2021-04-03 11:47:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:27' WHERE visitfeedbackid = '11195'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE sitesupervision SET `siteid` = '1304', `userid` = '406', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-03', `numofsamplecollected` = '204', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2283'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE onsitestaffs SET `staffname` = 'Ravindra Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE onssid = '9460'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE onsitestaffs SET `staffname` = 'Suraj Prasad', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE onssid = '9461'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE onsitestaffs SET `staffname` = 'Nitesh Sao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE onssid = '9462'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE onssid = '9463'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=212335 then '2' when ansid=212336 then '2' when ansid=212337 then '2' when ansid=212338 then '0' when ansid=212339 then '0' when ansid=212340 then '3' when ansid=212341 then '3' when ansid=212342 then '1' when ansid=212343 then '1' when ansid=212344 then '1' when ansid=212345 then '1' when ansid=212346 then '1' when ansid=212347 then '1' when ansid=212348 then '1' when ansid=212349 then '3' when ansid=212350 then '1' when ansid=212351 then '11' when ansid=212352 then '0' when ansid=212353 then '5' when ansid=212354 then '1' when ansid=212355 then '' when ansid=212356 then '1' when ansid=212357 then '' when ansid=212358 then '1' when ansid=212359 then '' when ansid=212360 then '1' when ansid=212361 then '' when ansid=212362 then '1' when ansid=212363 then '' when ansid=212364 then '1' when ansid=212365 then '1' when ansid=212366 then '1' when ansid=212367 then '1' when ansid=212368 then '' when ansid=212369 then '1' when ansid=212370 then '' when ansid=212371 then '1' when ansid=212372 then '' when ansid=212373 then '1' when ansid=212374 then '' when ansid=212375 then '1' when ansid=212376 then '' when ansid=212377 then '1' when ansid=212378 then '' when ansid=212379 then '2' when ansid=212380 then '' when ansid=212381 then '2' when ansid=212382 then '2' when ansid=212383 then '2' when ansid=212384 then '1' when ansid=212385 then '1' when ansid=212386 then '1' when ansid=212387 then 'No Any aspect searching the bubble envelop' when ansid=212388 then 'No Any' when ansid=212389 then '1) Checked the 11 data forms and it is observed that the circle has not made properly. 2) And also site in charges signature missing.' when ansid=212390 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '157.34.107.143',\n\t\t\t\t\t\t\t\tmodifiedby =406,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-03 11:47:40'\n\t\t\t\t\t\t\tWHERE ansid in ('212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390')"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE supvisstepid = '11363'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE visitfeedbackid = '11191'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE visitfeedbackid = '11192'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE visitfeedbackid = '11193'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE visitfeedbackid = '11194'"} {"userId":"406","date":"2021-04-03 11:47:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.34.107.143', `modifiedby` = '406', `modifieddate` = '2021-04-03 11:47:40' WHERE visitfeedbackid = '11195'"} {"userId":"511","date":"2021-04-03 11:49:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('511', '14.139.60.131', '2021-04-03 11:49:44')"}