Mercurial > dive4elements > river

annotate flys-aft/src/main/resources/sql/aft-common.properties @ 4604:488db475613d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add methods to hide and show the manage projects button of the header It should be possible to show the manage projects button only if the ProjectList is hidden. Therefore add methods to allow to show and hide the button.
author Björn Ricks <bjoern.ricks@intevation.de>
date Fri, 30 Nov 2012 10:00:39 +0100
parents a91c7e982c32
children 04377ccef10a
rev   line source
4068
21e49e0a2307 Add infrastructure to load SQL statements for databases.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 select.gewaesser = SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER
4076
039413d7e394 Load gauges from both dbs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4068
diff changeset
2 select.messstelle = SELECT NAME, MESSSTELLE_NR FROM MESSSTELLE WHERE GEWAESSER_NR = :GEWAESSER_NR
4088
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
3 select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \
4090
d556e29592f5 Create new discharge tables if needed.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4088
diff changeset
4 ABFLUSSTAFEL_BEZ, \
4088
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
5 strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
6 strftime('%s', GUELTIG_BIS) * 1000 AS GUELTIG_BIS, \
52cde7fe742a Fetch discharge table infos from AFT.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4076
diff changeset
7 PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number
4091
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
8 select.tafelwert = SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
a91c7e982c32 Make W/Q values from AFT and FLYS loadable.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 4090
diff changeset
9 WHERE ABFLUSSTAFEL_NR = :number
4068
21e49e0a2307 Add infrastructure to load SQL statements for databases.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10
http://dive4elements.wald.intevation.org