{"userId":"136","date":"2021-04-05 08:00:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('136', '202.142.71.128', '2021-04-05 08:00:19')"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE sitesupervision SET `siteid` = '452', `userid` = '136', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '1805'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE onssid = '7548'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE onssid = '7549'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE onssid = '7550'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE onssid = '7551'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE supvisstepid = '9303'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE visitfeedback SET `feedback` = 'Antenatal Care is not given by medical officers but by nursing staffs', `recommendation` = 'Antenatal care should be given by medical officer and eligibility should be checked by medical officer or site incharge', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE visitfeedbackid = '8801'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE visitfeedback SET `feedback` = 'ANC clinic and data form filling are in 2 different floor. STI counselor checks eligibility and recruits the mothers. But she is not adequately sensitized.', `recommendation` = 'STI counselor was sensitized on site regarding the eligibility criteria', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE visitfeedbackid = '8802'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE visitfeedbackid = '8803'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE visitfeedbackid = '8804'"}
{"userId":"136","date":"2021-04-05 08:35:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.142.71.128', `modifiedby` = '136', `modifieddate` = '2021-04-05 08:35:49' WHERE visitfeedbackid = '8805'"}
{"userId":"511","date":"2021-04-05 13:14:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('511', '14.139.60.131', '2021-04-05 13:14:28')"}
{"userId":"511","date":"2021-04-05 13:16:45","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1157', '2021-04-09', '511', '14.139.60.131', '511', '2021-04-05 13:16:45')"}
{"userId":"408","date":"2021-04-05 17:36:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('408', '45.124.145.86', '2021-04-05 17:36:04')"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE sitesupervision SET `siteid` = '1310', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '124', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2017'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'T. S. Chandel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE onssid = '8396'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'Girijashankar Joshi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE onssid = '8397'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE onsitestaffs SET `staffname` = 'Akash Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE onssid = '8398'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE onssid = '8399'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=191532 then '2' when ansid=191533 then '5' when ansid=191534 then '2' when ansid=191535 then '0' when ansid=191536 then '0' when ansid=191537 then '4' when ansid=191538 then '4' when ansid=191539 then '1' when ansid=191540 then '1' when ansid=191541 then '1' when ansid=191542 then '1' when ansid=191543 then '2' when ansid=191544 then '2' when ansid=191545 then '4' when ansid=191546 then '4' when ansid=191547 then '3' when ansid=191548 then '' when ansid=191549 then '' when ansid=191550 then '' when ansid=191551 then ''  when ansid=191552 then ''   when ansid=191553 then ''   when ansid=191554 then ''   when ansid=191555 then ''   when ansid=191556 then ''   when ansid=191557 then ''   when ansid=191558 then ''   when ansid=191559 then ''   when ansid=191560 then ''   when ansid=191561 then ''  when ansid=191562 then '' when ansid=191563 then '' when ansid=191564 then ''  when ansid=191565 then ''   when ansid=191566 then ''   when ansid=191567 then ''   when ansid=191568 then ''   when ansid=191569 then ''   when ansid=191570 then ''   when ansid=191571 then ''   when ansid=191572 then ''   when ansid=191573 then ''   when ansid=191574 then ''   when ansid=191575 then ''   when ansid=191576 then ''   when ansid=191577 then ''   when ansid=191578 then ''  when ansid=191579 then '' when ansid=191580 then '' when ansid=191581 then '' when ansid=191582 then '' when ansid=191583 then '' when ansid=191584 then '' when ansid=191585 then '' when ansid=191586 then '' when ansid=191587 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 17:58:28'\n\t\t\t\t\t\t\tWHERE ansid in ('191532','191533','191534','191535','191536','191537','191538','191539','191540','191541','191542','191543','191544','191545','191546','191547','191548','191549','191550','191551','191552','191553','191554','191555','191556','191557','191558','191559','191560','191561','191562','191563','191564','191565','191566','191567','191568','191569','191570','191571','191572','191573','191574','191575','191576','191577','191578','191579','191580','191581','191582','191583','191584','191585','191586','191587')"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE supvisstepid = '10238'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE visitfeedbackid = '9861'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE visitfeedbackid = '9862'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE visitfeedbackid = '9863'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE visitfeedbackid = '9864'"}
{"userId":"408","date":"2021-04-05 17:58:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:28' WHERE visitfeedbackid = '9865'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE sitesupervision SET `siteid` = '1310', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '124', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2017'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE onsitestaffs SET `staffname` = 'T. S. Chandel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE onssid = '8396'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE onsitestaffs SET `staffname` = 'Girijashankar Joshi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE onssid = '8397'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE onsitestaffs SET `staffname` = 'Akash Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE onssid = '8398'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE onssid = '8399'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=191532 then '2' when ansid=191533 then '5' when ansid=191534 then '2' when ansid=191535 then '0' when ansid=191536 then '0' when ansid=191537 then '4' when ansid=191538 then '4' when ansid=191539 then '1' when ansid=191540 then '1' when ansid=191541 then '1' when ansid=191542 then '1' when ansid=191543 then '2' when ansid=191544 then '2' when ansid=191545 then '4' when ansid=191546 then '4' when ansid=191547 then '3' when ansid=191548 then '' when ansid=191549 then '' when ansid=191550 then '' when ansid=191551 then ''  when ansid=191552 then ''   when ansid=191553 then ''   when ansid=191554 then ''   when ansid=191555 then ''   when ansid=191556 then ''   when ansid=191557 then ''   when ansid=191558 then ''   when ansid=191559 then ''   when ansid=191560 then ''   when ansid=191561 then ''  when ansid=191562 then '' when ansid=191563 then '' when ansid=191564 then ''  when ansid=191565 then ''   when ansid=191566 then ''   when ansid=191567 then ''   when ansid=191568 then ''   when ansid=191569 then ''   when ansid=191570 then ''   when ansid=191571 then ''   when ansid=191572 then ''   when ansid=191573 then ''   when ansid=191574 then ''   when ansid=191575 then ''   when ansid=191576 then ''   when ansid=191577 then ''   when ansid=191578 then ''  when ansid=191579 then '' when ansid=191580 then '' when ansid=191581 then '' when ansid=191582 then '' when ansid=191583 then '' when ansid=191584 then '' when ansid=191585 then '' when ansid=191586 then '' when ansid=191587 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 17:58:35'\n\t\t\t\t\t\t\tWHERE ansid in ('191532','191533','191534','191535','191536','191537','191538','191539','191540','191541','191542','191543','191544','191545','191546','191547','191548','191549','191550','191551','191552','191553','191554','191555','191556','191557','191558','191559','191560','191561','191562','191563','191564','191565','191566','191567','191568','191569','191570','191571','191572','191573','191574','191575','191576','191577','191578','191579','191580','191581','191582','191583','191584','191585','191586','191587')"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE supvisstepid = '10239'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE visitfeedbackid = '9861'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE visitfeedbackid = '9862'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE visitfeedbackid = '9863'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE visitfeedbackid = '9864'"}
{"userId":"408","date":"2021-04-05 17:58:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 17:58:35' WHERE visitfeedbackid = '9865'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE sitesupervision SET `siteid` = '1310', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '124', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2017'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE onsitestaffs SET `staffname` = 'T. S. Chandel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE onssid = '8396'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE onsitestaffs SET `staffname` = 'Girijashankar Joshi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE onssid = '8397'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE onsitestaffs SET `staffname` = 'Akash Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE onssid = '8398'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE onssid = '8399'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=191532 then '2' when ansid=191533 then '5' when ansid=191534 then '2' when ansid=191535 then '0' when ansid=191536 then '0' when ansid=191537 then '4' when ansid=191538 then '4' when ansid=191539 then '1' when ansid=191540 then '1' when ansid=191541 then '1' when ansid=191542 then '1' when ansid=191543 then '2' when ansid=191544 then '2' when ansid=191545 then '4' when ansid=191546 then '4' when ansid=191547 then '3' when ansid=191548 then '03' when ansid=191549 then '0' when ansid=191550 then '3' when ansid=191551 then '1'  when ansid=191552 then ''   when ansid=191553 then '1'   when ansid=191554 then ''   when ansid=191555 then '1'   when ansid=191556 then ''   when ansid=191557 then '1'   when ansid=191558 then ''   when ansid=191559 then '1'   when ansid=191560 then 'Counsellor is taking samples in place of D-LT'   when ansid=191561 then '3'  when ansid=191562 then '1' when ansid=191563 then '1' when ansid=191564 then '1'  when ansid=191565 then ''   when ansid=191566 then '1'   when ansid=191567 then ''   when ansid=191568 then '1'   when ansid=191569 then ''   when ansid=191570 then '1'   when ansid=191571 then 'Not found in the collection spot and'   when ansid=191572 then '3'   when ansid=191573 then ''   when ansid=191574 then '1'   when ansid=191575 then ''   when ansid=191576 then '2'   when ansid=191577 then ''   when ansid=191578 then '2'  when ansid=191579 then '1' when ansid=191580 then '1' when ansid=191581 then '1' when ansid=191582 then '1' when ansid=191583 then '1' when ansid=191584 then 'a) Total 124 blood samples of LDTs under HSS were collected till Feb 16th, 2021. The daily average of sample collection is 2 - 3 since its initiation which is suggested to increase as 5 - 6 samples on daily basis from 17th February onward, this strategy has been recommended to be adopted for achieving the given target of HSS within the given timeline.b)  The onsite supportive supervisory visit done on Korapura Raipur Union DIC while the sample collections were continuing over there.  Separate space for counselling and sample collection with proper light are not observed adequately. It is found during the visit that the designated TI counsellor is drawing blood samples in place of designated and trained LT (TI ORW), also the HSS register was not found in the collection spot as per the HSS Mandate. All these observations are raised to the PD-TI & Site In-Charge, they acknowledge the facts and ask to ensure appropriate action accordingly. c) The necessary components under Bio Medical Waste Management were not found in place at TI office alongwith HSS sites during visit as per standard guideline and recommended by PO-TI and TSU in earlier visits and HSS Training. It was again advised to procure the all essentials components for BMW management and make it operational at the earliest within 20th March 2021' when ansid=191585 then 'Yes, It was recommended to  to keep  necessary components under Bio Medical Waste Management but still it is yet to be done' when ansid=191586 then 'No Any' when ansid=191587 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:04:59'\n\t\t\t\t\t\t\tWHERE ansid in ('191532','191533','191534','191535','191536','191537','191538','191539','191540','191541','191542','191543','191544','191545','191546','191547','191548','191549','191550','191551','191552','191553','191554','191555','191556','191557','191558','191559','191560','191561','191562','191563','191564','191565','191566','191567','191568','191569','191570','191571','191572','191573','191574','191575','191576','191577','191578','191579','191580','191581','191582','191583','191584','191585','191586','191587')"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE supvisstepid = '10240'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE visitfeedbackid = '9861'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE visitfeedbackid = '9862'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE visitfeedbackid = '9863'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE visitfeedbackid = '9864'"}
{"userId":"408","date":"2021-04-05 18:04:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:04:59' WHERE visitfeedbackid = '9865'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE sitesupervision SET `siteid` = '1310', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '124', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2017'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE onsitestaffs SET `staffname` = 'T. S. Chandel', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE onssid = '8396'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE onsitestaffs SET `staffname` = 'Girijashankar Joshi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE onssid = '8397'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE onsitestaffs SET `staffname` = 'Akash Joshi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE onssid = '8398'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE onssid = '8399'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=191532 then '2' when ansid=191533 then '5' when ansid=191534 then '2' when ansid=191535 then '0' when ansid=191536 then '0' when ansid=191537 then '4' when ansid=191538 then '4' when ansid=191539 then '1' when ansid=191540 then '1' when ansid=191541 then '1' when ansid=191542 then '1' when ansid=191543 then '2' when ansid=191544 then '2' when ansid=191545 then '4' when ansid=191546 then '4' when ansid=191547 then '3' when ansid=191548 then '03' when ansid=191549 then '0' when ansid=191550 then '3' when ansid=191551 then '1'  when ansid=191552 then ''   when ansid=191553 then '1'   when ansid=191554 then ''   when ansid=191555 then '1'   when ansid=191556 then ''   when ansid=191557 then '1'   when ansid=191558 then ''   when ansid=191559 then '1'   when ansid=191560 then 'Counsellor is taking samples in place of D-LT'   when ansid=191561 then '3'  when ansid=191562 then '1' when ansid=191563 then '1' when ansid=191564 then '1'  when ansid=191565 then ''   when ansid=191566 then '1'   when ansid=191567 then ''   when ansid=191568 then '1'   when ansid=191569 then ''   when ansid=191570 then '1'   when ansid=191571 then 'Not found in the collection spot and'   when ansid=191572 then '3'   when ansid=191573 then ''   when ansid=191574 then '1'   when ansid=191575 then ''   when ansid=191576 then '2'   when ansid=191577 then ''   when ansid=191578 then '2'  when ansid=191579 then '1' when ansid=191580 then '1' when ansid=191581 then '1' when ansid=191582 then '1' when ansid=191583 then '1' when ansid=191584 then 'a) Total 124 blood samples of LDTs under HSS were collected till Feb 16th, 2021. The daily average of sample collection is 2 - 3 since its initiation which is suggested to increase as 5 - 6 samples on daily basis from 17th February onward, this strategy has been recommended to be adopted for achieving the given target of HSS within the given timeline.b)  The onsite supportive supervisory visit done on Korapura Raipur Union DIC while the sample collections were continuing over there.  Separate space for counselling and sample collection with proper light are not observed adequately. It is found during the visit that the designated TI counsellor is drawing blood samples in place of designated and trained LT (TI ORW), also the HSS register was not found in the collection spot as per the HSS Mandate. All these observations are raised to the PD-TI & Site In-Charge, they acknowledge the facts and ask to ensure appropriate action accordingly. c) The necessary components under Bio Medical Waste Management were not found in place at TI office alongwith HSS sites during visit as per standard guideline and recommended by PO-TI and TSU in earlier visits and HSS Training. It was again advised to procure the all essentials components for BMW management and make it operational at the earliest within 20th March 2021' when ansid=191585 then 'Yes, It was recommended to  to keep  necessary components under Bio Medical Waste Management but still it is yet to be done' when ansid=191586 then 'No Any' when ansid=191587 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:05:06'\n\t\t\t\t\t\t\tWHERE ansid in ('191532','191533','191534','191535','191536','191537','191538','191539','191540','191541','191542','191543','191544','191545','191546','191547','191548','191549','191550','191551','191552','191553','191554','191555','191556','191557','191558','191559','191560','191561','191562','191563','191564','191565','191566','191567','191568','191569','191570','191571','191572','191573','191574','191575','191576','191577','191578','191579','191580','191581','191582','191583','191584','191585','191586','191587')"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE supvisstepid = '10241'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE visitfeedbackid = '9861'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE visitfeedbackid = '9862'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE visitfeedbackid = '9863'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE visitfeedbackid = '9864'"}
{"userId":"408","date":"2021-04-05 18:05:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:05:06' WHERE visitfeedbackid = '9865'"}
{"userId":"408","date":"2021-04-05 18:08:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('408', '45.124.145.86', '2021-04-05 18:08:27')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1313', '2583', '408', '2021-04-05', '1', '45.124.145.86', '408', '2021-04-05 18:09:18', '', '')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2284', '0', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2284', '1', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2284', '2', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2284', '3', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2284', '', '', 'Array', '', 'Array', '', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2284', '', '', 'Array', '', 'Array', '', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2284', '', '', 'Array', '', 'Array', '', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2284', '', '', 'Array', '', 'Array', '', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:09:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2284', '45.124.145.86', '408', '2021-04-05 18:09:18')"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE sitesupervision SET `siteid` = '1313', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-05', `numofsamplecollected` = '69', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2284'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE onsitestaffs SET `staffname` = 'Raju Vaishnav', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE onssid = '9464'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE onsitestaffs SET `staffname` = 'Pratima Sarkar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'The M&E of TI are working as counsellor in case of said position is vacant', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE onssid = '9465'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE onsitestaffs SET `staffname` = 'Govinda Sandekar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE onssid = '9466'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE onssid = '9467'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212391 then '2' when ansid=212392 then '6' when ansid=212393 then '2' when ansid=212394 then '0' when ansid=212395 then '0' when ansid=212396 then '1' when ansid=212397 then '1' when ansid=212398 then '' when ansid=212399 then '' when ansid=212400 then '' when ansid=212401 then '' when ansid=212402 then '' when ansid=212403 then '' when ansid=212404 then '' when ansid=212405 then '' when ansid=212406 then '' when ansid=212407 then '' when ansid=212408 then '' when ansid=212409 then '' when ansid=212410 then ''  when ansid=212411 then ''   when ansid=212412 then ''   when ansid=212413 then ''   when ansid=212414 then ''   when ansid=212415 then ''   when ansid=212416 then ''   when ansid=212417 then ''   when ansid=212418 then ''   when ansid=212419 then ''   when ansid=212420 then ''  when ansid=212421 then '' when ansid=212422 then '' when ansid=212423 then ''  when ansid=212424 then ''   when ansid=212425 then ''   when ansid=212426 then ''   when ansid=212427 then ''   when ansid=212428 then ''   when ansid=212429 then ''   when ansid=212430 then ''   when ansid=212431 then ''   when ansid=212432 then ''   when ansid=212433 then ''   when ansid=212434 then ''   when ansid=212435 then ''   when ansid=212436 then ''   when ansid=212437 then ''  when ansid=212438 then '' when ansid=212439 then '' when ansid=212440 then '' when ansid=212441 then '' when ansid=212442 then '' when ansid=212443 then '' when ansid=212444 then '' when ansid=212445 then '' when ansid=212446 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:15:38'\n\t\t\t\t\t\t\tWHERE ansid in ('212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','212416','212417','212418','212419','212420','212421','212422','212423','212424','212425','212426','212427','212428','212429','212430','212431','212432','212433','212434','212435','212436','212437','212438','212439','212440','212441','212442','212443','212444','212445','212446')"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE supvisstepid = '11364'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE visitfeedbackid = '11196'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE visitfeedbackid = '11197'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE visitfeedbackid = '11198'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE visitfeedbackid = '11199'"}
{"userId":"408","date":"2021-04-05 18:15:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:15:38' WHERE visitfeedbackid = '11200'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE sitesupervision SET `siteid` = '1313', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-05', `numofsamplecollected` = '69', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2284'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE onsitestaffs SET `staffname` = 'Raju Vaishnav', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE onssid = '9464'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE onsitestaffs SET `staffname` = 'Pratima Sarkar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'The M&E of TI are working as counsellor in case of said position is vacant', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE onssid = '9465'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE onsitestaffs SET `staffname` = 'Govinda Sandekar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE onssid = '9466'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE onssid = '9467'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212391 then '2' when ansid=212392 then '6' when ansid=212393 then '2' when ansid=212394 then '0' when ansid=212395 then '0' when ansid=212396 then '1' when ansid=212397 then '1' when ansid=212398 then '1' when ansid=212399 then '1' when ansid=212400 then '1' when ansid=212401 then '1' when ansid=212402 then '1' when ansid=212403 then '1' when ansid=212404 then '1' when ansid=212405 then '1' when ansid=212406 then '1' when ansid=212407 then '' when ansid=212408 then '' when ansid=212409 then '' when ansid=212410 then ''  when ansid=212411 then ''   when ansid=212412 then ''   when ansid=212413 then ''   when ansid=212414 then ''   when ansid=212415 then ''   when ansid=212416 then ''   when ansid=212417 then ''   when ansid=212418 then ''   when ansid=212419 then ''   when ansid=212420 then ''  when ansid=212421 then '' when ansid=212422 then '' when ansid=212423 then ''  when ansid=212424 then ''   when ansid=212425 then ''   when ansid=212426 then ''   when ansid=212427 then ''   when ansid=212428 then ''   when ansid=212429 then ''   when ansid=212430 then ''   when ansid=212431 then ''   when ansid=212432 then ''   when ansid=212433 then ''   when ansid=212434 then ''   when ansid=212435 then ''   when ansid=212436 then ''   when ansid=212437 then ''  when ansid=212438 then '' when ansid=212439 then '' when ansid=212440 then '' when ansid=212441 then '' when ansid=212442 then '' when ansid=212443 then '' when ansid=212444 then '' when ansid=212445 then '' when ansid=212446 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:16:02'\n\t\t\t\t\t\t\tWHERE ansid in ('212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','212416','212417','212418','212419','212420','212421','212422','212423','212424','212425','212426','212427','212428','212429','212430','212431','212432','212433','212434','212435','212436','212437','212438','212439','212440','212441','212442','212443','212444','212445','212446')"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE supvisstepid = '11365'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE visitfeedbackid = '11196'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE visitfeedbackid = '11197'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE visitfeedbackid = '11198'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE visitfeedbackid = '11199'"}
{"userId":"408","date":"2021-04-05 18:16:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:16:02' WHERE visitfeedbackid = '11200'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE sitesupervision SET `siteid` = '1313', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-05', `numofsamplecollected` = '69', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2284'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE onsitestaffs SET `staffname` = 'Raju Vaishnav', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE onssid = '9464'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE onsitestaffs SET `staffname` = 'Pratima Sarkar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'The M&E of TI are working as counsellor in case of said position is vacant', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE onssid = '9465'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE onsitestaffs SET `staffname` = 'Govinda Sandekar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE onssid = '9466'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE onssid = '9467'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212391 then '2' when ansid=212392 then '6' when ansid=212393 then '2' when ansid=212394 then '0' when ansid=212395 then '0' when ansid=212396 then '1' when ansid=212397 then '1' when ansid=212398 then '1' when ansid=212399 then '1' when ansid=212400 then '1' when ansid=212401 then '1' when ansid=212402 then '1' when ansid=212403 then '1' when ansid=212404 then '1' when ansid=212405 then '1' when ansid=212406 then '1' when ansid=212407 then '0' when ansid=212408 then '0' when ansid=212409 then '3' when ansid=212410 then '1'  when ansid=212411 then ''   when ansid=212412 then '1'   when ansid=212413 then ''   when ansid=212414 then '1'   when ansid=212415 then ''   when ansid=212416 then '1'   when ansid=212417 then ''   when ansid=212418 then '1'   when ansid=212419 then ''   when ansid=212420 then '1'  when ansid=212421 then '1' when ansid=212422 then '1' when ansid=212423 then '1'  when ansid=212424 then ''   when ansid=212425 then '1'   when ansid=212426 then ''   when ansid=212427 then '1'   when ansid=212428 then ''   when ansid=212429 then '1'   when ansid=212430 then 'Proper colour code boxes to keep as per standard guideline also puncture proof box needed'   when ansid=212431 then '3'   when ansid=212432 then ''   when ansid=212433 then '1'   when ansid=212434 then ''   when ansid=212435 then '2'   when ansid=212436 then ''   when ansid=212437 then '2'  when ansid=212438 then '1' when ansid=212439 then '1' when ansid=212440 then '1' when ansid=212441 then '1' when ansid=212442 then '1' when ansid=212443 then 'No any' when ansid=212444 then 'No any' when ansid=212445 then 'No any' when ansid=212446 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:20:09'\n\t\t\t\t\t\t\tWHERE ansid in ('212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','212416','212417','212418','212419','212420','212421','212422','212423','212424','212425','212426','212427','212428','212429','212430','212431','212432','212433','212434','212435','212436','212437','212438','212439','212440','212441','212442','212443','212444','212445','212446')"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE supvisstepid = '11366'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE visitfeedbackid = '11196'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE visitfeedbackid = '11197'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE visitfeedbackid = '11198'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE visitfeedbackid = '11199'"}
{"userId":"408","date":"2021-04-05 18:20:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:09' WHERE visitfeedbackid = '11200'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE sitesupervision SET `siteid` = '1313', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-04-05', `numofsamplecollected` = '69', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2284'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE onsitestaffs SET `staffname` = 'Raju Vaishnav', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE onssid = '9464'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE onsitestaffs SET `staffname` = 'Pratima Sarkar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'The M&E of TI are working as counsellor in case of said position is vacant', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE onssid = '9465'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE onsitestaffs SET `staffname` = 'Govinda Sandekar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE onssid = '9466'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE onssid = '9467'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=212391 then '2' when ansid=212392 then '6' when ansid=212393 then '2' when ansid=212394 then '0' when ansid=212395 then '0' when ansid=212396 then '1' when ansid=212397 then '1' when ansid=212398 then '1' when ansid=212399 then '1' when ansid=212400 then '1' when ansid=212401 then '1' when ansid=212402 then '1' when ansid=212403 then '1' when ansid=212404 then '1' when ansid=212405 then '1' when ansid=212406 then '1' when ansid=212407 then '0' when ansid=212408 then '0' when ansid=212409 then '3' when ansid=212410 then '1'  when ansid=212411 then ''   when ansid=212412 then '1'   when ansid=212413 then ''   when ansid=212414 then '1'   when ansid=212415 then ''   when ansid=212416 then '1'   when ansid=212417 then ''   when ansid=212418 then '1'   when ansid=212419 then ''   when ansid=212420 then '1'  when ansid=212421 then '1' when ansid=212422 then '1' when ansid=212423 then '1'  when ansid=212424 then ''   when ansid=212425 then '1'   when ansid=212426 then ''   when ansid=212427 then '1'   when ansid=212428 then ''   when ansid=212429 then '1'   when ansid=212430 then 'Proper colour code boxes to keep as per standard guideline also puncture proof box needed'   when ansid=212431 then '3'   when ansid=212432 then ''   when ansid=212433 then '1'   when ansid=212434 then ''   when ansid=212435 then '2'   when ansid=212436 then ''   when ansid=212437 then '2'  when ansid=212438 then '1' when ansid=212439 then '1' when ansid=212440 then '1' when ansid=212441 then '1' when ansid=212442 then '1' when ansid=212443 then 'No any' when ansid=212444 then 'No any' when ansid=212445 then 'No any' when ansid=212446 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:20:14'\n\t\t\t\t\t\t\tWHERE ansid in ('212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','212416','212417','212418','212419','212420','212421','212422','212423','212424','212425','212426','212427','212428','212429','212430','212431','212432','212433','212434','212435','212436','212437','212438','212439','212440','212441','212442','212443','212444','212445','212446')"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE supvisstepid = '11367'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE visitfeedbackid = '11196'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE visitfeedbackid = '11197'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE visitfeedbackid = '11198'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE visitfeedbackid = '11199'"}
{"userId":"408","date":"2021-04-05 18:20:14","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:14' WHERE visitfeedbackid = '11200'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE sitesupervision SET `siteid` = '1303', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '221', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2187'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE onsitestaffs SET `staffname` = 'Rajesh Goyal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE onssid = '9076'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE onsitestaffs SET `staffname` = 'Rani Tandan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE onssid = '9077'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE onsitestaffs SET `staffname` = 'Shhjadee Khan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE onssid = '9078'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE onssid = '9079'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205364 then '2' when ansid=205365 then '1' when ansid=205366 then '1' when ansid=205367 then '0' when ansid=205368 then '0' when ansid=205369 then '2' when ansid=205370 then '2' when ansid=205371 then '' when ansid=205372 then '' when ansid=205373 then '' when ansid=205374 then '' when ansid=205375 then '' when ansid=205376 then '' when ansid=205377 then '' when ansid=205378 then '' when ansid=205379 then '' when ansid=205380 then '' when ansid=205381 then '' when ansid=205382 then '' when ansid=205383 then ''  when ansid=205384 then ''   when ansid=205385 then ''   when ansid=205386 then ''   when ansid=205387 then ''   when ansid=205388 then ''   when ansid=205389 then ''   when ansid=205390 then ''   when ansid=205391 then ''   when ansid=205392 then ''   when ansid=205393 then ''  when ansid=205394 then '' when ansid=205395 then '' when ansid=205396 then ''  when ansid=205397 then ''   when ansid=205398 then ''   when ansid=205399 then ''   when ansid=205400 then ''   when ansid=205401 then ''   when ansid=205402 then ''   when ansid=205403 then ''   when ansid=205404 then ''   when ansid=205405 then ''   when ansid=205406 then ''   when ansid=205407 then ''   when ansid=205408 then ''   when ansid=205409 then ''   when ansid=205410 then ''  when ansid=205411 then '' when ansid=205412 then '' when ansid=205413 then '' when ansid=205414 then '' when ansid=205415 then '' when ansid=205416 then '' when ansid=205417 then '' when ansid=205418 then '' when ansid=205419 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:20:50'\n\t\t\t\t\t\t\tWHERE ansid in ('205364','205365','205366','205367','205368','205369','205370','205371','205372','205373','205374','205375','205376','205377','205378','205379','205380','205381','205382','205383','205384','205385','205386','205387','205388','205389','205390','205391','205392','205393','205394','205395','205396','205397','205398','205399','205400','205401','205402','205403','205404','205405','205406','205407','205408','205409','205410','205411','205412','205413','205414','205415','205416','205417','205418','205419')"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE supvisstepid = '10951'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE visitfeedbackid = '10711'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE visitfeedbackid = '10712'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE visitfeedbackid = '10713'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE visitfeedbackid = '10714'"}
{"userId":"408","date":"2021-04-05 18:20:50","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:20:50' WHERE visitfeedbackid = '10715'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE sitesupervision SET `siteid` = '1303', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '221', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2187'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE onsitestaffs SET `staffname` = 'Rajesh Goyal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE onssid = '9076'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE onsitestaffs SET `staffname` = 'Rani Tandan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE onssid = '9077'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE onsitestaffs SET `staffname` = 'Shhjadee Khan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE onssid = '9078'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE onssid = '9079'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205364 then '2' when ansid=205365 then '1' when ansid=205366 then '1' when ansid=205367 then '0' when ansid=205368 then '0' when ansid=205369 then '2' when ansid=205370 then '2' when ansid=205371 then '1' when ansid=205372 then '1' when ansid=205373 then '1' when ansid=205374 then '1' when ansid=205375 then '1' when ansid=205376 then '1' when ansid=205377 then '1' when ansid=205378 then '3' when ansid=205379 then '1' when ansid=205380 then '' when ansid=205381 then '' when ansid=205382 then '' when ansid=205383 then ''  when ansid=205384 then ''   when ansid=205385 then ''   when ansid=205386 then ''   when ansid=205387 then ''   when ansid=205388 then ''   when ansid=205389 then ''   when ansid=205390 then ''   when ansid=205391 then ''   when ansid=205392 then ''   when ansid=205393 then ''  when ansid=205394 then '' when ansid=205395 then '' when ansid=205396 then ''  when ansid=205397 then ''   when ansid=205398 then ''   when ansid=205399 then ''   when ansid=205400 then ''   when ansid=205401 then ''   when ansid=205402 then ''   when ansid=205403 then ''   when ansid=205404 then ''   when ansid=205405 then ''   when ansid=205406 then ''   when ansid=205407 then ''   when ansid=205408 then ''   when ansid=205409 then ''   when ansid=205410 then ''  when ansid=205411 then '' when ansid=205412 then '' when ansid=205413 then '' when ansid=205414 then '' when ansid=205415 then '' when ansid=205416 then '' when ansid=205417 then '' when ansid=205418 then '' when ansid=205419 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:21:07'\n\t\t\t\t\t\t\tWHERE ansid in ('205364','205365','205366','205367','205368','205369','205370','205371','205372','205373','205374','205375','205376','205377','205378','205379','205380','205381','205382','205383','205384','205385','205386','205387','205388','205389','205390','205391','205392','205393','205394','205395','205396','205397','205398','205399','205400','205401','205402','205403','205404','205405','205406','205407','205408','205409','205410','205411','205412','205413','205414','205415','205416','205417','205418','205419')"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE supvisstepid = '10952'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE visitfeedbackid = '10711'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE visitfeedbackid = '10712'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE visitfeedbackid = '10713'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE visitfeedbackid = '10714'"}
{"userId":"408","date":"2021-04-05 18:21:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:21:07' WHERE visitfeedbackid = '10715'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE sitesupervision SET `siteid` = '1303', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '221', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2187'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE onsitestaffs SET `staffname` = 'Rajesh Goyal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE onssid = '9076'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE onsitestaffs SET `staffname` = 'Rani Tandan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE onssid = '9077'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE onsitestaffs SET `staffname` = 'Shhjadee Khan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE onssid = '9078'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE onssid = '9079'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205364 then '2' when ansid=205365 then '1' when ansid=205366 then '1' when ansid=205367 then '0' when ansid=205368 then '0' when ansid=205369 then '2' when ansid=205370 then '2' when ansid=205371 then '1' when ansid=205372 then '1' when ansid=205373 then '1' when ansid=205374 then '1' when ansid=205375 then '1' when ansid=205376 then '1' when ansid=205377 then '1' when ansid=205378 then '3' when ansid=205379 then '1' when ansid=205380 then '04' when ansid=205381 then '01' when ansid=205382 then '4' when ansid=205383 then '1'  when ansid=205384 then ''   when ansid=205385 then '1'   when ansid=205386 then ''   when ansid=205387 then '1'   when ansid=205388 then ''   when ansid=205389 then '1'   when ansid=205390 then ''   when ansid=205391 then '1'   when ansid=205392 then ''   when ansid=205393 then '1'  when ansid=205394 then '1' when ansid=205395 then '1' when ansid=205396 then '1'  when ansid=205397 then ''   when ansid=205398 then '1'   when ansid=205399 then ''   when ansid=205400 then '1'   when ansid=205401 then ''   when ansid=205402 then '1'   when ansid=205403 then ''   when ansid=205404 then '1'   when ansid=205405 then ''   when ansid=205406 then '1'   when ansid=205407 then ''   when ansid=205408 then '2'   when ansid=205409 then ''   when ansid=205410 then '2'  when ansid=205411 then '1' when ansid=205412 then '1' when ansid=205413 then '1' when ansid=205414 then '1' when ansid=205415 then '1' when ansid=205416 then 'NA' when ansid=205417 then 'NA' when ansid=205418 then 'Some little mistake found in HSS register in code  attendance which was rectified during the visit' when ansid=205419 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:24:26'\n\t\t\t\t\t\t\tWHERE ansid in ('205364','205365','205366','205367','205368','205369','205370','205371','205372','205373','205374','205375','205376','205377','205378','205379','205380','205381','205382','205383','205384','205385','205386','205387','205388','205389','205390','205391','205392','205393','205394','205395','205396','205397','205398','205399','205400','205401','205402','205403','205404','205405','205406','205407','205408','205409','205410','205411','205412','205413','205414','205415','205416','205417','205418','205419')"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE supvisstepid = '10953'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE visitfeedbackid = '10711'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE visitfeedbackid = '10712'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE visitfeedbackid = '10713'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE visitfeedbackid = '10714'"}
{"userId":"408","date":"2021-04-05 18:24:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:26' WHERE visitfeedbackid = '10715'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE sitesupervision SET `siteid` = '1303', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '221', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2187'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'Rajesh Goyal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE onssid = '9076'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'Rani Tandan', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE onssid = '9077'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE onsitestaffs SET `staffname` = 'Shhjadee Khan', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE onssid = '9078'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE onssid = '9079'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=205364 then '2' when ansid=205365 then '1' when ansid=205366 then '1' when ansid=205367 then '0' when ansid=205368 then '0' when ansid=205369 then '2' when ansid=205370 then '2' when ansid=205371 then '1' when ansid=205372 then '1' when ansid=205373 then '1' when ansid=205374 then '1' when ansid=205375 then '1' when ansid=205376 then '1' when ansid=205377 then '1' when ansid=205378 then '3' when ansid=205379 then '1' when ansid=205380 then '04' when ansid=205381 then '01' when ansid=205382 then '4' when ansid=205383 then '1'  when ansid=205384 then ''   when ansid=205385 then '1'   when ansid=205386 then ''   when ansid=205387 then '1'   when ansid=205388 then ''   when ansid=205389 then '1'   when ansid=205390 then ''   when ansid=205391 then '1'   when ansid=205392 then ''   when ansid=205393 then '1'  when ansid=205394 then '1' when ansid=205395 then '1' when ansid=205396 then '1'  when ansid=205397 then ''   when ansid=205398 then '1'   when ansid=205399 then ''   when ansid=205400 then '1'   when ansid=205401 then ''   when ansid=205402 then '1'   when ansid=205403 then ''   when ansid=205404 then '1'   when ansid=205405 then ''   when ansid=205406 then '1'   when ansid=205407 then ''   when ansid=205408 then '2'   when ansid=205409 then ''   when ansid=205410 then '2'  when ansid=205411 then '1' when ansid=205412 then '1' when ansid=205413 then '1' when ansid=205414 then '1' when ansid=205415 then '1' when ansid=205416 then 'NA' when ansid=205417 then 'NA' when ansid=205418 then 'Some little mistake found in HSS register in code  attendance which was rectified during the visit' when ansid=205419 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:24:31'\n\t\t\t\t\t\t\tWHERE ansid in ('205364','205365','205366','205367','205368','205369','205370','205371','205372','205373','205374','205375','205376','205377','205378','205379','205380','205381','205382','205383','205384','205385','205386','205387','205388','205389','205390','205391','205392','205393','205394','205395','205396','205397','205398','205399','205400','205401','205402','205403','205404','205405','205406','205407','205408','205409','205410','205411','205412','205413','205414','205415','205416','205417','205418','205419')"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE supvisstepid = '10954'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE visitfeedbackid = '10711'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE visitfeedbackid = '10712'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE visitfeedbackid = '10713'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE visitfeedbackid = '10714'"}
{"userId":"408","date":"2021-04-05 18:24:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:24:31' WHERE visitfeedbackid = '10715'"}
{"userId":"408","date":"2021-04-05 18:30:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('408', '45.124.145.86', '2021-04-05 18:30:05')"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE sitesupervision SET `siteid` = '1314', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '57', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2235'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE onssid = '9268'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohbe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE onssid = '9269'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE onssid = '9270'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE onssid = '9271'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209119 then '1' when ansid=209120 then '6' when ansid=209121 then '2' when ansid=209122 then '0' when ansid=209123 then '0' when ansid=209124 then '1' when ansid=209125 then '1' when ansid=209126 then '' when ansid=209127 then '' when ansid=209128 then '' when ansid=209129 then '' when ansid=209130 then '' when ansid=209131 then '' when ansid=209132 then '' when ansid=209133 then '' when ansid=209134 then '' when ansid=209135 then '' when ansid=209136 then '' when ansid=209137 then '' when ansid=209138 then ''  when ansid=209139 then ''   when ansid=209140 then ''   when ansid=209141 then ''   when ansid=209142 then ''   when ansid=209143 then ''   when ansid=209144 then ''   when ansid=209145 then ''   when ansid=209146 then ''   when ansid=209147 then ''   when ansid=209148 then ''  when ansid=209149 then '' when ansid=209150 then '' when ansid=209151 then ''  when ansid=209152 then ''   when ansid=209153 then ''   when ansid=209154 then ''   when ansid=209155 then ''   when ansid=209156 then ''   when ansid=209157 then ''   when ansid=209158 then ''   when ansid=209159 then ''   when ansid=209160 then ''   when ansid=209161 then ''   when ansid=209162 then ''   when ansid=209163 then ''   when ansid=209164 then ''   when ansid=209165 then ''  when ansid=209166 then '' when ansid=209167 then '' when ansid=209168 then '' when ansid=209169 then '' when ansid=209170 then '' when ansid=209171 then '' when ansid=209172 then '' when ansid=209173 then '' when ansid=209174 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:32:55'\n\t\t\t\t\t\t\tWHERE ansid in ('209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174')"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE supvisstepid = '11159'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE visitfeedbackid = '10951'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE visitfeedbackid = '10952'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE visitfeedbackid = '10953'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE visitfeedbackid = '10954'"}
{"userId":"408","date":"2021-04-05 18:32:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:32:55' WHERE visitfeedbackid = '10955'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE sitesupervision SET `siteid` = '1314', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '57', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2235'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE onssid = '9268'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohbe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE onssid = '9269'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE onssid = '9270'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE onssid = '9271'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209119 then '1' when ansid=209120 then '6' when ansid=209121 then '2' when ansid=209122 then '0' when ansid=209123 then '0' when ansid=209124 then '1' when ansid=209125 then '1' when ansid=209126 then '1' when ansid=209127 then '1' when ansid=209128 then '1' when ansid=209129 then '1' when ansid=209130 then '1' when ansid=209131 then '1' when ansid=209132 then '1' when ansid=209133 then '1' when ansid=209134 then '1' when ansid=209135 then '' when ansid=209136 then '' when ansid=209137 then '' when ansid=209138 then ''  when ansid=209139 then ''   when ansid=209140 then ''   when ansid=209141 then ''   when ansid=209142 then ''   when ansid=209143 then ''   when ansid=209144 then ''   when ansid=209145 then ''   when ansid=209146 then ''   when ansid=209147 then ''   when ansid=209148 then ''  when ansid=209149 then '' when ansid=209150 then '' when ansid=209151 then ''  when ansid=209152 then ''   when ansid=209153 then ''   when ansid=209154 then ''   when ansid=209155 then ''   when ansid=209156 then ''   when ansid=209157 then ''   when ansid=209158 then ''   when ansid=209159 then ''   when ansid=209160 then ''   when ansid=209161 then ''   when ansid=209162 then ''   when ansid=209163 then ''   when ansid=209164 then ''   when ansid=209165 then ''  when ansid=209166 then '' when ansid=209167 then '' when ansid=209168 then '' when ansid=209169 then '' when ansid=209170 then '' when ansid=209171 then '' when ansid=209172 then '' when ansid=209173 then '' when ansid=209174 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:33:17'\n\t\t\t\t\t\t\tWHERE ansid in ('209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174')"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE supvisstepid = '11160'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE visitfeedbackid = '10951'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE visitfeedbackid = '10952'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE visitfeedbackid = '10953'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE visitfeedbackid = '10954'"}
{"userId":"408","date":"2021-04-05 18:33:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:33:17' WHERE visitfeedbackid = '10955'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE sitesupervision SET `siteid` = '1314', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '57', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2235'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE onssid = '9268'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohbe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE onssid = '9269'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE onssid = '9270'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE onssid = '9271'"}
{"userId":"408","date":"2021-04-05 18:45:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209119 then '1' when ansid=209120 then '6' when ansid=209121 then '2' when ansid=209122 then '0' when ansid=209123 then '0' when ansid=209124 then '1' when ansid=209125 then '1' when ansid=209126 then '1' when ansid=209127 then '1' when ansid=209128 then '1' when ansid=209129 then '1' when ansid=209130 then '1' when ansid=209131 then '1' when ansid=209132 then '1' when ansid=209133 then '1' when ansid=209134 then '1' when ansid=209135 then '2' when ansid=209136 then '0' when ansid=209137 then '2' when ansid=209138 then '1'  when ansid=209139 then ''   when ansid=209140 then '1'   when ansid=209141 then ''   when ansid=209142 then '1'   when ansid=209143 then ''   when ansid=209144 then '1'   when ansid=209145 then ''   when ansid=209146 then '1'   when ansid=209147 then ''   when ansid=209148 then '1'  when ansid=209149 then '2' when ansid=209150 then '1' when ansid=209151 then '1'  when ansid=209152 then ''   when ansid=209153 then '1'   when ansid=209154 then ''   when ansid=209155 then '1'   when ansid=209156 then ''   when ansid=209157 then '1'   when ansid=209158 then ''   when ansid=209159 then '1'   when ansid=209160 then ''   when ansid=209161 then '1'   when ansid=209162 then ''   when ansid=209163 then '1'   when ansid=209164 then ''   when ansid=209165 then '2'  when ansid=209166 then '1' when ansid=209167 then '1' when ansid=209168 then '1' when ansid=209169 then '1' when ansid=209170 then '1' when ansid=209171 then 'No any' when ansid=209172 then 'The observation made by  officials from supervision  team was being follow by site personals' when ansid=209173 then '1) The office cum DIC area should be more specious 2) Bio Medical Waste management need to standardised' when ansid=209174 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:45:45'\n\t\t\t\t\t\t\tWHERE ansid in ('209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174')"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE supvisstepid = '11161'"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE visitfeedbackid = '10951'"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE visitfeedbackid = '10952'"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE visitfeedbackid = '10953'"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE visitfeedbackid = '10954'"}
{"userId":"408","date":"2021-04-05 18:45:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:45' WHERE visitfeedbackid = '10955'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE sitesupervision SET `siteid` = '1314', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '57', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2235'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE onssid = '9268'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohbe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE onssid = '9269'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE onssid = '9270'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE onssid = '9271'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209119 then '1' when ansid=209120 then '6' when ansid=209121 then '2' when ansid=209122 then '0' when ansid=209123 then '0' when ansid=209124 then '1' when ansid=209125 then '1' when ansid=209126 then '1' when ansid=209127 then '1' when ansid=209128 then '1' when ansid=209129 then '1' when ansid=209130 then '1' when ansid=209131 then '1' when ansid=209132 then '1' when ansid=209133 then '1' when ansid=209134 then '1' when ansid=209135 then '2' when ansid=209136 then '0' when ansid=209137 then '2' when ansid=209138 then '1'  when ansid=209139 then ''   when ansid=209140 then '1'   when ansid=209141 then ''   when ansid=209142 then '1'   when ansid=209143 then ''   when ansid=209144 then '1'   when ansid=209145 then ''   when ansid=209146 then '1'   when ansid=209147 then ''   when ansid=209148 then '1'  when ansid=209149 then '2' when ansid=209150 then '1' when ansid=209151 then '1'  when ansid=209152 then ''   when ansid=209153 then '1'   when ansid=209154 then ''   when ansid=209155 then '1'   when ansid=209156 then ''   when ansid=209157 then '1'   when ansid=209158 then ''   when ansid=209159 then '1'   when ansid=209160 then ''   when ansid=209161 then '1'   when ansid=209162 then ''   when ansid=209163 then '1'   when ansid=209164 then ''   when ansid=209165 then '2'  when ansid=209166 then '1' when ansid=209167 then '1' when ansid=209168 then '1' when ansid=209169 then '1' when ansid=209170 then '1' when ansid=209171 then 'No any' when ansid=209172 then 'The observation made by  officials from supervision  team was being follow by site personals' when ansid=209173 then '1) The office cum DIC area should be more specious 2) Bio Medical Waste management need to standardised' when ansid=209174 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 18:45:58'\n\t\t\t\t\t\t\tWHERE ansid in ('209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174')"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE supvisstepid = '11162'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE visitfeedbackid = '10951'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE visitfeedbackid = '10952'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE visitfeedbackid = '10953'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE visitfeedbackid = '10954'"}
{"userId":"408","date":"2021-04-05 18:45:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 18:45:58' WHERE visitfeedbackid = '10955'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE sitesupervision SET `siteid` = '1299', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '232', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2234'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE onsitestaffs SET `staffname` = 'Khemlata Khobragadhe', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE onssid = '9264'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE onsitestaffs SET `staffname` = 'Bharti Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE onssid = '9265'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE onsitestaffs SET `staffname` = 'Kunti Koushal', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE onssid = '9266'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE onssid = '9267'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209063 then '2' when ansid=209064 then '1' when ansid=209065 then '1' when ansid=209066 then '0' when ansid=209067 then '0' when ansid=209068 then '1' when ansid=209069 then '1' when ansid=209070 then '' when ansid=209071 then '' when ansid=209072 then '' when ansid=209073 then '' when ansid=209074 then '' when ansid=209075 then '' when ansid=209076 then '' when ansid=209077 then '' when ansid=209078 then '' when ansid=209079 then '' when ansid=209080 then '' when ansid=209081 then '' when ansid=209082 then ''  when ansid=209083 then ''   when ansid=209084 then ''   when ansid=209085 then ''   when ansid=209086 then ''   when ansid=209087 then ''   when ansid=209088 then ''   when ansid=209089 then ''   when ansid=209090 then ''   when ansid=209091 then ''   when ansid=209092 then ''  when ansid=209093 then '' when ansid=209094 then '' when ansid=209095 then ''  when ansid=209096 then ''   when ansid=209097 then ''   when ansid=209098 then ''   when ansid=209099 then ''   when ansid=209100 then ''   when ansid=209101 then ''   when ansid=209102 then ''   when ansid=209103 then ''   when ansid=209104 then ''   when ansid=209105 then ''   when ansid=209106 then ''   when ansid=209107 then ''   when ansid=209108 then ''   when ansid=209109 then ''  when ansid=209110 then '' when ansid=209111 then '' when ansid=209112 then '' when ansid=209113 then '' when ansid=209114 then '' when ansid=209115 then '' when ansid=209116 then '' when ansid=209117 then '' when ansid=209118 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:00:31'\n\t\t\t\t\t\t\tWHERE ansid in ('209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118')"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE supvisstepid = '11155'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE visitfeedbackid = '10946'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE visitfeedbackid = '10947'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE visitfeedbackid = '10948'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE visitfeedbackid = '10949'"}
{"userId":"408","date":"2021-04-05 19:00:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:00:31' WHERE visitfeedbackid = '10950'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE sitesupervision SET `siteid` = '1299', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '232', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2234'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE onsitestaffs SET `staffname` = 'Khemlata Khobragadhe', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE onssid = '9264'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE onsitestaffs SET `staffname` = 'Bharti Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE onssid = '9265'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE onsitestaffs SET `staffname` = 'Kunti Koushal', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE onssid = '9266'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE onssid = '9267'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209063 then '2' when ansid=209064 then '1' when ansid=209065 then '1' when ansid=209066 then '0' when ansid=209067 then '0' when ansid=209068 then '1' when ansid=209069 then '1' when ansid=209070 then '1' when ansid=209071 then '1' when ansid=209072 then '1' when ansid=209073 then '1' when ansid=209074 then '1' when ansid=209075 then '1' when ansid=209076 then '1' when ansid=209077 then '1' when ansid=209078 then '1' when ansid=209079 then '' when ansid=209080 then '' when ansid=209081 then '' when ansid=209082 then ''  when ansid=209083 then ''   when ansid=209084 then ''   when ansid=209085 then ''   when ansid=209086 then ''   when ansid=209087 then ''   when ansid=209088 then ''   when ansid=209089 then ''   when ansid=209090 then ''   when ansid=209091 then ''   when ansid=209092 then ''  when ansid=209093 then '' when ansid=209094 then '' when ansid=209095 then ''  when ansid=209096 then ''   when ansid=209097 then ''   when ansid=209098 then ''   when ansid=209099 then ''   when ansid=209100 then ''   when ansid=209101 then ''   when ansid=209102 then ''   when ansid=209103 then ''   when ansid=209104 then ''   when ansid=209105 then ''   when ansid=209106 then ''   when ansid=209107 then ''   when ansid=209108 then ''   when ansid=209109 then ''  when ansid=209110 then '' when ansid=209111 then '' when ansid=209112 then '' when ansid=209113 then '' when ansid=209114 then '' when ansid=209115 then '' when ansid=209116 then '' when ansid=209117 then '' when ansid=209118 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:02:13'\n\t\t\t\t\t\t\tWHERE ansid in ('209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118')"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE supvisstepid = '11156'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE visitfeedbackid = '10946'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE visitfeedbackid = '10947'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE visitfeedbackid = '10948'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE visitfeedbackid = '10949'"}
{"userId":"408","date":"2021-04-05 19:02:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:02:13' WHERE visitfeedbackid = '10950'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE sitesupervision SET `siteid` = '1299', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '232', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2234'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE onsitestaffs SET `staffname` = 'Khemlata Khobragadhe', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE onssid = '9264'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE onsitestaffs SET `staffname` = 'Bharti Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE onssid = '9265'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE onsitestaffs SET `staffname` = 'Kunti Koushal', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE onssid = '9266'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE onssid = '9267'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209063 then '2' when ansid=209064 then '1' when ansid=209065 then '1' when ansid=209066 then '0' when ansid=209067 then '0' when ansid=209068 then '1' when ansid=209069 then '1' when ansid=209070 then '1' when ansid=209071 then '1' when ansid=209072 then '1' when ansid=209073 then '1' when ansid=209074 then '1' when ansid=209075 then '1' when ansid=209076 then '1' when ansid=209077 then '1' when ansid=209078 then '1' when ansid=209079 then '4' when ansid=209080 then '0' when ansid=209081 then '0' when ansid=209082 then '1'  when ansid=209083 then ''   when ansid=209084 then '1'   when ansid=209085 then ''   when ansid=209086 then '1'   when ansid=209087 then ''   when ansid=209088 then '1'   when ansid=209089 then ''   when ansid=209090 then '1'   when ansid=209091 then ''   when ansid=209092 then '1'  when ansid=209093 then '1' when ansid=209094 then '1' when ansid=209095 then '1'  when ansid=209096 then ''   when ansid=209097 then '1'   when ansid=209098 then ''   when ansid=209099 then '1'   when ansid=209100 then ''   when ansid=209101 then '1'   when ansid=209102 then ''   when ansid=209103 then '1'   when ansid=209104 then ''   when ansid=209105 then '1'   when ansid=209106 then ''   when ansid=209107 then '2'   when ansid=209108 then ''   when ansid=209109 then '2'  when ansid=209110 then '1' when ansid=209111 then '1' when ansid=209112 then '1' when ansid=209113 then '1' when ansid=209114 then '1' when ansid=209115 then 'no any' when ansid=209116 then 'The site are following the recommendations made by earlier visits' when ansid=209117 then '1) As the site had sent samples with wrong site code earlier and matter was addressed by NICED, it is yet to be resolve2) The site personal who are writing the samples to be keep appropriate code accordingly 3) Some little mistake has  been observed in HSS Register which was rectified  during the visit' when ansid=209118 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:18:02'\n\t\t\t\t\t\t\tWHERE ansid in ('209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118')"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE supvisstepid = '11157'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE visitfeedbackid = '10946'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE visitfeedbackid = '10947'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE visitfeedbackid = '10948'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE visitfeedbackid = '10949'"}
{"userId":"408","date":"2021-04-05 19:18:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:02' WHERE visitfeedbackid = '10950'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE sitesupervision SET `siteid` = '1299', `userid` = '408', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '232', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2234'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE onsitestaffs SET `staffname` = 'Khemlata Khobragadhe', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE onssid = '9264'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE onsitestaffs SET `staffname` = 'Bharti Sahu', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE onssid = '9265'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE onsitestaffs SET `staffname` = 'Kunti Koushal', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE onssid = '9266'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE onssid = '9267'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=209063 then '2' when ansid=209064 then '1' when ansid=209065 then '1' when ansid=209066 then '0' when ansid=209067 then '0' when ansid=209068 then '1' when ansid=209069 then '1' when ansid=209070 then '1' when ansid=209071 then '1' when ansid=209072 then '1' when ansid=209073 then '1' when ansid=209074 then '1' when ansid=209075 then '1' when ansid=209076 then '1' when ansid=209077 then '1' when ansid=209078 then '1' when ansid=209079 then '4' when ansid=209080 then '0' when ansid=209081 then '0' when ansid=209082 then '1'  when ansid=209083 then ''   when ansid=209084 then '1'   when ansid=209085 then ''   when ansid=209086 then '1'   when ansid=209087 then ''   when ansid=209088 then '1'   when ansid=209089 then ''   when ansid=209090 then '1'   when ansid=209091 then ''   when ansid=209092 then '1'  when ansid=209093 then '1' when ansid=209094 then '1' when ansid=209095 then '1'  when ansid=209096 then ''   when ansid=209097 then '1'   when ansid=209098 then ''   when ansid=209099 then '1'   when ansid=209100 then ''   when ansid=209101 then '1'   when ansid=209102 then ''   when ansid=209103 then '1'   when ansid=209104 then ''   when ansid=209105 then '1'   when ansid=209106 then ''   when ansid=209107 then '2'   when ansid=209108 then ''   when ansid=209109 then '2'  when ansid=209110 then '1' when ansid=209111 then '1' when ansid=209112 then '1' when ansid=209113 then '1' when ansid=209114 then '1' when ansid=209115 then 'no any' when ansid=209116 then 'The site are following the recommendations made by earlier visits' when ansid=209117 then '1) As the site had sent samples with wrong site code earlier and matter was addressed by NICED, it is yet to be resolve2) The site personal who are writing the samples to be keep appropriate code accordingly 3) Some little mistake has  been observed in HSS Register which was rectified  during the visit' when ansid=209118 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =408,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:18:09'\n\t\t\t\t\t\t\tWHERE ansid in ('209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118')"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE supvisstepid = '11158'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE visitfeedbackid = '10946'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE visitfeedbackid = '10947'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE visitfeedbackid = '10948'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE visitfeedbackid = '10949'"}
{"userId":"408","date":"2021-04-05 19:18:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '408', `modifieddate` = '2021-04-05 19:18:09' WHERE visitfeedbackid = '10950'"}
{"userId":"403","date":"2021-04-05 19:21:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('403', '45.124.145.86', '2021-04-05 19:21:24')"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE sitesupervision SET `siteid` = '1305', `userid` = '403', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '250', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2195'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE onssid = '9108'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohobe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE onssid = '9109'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE onssid = '9110'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE onssid = '9111'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206040 then '1' when ansid=206041 then '2' when ansid=206042 then '1' when ansid=206043 then '0' when ansid=206044 then '0' when ansid=206045 then '1' when ansid=206046 then '1' when ansid=206047 then '' when ansid=206048 then '' when ansid=206049 then '' when ansid=206050 then '' when ansid=206051 then '' when ansid=206052 then '' when ansid=206053 then '' when ansid=206054 then '' when ansid=206055 then '' when ansid=206056 then '' when ansid=206057 then '' when ansid=206058 then '' when ansid=206059 then ''  when ansid=206060 then ''   when ansid=206061 then ''   when ansid=206062 then ''   when ansid=206063 then ''   when ansid=206064 then ''   when ansid=206065 then ''   when ansid=206066 then ''   when ansid=206067 then ''   when ansid=206068 then ''   when ansid=206069 then ''  when ansid=206070 then '' when ansid=206071 then '' when ansid=206072 then ''  when ansid=206073 then ''   when ansid=206074 then ''   when ansid=206075 then ''   when ansid=206076 then ''   when ansid=206077 then ''   when ansid=206078 then ''   when ansid=206079 then ''   when ansid=206080 then ''   when ansid=206081 then ''   when ansid=206082 then ''   when ansid=206083 then ''   when ansid=206084 then ''   when ansid=206085 then ''   when ansid=206086 then ''  when ansid=206087 then '' when ansid=206088 then '' when ansid=206089 then '' when ansid=206090 then '' when ansid=206091 then '' when ansid=206092 then '' when ansid=206093 then '' when ansid=206094 then '' when ansid=206095 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =403,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:23:55'\n\t\t\t\t\t\t\tWHERE ansid in ('206040','206041','206042','206043','206044','206045','206046','206047','206048','206049','206050','206051','206052','206053','206054','206055','206056','206057','206058','206059','206060','206061','206062','206063','206064','206065','206066','206067','206068','206069','206070','206071','206072','206073','206074','206075','206076','206077','206078','206079','206080','206081','206082','206083','206084','206085','206086','206087','206088','206089','206090','206091','206092','206093','206094','206095')"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE supvisstepid = '10986'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE visitfeedbackid = '10751'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE visitfeedbackid = '10752'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE visitfeedbackid = '10753'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE visitfeedbackid = '10754'"}
{"userId":"403","date":"2021-04-05 19:23:55","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:23:55' WHERE visitfeedbackid = '10755'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE sitesupervision SET `siteid` = '1305', `userid` = '403', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '250', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2195'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE onssid = '9108'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohobe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE onssid = '9109'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE onssid = '9110'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE onssid = '9111'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206040 then '1' when ansid=206041 then '2' when ansid=206042 then '1' when ansid=206043 then '0' when ansid=206044 then '0' when ansid=206045 then '1' when ansid=206046 then '1' when ansid=206047 then '1' when ansid=206048 then '1' when ansid=206049 then '1' when ansid=206050 then '1' when ansid=206051 then '1' when ansid=206052 then '1' when ansid=206053 then '1' when ansid=206054 then '1' when ansid=206055 then '1' when ansid=206056 then '' when ansid=206057 then '' when ansid=206058 then '' when ansid=206059 then ''  when ansid=206060 then ''   when ansid=206061 then ''   when ansid=206062 then ''   when ansid=206063 then ''   when ansid=206064 then ''   when ansid=206065 then ''   when ansid=206066 then ''   when ansid=206067 then ''   when ansid=206068 then ''   when ansid=206069 then ''  when ansid=206070 then '' when ansid=206071 then '' when ansid=206072 then ''  when ansid=206073 then ''   when ansid=206074 then ''   when ansid=206075 then ''   when ansid=206076 then ''   when ansid=206077 then ''   when ansid=206078 then ''   when ansid=206079 then ''   when ansid=206080 then ''   when ansid=206081 then ''   when ansid=206082 then ''   when ansid=206083 then ''   when ansid=206084 then ''   when ansid=206085 then ''   when ansid=206086 then ''  when ansid=206087 then '' when ansid=206088 then '' when ansid=206089 then '' when ansid=206090 then '' when ansid=206091 then '' when ansid=206092 then '' when ansid=206093 then '' when ansid=206094 then '' when ansid=206095 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =403,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:24:08'\n\t\t\t\t\t\t\tWHERE ansid in ('206040','206041','206042','206043','206044','206045','206046','206047','206048','206049','206050','206051','206052','206053','206054','206055','206056','206057','206058','206059','206060','206061','206062','206063','206064','206065','206066','206067','206068','206069','206070','206071','206072','206073','206074','206075','206076','206077','206078','206079','206080','206081','206082','206083','206084','206085','206086','206087','206088','206089','206090','206091','206092','206093','206094','206095')"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE supvisstepid = '10987'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE visitfeedbackid = '10751'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE visitfeedbackid = '10752'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE visitfeedbackid = '10753'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE visitfeedbackid = '10754'"}
{"userId":"403","date":"2021-04-05 19:24:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:24:08' WHERE visitfeedbackid = '10755'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE sitesupervision SET `siteid` = '1305', `userid` = '403', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '250', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2195'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE onssid = '9108'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohobe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE onssid = '9109'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE onssid = '9110'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE onssid = '9111'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206040 then '1' when ansid=206041 then '2' when ansid=206042 then '1' when ansid=206043 then '0' when ansid=206044 then '0' when ansid=206045 then '1' when ansid=206046 then '1' when ansid=206047 then '1' when ansid=206048 then '1' when ansid=206049 then '1' when ansid=206050 then '1' when ansid=206051 then '1' when ansid=206052 then '1' when ansid=206053 then '1' when ansid=206054 then '1' when ansid=206055 then '1' when ansid=206056 then '0' when ansid=206057 then '0' when ansid=206058 then '0' when ansid=206059 then '1'  when ansid=206060 then ''   when ansid=206061 then '1'   when ansid=206062 then ''   when ansid=206063 then '1'   when ansid=206064 then ''   when ansid=206065 then '1'   when ansid=206066 then ''   when ansid=206067 then '1'   when ansid=206068 then ''   when ansid=206069 then '1'  when ansid=206070 then '1' when ansid=206071 then '1' when ansid=206072 then '1'  when ansid=206073 then ''   when ansid=206074 then '1'   when ansid=206075 then ''   when ansid=206076 then '1'   when ansid=206077 then ''   when ansid=206078 then '1'   when ansid=206079 then ''   when ansid=206080 then '1'   when ansid=206081 then ''   when ansid=206082 then '1'   when ansid=206083 then ''   when ansid=206084 then '2'   when ansid=206085 then ''   when ansid=206086 then '2'  when ansid=206087 then '1' when ansid=206088 then '1' when ansid=206089 then '1' when ansid=206090 then '1' when ansid=206091 then '1' when ansid=206092 then 'No any' when ansid=206093 then 'The site followed the given recommendation' when ansid=206094 then 'The site completed the target sample size as 250' when ansid=206095 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =403,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:26:19'\n\t\t\t\t\t\t\tWHERE ansid in ('206040','206041','206042','206043','206044','206045','206046','206047','206048','206049','206050','206051','206052','206053','206054','206055','206056','206057','206058','206059','206060','206061','206062','206063','206064','206065','206066','206067','206068','206069','206070','206071','206072','206073','206074','206075','206076','206077','206078','206079','206080','206081','206082','206083','206084','206085','206086','206087','206088','206089','206090','206091','206092','206093','206094','206095')"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE supvisstepid = '10988'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE visitfeedbackid = '10751'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE visitfeedbackid = '10752'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE visitfeedbackid = '10753'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE visitfeedbackid = '10754'"}
{"userId":"403","date":"2021-04-05 19:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:19' WHERE visitfeedbackid = '10755'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE sitesupervision SET `siteid` = '1305', `userid` = '403', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-01', `numofsamplecollected` = '250', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2195'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE onsitestaffs SET `staffname` = 'Vijay Arora', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE onssid = '9108'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE onsitestaffs SET `staffname` = 'Deepak Mohobe', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE onssid = '9109'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE onsitestaffs SET `staffname` = 'Aswan Yadav', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE onssid = '9110'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE onssid = '9111'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=206040 then '1' when ansid=206041 then '2' when ansid=206042 then '1' when ansid=206043 then '0' when ansid=206044 then '0' when ansid=206045 then '1' when ansid=206046 then '1' when ansid=206047 then '1' when ansid=206048 then '1' when ansid=206049 then '1' when ansid=206050 then '1' when ansid=206051 then '1' when ansid=206052 then '1' when ansid=206053 then '1' when ansid=206054 then '1' when ansid=206055 then '1' when ansid=206056 then '0' when ansid=206057 then '0' when ansid=206058 then '0' when ansid=206059 then '1'  when ansid=206060 then ''   when ansid=206061 then '1'   when ansid=206062 then ''   when ansid=206063 then '1'   when ansid=206064 then ''   when ansid=206065 then '1'   when ansid=206066 then ''   when ansid=206067 then '1'   when ansid=206068 then ''   when ansid=206069 then '1'  when ansid=206070 then '1' when ansid=206071 then '1' when ansid=206072 then '1'  when ansid=206073 then ''   when ansid=206074 then '1'   when ansid=206075 then ''   when ansid=206076 then '1'   when ansid=206077 then ''   when ansid=206078 then '1'   when ansid=206079 then ''   when ansid=206080 then '1'   when ansid=206081 then ''   when ansid=206082 then '1'   when ansid=206083 then ''   when ansid=206084 then '2'   when ansid=206085 then ''   when ansid=206086 then '2'  when ansid=206087 then '1' when ansid=206088 then '1' when ansid=206089 then '1' when ansid=206090 then '1' when ansid=206091 then '1' when ansid=206092 then 'No any' when ansid=206093 then 'The site followed the given recommendation' when ansid=206094 then 'The site completed the target sample size as 250' when ansid=206095 then '1' end),\n\t\t\t\t\t\t\t\t ipaddress = '45.124.145.86',\n\t\t\t\t\t\t\t\tmodifiedby =403,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-05 19:26:27'\n\t\t\t\t\t\t\tWHERE ansid in ('206040','206041','206042','206043','206044','206045','206046','206047','206048','206049','206050','206051','206052','206053','206054','206055','206056','206057','206058','206059','206060','206061','206062','206063','206064','206065','206066','206067','206068','206069','206070','206071','206072','206073','206074','206075','206076','206077','206078','206079','206080','206081','206082','206083','206084','206085','206086','206087','206088','206089','206090','206091','206092','206093','206094','206095')"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE supvisstepid = '10989'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE visitfeedbackid = '10751'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE visitfeedbackid = '10752'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE visitfeedbackid = '10753'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE visitfeedbackid = '10754'"}
{"userId":"403","date":"2021-04-05 19:26:27","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '45.124.145.86', `modifiedby` = '403', `modifieddate` = '2021-04-05 19:26:27' WHERE visitfeedbackid = '10755'"}