From: Joey Schulze <joey@infodrom.org>
Date: Sat, 27 Feb 2010 22:16:49 +0000 (+0100)
Subject: Single group allowed for users, support it via select
X-Git-Tag: 2010-06-02_customer~183
X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=commitdiff_plain;h=c02b49eaa348d3de63be83beb9f12b7558706722

Single group allowed for users, support it via select
---

diff --git a/masks/sys_user.php b/masks/sys_user.php
index a5a47f6..358975f 100644
--- a/masks/sys_user.php
+++ b/masks/sys_user.php
@@ -3,10 +3,12 @@
 $mask = array(
 	      'table' => 'sys_user',
 	      'title' => 'Liste der Anwender',
+	      'join' => array('sys_group ON sys_user.gid = sys_group.id'),
 	      'list' => array(
 			      'id' => array(
 					    'name' => 'ID',
 					    'visible' => false,
+					    'sql' => 'sys_user.id',
 					    ),
 			      'login' => array(
 					    'name' => 'Login',
@@ -15,19 +17,27 @@ $mask = array(
 			      'name' => array(
 					    'name' => 'Name',
 					    'width' => 150,
+					    'sql' => 'sys_user.name',
 					    ),
 			      'email' => array(
 					    'name' => 'E-Mail',
 					    'width' => 150,
 					    ),
+			      'gruppe' => array(
+					    'name' => 'Gruppe',
+					    'width' => 70,
+					    'sql' => 'sys_group.name',
+					    ),
 			      'sys_user' => array(
 					    'name' => 'Bearb.',
 					    'width' => 50,
+					    'sql' => 'sys_user.sys_user',
 					    ),
 			      'sys_edit' => array(
 					    'name' => 'Geändert',
 					    'width' => 80,
 					    'type' => 'date',
+					    'sql' => 'sys_user.sys_edit',
 					    ),
 			      ),
 	      'rows' => 20,
@@ -47,6 +57,11 @@ $mask = array(
 					    'type' => 'text',
 					    'size' => 25,
 					    ),
+			      'gid' => array(
+					    'name' => 'Gruppe',
+					    'type' => 'select',
+					    'options' => 'SELECT id,name AS text FROM sys_group ORDER BY name',
+					    ),
 			      'passwd' => array(
 					    'name' => 'Passwort',
 					    'type' => 'passwd',