/**
* Obtiene toda la información de un usuario
* @param base_model $obj_model Instancia de un modelo
* @param string $str_user Identificador de usuario (nickname).
* @return array Toda la información: user_id, nombre, email, nick, trato, idioma,...
*/
function getInfo(&$obj_model, $str_user)
{
if ($str_user == '') {
$ret_val = array('user_id' => '', 'name' => '', 'surname' => '', 'username' => 'guest', 'password' => '', 'email' => '', 'statut' => '', 'treatment' => '', 'language' => '', 'theme' => '', 'profile' => 'guest', 'isadmin' => false);
} else {
$ret_sql = $obj_model->Select('user', 'user_id, nom, prenom, username, password, email, statut, idtreatment, language, theme, profile', "username = {$str_user}");
if ($obj_model->hasError()) {
$ret_val = null;
} else {
//No incluimos información de la "tabla" o modelo de datos
$ret_val = array('user_id' => $ret_sql[0]['user_id'], 'name' => $ret_sql[0]['nom'], 'surname' => $ret_sql[0]['prenom'], 'username' => $ret_sql[0]['username'], 'password' => $ret_sql[0]['password'], 'email' => $ret_sql[0]['email'], 'statut' => $ret_sql[0]['statut'], 'treatment' => $ret_sql[0]['idtreatment'], 'language' => $ret_sql[0]['language'], 'theme' => $ret_sql[0]['theme'], 'profile' => $ret_sql[0]['profile']);
}
}
return $ret_val;
}
/**
* Devuelve el rol asociado al usuario que inició la sesión.
* @param base_model $obj_model Instancia de un modelo.
* @param int $user_id Identificador de usuario.
* @return int Devuelve el role o profile asociado a un usuario.
*
**/
function getRole(&$obj_model, $user_id)
{
$ret_sql = $obj_model->Select('user', 'id_profile', 'user_id = ' . $user_id);
if ($obj_model->hasError()) {
$ret_val = null;
} else {
$ret_val = $ret_sql[0]['user.id_profile'];
}
return $ret_val;
}
/**
* Obtiene la localización del curso dentro de la institución
* @param base_model $obj_model Instancia de un modelo
* @param string $course_id Identificador del curso.
* @return array Toda la informaciÛn: institucion, facultad, departamento y area
*/
function _getPath(&$obj_model, $course_id)
{
$ret_sql = $obj_model->Select('area_course', 'institution_id, faculty_id, department_id, area_id', 'course_id = ' . $course_id);
if ($obj_model->hasError()) {
$ret_val = null;
} else {
$institution_id = $ret_sql[0]['area_course.institution_id'];
$faculty_id = $ret_sql[0]['area_course.faculty_id'];
$department_id = $ret_sql[0]['area_course.department_id'];
$area_id = $ret_sql[0]['area_course.area_id'];
}
$ret_sql = $obj_model->Select('institution', 'institution_description', 'institution_id = ' . $institution_id);
if ($obj_model->hasError()) {
$institution_description = '';
} else {
$institution_description = $ret_sql[0]['institution.institution_description'];
}
$ret_sql = $obj_model->Select('faculty', 'faculty_description', 'faculty_id = ' . $faculty_id);
if ($obj_model->hasError()) {
$faculty_description = '';
} else {
$faculty_description = $ret_sql[0]['faculty.faculty_description'];
}
$ret_sql = $obj_model->Select('department', 'department_description', 'department_id = ' . $department_id);
if ($obj_model->hasError()) {
$department_description = '';
} else {
$department_description = $ret_sql[0]['department.department_description'];
}
$ret_sql = $obj_model->Select('area', 'area_description', 'area_id = ' . $area_id);
if ($obj_model->hasError()) {
$area_description = '';
} else {
$area_description = $ret_sql[0]['area.area_description'];
}
$ret_val = array('institution' => $institution_description, 'faculty' => $faculty_description, 'department' => $department_description, 'area' => $area_description);
return $ret_val;
}
