Mercurial > dive4elements > river
comparison flys-aft/src/main/java/de/intevation/aft/DischargeTable.java @ 4101:b6a18d706cbe
Added debugging for AFT time intervals.
flys-aft/trunk@3630 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 09 Jan 2012 15:34:19 +0000 |
parents | 006e99437fb9 |
children | e8967ee1cb05 |
comparison
equal
deleted
inserted
replaced
4100:981de0b77c6b | 4101:b6a18d706cbe |
---|---|
8 import java.sql.ResultSet; | 8 import java.sql.ResultSet; |
9 | 9 |
10 import de.intevation.db.SymbolicStatement; | 10 import de.intevation.db.SymbolicStatement; |
11 import de.intevation.db.ConnectedStatements; | 11 import de.intevation.db.ConnectedStatements; |
12 | 12 |
13 import org.apache.log4j.Logger; | |
14 | |
13 public class DischargeTable | 15 public class DischargeTable |
14 { | 16 { |
17 private static Logger log = Logger.getLogger(DischargeTable.class); | |
18 | |
15 protected int id; | 19 protected int id; |
16 protected int gaugeId; | 20 protected int gaugeId; |
17 protected TimeInterval timeInterval; | 21 protected TimeInterval timeInterval; |
18 protected String description; | 22 protected String description; |
19 protected List<WQ> values; | 23 protected List<WQ> values; |
207 .clearParameters() | 211 .clearParameters() |
208 .setString("number", "%" + officialNumber) | 212 .setString("number", "%" + officialNumber) |
209 .executeQuery(); | 213 .executeQuery(); |
210 | 214 |
211 while (rs.next()) { | 215 while (rs.next()) { |
212 int dtId = rs.getInt("ABFLUSSTAFEL_NR"); | 216 int dtId = rs.getInt("ABFLUSSTAFEL_NR"); |
213 Date from = rs.getDate("GUELTIG_VON"); | 217 Date from = rs.getDate("GUELTIG_VON"); |
214 Date to = rs.getDate("GUELTIG_BIS"); | 218 Date to = rs.getDate("GUELTIG_BIS"); |
219 | |
220 if (from != null && to != null && from.compareTo(to) > 0) { | |
221 log.warn("AFT: ABFLUSSTAFEL_NR = " | |
222 + dtId + ": " + from + " > " + to + ". -> swap"); | |
223 Date temp = from; | |
224 from = to; | |
225 to = temp; | |
226 } | |
227 | |
215 String description = rs.getString("ABFLUSSTAFEL_BEZ"); | 228 String description = rs.getString("ABFLUSSTAFEL_BEZ"); |
216 if (description == null) { | 229 if (description == null) { |
217 description = String.valueOf(officialNumber); | 230 description = String.valueOf(officialNumber); |
218 } | 231 } |
219 | 232 |