Bemerkungen
EOC;
function gebiete()
{
$sql = "SELECT id,gebiet FROM gebiet ORDER BY id";
$sth = pg_query($sql);
$result = array();
while ($row = pg_fetch_assoc($sth))
$result[] = sprintf("%d: '%s'", $row['id'], $row['gebiet']);
return '{' . implode(', ', $result) . '}';
}
$mask = array(
'table' => 'kostenstellen',
'title' => 'Gewässer gereinigt?',
'select' => array(
'title' => 'Auswahl',
'options' => discover_years(true),
'default' => 'Jahr wählen',
'selected' => $_SESSION['gereinigt.year'],
'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
),
'variables' => array(
'year' => array(),
),
'list' => array(
'id' => array(
'name' => 'ID',
'sql' => 'kostenstellen.id',
'visible' => false,
),
'gebiet' => array(
'name' => 'Gebiet',
'sql' => 'gebiet',
'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
'specs' => "filterUI: 's'",
'width' => 270,
),
'kostenstelle' => array(
'name' => 'Kostenstelle',
'specs' => "filterUI: 's'",
'width' => 270,
),
'gereinigt' => array(
'name' => 'gereinigt',
'width' => 65,
'sql' => '(SELECT count(*) FROM gereinigt WHERE jahr = '
. intval($_SESSION['gereinigt.year'])
. ' AND gereinigt.kostenstelle = kostenstellen.id)',
'control' => "new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')",
'specs' => "filterUI: 'c', ClassName: 'aligncenter', canSort: false",
'update' => array('table' => 'gereinigt',
'basecol' => 'jahr',
'baseval' => $_SESSION['gereinigt.year'],
'refcol' => 'kostenstelle',
'reftable' => 'kostenstellen',
'refid' => 'kostenstellen.id',
),
),
),
'details' => array(
'html' => $details,
'list' => array(
'bemerkungen' => array('fetch' => fetch_bemerkungen),
),
),
);
function fetch_bemerkungen()
{
$sql = <<%d.%d: %s', $d[2], $d[1], $row['bemerkung']);
}
return $ret;
}
?>