Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe
Commits:
-
ddc07eea
by Tony Chemit at 2022-12-02T13:01:35+01:00
1 changed file:
Changes:
| ... | ... | @@ -1069,8 +1069,14 @@ Select vessel.code,\ |
| 1069 | 1069 | concat(day(t.endDate), '/', month(t.endDate), '/', year(t.endDate)), \
|
| 1070 | 1070 | departureHarbour.label2, \
|
| 1071 | 1071 | landingHarbour.label2, \
|
| 1072 | - 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, \
|
|
| 1073 | - 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, \
|
|
| 1072 | + case departureWellContentStatus.id when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#01' then 'Oui' \
|
|
| 1073 | + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#02' then 'Non' \
|
|
| 1074 | + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#03' then 'Inconnu' \
|
|
| 1075 | + else 'Non Renseigné' end, \
|
|
| 1076 | + case landingWellContentStatus.id when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#01' then 'Oui' \
|
|
| 1077 | + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#02' then 'Non' \
|
|
| 1078 | + when 'fr.ird.referential.ps.logbook.WellContentStatus#1464000000000#03' then 'Inconnu' \
|
|
| 1079 | + else 'Non Renseigné' end, \
|
|
| 1074 | 1080 | t.timeAtSea, \
|
| 1075 | 1081 | t.fishingTime, \
|
| 1076 | 1082 | (select Sum(l.weight) from t.landing l), \
|