view etl/src/main/resources/sql/aft-common.properties @ 8449:f61e2791ccdf

(issue1733) Fix locationdistancepanel There is now a central method to setup the listgrids and connect the Input completion pins. The old variant with three tables was broken and had did many duplicated things. Comments should also be clearer to point out which code path belongs to which input state.
author Andre Heinecke <andre.heinecke@intevation.de>
date Mon, 27 Oct 2014 17:00:40 +0100
parents 5aa05a7a34b7
children
line wrap: on
line source
select.gewaesser = \
    SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER
select.messstelle = \
    SELECT NAME, MESSSTELLE_NR, STATIONIERUNG \
    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, \
           BFG_ID \
    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
select.bfg.id.current = \
    SELECT ABT.BFG_ID AS BFG_ID FROM ABFLUSSTAFEL ABT \
    WHERE GUELTIG_VON IN ( \
        SELECT min(GUELTIG_VON) FROM ABFLUSSTAFEL \
        WHERE GUELTIG_VON IS NOT NULL AND GUELTIG_BIS IS NULL \
        AND MESSSTELLE_NR LIKE :number) \
    AND MESSSTELLE_NR LIKE :number

http://dive4elements.wald.intevation.org