Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/sinfo/DepthEvolutionValue.java @ 9032:1f63e9d3b0ec
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 } |