# HG changeset patch
# User Bjoern Ricks <bjoern.ricks@intevation.de>
# Date 1347445706 0
# Node ID 42db09d101f3265f71fcd9641c1f92ff68a64eca
# Parent  8f232119011ef2dee4573025a7524320491650e0
Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values


flys-backend/trunk@5437 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 8f232119011e -r 42db09d101f3 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Tue Sep 11 13:55:08 2012 +0000
+++ b/flys-backend/ChangeLog	Wed Sep 12 10:28:26 2012 +0000
@@ -1,3 +1,9 @@
+2012-09-12	Björn Ricks <bjoern.ricks@intevation.de>
+
+	* src/main/java/de/intevation/flys/model/River.java:
+	  Add new method determineMinMaxQ to fetch the mimimum and maximum q values
+	  from the database.
+
 2012-09-10	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* postgresql-minfo.sql: Added missing tables.
diff -r 8f232119011e -r 42db09d101f3 flys-backend/src/main/java/de/intevation/flys/model/River.java
--- a/flys-backend/src/main/java/de/intevation/flys/model/River.java	Tue Sep 11 13:55:08 2012 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/River.java	Wed Sep 12 10:28:26 2012 +0000
@@ -220,6 +220,33 @@
         return gauges.isEmpty() ? null : gauges.get(0);
     }
 
+    public double[] determineMinMaxQ() {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+        "select min(wqr.q) as min, max(wqr.q) as max from Wst w " +
+            "join WstColumns as wc " +
+            "join WstColumnQRange as wcqr " +
+            "join WstQRange as wqr " +
+            "where w.kind = 0 and river_id = :river_id");
+
+        query.setParameter("river", getId());
+
+        double minmax[] = new double[] { Double.MAX_VALUE, Double.MIN_VALUE };
+
+        List<Object> results = query.list();
+
+        if (!results.isEmpty()) {
+            Object[] arr = (Object[]) results.get(0);
+            BigDecimal minq = (BigDecimal)arr[0];
+            BigDecimal maxq = (BigDecimal)arr[1];
+            minmax[0] = minq.doubleValue();
+            minmax[1] = maxq.doubleValue();
+        }
+
+        return minmax;
+    }
+
 
     /**
      * This method returns the first gauge that is intersected by <i>a</i> and