8 tables_delete = array(string, ...)
15 maxprint = Integer (-> maxPrint, max exportable rows in table)
16 prefetch = true / false (default true)
23 list = array(col => array(), ...)
24 edit = array(col => array(), ...)
25 variables = array(col => array(), ...)
26 details = array(id => array(), ...)
27 buttons = array(id => boolean) (insert / save / delete)
31 'options' => discover_years(),
32 'default' => 'Jahr wählen',
33 'selected' => $_SESSION['akkord_geraete.year'],
34 'onchange' => "setvar(this,'year',select_year_calback,select_year_status)",
36 info = array(id => array(), ...)
37 'gebiete' => array('sql' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY text'),
40 second = {title, table, join, where, rows, sort, list, onclick}
49 ClassName: 'aligncenter' / 'alignleft' / 'alignright' / 'alignrightpad',
50 filterUI: 's' / 't' / 'c'
51 canSort: true / false (default true)
54 type = text / date (default text)
56 required = true / false (default false)
58 new Rico.TableColumn.lookup(".grid_lookup_sql('hw_types','id','name').", 0, '')
59 new Rico.TableColumn.link('javascript:personal_load({0})')
60 new Rico.TableColumn.link('ajax/ajax.php?id={0}&source=documents__files&func=file&name=download','_top')";
61 new Rico.TableColumn.checkboxDB(0, 'ajax/ricoUpdateConnection.php')
62 'update' => array('table' => 'sys_group_mask',
64 'baseval' => $_SESSION[VARNAME],
66 'reftable' => 'sys_mask',
67 'refid' => 'sys_mask.id')
73 type = text / date / select / passwd / boolean / textarea / decimal / number / hidden / html
75 options = "SELECT id,name AS text FROM sys_group ORDER BY name" / array(id,text)
76 options_string = true / false
80 null = true / false (default false)
82 code = String (bei Typ html)
94 list = Array(id => Array)
99 Zellen in der Liste editieren
100 -----------------------------
103 grid_column_edit[1] = {
108 ['1 mal bestellen', '1', 1],
109 ['2 mal bestellen', '2', 2],
110 ['3 mal bestellen', '3', 3],
111 ['4 mal bestellen', '4', 4],
112 ['5 mal bestellen', '5', 5],
113 ['6 mal bestellen', '6', 6],
114 ['7 mal bestellen', '7', 7],
115 ['8 mal bestellen', '8', 8],
116 ['9 mal bestellen', '9', 9]
121 'callbacks' => array('cellsave' => cell_save),
126 if ($_POST['value'] == 0)
127 $sql = sprintf("UPDATE metro_ordersatz_pos SET anzahl = NULL, sys_user = '%s', sys_edit = now() WHERE ordersatz = %d AND artikel = %d",
128 pg_escape_string($_SESSION['sys']['login']),
129 $_SESSION['ordersatz'], $_POST['id']);
131 $sql = sprintf("UPDATE metro_ordersatz_pos SET anzahl = %d, sys_user = '%s', sys_edit = now() WHERE ordersatz = %d AND artikel = %d",
132 $_POST['value'], pg_escape_string($_SESSION['sys']['login']),
133 $_SESSION['ordersatz'], $_POST['id']);
135 $sth = pg_query($sql);