Updates according to specification
[misc/kostenrechnung] / masks / materialien.php
1 <?php
2
3 $mask = array(
4               'table' => 'materialien',
5               'title' => 'Materialien',
6               'sort' => 1,
7               'join' => array('einheiten ON materialien.einheit = einheiten.id'),
8               'list' => array(
9                               'id' => array(
10                                             'name' => 'ID',
11                                             'visible' => false,
12                                             'sql' => 'materialien.id',
13                                             ),
14                               'material' => array(
15                                             'name' => 'Material',
16                                             'width' => 270,
17                                             'specs' => "filterUI: 't'",
18                                             ),
19                               'einheit' => array(
20                                             'name' => 'Einheit',
21                                             'width' => 70,
22                                             'sql' => 'einheiten.einheit',
23                                             ),
24                               'preis' => array(
25                                             'name' => 'Preis',
26                                             'type' => 'number',
27                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
28                                             'width' => 50,
29                                             ),
30                               ),
31               'rows' => 20,
32               'edit' => array(
33                               'material' => array(
34                                             'name' => 'Material',
35                                             'type' => 'text',
36                                             'size' => 50,
37                                             ),
38                               'einheit' => array(
39                                             'name' => 'Einheit',
40                                             'type' => 'select',
41                                             'options' => 'SELECT id,einheit AS text FROM einheiten ORDER BY einheit',
42                                             'size' => 10,
43                                             ),
44                               'preis' => array(
45                                             'name' => 'Preis',
46                                             'type' => 'text',
47                                             'size' => 10,
48                                             'comment' => 'immer brutto',
49                                             ),
50                               ),
51               );
52
53 ?>