$query = 'SELECT * FROM "' . TABLE_DEPARMENT . '" WHERE ' . $where . ' ORDER BY name ' . $sort_dep_dir; $db->query($query); $departments = $db->value; for ($i = 0; $i < count($departments); $i++) { $employees = array_merge($employees, get_employee_in_dep($departments[$i]['id_department'], $sort_dep_dir)); } return $employees; } $employees = get_employee_in_dep($department_id, $sort_dir); $employees = array_slice($employees, $from, LIMIT_EMPLOYEE_ON_PAGE); $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_EMPLOYEE_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars, 'Aclick'); } $dep = new department(); $emp = new employee(); for ($i = 0; $i < count($employees); $i++) { $dep->Init(); $dep->id_department = $employees[$i]['department_id']; $dep->Load(); $n = 0; $employees[$i]['department'] = array(); $employees[$i]['department'][$n]['dep'] = $dep->name; if ($dep->head_id != 0) { $emp->id_employee = $dep->head_id; $emp->Load(); $employees[$i]['department'][$n]['head'] = $emp->name; } else { $employees[$i]['department'][$n]['head'] = ''; } while ($dep->parent_id != 0) { $n++; $dep->id_department = $dep->parent_id;