Mercurial > dive4elements > river

comparison backend/src/main/java/org/dive4elements/river/model/sinfo/DepthEvolutionValue.java @ 9032:1f63e9d3b0ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
New columns for bed_height, tkh and depth_evolution, a few syntactic corrections for Oracle
author mschaefer
date Fri, 27 Apr 2018 17:35:12 +0200
parents 50416a0df385
children
comparison
equal deleted inserted replaced
9031:efd2de78d158 9032:1f63e9d3b0ec
9 */ 9 */
10 10
11 package org.dive4elements.river.model.sinfo; 11 package org.dive4elements.river.model.sinfo;
12 12
13 import java.io.Serializable; 13 import java.io.Serializable;
14 import java.util.List;
14 15
15 import javax.persistence.Column; 16 import javax.persistence.Column;
16 import javax.persistence.Entity; 17 import javax.persistence.Entity;
17 import javax.persistence.GeneratedValue; 18 import javax.persistence.GeneratedValue;
18 import javax.persistence.GenerationType; 19 import javax.persistence.GenerationType;
19 import javax.persistence.Id; 20 import javax.persistence.Id;
20 import javax.persistence.JoinColumn; 21 import javax.persistence.JoinColumn;
21 import javax.persistence.OneToOne; 22 import javax.persistence.OneToOne;
22 import javax.persistence.SequenceGenerator; 23 import javax.persistence.SequenceGenerator;
23 import javax.persistence.Table; 24 import javax.persistence.Table;
25 import javax.persistence.Transient;
26
27 import org.dive4elements.river.backend.SessionHolder;
28 import org.hibernate.Query;
29 import org.hibernate.Session;
24 30
25 31
26 /** 32 /**
27 * Hibernate binding for the DB table depth_evolution_values 33 * Hibernate binding for the DB table depth_evolution_values
28 * 34 *
108 114
109 public void setTotal_change(final Double total_change) { 115 public void setTotal_change(final Double total_change) {
110 this.total_change = total_change; 116 this.total_change = total_change;
111 } 117 }
112 118
119 @Transient
120 public Double getTotalChangeCm() {
121 if (getTotal_change() != null)
122 return getTotal_change() * 100;
123 else
124 return null;
125 }
126
113 @Column(name = "change_per_year") 127 @Column(name = "change_per_year")
114 public Double getChange_per_year() { 128 public Double getChange_per_year() {
115 return this.change_per_year; 129 return this.change_per_year;
116 } 130 }
117 131
118 public void setChange_per_year(final Double change_per_year) { 132 public void setChange_per_year(final Double change_per_year) {
119 this.change_per_year = change_per_year; 133 this.change_per_year = change_per_year;
120 } 134 }
135
136 @Transient
137 public Double getPerYearChangeCm() {
138 if (getChange_per_year() != null)
139 return getChange_per_year() * 100;
140 else
141 return null;
142 }
143
144 /**
145 * Selects the depth evolution values of a data series in a km range from the database
146 */
147 public static List<DepthEvolutionValue> getValues(final DepthEvolution parent, final double kmLo, final double kmHi) {
148 final Session session = SessionHolder.HOLDER.get();
149 final Query query = session.createQuery("FROM DepthEvolutionValue WHERE (depthEvolution=:parent)"
150 + " AND (station >= :kmLo - 0.0001) AND (station <= :kmHi + 0.0001)");
151 query.setParameter("parent", parent);
152 query.setParameter("kmLo", new Double(kmLo));
153 query.setParameter("kmHi", new Double(kmHi));
154 return query.list();
155 }
121 } 156 }
http://dive4elements.wald.intevation.org