# HG changeset patch
# User "Tom Gottfried <tom@intevation.de>"
# Date 1401457613 -7200
# Node ID 34fa3f8c20ed173efe005f73d21ab3bce0665e86
# Parent  8b8407c71ee2fd860b5877ea1cf5f4eebd04ea2e
issue661: prototyped tooltip for porosities in datacage.

diff -r 8b8407c71ee2 -r 34fa3f8c20ed artifacts/doc/conf/meta-data.xml
--- a/artifacts/doc/conf/meta-data.xml	Wed May 28 12:26:13 2014 +0200
+++ b/artifacts/doc/conf/meta-data.xml	Fri May 30 15:46:53 2014 +0200
@@ -1334,12 +1334,16 @@
                 p.id          AS pid,
                 p.description AS description,
                 d.lower        AS depth_lower,
-                d.upper        AS depth_upper
+                d.upper        AS depth_upper,
+                p.description  || '&lt;BR&gt;' ||
+                'Tiefe: ' || d.lower || ' - ' || d.upper 
+                    || ' cm &lt;BR&gt;' ||
+                'Zeitraum: ' || t.start_time || ' - ' || t.stop_time
+                AS info
             FROM     porosity p
                 JOIN depths d ON p.depth_id = d.id
-                JOIN porosity_values pv on pv.porosity_id = p.id
+                JOIN time_intervals t ON p.time_interval_id=t.id
             WHERE   p.river_id = ${river_id}
-            GROUP BY p.id, p.description, d.upper, d.lower
             ORDER BY depth_lower, depth_upper
         </dc:statement>
         <dc:if test="dc:has-result()">
@@ -1347,7 +1351,7 @@
                   <porosity description="{$depth_lower}-{$depth_upper} cm"
                    factory="porosity"
                    target_out="{$out}"
-                   info="{$description}"
+                   info="{$info}"
                    ids="{$pid};{$description}" />
           </dc:for-each>
         </dc:if>