Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/InfrastructureValue.java @ 9624:02ca823ec9c6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
zu Pos 20 Nachtrag; infrastructureChoice
author dnt_bjoernsen <d.tironi@bjoernsen.de>
date Fri, 11 Oct 2019 18:30:36 +0200
parents 26e113e8224f
children 07f02019065e
rev   line source
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
1 /* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
2 * Software engineering by
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
3 * Björnsen Beratende Ingenieure GmbH
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
4 * Dr. Schumacher Ingenieurbüro für Wasser und Umwelt
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
5 *
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
6 * This file is Free Software under the GNU AGPL (>=v3)
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
7 * and comes with ABSOLUTELY NO WARRANTY! Check out the
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
8 * documentation coming with Dive4Elements River for details.
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
9 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
10
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
11 package org.dive4elements.river.model.sinfo;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
12
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
13 import java.io.Serializable;
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
14 import java.util.List;
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
15 import java.util.Set;
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
16
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
17 import javax.persistence.Column;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
18 import javax.persistence.Entity;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
19 import javax.persistence.GeneratedValue;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
20 import javax.persistence.GenerationType;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
21 import javax.persistence.Id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
22 import javax.persistence.JoinColumn;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
23 import javax.persistence.OneToOne;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
24 import javax.persistence.SequenceGenerator;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
25 import javax.persistence.Table;
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
26 import javax.persistence.Transient;
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
27
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
28 import org.dive4elements.river.backend.SessionHolder;
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
29 import org.dive4elements.river.model.Attribute;
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
30 import org.dive4elements.river.model.Attribute.AttributeKey;
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
31 import org.dive4elements.river.model.River;
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
32 import org.hibernate.Query;
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
33 import org.hibernate.Session;
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
34
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
35 /**
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
36 * Hibernate binding for the DB table infrastructure_values
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
37 *
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
38 * @author Matthias Schäfer
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
39 *
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
40 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
41 @Entity
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
42 @Table(name = "infrastructure_values")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
43 public class InfrastructureValue implements Serializable {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
44
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
45 /***** FIELDS *****/
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
46
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
47 private static final long serialVersionUID = -3887269325288851829L;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
48
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
49 private Integer id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
50
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
51 private Infrastructure infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
52
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
53 private Double station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
54
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
55 private Attribute attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
56
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
57 private Double height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
58
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
59 /***** CONSTRUCTORS *****/
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
60
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
61 public InfrastructureValue() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
62 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
63
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
64 public InfrastructureValue(final Infrastructure infrastructure, final Double station, final Attribute attribute, final Double height) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
65 this.infrastructure = infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
66 this.station = station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
67 this.attribute = attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
68 this.height = height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
69 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
70
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
71 /**
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
72 * Parameter constructor with primitive double km and height
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
73 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
74 public InfrastructureValue(final Infrastructure infrastructure, final double km, final Attribute attribute, final double height) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
75 this(infrastructure, Double.valueOf(km), attribute, Double.valueOf(height));
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
76 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
77
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
78 /***** METHODS *****/
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
79
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
80 @Id
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
81 @SequenceGenerator(name = "SEQUENCE_INFRASTRUCTURE_VALUE_ID_SEQ", sequenceName = "INFRASTRUCTURE_VALUES_ID_SEQ", allocationSize = 1)
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
82 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_INFRASTRUCTURE_VALUE_ID_SEQ")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
83 @Column(name = "id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
84 public Integer getId() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
85 return this.id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
86 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
87
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
88 public void setId(final Integer id) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
89 this.id = id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
90 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
91
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
92 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
93 @JoinColumn(name = "infrastructure_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
94 public Infrastructure getInfrastructure() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
95 return this.infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
96 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
97
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
98 public void setInfrastructure(final Infrastructure infrastructure) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
99 this.infrastructure = infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
100 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
101
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
102 @Column(name = "station")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
103 public Double getStation() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
104 return this.station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
105 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
106
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
107 public void setStation(final Double station) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
108 this.station = station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
109 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
110
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
111 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
112 @JoinColumn(name = "attribute_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
113 public Attribute getAttribute() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
114 return this.attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
115 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
116
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
117 public void setAttribute(final Attribute attribute) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
118 this.attribute = attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
119 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
120
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
121 @Transient
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
122 public AttributeKey getAttributeKey() {
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
123 return this.getAttribute().getKey();
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
124 }
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
125
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
126 @Column(name = "height")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
127 public Double getHeight() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
128 return this.height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
129 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
130
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
131 public void setHeight(final Double height) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
132 this.height = height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
133 }
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
134
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
135 /**
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
136 * Selects from the database the infrastructure values of a data series in a km range
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
137 */
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
138 public static List<InfrastructureValue> getValues(final Infrastructure parent, final double kmLo, final double kmHi) {
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
139 final Session session = SessionHolder.HOLDER.get();
9624
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
140 final Query query = session
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
141 .createQuery("FROM InfrastructureValue WHERE (infrastructure=:parent)" + " AND (station >= :kmLo - 0.0001) AND (station <= :kmHi + 0.0001)");
9115
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
142 query.setParameter("parent", parent);
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
143 query.setParameter("kmLo", new Double(kmLo));
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
144 query.setParameter("kmHi", new Double(kmHi));
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
145 return query.list();
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database
mschaefer
parents: 8971
diff changeset
146 }
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
147
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
148 /**
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
149 * Selects from the database the infrastructure values of a km range of a river and a group/type/river-side selection
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
150 */
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
151 public static List<InfrastructureValue> getValues(final River river, final double kmLo, final double kmHi, final AttributeKey riverside,
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
152 final Set<String> groupTypes) {
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
153 final Session session = SessionHolder.HOLDER.get();
9624
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
154 final Query query = session
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
155 .createQuery("FROM InfrastructureValue" + " WHERE (infrastructure.river=:river)" + " AND (station BETWEEN :kmLo - 0.0001 AND :kmHi + 0.0001)"
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
156 + getRiversideClause(riverside, "", "attr_id") + getGroupTypeClause(groupTypes, "") + " ORDER BY station, attribute.id");
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
157 query.setParameter("river", river);
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
158 query.setParameter("kmLo", new Double(kmLo));
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
159 query.setParameter("kmHi", new Double(kmHi));
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
160 if (!getRiversideClause(riverside, "", "attr_id").isEmpty())
9176
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
161 query.setParameter("attr_id", riverside.getId());
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
162 return query.list();
1614cb14308f Work on calculations for S-Info flood duration workflow
mschaefer
parents: 9115
diff changeset
163 }
9614
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
164
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
165 /**
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
166 * Gets a query's and-where-clause for a set of infrastructure group-type-pairs (as tab-separated strings)
9614
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
167 */
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
168 private static String getGroupTypeClause(final Set<String> groupTypes, final String tableprefix) {
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
169 if (groupTypes.size() == 0)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
170 return "";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
171 String clause = " AND (";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
172 String sep = "";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
173 for (final String groupType : groupTypes) {
9624
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
174 clause += sep + "(" + tableprefix + "infrastructure.group.name='" + groupType.split("\t")[0] + "'" + " AND " + tableprefix
02ca823ec9c6 zu Pos 20 Nachtrag; infrastructureChoice
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9620
diff changeset
175 + "infrastructure.type.name='" + groupType.split("\t")[1] + "')";
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
176 sep = " OR ";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
177 }
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
178 if (sep.length() >= 1)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
179 clause += ")";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
180 return clause;
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
181 }
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
182
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
183 /**
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
184 * Gets a query's and-where-clause for a riverside key (tableprefix empty or starting with a dot)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
185 */
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
186 public static String getRiversideClause(final AttributeKey riverside, final String tableprefix, final String variable) {
9614
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
187 if ((riverside == AttributeKey.LEFT) || (riverside == AttributeKey.RIGHT))
9620
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types,
mschaefer
parents: 9614
diff changeset
188 return " AND (" + tableprefix + "attribute.id=:" + variable + ")";
9614
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
189 else
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
190 return "";
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
mschaefer
parents: 9176
diff changeset
191 }
8971
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
mschaefer
parents:
diff changeset
192 }
http://dive4elements.wald.intevation.org