Tony CHEMIT pushed to branch develop-9.0.x at ultreiaio / ird-observe Commits: 8c7cf3fd by Tony Chemit at 2022-12-02T13:01:20+01:00 Rapport LB - Vérification croisée des débarquements, colonnes cuves vides erronées - Closes #2551 - - - - - 1 changed file: - core/api/dto/src/main/resources/observe-reports.properties Changes: ===================================== core/api/dto/src/main/resources/observe-reports.properties ===================================== @@ -1069,8 +1069,14 @@ Select vessel.code,\ concat(day(t.endDate), '/', month(t.endDate), '/', year(t.endDate)), \ departureHarbour.label2, \ landingHarbour.label2, \ - case when departureWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#001' then 'Oui' when departureWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#002' then 'Non' when departureWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#003' then 'Inconnu' else 'Non Renseigné' end, \ - case when landingWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#001' then 'Oui' when landingWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#002' then 'Non' when departureWellContentStatus.id = 'fr.ird.referential.ps.common.AcquisitionStatus#1464000000000#003' then 'Inconnu' else 'Non Renseigné' end, \ + case departureWellContentStatus.id when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#01' then 'Oui' \ + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#02' then 'Non' \ + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#03' then 'Inconnu' \ + else 'Non Renseigné' end, \ + case landingWellContentStatus.id when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#01' then 'Oui' \ + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#02' then 'Non' \ + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#03' then 'Inconnu' \ + else 'Non Renseigné' end, \ t.timeAtSea, \ t.fishingTime, \ (select Sum(l.weight) from t.landing l), \ View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/8c7cf3fd7d9c54cf6e56b9935f... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/8c7cf3fd7d9c54cf6e56b9935f... You're receiving this email because of your account on gitlab.com.