Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/main/java/de/intevation/gnv/transition/TransitionBase.java @ 83:5c8e54726a58
Added Support for Vertical Profiles Mesh
gnv-artifacts/trunk@113 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 23 Sep 2009 11:57:08 +0000 |
| parents | 5eb62df21f9a |
| children | c8d1f7b9e5a8 |
comparison
equal
deleted
inserted
replaced
| 82:5eb62df21f9a | 83:5c8e54726a58 |
|---|---|
| 293 Iterator<String> it = this.inputValueNames.iterator(); | 293 Iterator<String> it = this.inputValueNames.iterator(); |
| 294 int i = 0; | 294 int i = 0; |
| 295 while (it.hasNext()){ | 295 while (it.hasNext()){ |
| 296 String value = it.next(); | 296 String value = it.next(); |
| 297 InputData data = this.inputData.get(value); | 297 InputData data = this.inputData.get(value); |
| 298 int size = this.inputValues.get(data.getName()).usedInQueries(); | 298 if (data != null && this.inputValues.containsKey(data.getName())){ |
| 299 for (int j = 0; j < size; j++){ | 299 int size = this.inputValues.get(data.getName()).usedInQueries(); |
| 300 list.add(data.getValue()); | 300 String type = this.inputValues.get(data.getName()).getType(); |
| 301 String requestValue = data.getValue(); | |
| 302 if (type.equalsIgnoreCase("string")){ | |
| 303 requestValue = this.prepareInputData4DBQuery(requestValue); | |
| 304 }else if (type.equalsIgnoreCase("date")){ | |
| 305 requestValue = this.prepareInputData4DateDBQuery(requestValue); | |
| 306 } | |
| 307 for (int j = 0; j < size; j++){ | |
| 308 list.add(requestValue); | |
| 309 } | |
| 301 } | 310 } |
| 302 } | 311 } |
| 303 String[] filterValues = list.toArray(new String[0]); | 312 String[] filterValues = list.toArray(new String[0]); |
| 304 Collection<Result> result = null; | 313 Collection<Result> result = null; |
| 305 try { | 314 try { |
| 313 } | 322 } |
| 314 } catch (QueryException e) { | 323 } catch (QueryException e) { |
| 315 log.error(e,e); | 324 log.error(e,e); |
| 316 throw new TransitionException(e); | 325 throw new TransitionException(e); |
| 317 } | 326 } |
| 327 } | |
| 328 | |
| 329 private String prepareInputData4DateDBQuery(String value){ | |
| 330 if (value != null){ | |
| 331 String[] values = value.split(","); | |
| 332 String newValue = ""; | |
| 333 for (int i = 0; i < values.length; i++){ | |
| 334 if (newValue.length() > 0){ | |
| 335 newValue= newValue + " , "; | |
| 336 } | |
| 337 newValue = "to_date('"+values[0].trim()+"', 'YYYY.MM.DD HH24:MI:SS')"; // TODO JUST HACK FIND A BETTER RESOLUTION | |
| 338 } | |
| 339 return newValue; | |
| 340 } | |
| 341 | |
| 342 return value; | |
| 343 } | |
| 344 private String prepareInputData4DBQuery(String value){ | |
| 345 if (value != null){ | |
| 346 String[] values = value.split(","); | |
| 347 String newValue = ""; | |
| 348 for (int i = 0; i < values.length; i++){ | |
| 349 if (newValue.length() > 0){ | |
| 350 newValue= newValue + " , "; | |
| 351 } | |
| 352 newValue = "'"+values[0].trim()+"'"; | |
| 353 } | |
| 354 return newValue; | |
| 355 } | |
| 356 | |
| 357 return value; | |
| 358 | |
| 318 } | 359 } |
| 319 | 360 |
| 320 /** | 361 /** |
| 321 * @param result | 362 * @param result |
| 322 */ | 363 */ |