From 03740fd8faf23b8f51e28ee27190cff452b54238 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Tue, 9 Mar 2010 20:42:46 +0100
Subject: [PATCH] Add type reference table geraetetypen for geraete and
 anbaugeraete

---
 masks/anbaugeraete.php | 12 ++++++++++++
 masks/geraete.php      | 12 ++++++++++++
 2 files changed, 24 insertions(+)

diff --git a/masks/anbaugeraete.php b/masks/anbaugeraete.php
index d4ea0c7..626795e 100644
--- a/masks/anbaugeraete.php
+++ b/masks/anbaugeraete.php
@@ -3,15 +3,22 @@
 $mask = array(
 	      'table' => 'anbaugeraete',
 	      'title' => 'Anbaugeräte',
+	      'join' => array('geraetetypen ON anbaugeraete.geraetetyp = geraetetypen.id'),
 	      'list' => array(
 			      'id' => array(
 					    'name' => 'ID',
 					    'visible' => false,
+					    'sql' => 'anbaugeraete.id',
 					    ),
 			      'anbaugeraet' => array(
 					    'name' => 'Anbaugerät',
 					    'width' => 150,
 					    ),
+			      'geraetetyp' => array(
+					    'name' => 'Gerätetyp',
+					    'width' => 70,
+					    'sql' => 'geraetetypen.name',
+					    ),
 			      'anbgerstdsatz' => array(
 					    'name' => 'Stundensatz',
 					    'type' => 'number',
@@ -38,6 +45,11 @@ $mask = array(
 					    'size' => 24,
 					    'required' => true,
 					    ),
+			      'geraetetyp' => array(
+					    'name' => 'Gerätetyp',
+					    'type' => 'select',
+					    'options' => 'SELECT id,name AS text FROM geraetetypen ORDER BY name',
+					    ),
 			      'anbgerstdsatz' => array(
 					    'name' => 'Stundensatz',
 					    'type' => 'decimal',
diff --git a/masks/geraete.php b/masks/geraete.php
index fc00430..2c961db 100644
--- a/masks/geraete.php
+++ b/masks/geraete.php
@@ -3,16 +3,23 @@
 $mask = array(
 	      'table' => 'gerate',
 	      'title' => 'Geräte',
+	      'join' => array('geraetetypen ON gerate.geraetetyp = geraetetypen.id'),
 	      'sort' => 1,
 	      'list' => array(
 			      'id' => array(
 					    'name' => 'ID',
 					    'visible' => false,
+					    'sql' => 'gerate.id',
 					    ),
 			      'geraet' => array(
 					    'name' => 'Gerät',
 					    'width' => 200,
 					    ),
+			      'geraetetyp' => array(
+					    'name' => 'Gerätetyp',
+					    'width' => 70,
+					    'sql' => 'geraetetypen.name',
+					    ),
 			      'gerstdsatz' => array(
 					    'name' => 'Stundensatz',
 					    'type' => 'number',
@@ -39,6 +46,11 @@ $mask = array(
 					    'size' => 24,
 					    'required' => true,
 					    ),
+			      'geraetetyp' => array(
+					    'name' => 'Gerätetyp',
+					    'type' => 'select',
+					    'options' => 'SELECT id,name AS text FROM geraetetypen ORDER BY name',
+					    ),
 			      'gerstdsatz' => array(
 					    'name' => 'Stundensatz',
 					    'type' => 'decimal',
-- 
2.20.1