Import current development version
[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                                             'specs' => "filterUI: 't'",
17                                             ),
18                               'menge' => array(
19                                             'name' => 'Menge',
20                                             'width' => 60,
21                                             'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
22                                             ),
23                               'bezeichnung' => array(
24                                             'name' => 'Bezeichnung',
25                                             'width' => 345,
26                                             'specs' => "filterUI: 't'",
27                                             ),
28                               'hersteller' => array(
29                                             'name' => 'Hersteller',
30                                             'width' => 100,
31                                             'specs' => "filterUI: 't'",
32                                             'visible' => false,
33                                             ),
34                               'abteilung' => array(
35                                             'name' => 'Abteilung',
36                                             'width' => 200,
37                                             'specs' => "filterUI: 's'",
38                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')",
39                                             'visible' => false,
40                                             ),
41                               'gang' => array(
42                                             'name' => 'Gang',
43                                             'width' => 50,
44                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
45                                             'visible' => false,
46                                             ),
47                               'vpe' => array(
48                                             'name' => 'Einheit',
49                                             'width' => 70,
50                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
51                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')",
52                                             ),
53                               ),
54               'edit' => array(
55                               'artnr' => array(
56                                             'name' => 'Artikelnummer',
57                                             'type' => 'number',
58                                             'size' => 25,
59                                             'required' => true,
60                                             ),
61                               'abteilung' => array(
62                                             'name' => 'Abteilung',
63                                             'type' => 'select',
64                                             'options' => 'SELECT id,name AS text FROM metro_abteilung ORDER BY name',
65                                             'option_empty' => '-- select --',
66                                             'required' => true,
67                                             ),
68                               'vpe' => array(
69                                             'name' => 'Verpackungseinheit',
70                                             'type' => 'select',
71                                             'options' => 'SELECT id,name AS text FROM metro_vpe ORDER BY name',
72                                             'option_empty' => '-- select --',
73                                             'required' => true,
74                                             ),
75                               'menge' => array(
76                                             'name' => 'Menge',
77                                             'type' => 'text',
78                                             'size' => 15,
79                                             'null' => true,
80                                             ),
81                               'bezeichnung' => array(
82                                             'name' => 'Bezeichnung',
83                                             'type' => 'text',
84                                             'size' => 25,
85                                             'required' => true,
86                                             ),
87                               'hersteller' => array(
88                                             'name' => 'Hersteller',
89                                             'type' => 'text',
90                                             'size' => 25,
91                                             'null' => true,
92                                             ),
93                               ),
94               );
95
96 ?>