Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/FixingsOverview.java @ 5725:0cab1c884e72
Doc.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Tue, 16 Apr 2013 12:36:43 +0200 |
| parents | 61f4d4164a30 |
| children | 948d07aa988a |
comparison
equal
deleted
inserted
replaced
| 5724:ea183a2eee0b | 5725:0cab1c884e72 |
|---|---|
| 37 " km_up " + | 37 " km_up " + |
| 38 "FROM rivers " + | 38 "FROM rivers " + |
| 39 "WHERE" + | 39 "WHERE" + |
| 40 " name = :name"; | 40 " name = :name"; |
| 41 | 41 |
| 42 /** All kind-2 wsts from given river. */ | |
| 42 public static final String SQL_FIXINGS = | 43 public static final String SQL_FIXINGS = |
| 43 "SELECT" + | 44 "SELECT" + |
| 44 " id AS wst_id," + | 45 " id AS wst_id," + |
| 45 " description " + | 46 " description " + |
| 46 "FROM wsts " + | 47 "FROM wsts " + |
| 47 "WHERE" + | 48 "WHERE" + |
| 48 " river_id = :river_id AND kind = 2"; | 49 " river_id = :river_id AND kind = 2"; |
| 49 | 50 |
| 51 /** All columns from given wst. */ | |
| 50 public static final String SQL_FIXING_COLUMNS = | 52 public static final String SQL_FIXING_COLUMNS = |
| 51 "SELECT" + | 53 "SELECT" + |
| 52 " wc.id AS wst_column_id," + | 54 " wc.id AS wst_column_id," + |
| 53 " ti.start_time AS start_time," + | 55 " ti.start_time AS start_time," + |
| 54 " wc.name AS name " + | 56 " wc.name AS name " + |
| 325 for (Column column: columns) { | 327 for (Column column: columns) { |
| 326 column.loadQRanges(query, gaugeFinder); | 328 column.loadQRanges(query, gaugeFinder); |
| 327 } | 329 } |
| 328 } | 330 } |
| 329 | 331 |
| 332 /** | |
| 333 * @param allColumns[out] Columns will be put here. | |
| 334 * @param range can be null. | |
| 335 * @param filter filter to apply. | |
| 336 */ | |
| 330 public void addAllColumns( | 337 public void addAllColumns( |
| 331 List<Column> allColumns, | 338 List<Column> allColumns, |
| 332 Range range, | 339 Range range, |
| 333 Filter filter | 340 Filter filter |
| 334 ) { | 341 ) { |
| 560 public boolean accept(Fixing.Column column) { | 567 public boolean accept(Fixing.Column column) { |
| 561 return column.getId() == columnId; | 568 return column.getId() == columnId; |
| 562 } | 569 } |
| 563 } // class IdFilter | 570 } // class IdFilter |
| 564 | 571 |
| 572 /** Accept Fixing columns whose id is in id list. */ | |
| 565 public static class IdsFilter implements Fixing.Filter { | 573 public static class IdsFilter implements Fixing.Filter { |
| 566 | 574 |
| 567 protected int [] columnIds; | 575 protected int [] columnIds; |
| 568 | 576 |
| 569 public IdsFilter(int [] columnIds) { | 577 public IdsFilter(int [] columnIds) { |