Use select box instead of input filter
[misc/kostenrechnung] / masks / overview_gewaesser.php
1 <?php
2
3 $mask = array(
4               'table' => 'einsatz',
5               'title' => 'Einsatzübersicht nach Gewässer',
6               'subtitle' => 'Altenoyther Feld',
7               'join' => array('personal ON einsatz.personal = personal.id',
8                               'gebiet ON einsatz.gebiet = gebiet.id',
9                               'gerate ON einsatz.geraet = gerate.id',
10                               'anbaugeraete ON einsatz.anbaugeraet = anbaugeraete.id',
11                               'arbeitsarten ON einsatz.arbeiten = arbeitsarten.id',
12                               'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
13                               ),
14               'where' => "arbeitsarten.arbeitsart <> 'Urlaub' AND arbeitsarten.arbeitsart <> 'Krank' AND arbeitsarten.arbeitsart <> 'Sonstige Fehltage'"
15                          . ' AND einsatz.gebiet = 41', # 20 Altenoyther Feld
16               'sort' => 1,
17               'list' => array(
18                               'id' => array(
19                                             'name' => 'ID',
20                                             'visible' => false,
21                                             'sql' => 'einsatz.id',
22                                             ),
23                               'datum' => array(
24                                             'name' => 'Datum',
25                                             'type' => 'date',
26                                             'width' => 70,
27                                             ),
28                               'personal' => array(
29                                             'name' => 'Personal',
30                                             'sql' => "personal.personal || ', ' || personal.vorname",
31                                             'width' => 150,
32                                             'specs' => "filterUI: 't'",
33                                             ),
34                               'stunden' => array(
35                                             'name' => 'Stunden',
36                                             'type' => 'number',
37                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
38                                             'width' => 50,
39                                             ),
40                               'stunde' => array(
41                                             'name' => 'Stunde',
42                                             'type' => 'number',
43                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
44                                             'width' => 50,
45                                             'sql' => 'stunden * personal.persstdsatz',
46                                             ),
47                               'lfdm' => array(
48                                             'name' => 'Lfdm',
49                                             'visible' => false,
50                                             'type' => 'number',
51                                             'specs' => "decPlaces: 3, ClassName: 'alignright', suffix: '&nbsp;'",
52                                             'width' => 50,
53                                             'sql' => '(stunden * personal.persstdsatz) / laenge',
54                                             ),
55 #
56                               'geraet' => array(
57                                             'name' => 'Gerät',
58                                             'sql' => 'gerate.geraet',
59                                             'width' => 150,
60                                             'specs' => "filterUI: 's'",
61                                             ),
62                               'geraetstunden' => array(
63                                             'name' => 'Stunden',
64                                             'type' => 'number',
65                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
66                                             'width' => 50,
67                                             ),
68                               'geraetstunde' => array(
69                                             'name' => 'Stunde',
70                                             'type' => 'number',
71                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
72                                             'width' => 50,
73                                             'sql' => 'geraetstunden * gerate.gerstdsatz',
74                                             ),
75                               'geraetlfdm' => array(
76                                             'name' => 'Lfdm',
77                                             'visible' => false,
78                                             'type' => 'number',
79                                             'specs' => "decPlaces: 3, ClassName: 'alignright', suffix: '&nbsp;'",
80                                             'width' => 50,
81                                             'sql' => '(geraetstunden * gerate.gerstdsatz) / laenge',
82                                             ),
83 #
84                               'anbaugeraet' => array(
85                                             'name' => 'Anbaugerät',
86                                             'sql' => 'anbaugeraete.anbaugeraet',
87                                             'width' => 150,
88                                             'specs' => "filterUI: 's'",
89                                             ),
90                               'anbaugeraetstunden' => array(
91                                             'name' => 'Stunden',
92                                             'type' => 'number',
93                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
94                                             'width' => 50,
95                                             ),
96                               'anbaugeraetstunde' => array(
97                                             'name' => 'Stunde',
98                                             'type' => 'number',
99                                             'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: '&nbsp;'",
100                                             'width' => 50,
101                                             'sql' => 'anbaugeraetstunden * anbaugeraete.anbgerstdsatz',
102                                             ),
103                               'anbaugeraetlfdm' => array(
104                                             'name' => 'Lfdm',
105                                             'visible' => false,
106                                             'type' => 'number',
107                                             'specs' => "decPlaces: 3, ClassName: 'alignright', suffix: '&nbsp;'",
108                                             'width' => 50,
109                                             'sql' => '(anbaugeraetstunden * anbaugeraete.anbgerstdsatz) / laenge',
110                                             ),
111                               ),
112               'details' => array(
113                                  'title' => 'Details',
114                                  'subtitle' => 'Informationen zum Gewässer',
115                                  'list' => array(
116                                       'gewaesser' => array(
117                                                     'name' => 'Gewässer',
118                                                     ),
119                                       'laenge' => array(
120                                                     'name' => 'Länge',
121                                                     ),
122                                       'kosten' => array(
123                                                     'name' => 'Gesamtkosten',
124                                                     'format' => '%.2f',
125                                                     ),
126                                       'lfdm' => array(
127                                                     'name' => 'Lfdm',
128                                                     'format' => '%.2f',
129                                                     ),
130                                       'zusatz' => array(
131                                                     'name' => 'Zusätze',
132                                                     ),
133                                                  ),
134                                     ),
135               'rows' => 20,
136               );
137
138 ?>