function ShowMenuItems($id)
{
global $db;
$sql = "SELECT id, name, position, parent_id FROM menus WHERE parent_id='" . $id . "' ORDER by position";
//$columns['id'] = new Column_Number('ID', 0);
$columns['name'] = new Column('Название');
$columns['position'] = new Column_Number('Позиция', 0);
if ($id != 0) {
$columns['back'] = new Column_Custom('Назад', '<input type="button" value="<" onClick="GoURL(\'?id=' . GetParentID($id) . '\')" />');
}
$columns['more'] = new Column_UserFunc('Далее', 'GetChildIDButton', array('id'));
// $columns['more'] = new Column_Button('Далее', '', 'id', '>>>');
$table = new Table($db, 'menu_edit', $sql, $columns);
$table->Show_PageSwitch(false);
$table->Show();
}
function GetObject($overhead_id, $type)
{
$data = '';
if ($type == 6) {
$req = mysql_query("SELECT `id`, `name`\n\t\t\t\t\t\t\tFROM `object`\n\t\t\t\t\t\t\tWHERE `type` = 2 || `type` = 6");
// <<<<---------------------Type!!!
if (!empty($overhead_id)) {
$par_id = GetParentID($overhead_id);
$obj = mysql_fetch_assoc(mysql_query("SELECT `object_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `reserve`\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE `overhead_id` = {$par_id}\r\n\t\t\t\t\t\t\t\t\t\t\t\t GROUP BY `overhead_id`"));
}
} else {
$req = mysql_query("SELECT `id`, `name`\r\n\t\t\t\t\t\t\tFROM `object`\r\n\t\t\t\t\t\t\tWHERE `type` = 2 || `type` = 6");
// <<<<---------------------Type!!!
if (!empty($overhead_id)) {
$obj = mysql_fetch_assoc(mysql_query("SELECT `object_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `reserve`\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE `overhead_id` = {$overhead_id}\r\n\t\t\t\t\t\t\t\t\t\t\t\t GROUP BY `overhead_id`"));
}
}
while ($res = mysql_fetch_assoc($req)) {
if ($res['id'] == $obj['object_id']) {
$data .= '<option value="' . $res['id'] . '" selected="selected">' . $res['name'] . '</option>';
} else {
$data .= '<option value="' . $res['id'] . '">' . $res['name'] . '</option>';
}
}
return $data;
}
