/** * 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); } ?>