function headermenu()
{
$menuData = array();
ProjectCommon::GetTree(&$menuData, "view_menus", "ID_MNU", "ID_MNU_PARENT", 1, 1);
for ($i = 0; $i < count($menuData); $i++) {
$menuData[$i]['ACTID'] = $actid;
}
$menuData = array_values($menuData);
$menu->menu = ProjectCommon::buildMenuUL_LI(&$menuData);
return $menu;
}
/**
* Tạo select user từ select department
*
* @param int $DName tên combobox chứa danh sách department
* @param int $UName tên combobox chứa danh sách user thuộc department trên
* @return html code
*/
static function writeSelectDepartment($DName, $UName)
{
global $db;
$arr_user = '******' . $UName;
$department = array();
ProjectCommon::GetTree(&$department, "QTHT_DEPARTMENTS", "ID_DEP", "ID_DEP_PARENT", 1, 1);
$r = $db->query("\n\t\t\t\tSELECT\n\t\t\t\t\tDEP.ID_DEP,U.ID_U,CONCAT(E.FIRSTNAME , ' ' , E.LASTNAME) as NAME\n\t\t\t\tFROM\t\t\t\t\n\t\t\t\t\tQTHT_USERS U \n\t\t\t\t\tINNER JOIN QTHT_EMPLOYEES E ON E.ID_EMP = U.ID_EMP\n\t\t\t\t\tINNER JOIN QTHT_DEPARTMENTS DEP ON E.ID_DEP=DEP.ID_DEP\n\t\t\t\tORDER BY\n\t\t\t\t\tU.ORDERS, E.LASTNAME\n\t\t\t");
$user = $r->fetchAll();
$r->closeCursor();
$html .= " \t<select name={$DName} id={$DName} onchange='FillComboByCombo(this,document.getElementById(\"{$UName}\"),{$arr_user});'>";
$html .= " \t<option value=0>--Chọn phòng--</option>";
for ($i = 0; $i < count($department); $i++) {
$html .= " <option value=" . $department[$i]["ID_DEP"] . ">" . str_repeat("--", $department[$i]["LEVEL"]) . ($department[$i]["LEVEL"] > 1 ? "-> " : "") . $department[$i]["NAME"] . "</option>";
}
$html .= " </select>";
$html .= "<script>";
$html .= "\tvar {$arr_user} = new Array();";
for ($i = 0; $i < count($user); $i++) {
$html .= $arr_user . "[" . $i . "] = new Array('" . $user[$i]['ID_DEP'] . "','" . $user[$i]['ID_U'] . "','" . $user[$i]['NAME'] . "');";
}
$html .= "</script>";
return $html;
}
