3 $jscode[] = "Rico.moduleDependencies['checkboxDB'] = ['+LiveGrid', '../ricoTableColumnDB.js'];";
4 $jscode[] = "Rico.loadModule('checkboxDB');";
6 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
8 if (empty($_SESSION['gereinigt.year'])) $_SESSION['gereinigt.year'] = date('Y');
11 <div style="padding-left: 3px; margin-top: -10px;">
12 <b>Bemerkungen</b><br>
13 <div id="detail_bemerkungen"></div>
19 $sql = "SELECT id,gebiet FROM gebiet ORDER BY id";
20 $sth = pg_query($sql);
23 while ($row = pg_fetch_assoc($sth))
24 $result[] = sprintf("%d: '%s'", $row['id'], $row['gebiet']);
26 return '{' . implode(', ', $result) . '}';
30 'table' => 'kostenstellen',
31 'title' => 'Gewässer gereinigt?',
34 'options' => discover_years(true),
35 'default' => 'Jahr wählen',
36 'selected' => $_SESSION['gereinigt.year'],
37 'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
45 'sql' => 'kostenstellen.id',
51 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
52 'specs' => "filterUI: 's'",
55 'kostenstelle' => array(
56 'name' => 'Kostenstelle',
57 'specs' => "filterUI: 's'",
61 'name' => 'gereinigt',
63 'sql' => '(SELECT count(*) FROM gereinigt WHERE jahr = '
64 . intval($_SESSION['gereinigt.year'])
65 . ' AND gereinigt.kostenstelle = kostenstellen.id)',
66 'control' => "new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')",
67 'specs' => "filterUI: 'c', ClassName: 'aligncenter', canSort: false",
68 'update' => array('table' => 'gereinigt',
70 'baseval' => $_SESSION['gereinigt.year'],
71 'refcol' => 'kostenstelle',
72 'reftable' => 'kostenstellen',
73 'refid' => 'kostenstellen.id',
80 'bemerkungen' => array('fetch' => fetch_bemerkungen),
86 function fetch_bemerkungen()
89 SELECT datum, bemerkung FROM einsatz
90 WHERE date_part('year', datum) = %d
92 AND bemerkung IS NOT NULL
96 $sql = sprintf($sql, $_SESSION['gereinigt.year'], $_POST['id']);
98 $res = query_db($sql);
99 if ($res === false) return '';
101 if (!count($res)) return 'keine Bemerkungen vorhanden';
104 foreach ($res as $row) {
105 $d = explode('-',$row['datum']);
106 $ret .= sprintf('<p style="margin-top: 0; margin-bottom: 2px;">%d.%d: %s</p>', $d[2], $d[1], $row['bemerkung']);