<?php
-# function mask_fields($list)
-# {
-# $ret = array();
-#
-# foreach ($list as $field => $data)
-# $ret[] = $field;
-#
-# return $ret;
-# }
-
-function build_form($name, $fields)
+function check_edit($name)
{
+ $sql = sprintf("SELECT sys_mask.id,edit FROM sys_mask "
+ . "JOIN sys_group_mask ON sys_mask.id = sys_group_mask.mask "
+ . "WHERE gid = %d AND fname = '%s' "
+ . "ORDER BY edit DESC LIMIT 1",
+ $_SESSION['sys']['group'], pg_escape_string($name));
+
+ $sth = pg_query($sql);
+
+ if ($sth === false) return false;
+
+ $row = pg_fetch_assoc($sth);
+ if ($row === false) return false;
+
+ if ($row['edit'] == '0')
+ return false;
+
+ return true;
+}
+
+function build_form($name, $mask)
+{
+ global $jscode;
$ret = array();
+ $jscode[] = 'Rico.onLoad( function() {';
+ $jscode[] = "form_init();";
+ $jscode[] = '});';
+
$ret[] = '<div class="form">';
- $ret[] = '<p id="form_title">Datensatz bearbeiten</p>';
+ if (empty($mask['edit_title']))
+ $ret[] = '<p class="title">Datensatz bearbeiten</p>';
+ else
+ $ret[] = sprintf('<p class="title">%s</p>', $mask['edit_title']);
$ret[] = '<form id="form_edit">';
$ret[] = '<input type="hidden" id="edit_id" name="id" value="">';
$ret[] = sprintf('<input type="hidden" id="edit_source" name="source" value="%s">', $name);
- foreach ($fields as $id => $info) {
- if ($info['type'] == 'text' || $info['type'] == 'passwd' || $info['type'] == 'number') {
+ foreach ($mask['edit'] as $id => $info) {
+ if ($info['type'] == 'hidden') {
+ $ret[] = sprintf('<input type="hidden" id="edit_%s" name="%s">', $id, $id);
+ } else if ($info['type'] == 'text' || $info['type'] == 'passwd' ||
+ $info['type'] == 'decimal' || $info['type'] == 'number') {
$v = array('id="edit_'.$id.'"',
'name="'.$id.'"');
$v[] = 'size="'.(empty($info['size'])?'10':$info['size']).'"';
$v[] = 'type="'.($info['type']=='passwd'?'password':'text').'"';
$ret[] = sprintf('<label for="edit_%s">%s</label><br>', $id, $info['name']);
- $ret[] = sprintf('<input %s><br>', implode(' ', $v));
+ $ret[] = sprintf('<input %s>', implode(' ', $v));
+ } elseif ($info['type'] == 'date') {
+ $ret[] = sprintf('<label for="edit_%s">%s</label><br>', $id, $info['name']);
+ $ret[] = sprintf('<input id="edit_%s" name="%s" size="8"> '.
+ '<img class="calendar" src="images/icons/calendar.gif" onclick="calendar(\'edit_%s\',event)" />',
+ $id, $id, $id);
} elseif ($info['type'] == 'boolean') {
$ret[] = sprintf('<label for="edit_%s">%s</label><br>', $id, $info['name']);
- $ret[] = sprintf('<input type="checkbox" id="edit_%s" name="%s"><br>', $id, $id);
+ $ret[] = sprintf('<input type="checkbox" id="edit_%s" name="%s">', $id, $id);
} elseif ($info['type'] == 'select') {
+ $v = array('id="edit_'.$id.'"',
+ 'name="'.$id.'"');
+ if (array_key_exists('onchange',$info))
+ $v[] = sprintf('onchange="%s"', $info['onchange']);
+
$ret[] = sprintf('<label for="edit_%s">%s</label><br>', $id, $info['name']);
- $ret[] = sprintf('<select id="edit_%s" name="%s">', $id, $id);
+ $ret[] = sprintf('<select %s>', implode(' ', $v));
if (is_array($info['options'])) $options = $info['options'];
else $options = query_db($info['options']);
foreach ($options as $row)
- $ret[] = sprintf('<option value="%s">%s</option>', $row['id'], $row['text']);
- $ret[] = '</select><br>';
- } elseif ($info['type'] == 'date') {
- error_log('type = date');
+ $ret[] = sprintf('<option value="%s"%s>%s</option>',
+ $row['id'],
+ !empty($info['selected']) && $row['id'] == $info['selected'] ? ' selected' : '',
+ $row['text']);
+ $ret[] = '</select>';
+ } elseif ($info['type'] == 'textarea') {
+ $ret[] = sprintf('<label for="edit_%s">%s</label><br>', $id, $info['name']);
+ $v = array('id="edit_'.$id.'"',
+ 'name="'.$id.'"');
+ $v[] = sprintf('cols="%d"', empty($info['columns'])?33:$info['columns']);
+ $v[] = sprintf('rows="%d"', empty($info['rows'])?5:$info['columns']);
+ $ret[] = sprintf('<textarea %s></textarea>', implode(' ', $v));
}
+ if (array_key_exists('comment',$info))
+ $ret[] = sprintf('<span class="comment">%s</span>', $info['comment']);
+ if ($info['type'] != 'hidden')
+ $ret[] = '<br>';
}
- $ret[] = '<span id="form_status"></span>';
+ $v_save = array('id="button_save"',
+ 'onclick="return form_save(this);"');
+ if ($mask['buttons']['save'] === false) $v_save[] = 'style="display: none"';
+
+ $v_insert = array('id="button_insert"',
+ 'onclick="return form_insert(this);"');
+ if ($mask['buttons']['insert'] === false) $v_insert[] = 'style="display: none"';
+
+ $v_delete = array('id="button_delete"',
+ 'onclick="return form_delete(this);"');
+ if ($mask['buttons']['delete'] === false) $v_delete[] = 'style="display: none"';
+
+ $ret[] = '<span id="form_status"> </span>';
$ret[] = '<div class="buttons">';
- $ret[] = '<button id="button_save" onclick="return form_save(this);">Speichern</button>';
+ $ret[] = sprintf('<button %s>%s</button>', implode(' ', $v_save), 'Speichern');
$ret[] = '<span></span>';
- $ret[] = '<button id="button_insert" onclick="return form_insert(this);">Hinzufügen</button>';
+ $ret[] = sprintf('<button %s>%s</button>', implode(' ', $v_insert), 'Hinzufügen');
$ret[] = '<span></span>';
- $ret[] = '<button id="button_delete" onclick="return form_delete(this);">Löschen</button>';
+ $ret[] = sprintf('<button %s>%s</button>', implode(' ', $v_delete), 'Löschen');
$ret[] = '</div>';
$ret[] = '</form>';
global $jscode;
$ret = array();
- $jscode[] = 'Rico.writeDebugMsg = function(msg, resetFlag) {};';
-
$opts = array("click: gridDrillDown",
"menuEvent: 'contextmenu'",
"highlightElem: 'menuRow'");
if ($data['width'] > 0) $s[] = 'width: ' . $data['width'];
if (array_key_exists('type', $data)) $s[] = "type: '" . $data['type'] . "'";
if (array_key_exists('specs', $data)) $s[] = $data['specs'];
+ if (array_key_exists('control', $data)) $s[] = 'control: ' . $data['control'];
$specs[] = '{' . implode(', ', $s) . '}';
if (array_key_exists('sql', $data))
else
$fields[] = $field;
}
- $_SESSION['grid_' . $name] = sprintf("SELECT %s FROM %s",
- implode(',', $fields), $mask['table']);
- if (array_key_exists('join', $mask)) $_SESSION['grid_' . $name] .= ' JOIN ' . join(' JOIN ', $mask['join']);
- if (array_key_exists('where', $mask)) $_SESSION['grid_' . $name] .= ' WHERE ' . $mask['where'];
+
+ grid_sql($name, $mask);
$ret[] = ' </tr>';
$ret[] = '</table>';
{
$ret = array();
-
$ret[] = '<div class="box" id="details">';
$ret[] = sprintf('<h3>%s</h3>', $details['title']);
if (array_key_exists('subtitle', $details))
$ret[] = sprintf('<p class="subtitle">%s</p>', $details['subtitle']);
- $ret[] = '<ul>';
- foreach ($details['list'] as $name => $info) {
- $ret[] = sprintf('<li>%s: <span id="detail_%s"></span></li>', $info['name'], $name);
+ if (array_key_exists('html',$details)) {
+ $ret[] = $details['html'];
+ } elseif (array_key_exists('list',$details)) {
+ $ret[] = '<ul>';
+ foreach ($details['list'] as $name => $info) {
+ $ret[] = sprintf('<li>%s: <span id="detail_%s"></span></li>', $info['name'], $name);
+ }
+ $ret[] = '</ul>';
+ }
+ $ret[] = '</div>';
+
+ return $ret;
+}
+
+function build_select($name, $details)
+{
+ $ret = array();
+
+ $ret[] = '<div class="form">';
+ $ret[] = sprintf('<p class="title">%s</p>', $details['title']);
+ $ret[] = sprintf ('<select%s>', array_key_exists('onchange',$details)?sprintf(' onchange="%s"',$details['onchange']):'');
+ if (is_array($details['options']))
+ $options = $details['options'];
+ else
+ $options = query_db($details['options']);
+
+ if (array_key_exists('default',$details))
+ $ret[] = sprintf('<option value="">%s</option>', $details['default']);
+
+ foreach ($options as $row) {
+ $selected = array_key_exists('selected',$details) && $details['selected'] == $row['id'] ? true : false;
+ $ret[] = sprintf('<option value="%s"%s>%s</option>', $row['id'], $selected?' selected':'',$row['text']);
}
- $ret[] = '</ul>';
+
+ $ret[] = '</select>';
$ret[] = '</div>';
return $ret;
function build_mask($name, $mask)
{
- $grid = build_grid($name, $mask);
+ global $jscode;
+ $jscode[] = 'Rico.writeDebugMsg = function(msg, resetFlag) {};';
+
+ if (array_key_exists('list', $mask))
+ $grid = build_grid($name, $mask);
+ else
+ $grid = array();
+
$status = array('<span id="status"></span><br>');
if (array_key_exists('details', $mask))
else
$details = array();
- if (array_key_exists('edit', $mask))
- $edit = build_form($name, $mask['edit']);
+ if (array_key_exists('select', $mask))
+ $select = build_select($name, $mask['select']);
+ else
+ $select = array();
+
+ if (array_key_exists('edit', $mask) && check_edit($name))
+ $edit = build_form($name, $mask);
else
$edit = array();
$head = array();
$head[] = sprintf('<h3>%s</h3>', $title);
- $head[] = '<div class="right">';
+
+ if (array_key_exists('html', $mask) &&
+ !array_key_exists('details', $mask) &&
+ !array_key_exists('select', $mask) &&
+ !array_key_exists('edit', $mask))
+ return array_merge($head, array($mask['html']),$status);
return array_merge($head,
+ array('<div class="right">'),
$grid,
array('</div>','<div class="left">'),
$details,
+ $select,
$edit,
$status,
array('</div>'));
$jsfiles[] = 'lib/functions.js';
$jsfiles[] = 'lib/rico/rico.js';
- if (array_key_exists('table',$mask) && array_key_exists('list',$mask))
+ if (array_key_exists('table',$mask))
$ret = build_mask($name, $mask);
- error_log(count($ret));
- return implode("\n", $ret);
+ return sprintf('<span id="source" style="display: none;">%s</span>', $_GET['mask'])
+ . implode("\n", $ret);
}
-?>
\ No newline at end of file
+?>