--- /dev/null
+<?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',
+ ),
+ ),
+ );
+
+?>