view flys-aft/src/main/resources/sql/aft-common.properties @ 4478:6153c50f78cf

WaterLineArtifact: Added callcontext-parameter to interfaces getWaterLine. Update all implementations. The change was done to be able to compute the extreme values during getWaterLine to access data needed in CrossSectionProfile Diagrams.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Tue, 13 Nov 2012 14:46:44 +0100
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