# ObServe changelog

  * Author [Tony Chemit](mailto:dev@tchemit.fr)

 ## Version [9.2.1](https://gitlab.com/ultreiaio/ird-observe/-/milestones/272)

 ### Download

 * [Client (observe-9.2.1-client.zip)](https://repo1.maven.org/maven2/fr/ird/observe/observe/9.2.1/observe-9.2.1-client.zip)

 * [Serveur (observe-9.2.1.war)](https://repo1.maven.org/maven2/fr/ird/observe/observe/9.2.1/observe-9.2.1.war)

 * [Serveur (observe-9.2.1-server.zip)](https://repo1.maven.org/maven2/fr/ird/observe/observe/9.2.1/observe-9.2.1-server.zip)

 ### Issues

   * [[Type::Anomalie 2798]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2798) **Souci de décalage de lignes sur le rapport Vérification des plans de cuve** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2800]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2800) **Erreur de migration sur bases AZTI locales** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

     protected void onComingFromNextStepAdjust() {

         AdminUIModel model = ui.getModel();

                 (model.containsOperation(AdminStep.CONSOLIDATE) && !model.containsOperation(AdminStep.EXPORT_DATA))) {

             if (model.getStepState(AdminStep.CONSOLIDATE) == WizardState.SUCCESSED) {

                 // set back to pending consolidate step

                 model.setStepState(AdminStep.VALIDATE, WizardState.PENDING);

                 // reset report model

                 model.getValidateModel().reset();

             }

         }

     }

         super.afterInit(ui);

         setAutoStart(ui.getPrepare());

         hideFixedPanelLabel(ui);

     }

 }

             }

             break;

         }

         stepModel.recomputeSelectedValues();

         return WizardState.NEED_FIX;

     }

     <field name="transmittingBuoyOwnership" component="transmittingBuoyOwnership1"/>

     <field name="code" component="code1"/>

     <field name="country" component="country1"/>

     <field name='longitude' component='coordinate1'/>

     <field name='latitude' component='coordinate1'/>

     <field name='quadrant' component='coordinate1'/>

     <field name="transmittingBuoyOwnership" component="transmittingBuoyOwnership2"/>

     <field name="code" component="code2"/>

     <field name="country" component="country2"/>

     <field name='comment' component='comment2'/>

   </BeanValidator>

     <field name="transmittingBuoyOwnership" component="transmittingBuoyOwnership1"/>

     <field name="code" component="code1"/>

     <field name="country" component="country1"/>

     <field name='longitude' component='coordinate1'/>

     <field name='latitude' component='coordinate1'/>

     <field name='quadrant' component='coordinate1'/>

     <field name="transmittingBuoyOwnership" component="transmittingBuoyOwnership2"/>

     <field name="code" component="code2"/>

     <field name="country" component="country2"/>

     <field name='comment' component='comment2'/>

   </BeanValidator>

                           <JLabel id='vessel1Label'/>

                         </cell>

                         <cell anchor='east' weightx="1" fill="both">

                         </cell>

                       </row>

                       <row>

       "ll_observation.set→DELETE FROM ll_observation.set WHERE set.activity %s;",

       "ll_observation.sensorUsed→DELETE FROM ll_observation.sensorUsed WHERE sensorUsed.activity %s;",

       "ll_observation.encounter→DELETE FROM ll_observation.encounter WHERE encounter.activity %s;",

       "ll_observation.activity→DELETE FROM ll_observation.activity WHERE activity.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.BaitsComposition": [

       "ll_observation.baitsComposition→DELETE FROM ll_observation.baitsComposition WHERE baitsComposition.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.Basket": [

       "ll_observation.branchline→DELETE FROM ll_observation.branchline WHERE branchline.basket %s;",

       "ll_observation.basket→DELETE FROM ll_observation.basket WHERE basket.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.Branchline": [

       "ll_observation.branchline→DELETE FROM ll_observation.branchline WHERE branchline.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.BranchlinesComposition": [

       "ll_observation.hooksComposition→DELETE FROM ll_observation.hooksComposition WHERE hooksComposition.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.Section": [

       "ll_observation.branchline→DELETE FROM ll_observation.branchline WHERE branchline.topiaId IN (SELECT branchline.topiaId FROM ll_observation.branchline branchline INNER JOIN ll_observation.basket basket ON basket.topiaId = branchline.basket WHERE basket.section %s);",

       "ll_observation.basket→DELETE FROM ll_observation.basket WHERE basket.section %s;",

       "ll_observation.section→DELETE FROM ll_observation.section WHERE section.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ll.observation.SensorUsed": [

     ],

     "fr.ird.observe.entities.data.ps.localmarket.Survey": [

       "ps_localmarket.surveyPart→DELETE FROM ps_localmarket.surveyPart WHERE surveyPart.survey %s;",

       "ps_localmarket.survey→DELETE FROM ps_localmarket.survey WHERE survey.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ps.localmarket.SurveyPart": [

       "ps_observation.floatingObject→DELETE FROM ps_observation.floatingObject WHERE floatingObject.activity %s;",

       "ps_observation.catch→DELETE FROM ps_observation.catch WHERE catch.topiaId IN (SELECT catch.topiaId FROM ps_observation.catch catch INNER JOIN ps_observation.set set ON set.topiaId = catch.set WHERE set.activity %s);",

       "ps_observation.set→DELETE FROM ps_observation.set WHERE set.activity %s;",

       "ps_observation.activity→DELETE FROM ps_observation.activity WHERE activity.topiaId %s;"

     ],

     "fr.ird.observe.entities.data.ps.observation.Catch": [

       "ps_observation.floatingObject→DELETE FROM ps_observation.floatingObject WHERE floatingObject.topiaId IN (SELECT floatingObject.topiaId FROM ps_observation.floatingObject floatingObject INNER JOIN ps_observation.activity activity ON activity.topiaId = floatingObject.activity WHERE activity.route %s);",

       "ps_observation.catch→DELETE FROM ps_observation.catch WHERE catch.topiaId IN (SELECT catch.topiaId FROM ps_observation.catch catch INNER JOIN ps_observation.set set ON set.topiaId = catch.set  INNER JOIN ps_observation.activity activity ON activity.topiaId = set.activity WHERE activity.route %s);",

       "ps_observation.set→DELETE FROM ps_observation.set WHERE set.topiaId IN (SELECT set.topiaId FROM ps_observation.set set INNER JOIN ps_observation.activity activity ON activity.topiaId = set.activity WHERE activity.route %s);",

       "ps_observation.activity→DELETE FROM ps_observation.activity WHERE activity.route %s;",

       "ps_observation.route→DELETE FROM ps_observation.route WHERE route.topiaId %s;"

     ],

 import fr.ird.observe.dto.BusinessDto;

 import fr.ird.observe.dto.ToolkitIdDtoBean;

 import fr.ird.observe.dto.data.RootOpenableDto;

 import java.util.Set;

 import java.util.StringJoiner;

  * @author Tony Chemit - dev@tchemit.fr

  * @since 8.0.1

  */

     /**

      * Id of parent data to move.

  */

 import fr.ird.observe.datasource.SqlHelper;

 import fr.ird.observe.entities.Entity;

 import fr.ird.observe.spi.context.DataDtoEntityContext;

 import org.hibernate.query.NativeQuery;

 import javax.persistence.Parameter;

 import java.sql.Timestamp;

 import java.util.Collections;

 import java.util.Comparator;

 import java.util.LinkedList;

 import java.util.List;

 import java.util.Map;

 import java.util.function.BiConsumer;

 import java.util.function.Function;

 import java.util.stream.Collectors;

 /**

     default int execute(NativeQuery<?> sqlQuery) {

         return sqlQuery.executeUpdate();

     }

 }

     public static final String FROM_SQL = "%s WHERE %s";

     public static final String FROM_SQL_NO_WHERE = "%s";

     public static final String SQL_WHERE_CLAUSE_ALIAS = "%1$s.%2$s";

     public static final String DELETE_FROM_SELECTOR_STATEMENT = "DELETE FROM %1$s.%2$s WHERE %2$s.%3$s IN (%4$s);";

     public static final String DELETE_FROM_SELECTOR_SIMPLIFIED_STATEMENT = "DELETE FROM %1$s.%2$s WHERE %3$s;";