March 2012 - Wao-commits - mailman.cloud.codelutin.com

r1572 - trunk/wao-business/src/main/java/fr/ifremer/wao
by bleny＠users.forge.codelutin.com March 20, 2012

March 20, 2012

Author: bleny Date: 2012-03-20 14:56:25 +0100 (Tue, 20 Mar 2012) New Revision: 1572 Url: http://forge.codelutin.com/repositories/revision/wao/1572 Log: Evolution #1007 Ajouter des index sur les cl?\195?\169s ?\195?\169trang?\195?\168res Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-20 13:51:45 UTC (rev 1571) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-20 13:56:25 UTC (rev 1572) @@ -1114,4 +1114,23 @@ queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_V') WHERE obsProgramOrdinal=1;"); queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_D') WHERE obsProgramOrdinal=2;"); } + + @Override + protected void addAllMissingIndexesOnForeignKeys_3_3(List<String> queries) { + queries.add("CREATE INDEX idx_Boat_elligibleBoat ON elligibleBoat(boat); "); + queries.add("CREATE INDEX idx_Company_waoUser ON waoUser(company); "); + queries.add("CREATE INDEX idx_Contact_secondaryObservers ON contact_secondaryobservers(contact);"); + queries.add("CREATE INDEX idx_FishingZone_sampleRow ON fishingzone_samplerow(fishingZone); "); + queries.add("CREATE INDEX idx_Indicator_indicatorLevel ON indicatorLevel(indicator); "); + queries.add("CREATE INDEX idx_ObsDebCode_obsDebCodeDetails ON obsDebCodeDetails(obsDebCode); "); + queries.add("CREATE INDEX idx_SampleRow_sampleMonth ON sampleMonth(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_sampleRowLog ON sampleRowLog(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_elligibleBoat ON elligibleBoat(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_fishingZone ON fishingzone_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_dCF5Code ON dcf5code_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_SampleRow_observers ON observers_samplerow(sampleRow); "); + queries.add("CREATE INDEX idx_WaoUser_userProfile ON userProfile(waoUser); "); + queries.add("CREATE INDEX idx_WaoUser_allegroWallet ON allegrowallet_waouser(waoUser); "); + queries.add("CREATE INDEX idx_WaoUser_canReadBoats ON canreadboats_waouser(waoUser); "); + } } Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-20 13:51:45 UTC (rev 1571) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-20 13:56:25 UTC (rev 1572) @@ -621,10 +621,14 @@ migrateSampleRowCodes_3_3(queries); + addAllMissingIndexesOnForeignKeys_3_3(queries); + String[] strings = queries.toArray(new String[queries.size()]); executeSQL(tx, showSql, showProgression, strings); } + protected abstract void addAllMissingIndexesOnForeignKeys_3_3(List<String> queries); + protected abstract void migrateSampleRowCodes_3_3(List<String> queries); protected abstract void addWaoUserCguAccepted_3_3(List<String> queries);

1 0

r1571 - trunk/wao-business/src/main/java/fr/ifremer/wao
by bleny＠users.forge.codelutin.com March 20, 2012

March 20, 2012

Author: bleny Date: 2012-03-20 14:51:45 +0100 (Tue, 20 Mar 2012) New Revision: 1571 Url: http://forge.codelutin.com/repositories/revision/wao/1571 Log: conventions de nommage des m?\195?\169thodes de migration Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-19 17:01:27 UTC (rev 1570) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2012-03-20 13:51:45 UTC (rev 1571) @@ -1109,7 +1109,7 @@ } @Override - protected void migrateSampleRowCodes(List<String> queries) { + protected void migrateSampleRowCodes_3_3(List<String> queries) { queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_M') WHERE obsProgramOrdinal=0;"); queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_V') WHERE obsProgramOrdinal=1;"); queries.add("UPDATE SampleRow SET code=REPLACE(code, '_', '_D') WHERE obsProgramOrdinal=2;"); Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-19 17:01:27 UTC (rev 1570) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java 2012-03-20 13:51:45 UTC (rev 1571) @@ -619,13 +619,13 @@ addWaoUserCguAccepted_3_3(queries); - migrateSampleRowCodes(queries); + migrateSampleRowCodes_3_3(queries); String[] strings = queries.toArray(new String[queries.size()]); executeSQL(tx, showSql, showProgression, strings); } - protected abstract void migrateSampleRowCodes(List<String> queries); + protected abstract void migrateSampleRowCodes_3_3(List<String> queries); protected abstract void addWaoUserCguAccepted_3_3(List<String> queries);

1 0

r1570 - in trunk: src/site/resources/exemples_imports/obsDeb src/site/rst/obsMer src/site/rst/obsVente wao-business/src/main/java/fr/ifremer/wao wao-business/src/main/java/fr/ifremer/wao/bean wao-business/src/main/java/fr/ifremer/wao/io/csv2/models wao-business/src/main/java/fr/ifremer/wao/io/csv2/models/operations wao-business/src/main/java/fr/ifremer/wao/service wao-business/src/main/resources/i18n wao-business/src/test/java/fr/ifremer/wao/business wao-business/src/test/java/fr/ifremer/wao/b
by bleny＠users.forge.codelutin.com March 19, 2012

