Formular-Definitionen
=====================

$mask
-----

  table = string
  tables_delete = array(string, ...)
  title = string
  subtitle = string
  where = string
  join = string
  rows = Integer
  sort = Integer
  sortdir = ASC | DESC
  maxprint = Integer (-> maxPrint, max exportable rows in table)
  prefetch = true / false (default true)
  html = string
  insert = Funktion
  postinsert = Funktion
  save = Funktion
  predelete = Funktion
  delete = Funktion
  list = array(col => array(), ...)
  edit = array(col => array(), ...)
  variables = array(col => array(), ...)
  details = array(id => array(), ...)
  buttons = array(id => boolean) (insert / save / delete)

  'select' => array(
                    'title' => 'Auswahl',
                    'options' => discover_years(),
                    'default' => 'Jahr wählen',
                    'selected' => $_SESSION['akkord_geraete.year'],
                    'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
                    ),
  info = array(id => array(), ...)
    'gebiete' => array('sql' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY text'),
                WHERE id = {id}

  second = {title, table, join, where, rows, sort, list, onclick}

Element list
------------

  name = string
  visible = Boolean
  width = Integer
  specs = String
    ClassName: 'aligncenter' / 'alignleft' /  'alignright' / 'alignrightpad',
    filterUI: 's' / 't' / 'c'
    canSort: true / false (default true)
    suffix: 'string'
    decPlaces: 2
  type = text / date (default text)
  sql = String
  required = true / false (default false)
  control = String
    new Rico.TableColumn.lookup(".grid_lookup_sql('hw_types','id','name').", 0, '')
    new Rico.TableColumn.link('javascript:personal_load({0})')
    new Rico.TableColumn.link('ajax/ajax.php?id={0}&source=documents__files&func=file&name=download','_top')";
    new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')
         'update' => array('table' => 'sys_group_mask',
                           'basecol' => 'gid',
                           'baseval' => $_SESSION[VARNAME],
                           'refcol' => 'mask',
                           'reftable' => 'sys_mask',
                           'refid' => 'sys_mask.id')

Element edit
------------

  name = String
  type = text / date / select / passwd / boolean / textarea / decimal / number / hidden / html
  size = Integer
  options = "SELECT id,name AS text FROM sys_group ORDER BY name" / array(id,text)
  options_string = true / false
  option_empty = String
  onchange = JavaScript
  selected = Integer
  null = true / false (default false)
  comment = String
  code = String (bei Typ html)

Element variables
-----------------

  array()

Element details
---------------

  title = String
  html = String
  list = Array(id => Array)

    fetch = Funktion


Zellen in der Liste editieren
-----------------------------

$jscode[] = <<<EOC
grid_column_edit[1] = {
    default_menu: false,
    width: '9em',
    values: [
	     ['löschen', '', 0],
	     ['1 mal bestellen', '1', 1],
	     ['2 mal bestellen', '2', 2],
	     ['3 mal bestellen', '3', 3],
	     ['4 mal bestellen', '4', 4],
	     ['5 mal bestellen', '5', 5],
	     ['6 mal bestellen', '6', 6],
	     ['7 mal bestellen', '7', 7],
	     ['8 mal bestellen', '8', 8],
	     ['9 mal bestellen', '9', 9]
	     ]
};
EOC;

'callbacks' => array('cellsave' => cell_save),


function cell_save()
{
  if ($_POST['value'] == 0)
    $sql = sprintf("UPDATE metro_ordersatz_pos SET anzahl = NULL, sys_user = '%s', sys_edit = now() WHERE ordersatz = %d AND artikel = %d",
		   pg_escape_string($_SESSION['sys']['login']),
		   $_SESSION['ordersatz'], $_POST['id']);
  else
    $sql = sprintf("UPDATE metro_ordersatz_pos SET anzahl = %d, sys_user = '%s', sys_edit = now() WHERE ordersatz = %d AND artikel = %d",
		   $_POST['value'], pg_escape_string($_SESSION['sys']['login']),
		   $_SESSION['ordersatz'], $_POST['id']);

  $sth = pg_query($sql);
  error_log($sql);
}