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; }