March 19, 2012

Author: bleny Date: 2012-03-19 18:01:27 +0100 (Mon, 19 Mar 2012) New Revision: 1570 Url: http://forge.codelutin.com/repositories/revision/wao/1570 Log: Evolution #792 Changer la forme des codes des lignes Modified: trunk/src/site/resources/exemples_imports/obsDeb/plan_?\195?\169chantillonnage_t?\195?\169l?\195?\169phonique.csv trunk/src/site/resources/exemples_imports/obsDeb/plan_?\195?\169chantillonnage_terrain.csv trunk/src/site/rst/obsMer/administrateur.rst trunk/src/site/rst/obsVente/administrateur.rst trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java trunk/wao-business/src/main/java/fr/ifremer/wao/WaoMigrationCallBack.java trunk/wao-business/src/main/java/fr/ifremer/wao/WaoUtils.java trunk/wao-business/src/main/java/fr/ifremer/wao/bean/ObsProgram.java trunk/wao-business/src/main/java/fr/ifremer/wao/io/csv2/models/ObsDebSamplingPlanImportExportModel.java trunk/wao-business/src/main/java/fr/ifremer/wao/io/csv2/models/ObsMerObsVenteSamplingPlanImportExportModel.java trunk/wao-business/src/main/java/fr/ifremer/wao/io/csv2/models/operations/SampleRowCodeParserFormatter.java trunk/wao-business/src/main/java/fr/ifremer/wao/service/ServiceSamplingImpl.java trunk/wao-business/src/main/resources/i18n/wao-business_en_GB.properties trunk/wao-business/src/main/resources/i18n/wao-business_fr_FR.properties trunk/wao-business/src/test/java/fr/ifremer/wao/business/ObsDebFieldWorkTest.java trunk/wao-business/src/test/java/fr/ifremer/wao/business/ObsDebPhoneTest.java trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures/ObsMerFixtures.java trunk/wao-business/src/test/java/fr/ifremer/wao/entity/BoatImplTest.java trunk/wao-business/src/test/java/fr/ifremer/wao/service/ServiceSamplingTest.java trunk/wao-business/src/test/resources/import/echantillonnage.csv trunk/wao-business/src/test/resources/import/misc.csv trunk/wao-business/src/test/resources/import/samplingPlan-obsdeb.csv trunk/wao-ui/src/main/java/fr/ifremer/wao/ui/pages/SampleRowForm.java /opt/redmine-tools/commit-email.pl: `/usr/bin/svnlook diff /var/lib/svn/svn-forge.codelutin.com/wao -r 1570' failed with this output: Modified: trunk/src/site/resources/exemples_imports/obsDeb/plan_?\195?\169chantillonnage_terrain.csv =================================================================== svnlook: Can't convert string from 'UTF-8' to native encoding: svnlook: --- trunk/src/site/resources/exemples_imports/obsDeb/plan_?\195?\169chantillonnage_terrain.csv 2012-03-16 16:17:07 UTC (rev 1569) +++ trunk/src/site/resources/exemples_imports/obsDeb/plan_?\195?\169chantillonnage_terrain.csv 2012-03-19 17:01:27 UTC (rev 1570)

1 0

r1569 - trunk/wao-business/src/main/xmi
by bleny＠users.forge.codelutin.com March 16, 2012

March 16, 2012

