Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe

Commits:

2 changed files:

Changes:

  • core/persistence/report/src/main/resources/observe-reports.properties
    ... ... @@ -920,6 +920,16 @@ report.psLogbookWellPlanCheck.modelType=PS
    920 920 
     report.psLogbookWellPlanCheck.name=Livre de bord - Vérification des plan de cuves
    921 921 
     report.psLogbookWellPlanCheck.description=Livre de bord - Vérification des plan de cuves
    922 922 
     report.psLogbookWellPlanCheck.columns=Code bateau,Nom bateau,Date départ,Date arrivée,Date de route,Numéro activité,Heure activité,Logbook YFT,Logbook SKJ,Logbook BET,Logbook ALB,Logbook Autres,Plan de cuves YFT,Plan de cuves SKJ,Plan de cuves BET,Plan de cuves ALB,Plan de cuves Autres,Logbook Total,Plan de cuves Total,Différence
    923 
    +report.psLogbookWellPlanCheck.repeatVariable.1.name=activity
    924 
    +report.psLogbookWellPlanCheck.repeatVariable.1.type=fr.ird.observe.entities.data.ps.logbook.Activity
    925 
    +report.psLogbookWellPlanCheck.repeatVariable.1.request=Select a \
    926 
    +From TripImpl t \
    927 
    +Join t.routeLogbook r \
    928 
    +Join r.activity a \
    929 
    +Join t.vessel vessel \
    930 
    +Left Join a.vesselActivity vesselActivity \
    931 
    +Where t.id In :tripId and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    932 
    +Order By vessel.code,t.startDate,r.date,a.number,a.time
    923 933 
     report.psLogbookWellPlanCheck.request.1.location=0,0
    924 934 
     report.psLogbookWellPlanCheck.request.1.layout=row
    925 935 
     report.psLogbookWellPlanCheck.request.1.request=Select vessel.code,\
    ... ... @@ -928,7 +938,17 @@ concat(day(t.startDate), '/', month(t.startDate), '/', year(t.startDate)), \
    928 938 
     concat(day(t.endDate), '/', month(t.endDate), '/', year(t.endDate)), \
    929 939 
     concat(day(r.date), '/', month(r.date), '/', year(r.date)), \
    930 940 
     a.number, \
    931 
    -concat(hour(a.time), ':', minute(a.time)), \
    941 
    +concat(hour(a.time), ':', minute(a.time)) \
    942 
    +From TripImpl t \
    943 
    +Join t.routeLogbook r \
    944 
    +Join r.activity a \
    945 
    +Join t.vessel vessel \
    946 
    +Where t.id In :tripId and a = :activity
    947 
    +report.psLogbookWellPlanCheck.request.1.repeat.name=activity
    948 
    +report.psLogbookWellPlanCheck.request.1.repeat.layout=column
    949 
    +report.psLogbookWellPlanCheck.request.2.location=7,0
    950 
    +report.psLogbookWellPlanCheck.request.2.layout=row
    951 
    +report.psLogbookWellPlanCheck.request.2.request=Select \
    932 952 
     Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then ct.weight Else 0.0 End), \
    933 953 
     Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then ct.weight Else 0.0 End), \
    934 954 
     Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then ct.weight Else 0.0 End), \
    ... ... @@ -942,14 +962,12 @@ From TripImpl t \
    942 962 
     Join t.routeLogbook r \
    943 963 
     Join r.activity a \
    944 964 
     Join a.catches ct \
    945 
    -Join t.vessel vessel \
    946 
    -Left Join a.vesselActivity vesselActivity \
    947 
    -Where t.id In :tripId and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    948 
    -Group By vessel.code,vessel.label2,t.startDate,t.endDate,r.date,a.time,a.number \
    949 
    -Order By vessel.code,t.startDate,r.date,a.time
    950 
    -report.psLogbookWellPlanCheck.request.2.location=12,0
    951 
    -report.psLogbookWellPlanCheck.request.2.layout=row
    952 
    -report.psLogbookWellPlanCheck.request.2.request=Select \
    965 
    +Where t.id In :tripId and a = :activity
    966 
    +report.psLogbookWellPlanCheck.request.2.repeat.name=activity
    967 
    +report.psLogbookWellPlanCheck.request.2.repeat.layout=column
    968 
    +report.psLogbookWellPlanCheck.request.3.location=12,0
    969 
    +report.psLogbookWellPlanCheck.request.3.layout=row
    970 
    +report.psLogbookWellPlanCheck.request.3.request=Select \
    953 971 
     Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then was.weight Else 0.0 End), \
    954 972 
     Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then was.weight Else 0.0 End), \
    955 973 
     Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then was.weight Else 0.0 End), \
    ... ... @@ -963,41 +981,31 @@ From TripImpl t \
    963 981 
     Join t.well w \
    964 982 
     Join w.wellActivity wa \
    965 983 
     Join wa.wellActivitySpecies was \
    966 
    -Join t.routeLogbook r \
    967 
    -Join r.activity a \
    968 
    -Join t.vessel vessel \
    969 
    -Left Join a.vesselActivity vesselActivity \
    970 
    -Where t.id In :tripId and wa.activity = a and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    971 
    -Group By vessel.code,vessel.label2,t.startDate,t.endDate,r.date,a.time,a.number \
    972 
    -Order By vessel.code,t.startDate,r.date,a.time
    973 
    -report.psLogbookWellPlanCheck.request.3.location=17,0
    974 
    -report.psLogbookWellPlanCheck.request.3.layout=row
    975 
    -report.psLogbookWellPlanCheck.request.3.request=Select \
    984 
    +Where t.id In :tripId and wa.activity = :activity
    985 
    +report.psLogbookWellPlanCheck.request.3.repeat.name=activity
    986 
    +report.psLogbookWellPlanCheck.request.3.repeat.layout=column
    987 
    +report.psLogbookWellPlanCheck.request.4.location=17,0
    988 
    +report.psLogbookWellPlanCheck.request.4.layout=row
    989 
    +report.psLogbookWellPlanCheck.request.4.request=Select \
    976 990 
     Sum(ct.weight) \
    977 991 
     From TripImpl t \
    978 992 
     Join t.routeLogbook r \
    979 993 
     Join r.activity a \
    980 994 
     Join a.catches ct \
    981 
    -Join t.vessel vessel \
    982 
    -Left Join a.vesselActivity vesselActivity \
    983 
    -Where t.id In :tripId and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    984 
    -Group By vessel.code,vessel.label2,t.startDate,t.endDate,r.date,a.time,a.number \
    985 
    -Order By vessel.code,t.startDate,r.date,a.time
    986 
    -report.psLogbookWellPlanCheck.request.4.location=18,0
    987 
    -report.psLogbookWellPlanCheck.request.4.layout=row
    988 
    -report.psLogbookWellPlanCheck.request.4.request=Select \
    995 
    +Where t.id In :tripId and a = :activity
    996 
    +report.psLogbookWellPlanCheck.request.4.repeat.name=activity
    997 
    +report.psLogbookWellPlanCheck.request.4.repeat.layout=column
    998 
    +report.psLogbookWellPlanCheck.request.5.location=18,0
    999 
    +report.psLogbookWellPlanCheck.request.5.layout=row
    1000 
    +report.psLogbookWellPlanCheck.request.5.request=Select \
    989 1001 
     Sum(was.weight) \
    990 1002 
     From TripImpl t \
    991 1003 
     Join t.well w \
    992 1004 
     Join w.wellActivity wa \
    993 1005 
     Join wa.wellActivitySpecies was \
    994 
    -Join t.routeLogbook r \
    995 
    -Join r.activity a \
    996 
    -Join t.vessel vessel \
    997 
    -Left Join a.vesselActivity vesselActivity \
    998 
    -Where t.id In :tripId and wa.activity = a and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    999 
    -Group By vessel.code,vessel.label2,t.startDate,t.endDate,r.date,a.time,a.number \
    1000 
    -Order By vessel.code,t.startDate,r.date,a.time
    1006 
    +Where t.id In :tripId and wa.activity = :activity
    1007 
    +report.psLogbookWellPlanCheck.request.5.repeat.name=activity
    1008 
    +report.psLogbookWellPlanCheck.request.5.repeat.layout=column
    1001 1009 
     report.psLogbookWellPlanCheck.operations.1.type=SubtractColum
    1002 1010 
     report.psLogbookWellPlanCheck.operations.1.parameters=17|18|19
    1003 1011 
     report.psLogbookWellPlanCheck.operations.2.type=SumColumn

  • core/services/test/src/main/resources/fixtures/fr/ird/observe/services/service/ReportService-psLogbookWellPlanCheck.properties
    ... ... @@ -20,13 +20,16 @@
    20 20 
     # #L%
    21 21 
     ###
    22 22 
     result.0=483^CAP BOJADOR^30/3/2019^8/4/2019^30/3/2019^1^15:12^0.0^123.0^43.0^0.0^0.0^0.0^0.0^12.0^0.0^0.0^166.0^12.0^154.0
    23 
    +result.1=483^CAP BOJADOR^30/3/2019^8/4/2019^1/4/2019^1^15:12^null^null^null^null^null^null^null^null^null^null^null^null^-
    24 
    +result.2=483^CAP BOJADOR^30/3/2019^8/4/2019^1/4/2019^1^15:12^null^null^null^null^null^null^null^null^null^null^null^null^-
    25 
    +result.3=Total^null^null^null^null^null^-^0.0^123.0^43.0^0.0^0.0^0.0^0.0^12.0^0.0^0.0^166.0^12.0^-
    23 26 
     result.columns=20
    24 
    -result.rows=1
    27 
    +result.rows=4
    25 28 
     syntax.columns=20
    26 29 
     syntax.columnsHeader=Code bateau^Nom bateau^Date départ^Date arrivée^Date de route^Numéro activité^Heure activité^Logbook YFT^Logbook SKJ^Logbook BET^Logbook ALB^Logbook Autres^Plan de cuves YFT^Plan de cuves SKJ^Plan de cuves BET^Plan de cuves ALB^Plan de cuves Autres^Logbook Total^Plan de cuves Total^Différence
    27 30 
     syntax.description=Livre de bord - Vérification des plan de cuves
    28 31 
     syntax.name=Livre de bord - Vérification des plan de cuves
    29 
    -syntax.nbRequests=4
    32 
    +syntax.nbRequests=5
    30 33 
     syntax.rows=-1
    31 34 
     syntax.rowsHeader=
    32 35 
     tripIds=${PS_COMMON_TRIP},${PS_COMMON_TRIP_MOVE}

    • —
    View it on GitLab.
    You're receiving this email because of your account on gitlab.com. Manage all notifications · Help