Add filter possibility
[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'",
38                                             'width' => 50,
39                                             ),
40                               'stunde' => array(
41                                             'name' => 'Stunde',
42                                             'type' => 'number',
43                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
44                                             'width' => 50,
45                                             'sql' => 'stunden * personal.persstdsatz',
46                                             ),
47                               'lfdm' => array(
48                                             'name' => 'Lfdm',
49                                             'type' => 'number',
50                                             'specs' => "decPlaces: 3, ClassName: 'alignright'",
51                                             'width' => 50,
52                                             'sql' => '(stunden * personal.persstdsatz) / laenge',
53                                             ),
54 #
55                               'geraet' => array(
56                                             'name' => 'Gerät',
57                                             'sql' => 'gerate.geraet',
58                                             'width' => 150,
59                                             'specs' => "filterUI: 't'",
60                                             ),
61                               'geraetstunden' => array(
62                                             'name' => 'Stunden',
63                                             'type' => 'number',
64                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
65                                             'width' => 50,
66                                             ),
67                               'geraetstunde' => array(
68                                             'name' => 'Stunde',
69                                             'type' => 'number',
70                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
71                                             'width' => 50,
72                                             'sql' => 'geraetstunden * gerate.gerstdsatz',
73                                             ),
74                               'geraetlfdm' => array(
75                                             'name' => 'Lfdm',
76                                             'type' => 'number',
77                                             'specs' => "decPlaces: 3, ClassName: 'alignright'",
78                                             'width' => 50,
79                                             'sql' => '(geraetstunden * gerate.gerstdsatz) / laenge',
80                                             ),
81 #
82                               'anbaugeraet' => array(
83                                             'name' => 'Anbaugerät',
84                                             'sql' => 'anbaugeraete.anbaugeraet',
85                                             'width' => 150,
86                                             'specs' => "filterUI: 't'",
87                                             ),
88                               'anbaugeraetstunden' => array(
89                                             'name' => 'Stunden',
90                                             'type' => 'number',
91                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
92                                             'width' => 50,
93                                             ),
94                               'anbaugeraetstunde' => array(
95                                             'name' => 'Stunde',
96                                             'type' => 'number',
97                                             'specs' => "decPlaces: 2, ClassName: 'alignright'",
98                                             'width' => 50,
99                                             'sql' => 'anbaugeraetstunden * anbaugeraete.anbgerstdsatz',
100                                             ),
101                               'anbaugeraetlfdm' => array(
102                                             'name' => 'Lfdm',
103                                             'type' => 'number',
104                                             'specs' => "decPlaces: 3, ClassName: 'alignright'",
105                                             'width' => 50,
106                                             'sql' => '(anbaugeraetstunden * anbaugeraete.anbgerstdsatz) / laenge',
107                                             ),
108                               ),
109               'rows' => 20,
110               );
111
112 ?>