Author: bleny Date: 2012-03-16 17:17:07 +0100 (Fri, 16 Mar 2012) New Revision: 1569 Url: http://forge.codelutin.com/repositories/revision/wao/1569 Log: fichier adjoint au mod?\195?\168le en CamelCase Modified: trunk/wao-business/src/main/xmi/wao.properties Modified: trunk/wao-business/src/main/xmi/wao.properties =================================================================== --- trunk/wao-business/src/main/xmi/wao.properties 2012-03-16 16:15:41 UTC (rev 1568) +++ trunk/wao-business/src/main/xmi/wao.properties 2012-03-16 16:17:07 UTC (rev 1569) @@ -21,51 +21,51 @@ # along with this program. If not, see <http://www.gnu.org/licenses/>. # #L% ### -model.tagvalue.copyright=/* *##%\n Copyright (C) 2009 Wao\n *##%*/ -model.tagvalue.java.lang.String=text -model.tagvalue.exceptionClass=fr.ifremer.wao.WaoException -model.tagvalue.notGenerateToString=true -model.tagvalue.constantPrefix=PROPERTY_ -model.tagvalue.useEnumerationName=true +model.tagValue.copyright=/* *##%\n Copyright (C) 2009 Wao\n *##%*/ +model.tagValue.java.lang.String=text +model.tagValue.exceptionClass=fr.ifremer.wao.WaoException +model.tagValue.notGenerateToString=true +model.tagValue.constantPrefix=PROPERTY_ +model.tagValue.useEnumerationName=true # model.tagValue.indexForeignKeys=true # model.tagValue.doNotGenerateBooleanGetMethods=true -#model.tagvalue.useLegacyDAO=true +#model.tagValue.useLegacyDAO=true -fr.ifremer.wao.entity.WaoUser.attribute.userProfile.tagvalue.lazy=false +fr.ifremer.wao.entity.WaoUser.attribute.userProfile.tagValue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.sampleMonth.tagvalue.orderBy=periodDate -fr.ifremer.wao.entity.SampleRow.attribute.fishingZone.tagvalue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.fishingZone.tagvalue.orderBy=facadeName,sectorName,districtCode -fr.ifremer.wao.entity.SampleRow.attribute.company.tagvalue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.profession.tagvalue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.dCF5Code.tagvalue.lazy=false -fr.ifremer.wao.entity.DCF5Code.attribute.fishingGearDCF.tagvalue.lazy=false -fr.ifremer.wao.entity.DCF5Code.attribute.targetSpeciesDCF.tagvalue.lazy=false -#fr.ifremer.wao.entity.SampleRow.attribute.elligibleBoat.tagvalue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.elligibleBoat.tagvalue.orderBy=companyActive -#fr.ifremer.wao.entity.SampleRow.attribute.sampleRowLog.tagvalue.lazy=false -fr.ifremer.wao.entity.SampleRow.attribute.sampleRowLog.tagvalue.orderBy=topiaCreateDate desc +fr.ifremer.wao.entity.SampleRow.attribute.sampleMonth.tagValue.orderBy=periodDate +fr.ifremer.wao.entity.SampleRow.attribute.fishingZone.tagValue.lazy=false +fr.ifremer.wao.entity.SampleRow.attribute.fishingZone.tagValue.orderBy=facadeName,sectorName,districtCode +fr.ifremer.wao.entity.SampleRow.attribute.company.tagValue.lazy=false +fr.ifremer.wao.entity.SampleRow.attribute.profession.tagValue.lazy=false +fr.ifremer.wao.entity.SampleRow.attribute.dCF5Code.tagValue.lazy=false +fr.ifremer.wao.entity.DCF5Code.attribute.fishingGearDCF.tagValue.lazy=false +fr.ifremer.wao.entity.DCF5Code.attribute.targetSpeciesDCF.tagValue.lazy=false +#fr.ifremer.wao.entity.SampleRow.attribute.elligibleBoat.tagValue.lazy=false +fr.ifremer.wao.entity.SampleRow.attribute.elligibleBoat.tagValue.orderBy=companyActive +#fr.ifremer.wao.entity.SampleRow.attribute.sampleRowLog.tagValue.lazy=false +fr.ifremer.wao.entity.SampleRow.attribute.sampleRowLog.tagValue.orderBy=topiaCreateDate desc -fr.ifremer.wao.entity.SampleRowLog.attribute.author.tagvalue.lazy=false +fr.ifremer.wao.entity.SampleRowLog.attribute.author.tagValue.lazy=false -fr.ifremer.wao.entity.FishingZone.attribute.sampleRow.tagvalue.orderBy=code +fr.ifremer.wao.entity.FishingZone.attribute.sampleRow.tagValue.orderBy=code -#fr.ifremer.wao.entity.Boat.attribute.shipOwner.tagvalue.lazy=false -fr.ifremer.wao.entity.Boat.attribute.boatDistrict.tagvalue.lazy=false -fr.ifremer.wao.entity.Boat.attribute.elligibleBoat.tagvalue.orderBy=companyActive +#fr.ifremer.wao.entity.Boat.attribute.shipOwner.tagValue.lazy=false +fr.ifremer.wao.entity.Boat.attribute.boatDistrict.tagValue.lazy=false +fr.ifremer.wao.entity.Boat.attribute.elligibleBoat.tagValue.orderBy=companyActive -fr.ifremer.wao.entity.ElligibleBoat.attribute.boat.tagvalue.lazy=false +fr.ifremer.wao.entity.ElligibleBoat.attribute.boat.tagValue.lazy=false -fr.ifremer.wao.entity.Contact.attribute.sampleRow.tagvalue.lazy=false -fr.ifremer.wao.entity.Contact.attribute.boat.tagvalue.lazy=false +fr.ifremer.wao.entity.Contact.attribute.sampleRow.tagValue.lazy=false +fr.ifremer.wao.entity.Contact.attribute.boat.tagValue.lazy=false -fr.ifremer.wao.entity.TerrestrialDivision.attribute.regionIfremer.tagvalue.lazy=false +fr.ifremer.wao.entity.TerrestrialDivision.attribute.regionIfremer.tagValue.lazy=false -fr.ifremer.wao.entity.Indicator.attribute.indicatorLevel.tagvalue.lazy=false -fr.ifremer.wao.entity.IndicatorLog.attribute.author.tagvalue.lazy=false -fr.ifremer.wao.entity.Indicator.attribute.indicatorLevel.tagvalue.orderBy=level +fr.ifremer.wao.entity.Indicator.attribute.indicatorLevel.tagValue.lazy=false +fr.ifremer.wao.entity.IndicatorLog.attribute.author.tagValue.lazy=false +fr.ifremer.wao.entity.Indicator.attribute.indicatorLevel.tagValue.orderBy=level fr.ifremer.wao.entity.SampleRow.attribute.observers.tagValue.inverse=false fr.ifremer.wao.entity.WaoUser.attribute.SampleRow.tagValue.inverse=true

