Rename sys_mask.mask into sys_mask.fname
[misc/kostenrechnung] / masks / einsatz.php
1 <?php
2
3 $mask = array(
4               'table' => 'einsatz',
5               'join' => array('personal ON einsatz.personal = personal.id',
6                               'gebiet ON einsatz.gebiet = gebiet.id',
7                               'gerate ON einsatz.geraet = gerate.id',
8                               'anbaugeraete ON einsatz.anbaugeraet = anbaugeraete.id',
9                               'arbeitsarten ON einsatz.arbeiten = arbeitsarten.id',
10                               'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
11                               ),
12               'list' => array(
13                               'id' => array(
14                                             'name' => 'ID',
15                                             'visible' => false,
16                                             'sql' => 'einsatz.id',
17                                             ),
18                               'datum' => array(
19                                             'name' => 'Datum',
20                                             'type' => 'date',
21                                             'width' => 70,
22                                             ),
23                               'ordnung' => array(
24                                             'name' => 'Ord',
25                                             'type' => 'number',
26                                             'specs' => "ClassName: 'alignright'",
27                                             'width' => 20,
28                                             'visible' => false,
29                                             ),
30                               'stunden' => array(
31                                             'name' => 'Std',
32                                             'type' => 'number',
33                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
34                                             'width' => 50,
35                                             ),
36                               'personal' => array(
37                                             'name' => 'Personal',
38                                             'sql' => 'personal.personal',
39                                             'width' => 150,
40                                             'specs' => "filterUI: 't'",
41                                             ),
42                               'kostenstelle' => array(
43                                             'name' => 'Kostenstelle',
44                                             'sql' => 'kostenstellen.kostenstelle',
45                                             'width' => 150,
46                                             'specs' => "filterUI: 't'",
47                                             ),
48                               'gebiet' => array(
49                                             'name' => 'Gebiet',
50                                             'sql' => 'gebiet.gebiet',
51                                             'width' => 150,
52                                             'specs' => "filterUI: 't'",
53                                             ),
54                               'geraet' => array(
55                                             'name' => 'Gerät',
56                                             'sql' => 'gerate.geraet',
57                                             'width' => 150,
58                                             'specs' => "filterUI: 't'",
59                                             ),
60                               'anbaugeraet' => array(
61                                             'name' => 'Anbaugerät',
62                                             'sql' => 'anbaugeraete.anbaugeraet',
63                                             'width' => 150,
64                                             'specs' => "filterUI: 't'",
65                                             ),
66                               'arbeit' => array(
67                                             'name' => 'Arbeit',
68                                             'sql' => 'arbeitsarten.arbeitsart',
69                                             'width' => 150,
70                                             'specs' => "filterUI: 't'",
71                                             ),
72                               'geraetstunden' => array(
73                                             'name' => 'Std/G',
74                                             'type' => 'number',
75                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
76                                             'width' => 50,
77                                             ),
78                               'anbaugeraetstunden' => array(
79                                             'name' => 'Std/A',
80                                             'type' => 'number',
81                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
82                                             'width' => 50,
83                                             ),
84                               'pers_kosten' => array(
85                                             'name' => 'Kosten/P',
86                                             'type' => 'number',
87                                             'specs' => "decPlaces: 4, ClassName: 'alignright'",
88                                             'width' => 80,
89                                             ),
90                               'geraet_kosten' => array(
91                                             'name' => 'Kosten/G',
92                                             'type' => 'number',
93                                             'specs' => "decPlaces: 4, ClassName: 'alignright'",
94                                             'width' => 80,
95                                             ),
96                               'anbauger_kosten' => array(
97                                             'name' => 'Kosten/A',
98                                             'type' => 'number',
99                                             'specs' => "decPlaces: 4, ClassName: 'alignright'",
100                                             'width' => 80,
101                                             ),
102                               'akkord' => array(
103                                             'name' => 'Akkord',
104                                             'type' => 'number',
105                                             'specs' => "ClassName: 'alignright'",
106                                             'width' => 20,
107                                             'visible' => false,
108                                             ),
109                               'anbauger_kstint' => array(
110                                             'name' => 'KstInt/A',
111                                             'type' => 'number',
112                                             'specs' => "decPlaces: 4, ClassName: 'alignright'",
113                                             'width' => 80,
114                                             ),
115                               'geraet_kstint' => array(
116                                             'name' => 'KstInt/G',
117                                             'type' => 'number',
118                                             'specs' => "decPlaces: 4, ClassName: 'alignright'",
119                                             'width' => 80,
120                                             ),
121                               'hhjahreinsatz' => array(
122                                             'name' => 'Jahreseinsatz',
123                                             'type' => 'number',
124                                             'specs' => "ClassName: 'alignright'",
125                                             'width' => 30,
126                                             'visible' => false,
127                                             ),
128                               'eingabe' => array(
129                                             'name' => 'Edit',
130                                             'type' => 'date',
131                                             'width' => 70,
132                                             'visible' => false,
133                                             ),
134 # gewaesser          | integer                     |
135                               ),
136               'rows' => 20,
137               );
138
139 ?>