Add AJAX backend for fetching data and filling the edit form

[misc/kostenrechnung] / masks / sys_mask.php

diff --git a/masks/sys_mask.php b/masks/sys_mask.php
index 9115625..a96d56a 100644 (file)
--- a/masks/sys_mask.php
+++ b/masks/sys_mask.php
@@ -2,37 +2,55 @@
 
 $mask = array(
              'table' => 'sys_mask',
+             'title' => 'Liste der Menüpunkte',
+             'join' => array('sys_menu ON sys_mask.menu = sys_menu.id'),
              'list' => array(
                              'id' => array(
                                            'name' => 'ID',
                                            'visible' => false,
+                                           'sql' => 'sys_mask.id',
                                            ),
                              'mask' => array(
-                                           'name' => 'Maske',
+                                           'name' => 'Menüpunkt',
                                            'width' => 100,
                                            ),
-                             'name' => array(
+                             'title' => array(
                                            'name' => 'Name',
                                            'width' => 150,
                                            ),
+                             'menutitle' => array(
+                                           'name' => 'Menütitel',
+                                           'width' => 150,
+                                           ),
+                             'menu' => array(
+                                           'name' => 'Menü',
+                                           'sql' => 'sys_menu.name',
+                                           'width' => 150,
+                                           ),
                              'edit' => array(
                                            'name' => 'Edit',
-                                           'width' => 15,
+                                           'width' => 20,
+                                           'specs' => "ClassName: 'aligncenter'",
                                            ),
                              'priority' => array(
                                            'name' => 'Priorität',
-                                           'width' => 25,
+                                           'width' => 30,
                                            'type' => 'number',
                                            'specs' => "ClassName: 'alignright'",
+                                           'sql' => 'sys_mask.priority',
                                            ),
                              'sys_user' => array(
                                            'name' => 'Edit',
                                            'width' => 50,
+                                           'visible' => false,
+                                           'sql' => 'sys_mask.sys_user',
                                            ),
                              'sys_edit' => array(
                                            'name' => 'Datum',
                                            'width' => 80,
                                            'type' => 'date',
+                                           'visible' => false,
+                                           'sql' => 'sys_mask.sys_edit',
                                            ),
                              ),
              'rows' => 20,