Update filter select elements after selecting a new year
[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                                             'specs' => 'canSort: false',
24                                             ),
25                               'preis' => array(
26                                             'name' => 'Preis',
27                                             'type' => 'number',
28                                             'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
29                                             'width' => 50,
30                                             ),
31                               ),
32               'rows' => 20,
33               'edit' => array(
34                               'material' => array(
35                                             'name' => 'Material',
36                                             'type' => 'text',
37                                             'size' => 24,
38                                             'required' => true,
39                                             ),
40                               'einheit' => array(
41                                             'name' => 'Einheit',
42                                             'type' => 'select',
43                                             'options' => 'SELECT id,einheit AS text FROM einheiten ORDER BY einheit',
44                                             'size' => 10,
45                                             ),
46                               'preis' => array(
47                                             'name' => 'Preis',
48                                             'type' => 'decimal',
49                                             'size' => 10,
50                                             'comment' => 'immer brutto',
51                                             'required' => true,
52                                             ),
53                               ),
54               );
55
56 ?>