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