Mercurial > dive4elements > river

annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java @ 4282:8b4988815974

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added marker for Ws and Qs in Historical Discharge WQ charts. Therefore, the XYChartGenerator got two new methods addDomainMarker(Marker, boolean) and addValueMarker(Marker, boolean). The boolean parameters determine, if the marker should be visible or not. This is analogous to addAxisSeries(XYSeries, int, boolean).
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 29 Oct 2012 05:59:27 +0100
parents 729bd242c82e
children
rev   line source
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
1 package de.intevation.flys.artifacts.model.minfo;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
2
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
3 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
4 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
5 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
6 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
7 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
8
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
9 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
10 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
11 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
12 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
13 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
14 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
15
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
16 import de.intevation.flys.utils.KMIndex;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
17
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
18 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
19
3778
35a6c9a49a76 Fixed wrong assigned loggers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3751
diff changeset
20 private static Logger log = Logger.getLogger(BedloadOverview.class);
35a6c9a49a76 Fixed wrong assigned loggers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3751
diff changeset
21
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
22 /**
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
23 * 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
24 */
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
25 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
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 interface Filter {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
28 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
29
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
30 } // interface Filter
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
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
33 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
34 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
35 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
36 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
37 };
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 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
40
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
41 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
42
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
43 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
44 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
45 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
46 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
47 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
48 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
49 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
50 }
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 return false;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
53 }
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
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
56 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
57
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
58 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
59
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
60 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
61 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
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 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
65 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
66 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
67 return true;
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 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
70 return false;
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
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
74 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
75
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
76 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
77
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
78 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
79 "SELECT" +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
80 " 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
81 " 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
82 "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
83 " 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
84 " 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
85 " 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
86 " 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
87 "WHERE" +
3914
729bd242c82e MINFO: Fixed SQL statement in BedloadOverview. Exclude data where km is null.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3778
diff changeset
88 " g.name = :name AND " +
729bd242c82e MINFO: Fixed SQL statement in BedloadOverview. Exclude data where km is null.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3778
diff changeset
89 " m.km IS NOT NULL " +
3751
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
90 "ORDER by" +
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
91 " m.km, m.datum";
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
92
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
93 protected String riverName;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
94
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
95 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
96
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
97 public BedloadOverview() {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
98 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
99 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
100
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
101 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
102 this();
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
103 this.riverName = riverName;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
104 }
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 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
107 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
108 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
109
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
110 protected void loadData(Session session) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
111 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
112 .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
113 .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
114
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
115 query.setString("name", riverName);
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 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
118
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
119 if (list.isEmpty()) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
120 log.warn("No river '" + riverName + "' found.");
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
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
123 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
124 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
125
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
126 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
127 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
128 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
129 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
130 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
131 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
132 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
133 prevKm = km;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
134 }
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 (!dates.isEmpty()) {
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
137 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
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
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
141 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
142
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
143 loadData(session);
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
144
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
145 return true;
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
146 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
147
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 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
150 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
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 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
154 // 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
155 return entries;
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 void generateOverview(
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
159 Document document,
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
160 Filter filter
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 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
163
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
164 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
165
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
166 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
167
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
168 riverElement.setAttribute("name", riverName);
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 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
171
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
172 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
173
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
174 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
175
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
176 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
177
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
178 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
179
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
180 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
181 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
182
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
183 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
184 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
185
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
186 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
187
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
188 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
189 }
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 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
192 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
193 }
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 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
196
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
197 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
198 }
ae598cf50682 Added new services to render overview charts in minfo bed quality calculation
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
199 }
http://dive4elements.wald.intevation.org