branch develop updated (f5c16c9 -> 066334f)
This is an automated email from the git hooks/post-receive script. New change to branch develop in repository observe. See http://git.codelutin.com/observe.git from f5c16c9 correction des requetes (refs #7138) new bcd0132 ajout de la requete (refs #7134) new 066334f fixes #7134: [PS] Orthongel - Nouvelle requête Répartition des calées par cuve Merge branch 'feature/7134' into develop The 2 revisions listed above as "new" are entirely new to this repository and will be described in separate emails. The revisions listed as "adds" were already present in the repository and have only been added to this reference. Detailed log of new commits: commit 066334f5c6e4229c58b8661b478a567a01098a4b Merge: f5c16c9 bcd0132 Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat May 23 13:54:01 2015 +0200 fixes #7134: [PS] Orthongel - Nouvelle requête Répartition des calées par cuve Merge branch 'feature/7134' into develop commit bcd01324a6245529558d25bad81c687d9a671477 Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat May 23 13:53:58 2015 +0200 ajout de la requete (refs #7134) Summary of changes: .../src/main/filters/observe-reports.properties | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.
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 bcd01324a6245529558d25bad81c687d9a671477 Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat May 23 13:53:58 2015 +0200 ajout de la requete (refs #7134) --- .../src/main/filters/observe-reports.properties | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) diff --git a/observe-business/src/main/filters/observe-reports.properties b/observe-business/src/main/filters/observe-reports.properties index 936b1f0..6eac42b 100644 --- a/observe-business/src/main/filters/observe-reports.properties +++ b/observe-business/src/main/filters/observe-reports.properties @@ -1488,3 +1488,26 @@ Where t.id = :tripId \ And tl.measureType = 2 \ Group By tl.length \ Order By tl.length + +############################################ +## R\u00e9partition des cal\u00e9es par cuve +############################################ + +report.repartionCaleeParCuve.name=R\u00e9partition des cal\u00e9es par cuve +report.repartionCaleeParCuve.description=R\u00e9partition des cal\u00e9es par cuves, type de banc et esp\u00e8ce +report.repartionCaleeParCuve.columns=Jour - Heure observation,Latitude,Longitude,Type de banc,Esp\u00e8ce,Tonnage,Cuve +report.repartionCaleeParCuve.request.1=0,0|row| \ +Select concat(day(r.date), '/', month(r.date), '/', year(r.date), ' ', hour(a.time), ':', minute(a.time)), \ + a.latitude, \ + a.longitude, \ + case when a.setSeine.schoolType = 1 then 'BO' else 'BL' end, \ + tc.weightCategory.species.faoCode, \ + Sum(tc.catchWeight), \ + tc.well \ +From TripSeineImpl t \ +Join t.route r \ +Join r.activitySeine a \ +Join a.setSeine.targetCatch tc \ +Where t.id = :tripId \ +Group By r.date, a.time, a.latitude, a.longitude, tc.weightCategory.species, tc.well \ +Order By r.date, a.time, tc.weightCategory.species, tc.well -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.
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 066334f5c6e4229c58b8661b478a567a01098a4b Merge: f5c16c9 bcd0132 Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat May 23 13:54:01 2015 +0200 fixes #7134: [PS] Orthongel - Nouvelle requête Répartition des calées par cuve Merge branch 'feature/7134' into develop .../src/main/filters/observe-reports.properties | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@list.forge.codelutin.com>.
participants (1)
-
codelutin.com scm