1 0

r1568 - trunk/wao-business/src/main/xmi
by bleny＠users.forge.codelutin.com March 16, 2012

March 16, 2012

Author: bleny Date: 2012-03-16 17:15:41 +0100 (Fri, 16 Mar 2012) New Revision: 1568 Url: http://forge.codelutin.com/repositories/revision/wao/1568 Log: ajout de la tagValue indexForeignKeys comment?\195?\169e Modified: trunk/wao-business/src/main/xmi/wao.properties Modified: trunk/wao-business/src/main/xmi/wao.properties =================================================================== --- trunk/wao-business/src/main/xmi/wao.properties 2012-03-16 15:53:26 UTC (rev 1567) +++ trunk/wao-business/src/main/xmi/wao.properties 2012-03-16 16:15:41 UTC (rev 1568) @@ -27,6 +27,8 @@ model.tagvalue.notGenerateToString=true model.tagvalue.constantPrefix=PROPERTY_ model.tagvalue.useEnumerationName=true +# model.tagValue.indexForeignKeys=true + # model.tagValue.doNotGenerateBooleanGetMethods=true #model.tagvalue.useLegacyDAO=true

1 0

r1567 - in trunk/wao-business/src/main: java/fr/ifremer/wao/entity java/fr/ifremer/wao/service resources/i18n
by bleny＠users.forge.codelutin.com March 16, 2012

March 16, 2012

