This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository observe. See http://git.codelutin.com/observe.git commit 8890409a7d230f9fdfef8ed6a13f280cdf501137 Author: Tony CHEMIT <chemit@codelutin.com> Date: Fri May 22 20:23:25 2015 +0200 ajout du rapport (refs #7137) --- .../src/main/filters/observe-reports.properties | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) diff --git a/observe-business/src/main/filters/observe-reports.properties b/observe-business/src/main/filters/observe-reports.properties index e313a53..d59869a 100644 --- a/observe-business/src/main/filters/observe-reports.properties +++ b/observe-business/src/main/filters/observe-reports.properties @@ -1399,3 +1399,44 @@ report.accessoryCatchByGroup.request.11=10,0|row|\ 'fr.ird.observe.entities.referentiel.seine.SpeciesFate#1239832683621#0.6728026426066158' \ ) report.accessoryCatchByGroup.request.11.repeat=speciesId|column + +########################################################### +## Distribution des tailles par esp\u00e8ce non cibl\u00e8s +########################################################### + +report.nonTargetDistributionLengths.name= Distribution des tailles par esp\u00e8ce non cibles +report.nonTargetDistributionLengths.description=Afficher la nombre d'individus mesur\u00e9s par classe de taille pour les esp\u00e8ces non cibl\u00e9es +report.nonTargetDistributionLengths.columns=Classe de taille,Effectif +report.nonTargetDistributionLengths.variable.speciesId=fr.ird.observe.entities.referentiel.Species|Select s From SpeciesListImpl sl, SpeciesImpl s Where sl.id = 'fr.ird.observe.entities.referentiel.SpeciesList#1239832675370#0.2' And s in elements(sl.species) Order By s.code +report.nonTargetDistributionLengths.repeatVariable.length=java.lang.Float|\ +Select distinct ntl.length \ +From SetSeineImpl s, NonTargetSampleImpl nts, NonTargetLengthImpl ntl \ + Where \ + s in ( \ + Select distinct a.setSeine From TripSeineImpl m, RouteImpl r, ActivitySeineImpl a \ + Where m.id = :tripId \ + and r in elements(m.route) \ + and a in elements(r.activitySeine) \ + and a.setSeine is not null \ + ) \ + and nts in elements(s.nonTargetSample) \ + and ntl in elements(nts.nonTargetLength) \ + and ntl.species.id = :speciesId + +report.nonTargetDistributionLengths.request.1=0,0|row| \ +Select ntl.length, sum(ntl.count) \ +From SetSeineImpl s, NonTargetSampleImpl nts, NonTargetLengthImpl ntl \ + Where \ + s in ( \ + Select distinct a.setSeine From TripSeineImpl m, RouteImpl r, ActivitySeineImpl a \ + Where m.id = :tripId \ + and r in elements(m.route) \ + and a in elements(r.activitySeine) \ + and a.setSeine is not null \ + ) \ + and nts in elements(s.nonTargetSample) \ + and ntl in elements(nts.nonTargetLength) \ + and ntl.species.id = :speciesId \ + and ntl.length = :length \ +Group By ntl.length +report.nonTargetDistributionLengths.request.1.repeat=length|column \ No newline at end of file -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.