dive4elements/river: flys-backend/src/main/java/de/intevation/flys/model/River.java annotate

annotate flys-backend/src/main/java/de/intevation/flys/model/River.java @ 3795:f210432f4383

Fix hibernate query flys-backend/trunk@5438 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Bjoern Ricks <bjoern.ricks@intevation.de>
date	Wed, 12 Sep 2012 11:12:19 +0000
parents	42db09d101f3
children	5fea100c5334

rev	line source
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 package de.intevation.flys.model;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 import java.io.Serializable;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	4
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	5 import java.math.BigDecimal;
768 87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	6 import java.math.MathContext;
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	7
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	8 import javax.persistence.Entity;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	9 import javax.persistence.Id;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	10 import javax.persistence.Table;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	11 import javax.persistence.GeneratedValue;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	12 import javax.persistence.Column;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	13 import javax.persistence.SequenceGenerator;
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	14 import javax.persistence.OneToMany;
2347 0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	15 import javax.persistence.OneToOne;
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	16 import javax.persistence.JoinColumn;
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	17 import javax.persistence.GenerationType;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	18
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	19 import java.util.List;
2383 6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	20 import java.util.Comparator;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	21 import java.util.Map;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	22 import java.util.TreeMap;
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	23
472 1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	24 import org.hibernate.Session;
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	25 import org.hibernate.Query;
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	26
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	27 import de.intevation.flys.backend.SessionHolder;
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	28
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	29
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	30 @Entity
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	31 @Table(name = "rivers")
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32 public class River
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	33 implements Serializable
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	34 {
768 87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	35 public static final MathContext PRECISION = new MathContext(6);
87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	36
2383 6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	37 public static final double EPSILON = 1e-5;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	38
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	39 public static final Comparator KM_CMP = new Comparator<Double>() {
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	40 @Override
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	41 public int compare(Double a, Double b) {
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	42 double diff = a - b;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	43 if (diff < -EPSILON) return -1;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	44 if (diff > EPSILON) return +1;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	45 return 0;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	46 }
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	47 };
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	48
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	49 private Integer id;
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	50
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	51 private String name;
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52
505 ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	53 private boolean kmUp;
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	54
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	55 private List<Gauge> gauges;
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	56
2347 0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	57 private Unit wstUnit;
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	58
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	59 @Id
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	60 @SequenceGenerator(
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 169 diff changeset	61 name = "SEQUENCE_RIVERS_ID_SEQ",
169 7929f4144d2f Bound Apache Commons DBCP with Hibernate. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	62 sequenceName = "RIVERS_ID_SEQ",
7929f4144d2f Bound Apache Commons DBCP with Hibernate. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	63 allocationSize = 1)
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	64 @GeneratedValue(
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	65 strategy = GenerationType.SEQUENCE,
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 169 diff changeset	66 generator = "SEQUENCE_RIVERS_ID_SEQ")
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	67 @Column(name = "id")
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	68 public Integer getId() {
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	69 return id;
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	70 }
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	71
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	72 public void setId(Integer id) {
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 this.id = id;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	76 @Column(name = "name")
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	77 public String getName() {
86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	78 return name;
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 public void setName(String name) {
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 this.name = name;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84
505 ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	85 @Column(name = "km_up")
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	86 public boolean getKmUp() {
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	87 return kmUp;
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	88 }
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	89
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	90 public void setKmUp(boolean kmUp) {
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	91 this.kmUp = kmUp;
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	92 }
ce9c6f05f464 Schema: Added a column which tells if a river counts its km up or downwards. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 488 diff changeset	93
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 public River() {
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 }
169 7929f4144d2f Bound Apache Commons DBCP with Hibernate. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	96
2347 0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	97 public River(String name, Unit wstUnit) {
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	98 this.name = name;
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	99 this.wstUnit = wstUnit;
169 7929f4144d2f Bound Apache Commons DBCP with Hibernate. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	100 }
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	101
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	102 @OneToMany
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	103 @JoinColumn(name="river_id")
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	104 public List<Gauge> getGauges() {
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	105 return gauges;
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	106 }
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	107
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	108 public void setGauges(List<Gauge> gauges) {
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	109 this.gauges = gauges;
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	110 }
188 003ac16812dd Store annotations in backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	111
2347 0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	112
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	113 @OneToOne
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	114 @JoinColumn(name = "wst_unit_id" )
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	115 public Unit getWstUnit() {
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	116 return wstUnit;
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	117 }
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	118
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	119 public void setWstUnit(Unit wstUnit) {
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	120 this.wstUnit = wstUnit;
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	121 }
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	122
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	123
0acf28a3d28a Removed the Unit from Wsts - added a WstUnit column to rivers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2345 diff changeset	124
188 003ac16812dd Store annotations in backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	125 public String toString() {
003ac16812dd Store annotations in backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	126 return name != null ? name : "";
003ac16812dd Store annotations in backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	127 }
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	128
472 1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	129
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	130 /**
488 b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	131 * This method returns the gauges that intersect with <i>a</i> and
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	132 * <i>b</i>,
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	133 *
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	134 * @param a A start point.
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	135 * @param b An end point.
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	136 *
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	137 * @return the intersecting gauges.
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	138 */
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	139 public List<Gauge> determineGauges(double a, double b) {
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	140 Session session = SessionHolder.HOLDER.get();
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	141
756 ca13926b8871 River: Make search for gauges independent of from/to order. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 505 diff changeset	142 if (a > b) { double t = a; a = b; b = t; }
ca13926b8871 River: Make search for gauges independent of from/to order. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 505 diff changeset	143
488 b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	144 Query query = session.createQuery(
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	145 "from Gauge where river=:river " +
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	146 "and not (range.a > :b or range.b < :a) order by a");
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	147 query.setParameter("river", this);
769 321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	148 query.setParameter("a", new BigDecimal(a, PRECISION));
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	149 query.setParameter("b", new BigDecimal(b, PRECISION));
488 b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	150
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	151 return query.list();
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	152 }
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	153
769 321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	154 public Gauge maxOverlap(double a, double b) {
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	155 List<Gauge> gauges = determineGauges(a, b);
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	156 if (gauges == null) {
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	157 return null;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	158 }
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	159
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	160 if (a > b) { double t = a; a = b; b = t; }
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	161
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	162 double max = -Double.MAX_VALUE;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	163
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	164 Gauge result = null;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	165
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	166 for (Gauge gauge: gauges) {
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	167 Range r = gauge.getRange();
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	168 double c = r.getA().doubleValue();
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	169 double d = r.getB().doubleValue();
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	170
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	171 double start = c >= a ? c : a;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	172 double stop = d <= b ? d : b;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	173
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	174 double length = stop - start;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	175
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	176 if (length > max) {
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	177 max = length;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	178 result = gauge;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	179 }
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	180 }
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	181
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	182 return result;
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	183 }
321b9e480f72 Added a method to river to find the gauge with the max overlap with a given interval. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 768 diff changeset	184
767 5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	185 public Gauge determineGaugeByName(String name) {
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	186 Session session = SessionHolder.HOLDER.get();
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	187 Query query = session.createQuery(
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	188 "from Gauge where river=:river and name=:name");
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	189 query.setParameter("river", this);
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	190 query.setParameter("name", name);
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	191 List<Gauge> gauges = query.list();
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	192 return gauges.isEmpty() ? null : gauges.get(0);
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	193 }
5572d051347e River: Added method to find gauge by its name. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 764 diff changeset	194
764 e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	195 public Gauge determineGaugeByPosition(double p) {
e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	196 Session session = SessionHolder.HOLDER.get();
e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	197 Query query = session.createQuery(
768 87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	198 "from Gauge g where river=:river " +
87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	199 "and :p between g.range.a and g.range.b");
764 e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	200 query.setParameter("river", this);
768 87ac543c7ab9 When Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 767 diff changeset	201 query.setParameter("p", new BigDecimal(p, PRECISION));
764 e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	202 List<Gauge> gauges = query.list();
e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	203 return gauges.isEmpty() ? null : gauges.get(0);
e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	204 }
e09f00ecb915 river model: Added method to find gauge by a position lying in its range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 757 diff changeset	205
757 c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	206 public Gauge determineGaugeByStation(double a, double b) {
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	207
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	208 if (a > b) { double t = a; a = b; b = t; }
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	209
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	210 Session session = SessionHolder.HOLDER.get();
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	211
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	212 Query query = session.createQuery(
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	213 "from Gauge where river.id=:river " +
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	214 "and station between :a and :b");
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	215 query.setParameter("river", getId());
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	216 query.setParameter("a", new BigDecimal(a));
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	217 query.setParameter("b", new BigDecimal(b));
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	218
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	219 List<Gauge> gauges = query.list();
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	220 return gauges.isEmpty() ? null : gauges.get(0);
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	221 }
c19d4c643526 River: add method to find gauge by its station position. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 756 diff changeset	222
3794 42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	223 public double[] determineMinMaxQ() {
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	224 Session session = SessionHolder.HOLDER.get();
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	225
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	226 Query query = session.createQuery(
3795 f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	227 "select min(wqr.q) as min, max(wqr.q) as max " +
f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	228 "from Wst as w " +
f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	229 "join w.columns as wc " +
f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	230 "join wc.columnQRanges as wcqr " +
f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	231 "join wcqr.wstQRange as wqr " +
f210432f4383 Fix hibernate query Bjoern Ricks <bjoern.ricks@intevation.de> parents: 3794 diff changeset	232 "where w.kind = 0 and river_id = :river");
3794 42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	233
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	234 query.setParameter("river", getId());
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	235
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	236 double minmax[] = new double[] { Double.MAX_VALUE, Double.MIN_VALUE };
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	237
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	238 List<Object> results = query.list();
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	239
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	240 if (!results.isEmpty()) {
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	241 Object[] arr = (Object[]) results.get(0);
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	242 BigDecimal minq = (BigDecimal)arr[0];
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	243 BigDecimal maxq = (BigDecimal)arr[1];
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	244 minmax[0] = minq.doubleValue();
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	245 minmax[1] = maxq.doubleValue();
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	246 }
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	247
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	248 return minmax;
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	249 }
42db09d101f3 Add new method determineMinMaxQ to the River class to fetch the mimimum and maximum q values Bjoern Ricks <bjoern.ricks@intevation.de> parents: 2384 diff changeset	250
488 b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	251
b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	252 /**
472 1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	253 * This method returns the first gauge that is intersected by <i>a</i> and
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	254 * <i>b</i>,
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	255 *
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	256 * @param a A start point.
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	257 * @param b An end point.
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	258 *
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	259 * @return the first intersecting gauge.
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	260 */
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	261 public Gauge determineGauge(double a, double b) {
488 b316d2106598 River got a new method that returns all gauges intersected by a given start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 472 diff changeset	262 List<Gauge> gauges = determineGauges(a, b);
472 1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	263
2345 c3ea91aee989 Bugfix: #333 Improved determination of reference gauge based on start km. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 769 diff changeset	264 int idx = a < b ? 0 : gauges.size() - 1;
c3ea91aee989 Bugfix: #333 Improved determination of reference gauge based on start km. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 769 diff changeset	265
c3ea91aee989 Bugfix: #333 Improved determination of reference gauge based on start km. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 769 diff changeset	266 return gauges.isEmpty() ? null : gauges.get(idx);
472 1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	267 }
1e196c75563b Added a new method to determine the selected gauge of a river based on a start and end point. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 465 diff changeset	268
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	269 /**
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	270 * Returns the min and max distance of this river. The first position in the
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	271 * resulting array contains the min distance, the second position the max
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	272 * distance.
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	273 *
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	274 * @return the min and max distance of this river.
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	275 */
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	276 public double[] determineMinMaxDistance() {
2373 056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	277 List<Gauge> gauges = getGauges();
056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	278
056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	279 if (gauges == null \|\| gauges.isEmpty()) {
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	280 return null;
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	281 }
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	282
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	283 double minmax[] = new double[] { Double.MAX_VALUE, Double.MIN_VALUE };
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	284
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	285 for (Gauge g: gauges) {
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	286 Range r = g.getRange();
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	287
2373 056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	288 if (r == null) {
056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	289 continue;
056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	290 }
056b3a5aa181 Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2347 diff changeset	291
465 c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	292 double a = r.getA().doubleValue();
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	293 minmax[0] = minmax[0] < a ? minmax[0] : a;
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	294
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	295 BigDecimal bigB = r.getB();
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	296 if (bigB != null) {
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	297 double b = bigB.doubleValue();
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	298 minmax[1] = minmax[1] > b ? minmax[1] : b;
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	299 }
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	300 }
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	301
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	302 return minmax;
c2c3ad4fda58 Added a method to River that returns the min and max distance of the river. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 188 diff changeset	303 }
2383 6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	304
2384 385170ff7b34 River: (fix) Renamed function which is not a getter. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 2383 diff changeset	305 public Map<Double, Double> queryGaugeDatumsKMs() {
2383 6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	306 List<Gauge> gauges = getGauges();
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	307 Map result = new TreeMap<Double, Double>(KM_CMP);
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	308
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	309 for (Gauge gauge: gauges) {
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	310 BigDecimal km = gauge.getStation();
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	311 BigDecimal datum = gauge.getDatum();
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	312 if (km != null && datum != null) {
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	313 result.put(km.doubleValue(), datum.doubleValue());
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	314 }
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	315 }
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	316
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	317 return result;
6605dcd6745f Added a method to build a map from gauge stations to the datums of the gauges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2373 diff changeset	318 }
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	319 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	320 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate flys-backend/src/main/java/de/intevation/flys/model/River.java @ 3795:f210432f4383