Use Rico.TableColumn.lookup and table for some columns

[misc/kostenrechnung] / masks / overview_kostenstellen.php

diff --git a/masks/overview_kostenstellen.php b/masks/overview_kostenstellen.php
index 0fae553..9bc7e6f 100644 (file)
--- a/masks/overview_kostenstellen.php
+++ b/masks/overview_kostenstellen.php
@@ -4,10 +4,21 @@ include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
 
 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(),
@@ -27,9 +38,10 @@ $mask = array(
                                            ),
                              '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',