Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedloadOverview.java @ 8782:4289930e276c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
author Tom Gottfried <tom@intevation.de>
date Tue, 08 Dec 2015 16:03:30 +0100
parents 2e11fc7f5d35
children b251a6ad46bb
rev   line source
5863
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
2 * Software engineering by Intevation GmbH
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
3 *
5994
af13ceeba52a Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5863
diff changeset
4 * This file is Free Software under the GNU AGPL (>=v3)
5863
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5994
af13ceeba52a Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5863
diff changeset
6 * documentation coming with Dive4Elements River for details.
5863
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
7 */
4897a58c8746 River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
8
5831
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3914
diff changeset
9 package org.dive4elements.river.artifacts.model.minfo;
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
10
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
11 import java.io.Serializable;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
12 import java.text.SimpleDateFormat;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
13 import java.util.ArrayList;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
14 import java.util.Date;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
15 import java.util.List;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
16
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
17 import org.apache.log4j.Logger;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
18 import org.hibernate.SQLQuery;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
19 import org.hibernate.Session;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
20 import org.hibernate.type.StandardBasicTypes;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
21 import org.w3c.dom.Document;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
22 import org.w3c.dom.Element;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
23
5831
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3914
diff changeset
24 import org.dive4elements.river.utils.KMIndex;
8684
2e11fc7f5d35 (issue1796) Use seddb name of a river when accessing the seddb
Andre Heinecke <andre.heinecke@intevation.de>
parents: 5994
diff changeset
25 import org.dive4elements.river.artifacts.model.RiverFactory;
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
26
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
27 public class BedloadOverview implements Serializable {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
28
3778
35a6c9a49a76 Fixed wrong assigned loggers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3751
diff changeset
29 private static Logger log = Logger.getLogger(BedloadOverview.class);
35a6c9a49a76 Fixed wrong assigned loggers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3751
diff changeset
30
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
31 /**
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
32 * Serial version UId.
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
33 */
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
34 private static final long serialVersionUID = -7607668985959407096L;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
35
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
36 public interface Filter {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
37 boolean accept(KMIndex<List<Date>> entry);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
38
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
39 } // interface Filter
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
40
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
41
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
42 public static final Filter ACCEPT = new Filter() {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
43 public boolean accept(KMIndex<List<Date>> entry) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
44 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
45 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
46 };
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
47
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
48 public static class KmFilter implements Filter {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
49
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
50 protected double km;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
51
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
52 public KmFilter (double km) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
53 this.km = km;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
54 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
55 public boolean accept(KMIndex<List<Date>> list) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
56 for (KMIndex.Entry<List<Date>> e: list){
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
57 if (e.getKm() == km) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
58 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
59 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
60 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
61 return false;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
62 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
63 };
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
64
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
65 public static class DateFilter implements Filter {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
66
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
67 protected Date date;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
68
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
69 public DateFilter (Date date) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
70 this.date = date;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
71 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
72
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
73 public boolean accept(KMIndex<List<Date>> list) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
74 for (KMIndex.Entry<List<Date>> e: list){
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
75 if (e.getValue().equals(this.date)) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
76 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
77 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
78 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
79 return false;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
80 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
81 };
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
82
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
83 public static final double EPSILON = 1e-4;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
84
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
85 public static final String DATE_FORMAT = "dd.MM.yyyy";
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
86
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
87 public static final String SQL_SQ =
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
88 "SELECT" +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
89 " m.km AS km," +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
90 " m.datum AS datum " +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
91 "FROM messung m " +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
92 " JOIN station s" +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
93 " ON m.stationid = s.stationid " +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
94 " JOIN gewaesser g " +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
95 " ON s.gewaesserid = g.gewaesserid " +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
96 "WHERE" +
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
97 " g.name = :name" +
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
98 " AND m.km IS NOT NULL" +
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
99 " AND m.km BETWEEN :from AND :to " +
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
100 " AND m.d10 IS NOT NULL" +
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
101 "ORDER BY m.km, m.datum";
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
102
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
103 protected String riverName;
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
104 protected String SeddbRiverName;
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
105
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
106 protected KMIndex<List<Date>> entries;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
107
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
108 public BedloadOverview() {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
109 entries = new KMIndex<List<Date>>();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
110 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
111
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
112 public BedloadOverview(String riverName) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
113 this();
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
114 this.riverName = riverName;
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
115 this.SeddbRiverName = RiverFactory.getRiver(riverName).nameForSeddb();
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
116 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
117
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
118 private static final boolean epsilonEquals(double a, double b) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
119 return Math.abs(a - b) < EPSILON;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
120 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
121
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
122 protected void loadData(Session session) {
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
123 double [] fromTo = RiverFactory.getRiver(riverName)
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
124 .determineMinMaxDistance();
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
125
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
126 SQLQuery query = session.createSQLQuery(SQL_SQ)
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
127 .addScalar("km", StandardBasicTypes.DOUBLE)
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
128 .addScalar("datum", StandardBasicTypes.DATE);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
129
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
130 query.setString("name", SeddbRiverName);
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
131 query.setDouble("from", fromTo[0]);
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
132 query.setDouble("to", fromTo[1]);
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
133
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
134 List<Object []> list = query.list();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
135
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
136 if (list.isEmpty()) {
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
137 log.warn("No river '" + SeddbRiverName + "' found.");
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
138 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
139
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
140 Double prevKm = -Double.MAX_VALUE;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
141 List<Date> dates = new ArrayList<Date>();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
142
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
143 for (Object [] row: list) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
144 Double km = (Double)row[0];
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
145 if (!epsilonEquals(km, prevKm) && !dates.isEmpty()) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
146 entries.add(prevKm, dates);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
147 dates = new ArrayList<Date>();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
148 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
149 dates.add((Date)row[1]);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
150 prevKm = km;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
151 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
152
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
153 if (!dates.isEmpty()) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
154 entries.add(prevKm, dates);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
155 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
156 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
157
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
158 public boolean load(Session session) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
159
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
160 loadData(session);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
161
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
162 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
163 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
164
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
165
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
166 public void generateOverview(Document document) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
167 generateOverview(document, ACCEPT);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
168 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
169
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
170 public KMIndex<List<Date>> filter(Filter f) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
171 // TODO: Apply filter
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
172 return entries;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
173 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
174
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
175 public void generateOverview(
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
176 Document document,
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
177 Filter filter
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
178 ) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
179 KMIndex<List<Date>> filtered = filter(ACCEPT);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
180
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
181 Element sqElement = document.createElement("bedload");
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
182
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
183 Element riverElement = document.createElement("river");
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
184
8782
4289930e276c Issue1854: Adapt to QualityMeasurementFactory and filter with river distance.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
185 riverElement.setAttribute("name", SeddbRiverName);
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
186
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
187 sqElement.appendChild(riverElement);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
188
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
189 SimpleDateFormat df = new SimpleDateFormat(DATE_FORMAT);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
190
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
191 Element kmE = document.createElement("km");
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
192
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
193 for (KMIndex.Entry<List<Date>> e: filtered) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
194
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
195 List<Date> dates = e.getValue();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
196
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
197 if (!dates.isEmpty()) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
198 Element dEs = document.createElement("dates");
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
199
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
200 for (Date d: dates) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
201 Element dE = document.createElement("date");
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
202
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
203 dE.setAttribute("value", df.format(d));
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
204
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
205 dEs.appendChild(dE);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
206 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
207
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
208 kmE.appendChild(dEs);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
209 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
210 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
211
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
212 sqElement.appendChild(kmE);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
213
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
214 document.appendChild(sqElement);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
215 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
216 }
http://dive4elements.wald.intevation.org