</div>
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?',
- 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
'select' => array(
'title' => 'Auswahl',
'options' => discover_years(true),
),
'gebiet' => array(
'name' => 'Gebiet',
- 'sql' => 'gebiet.gebiet',
+ 'sql' => 'gebiet',
+ 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
'specs' => "filterUI: 's'",
'width' => 270,
),
return delete_or_copy_row($mask['table'], $id);
}
+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' => 'einsatz',
'tables_delete' => array('einsatzpersonal','einsatzgeraete'),
'title' => 'Korrektur von Arbeitsberichten',
'join' => array(
'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
- 'gebiet ON kostenstellen.gebiet = gebiet.id',
),
'list' => array(
'id' => array(
'gebiet' => array(
'name' => 'Gebiet',
'width' => 230,
- 'sql' => 'gebiet.gebiet',
+ 'sql' => 'einsatz.gebiet',
+ 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
'specs' => "filterUI: 's'",
),
'kostenstelle' => array(
<?php
+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' => 'Kostenstellen',
- 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
'list' => array(
'id' => array(
'name' => 'ID',
),
'gebiet' => array(
'name' => 'Gebiet',
- 'sql' => 'gebiet.gebiet',
+ 'sql' => 'kostenstellen.gebiet',
+ 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
'specs' => "filterUI: 's'",
'width' => 220,
),
if (empty($_SESSION['overview_kostenstellen.year'])) $_SESSION['overview_kostenstellen.year'] = 0;
+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' => 'Übersicht nach Kostenstellen',
- 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
'select' => array(
'title' => 'Auswahl',
'options' => discover_years(),
),
'gebiet' => array(
'name' => 'Gebiet',
- 'sql' => "gebiet.gebiet",
+ 'sql' => 'kostenstellen.gebiet',
+ 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
'width' => 220,
- 'specs' => "filterUI: 't'",
+ 'specs' => "filterUI: 's'",
),
'kostenstelle' => array(
'name' => 'Gewässer',