# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1342187006 0
# Node ID 81a98f360553205197e90f8dee2111a8c731ac52
# Parent  1b41dc00b1f7168d9cf617ac8f55a0addefe86fe
Very basic official lines in dc, malplaced.

flys-artifacts/trunk@4995 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 1b41dc00b1f7 -r 81a98f360553 flys-artifacts/ChangeLog
--- a/flys-artifacts/ChangeLog	Fri Jul 13 12:41:44 2012 +0000
+++ b/flys-artifacts/ChangeLog	Fri Jul 13 13:43:26 2012 +0000
@@ -1,3 +1,9 @@
+2012-07-13	Felix Wolfsteller	<felix.wolfsteller@intevation.de>
+
+	* doc/conf/meta-data.xml: very basic official lines matching the current
+	  artifact (for this it is wrongly placed in previous calc.-part, for
+	  now.
+
 2012-07-13	Christian Lins	<christian.lins@intevation.de>
 
 	* src/main/java/de/intevation/flys/utils/MapfileGenerator.java:
diff -r 1b41dc00b1f7 -r 81a98f360553 flys-artifacts/doc/conf/meta-data.xml
--- a/flys-artifacts/doc/conf/meta-data.xml	Fri Jul 13 12:41:44 2012 +0000
+++ b/flys-artifacts/doc/conf/meta-data.xml	Fri Jul 13 13:43:26 2012 +0000
@@ -1170,6 +1170,39 @@
             ORDER BY c.creation DESC
         </dc:statement>
 
+        <!-- OFFICIAL LINES -->
+        <dc:if test="dc:contains($artifact-outs, 'longitudinal_section')">
+          <dc:comment comment=".wst -------------------------------"/>
+          <officiallines>
+            <dc:elements>
+                <dc:context>
+                  <dc:statement>
+                    SELECT m.id AS a_id, m.state AS a_state, m.gid AS a_gid, m.creation AS a_creation, ardg.v as gaugy, arv.v as wqsingle
+                    FROM   master_artifacts m, artifact_data ardg, artifact_data arv
+                    WHERE  m.collection_id = ${collection_id} AND m.gid = CAST(${artifact-id} AS uuid) AND ardg.artifact_id = m.id AND ardg.k = 'ld_gaugename' AND arv.artifact_id = m.id AND arv.k = 'wq_single'
+                    AND EXISTS (
+                        SELECT id FROM artifact_data ad WHERE ad.artifact_id = m.id AND k = 'river' AND v = ${river})
+                  </dc:statement>
+                  <dc:elements>
+                      <dc:context connection="system">
+                        <dc:statement>
+                          SELECT ol.wst_id AS wstid, ol.wst_column_pos AS wstcolpos, ol.name AS olname, ol.value AS oval
+                          FROM official_q_values ol
+                          WHERE ol.value = CAST(${wqsingle} AS NUMERIC(10,2)) AND ol.gauge_name = ${gaugy}
+                        </dc:statement>
+                        <dc:elements>
+                          <dc:element name="${olname}">
+                            <dc:attribute name="name" value="${olname}"/>
+                            <dc:attribute name="ids" value="additionals-wstv-${wstcolpos}-${wstid}"/>
+                            <dc:attribute name="factory" value="staticwkms"/>
+                          </dc:element>
+                        </dc:elements>
+                      </dc:context>
+                  </dc:elements>
+                </dc:context>
+          </dc:elements>
+          </officiallines>
+        </dc:if>
 
         <dc:comment>
           SHOW W-DIFFERENCES