dive4elements/river: backend/src/main/java/org/dive4elements/river/model/sinfo/InfrastructureValue.java annotate

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/InfrastructureValue.java @ 9625:07f02019065e

Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class

author	mschaefer
date	Mon, 14 Oct 2019 08:14:58 +0200
parents	02ca823ec9c6
children

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
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	35
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	36 /**
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	37 * Hibernate binding for the DB table infrastructure_values
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	38 *
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	39 * @author Matthias Schäfer
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 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	42 @Entity
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	43 @Table(name = "infrastructure_values")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	44 public class InfrastructureValue implements Serializable {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	45
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	46 /*** FIELDS ***/
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	47
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	48 private static final long serialVersionUID = -3887269325288851829L;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	49
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	50 private Integer id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	51
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	52 private Infrastructure infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	53
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	54 private Double station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	55
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	56 private Attribute attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	57
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	58 private Double height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	59
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	60
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	61 /*** CONSTRUCTORS ***/
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 public InfrastructureValue() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	64 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	65
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	66 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	67 this.infrastructure = infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	68 this.station = station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	69 this.attribute = attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	70 this.height = height;
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
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 * Parameter constructor with primitive double km and height
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	75 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	76 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	77 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	78 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	79
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	80
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	81 /*** METHODS ***/
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	82
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	83 @Id
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	84 @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	85 @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	86 @Column(name = "id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	87 public Integer getId() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	88 return this.id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	89 }
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 public void setId(final Integer id) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	92 this.id = id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	93 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	94
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	95 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	96 @JoinColumn(name = "infrastructure_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	97 public Infrastructure getInfrastructure() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	98 return this.infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	99 }
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 public void setInfrastructure(final Infrastructure infrastructure) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	102 this.infrastructure = infrastructure;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	103 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	104
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	105 @Column(name = "station")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	106 public Double getStation() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	107 return this.station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	108 }
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 public void setStation(final Double station) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	111 this.station = station;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	112 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	113
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	114 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	115 @JoinColumn(name = "attribute_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	116 public Attribute getAttribute() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	117 return this.attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	118 }
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 public void setAttribute(final Attribute attribute) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	121 this.attribute = attribute;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	122 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	123
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	124 @Transient
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	125 public AttributeKey getAttributeKey() {
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	126 return this.getAttribute().getKey();
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	127 }
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	128
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	129 @Column(name = "height")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	130 public Double getHeight() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	131 return this.height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	132 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	133
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	134 public void setHeight(final Double height) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	135 this.height = height;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	136 }
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 /**
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	139 * 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	140 */
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 8971 diff changeset	141 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	142 final Session session = SessionHolder.HOLDER.get();
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	143 final Query query = session.createQuery("FROM InfrastructureValue WHERE (infrastructure=:parent)"
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	144 + " 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	145 query.setParameter("parent", parent);
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 8971 diff changeset	146 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	147 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	148 return query.list();
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 8971 diff changeset	149 }
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	150
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	151 /**
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	152 * 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	153 */
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	154 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	155 final Set<String> groupTypes) {
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	156 final Session session = SessionHolder.HOLDER.get();
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	157 final Query query = session.createQuery("FROM InfrastructureValue"
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	158 + " WHERE (infrastructure.river=:river)"
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	159 + " AND (station BETWEEN :kmLo - 0.0001 AND :kmHi + 0.0001)"
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	160 + getRiversideClause(riverside, "", "attr_id")
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	161 + getGroupTypeClause(groupTypes, "")
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	162 + " ORDER BY station, attribute.id");
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	163 query.setParameter("river", river);
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	164 query.setParameter("kmLo", new Double(kmLo));
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	165 query.setParameter("kmHi", new Double(kmHi));
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	166 if (!getRiversideClause(riverside, "", "attr_id").isEmpty())
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	167 query.setParameter("attr_id", riverside.getId());
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	168 return query.list();
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	169 }
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	170
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	171 /**
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	172 * 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	173 */
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	174 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	175 if (groupTypes.size() == 0)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	176 return "";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	177 String clause = " AND (";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	178 String sep = "";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	179 for (final String groupType : groupTypes) {
9625 07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	180 clause += sep + "(" + tableprefix + "infrastructure.group.name='" + groupType.split("\t")[0] + "'"
07f02019065e Nachtrag Pos. 20: infrastructure query added, calculation updated for extended access class mschaefer parents: 9624 diff changeset	181 + " AND " + tableprefix + "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	182 sep = " OR ";
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 if (sep.length() >= 1)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	185 clause += ")";
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	186 return clause;
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	187 }
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	188
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	189 /**
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	190 * 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	191 */
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	192 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	193 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	194 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	195 else
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	196 return "";
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	197 }
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	198 }

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/InfrastructureValue.java @ 9625:07f02019065e