view flys-aft/src/main/resources/sql/flys-common.properties @ 4556:5e25a2b19ddd

Add GaugeOverview to Fixanalysis Show the gauge info panel when the fixanalysis is selected. Currently all entries in the tree are expanded independend from the selected ranges in the fixanalysis.
author Björn Ricks <bjoern.ricks@intevation.de>
date Fri, 16 Nov 2012 12:33:25 +0100
parents 8ba11e13ae8a
children a310aceb2e51
line wrap: on
line source
select.river = SELECT id, name FROM rivers 
select.gauges = SELECT id, name, official_number FROM gauges WHERE river_id = :river_id
next.gauge.id = SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id
insert.gauge = INSERT INTO gauges (id, name, river_id, station, aeo, official_number, datum) \
                      VALUES(:id, :name, :river_id, :station, :aeo, :official_number, :datum)
select.timeintervals = SELECT id, start_time, stop_time FROM time_intervals
next.timeinterval.id = SELECT NEXTVAL('TIME_INTERVALS_ID_SEQ') AS time_interval_id
insert.timeinterval = INSERT INTO time_intervals (id, start_time, stop_time) VALUES (:id, :start_time, :stop_time)
next.discharge.id = SELECT NEXTVAL('DISCHARGE_TABLES_ID_SEQ') AS discharge_table_id
insert.dischargetable = INSERT INTO discharge_tables (id, gauge_id, description, kind, time_interval_id) \
                        VALUES (:id, :gauge_id, :description, 1, :time_interval_id)
select.discharge.table.values = SELECT id, w, q FROM discharge_table_values WHERE table_id = :table_id
next.discharge.table.values.id = SELECT NEXTVAL('DISCHARGE_TABLE_VALUES_ID_SEQ') AS discharge_table_values_id
insert.discharge.table.value = INSERT INTO discharge_table_values (id, table_id, w, q) VALUES (:id, :table_id, :w, :q)
delete.discharge.table.value = DELETE FROM discharge_table_values WHERE id = :id
select.gauge.discharge.tables = SELECT dt.id AS id, dt.description AS description, ti.start_time AS start_time, ti.stop_time AS stop_time \
                               FROM discharge_tables dt LEFT OUTER JOIN time_intervals ti ON dt.time_interval_id = ti.id \
                               WHERE gauge_id = :gauge_id

http://dive4elements.wald.intevation.org