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

Commits:

11 changed files:

Changes:

  • client/datasource/actions/src/main/java/fr/ird/observe/client/datasource/actions/export/actions/Prepare.java
    ... ... @@ -58,7 +58,7 @@ public class Prepare extends ExportUIActionSupport {
    58 58 
             addAdminWorker(ui.getPrepare().getToolTipText(), this::doPrepareAction0);
    59 59 
         }
    60 60
    61 
    -    private WizardState doPrepareAction0() throws Exception {
    61 
    +    private WizardState doPrepareAction0() {
    62 62
    63 63 
             AdminUIModel model = ui.getModel();
    64 64 
             List<CopyDataTask> data = CopyDataTask.of(TaskSide.FROM_LEFT, model.getSelectDataModel().getSelectionDataModel()).collect(Collectors.toList());
    ... ... @@ -70,10 +70,6 @@ public class Prepare extends ExportUIActionSupport {
    70 70
    71 71 
             ConfigModel configModel = model.getConfigModel();
    72 72 
             ObserveSwingDataSource targetSource = configModel.getRightSourceModel().getSafeSourceNotOpened();
    73 
    -        if (!targetSource.canWriteData()) {
    74 
    -            throw new IllegalStateException(String.format("Can't export if target source (%s) has no data rights", targetSource.getLabel()));
    75 
    -        }
    76 
    -
    77 73 
             ObserveSwingDataSource incomingSource = configModel.getLeftSourceModel().getSafeSourceNotOpened();
    78 74
    79 75 
             stepModel.setData(data);

  • client/datasource/actions/src/main/java/fr/ird/observe/client/datasource/actions/report/ReportModel.java
    ... ... @@ -57,7 +57,11 @@ import javax.swing.JComboBox;
    57 57 
     import javax.swing.JLabel;
    58 58 
     import javax.swing.JPanel;
    59 59 
     import javax.swing.SwingUtilities;
    60 
    +import javax.swing.table.TableCellRenderer;
    61 
    +import javax.swing.table.TableColumn;
    62 
    +import javax.swing.table.TableColumnModel;
    60 63 
     import java.awt.BorderLayout;
    64 
    +import java.awt.Component;
    61 65 
     import java.awt.event.ItemEvent;
    62 66 
     import java.beans.PropertyChangeListener;
    63 67 
     import java.io.File;
    ... ... @@ -508,6 +512,9 @@ public class ReportModel extends AdminActionModel {
    508 512 
                 if (reportColumnRenderersParameters != null) {
    509 513 
                     reportColumnRenderersParameters.consumeColumnRenderersSwing(resultTable);
    510 514 
                 }
    515 
    +            resizeColumnWidth(resultTable,-1);
    516 
    +
    517 
    +
    511 518 
             } catch (Exception e) {
    512 519 
                 clearResult(ui);
    513 520 
                 throw e;
    ... ... @@ -516,6 +523,30 @@ public class ReportModel extends AdminActionModel {
    516 523 
             }
    517 524 
         }
    518 525
    526 
    +    public static void resizeColumnWidth(JXTable table, int maxWidth) {
    527 
    +        final TableColumnModel columnModel = table.getColumnModel();
    528 
    +        for (int column = 0; column < table.getColumnCount(); column++) {
    529 
    +            // Account for header size
    530 
    +            TableColumn tableColumn = table.getColumnModel().getColumn(column);
    531 
    +            TableCellRenderer renderer = tableColumn.getCellRenderer();
    532 
    +            if (renderer==null) {
    533 
    +                renderer = table.getTableHeader().getDefaultRenderer();
    534 
    +            }
    535 
    +            Component component = renderer.getTableCellRendererComponent(table, tableColumn.getHeaderValue(), false, false, -1, column);
    536 
    +            double width     = component.getPreferredSize().width;
    537 
    +            for (int row = 0; row < table.getRowCount(); row++) {
    538 
    +                renderer = table.getCellRenderer(row, column);
    539 
    +                Component comp = table.prepareRenderer(renderer, row, column);
    540 
    +                width = Math.max(comp.getPreferredSize().width + 1, width);
    541 
    +            }
    542 
    +            if (maxWidth>0 && width > maxWidth) {
    543 
    +                width = maxWidth;
    544 
    +            }
    545 
    +            tableColumn.setPreferredWidth((int) width);
    546 
    +            log.debug("Column {} - width (min/max/pref): {} {}/{}/{}", tableColumn.getModelIndex(), tableColumn.getWidth(), tableColumn.getMinWidth(), tableColumn.getMaxWidth(), tableColumn.getPreferredWidth());
    547 
    +        }
    548 
    +    }
    549 
    +
    519 550 
         private void clearResult(ReportUI ui) {
    520 551 
             getResultModel().clear();
    521 552 
             ui.getConfigurationPane().setTitle(null);

  • core/persistence/report/src/main/resources/META-INF/report/default/ps/psLogbookWellPlan.report
    ... ... @@ -39,19 +39,16 @@ w.well, \
    39 39 
     r.date, \
    40 40 
     a.number, \
    41 41 
     Cast(a.time As java.sql.Time), \
    42 
    -species.@i18nColumnName@, \
    43 
    -weightCategory.@i18nColumnName@, \
    42 
    +was.species.@i18nColumnName@, \
    43 
    +was.weightCategory.@i18nColumnName@, \
    44 44 
     was.weight \
    45 45 
     From TripImpl t \
    46 46 
     Join t.well w \
    47 47 
     Join w.wellActivity wa \
    48 48 
     Join wa.wellActivitySpecies was \
    49 
    -Join was.species species \
    50 
    -Join was.weightCategory weightCategory \
    51 49 
     Join t.routeLogbook r \
    52 50 
     Join r.activity a \
    53 51 
     Join t.vessel vessel \
    54 52 
     Left Join a.vesselActivity vesselActivity \
    55 
    -Left Join a.schoolType schoolType \
    56 53 
     Where t.id In :tripId and wa.activity = a \
    57 54 
     Order By vessel.code,t.startDate,t.endDate,w.well,r.date,a.time

  • core/persistence/report/src/main/resources/META-INF/report/default/ps/psLogbookWellPlanCheck.report
    ... ... @@ -29,16 +29,6 @@ description.es=
    29 29 
     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
    30 30 
     columns.en=Vessel code,Vessel name,Departure date,Landing date,Day of route,Activity number,Activity hour,Logbook YFT,Logbook SKJ,Logbook BET,Logbook ALB,Logbook others,Well plan YFT,Well plan SKJ,Well plan BET,Well plan ALB,Well plan others,Logbook Total,Well plan Total,Difference
    31 31 
     columns.es=
    32 
    -repeatVariable.1.name=activity
    33 
    -repeatVariable.1.type=fr.ird.observe.entities.data.ps.logbook.Activity
    34 
    -repeatVariable.1.request=Select a \
    35 
    -From TripImpl t \
    36 
    -Join t.routeLogbook r \
    37 
    -Join r.activity a \
    38 
    -Join t.vessel vessel \
    39 
    -Left Join a.vesselActivity vesselActivity \
    40 
    -Where t.id In :tripId and vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    41 
    -Order By vessel.code,t.startDate,r.date,a.number,a.time
    42 32 
     request.1.location=0,0
    43 33 
     request.1.layout=row
    44 34 
     request.1.request=Select vessel.code,\
    ... ... @@ -47,74 +37,33 @@ t.startDate, \
    47 37 
     t.endDate, \
    48 38 
     r.date, \
    49 39 
     a.number, \
    50 
    -Cast(a.time As java.sql.Time) \
    51 
    -From TripImpl t \
    52 
    -Join t.routeLogbook r \
    53 
    -Join r.activity a \
    54 
    -Join t.vessel vessel \
    55 
    -Where t.id In :tripId and a = :activity
    56 
    -request.1.repeat.name=activity
    57 
    -request.1.repeat.layout=column
    58 
    -request.2.location=7,0
    59 
    -request.2.layout=row
    60 
    -request.2.request=Select \
    61 
    -Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then ct.weight Else 0.0 End), \
    62 
    -Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then ct.weight Else 0.0 End), \
    63 
    -Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then ct.weight Else 0.0 End), \
    64 
    -Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then ct.weight Else 0.0 End), \
    65 
    -Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then 0.0 \
    40 
    +Cast(a.time As java.sql.Time), \
    41 
    +(Select Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then ct.weight Else 0.0 End) From a.catches ct), \
    42 
    +(Select Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then ct.weight Else 0.0 End) From a.catches ct), \
    43 
    +(Select Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then ct.weight Else 0.0 End) From a.catches ct), \
    44 
    +(Select Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then ct.weight Else 0.0 End) From a.catches ct), \
    45 
    +(Select Sum(CASE ct.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then 0.0 \
    66 46 
     When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then 0.0 \
    67 47 
     When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then 0.0 \
    68 48 
     When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then 0.0 \
    69 
    -Else ct.weight End) \
    70 
    -From TripImpl t \
    71 
    -Join t.routeLogbook r \
    72 
    -Join r.activity a \
    73 
    -Join a.catches ct \
    74 
    -Where t.id In :tripId and a = :activity
    75 
    -request.2.repeat.name=activity
    76 
    -request.2.repeat.layout=column
    77 
    -request.3.location=12,0
    78 
    -request.3.layout=row
    79 
    -request.3.request=Select \
    80 
    -Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then was.weight Else 0.0 End), \
    81 
    -Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then was.weight Else 0.0 End), \
    82 
    -Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then was.weight Else 0.0 End), \
    83 
    -Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then was.weight Else 0.0 End), \
    84 
    -Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then 0.0 \
    49 
    +Else ct.weight End) From a.catches ct), \
    50 
    +(Select Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then was.weight Else 0.0 End)  From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a), \
    51 
    +(Select Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then was.weight Else 0.0 End)  From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a), \
    52 
    +(Select Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then was.weight Else 0.0 End)  From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a), \
    53 
    +(Select Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then was.weight Else 0.0 End)  From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a), \
    54 
    +(Select Sum(CASE was.species.id When 'fr.ird.referential.common.Species#1239832685474#0.8943253454598569'  Then 0.0 \
    85 55 
     When 'fr.ird.referential.common.Species#1239832685474#0.975344121171992'   Then 0.0 \
    86 56 
     When 'fr.ird.referential.common.Species#1239832685475#0.13349466123905152' Then 0.0 \
    87 57 
     When 'fr.ird.referential.common.Species#1239832685476#0.5618871286604711'  Then 0.0 \
    88 
    -Else was.weight End) \
    89 
    -From TripImpl t \
    90 
    -Join t.well w \
    91 
    -Join w.wellActivity wa \
    92 
    -Join wa.wellActivitySpecies was \
    93 
    -Where t.id In :tripId and wa.activity = :activity
    94 
    -request.3.repeat.name=activity
    95 
    -request.3.repeat.layout=column
    96 
    -request.4.location=17,0
    97 
    -request.4.layout=row
    98 
    -request.4.request=Select \
    99 
    -Sum(ct.weight) \
    58 
    +Else was.weight End)  From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a), \
    59 
    +(Select Sum(ct.weight) From a.catches ct), \
    60 
    +(Select Sum(was.weight) From WellActivityImpl wa Join wa.wellActivitySpecies was Where wa.activity = a) \
    100 61 
     From TripImpl t \
    101 62 
     Join t.routeLogbook r \
    102 
    -Join r.activity a \
    103 
    -Join a.catches ct \
    104 
    -Where t.id In :tripId and a = :activity
    105 
    -request.4.repeat.name=activity
    106 
    -request.4.repeat.layout=column
    107 
    -request.5.location=18,0
    108 
    -request.5.layout=row
    109 
    -request.5.request=Select \
    110 
    -Sum(was.weight) \
    111 
    -From TripImpl t \
    112 
    -Join t.well w \
    113 
    -Join w.wellActivity wa \
    114 
    -Join wa.wellActivitySpecies was \
    115 
    -Where t.id In :tripId and wa.activity = :activity
    116 
    -request.5.repeat.name=activity
    117 
    -request.5.repeat.layout=column
    63 
    +Join r.activity a With a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    64 
    +Join t.vessel vessel \
    65 
    +Where t.id In :tripId \
    66 
    +Order By vessel.code,t.startDate,r.date,a.number,a.time
    118 67 
     operations.1.type=SubtractColum
    119 68 
     operations.1.parameters=17|18|19
    120 69 
     operations.2.type=SumColumn

  • core/persistence/report/src/main/resources/META-INF/report/default/ps/psObservationFobUsageExtended.report
    ... ... @@ -33,17 +33,20 @@ repeatVariable.1.name=typeObjetId
    33 33 
     repeatVariable.1.type=java.lang.String
    34 34 
     repeatVariable.1.request=Select distinct (om.standardCode) \
    35 35 
     From ObjectMaterialImpl om \
    36 
    -Where standardCode is not null \
    37 
    -And standardCode != '' \
    38 
    -And (Select Count(dcp) \
    36 
    +Where om.standardCode is not null \
    37 
    +And om.standardCode != '' \
    38 
    +And (om.standardCode In (Select Distinct(dcp.computedWhenArrivingSimplifiedObjectType) \
    39 39 
     From fr.ird.observe.entities.data.ps.common.TripImpl m \
    40 40 
     Join m.routeObs r \
    41 41 
     Join r.activity a \
    42 
    -Join a.floatingObject dcp \
    43 
    -Where \
    44 
    -m.id In :tripId \
    45 
    -and (dcp.computedWhenArrivingSimplifiedObjectType = om.standardCode Or dcp.computedWhenLeavingSimplifiedObjectType = om.standardCode) \
    46 
    -) > 0
    42 
    +Join a.floatingObject dcp With dcp.computedWhenArrivingSimplifiedObjectType Is Not Null \
    43 
    +Where m.id In :tripId ) Or om.standardCode In (Select Distinct(dcp.computedWhenLeavingSimplifiedObjectType) \
    44 
    +From fr.ird.observe.entities.data.ps.common.TripImpl m \
    45 
    +Join m.routeObs r \
    46 
    +Join r.activity a \
    47 
    +Join a.floatingObject dcp With dcp.computedWhenLeavingSimplifiedObjectType Is Not Null \
    48 
    +Where m.id In :tripId )) \
    49 
    +Order by om.standardCode
    47 50 
     request.1.location=0,0
    48 51 
     request.1.layout=row
    49 52 
     request.1.request=Select concat(str(om.standardCode) , ' - ', om.@i18nColumnName@) \
    ... ... @@ -55,258 +58,30 @@ request.1.repeat.name=typeObjetId
    55 58 
     request.1.repeat.layout=column
    56 59 
     request.2.location=1,0
    57 60 
     request.2.layout=row
    58 
    -request.2.request=Select Count(dcp) \
    59 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    60 
    -Join m.routeObs r \
    61 
    -Join r.activity a \
    62 
    -Join a.floatingObject dcp \
    63 
    -Where \
    64 
    -m.id In :tripId \
    65 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    66 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    67 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    61 
    +request.2.request=Select \
    62 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    63 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    64 
    +Sum(Case When dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    65 
    +Sum(Case When dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    66 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    67 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    68 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    69 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    70 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    71 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    72 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    73 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    74 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    75 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    76 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' Or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    77 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' Or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' Then 1 Else 0 End), \
    78 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectObservedSpecies Is Not Empty Then (Select Sum(efo.count) From dcp.objectObservedSpecies efo Where efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461') Else 0 End) \
    79 
    +From fr.ird.observe.entities.data.ps.common.TripImpl m \
    80 
    +Join m.routeObs r \
    81 
    +Join r.activity a \
    82 
    +Join a.floatingObject dcp With dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId Or dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    83 
    +Where \
    84 
    +m.id In :tripId
    68 85 
     request.2.repeat.name=typeObjetId
    69 86 
     request.2.repeat.layout=column
    70 
    -request.2.comment=visite + peche
    71 
    -request.3.location=2,0
    72 
    -request.3.layout=row
    73 
    -request.3.request=Select Count(dcp) \
    74 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    75 
    -Join m.routeObs r \
    76 
    -Join r.activity a \
    77 
    -Join a.floatingObject dcp \
    78 
    -Where \
    79 
    -m.id In :tripId \
    80 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    81 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    82 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    83 
    -request.3.repeat.name=typeObjetId
    84 
    -request.3.repeat.layout=column
    85 
    -request.3.comment=visite - peche
    86 
    -request.4.location=3,0
    87 
    -request.4.layout=row
    88 
    -request.4.request=Select Count(dcp) \
    89 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    90 
    -Join m.routeObs r \
    91 
    -Join r.activity a \
    92 
    -Join a.floatingObject dcp \
    93 
    -Where \
    94 
    -m.id In :tripId \
    95 
    -and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \
    96 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' \
    97 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    98 
    -request.4.repeat.name=typeObjetId
    99 
    -request.4.repeat.layout=column
    100 
    -request.4.comment=Deploiement + peche
    101 
    -request.5.location=4,0
    102 
    -request.5.layout=row
    103 
    -request.5.request=Select Count(dcp) \
    104 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    105 
    -Join m.routeObs r \
    106 
    -Join r.activity a \
    107 
    -Join a.floatingObject dcp \
    108 
    -Where \
    109 
    -m.id In :tripId \
    110 
    -and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \
    111 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' \
    112 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    113 
    -request.5.repeat.name=typeObjetId
    114 
    -request.5.repeat.layout=column
    115 
    -request.5.comment=Deploiement - peche
    116 
    -request.6.location=5,0
    117 
    -request.6.layout=row
    118 
    -request.6.request=Select Count(dcp) \
    119 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    120 
    -Join m.routeObs r \
    121 
    -Join r.activity a \
    122 
    -Join a.floatingObject dcp \
    123 
    -Where \
    124 
    -m.id In :tripId \
    125 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    126 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \
    127 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    128 
    -request.6.repeat.name=typeObjetId
    129 
    -request.6.repeat.layout=column
    130 
    -request.6.comment=Modifie + peche
    131 
    -request.7.location=6,0
    132 
    -request.7.layout=row
    133 
    -request.7.request=Select Count(dcp) \
    134 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    135 
    -Join m.routeObs r \
    136 
    -Join r.activity a \
    137 
    -Join a.floatingObject dcp \
    138 
    -Where \
    139 
    -m.id In :tripId \
    140 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    141 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \
    142 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    143 
    -request.7.repeat.name=typeObjetId
    144 
    -request.7.repeat.layout=column
    145 
    -request.7.comment=Modifie - peche
    146 
    -request.8.location=7,0
    147 
    -request.8.layout=row
    148 
    -request.8.request=Select Count(dcp) \
    149 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    150 
    -Join m.routeObs r \
    151 
    -Join r.activity a \
    152 
    -Join a.floatingObject dcp \
    153 
    -Where \
    154 
    -m.id In :tripId \
    155 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    156 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \
    157 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    158 
    -request.8.repeat.name=typeObjetId
    159 
    -request.8.repeat.layout=column
    160 
    -request.8.comment=Retire + peche
    161 
    -request.9.location=8,0
    162 
    -request.9.layout=row
    163 
    -request.9.request=Select Count(dcp) \
    164 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    165 
    -Join m.routeObs r \
    166 
    -Join r.activity a \
    167 
    -Join a.floatingObject dcp \
    168 
    -Where \
    169 
    -m.id In :tripId \
    170 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    171 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \
    172 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    173 
    -request.9.repeat.name=typeObjetId
    174 
    -request.9.repeat.layout=column
    175 
    -request.9.comment=Retire - peche
    176 
    -request.10.location=9,0
    177 
    -request.10.layout=row
    178 
    -request.10.request=Select Count(dcp) \
    179 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    180 
    -Join m.routeObs r \
    181 
    -Join r.activity a \
    182 
    -Join a.floatingObject dcp \
    183 
    -Where \
    184 
    -m.id In :tripId \
    185 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    186 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \
    187 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    188 
    -request.10.repeat.name=typeObjetId
    189 
    -request.10.repeat.layout=column
    190 
    -request.10.comment=Abandonne + peche
    191 
    -request.11.location=10,0
    192 
    -request.11.layout=row
    193 
    -request.11.request=Select Count(dcp) \
    194 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    195 
    -Join m.routeObs r \
    196 
    -Join r.activity a \
    197 
    -Join a.floatingObject dcp \
    198 
    -Where \
    199 
    -m.id In :tripId \
    200 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    201 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \
    202 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    203 
    -request.11.repeat.name=typeObjetId
    204 
    -request.11.repeat.layout=column
    205 
    -request.11.comment=Abandonne - peche
    206 
    -request.12.location=11,0
    207 
    -request.12.layout=row
    208 
    -request.12.request=Select Count(dcp) \
    209 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    210 
    -Join m.routeObs r \
    211 
    -Join r.activity a \
    212 
    -Join a.floatingObject dcp \
    213 
    -Where \
    214 
    -m.id In :tripId \
    215 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    216 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \
    217 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    218 
    -request.12.repeat.name=typeObjetId
    219 
    -request.12.repeat.layout=column
    220 
    -request.12.comment=Coule + peche
    221 
    -request.13.location=12,0
    222 
    -request.13.layout=row
    223 
    -request.13.request=Select Count(dcp) \
    224 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    225 
    -Join m.routeObs r \
    226 
    -Join r.activity a \
    227 
    -Join a.floatingObject dcp \
    228 
    -Where \
    229 
    -m.id In :tripId \
    230 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    231 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \
    232 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    233 
    -request.13.repeat.name=typeObjetId
    234 
    -request.13.repeat.layout=column
    235 
    -request.13.comment=Coule - peche
    236 
    -request.14.location=13,0
    237 
    -request.14.layout=row
    238 
    -request.14.request=Select Count(dcp) \
    239 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    240 
    -Join m.routeObs r \
    241 
    -Join r.activity a \
    242 
    -Join a.floatingObject dcp \
    243 
    -Where \
    244 
    -m.id In :tripId \
    245 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    246 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \
    247 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    248 
    -request.14.repeat.name=typeObjetId
    249 
    -request.14.repeat.layout=column
    250 
    -request.14.comment=Remplace + peche
    251 
    -request.15.location=14,0
    252 
    -request.15.layout=row
    253 
    -request.15.request=Select Count(dcp) \
    254 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    255 
    -Join m.routeObs r \
    256 
    -Join r.activity a \
    257 
    -Join a.floatingObject dcp \
    258 
    -Where \
    259 
    -m.id In :tripId \
    260 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    261 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \
    262 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    263 
    -request.15.repeat.name=typeObjetId
    264 
    -request.15.repeat.layout=column
    265 
    -request.15.comment=Remplace - peche
    266 
    -request.16.location=15,0
    267 
    -request.16.layout=row
    268 
    -request.16.request=Select Count(dcp) \
    269 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    270 
    -Join m.routeObs r \
    271 
    -Join r.activity a \
    272 
    -Join a.floatingObject dcp \
    273 
    -Where \
    274 
    -m.id In :tripId \
    275 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    276 
    -and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \
    277 
    -or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') \
    278 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    279 
    -request.16.repeat.name=typeObjetId
    280 
    -request.16.repeat.layout=column
    281 
    -request.16.comment=Autre ou ancien peche + peche
    282 
    -request.17.location=16,0
    283 
    -request.17.layout=row
    284 
    -request.17.request=Select Count(dcp) \
    285 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    286 
    -Join m.routeObs r \
    287 
    -Join r.activity a \
    288 
    -Join a.floatingObject dcp \
    289 
    -Where \
    290 
    -m.id In :tripId \
    291 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    292 
    -and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \
    293 
    -or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') \
    294 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586'
    295 
    -request.17.repeat.name=typeObjetId
    296 
    -request.17.repeat.layout=column
    297 
    -request.17.comment=Autre ou ancien peche - peche
    298 
    -request.18.location=17,0
    299 
    -request.18.layout=row
    300 
    -request.18.request=Select Sum(efo.count) \
    301 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    302 
    -Join m.routeObs r \
    303 
    -Join r.activity a \
    304 
    -Join a.floatingObject dcp \
    305 
    -Join dcp.objectObservedSpecies efo \
    306 
    -Where \
    307 
    -m.id In :tripId \
    308 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    309 
    -and efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461'
    310 
    -request.18.repeat.name=typeObjetId
    311 
    -request.18.repeat.layout=column
    312 
    -request.18.comment=Nombre de tortues
    87 
    +request.2.comment=visite + peche / visite - peche / Deploiement + peche / Deploiement - peche / Modifie + peche / Modifie - peche / Retire + peche / Retire - peche / Abandonne + peche / Abandonne - peche / Coule + peche / Coule - peche / Remplace + peche / Remplace - peche / Autre ou ancien peche + peche / Autre ou ancien peche - peche / Nombre de tortues

  • core/persistence/report/src/main/resources/META-INF/report/default/ps/psObservationFobUsageMinimal.report
    ... ... @@ -33,17 +33,20 @@ repeatVariable.1.name=typeObjetId
    33 33 
     repeatVariable.1.type=java.lang.String
    34 34 
     repeatVariable.1.request=Select distinct (om.standardCode) \
    35 35 
     From ObjectMaterialImpl om \
    36 
    -Where standardCode is not null \
    37 
    -And standardCode != '' \
    38 
    -And (Select Count(dcp) \
    36 
    +Where om.standardCode is not null \
    37 
    +And om.standardCode != '' \
    38 
    +And (om.standardCode In (Select Distinct(dcp.computedWhenArrivingSimplifiedObjectType) \
    39 39 
     From fr.ird.observe.entities.data.ps.common.TripImpl m \
    40 40 
     Join m.routeObs r \
    41 41 
     Join r.activity a \
    42 
    -Join a.floatingObject dcp \
    43 
    -Where \
    44 
    -m.id In :tripId \
    45 
    -and (dcp.computedWhenArrivingSimplifiedObjectType = om.standardCode Or dcp.computedWhenLeavingSimplifiedObjectType = om.standardCode) \
    46 
    -) > 0
    42 
    +Join a.floatingObject dcp With dcp.computedWhenArrivingSimplifiedObjectType Is Not Null \
    43 
    +Where m.id In :tripId ) Or om.standardCode In (Select Distinct(dcp.computedWhenLeavingSimplifiedObjectType) \
    44 
    +From fr.ird.observe.entities.data.ps.common.TripImpl m \
    45 
    +Join m.routeObs r \
    46 
    +Join r.activity a \
    47 
    +Join a.floatingObject dcp With dcp.computedWhenLeavingSimplifiedObjectType Is Not Null \
    48 
    +Where m.id In :tripId )) \
    49 
    +Order by om.standardCode
    47 50 
     repeatVariable.1.comment=liste des types CECOFAD en presence sur les donnees selectionnees
    48 51 
     request.1.location=0,0
    49 52 
     request.1.layout=row
    ... ... @@ -56,74 +59,31 @@ request.1.repeat.name=typeObjetId
    56 59 
     request.1.repeat.layout=column
    57 60 
     request.2.location=1,0
    58 61 
     request.2.layout=row
    59 
    -request.2.request=Select Count(dcp) \
    60 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    61 
    -Join m.routeObs r \
    62 
    -Join r.activity a \
    63 
    -Join a.floatingObject dcp \
    64 
    -Where \
    65 
    -m.id In :tripId \
    66 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    67 
    -and a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    68 
    -and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    62 
    +request.2.request=Select \
    63 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And a.vesselActivity.id = 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' And (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    69 64 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \
    70 65 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \
    71 66 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \
    72 67 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \
    73 68 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \
    74 69 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \
    75 
    -or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3')
    76 
    -request.2.repeat.name=typeObjetId
    77 
    -request.2.repeat.layout=column
    78 
    -request.2.comment=rencontres + peches
    79 
    -request.3.location=2,0
    80 
    -request.3.layout=row
    81 
    -request.3.request=Select Count(dcp) \
    82 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    83 
    -Join m.routeObs r \
    84 
    -Join r.activity a \
    85 
    -Join a.floatingObject dcp \
    86 
    -Where \
    87 
    -m.id In :tripId \
    88 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    89 
    -and a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' \
    90 
    -and (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    70 
    +or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') Then 1 Else 0 End), \
    71 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And a.vesselActivity.id != 'fr.ird.referential.ps.common.VesselActivity#1239832675369#0.12552908048322586' And (dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#2' \
    91 72 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#8' \
    92 73 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#4' \
    93 74 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#5' \
    94 75 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#7' \
    95 76 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#9' \
    96 77 
     or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#10' \
    97 
    -or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3')
    98 
    -request.3.repeat.name=typeObjetId
    99 
    -request.3.repeat.layout=column
    100 
    -request.3.comment=rencontres - peches
    101 
    -request.4.location=3,0
    102 
    -request.4.layout=row
    103 
    -request.4.request=Select Count(dcp) \
    104 
    -From fr.ird.observe.entities.data.ps.common.TripImpl m \
    105 
    -Join m.routeObs r \
    106 
    -Join r.activity a \
    107 
    -Join a.floatingObject dcp \
    108 
    -Where \
    109 
    -m.id In :tripId \
    110 
    -and dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \
    111 
    -and dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1'
    112 
    -request.4.repeat.name=typeObjetId
    113 
    -request.4.repeat.layout=column
    114 
    -request.4.comment=deployes
    115 
    -request.5.location=4,0
    116 
    -request.5.layout=row
    117 
    -request.5.request=Select Sum(efo.count) \
    78 
    +or dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#3') Then 1 Else 0 End), \
    79 
    +Sum(Case When dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId And dcp.objectOperation.id = 'fr.ird.referential.ps.common.ObjectOperation#0#1' Then 1 Else 0 End), \
    80 
    +Sum(Case When dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId And dcp.objectObservedSpecies Is Not Empty Then (Select Sum(efo.count) From dcp.objectObservedSpecies efo Where efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461') Else 0 End) \
    118 81 
     From fr.ird.observe.entities.data.ps.common.TripImpl m \
    119 82 
     Join m.routeObs r \
    120 83 
     Join r.activity a \
    121 
    -Join a.floatingObject dcp \
    122 
    -Join dcp.objectObservedSpecies efo \
    84 
    +Join a.floatingObject dcp With dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId Or dcp.computedWhenLeavingSimplifiedObjectType = :typeObjetId \
    123 85 
     Where \
    124 
    -m.id In :tripId \
    125 
    -and dcp.computedWhenArrivingSimplifiedObjectType = :typeObjetId \
    126 
    -and efo.species.speciesGroup.id = 'fr.ird.referential.common.SpeciesGroup#1239832683690#0.24333033683679461'
    127 
    -request.5.repeat.name=typeObjetId
    128 
    -request.5.repeat.layout=column
    129 
    -request.5.comment=Nombre de tortues
    86 
    +m.id In :tripId
    87 
    +request.2.repeat.name=typeObjetId
    88 
    +request.2.repeat.layout=column
    89 
    +request.2.comment=rencontres + peches / rencontres - peches / deployes / Nombre de tortues

  • core/services/test/src/main/java/fr/ird/observe/services/service/report/ps/PsObservationFobUsageExtendedReportFixture.java
    ... ... @@ -45,6 +45,5 @@ public class PsObservationFobUsageExtendedReportFixture extends ReportFixture {
    45 45 
             Iterator<ReportRequestDefinition> requests = getRequestIterator(report);
    46 46 
             assertReportRequestDimension(requests, RequestLayout.row, 0, 0);
    47 47 
             assertReportRequestDimension(requests, RequestLayout.row, 1, 0);
    48 
    -        assertReportRequestDimension(requests, RequestLayout.row, 2, 0);
    49 48 
         }
    50 49 
     }

  • core/services/test/src/main/java/fr/ird/observe/services/service/report/ps/PsObservationFobUsageMinimalReportFixture.java
    ... ... @@ -45,6 +45,5 @@ public class PsObservationFobUsageMinimalReportFixture extends ReportFixture {
    45 45 
             Iterator<ReportRequestDefinition> requests = getRequestIterator(report);
    46 46 
             assertReportRequestDimension(requests, RequestLayout.row, 0, 0);
    47 47 
             assertReportRequestDimension(requests, RequestLayout.row, 1, 0);
    48 
    -        assertReportRequestDimension(requests, RequestLayout.row, 2, 0);
    49 48 
         }
    50 49 
     }

  • core/services/test/src/main/resources/fixtures/fr/ird/observe/services/service/ReportService-psLogbookWellPlanCheck.properties
    ... ... @@ -25,7 +25,7 @@ syntax.rows=-1
    25 25 
     syntax.columns=20
    26 26 
     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 27 
     syntax.rowsHeader=
    28 
    -syntax.nbRequests=5
    28 
    +syntax.nbRequests=1
    29 29 
     result.columns=20
    30 30 
     result.rows=4
    31 31 
     result.0=483^CAP BOJADOR^30/03/2019^08/04/2019^30/03/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

  • core/services/test/src/main/resources/fixtures/fr/ird/observe/services/service/ReportService-psObservationFobUsageExtended.properties
    ... ... @@ -19,14 +19,14 @@
    19 19 
     # <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 20 
     # #L%
    21 21 
     ###
    22 
    -result.0=FOB - FOB^0^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^null
    23 
    -result.1=DFAD - DFAD (FAD dérivant)^1^15^1^27^0^0^0^0^0^0^0^0^0^0^0^0^null
    22 
    +result.0=DFAD - DFAD (FAD dérivant)^1^15^1^27^0^0^0^0^0^0^0^0^0^0^0^0^0
    23 
    +result.1=FOB - FOB^0^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0
    24 24 
     result.columns=18
    25 25 
     result.rows=2
    26 26 
     syntax.columns=18
    27 27 
     syntax.columnsHeader=Type de FOB^Visités Pêchés^Visités non Pêchés^Déploiement après Pêches^Déploiement seul^Modifiés Pêchés^Modifiés non Pêchés^Retirés Pêchés^Retirés non Pêchés^Abandonnés Pêchés^Abandonnés non Pêchés^Coulés Pêchés^Coulés non Pêchés^Remplacés Pêchés^Remplacés non Pêchés^Autre Pêchés^Autre non Pêchés^Tortues associées
    28 28 
     syntax.description=Tableau récapitulatif des FOB rencontrés, par types CECOFAD et types d’actions (déploiements, simples visites, modifications, diverses modalités de retraits), avec et sans pêche, et nombres de tortues observées
    29 29 
     syntax.name=Observations - Utilisation des FOB, tableau détaillé
    30 
    -syntax.nbRequests=18
    30 
    +syntax.nbRequests=2
    31 31 
     syntax.rows=-1
    32 32 
     syntax.rowsHeader=

  • core/services/test/src/main/resources/fixtures/fr/ird/observe/services/service/ReportService-psObservationFobUsageMinimal.properties
    ... ... @@ -19,14 +19,14 @@
    19 19 
     # <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 20 
     # #L%
    21 21 
     ###
    22 
    -result.0=FOB - FOB^0^1^0^null
    23 
    -result.1=DFAD - DFAD (FAD dérivant)^1^15^28^null
    22 
    +result.0=DFAD - DFAD (FAD dérivant)^1^15^28^0
    23 
    +result.1=FOB - FOB^0^1^0^0
    24 24 
     result.columns=5
    25 25 
     result.rows=2
    26 26 
     syntax.columns=5
    27 27 
     syntax.columnsHeader=Type de FOB^Rencontrés pêchés^Rencontrés non pêchés^Déployés^Tortues associées
    28 28 
     syntax.description=Tableau récapitulatif des FOB rencontrés, par types CECOFAD et types d’actions regroupés (rencontrés et pêchés, rencontrés non pêchés, déployés), et nombres de tortues observées
    29 29 
     syntax.name=Observations - Utilisation des FOB, tableau simplifiée
    30 
    -syntax.nbRequests=5
    30 
    +syntax.nbRequests=2
    31 31 
     syntax.rows=-1
    32 32 
     syntax.rowsHeader=

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