From: Joey Schulze <joey@infodrom.org>
Date: Fri, 4 Mar 2011 20:50:48 +0000 (+0100)
Subject: Neue Stammdaten
X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-kostenrechnung;a=commitdiff_plain;h=542b9828de7cf5ea06f5b9e975b117c8378f4697

Neue Stammdaten
---

diff --git a/lieferanten.php b/lieferanten.php
new file mode 100644
index 0000000..f2af409
--- /dev/null
+++ b/lieferanten.php
@@ -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
index 0000000..08d99d4
--- /dev/null
+++ b/work_geraete.php
@@ -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
index 0000000..7c4c9f9
--- /dev/null
+++ b/work_material.php
@@ -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',
+					    ),
+			      ),
+	      );
+
+?>