view flys-aft/src/main/resources/sql/aft-common.properties @ 4198:1cdbd8a0c994

Added two new tables ClickableQDTable and ClickableWTable and made Ws and Qs clickable in historical discharge calculation. The new tables define listener interfaces (clicked lower or upper icon) to listen to user clicks. In addition to this, there is an enum ClickMode with NONE, SINGLE and RANGE options, which allows to specifiy, which icons are displayed in the tables. NONE means no icon for user clicks, SINGLE has 1 icon, RANGE 2 icons for lower and upper.
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 22 Oct 2012 13:31:25 +0200
parents a91c7e982c32
children 04377ccef10a
line wrap: on
line source
select.gewaesser = SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER
select.messstelle = SELECT NAME, MESSSTELLE_NR FROM MESSSTELLE WHERE GEWAESSER_NR = :GEWAESSER_NR
select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \
                             ABFLUSSTAFEL_BEZ, \
                             strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \
                             strftime('%s', GUELTIG_BIS) * 1000 AS GUELTIG_BIS, \
                             PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number
select.tafelwert = SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
                          WHERE ABFLUSSTAFEL_NR = :number

http://dive4elements.wald.intevation.org