dive4elements/river: flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/FixingsOverview.java annotate

annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/FixingsOverview.java @ 2564:3f038d54bc87

FixingsOverviewService: Made the filter mechanisms available via the incoming XML document. flys-artifacts/trunk@4090 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Mon, 20 Feb 2012 19:13:19 +0000
parents	59c920e73d8a
children	72f77b2210c2

rev	line source
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 package de.intevation.flys.artifacts.model;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 import java.io.Serializable;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	4
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	5 import java.text.SimpleDateFormat;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	7 import java.util.ArrayList;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8 import java.util.Collections;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 import java.util.Comparator;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10 import java.util.Date;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11 import java.util.HashMap;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12 import java.util.List;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13 import java.util.Map;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	14
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15 import org.apache.log4j.Logger;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17 import org.hibernate.SQLQuery;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 import org.hibernate.Session;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 import org.hibernate.type.StandardBasicTypes;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22 import org.w3c.dom.Document;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 import org.w3c.dom.Element;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 public class FixingsOverview
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 implements Serializable
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27 {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 private static Logger log = Logger.getLogger(FixingsOverview.class);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 public static final double EPSILON = 1e-5;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	31 public static final double EPSILON2 = 1e-1;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32
2564 3f038d54bc87 FixingsOverviewService: Made the filter mechanisms available via the incoming XML document. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2563 diff changeset	33 public static final String DATE_FORMAT = "dd.MM.yyyy HH:mm";
3f038d54bc87 FixingsOverviewService: Made the filter mechanisms available via the incoming XML document. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2563 diff changeset	34
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	35 public static final String SQL_RIVER_ID =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	37 " id AS river_id," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 " km_up " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 "FROM rivers " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 " name = :name";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 public static final String SQL_RIVER_EXTENT =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 " MIN(wcv.position) AS start_km," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 " MAX(wcv.position) AS end_km " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	47 "FROM wst_column_values wcv" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	48 " JOIN wst_columns wc ON wcv.wst_column_id = wc.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	49 " JOIN wsts w ON wc.wst_id = w.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	50 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 " w.kind = 0 AND w.river_id = :river_id";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53 public static final String SQL_GAUGES =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	54 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 " g.id AS gauge_id," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56 " r.a AS a," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57 " r.b AS b " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 "FROM gauges g" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59 " JOIN ranges r ON g.range_id = r.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	60 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 " g.river_id = :river_id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 "ORDER BY r.a";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 public static final String SQL_DISCHARGE_SECTORS =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 " g.id AS gauge_id," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	67 " nmv.name AS name," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68 " CAST(mv.value AS NUMERIC(38,2)) AS value " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	69 "FROM gauges g" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	70 " JOIN main_values mv ON g.id = mv.gauge_id" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 " JOIN named_main_values nmv ON nmv.id = mv.named_value_id" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 " JOIN main_value_types mvt ON nmv.type_id = mvt.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 " mvt.name = 'Q' AND (" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 " nmv.name = 'MNQ' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 " nmv.name LIKE 'MNQ(%' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 " nmv.name = 'MQ' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78 " nmv.name LIKE 'MQ(%' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 " nmv.name = 'MHQ' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80 " nmv.name LIKE 'MHQ(%' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 " nmv.name = 'HQ5' OR" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 " nmv.name LIKE 'HQ5(%') AND" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 " g.river_id = :river_id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 "ORDER BY" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85 " g.id";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87 public static final String SQL_FIXINGS =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 " id AS wst_id," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90 " description " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91 "FROM wsts " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 " river_id = :river_id AND kind = 2";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 public static final String SQL_FIXING_COLUMNS =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 " wc.id AS wst_column_id," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 " ti.start_time AS start_time," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 " wc.name AS name " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 "FROM wst_columns wc" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 " JOIN time_intervals ti ON wc.time_interval_id = ti.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 " wc.wst_id = :wst_id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 "ORDER BY position";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 public static final String SQL_FIXING_COLUMN_Q_RANGES =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 " wqr.q AS q," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 " r.a AS start_km," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 " r.b AS stop_km " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 "FROM wst_column_q_ranges wcqr" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 " JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 " JOIN ranges r ON wqr.range_id = r.id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 "WHERE" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	115 " wcqr.wst_column_id = :column_id " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 "ORDER BY r.a";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 public static final String SQL_FIXING_COLUMN_KM_RANGE =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119 "SELECT" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120 " MIN(position) AS start_km," +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 " MAX(position) AS stop_km " +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122 "FROM" +
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 " wst_column_values " +
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	124 "WHERE" +
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125 " wst_column_id = :column_id";
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127 public static class Range implements Serializable {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 protected double start;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 protected double end;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132 public Range() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	134
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135 public Range(double start, double end) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	136 this.start = start;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137 this.end = end;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	140 public double getStart() {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	141 return start;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	142 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	143
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	144 public double getEnd() {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	145 return end;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	146 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	147
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148 public boolean disjoint(Range other) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	149 return start > other.end \|\| other.start > end;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	150 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	151
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	152 public boolean intersects(Range other) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	153 return !disjoint(other);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	154 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	155
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	156 public boolean clip(Range other) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	157 if (disjoint(other)) return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 if (other.start > start) start = other.start;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160 if (other.end < end ) end = other.end;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	161
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	162 return true;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	163 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	164
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	165 public boolean inside(double x) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	166 return x > start-EPSILON && x < end+EPSILON;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	167 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	168 } // class Range
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	169
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	170 public static class GaugeRange extends Range {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	171
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	172 private static final class Sector implements Serializable {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	173
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	174 int sector;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	175 double value;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	176
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	177 Sector(int sector, double value) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	178 this.sector = sector;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	179 this.value = value;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	180 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	181
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	182 } // class Sector
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 protected int gaugeId;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	185
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	186 protected Map<String, Double> mainValues;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 protected List<Sector> sectors;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	188
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	189 public GaugeRange() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	190 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	191
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	192 public GaugeRange(double start, double end, int gaugeId) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	193 super(start, end);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	194 this.gaugeId = gaugeId;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	195 mainValues = new HashMap<String, Double>();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	196 sectors = new ArrayList<Sector>(3);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	197 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	198
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	199 public void addMainValue(String label, Double value) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	200 int idx = label.indexOf('(');
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	201 if (idx >= 0) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	202 label = label.substring(0, idx);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	203 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	204 mainValues.put(label, value);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	207 protected Double getMainValue(String label) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	208 Double v = mainValues.get(label);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	209 if (v == null) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	210 log.warn("Missing main value '"
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	211 + label + "' for gauge " + gaugeId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	212 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	213 return v;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	214 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	215
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 public void buildClasses() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	217 Double mnq = getMainValue("MNQ");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	218 Double mq = getMainValue("MQ");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	219 Double mhq = getMainValue("MHQ");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	220 Double hq5 = getMainValue("HQ5");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	221
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	222 Double [][] pairs = {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	223 { mnq, mq },
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	224 { mq, mhq },
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	225 { hq5, hq5 } };
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	226
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	227 for (int c = 0; c < pairs.length; ++c) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	228 Double [] pair = pairs[c];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	229 if (pair[0] != null && pair[1] != null) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	230 double value = 0.5*(pair[0] + pair[1]);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	231 sectors.add(new Sector(c, value));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	232 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	233 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	234 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	235
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	236 public int classify(double value) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	237 for (Sector sector: sectors) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	238 if (value < sector.value) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	239 return sector.sector;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	240 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	241 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	242 return sectors.size();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	243 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	244 } // class GaugeRange
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	245
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	246 public static class GaugeFinder {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	247
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	248 protected List<GaugeRange> gauges;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	249 protected boolean isKmUp;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	250
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	251 public GaugeFinder(List<GaugeRange> gauges) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	252 this(gauges, true);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	253 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	254
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	255 public GaugeFinder(
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	256 List<GaugeRange> gauges,
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	257 boolean isKmUp
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	258 ) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	259 this.gauges = gauges;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	260 this.isKmUp = isKmUp;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	261 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	262
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	263 public boolean getIsKmUp() {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	264 return isKmUp;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	265 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	266
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	267 public void setIsKmUp(boolean isKmUp) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	268 this.isKmUp = isKmUp;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	269 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	270
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	271 public GaugeRange find(Range range) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	272 double km = isKmUp ? range.start : range.end;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	273 for (GaugeRange gauge: gauges) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	274 if (gauge.inside(km)) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	275 return gauge;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	276 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	277 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	278 return null;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	279 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	280
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	281 public GaugeRange find(int gaugeId) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	282 for (GaugeRange gauge: gauges) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	283 if (gauge.gaugeId == gaugeId) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	284 return gauge;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	285 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	286 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	287 return null;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	288 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	289
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	290 public boolean loadDischargeSectors(Session session, int riverId) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	291
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	292 SQLQuery query = session.createSQLQuery(SQL_DISCHARGE_SECTORS)
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	293 .addScalar("gauge_id", StandardBasicTypes.INTEGER)
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	294 .addScalar("name", StandardBasicTypes.STRING)
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	295 .addScalar("value", StandardBasicTypes.DOUBLE);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	296
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	297 query.setInteger("river_id", riverId);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	298
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	299 List<Object []> list = query.list();
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	300
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	301 if (list.isEmpty()) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	302 log.warn("River " + riverId + " has no discharge sectors.");
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	303 return false;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	304 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	305
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	306 GaugeRange gauge = null;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	307
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	308 for (Object [] row: list) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	309 int gaugeId = (Integer)row[0];
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	310 String label = (String) row[1];
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	311 Double value = (Double) row[2];
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	312
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	313 if (gauge == null \|\| gauge.gaugeId != gaugeId) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	314 if ((gauge = find(gaugeId)) == null) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	315 log.warn("Cannot find gauge for id " + gaugeId + ".");
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	316 continue;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	317 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	318 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	319
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	320 gauge.addMainValue(label, value);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	321 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	322
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	323 for (GaugeRange g: gauges) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	324 g.buildClasses();
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	325 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	326
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	327 return true;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	328 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	329 } // class GaugeFinder
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	330
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	331 public static class QRange extends Range {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	332
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	333 protected double q;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	334
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	335 public QRange() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	336 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	337
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	338 public QRange(double start, double end, double q) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	339 super(start, end);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	340 this.q = q;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	341 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	342 } // class QRange
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	343
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	344 public static class SectorRange extends Range {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	345
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	346 protected int sector;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	347
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	348 public SectorRange() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	349 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	350
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	351 public SectorRange(SectorRange other) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	352 start = other.start;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	353 end = other.end;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	354 sector = other.sector;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	355 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	356
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	357 public SectorRange(double start, double end, int sector) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	358 super(start, end);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	359 this.sector = sector;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	360 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	361
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	362 public int getSector() {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	363 return sector;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	364 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	365
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	366 public boolean enlarge(SectorRange other) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	367 if (sector == other.sector
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	368 && Math.abs(end-other.start) < EPSILON2) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	369 end = other.end;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	370 return true;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	371 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	372 return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	373 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	374 } // class SectorRange
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	375
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	376 public static class Fixing implements Serializable {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	377
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	378 public static final Comparator<Column> DATE_CMP =
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	379 new Comparator<Column>() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	380 @Override
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	381 public int compare(Column a, Column b) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	382 return a.startTime.compareTo(b.startTime);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	383 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	384 };
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	385
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	386 public interface Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	387
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	388 boolean accept(Column column);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	389
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	390 } // interface Filter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	391
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	392 public class Column extends Range {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	393
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	394 protected int columnId;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	395 protected Date startTime;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	396 protected String name;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	397
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	398 protected List<SectorRange> sectors;
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	399
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	400 public Column() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	401 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	402
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	403 public Column(int columnId, Date startTime, String name) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	404 this.columnId = columnId;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	405 this.startTime = startTime;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	406 this.name = name;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	407
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	408 sectors = new ArrayList<SectorRange>();
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	409 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	410
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	411 public int getId() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	412 return columnId;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	413 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	414
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	415 public Fixing getFixing() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	416 return Fixing.this;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	417 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	418
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	419 public Date getStartTime() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	420 return startTime;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	421 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	422
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	423 public String getName() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	424 return name;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	425 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	426
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	427 public List<SectorRange> getSectors() {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	428 return sectors;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	429 }
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	430
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	431 public List<SectorRange> getSectors(Range range) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	432
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	433 List<SectorRange> result =
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	434 new ArrayList<SectorRange>(sectors.size());
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	435
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	436 for (SectorRange src: sectors) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	437 SectorRange dst = new SectorRange(src);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	438 if (dst.clip(range)) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	439 result.add(dst);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	440 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	441 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	442
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	443 return result;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	444 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	445
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	446 public void buildSectors(GaugeRange gauge, List<QRange> qRanges) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	447
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	448 for (QRange qRange: qRanges) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	449 SectorRange sector = new SectorRange(
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	450 qRange.start, qRange.end,
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	451 gauge.classify(qRange.q));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	452 if (sectors.isEmpty()
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	453 \|\| !sectors.get(sectors.size()-1).enlarge(sector)) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	454 sectors.add(sector);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	455 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	456 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	457 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	458
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	459 public void loadKmRange(SQLQuery query) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	460 query.setInteger("column_id", columnId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	461
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	462 List<Object []> kms = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	463
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	464 if (kms.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	465 log.warn("No km range for column " + columnId + ".");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	466 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	467 else {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	468 Object [] obj = kms.get(0);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	469 start = (Double)obj[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	470 end = (Double)obj[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	471 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	472 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	473
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	474 public void loadQRanges(
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	475 SQLQuery query,
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	476 GaugeFinder gaugeFinder
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	477 ) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	478 query.setInteger("column_id", columnId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	479 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	480
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	481 List<QRange> qRanges = new ArrayList<QRange>(list.size());
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	482
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	483 for (Object [] row: list) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	484 double q = (Double)row[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	485 double start = (Double)row[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	486 double end = (Double)row[2];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	487 QRange qRange = new QRange(start, end, q);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	488 if (qRange.clip(this)) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	489 qRanges.add(qRange);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	490 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	491 }
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	492
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	493 GaugeRange gauge = gaugeFinder.find(this);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	494
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	495 if (gauge != null) {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	496 buildSectors(gauge, qRanges);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	497 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	498 else {
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	499 log.warn("No gauge found for column " + columnId + ".");
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	500 }
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	501 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	502 } // class Column
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	503
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	504 protected int wstId;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	505 protected String description;
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	506 protected List<Column> columns;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	507
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	508 public Fixing() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	509 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	510
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	511 public int getId() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	512 return wstId;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	513 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	514
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	515 public String getDescription() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	516 return description;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	517 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	518
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	519 public Fixing(int wstId, String description) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	520 this.wstId = wstId;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	521 this.description = description;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	522 columns = new ArrayList<Column>();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	523 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	524
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	525 public void loadColumns(SQLQuery query) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	526 query.setInteger("wst_id", wstId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	527 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	528 for (Object [] row: list) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	529 int columnId = (Integer)row[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	530 Date startTime = (Date) row[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	531 String name = (String) row[2];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	532 columns.add(new Column(columnId, startTime, name));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	533 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	534 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	535
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	536 public void loadColumnsKmRange(SQLQuery query) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	537 for (Column column: columns) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	538 column.loadKmRange(query);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	539 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	540 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	541
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	542 public void loadColumnsQRanges(
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	543 SQLQuery query,
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	544 GaugeFinder gaugeFinder
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	545 ) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	546 for (Column column: columns) {
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	547 column.loadQRanges(query, gaugeFinder);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	548 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	549 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	550
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	551 public void addAllColumns(
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	552 List<Column> allColumns,
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	553 Range range,
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	554 Filter filter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	555 ) {
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	556 for (Column column: columns) {
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	557 if (column.intersects(range) && filter.accept(column)) {
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	558 allColumns.add(column);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	559 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	560 }
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	561 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	562 } // class Fixing
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	563
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	564
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	565 protected String riverName;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	566 protected int riverId;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	567 protected boolean isKmUp;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	568 protected List<Fixing> fixings;
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	569 protected Range extent;
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	570
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	571 public FixingsOverview() {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	572 fixings = new ArrayList<Fixing>();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	573 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	574
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	575 public FixingsOverview(String riverName) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	576 this();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	577 this.riverName = riverName;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	578 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	579
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	580 protected boolean loadRiver(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	581 SQLQuery query = session.createSQLQuery(SQL_RIVER_ID)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	582 .addScalar("river_id", StandardBasicTypes.INTEGER)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	583 .addScalar("km_up", StandardBasicTypes.BOOLEAN);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	584
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	585 query.setString("name", riverName);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	586
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	587 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	588
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	589 if (list.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	590 log.warn("No river '" + riverName + "' found.");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	591 return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	592 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	593
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	594 Object [] row = list.get(0);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	595
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	596 riverId = (Integer)row[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	597 isKmUp = (Boolean)row[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	598
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	599 return true;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	600 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	601
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	602 protected boolean loadRiverExtent(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	603 SQLQuery query = session.createSQLQuery(SQL_RIVER_EXTENT)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	604 .addScalar("start_km", StandardBasicTypes.DOUBLE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	605 .addScalar("end_km", StandardBasicTypes.DOUBLE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	606
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	607 query.setInteger("river_id", riverId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	608
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	609 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	610
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	611 if (list.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	612 log.warn("River " + riverId + " has no extent.");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	613 return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	614 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	615
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	616 Object [] row = list.get(0);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	617 extent = new Range((Double)row[0], (Double)row[1]);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	618
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	619 return true;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	620 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	621
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	622 protected GaugeFinder loadGauges(Session session) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	623 SQLQuery query = session.createSQLQuery(SQL_GAUGES)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	624 .addScalar("gauge_id", StandardBasicTypes.INTEGER)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	625 .addScalar("a", StandardBasicTypes.DOUBLE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	626 .addScalar("b", StandardBasicTypes.DOUBLE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	627
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	628 query.setInteger("river_id", riverId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	629
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	630 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	631
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	632 if (list.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	633 log.warn("River " + riverId + " has no gauges.");
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	634 return null;
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	635 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	636
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	637 List<GaugeRange> gauges = new ArrayList<GaugeRange>();
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	638
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	639 for (Object [] row: list) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	640 int gaugeId = (Integer)row[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	641 double start = (Double) row[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	642 double end = (Double) row[2];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	643 GaugeRange gauge = new GaugeRange(start, end, gaugeId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	644 gauges.add(gauge);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	645 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	646
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	647 return new GaugeFinder(gauges, isKmUp);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	648 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	649
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	650
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	651 protected void loadFixings(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	652 SQLQuery query = session.createSQLQuery(SQL_FIXINGS)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	653 .addScalar("wst_id", StandardBasicTypes.INTEGER)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	654 .addScalar("description", StandardBasicTypes.STRING);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	655
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	656 query.setInteger("river_id", riverId);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	657
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	658 List<Object []> list = query.list();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	659
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	660 if (list.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	661 log.warn("River " + riverId + " has no fixings.");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	662 // Its pretty fine to have no fixings.
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	663 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	664
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	665 for (Object [] row: list) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	666 int wstId = (Integer)row[0];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	667 String description = (String) row[1];
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	668 Fixing fixing = new Fixing(wstId, description);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	669 fixings.add(fixing);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	670 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	671 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	672
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	673 protected void loadFixingsColumns(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	674 SQLQuery query = session.createSQLQuery(SQL_FIXING_COLUMNS)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	675 .addScalar("wst_column_id", StandardBasicTypes.INTEGER)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	676 .addScalar("start_time", StandardBasicTypes.DATE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	677 .addScalar("name", StandardBasicTypes.STRING);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	678
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	679 for (Fixing fixing: fixings) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	680 fixing.loadColumns(query);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	681 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	682 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	683
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	684 protected void loadFixingsColumnsKmRange(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	685 SQLQuery query = session.createSQLQuery(SQL_FIXING_COLUMN_KM_RANGE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	686 .addScalar("start_km", StandardBasicTypes.DOUBLE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	687 .addScalar("stop_km", StandardBasicTypes.DOUBLE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	688
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	689 for (Fixing fixing: fixings) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	690 fixing.loadColumnsKmRange(query);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	691 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	692 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	693
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	694 protected void loadFixingsColumnsQRanges(
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	695 Session session,
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	696 GaugeFinder gaugeFinder
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	697 ) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	698 SQLQuery query = session.createSQLQuery(SQL_FIXING_COLUMN_Q_RANGES)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	699 .addScalar("q", StandardBasicTypes.DOUBLE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	700 .addScalar("start_km", StandardBasicTypes.DOUBLE)
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	701 .addScalar("stop_km", StandardBasicTypes.DOUBLE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	702
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	703 for (Fixing fixing: fixings) {
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	704 fixing.loadColumnsQRanges(query, gaugeFinder);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	705 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	706 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	707
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	708 public boolean load(Session session) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	709
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	710 if (!loadRiver(session)
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	711 \|\| !loadRiverExtent(session)) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	712 return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	713 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	714
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	715 GaugeFinder gaugeFinder = loadGauges(session);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	716
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	717 if (gaugeFinder == null
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	718 \|\| !gaugeFinder.loadDischargeSectors(session, riverId)) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	719 return false;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	720 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	721
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	722 loadFixings(session);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	723 loadFixingsColumns(session);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	724 loadFixingsColumnsKmRange(session);
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	725 loadFixingsColumnsQRanges(session, gaugeFinder);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	726
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	727 return true;
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	728 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	729
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	730 public static final Range FULL_EXTENT =
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	731 new Range(-Double.MAX_VALUE, Double.MAX_VALUE);
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	732
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	733 public static final Fixing.Filter ACCEPT = new Fixing.Filter() {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	734 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	735 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	736 return true;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	737 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	738 };
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	739
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	740 public static class NotFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	741 protected Fixing.Filter child;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	742
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	743 public NotFilter(Fixing.Filter child) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	744 this.child = child;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	745 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	746
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	747 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	748 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	749 return !child.accept(column);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	750 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	751 } // class NotFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	752
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	753 public static abstract class ComponentFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	754 protected List<Fixing.Filter> children;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	755
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	756 public ComponentFilter(List<Fixing.Filter> children) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	757 this.children = children;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	758 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	759 } // class ComponentFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	760
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	761 public static class OrFilter extends ComponentFilter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	762
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	763 public OrFilter(List<Fixing.Filter> children) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	764 super(children);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	765 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	766
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	767 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	768 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	769 for (Fixing.Filter child: children) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	770 if (child.accept(column)) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	771 return true;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	772 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	773 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	774 return false;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	775 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	776 } // class OrFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	777
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	778 public static class AndFilter extends ComponentFilter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	779
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	780 public AndFilter(List<Fixing.Filter> children) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	781 super(children);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	782 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	783
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	784 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	785 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	786 for (Fixing.Filter child: children) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	787 if (!child.accept(column)) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	788 return false;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	789 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	790 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	791 return true;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	792 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	793 } // class AndFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	794
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	795 public static class IdFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	796
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	797 protected int columnId;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	798
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	799 public IdFilter(int columnId) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	800 this.columnId = columnId;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	801 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	802
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	803 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	804 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	805 return column.getId() == columnId;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	806 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	807 } // class IdFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	808
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	809 public static class DateFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	810
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	811 protected Date date;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	812
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	813 public DateFilter(Date date) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	814 this.date = date;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	815 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	816
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	817 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	818 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	819 return date.equals(column.getStartTime());
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	820 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	821 } // class DateFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	822
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	823 public static class DateRangeFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	824
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	825 protected Date start;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	826 protected Date end;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	827
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	828 public DateRangeFilter(Date start, Date end) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	829 this.start = start;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	830 this.end = end;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	831 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	832
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	833 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	834 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	835 Date date = column.getStartTime();
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	836 return start.compareTo(date) <= 0 && end.compareTo(date) >= 0;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	837 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	838 } // class DateRangeFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	839
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	840 public static class SectorRangeFilter implements Fixing.Filter {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	841
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	842 protected int min;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	843 protected int max;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	844
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	845 public SectorRangeFilter(int min, int max) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	846 this.min = Math.min(min, max);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	847 this.max = Math.max(min, max);
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	848 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	849
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	850 @Override
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	851 public boolean accept(Fixing.Column column) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	852 for (SectorRange s: column.getSectors()) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	853 int v = s.getSector();
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	854 if (v >= min && v <= max) {
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	855 return true;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	856 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	857 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	858 return false;
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	859 }
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	860 } // class SectorRangeFilter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	861
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	862 public void generateOverview(Document document) {
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	863 generateOverview(document, FULL_EXTENT, ACCEPT);
2562 ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	864 }
ba35dfb7c09a FixingsOverview: Construct the Q sectors once. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2561 diff changeset	865
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	866 public void generateOverview(
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	867 Document document,
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	868 Range range,
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	869 Fixing.Filter filter
59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	870 ) {
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	871 List<Fixing.Column> allColumns = new ArrayList<Fixing.Column>();
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	872
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	873 for (Fixing fixing: fixings) {
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	874 fixing.addAllColumns(allColumns, range, filter);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	875 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	876
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	877 Collections.sort(allColumns, Fixing.DATE_CMP);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	878
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	879 Element fixingsElement = document.createElement("fixings");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	880
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	881 Element riverElement = document.createElement("river");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	882
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	883 riverElement.setAttribute("from", String.valueOf(extent.start));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	884 riverElement.setAttribute("to", String.valueOf(extent.end));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	885 riverElement.setAttribute("rid", String.valueOf(riverId));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	886
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	887 fixingsElement.appendChild(riverElement);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	888
2564 3f038d54bc87 FixingsOverviewService: Made the filter mechanisms available via the incoming XML document. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2563 diff changeset	889 SimpleDateFormat df = new SimpleDateFormat(DATE_FORMAT);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	890
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	891 Element esE = document.createElement("events");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	892
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	893 for (Fixing.Column column: allColumns) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	894
2563 59c920e73d8a FixingsOverview: Added a filter mechanism for generating output. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2562 diff changeset	895 List<SectorRange> sectors = column.getSectors(range);
2561 b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	896
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	897 if (!sectors.isEmpty()) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	898 Element eE = document.createElement("event");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	899 eE.setAttribute("name",
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	900 String.valueOf(column.getFixing().description));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	901 eE.setAttribute("cid", String.valueOf(column.columnId));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	902 eE.setAttribute("date", df.format(column.startTime));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	903
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	904 for (SectorRange sector: sectors) {
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	905 Element sE = document.createElement("sector");
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	906
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	907 sE.setAttribute("from", String.valueOf(sector.start));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	908 sE.setAttribute("to", String.valueOf(sector.end));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	909 sE.setAttribute("class", String.valueOf(sector.sector));
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	910
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	911 eE.appendChild(sE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	912 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	913
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	914 esE.appendChild(eE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	915 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	916 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	917
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	918 fixingsElement.appendChild(esE);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	919
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	920 document.appendChild(fixingsElement);
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	921 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	922 }
b3f6d49cdc80 Service to generate the data needed to build the "Fixerungen pro Fluss Uebersicht" Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	923 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/FixingsOverview.java @ 2564:3f038d54bc87