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

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java @ 9620:26e113e8224f

Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, local class FloodDurationCalculationResult.Infrastructure renamed and extracted into own class

author	mschaefer
date	Thu, 10 Oct 2019 17:11:54 +0200
parents	d889ffe2fb05
children	02ca823ec9c6

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;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	14 import java.util.ArrayList;
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	15 import java.util.HashSet;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	16 import java.util.List;
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	17 import java.util.Set;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	18
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	19 import javax.persistence.Column;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	20 import javax.persistence.Entity;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	21 import javax.persistence.GeneratedValue;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	22 import javax.persistence.GenerationType;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	23 import javax.persistence.Id;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	24 import javax.persistence.JoinColumn;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	25 import javax.persistence.OneToMany;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	26 import javax.persistence.OneToOne;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	27 import javax.persistence.SequenceGenerator;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	28 import javax.persistence.Table;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	29
9115 a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	30 import org.dive4elements.river.backend.SessionHolder;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	31 import org.dive4elements.river.model.AnnotationType;
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	32 import org.dive4elements.river.model.Attribute.AttributeKey;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	33 import org.dive4elements.river.model.River;
9115 a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	34 import org.hibernate.Query;
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	35 import org.hibernate.Session;
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 /**
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	38 * Hibernate binding for the DB table infrastructure
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 * @author Matthias Schäfer
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 */
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	43
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	44 @Entity
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	45 @Table(name = "infrastructure")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	46 public class Infrastructure implements Serializable {
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 /*** FIELDS ***/
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 static final long serialVersionUID = -5505080011501611034L;
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 Integer id;
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 River river;
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 String filename;
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 String kmrange_info;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	59
9038 4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	60 private String notes;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	61
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	62 private AnnotationType type;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	63
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	64 private AnnotationType group;
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	65
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	66 private Integer year;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	67
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	68 private String dataprovider;
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 private String evaluation_by;
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 private List<InfrastructureValue> values;
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
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	75 /*** CONSTRUCTORS ***/
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 public Infrastructure() {
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
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	80
9038 4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	81 public Infrastructure(final River river, final String filename, final String kmrange_info, final String notes, final AnnotationType type,
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	82 final AnnotationType group, final Integer year, final String dataprovider, final String evaluation_by) {
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	83 this.river = river;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	84 this.filename = filename;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	85 this.kmrange_info = kmrange_info;
9038 4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	86 this.notes = notes;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	87 this.type = type;
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	88 this.group = group;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	89 this.year = year;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	90 this.dataprovider = dataprovider;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	91 this.evaluation_by = evaluation_by;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	92 this.values = new ArrayList<>();
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
9115 a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	95
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	96 /*** METHODS ***/
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 @Id
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	99 @SequenceGenerator(name = "SEQUENCE_INFRASTRUCTURE_ID_SEQ", sequenceName = "INFRASTRUCTURE_ID_SEQ", allocationSize = 1)
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	100 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_INFRASTRUCTURE_ID_SEQ")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	101 @Column(name = "id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	102 public Integer getId() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	103 return this.id;
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
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	106 public void setId(final Integer id) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	107 this.id = id;
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 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	111 @JoinColumn(name = "river_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	112 public River getRiver() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	113 return this.river;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	114 }
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 public void setRiver(final River river) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	117 this.river = river;
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 @Column(name = "filename")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	121 public String getFilename() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	122 return this.filename;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	123 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	124
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	125 public void setFilename(final String filename) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	126 this.filename = filename;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	127 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	128
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	129 @Column(name = "kmrange_info")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	130 public String getKmrange_info() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	131 return this.kmrange_info;
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 setKmrange_info(final String kmrange_info) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	135 this.kmrange_info = kmrange_info;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	136 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	137
9038 4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	138 @Column(name = "notes")
4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	139 public String getNotes() {
4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	140 return this.notes;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	141 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	142
9038 4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	143 public void setNotes(final String notes) {
4c5eeaff554c Database column "comment" renamed to "notes" (restrictions in Oracle) mschaefer parents: 8971 diff changeset	144 this.notes = notes;
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	145 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	146
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	147 @OneToOne
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	148 @JoinColumn(name = "annotation_type_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	149 public AnnotationType getType() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	150 return this.type;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	151 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	152
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	153 public void setType(final AnnotationType type) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	154 this.type = type;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	155 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	156
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	157 @OneToOne
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	158 @JoinColumn(name = "group_id")
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	159 public AnnotationType getGroup() {
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	160 return this.group;
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	161 }
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	162
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	163 public void setGroup(final AnnotationType group) {
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	164 this.group = group;
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	165 }
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	166
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	167 @Column(name = "year")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	168 public Integer getYear() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	169 return this.year;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	170 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	171
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	172 public void setYear(final Integer year) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	173 this.year = year;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	174 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	175
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	176 @Column(name = "dataprovider")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	177 public String getDataprovider() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	178 return this.dataprovider;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	179 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	180
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	181 public void setDataprovider(final String dataprovider) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	182 this.dataprovider = dataprovider;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	183 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	184
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	185 @Column(name = "evaluation_by")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	186 public String getEvaluation_by() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	187 return this.evaluation_by;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	188 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	189
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	190 public void setEvaluation_by(final String evaluation_by) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	191 this.evaluation_by = evaluation_by;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	192 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	193
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	194 @OneToMany
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	195 @JoinColumn(name = "infrastructure_id")
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	196 public List<InfrastructureValue> getValues() {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	197 return this.values;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	198 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	199
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	200 public void setValues(final List<InfrastructureValue> values) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	201 this.values = values;
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	202 }
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	203
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	204 public void addValue(final InfrastructureValue value) {
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	205 this.values.add(value);
50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	206 }
9115 a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	207
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	208 /**
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	209 * Get data series by id
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	210 */
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	211 public static Infrastructure getSeries(final int id) {
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	212 final Session session = SessionHolder.HOLDER.get();
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	213 final Query query = session.createQuery("FROM Infrastructure WHERE (id=:id)");
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	214 query.setParameter("id", id);
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	215 return (Infrastructure) query.list().get(0);
a165cd63099f Added datacage select and chart display for river infrastructure heights loaded from database mschaefer parents: 9038 diff changeset	216 }
9176 1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	217
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	218 /**
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	219 * Get first data series of a river
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	220 */
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	221 public static Infrastructure getSeries(final River river) {
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	222 final Session session = SessionHolder.HOLDER.get();
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	223 final Query query = session.createQuery("FROM Infrastructure WHERE (river=:river)");
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	224 query.setParameter("river", river);
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	225 final List rows = query.list();
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	226 if (!rows.isEmpty())
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	227 return (Infrastructure) rows.get(0);
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	228 else
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	229 return null;
1614cb14308f Work on calculations for S-Info flood duration workflow mschaefer parents: 9115 diff changeset	230 }
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	231
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	232 /**
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	233 * Fetches from the database the infrastructure groups and types of a river's km range and river side(s)
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	234 * as tab-separated strings ordered by the infrastructure group, then the type
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	235 */
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	236 public static Set<String> fetchInfrastructureTypes(final River river, final double kmLo, final double kmHi,
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	237 final AttributeKey riverside) {
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	238 final Set<String> groupTypes = new HashSet<>();
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	239 for (final Infrastructure ifs : fetchInfrastructureTypeList(river, kmLo, kmHi, riverside))
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	240 groupTypes.add(ifs.getGroup().getName() + "\t" + ifs.getType().getName());
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	241 return groupTypes;
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	242 }
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	243
26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	244 /**
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	245 * Fetches from the database the list of infrastructure types of a river's km range and river side(s)
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	246 * ordered by type group
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	247 */
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	248 private static List<Infrastructure> fetchInfrastructureTypeList(final River river, final double kmLo, final double kmHi,
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	249 final AttributeKey riverside) {
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	250
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	251 final Session session = SessionHolder.HOLDER.get();
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	252
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	253 final Query query = session.createQuery("FROM Infrastructure"
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	254 + " WHERE (river=:river)"
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	255 + " AND (id IN (SELECT v.infrastructure.id FROM InfrastructureValue v"
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	256 + " WHERE (v.station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))"
9620 26e113e8224f Nachtrag Pos. 20: flood duration calculation for multiple infrastructure groups/types, mschaefer parents: 9614 diff changeset	257 + InfrastructureValue.getRiversideClause(riverside, "v.", "attr_id")
9614 d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	258 + "))"
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	259 + " ORDER BY group, type");
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	260 query.setParameter("river", river);
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	261 query.setParameter("kmLo", new Double(kmLo));
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	262 query.setParameter("kmHi", new Double(kmHi));
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	263 if (!InfrastructureValue.getRiversideClause(riverside, "v", "attr_id").isEmpty())
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	264 query.setParameter("attr_id", riverside.getId());
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	265
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	266 return query.list();
d889ffe2fb05 Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class mschaefer parents: 9176 diff changeset	267 }
8971 50416a0df385 Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files mschaefer parents: diff changeset	268 }

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java @ 9620:26e113e8224f