Add initial mask configuration

diff --git a/masks/anbaugeraete.php b/masks/anbaugeraete.php
new file mode 100644 (file)
index 0000000..2252411
--- /dev/null
+++ b/masks/anbaugeraete.php
@@ -0,0 +1,36 @@
+<?php
+
+$mask = array(
+             'table' => 'anbaugeraete',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'anbaugeraet' => array(
+                                           'name' => 'Gerät',
+                                           'width' => 150,
+                                           ),
+                             'anbgerstdsatz' => array(
+                                           'name' => 'Satz',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'anbkst_intern' => array(
+                                           'name' => 'intern',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'anbkst_extern' => array(
+                                           'name' => 'extern',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/arbeitsarten.php b/masks/arbeitsarten.php
new file mode 100644 (file)
index 0000000..94fecbe
--- /dev/null
+++ b/masks/arbeitsarten.php
@@ -0,0 +1,18 @@
+<?php
+
+$mask = array(
+             'table' => 'arbeitsarten',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'arbeitsart' => array(
+                                           'name' => 'Arbeitsart',
+                                           'width' => 200,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/einsatz.php b/masks/einsatz.php
new file mode 100644 (file)
index 0000000..839c197
--- /dev/null
+++ b/masks/einsatz.php
@@ -0,0 +1,139 @@
+<?php
+
+$mask = array(
+             'table' => 'einsatz',
+             'join' => array('personal ON einsatz.personal = personal.id',
+                             'gebiet ON einsatz.gebiet = gebiet.id',
+                             'gerate ON einsatz.geraet = gerate.id',
+                             'anbaugeraete ON einsatz.anbaugeraet = anbaugeraete.id',
+                             'arbeitsarten ON einsatz.arbeiten = arbeitsarten.id',
+                             'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
+                             ),
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           'sql' => 'einsatz.id',
+                                           ),
+                             'datum' => array(
+                                           'name' => 'Datum',
+                                           'type' => 'date',
+                                           'width' => 70,
+                                           ),
+                             'ordnung' => array(
+                                           'name' => 'Ord',
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 20,
+                                           'visible' => false,
+                                           ),
+                             'stunden' => array(
+                                           'name' => 'Std',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'personal' => array(
+                                           'name' => 'Personal',
+                                           'sql' => 'personal.personal',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'kostenstelle' => array(
+                                           'name' => 'Kostenstelle',
+                                           'sql' => 'kostenstellen.kostenstelle',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'gebiet' => array(
+                                           'name' => 'Gebiet',
+                                           'sql' => 'gebiet.gebiet',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'geraet' => array(
+                                           'name' => 'Gerät',
+                                           'sql' => 'gerate.geraet',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'anbaugeraet' => array(
+                                           'name' => 'Anbaugerät',
+                                           'sql' => 'anbaugeraete.anbaugeraet',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'arbeit' => array(
+                                           'name' => 'Arbeit',
+                                           'sql' => 'arbeitsarten.arbeitsart',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'geraetstunden' => array(
+                                           'name' => 'Std/G',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'anbaugeraetstunden' => array(
+                                           'name' => 'Std/A',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'pers_kosten' => array(
+                                           'name' => 'Kosten/P',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 4, ClassName: 'alignright'",
+                                           'width' => 80,
+                                           ),
+                             'geraet_kosten' => array(
+                                           'name' => 'Kosten/G',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 4, ClassName: 'alignright'",
+                                           'width' => 80,
+                                           ),
+                             'anbauger_kosten' => array(
+                                           'name' => 'Kosten/A',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 4, ClassName: 'alignright'",
+                                           'width' => 80,
+                                           ),
+                             'akkord' => array(
+                                           'name' => 'Akkord',
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 20,
+                                           'visible' => false,
+                                           ),
+                             'anbauger_kstint' => array(
+                                           'name' => 'KstInt/A',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 4, ClassName: 'alignright'",
+                                           'width' => 80,
+                                           ),
+                             'geraet_kstint' => array(
+                                           'name' => 'KstInt/G',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 4, ClassName: 'alignright'",
+                                           'width' => 80,
+                                           ),
+                             'hhjahreinsatz' => array(
+                                           'name' => 'Jahreseinsatz',
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 30,
+                                           'visible' => false,
+                                           ),
+                             'eingabe' => array(
+                                           'name' => 'Edit',
+                                           'type' => 'date',
+                                           'width' => 70,
+                                           'visible' => false,
+                                           ),
+# gewaesser          | integer                     |
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/gebiet.php b/masks/gebiet.php
new file mode 100644 (file)
index 0000000..02a5c95
--- /dev/null
+++ b/masks/gebiet.php
@@ -0,0 +1,19 @@
+<?php
+
+$mask = array(
+             'table' => 'gebiet',
+             'sort' => 1,
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'gebiet' => array(
+                                           'name' => 'Gebiet',
+                                           'width' => 200,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/geraete.php b/masks/geraete.php
new file mode 100644 (file)
index 0000000..98e5d59
--- /dev/null
+++ b/masks/geraete.php
@@ -0,0 +1,37 @@
+<?php
+
+$mask = array(
+             'table' => 'gerate',
+             'sort' => 1,
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'geraet' => array(
+                                           'name' => 'Gerät',
+                                           'width' => 150,
+                                           ),
+                             'gerstdsatz' => array(
+                                           'name' => 'Satz',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'geraetkst_intern' => array(
+                                           'name' => 'intern',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 60,
+                                           ),
+                             'geraetkst_extern' => array(
+                                           'name' => 'extern',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 60,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/kostenstellen.php b/masks/kostenstellen.php
new file mode 100644 (file)
index 0000000..4091e7a
--- /dev/null
+++ b/masks/kostenstellen.php
@@ -0,0 +1,43 @@
+<?php
+
+$mask = array(
+             'table' => 'kostenstellen',
+             'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'sql' => 'kostenstellen.id',
+                                           'visible' => false,
+                                           ),
+                             'kostenstelle' => array(
+                                           'name' => 'Kostenstelle',
+                                           'width' => 150,
+                                           ),
+                             'gebiet' => array(
+                                           'name' => 'Gebiet',
+                                           'sql' => 'gebiet.gebiet',
+                                           'width' => 200,
+                                           ),
+                             'laenge' => array(
+                                           'name' => 'Länge',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 65,
+                                           ),
+                             'dienstlstg' => array(
+                                           'name' => 'Dienst',
+#                                          'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'gereinigt' => array(
+                                           'name' => 'gereinigt',
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/materialien.php b/masks/materialien.php
new file mode 100644 (file)
index 0000000..3a99c81
--- /dev/null
+++ b/masks/materialien.php
@@ -0,0 +1,38 @@
+<?php
+
+$mask = array(
+             'table' => 'materialien',
+             'sort' => 1,
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'material' => array(
+                                           'name' => 'Material',
+                                           'width' => 200,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'preis' => array(
+                                           'name' => 'Preis',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             ),
+             'rows' => 20,
+             'edit' => array(
+                             'material' => array(
+                                           'name' => 'Material',
+                                           'type' => 'text',
+                                           'size' => 50,
+                                           ),
+                             'preis' => array(
+                                           'name' => 'Preis',
+                                           'type' => 'text',
+                                           'size' => 20,
+                                           ),
+                             ),
+             );
+
+?>

diff --git a/masks/materialverbrauch.php b/masks/materialverbrauch.php
new file mode 100644 (file)
index 0000000..61d9cf3
--- /dev/null
+++ b/masks/materialverbrauch.php
@@ -0,0 +1,42 @@
+<?php
+
+$mask = array(
+             'table' => 'materialverbrauch',
+             'join' => array('materialien ON materialverbrauch.material = materialien.id'),
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'sql' => 'materialverbrauch.id',
+                                           'visible' => false,
+                                           ),
+                             'kostenstelle' => array(
+                                           'name' => 'KSt',
+                                           'width' => 50,
+                                           ),
+                             'material' => array(
+                                           'name' => 'Material',
+                                           'sql' => 'materialien.material',
+                                           'width' => 200,
+                                           ),
+                             'menge' => array(
+                                           'name' => 'Menge',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'einheit' => array(
+                                           'name' => 'Einheit',
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'datum' => array(
+                                           'name' => 'Datum',
+                                           'type' => 'date',
+                                           'width' => 60,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/personal.php b/masks/personal.php
new file mode 100644 (file)
index 0000000..33a7fc6
--- /dev/null
+++ b/masks/personal.php
@@ -0,0 +1,41 @@
+<?php
+
+$mask = array(
+             'table' => 'personal',
+             'sort' => 1,
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'personal' => array(
+                                           'name' => 'Name',
+                                           'width' => 100,
+                                           ),
+                             'vorname' => array(
+                                           'name' => 'Vorname',
+                                           'width' => 100,
+                                           ),
+                             'persstdsatz' => array(
+                                           'name' => 'Satz',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 50,
+                                           ),
+                             'jahresakkord' => array(
+                                           'name' => 'Akkord',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 60,
+                                           ),
+                             'akkordzuschlag' => array(
+                                           'name' => 'Zuschlag',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright'",
+                                           'width' => 60,
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/sys_group.php b/masks/sys_group.php
new file mode 100644 (file)
index 0000000..02a12e6
--- /dev/null
+++ b/masks/sys_group.php
@@ -0,0 +1,31 @@
+<?php
+
+$mask = array(
+             'table' => 'sys_group',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'gname' => array(
+                                           'name' => 'Gruppe',
+                                           'width' => 70,
+                                           ),
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'width' => 150,
+                                           ),
+                             'sys_user' => array(
+                                           'name' => 'Edit',
+                                           'width' => 50,
+                                           ),
+                             'sys_edit' => array(
+                                           'name' => 'Datum',
+                                           'width' => 80,
+                                           'type' => 'date',
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/sys_mask.php b/masks/sys_mask.php
new file mode 100644 (file)
index 0000000..9115625
--- /dev/null
+++ b/masks/sys_mask.php
@@ -0,0 +1,41 @@
+<?php
+
+$mask = array(
+             'table' => 'sys_mask',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'mask' => array(
+                                           'name' => 'Maske',
+                                           'width' => 100,
+                                           ),
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'width' => 150,
+                                           ),
+                             'edit' => array(
+                                           'name' => 'Edit',
+                                           'width' => 15,
+                                           ),
+                             'priority' => array(
+                                           'name' => 'Priorität',
+                                           'width' => 25,
+                                           'type' => 'number',
+                                           'specs' => "ClassName: 'alignright'",
+                                           ),
+                             'sys_user' => array(
+                                           'name' => 'Edit',
+                                           'width' => 50,
+                                           ),
+                             'sys_edit' => array(
+                                           'name' => 'Datum',
+                                           'width' => 80,
+                                           'type' => 'date',
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>

diff --git a/masks/sys_user.php b/masks/sys_user.php
new file mode 100644 (file)
index 0000000..0fbf975
--- /dev/null
+++ b/masks/sys_user.php
@@ -0,0 +1,31 @@
+<?php
+
+$mask = array(
+             'table' => 'sys_user',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           ),
+                             'login' => array(
+                                           'name' => 'Login',
+                                           'width' => 70,
+                                           ),
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'width' => 150,
+                                           ),
+                             'sys_user' => array(
+                                           'name' => 'Edit',
+                                           'width' => 50,
+                                           ),
+                             'sys_edit' => array(
+                                           'name' => 'Datum',
+                                           'width' => 80,
+                                           'type' => 'date',
+                                           ),
+                             ),
+             'rows' => 20,
+             );
+
+?>