Neue Stammdaten

[misc/hallinta-kostenrechnung] / work_geraete.php

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