Neue Stammdaten
authorJoey Schulze <joey@infodrom.org>
Fri, 4 Mar 2011 20:50:48 +0000 (21:50 +0100)
committerJoey Schulze <joey@infodrom.org>
Fri, 4 Mar 2011 20:50:48 +0000 (21:50 +0100)
lieferanten.php [new file with mode: 0644]
work_geraete.php [new file with mode: 0644]
work_material.php [new file with mode: 0644]

diff --git a/lieferanten.php b/lieferanten.php
new file mode 100644 (file)
index 0000000..f2af409
--- /dev/null
@@ -0,0 +1,106 @@
+<?php
+
+$mask = array(
+             'table' => 'lieferanten',
+             'title' => 'Lieferanten',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           'sql' => 'id',
+                                           ),
+                             'name' => array(
+                                           'name' => 'Firmenname',
+                                           'width' => 270,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'plz' => array(
+                                           'name' => 'PLZ',
+                                           'width' => 70,
+                                           'specs' => 'canSort: false',
+                                           ),
+                             'ort' => array(
+                                           'name' => 'Ort',
+                                           'width' => 150,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'url' => array(
+                                           'name' => 'Homepage',
+                                           'width' => 150,
+                                           'control' => "new Rico.TableColumn.link('{4}','_blank')",
+                                           ),
+                             ),
+             'edit' => array(
+                             'name' => array(
+                                           'name' => 'Firmenname',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'required' => true,
+                                           ),
+                             'anschrift1' => array(
+                                           'name' => 'Adresse',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'required' => true,
+                                           ),
+                             'anschrift2' => array(
+                                           'name' => 'Adresszusatz',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           ),
+                             'plz' => array(
+                                           'name' => 'PLZ',
+                                           'type' => 'decimal',
+                                           'size' => 5,
+                                           'required' => true,
+                                           ),
+                             'ort' => array(
+                                           'name' => 'Ort',
+                                           'type' => 'text',
+                                           'size' => 20,
+                                           'required' => true,
+                                           ),
+                             'land' => array(
+                                           'name' => 'Land',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'default' => 'Deutschland',
+                                           ),
+                             'url' => array(
+                                           'name' => 'Homepage',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           ),
+                             'uid' => array(
+                                           'name' => 'UStdId',
+                                           'type' => 'text',
+                                           'size' => 20,
+                                           ),
+                             'kontakt_name' => array(
+                                           'name' => 'Kontakt',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           ),
+                             'kontakt_email' => array(
+                                           'name' => 'E-Mail',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           ),
+                             'kontakt_tel' => array(
+                                           'name' => 'Telefon',
+                                           'type' => 'text',
+                                           'size' => 15,
+                                           ),
+                             'kontakt_fax' => array(
+                                           'name' => 'Fax',
+                                           'type' => 'text',
+                                           'size' => 15,
+                                           ),
+                             'comment' => array(
+                                           'name' => 'Bemerkung',
+                                           'type' => 'textarea',
+                                           ),
+                             ),
+             );
+
+?>
diff --git a/work_geraete.php b/work_geraete.php
new file mode 100644 (file)
index 0000000..08d99d4
--- /dev/null
@@ -0,0 +1,111 @@
+<?php
+
+$mask = array(
+             'table' => 'work_geraete',
+             'title' => 'Gerätestammdaten',
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           'sql' => 'id',
+                                           ),
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'width' => 250,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'hersteller' => array(
+                                           'name' => 'Hersteller',
+                                           'width' => 180,
+                                           'specs' => "filterUI: 't'",
+                                           ),
+                             'baujahr' => array(
+                                           'name' => 'Baujahr',
+                                           'width' => 50,
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 0, canSort: false, filterUI: 's', thouSep: ''",
+                                           ),
+                             'anschaffung' => array(
+                                           'name' => 'Anschaffung',
+                                           'type' => 'date',
+                                           'width' => 70,
+                                           ),
+                             'preis' => array(
+                                           'name' => 'Preis',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
+                                           'width' => 70,
+                                           ),
+                             'nummer' => array(
+                                           'name' => 'Gerätenummer',
+                                           'width' => 120,
+                                           'specs' => "filterUI: 't'",
+                                           'visible' => false,
+                                           ),
+                             ),
+             'edit' => array(
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'required' => true,
+                                           ),
+                             'hersteller' => array(
+                                           'name' => 'Hersteller',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'required' => true,
+                                           ),
+                             'baujahr' => array(
+                                           'name' => 'Baujahr',
+                                           'type' => 'number',
+                                           'size' => 4,
+                                           'required' => true,
+                                           ),
+                             'lieferant' => array(
+                                           'name' => 'Lieferant',
+                                           'type' => 'select',
+                                           'options' => 'SELECT id,name AS text FROM lieferanten ORDER BY name',
+                                           'option_empty' => '-- select --',
+                                           'required' => true,
+                                           ),
+                             'preis' => array(
+                                           'name' => 'Preis',
+                                           'type' => 'decimal',
+                                           'size' => 10,
+                                           'required' => true,
+                                           ),
+                             'leistung' => array(
+                                           'name' => 'Leistung',
+                                           'type' => 'decimal',
+                                           'size' => 10,
+                                           'comment' => 'KW',
+                                           ),
+                             'nummer' => array(
+                                           'name' => 'Gerätenummer',
+                                           'type' => 'text',
+                                           'size' => 20,
+                                           'required' => true,
+                                           ),
+                             'anschaffung' => array(
+                                           'name' => 'Anschaffungsdatum',
+                                           'type' => 'date',
+                                           'size' => 8,
+                                           'null' => true,
+                                           ),
+/*
+                             'path_photo' => array(
+                                           'name' => 'Foto',
+                                           'type' => 'file',
+                                           'path' => 'werkstatt',
+                                           'sql' => false,
+                                           ),
+*/
+                             'comment' => array(
+                                           'name' => 'Bemerkung',
+                                           'type' => 'textarea',
+                                           ),
+                             ),
+             );
+
+?>
diff --git a/work_material.php b/work_material.php
new file mode 100644 (file)
index 0000000..7c4c9f9
--- /dev/null
@@ -0,0 +1,83 @@
+<?php
+
+$mask = array(
+             'table' => 'work_material',
+             'title' => 'Materialstammdaten',
+             'join' => array('lieferanten ON lieferant = lieferanten.id'),
+             'list' => array(
+                             'id' => array(
+                                           'name' => 'ID',
+                                           'visible' => false,
+                                           'sql' => 'work_material.id',
+                                           ),
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'width' => 250,
+                                           'specs' => "filterUI: 't'",
+                                           'sql' => 'work_material.name',
+                                           ),
+                             'menge' => array(
+                                           'name' => 'Menge',
+                                           'type' => 'number',
+                                           'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
+                                           'width' => 50,
+                                           ),
+                             'lieferant' => array(
+                                           'name' => 'Lieferant',
+                                           'width' => 200,
+                                           'specs' => "filterUI: 's'",
+                                           'sql' => 'lieferanten.name',
+                                           ),
+                             'nummer' => array(
+                                           'name' => 'Materialnummer',
+                                           'width' => 120,
+                                           'specs' => "filterUI: 't'",
+                                           'visible' => false,
+                                           ),
+                             ),
+             'edit' => array(
+                             'name' => array(
+                                           'name' => 'Name',
+                                           'type' => 'text',
+                                           'size' => 24,
+                                           'required' => true,
+                                           ),
+                             'nummer' => array(
+                                           'name' => 'Materialnummer',
+                                           'type' => 'text',
+                                           'size' => 20,
+                                           'required' => true,
+                                           ),
+                             'menge' => array(
+                                           'name' => 'Menge',
+                                           'type' => 'number',
+                                           'size' => 6,
+                                           'required' => true,
+                                           ),
+                             'einheit' => array(
+                                           'name' => 'Einheit',
+                                           'type' => 'text',
+                                           'size' => 10,
+                                           'required' => true,
+                                           ),
+                             'einzelpreis' => array(
+                                           'name' => 'Einzelpreis',
+                                           'type' => 'decimal',
+                                           'size' => 10,
+                                           'required' => true,
+                                           ),
+                             'lieferant' => array(
+                                           'name' => 'Lieferant',
+                                           'type' => 'select',
+                                           'options' => 'SELECT id,name AS text FROM lieferanten ORDER BY name',
+                                           'option_empty' => '-- select --',
+                                           'required' => true,
+                                           ),
+                             'comment' => array(
+                                           'name' => 'Bemerkung',
+                                           'type' => 'textarea',
+                                           ),
+                             ),
+             );
+
+?>