/**
* Get columns.
*
* @return array
*/
private function getColumns()
{
$cols = $this->handler->columns($this->model);
$result = [];
foreach ($cols as $field) {
$result[$field] = ['title' => fieldName($field)];
}
return $result;
}
function dateselect($name, $val = 0, $duration = FALSE)
{
if ($val == 0 || $val == '' || $val === NULL) {
$val = time();
}
$months = array(01 => 'Jan', 02 => 'Feb', 03 => 'Mar', 04 => 'Apr', 05 => 'May', 06 => 'Jun', 07 => 'Jul', 00 => 'Aug', 00 => 'Sep', 10 => 'Oct', 11 => 'Nov', 12 => 'Dec');
$arr = array('year' => array('dstr' => 'Y', 'str' => '%.4d', 'low' => 1997, 'high' => 2005, 'suffix' => '-'), 'month' => array('dstr' => 'm', 'str' => '%.3s', 'high' => 12, 'index' => $months, 'suffix' => '-'), 'day' => array('dstr' => 'd', 'high' => 31, 'suffix' => ' at ', 'def' => 14), 'hour' => array('dstr' => 'H', 'high' => 23, 'suffix' => ':'), 'minute' => array('dstr' => 'i', 'high' => 59, 'suffix' => ':'), 'second' => array('dstr' => 's', 'high' => 59));
if ($duration) {
$arr['year']['low'] = 0;
$arr['year']['high'] = 1;
}
$defaultelem = array('dstr' => '', 'str' => '%.2d', 'low' => 0, 'high' => 5, 'prefix' => '', 'suffix' => '', 'def' => 0);
foreach ($arr as $key => $data) {
$arr[$key] = array_merge($defaultelem, $arr[$key]);
}
foreach ($arr as $key => $data) {
if (!$duration) {
$arr[$key]['current'] = date($data['dstr'], $val);
} else {
$arr[$key]['current'] = $arr[$key]['def'];
unset($arr[$key]['index']);
}
$arr[$key]['values'] = seq($arr[$key]['low'], $arr[$key]['high']);
}
$str = '';
foreach ($arr as $key => $data) {
if (isset($data['index'])) {
$v = $data['index'];
} else {
$v = array();
foreach ($data['values'] as $d) {
$v[$d] = sprintf($data['str'], $d);
}
}
$str .= $data['prefix'] . selectinput(fieldName($name, $key), $v, $data['current']) . $data['suffix'];
}
if (!$duration) {
$str .= '(YYYY-MMM-DD HH-MM-SS)';
} else {
$str .= '(YYYY-MM-DD HH-MM-SS) [duration]';
}
return $str;
}
$idEdit = v('id');
$tableEdit = v('table');
$cols = MySQL_arrayToSequence($tableData[$tableName]['_view_cols'], FALSE, FALSE);
if (empty($tableData[$tableName]['_idkey'])) {
die("Trying to edit a table {$tableName} without any ID key!\n");
}
$query = $tableData[$tableName]['_view_sql_all'] . ' WHERE ' . $tableData[$tableName]['_idkey'] . '=' . MySQL_quote($idEdit);
if (dodbg()) {
echo 'Query: ' . $query . "<br />\n";
}
global $MySQL_singleton_abort;
$editData = MySQL_singletonassoc($query);
if ($editData === $MySQL_singleton_abort) {
die("Data abort! Query: {$query}\n");
}
echo hiddeninput(fieldName($tableName, $tableData[$tableName]['_idkey']), $idEdit);
}
echo hiddeninput('table', $tableName);
echo hiddeninput('perm', $perm);
echo "\n";
?>
<table class="dataform">
<?php
$data = NULL;
if ($editData !== NULL) {
$data = $editData;
}
foreach ($tableData[$tableName]['_view_cols'] as $itemkey) {
formelement($tableName, $tableData, $itemkey, $data);
}
?>