Author: bleny Date: 2012-03-16 16:53:26 +0100 (Fri, 16 Mar 2012) New Revision: 1567 Url: http://forge.codelutin.com/repositories/revision/wao/1567 Log: Evolution #813 mise ?\195?\160 jour des r?\195?\169f?\195?\169rentiels DCF5 : selon les CSV Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/entity/FishingGearDCFImpl.java trunk/wao-business/src/main/java/fr/ifremer/wao/entity/TargetSpeciesDCFImpl.java trunk/wao-business/src/main/java/fr/ifremer/wao/service/ServiceReferentialImpl.java trunk/wao-business/src/main/resources/i18n/wao-business_en_GB.properties trunk/wao-business/src/main/resources/i18n/wao-business_fr_FR.properties Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/entity/FishingGearDCFImpl.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/entity/FishingGearDCFImpl.java 2012-03-15 15:22:28 UTC (rev 1566) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/entity/FishingGearDCFImpl.java 2012-03-16 15:53:26 UTC (rev 1567) @@ -24,6 +24,7 @@ package fr.ifremer.wao.entity; import fr.ifremer.wao.WaoUtils; +import org.apache.commons.lang3.builder.ReflectionToStringBuilder; /** * @author bleny @@ -48,4 +49,9 @@ public String getFullDescription() { return String.format("%s (%s)", getCode(), getDescription()); } + + @Override + public String toString() { + return ReflectionToStringBuilder.toString(this); + } } Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/entity/TargetSpeciesDCFImpl.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/entity/TargetSpeciesDCFImpl.java 2012-03-15 15:22:28 UTC (rev 1566) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/entity/TargetSpeciesDCFImpl.java 2012-03-16 15:53:26 UTC (rev 1567) @@ -24,6 +24,7 @@ package fr.ifremer.wao.entity; import fr.ifremer.wao.WaoUtils; +import org.apache.commons.lang3.builder.ReflectionToStringBuilder; /** * @author bleny @@ -48,4 +49,9 @@ public String getFullDescription() { return String.format("%s (%s)", getCode(), getDescription()); } + + @Override + public String toString() { + return ReflectionToStringBuilder.toString(this); + } } Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/service/ServiceReferentialImpl.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/service/ServiceReferentialImpl.java 2012-03-15 15:22:28 UTC (rev 1566) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/service/ServiceReferentialImpl.java 2012-03-16 15:53:26 UTC (rev 1567) @@ -41,6 +41,7 @@ import fr.ifremer.wao.entity.BoatGroup; import fr.ifremer.wao.entity.ContactStateMotif; import fr.ifremer.wao.entity.ContactStateMotifDAO; +import fr.ifremer.wao.entity.DCF5Code; import fr.ifremer.wao.entity.FishingGearDCF; import fr.ifremer.wao.entity.FishingGearDCFDAO; import fr.ifremer.wao.entity.FishingZone; @@ -54,6 +55,8 @@ import fr.ifremer.wao.entity.ReferentialMeta; import fr.ifremer.wao.entity.ReferentialMetaDAO; import fr.ifremer.wao.entity.ReferentialMetaImpl; +import fr.ifremer.wao.entity.SampleRow; +import fr.ifremer.wao.entity.SampleRowDAO; import fr.ifremer.wao.entity.TargetSpeciesDCF; import fr.ifremer.wao.entity.TargetSpeciesDCFDAO; import fr.ifremer.wao.entity.TerrestrialDivision; @@ -71,6 +74,7 @@ import fr.ifremer.wao.io.csv2.models.TerrestrialDivisionImportModel; import fr.ifremer.wao.io.csv2.models.TerrestrialLocationImportModel; import org.apache.commons.io.IOUtils; +import org.apache.commons.lang3.ArrayUtils; import org.apache.commons.lang3.StringUtils; import org.nuiton.topia.TopiaContext; import org.nuiton.topia.TopiaException; @@ -676,18 +680,18 @@ FishingGearDCFDAO fishingGearDCFDAO = WaoDAOHelper.getFishingGearDCFDAO(transaction); TargetSpeciesDCFDAO targetSpeciesDCFDAO = WaoDAOHelper.getTargetSpeciesDCFDAO(transaction); + + final String[] gearCodesBase = {"DRB", "DRH", + "FPN", "FPO", "FSN", "FWR", "FYK", "GES", "GNC", + "GND", "GNF", "GNS", "GTN", "GTR", "HAR", "HMD", "HMP", + "LA", "LHM", "LHP", "LLD", "LLS", "LNB", "LNP", "LNS", + "LTL", "LX", "OTB", "OTM", "OTT", "PS", + "PTB", "PTM", "RG", "SB", "SDN", "SPR", "SSC", "SV", + "TBB", "TBN", "TBS", "TMS"}; - final String[] gearCodesBase = {"DRB", "DRH", "FAR", "FCN", "FG", - "FIX", "FPN", "FPO", "FSN", "FWR", "FYK", "GEN", "GES", "GN", "GNC", - "GND", "GNF", "GNS", "GT", "GTN", "GTR", "HAR", "HMD", "HMP", "HMX", - "LA", "LHM", "LHP", "LL", "LLD", "LLS", "LN", "LNB", "LNP", "LNS", - "LTL", "LX", "MIS", "NK", "OT", "OTB", "OTM", "OTT", "PS", "PS1", - "PS2", "PT", "PTB", "PTM", "RG", "SB", "SDN", "SPR", "SSC", "SV", - "SW", "TB", "TBB", "TBN", "TBS", "TM", "TMS", "TX"}; + final String[] speciesCodesBase = {"ALG", "ANA", "CAT", "CRU", + "DEF", "DWS", "LPF", "MOL", "SPF"}; - final String[] speciesCodesBase = {"ALG", "CAT", "CRU", "CSJ", - "DEF", "DWS", "FIN", "LPF", "MOL", "SPF", "CRW"}; - long nbCodes = fishingGearDCFDAO.count() + targetSpeciesDCFDAO.count(); if (nbCodes == 0) { @@ -726,6 +730,37 @@ } } + // on supprime ce qu'il y a en trop + for (FishingGearDCF fishingGearDCF : fishingGearDCFDAO.findAll()) { + if ( ! ArrayUtils.contains(gearCodesBase, fishingGearDCF.getCode())) { + List<DCF5Code> usages = fishingGearDCFDAO.findUsages(DCF5Code.class, fishingGearDCF); + if (usages.isEmpty()) { + log.info("will delete code " + fishingGearDCF); + fishingGearDCFDAO.delete(fishingGearDCF); + } else { + log.warn("will not delete " + fishingGearDCF); + SampleRowDAO sampleRowDAO = WaoDAOHelper.getSampleRowDAO(transaction); + for (DCF5Code usage : usages) { + List<SampleRow> sampleRows = sampleRowDAO.findAllContainsdCF5Code(usage); + for (SampleRow sampleRow : sampleRows) { + log.warn("sampleRow " + sampleRow.getCode() + " use " + usage); + } + } + } + } + } + + for (TargetSpeciesDCF targetSpeciesDCF : targetSpeciesDCFDAO.findAll()) { + if ( ! ArrayUtils.contains(speciesCodesBase, targetSpeciesDCF.getCode())) { + List<DCF5Code> usages = targetSpeciesDCFDAO.findUsages(DCF5Code.class, targetSpeciesDCF); + if (usages.isEmpty()) { + log.info("will delete code " + targetSpeciesDCF); + targetSpeciesDCFDAO.delete(targetSpeciesDCF); + } else { + log.warn("will not delete " + targetSpeciesDCF); + } + } + } } transaction.commitTransaction(); Modified: trunk/wao-business/src/main/resources/i18n/wao-business_en_GB.properties =================================================================== --- trunk/wao-business/src/main/resources/i18n/wao-business_en_GB.properties 2012-03-15 15:22:28 UTC (rev 1566) +++ trunk/wao-business/src/main/resources/i18n/wao-business_en_GB.properties 2012-03-16 15:53:26 UTC (rev 1567) @@ -125,6 +125,7 @@ fr.ifremer.wao.entity.ObsDebCode=ObsDeb codes fr.ifremer.wao.entity.TargetSpeciesDCF.=Not specified fr.ifremer.wao.entity.TargetSpeciesDCF.ALG=Algae +fr.ifremer.wao.entity.TargetSpeciesDCF.ANA=Espèces anadromes fr.ifremer.wao.entity.TargetSpeciesDCF.CAT=Catadromous species fr.ifremer.wao.entity.TargetSpeciesDCF.CRU=Crustacean fr.ifremer.wao.entity.TargetSpeciesDCF.CRW=Langouste Modified: trunk/wao-business/src/main/resources/i18n/wao-business_fr_FR.properties =================================================================== --- trunk/wao-business/src/main/resources/i18n/wao-business_fr_FR.properties 2012-03-15 15:22:28 UTC (rev 1566) +++ trunk/wao-business/src/main/resources/i18n/wao-business_fr_FR.properties 2012-03-16 15:53:26 UTC (rev 1567) @@ -85,8 +85,8 @@ fr.ifremer.wao.entity.FishingGearDCF.HMP=Pompes fr.ifremer.wao.entity.FishingGearDCF.HMX=Engins de récolte (non spécifiés) fr.ifremer.wao.entity.FishingGearDCF.LA=Filets tournants sans coulisse (filet lamparo) -fr.ifremer.wao.entity.FishingGearDCF.LHM=Lignes à main et lignes avec cannes -fr.ifremer.wao.entity.FishingGearDCF.LHP=Lignes à main et lignes à cannes +fr.ifremer.wao.entity.FishingGearDCF.LHM=Lignes à main et lignes avec cannes (mécanisées) +fr.ifremer.wao.entity.FishingGearDCF.LHP=Lignes à main et lignes à cannes (manœuvrées à la main) fr.ifremer.wao.entity.FishingGearDCF.LL=Palangres (non spécifiées) fr.ifremer.wao.entity.FishingGearDCF.LLD=Palangres dérivantes fr.ifremer.wao.entity.FishingGearDCF.LLS=Palangres calées ou semi-flottantes @@ -120,12 +120,13 @@ fr.ifremer.wao.entity.FishingGearDCF.TBN=Chalut à langoustines fr.ifremer.wao.entity.FishingGearDCF.TBS=Chalut à crevettes fr.ifremer.wao.entity.FishingGearDCF.TM=Chalut pélagique (non spécifié) -fr.ifremer.wao.entity.FishingGearDCF.TMS=Chalut à crevettes +fr.ifremer.wao.entity.FishingGearDCF.TMS=Chalut pélagique à crevettes fr.ifremer.wao.entity.FishingGearDCF.TX=Autre chalut (non spécifié) fr.ifremer.wao.entity.FishingZone=Zones de pêche fr.ifremer.wao.entity.ObsDebCode=Codes métiers ObsDeb fr.ifremer.wao.entity.TargetSpeciesDCF.=Non spécifié fr.ifremer.wao.entity.TargetSpeciesDCF.ALG=Algues +fr.ifremer.wao.entity.TargetSpeciesDCF.ANA=Espèces anadromes fr.ifremer.wao.entity.TargetSpeciesDCF.CAT=Espèces catadromes fr.ifremer.wao.entity.TargetSpeciesDCF.CRU=Crustacés fr.ifremer.wao.entity.TargetSpeciesDCF.CRW=Langouste

