3 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
5 if (empty($_SESSION['overview_kostenstellen.year'])) $_SESSION['overview_kostenstellen.year'] = 0;
9 $sql = "SELECT id,gebiet FROM gebiet ORDER BY id";
10 $sth = pg_query($sql);
13 while ($row = pg_fetch_assoc($sth))
14 $result[] = sprintf("%d: '%s'", $row['id'], $row['gebiet']);
16 return '{' . implode(', ', $result) . '}';
20 'table' => 'kostenstellen',
21 'title' => 'Übersicht nach Kostenstellen',
24 'options' => discover_years(),
25 'default' => 'Jahr wählen',
26 'selected' => $_SESSION['overview_kostenstellen.year'],
27 'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
37 'sql' => 'kostenstellen.id',
41 'sql' => 'kostenstellen.gebiet',
42 'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
44 'specs' => "filterUI: 's'",
46 'kostenstelle' => array(
48 'sql' => "kostenstellen.kostenstelle",
50 'specs' => "filterUI: 't'",
55 'specs' => "decPlaces: 2, ClassName: 'alignrightpad', canSort: false",
59 'personalstunden' => array(
60 'name' => 'Personalstunden',
62 'specs' => "decPlaces: 2, ClassName: 'alignrightpad', canSort: false",
64 'sql' => "(SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
65 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
66 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))",
68 'geraetstunden' => array(
69 'name' => 'Gerätestunden',
71 'specs' => "decPlaces: 2, ClassName: 'alignrightpad', canSort: false",
73 'sql' => "(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'] . "))",
78 'name' => 'Stunden pro lfdm',
80 'specs' => "decPlaces: 2, ClassName: 'alignrightpad', canSort: false",
82 'sql' => "((SELECT sum(stunden) FROM einsatzpersonal WHERE einsatz IN " .
83 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
84 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . ")) + ".
85 "(SELECT sum(stunden) FROM einsatzgeraete WHERE einsatz IN " .
86 "(SELECT id FROM einsatz WHERE kostenstelle = kostenstellen.id " .
87 "AND date_part('year', datum) = " . $_SESSION['overview_kostenstellen.year'] . "))) / laenge",