<?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',
					    ),
			      ),
	      );

?>