6144b977848a52de8e137c7affb6f526ce338eeb
[misc/hallinta-metro] / artikel.php
1 <?php
2
3 $mask = array(
4               'table' => 'metro_artikel',
5               'title' => 'Artikelstammdaten',
6               'join' => array('metro_abteilung ON abteilung = metro_abteilung.id'),
7               'list' => array(
8                               'id' => array(
9                                             'name' => 'ID',
10                                             'visible' => false,
11                                             'sql' => 'metro_artikel.id',
12                                             ),
13                               'artnr' => array(
14                                             'name' => 'ArtNr',
15                                             'width' => 60,
16                                             ),
17                               'menge' => array(
18                                             'name' => 'Menge',
19                                             'width' => 60,
20                                             'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
21                                             ),
22                               'bezeichnung' => array(
23                                             'name' => 'Bezeichnung',
24                                             'width' => 345,
25                                             'specs' => "filterUI: 't'",
26                                             ),
27                               'hersteller' => array(
28                                             'name' => 'Hersteller',
29                                             'width' => 100,
30                                             'specs' => "filterUI: 't'",
31                                             'visible' => false,
32                                             ),
33                               'abteilung' => array(
34                                             'name' => 'Abteilung',
35                                             'width' => 200,
36                                             'specs' => "filterUI: 's'",
37                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')",
38                                             'visible' => false,
39                                             ),
40                               'gang' => array(
41                                             'name' => 'Gang',
42                                             'width' => 50,
43                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
44                                             'visible' => false,
45                                             ),
46                               'vpe' => array(
47                                             'name' => 'Einheit',
48                                             'width' => 70,
49                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
50                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')",
51                                             ),
52                               ),
53               'edit' => array(
54                               'artnr' => array(
55                                             'name' => 'Artikelnummer',
56                                             'type' => 'number',
57                                             'size' => 25,
58                                             'required' => true,
59                                             ),
60                               'abteilung' => array(
61                                             'name' => 'Abteilung',
62                                             'type' => 'select',
63                                             'options' => 'SELECT id,name AS text FROM metro_abteilung ORDER BY name',
64                                             'option_empty' => '-- select --',
65                                             'required' => true,
66                                             ),
67                               'vpe' => array(
68                                             'name' => 'Verpackungseinheit',
69                                             'type' => 'select',
70                                             'options' => 'SELECT id,name AS text FROM metro_vpe ORDER BY name',
71                                             'option_empty' => '-- select --',
72                                             'required' => true,
73                                             ),
74                               'menge' => array(
75                                             'name' => 'Menge',
76                                             'type' => 'text',
77                                             'size' => 15,
78                                             'null' => true,
79                                             ),
80                               'bezeichnung' => array(
81                                             'name' => 'Bezeichnung',
82                                             'type' => 'text',
83                                             'size' => 25,
84                                             'required' => true,
85                                             ),
86                               'hersteller' => array(
87                                             'name' => 'Hersteller',
88                                             'type' => 'text',
89                                             'size' => 25,
90                                             'null' => true,
91                                             ),
92                               ),
93               );
94
95 ?>