fr.ird.observe.dto.referential.common.SpeciesReference

     fr.ird.observe.dto.referential.common.VesselReference

     fr.ird.observe.dto.referential.ll.landing.DataSourceReference

     fr.ird.observe.client.ui.actions.content.data.ll.delete.DeleteTripLonglineLandingUIAction

     fr.ird.observe.client.ui.actions.content.data.ll.move.MoveSingleTripLonglineLandingUIAction

   -->

 <fr.ird.observe.client.ui.content.api.ref.ContentI18nReferenceUI

     superGenericType='CompagniesDto, CompagniesReference, CompagniesUI'>

   <import>

     fr.ird.observe.dto.reference.ReferentialDtoReference

     static fr.ird.observe.client.ui.util.UIHelper.getStringValue

     fr.ird.observe.dto.referential.ReferenceStatus

   </import>

   <!-- validator -->

                  context='create' errorTableModel='{getErrorTableModel()}'/>

   <!-- model -->

 /*-

  * #%L

  */

 import fr.ird.observe.client.ui.content.api.ref.ContentReferenceUIHandler;

 import org.nuiton.jaxx.runtime.spi.UIHandler;

 /**

 /*

  * #%L

  */

 import fr.ird.observe.client.ui.content.api.ref.ContentReferenceUIModel;

 /**

  * Created on 9/27/14.

 import fr.ird.observe.dto.reference.ReferentialDtoReference;

 import fr.ird.observe.dto.referential.ReferentialDto;

 import fr.ird.observe.dto.referential.ReferentialLocale;

 import fr.ird.observe.dto.referential.common.CountryDto;

 import fr.ird.observe.dto.referential.common.CountryReference;

 import fr.ird.observe.dto.referential.common.DataQualityDto;

 import fr.ird.observe.dto.data.ps.observation.TransmittingBuoyDto;

 import fr.ird.observe.dto.reference.DtoReference;

 import fr.ird.observe.dto.referential.ReferentialDto;

 import fr.ird.observe.dto.referential.common.CountryDto;

 import fr.ird.observe.dto.referential.common.DataQualityDto;

 import fr.ird.observe.dto.referential.common.FpaZoneDto;

     public static final ImmutableSet<Class<? extends ReferentialDto>> COMMON_REFERENTIAL_TYPES = ImmutableSet.of(

             VesselSizeCategoryDto.class,

             CountryDto.class,

             LengthMeasureMethodDto.class,

             WeightMeasureMethodDto.class,

             DataQualityDto.class,

             WeightDeterminationMethodDto.class);

     public static final ImmutableSet<Class<? extends ReferentialDto>> LONGLINE_LANDING_REFERENTIAL_TYPES = ImmutableSet.of(

             ConservationDto.class,

             DataSourceDto.class);

 ocean {*:0..1} fr.ird.observe.dto.referential.common.OceanReference

 sex {*:1} fr.ird.observe.dto.referential.common.SexReference

 referential.common.Country > referential.I18nReferential | references=code,label,uri,iso2Code,iso3Code

 iso2Code + {*:1} String

 iso3Code + {*:1} String

 package fr.ird.observe.dto.referential.ll.landing | form=self

 referential.ll.landing.Conservation > referential.I18nReferential

 referential.ll.landing.DataSource > referential.I18nReferential

 startDate + {*:1} Date

 endDate + {*:1} Date

 dataSource {*:1} fr.ird.observe.dto.referential.ll.landing.DataSourceReference

 person {*:1} fr.ird.observe.dto.referential.common.PersonReference

 harbour {*:0..1} fr.ird.observe.dto.referential.common.HarbourReference

 vessel {*:0..1} fr.ird.observe.dto.referential.common.VesselReference

 ClientConfig.description=ObServe configuration

 ObserveWebApplicationConfig.description=ObServe Web configuration

 observe.TripLongline.action.generateHomeId.tip=Generate a new id

 observe.validation.activity.speed.bound=Activity speed is %s nd, which is more than the maximum authorized which is %s nd.

 observe.validation.activity.speed.bound.inter=Speed between two activities can't exceed %1$s nd, (activity %2$s speed is %3$s).

 observe.validation.activityLongline.desactivated.fpaZone=Fpa zone is disabled.

 observe.validation.baitsComposition.bound.individualSize=Size must be bound between %s and %s.

 observe.validation.baitsComposition.bound.individualWeight=Weight must be bound between %s and %s.

 observe.validation.baitsComposition.bound.proportion=Proportion must be bound between %s and %s.

 ClientConfig.description=Configuración de ObServe

 ObserveWebApplicationConfig.description=Configuración de Observe web

 observe.TripLongline.action.generateHomeId.tip=Génerer un identifiant \#TODO

 observe.validation.activity.speed.bound=La velocidad de la actividad actual es %s nudos, mientras que la velocidad máxima es %s nudos.

 observe.validation.activity.speed.bound.inter=la velocidad entre dos actividades no debe sobrepasar %1$s nd, (actividad %2$s incorrecta, velocidad  \: %3$s nd).

 observe.validation.activityLongline.desactivated.fpaZone=La zona FPA seleccionada está desactivada.

 observe.validation.baitsComposition.bound.individualSize=El tamaño debe ser entre %s y %s.

 observe.validation.baitsComposition.bound.individualWeight=El peso debe ser entre %s y %s.

 observe.validation.baitsComposition.bound.proportion=La proporción debe ser entre %s y %s.

 observe.action.back.to.list=Retour à la liste

 observe.action.back.to.list.tip=Retour à la liste des données

 observe.action.cancel=Annuler

 observe.action.cancel.remote.tip=Annuler la création de la configuration

 observe.action.cancel.server.tip=Annuler la création de la configuration

 observe.action.change.storage=Changer la source de données

 observe.validation.activity.speed.bound=La vitesse de l'activité courante est de %s nd, alors que la vitesse maximale autorisée est %s nd.

 observe.validation.activity.speed.bound.inter=La vitesse entre deux activités ne doit pas dépasser %1$s nd, (l'activité %2$s a une vitesse de %3$s nd).

 observe.validation.activityLongline.desactivated.fpaZone=La zone FPA sélectionnée est désactivée.

 observe.validation.baitsComposition.bound.individualSize=La taille doit être comprise entre %s et %s.

 observe.validation.baitsComposition.bound.individualWeight=Le poids doit être comprise entre %s et %s.

 observe.validation.baitsComposition.bound.proportion=La proportion doit être comprise entre %s et %s.

 /*-

  * #%L

  */

 import fr.ird.observe.binder.referential.ReferentialEntityDtoBinderSupport;

 import fr.ird.observe.dto.referential.ReferentialLocale;

 /**

  * Created on 24/11/15.

             new ObserveEntityEnum[]{

                     ObserveEntityEnum.common_VesselSizeCategory,

                     ObserveEntityEnum.common_Country,

                     ObserveEntityEnum.common_LengthMeasureMethod,

                     ObserveEntityEnum.common_WeightMeasureMethod,

                     ObserveEntityEnum.common_DataQuality,

                     ObserveEntityEnum.ll_common_VesselActivityLongline,

                     ObserveEntityEnum.ll_common_OnBoardProcessing,

                     ObserveEntityEnum.ll_common_TripType,

                     ObserveEntityEnum.ll_landing_Conservation,

                     ObserveEntityEnum.ll_landing_DataSource,

                     ObserveEntityEnum.ll_observation_BaitHaulingStatus,

 label8 + {*:1} String

 getLabel(referentialLocale !fr.ird.observe.dto.referential.ReferentialLocale) String

 referential.common.Country > referential.I18nReferentialEntity | entity

 iso2Code + {*:1} String

 iso3Code + {*:1} String

 package fr.ird.observe.entities.referential.ll.landing | dbSchema=ll_landing

 referential.ll.landing.Conservation > referential.I18nReferentialEntity | entity

 referential.ll.landing.DataSource > referential.I18nReferentialEntity | entity

 startDate + {*:1} Date

 endDate + {*:1} Date

 dataSource {*:1} referential.ll.landing.DataSource

 person {*:1} referential.common.Person

 harbour {*:0..1} referential.common.Harbour

 vessel {*:0..1} referential.common.Vessel

 CREATE SCHEMA common;

 CREATE TABLE common.country(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_country PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), uri VARCHAR(255), iso2code VARCHAR(255), iso3code VARCHAR(255), status INTEGER DEFAULT 1, label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.dataquality(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_dataquality PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255));

 CREATE TABLE common.fpazone(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_fpazone PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), startdate DATE, enddate DATE, needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.speciesgroup_speciesgroupreleasemode(speciesgroup VARCHAR(255) NOT NULL, speciesgroupreleasemode VARCHAR(255) NOT NULL);

 CREATE TABLE common.species_specieslist(specieslist VARCHAR(255) NOT NULL, species VARCHAR(255) NOT NULL);

 INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, code, uri, iso2code, iso3code, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, uri, iso2code, iso3code, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate FROM observe_common.country;

 INSERT INTO common.dataquality(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_common.dataquality;

 INSERT INTO common.fpazone(topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, startdate, enddate, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, startdate, enddate, needcomment, lastupdatedate FROM observe_common.fpazone;

 INSERT INTO common.speciesgroup_speciesgroupreleasemode( speciesgroup, speciesgroupreleasemode) SELECT speciesgroup, speciesgroupreleasemode FROM observe_common.speciesgroup_speciesgroupreleasemode;

 INSERT INTO common.species_specieslist( specieslist, species) SELECT specieslist, species FROM observe_common.species_specieslist;

 UPDATE common.Country SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel', 'referential.common'), topiaversion = topiaversion+1;

 UPDATE common.DataQuality SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel', 'referential.common'), topiaversion = topiaversion+1;

 UPDATE common.FpaZone SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel', 'referential.common'), topiaversion = topiaversion+1;

 UPDATE common.speciesgroup_speciesgroupreleasemode SET speciesgroup = REPLACE(speciesgroup,'observe.entities.referentiel','referential.common'), speciesgroupreleasemode=REPLACE(speciesgroupreleasemode,'observe.entities.referentiel','referential.common');

 UPDATE common.species_specieslist SET specieslist = REPLACE(specieslist,'observe.entities.referentiel','referential.common'), species=REPLACE(species,'observe.entities.referentiel','referential.common');

 CREATE INDEX idx_common_country_lastupdatedate ON common.country(lastupdatedate);

 CREATE INDEX idx_common_dataquality_lastupdatedate ON common.dataquality(lastupdatedate);

 CREATE INDEX idx_common_fpazone_lastupdatedate ON common.fpazone(lastupdatedate);

 ALTER TABLE common.species_specieslist ADD CONSTRAINT fk_common_species_specieslist_specieslist FOREIGN KEY(specieslist) REFERENCES common.specieslist;

 ALTER TABLE common.species_specieslist ADD CONSTRAINT fk_common_species_specieslist_species FOREIGN KEY(species) REFERENCES common.species;

 UPDATE common.LASTUPDATEDATE SET TYPE = REPLACE(TYPE, 'referentiel.Country' , 'referential.common.Country');

 UPDATE common.LASTUPDATEDATE SET TYPE = REPLACE(TYPE, 'referentiel.DataQuality' , 'referential.common.DataQuality');

 UPDATE common.LASTUPDATEDATE SET TYPE = REPLACE(TYPE, 'referentiel.FpaZone' , 'referential.common.FpaZone');

 CREATE SCHEMA ll_landing;

 CREATE TABLE ll_landing.conservation(topiaid VARCHAR(255) NOT NULL, topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), CONSTRAINT pk_ll_landing_conservation primary key(topiaid));

 CREATE TABLE ll_landing.datasource(topiaid VARCHAR(255) NOT NULL, topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), CONSTRAINT pk_ll_landing_datasource primary key(topiaid));

 CREATE TABLE ll_landing.landingpart(topiaid VARCHAR(255) NOT NULL, topiaversion BIGINT NOT NULL, topiacreatedate TIMESTAMP, lastupdatedate TIMESTAMP NOT NULL, dataquality VARCHAR(255), categorymin NUMERIC, categorymax NUMERIC, count INTEGER, weight NUMERIC, startdate DATE, enddate DATE, species VARCHAR(255), fpazone VARCHAR(255), onboardprocessing VARCHAR(255), conservation VARCHAR(255), landing VARCHAR(255), weightmeasuremethod VARCHAR(255), CONSTRAINT pk_ll_landing_landingpart primary key(topiaid));

 CREATE TABLE ll_landing.landing(topiaid VARCHAR(255) NOT NULL, topiaversion BIGINT NOT NULL, topiacreatedate TIMESTAMP, lastupdatedate TIMESTAMP NOT NULL, comment VARCHAR(1025), startdate DATE, enddate DATE, datasource VARCHAR(255), compagnies VARCHAR(255), person VARCHAR(255), harbour VARCHAR(255), vessel VARCHAR(255), trip VARCHAR(255), CONSTRAINT pk_ll_landing_landing primary key(topiaid));

 INSERT INTO ll_landing.conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 ) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_longline.conservation;

 INSERT INTO ll_landing.datasource(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 ) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_longline.datasource;

 UPDATE ll_landing.conservation SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel.longline', 'referential.ll.landing'), topiaversion = topiaversion + 1;

 UPDATE ll_landing.datasource SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel.longline', 'referential.ll.landing'), topiaversion = topiaversion + 1;

 ALTER TABLE ll_landing.landingpart ADD CONSTRAINT fk_ll_landing_landingpart_onboardprocessing foreign key(onboardprocessing) references ll_common.onboardprocessing;

 ALTER TABLE ll_landing.landingpart ADD CONSTRAINT fk_ll_landing_landingpart_species foreign key(species) references common.species;

 ALTER TABLE ll_landing.landingpart ADD CONSTRAINT fk_ll_landing_landingpart_weightmeasuremethod foreign key(weightmeasuremethod) references common.weightmeasuremethod;

 ALTER TABLE ll_landing.landing ADD CONSTRAINT fk_ll_landing_landing_datasource foreign key(datasource) references ll_landing.datasource;

 ALTER TABLE ll_landing.landing ADD CONSTRAINT fk_ll_landing_landing_harbour foreign key(harbour) references common.harbour;

 ALTER TABLE ll_landing.landing ADD CONSTRAINT fk_ll_landing_landing_person foreign key(person) references common.person;

 CREATE INDEX idx_ll_landing_landing_trip ON ll_landing.landing(trip);

 CREATE INDEX idx_ll_landing_landing_vessel ON ll_landing.landing(vessel);

 CREATE INDEX idx_ll_landing_conservation_lastupdatedate ON ll_landing.conservation(lastupdatedate);

 CREATE INDEX idx_ll_landing_datasource_lastupdatedate ON ll_landing.datasource(lastupdatedate);

 CREATE INDEX idx_ll_landing_landingpart_lastupdatedate ON ll_landing.landingpart(lastupdatedate);

 INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1021', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.landing.LandingLongline', CURRENT_TIMESTAMP);

 INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1022', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.landing.LandingPartLongline', CURRENT_TIMESTAMP);

 UPDATE common.LASTUPDATEDATE SET TYPE = replace(TYPE, 'referentiel.longline.Conservation', 'referential.ll.landing.Conservation');

 UPDATE common.LASTUPDATEDATE SET TYPE = replace(TYPE, 'referentiel.longline.DataSource', 'referential.ll.landing.DataSource');

 -- #L%

 ---

 ALTER TABLE common.country ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE common.dataquality ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE common.fpazone ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_common.vesselactivity ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_common.weightcategory ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_common.weightdeterminationmethod ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_landing.conservation ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_landing.datasource ADD COLUMN homeId VARCHAR(255);

 ALTER TABLE ll_landing.landing ADD COLUMN homeId VARCHAR(255);

 -- #L%

 ---