Display gebiet
authorJoey Schulze <joey@infodrom.org>
Wed, 10 Mar 2010 15:06:34 +0000 (16:06 +0100)
committerJoey Schulze <joey@infodrom.org>
Wed, 10 Mar 2010 15:06:34 +0000 (16:06 +0100)
masks/materialverbrauch.php

index c5079bf..9855fc1 100644 (file)
@@ -39,11 +39,15 @@ function fetch_tbody()
 $mask = array(
              'table' => 'einsatz',
              'title' => 'Materialverbrauch zu Arbeitsberichten',
-             'join' => array('kostenstellen ON einsatz.kostenstelle = kostenstellen.id'),
+             'join' => array(
+                             'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
+                             'gebiet ON kostenstellen.gebiet = gebiet.id',
+                             ),
              'list' => array(
                              'id' => array(
                                            'name' => 'ID',
                                            'sql' => 'einsatz.id',
+                                           'width' => 60,
                                            'visible' => false,
                                            ),
                              'datum' => array(
@@ -51,6 +55,11 @@ $mask = array(
                                            'type' => 'date',
                                            'width' => 70,
                                            ),
+                             'gebiet' => array(
+                                           'name' => 'Gebiet',
+                                           'width' => 230,
+                                           'sql' => 'gebiet.gebiet',
+                                           ),
                              'kostenstelle' => array(
                                            'name' => 'Kostenstelle',
                                            'width' => 230,