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>.