1 0

r1566 - in trunk/wao-ui/src/main: java/fr/ifremer/wao/ui/pages webapp webapp/css
by bleny＠users.forge.codelutin.com March 15, 2012

March 15, 2012

Author: bleny Date: 2012-03-15 16:22:28 +0100 (Thu, 15 Mar 2012) New Revision: 1566 Url: http://forge.codelutin.com/repositories/revision/wao/1566 Log: Evolution #665 Ajouter une contrainte de filtrage des informations par navire pour le professionnel - champs sous la forme d'une liste d'immatriculation Modified: trunk/wao-ui/src/main/java/fr/ifremer/wao/ui/pages/Administration.java trunk/wao-ui/src/main/webapp/Administration.tml trunk/wao-ui/src/main/webapp/css/administration.css Modified: trunk/wao-ui/src/main/java/fr/ifremer/wao/ui/pages/Administration.java =================================================================== --- trunk/wao-ui/src/main/java/fr/ifremer/wao/ui/pages/Administration.java 2012-03-14 11:21:22 UTC (rev 1565) +++ trunk/wao-ui/src/main/java/fr/ifremer/wao/ui/pages/Administration.java 2012-03-15 15:22:28 UTC (rev 1566) @@ -83,6 +83,7 @@ import java.io.InputStream; import java.text.DateFormat; import java.text.SimpleDateFormat; +import java.util.LinkedList; import java.util.List; /** @@ -455,6 +456,7 @@ // reset : if user change, its profiles change editedUserProfiles = null; editedProfile = null; + editedUserCanReadBoats = null; if (log.isDebugEnabled()) { log.debug("'User id : " + userId); @@ -533,6 +535,19 @@ void onValidateFormFromUserForm() { userForm.clearErrors(); + if (editedUserCanReadBoats != null) { + getUserEdited().clearCanReadBoats(); + if (StringUtils.isNotBlank(editedUserCanReadBoats)) { + try { + List<Boat> boatsByImmatriculations = + serviceBoat.getBoatsByImmatriculations(editedUserCanReadBoats); + getUserEdited().addAllCanReadBoats(boatsByImmatriculations); + } catch (WaoBusinessException e) { + userForm.recordError("Vous devez préciser une liste d'immatriculations de navire séparées par des espaces"); + } + } + } + getUserEdited().clearUserProfile(currentUser.getProfile().getObsProgram()); getUserEdited().addAllUserProfile(getEditedUserProfiles()); } @@ -579,6 +594,9 @@ private List<UserProfile> editedUserProfiles; @Persist + private String editedUserCanReadBoats; + + @Persist @Property private UserProfile profile; @@ -654,6 +672,23 @@ return editedUserProfiles; } + public String getEditedUserCanReadBoats() { + if (editedUserCanReadBoats == null) { + if (getUserEdited() != null) { + List<String> boatImmatriculations = new LinkedList<String>(); + for (Boat boat : getUserEdited().getCanReadBoats()) { + boatImmatriculations.add(String.valueOf(boat.getImmatriculation())); + } + editedUserCanReadBoats = StringUtils.join(boatImmatriculations, " "); + } + } + return editedUserCanReadBoats; + } + + public void setEditedUserCanReadBoats(String editedUserCanReadBoats) { + this.editedUserCanReadBoats = editedUserCanReadBoats; + } + @Log Zone onActionFromAddRole() { Modified: trunk/wao-ui/src/main/webapp/Administration.tml =================================================================== --- trunk/wao-ui/src/main/webapp/Administration.tml 2012-03-14 11:21:22 UTC (rev 1565) +++ trunk/wao-ui/src/main/webapp/Administration.tml 2012-03-15 15:22:28 UTC (rev 1566) @@ -149,14 +149,8 @@ </p:mammalsNotifications> <p:canReadBoats> <t:if t:test="currentUser.admin"> - <label t:for="canReadBoats">${message:wao.ui.field.WaoUser.canReadBoats}</label> - <t:topiaEntitySelector t:id="canReadBoats" - t:multiple="true" - t:clazzName="Boat" - t:labelPropertyName="description" - t:values="boats" - t:selectedValues="userEdited.canReadBoats" - size="6"/> + <label t:for="editedUserCanReadBoats">${message:wao.ui.field.WaoUser.canReadBoats}</label> + <input t:type="textarea" t:id="editedUserCanReadBoats" value="editedUserCanReadBoats" /> </t:if> </p:canReadBoats> </t:beaneditform> Modified: trunk/wao-ui/src/main/webapp/css/administration.css =================================================================== --- trunk/wao-ui/src/main/webapp/css/administration.css 2012-03-14 11:21:22 UTC (rev 1565) +++ trunk/wao-ui/src/main/webapp/css/administration.css 2012-03-15 15:22:28 UTC (rev 1566) @@ -51,10 +51,15 @@ padding-left: 5px; } -div#so-admin fieldset.user-form div.t-beaneditor input { +div#so-admin fieldset.user-form div.t-beaneditor input, +div#so-admin fieldset.user-form div.t-beaneditor textarea { width: 350px; } +div#so-admin fieldset.user-form div.t-beaneditor textarea { + height: 200px; +} + fieldset.user-form div.t-beaneditor input.t-beaneditor-submit { background: url(../img/save.png) no-repeat center right !important; }

