if (empty($_SESSION['gereinigt.year'])) $_SESSION['gereinigt.year'] = date('Y');
+$details = <<<EOC
+<div style="padding-left: 3px; margin-top: -10px;">
+<b>Bemerkungen</b><br>
+<div id="detail_bemerkungen"></div>
+</div>
+EOC;
+
$mask = array(
'table' => 'kostenstellen',
'title' => 'Gewässer gereinigt?',
),
),
),
+ 'details' => array(
+ 'html' => $details,
+ 'list' => array(
+ 'bemerkungen' => array('fetch' => fetch_bemerkungen),
+ ),
+
+ ),
);
+function fetch_bemerkungen()
+{
+ $sql = <<<EOC
+SELECT datum, bemerkung FROM einsatz
+WHERE date_part('year', datum) = %d
+ AND kostenstelle = %d
+ AND bemerkung IS NOT NULL
+ORDER BY datum
+EOC;
+
+ $sql = sprintf($sql, $_SESSION['gereinigt.year'], $_POST['id']);
+
+ $res = query_db($sql);
+ if ($res === false) return '';
+
+ if (!count($res)) return 'keine Bemerkungen vorhanden';
+
+ $ret = '';
+ foreach ($res as $row) {
+ $d = explode('-',$row['datum']);
+ $ret .= sprintf('<p style="margin-top: 0; margin-bottom: 2px;">%d.%d: %s</p>', $d[2], $d[1], $row['bemerkung']);
+ }
+
+ return $ret;
+}
?>