Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/GaugeFinderFactory.java @ 3421:c44ff50f4970
FixA: Added a list of gauges to the output of the fixings overview service which intersect the selected fixings.
flys-artifacts/trunk@5075 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 19 Jul 2012 21:12:57 +0000 |
| parents | 368d1837ce5d |
| children | 61f4d4164a30 |
comparison
equal
deleted
inserted
replaced
| 3420:7f7ab030a4e3 | 3421:c44ff50f4970 |
|---|---|
| 26 public static final String CACHE_NAME = "gauge-finders"; | 26 public static final String CACHE_NAME = "gauge-finders"; |
| 27 | 27 |
| 28 public static final String SQL_GAUGES = | 28 public static final String SQL_GAUGES = |
| 29 "SELECT" + | 29 "SELECT" + |
| 30 " g.id AS gauge_id," + | 30 " g.id AS gauge_id," + |
| 31 " g.name AS name," + | |
| 31 " r.a AS a," + | 32 " r.a AS a," + |
| 32 " r.b AS b " + | 33 " r.b AS b " + |
| 33 "FROM gauges g" + | 34 "FROM gauges g" + |
| 34 " JOIN ranges r ON g.range_id = r.id " + | 35 " JOIN ranges r ON g.range_id = r.id " + |
| 35 "WHERE" + | 36 "WHERE" + |
| 87 int riverId, | 88 int riverId, |
| 88 boolean isKmUp | 89 boolean isKmUp |
| 89 ) { | 90 ) { |
| 90 SQLQuery query = session.createSQLQuery(SQL_GAUGES) | 91 SQLQuery query = session.createSQLQuery(SQL_GAUGES) |
| 91 .addScalar("gauge_id", StandardBasicTypes.INTEGER) | 92 .addScalar("gauge_id", StandardBasicTypes.INTEGER) |
| 93 .addScalar("name", StandardBasicTypes.STRING) | |
| 92 .addScalar("a", StandardBasicTypes.DOUBLE) | 94 .addScalar("a", StandardBasicTypes.DOUBLE) |
| 93 .addScalar("b", StandardBasicTypes.DOUBLE); | 95 .addScalar("b", StandardBasicTypes.DOUBLE); |
| 94 | 96 |
| 95 query.setInteger("river_id", riverId); | 97 query.setInteger("river_id", riverId); |
| 96 | 98 |
| 103 | 105 |
| 104 List<GaugeRange> gauges = new ArrayList<GaugeRange>(); | 106 List<GaugeRange> gauges = new ArrayList<GaugeRange>(); |
| 105 | 107 |
| 106 for (Object [] row: list) { | 108 for (Object [] row: list) { |
| 107 int gaugeId = (Integer)row[0]; | 109 int gaugeId = (Integer)row[0]; |
| 108 double start = (Double) row[1]; | 110 String name = (String) row[1]; |
| 109 double end = (Double) row[2]; | 111 double start = (Double) row[2]; |
| 110 GaugeRange gauge = new GaugeRange(start, end, gaugeId); | 112 double end = (Double) row[3]; |
| 113 GaugeRange gauge = new GaugeRange(start, end, name, gaugeId); | |
| 111 gauges.add(gauge); | 114 gauges.add(gauge); |
| 112 } | 115 } |
| 113 | 116 |
| 114 return new GaugeFinder(gauges, isKmUp); | 117 return new GaugeFinder(gauges, isKmUp); |
| 115 } | 118 } |