- $sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
- implode(',', array_keys($mask['details']['list'])),
- $mask['table'], $_POST['id']);
+ $fields = array();
+ foreach ($mask['details']['list'] as $field => $info) {
+ if ($info['type'] == 'date')
+ $fields[] = sprintf("to_char(%s,'DD.MM.YYYY') AS %s",
+ empty($info['sql']) ? $field : $info['sql'],
+ $field);
+ elseif (!array_key_exists('fetch',$info))
+ $fields[] = empty($info['sql']) ? $field : $info['sql'] . ' AS ' . $field;
+ }