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",
46 'personalstunden' => array(
47 'name' => 'Personalstunden',
49 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
51 'sql' => "(SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
52 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
53 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))",
55 'geraetstunden' => array(
56 'name' => 'Gerätestunden',
58 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
60 'sql' => "(SELECT sum(stunden) FROM einsatzgeraete WHERE einsatz IN " .
61 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
62 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))",
65 'name' => 'Stunden pro lfdm',
67 'specs' => "decPlaces: 2, ClassName: 'alignright', suffix: ' ', canSort: false",
69 'sql' => "((SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
70 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
71 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . ")) + ".
72 "(SELECT sum(stunden) FROM einsatzgeraete WHERE einsatz IN " .
73 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
74 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))) / laenge",