1 0

r1565 - trunk/wao-ui/src/main/webapp
by bleny＠users.forge.codelutin.com March 14, 2012

March 14, 2012

Author: bleny Date: 2012-03-14 12:21:22 +0100 (Wed, 14 Mar 2012) New Revision: 1565 Url: http://forge.codelutin.com/repositories/revision/wao/1565 Log: augmentation de la hauteur de la popup ?\195?\160 la connexion Modified: trunk/wao-ui/src/main/webapp/Connexion.tml Modified: trunk/wao-ui/src/main/webapp/Connexion.tml =================================================================== --- trunk/wao-ui/src/main/webapp/Connexion.tml 2012-03-14 09:56:55 UTC (rev 1564) +++ trunk/wao-ui/src/main/webapp/Connexion.tml 2012-03-14 11:21:22 UTC (rev 1565) @@ -68,7 +68,7 @@ </div> <div t:type="minimalWindow" t:id="roleWindow" t:show="${showRoleWindow}" t:modal="true" - t:center="false" t:top="70" t:width="500" t:height="400" + t:center="false" t:top="70" t:width="500" t:height="450" t:title="${message:wao.ui.message.chooseProfile}"> <form t:id="roleForm" t:type="form" action="tapestry"> <t:if test="askForAcceptCgu">

