5 Rico.moduleDependencies['checkboxDB'] = ['+LiveGrid', '../ricoTableColumnDB.js'];
6 Rico.loadModule('checkboxDB');
8 function select_year_calback(data)
13 function select_year(obj)
15 if (!obj.options[obj.selectedIndex].value.length)
18 val = obj.options[obj.selectedIndex].value;
20 ajax_request('setvar','source=gereinigt&name=year&value='+val,select_year_calback);
22 if (obj.options[obj.selectedIndex].value.length)
23 info('Jahr ' + obj.options[obj.selectedIndex].innerHTML + ' ausgewählt');
29 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
31 if (empty($_SESSION['gereinigt.year'])) $_SESSION['gereinigt.year'] = date('Y');
34 'table' => 'kostenstellen',
35 'title' => 'Gewässer gereinigt?',
36 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
39 'options' => discover_years(true),
40 'default' => 'Jahr wählen',
41 'selected' => $_SESSION['gereinigt.year'],
42 'onchange' => 'select_year(this)',
44 'variables' => array('year'),
48 'sql' => 'kostenstellen.id',
53 'sql' => 'gebiet.gebiet',
54 'specs' => "filterUI: 's'",
57 'kostenstelle' => array(
58 'name' => 'Kostenstelle',
59 'specs' => "filterUI: 's'",
63 'name' => 'gereinigt?',
65 'sql' => '(SELECT count(*) FROM gereinigt WHERE jahr = '
66 . intval($_SESSION['gereinigt.year'])
67 . ' AND gereinigt.kostenstelle = kostenstellen.id)',
68 'control' => "new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')",
69 'specs' => "filterUI: 'c'",
70 'update' => array('table' => 'gereinigt',
72 'baseval' => $_SESSION['gereinigt.year'],
73 'refcol' => 'kostenstelle',
74 'reftable' => 'kostenstellen',
75 'refid' => 'kostenstellen.id',
80 'name' => 'gereinigt',
82 'specs' => "ClassName: 'alignright'",