From f77dc8a8ce646554325b1bf4dd2ad6cad1848715 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Wed, 20 Jan 2010 11:01:16 +0100
Subject: [PATCH] Add initial mask configuration

---
 masks/anbaugeraete.php      |  36 ++++++++++
 masks/arbeitsarten.php      |  18 +++++
 masks/einsatz.php           | 139 ++++++++++++++++++++++++++++++++++++
 masks/gebiet.php            |  19 +++++
 masks/geraete.php           |  37 ++++++++++
 masks/kostenstellen.php     |  43 +++++++++++
 masks/materialien.php       |  38 ++++++++++
 masks/materialverbrauch.php |  42 +++++++++++
 masks/personal.php          |  41 +++++++++++
 masks/sys_group.php         |  31 ++++++++
 masks/sys_mask.php          |  41 +++++++++++
 masks/sys_user.php          |  31 ++++++++
 12 files changed, 516 insertions(+)
 create mode 100644 masks/anbaugeraete.php
 create mode 100644 masks/arbeitsarten.php
 create mode 100644 masks/einsatz.php
 create mode 100644 masks/gebiet.php
 create mode 100644 masks/geraete.php
 create mode 100644 masks/kostenstellen.php
 create mode 100644 masks/materialien.php
 create mode 100644 masks/materialverbrauch.php
 create mode 100644 masks/personal.php
 create mode 100644 masks/sys_group.php
 create mode 100644 masks/sys_mask.php
 create mode 100644 masks/sys_user.php

diff --git a/masks/anbaugeraete.php b/masks/anbaugeraete.php
new file mode 100644
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
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
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
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
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
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
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
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
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
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
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
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,
+	      );
+
+?>
-- 
2.20.1