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

annotate backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 6229:3fea9701d58d

Fix gauge determination. If we look upstream ( a > b ) we still have to compare the start value of our range against the gauge and not the end value. The start value is always the relevant value as we handle the direction by checking this against A or B of the gauge. Also: I will never compare doubles with == again. I will never compare doubles with == again. I will never compare doubles with == again. I will never compare doubles with == again. I will never compare doubles with == again.

author	Andre Heinecke <aheinecke@intevation.de>
date	Thu, 06 Jun 2013 18:23:17 +0200
parents	4c3ccf2b0304
children	5b1cc816fcdb

rev	line source
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5844 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5844 diff changeset	6 * documentation coming with Dive4Elements River for details.
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	9 package org.dive4elements.river.model;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11 import java.io.Serializable;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13 import java.util.List;
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	14 import java.util.ArrayList;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	15
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	16 import java.awt.geom.Point2D;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 import javax.persistence.Entity;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 import javax.persistence.Id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 import javax.persistence.Table;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21 import javax.persistence.GeneratedValue;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22 import javax.persistence.Column;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 import javax.persistence.SequenceGenerator;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24 import javax.persistence.GenerationType;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 import javax.persistence.OneToOne;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 import javax.persistence.OneToMany;
1210 31d8638760b1 New. The hibernate models Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1204 diff changeset	27 import javax.persistence.OrderBy;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 import javax.persistence.JoinColumn;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	30 import java.math.MathContext;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	31 import java.math.BigDecimal;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	32
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	33 import org.hibernate.Session;
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	34 import org.hibernate.SQLQuery;
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	35 import org.hibernate.Query;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	36
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	37 import org.hibernate.type.StandardBasicTypes;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	38
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	39 import org.dive4elements.river.backend.SessionHolder;
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	40
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 @Entity
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 @Table(name = "cross_sections")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 public class CrossSection
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 implements Serializable
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 {
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	46 public static final MathContext PRECISION = new MathContext(6);
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	47
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	48 public static final String SQL_FAST_CROSS_SECTION_LINES =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	49 "SELECT km, x, y, csl.id AS csl_id " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	50 "FROM cross_section_lines csl JOIN cross_section_points csp " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	51 "ON csp.cross_section_line_id = csl.id " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	52 "WHERE csl.cross_section_id = :cs_id AND " +
3334 2ae732e2c65c FLYS backend: Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2380 diff changeset	53 "km between :from_km AND :to_km " +
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	54 "ORDER BY csl.id, csp.col_pos";
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	55
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	56 private Integer id;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	57 private River river;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	58 private TimeInterval timeInterval;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	59 private String description;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	60 private List<CrossSectionLine> lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 public CrossSection() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64
1204 22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	65 public CrossSection(
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	66 River river,
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	67 TimeInterval timeInterval,
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	68 String description
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	69 ) {
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	70 this.river = river;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	71 this.timeInterval = timeInterval;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	72 this.description = description;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	73 }
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	74
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 @Id
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 @SequenceGenerator(
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 name = "SEQUENCE_CROSS_SECTIONS_ID_SEQ",
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78 sequenceName = "CROSS_SECTIONS_ID_SEQ",
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 allocationSize = 1)
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80 @GeneratedValue(
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 strategy = GenerationType.SEQUENCE,
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 generator = "SEQUENCE_CROSS_SECTIONS_ID_SEQ")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 @Column(name = "id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 public Integer getId() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85 return id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88 public void setId(Integer id) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 this.id = id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 @OneToOne
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 @JoinColumn(name = "river_id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 public River getRiver() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 return river;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 public void setRiver(River river) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 this.river = river;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 @OneToOne
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 @JoinColumn(name = "time_interval_id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 public TimeInterval getTimeInterval() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 return timeInterval;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 public void setTimeInterval(TimeInterval timeInterval) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 this.timeInterval = timeInterval;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111
1202 44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	112 @Column(name = "description")
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	113 public String getDescription() {
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	114 return description;
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	115 }
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	116
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	117 public void setDescription(String description) {
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	118 this.description = description;
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	119 }
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	120
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 @OneToMany
1210 31d8638760b1 New. The hibernate models Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1204 diff changeset	122 @OrderBy("km")
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 @JoinColumn(name="cross_section_id")
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	124 public List<CrossSectionLine> getLines() {
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	125 return lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	128 public void setLines(List<CrossSectionLine> lines) {
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	129 this.lines = lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 }
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	131
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	132 public List<CrossSectionLine> getLines(double startKm, double endKm) {
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	133 Session session = SessionHolder.HOLDER.get();
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	134 Query query = session.createQuery(
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	135 "from CrossSectionLine where crossSection=:crossSection " +
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	136 "and km between :startKm and :endKm order by km");
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	137 query.setParameter("crossSection", this);
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	138 query.setParameter("startKm", new BigDecimal(startKm, PRECISION));
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	139 query.setParameter("endKm", new BigDecimal(endKm, PRECISION));
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	140
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	141 return query.list();
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	142 }
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	143
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	144 public List<FastCrossSectionLine> getFastLines(
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	145 double startKm,
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	146 double endKm
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	147 ) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	148 Session session = SessionHolder.HOLDER.get();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	149
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	150 SQLQuery sqlQuery = session.createSQLQuery(SQL_FAST_CROSS_SECTION_LINES)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	151 .addScalar("km", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	152 .addScalar("x", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	153 .addScalar("y", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	154 .addScalar("csl_id", StandardBasicTypes.INTEGER);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	155
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	156 sqlQuery
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	157 .setInteger("cs_id", getId())
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	158 .setDouble("from_km", startKm)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	159 .setDouble("to_km", endKm);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	160
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	161 List<Object []> results = sqlQuery.list();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	162
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	163 ArrayList<Point2D> points = new ArrayList<Point2D>(500);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	164 ArrayList<FastCrossSectionLine> lines =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	165 new ArrayList<FastCrossSectionLine>();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	166
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	167 Integer lastId = null;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	168 Double lastKm = null;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	169
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	170 for (Object [] result: results) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	171 Double km = (Double)result[0];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	172 Double x = (Double)result[1];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	173 Double y = (Double)result[2];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	174 Integer id = (Integer)result[3];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	175
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	176 if (lastId != null && !lastId.equals(id)) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	177 points.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	178 FastCrossSectionLine line =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	179 new FastCrossSectionLine(lastKm, points);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	180 lines.add(line);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	181 points = new ArrayList<Point2D>(500);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	182 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	183
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	184 Point2D p = new Point2D.Double(x, y);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	185
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	186 if (CrossSectionLine.isValid(p)) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	187 points.add(p);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	188 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	189
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	190 lastKm = km;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	191 lastId = id;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	192 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	193
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	194 if (lastId != null) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	195 points.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	196 FastCrossSectionLine line =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	197 new FastCrossSectionLine(lastKm, points);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	198 lines.add(line);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	199 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	200
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	201 lines.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	202
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	203 return lines;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	204 }
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 6229:3fea9701d58d