3 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
5 if (empty($_SESSION['overview_kostenstellen.year'])) $_SESSION['overview_kostenstellen.year'] = 0;
8 'table' => 'kostenstellen',
9 'title' => 'Übersicht nach Kostenstellen',
10 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
13 'options' => discover_years(),
14 'default' => 'Jahr wählen',
15 'selected' => $_SESSION['overview_kostenstellen.year'],
16 'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
26 'sql' => 'kostenstellen.id',
30 'sql' => "gebiet.gebiet",
32 'specs' => "filterUI: 't'",
34 'kostenstelle' => array(
36 'sql' => "kostenstellen.kostenstelle",
38 'specs' => "filterUI: 't'",
43 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
47 'personalstunden' => array(
48 'name' => 'Personalstunden',
50 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
52 'sql' => "(SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
53 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
54 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))",
56 'geraetstunden' => array(
57 'name' => 'Gerätestunden',
59 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
61 'sql' => "(SELECT sum(stunden) FROM einsatzgeraete WHERE einsatz IN " .
62 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
63 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))",
66 'name' => 'Stunden pro lfdm',
68 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
70 'sql' => "((SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
71 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
72 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . ")) + ".
73 "(SELECT sum(stunden) FROM einsatzgeraete WHERE einsatz IN " .
74 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
75 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))) / laenge",