1 0

r1564 - trunk/wao-business/src/main/java/fr/ifremer/wao/entity
by bleny＠users.forge.codelutin.com March 14, 2012

March 14, 2012

Author: bleny Date: 2012-03-14 10:56:55 +0100 (Wed, 14 Mar 2012) New Revision: 1564 Url: http://forge.codelutin.com/repositories/revision/wao/1564 Log: Anomalie #980 Temps d'ouverture de la page navires Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/entity/BoatDAOImpl.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/entity/BoatDAOImpl.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/entity/BoatDAOImpl.java 2012-03-13 14:50:58 UTC (rev 1563) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/entity/BoatDAOImpl.java 2012-03-14 09:56:55 UTC (rev 1564) @@ -108,7 +108,8 @@ sampleRowDAO.toTopiaQuery(filter.getSamplingFilter()); samplingFilterQuery.setSelect("SR.topiaId"); query.addDistinct() - .addLeftJoin(boatProperty.elligibleBoat(), "EB", true) + // On ne fetch pas ici car on fetch déjà quand nécessaire + .addLeftJoin(boatProperty.elligibleBoat(), "EB", false) .addSubQuery( "EB." + ElligibleBoat.PROPERTY_SAMPLE_ROW + "." + SampleRow.TOPIA_ID + " IN (?)", samplingFilterQuery); @@ -183,21 +184,25 @@ boatProperty.fleet(), boatProperty.district()); + WaoQueryHelper.ElligibleBoatProperty elligibleBoatProperty = WaoQueryHelper.newElligibleBoatProperty("ER"); + + query.addLeftJoin(boatProperty.elligibleBoat(), "ER", true); + query.addLeftJoin(elligibleBoatProperty.sampleRow(), "SR", true); + // load data for sample row: company, fishingZone, DCF5Code, profession - WaoQueryHelper.SampleRowProperty sampleRowProperty = - WaoQueryHelper.newSampleRowProperty(); -// query.addFetch( // XXX 20110524 bleny fetching those two data raise a - // 'cannot simultaneously fetch multiple bags' - // exception. Not fetching works but data will be lazily - // loaded and it costs performance in - // BoatFilterValues#fillBoats() - // - // sampleRowProperty.fishingZone(), - // sampleRowProperty.dCF5Code(), -// sampleRowProperty.company(), -// sampleRowProperty.profession()); + WaoQueryHelper.SampleRowProperty sampleRowProperty = elligibleBoatProperty.sampleRowProperty(); + query.addFetch( // XXX 20110524 bleny fetching those two data raise a + // 'cannot simultaneously fetch multiple bags' + // exception. Not fetching works but data will be lazily + // loaded and it costs performance in + // BoatFilterValues#fillBoats() + // elligibleBoatProperty.sampleRowProperty().fishingZone(), + // elligibleBoatProperty.sampleRowProperty().dCF5Code(), + sampleRowProperty.company(), + sampleRowProperty.profession()); + if (log.isDebugEnabled()) { log.debug("query to get boats by filter : " + query); }

1 0

r1563 - trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures
by bleny＠users.forge.codelutin.com March 13, 2012

March 13, 2012

Author: bleny Date: 2012-03-13 15:50:58 +0100 (Tue, 13 Mar 2012) New Revision: 1563 Url: http://forge.codelutin.com/repositories/revision/wao/1563 Log: correction test suite ?\195?\160 changement des r?\195?\168gles de validation contact Modified: trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures/ObsMerFixtures.java Modified: trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures/ObsMerFixtures.java =================================================================== --- trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures/ObsMerFixtures.java 2012-03-13 14:31:25 UTC (rev 1562) +++ trunk/wao-business/src/test/java/fr/ifremer/wao/business/fixtures/ObsMerFixtures.java 2012-03-13 14:50:58 UTC (rev 1563) @@ -215,6 +215,7 @@ contact5.setMainObserver(user2); contact5.setSampleRow(row2); contact5.setContactState(ContactState.OBSERVATION_CANCELLED); + contact5.setComment("commentaire obligatoire"); begin = DateUtil.createDate(3, 5, 2010); end = DateUtil.createDate(4, 5, 2010); contact5.setObservationEndDate(end); @@ -227,6 +228,7 @@ contact6.setMainObserver(user2); contact6.setSampleRow(row2); contact6.setContactState(ContactState.OBSERVATION_CANCELLED); + contact6.setComment("commentaire obligatoire"); begin = DateUtil.createDate(3, 3, 2010); contact6.setCreationDate(begin); end = DateUtil.createDate(4, 3, 2010);

1 0