git.infodrom.org Git - misc/kostenrechnung/blob - masks/gereinigt.php

   1 <?php
   2
   3 $jscode[] = <<<EOC
   4
   5 Rico.moduleDependencies['checkboxDB'] = ['+LiveGrid', '../ricoTableColumnDB.js'];
   6 Rico.loadModule('checkboxDB');
   7
   8 function select_year_calback(data)
   9 {
  10   grid_update(grid);
  11 }
  12
  13 function select_year(obj)
  14 {
  15   if (!obj.options[obj.selectedIndex].value.length)
  16     val = -1;
  17   else
  18     val = obj.options[obj.selectedIndex].value;
  19
  20   ajax_request('setvar','source=gereinigt&name=year&value='+val,select_year_calback);
  21
  22   if (obj.options[obj.selectedIndex].value.length)
  23     info('Jahr ' + obj.options[obj.selectedIndex].innerHTML + ' ausgewählt');
  24   else
  25     info('');
  26 }
  27 EOC;
  28
  29 include_once($_SESSION['sys']['basedir'].'/lib/overview_utils.php');
  30
  31 if (empty($_SESSION['gereinigt.year'])) $_SESSION['gereinigt.year'] = date('Y');
  32
  33 $mask = array(
  34               'table' => 'kostenstellen',
  35               'title' => 'Gewässer gereinigt?',
  36               'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
  37               'select' => array(
  38                                 'title' => 'Auswahl',
  39                                 'options' => discover_years(true),
  40                                 'default' => 'Jahr wählen',
  41                                 'selected' => $_SESSION['gereinigt.year'],
  42                                 'onchange' => 'select_year(this)',
  43                                 ),
  44               'variables' => array('year'),
  45               'list' => array(
  46                               'id' => array(
  47                                             'name' => 'ID',
  48                                             'sql' => 'kostenstellen.id',
  49                                             'visible' => false,
  50                                             ),
  51                               'gebiet' => array(
  52                                             'name' => 'Gebiet',
  53                                             'sql' => 'gebiet.gebiet',
  54                                             'specs' => "filterUI: 's'",
  55                                             'width' => 220,
  56                                             ),
  57                               'kostenstelle' => array(
  58                                             'name' => 'Kostenstelle',
  59                                             'specs' => "filterUI: 's'",
  60                                             'width' => 220,
  61                                             ),
  62                               'gereinigt' => array(
  63                                             'name' => 'gereinigt?',
  64                                             'width' => 40,
  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',
  71                                                               'basecol' => 'jahr',
  72                                                               'baseval' => $_SESSION['gereinigt.year'],
  73                                                               'refcol' => 'kostenstelle',
  74                                                               'reftable' => 'kostenstellen',
  75                                                               'refid' => 'kostenstellen.id',
  76                                                               ),
  77                                             ),
  78 /*
  79                               'gereinigt' => array(
  80                                             'name' => 'gereinigt',
  81                                             'type' => 'number',
  82                                             'specs' => "ClassName: 'alignright'",
  83                                             'width' => 60,
  84                                             ),
  85 */
  86                               ),
  87               'rows' => 20,
  88               );
  89
  90 ?>