3 $jscode[] = "Rico.moduleDependencies['checkboxDB'] = ['+LiveGrid', '../ricoTableColumnDB.js'];";
4 $jscode[] = "Rico.loadModule('checkboxDB');";
6 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
8 if (empty($_SESSION['gereinigt.year'])) $_SESSION['gereinigt.year'] = date('Y');
11 'table' => 'kostenstellen',
12 'title' => 'Gewässer gereinigt?',
13 'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
16 'options' => discover_years(true),
17 'default' => 'Jahr wählen',
18 'selected' => $_SESSION['gereinigt.year'],
19 'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
27 'sql' => 'kostenstellen.id',
32 'sql' => 'gebiet.gebiet',
33 'specs' => "filterUI: 's'",
36 'kostenstelle' => array(
37 'name' => 'Kostenstelle',
38 'specs' => "filterUI: 's'",
42 'name' => 'gereinigt',
44 'sql' => '(SELECT count(*) FROM gereinigt WHERE jahr = '
45 . intval($_SESSION['gereinigt.year'])
46 . ' AND gereinigt.kostenstelle = kostenstellen.id)',
47 'control' => "new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')",
48 'specs' => "filterUI: 'c', ClassName: 'aligncenter', canSort: false",
49 'update' => array('table' => 'gereinigt',
51 'baseval' => $_SESSION['gereinigt.year'],
52 'refcol' => 'kostenstelle',
53 'reftable' => 'kostenstellen',
54 'refid' => 'kostenstellen.id',