changeset 7190:851fc99be4bc

issue1435: meta-data.xml: Add sedimentload/yield- part to minfo part of dc.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Fri, 27 Sep 2013 14:42:03 +0200
parents 4c8ce0c41dc2
children 7bd19eff9bca
files artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 30 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml	Fri Sep 27 14:40:39 2013 +0200
+++ b/artifacts/doc/conf/meta-data.xml	Fri Sep 27 14:42:03 2013 +0200
@@ -1225,9 +1225,39 @@
           <dc:call-macro name="basedata_7_waterlevels"/>
           <dc:call-macro name="minfo-heights"/>
           <dc:call-macro name="sounding-width"/>
+          <dc:call-macro name="yields"/>
       </minfo>
     </dc:macro>
 
+    <dc:macro name="yields">
+      <dc:context>
+        <dc:statement>
+            SELECT DISTINCT
+                sy.id AS syid,
+                sy.description AS description,
+                ti.start_time AS year
+            FROM     sediment_yield sy
+                JOIN rivers r ON sy.river_id = r.id
+                JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id
+                JOIN time_intervals ti ON sy.time_interval_id = ti.id
+            WHERE   r.name = 'Elbe'
+                AND ti.stop_time IS NULL
+                AND syv.station BETWEEN ${fromkm} AND ${tokm}
+        </dc:statement>
+        <dc:if test="dc:has-result()">
+          <dc:for-each>
+            <year description="{$description}"
+                    factory="sedimentyield"
+                    target_out="{$out}"
+                    info="infome"
+                  ids="{$syid}" />
+<!-- or epoch -->
+          </dc:for-each>
+        </dc:if>
+      </dc:context>
+    </dc:macro>
+
+
     <dc:macro name="basedata_5_flood-protections">
       <dc:filter expr="$kind=5">
         <dc:if test="dc:has-result()">

http://dive4elements.wald.intevation.org