function getUserInfo($id)
{
$usr_info = mysql_fetch_object(listAll("user", "WHERE id = '{$id}'"));
$descripcion = getUserData($id, "2");
$user_img = getUserData($id, "1");
$direccion = getUserData($id, "3");
$ciudad = getUserData($id, "10");
$cp = getUserData($id, "4");
$pais = getUserData($id, "5");
$telefono = getUserData($id, "6");
$movil = getUserData($id, "7");
$exp = getUserData($id, "14");
$cam = getUserData($id, "11");
$lentes = getUserData($id, "12");
$equip = getUserData($id, "13");
$cover = getUserData($id, "16");
$user_pago = getUserData($id, "17");
$escuelaFotografia = getUserData($id, "18");
$masEducacion = getUserData($id, "19");
$experienciaLaboral = getRecentUserData($id, "20");
$idiomas = getUserData($id, "22");
$habilidades = getUserData($id, "21");
$rut = getUserData($id, "23");
if ($usr_info->gender == "H") {
$gender = "Hombre";
} else {
$gender = "Mujer";
}
$paisf = listAll("paises", "WHERE iso = '{$pais->description}'");
$rs_paisf = mysql_fetch_object($paisf);
$user['id'] = $usr_info->id;
$user['user_type'] = $usr_info->user_type;
$user['email'] = $usr_info->user;
$user['new_email'] = $usr_info->new_email;
$user['new_email_code'] = $usr_info->new_email_code;
$user['descripcion'] = $descripcion->description;
$user['user_img'] = $user_img->description;
$user["name"] = $usr_info->name;
$user['lastname'] = $usr_info->lastname;
$user['dob'] = DateHelper::getLongDate($usr_info->dob);
$user['user_dob'] = DateHelper::getShortDate($usr_info->dob, 'd/m/Y');
$user['sex'] = $gender;
$user['act'] = $usr_info->act;
$dob = explode("-", $usr_info->dob);
$user['ano'] = $dob[0];
$user['mes'] = $dob[1];
$user['dia'] = $dob[2];
$user['direccion'] = $direccion->description;
$user['ciudad'] = $ciudad->description;
$user['cp'] = $cp->description;
$user['pais'] = utf8_encode($rs_paisf->nombre);
$user['pais_ab'] = utf8_encode($rs_paisf->iso);
$user['telefono'] = $telefono->description;
$user['movil'] = $movil->description;
$user['exp'] = $exp->description;
$user['escuela-fotografia'] = $escuelaFotografia->description;
$user['mas-educacion'] = $masEducacion->description;
$user['experiencia-laboral'] = json_decode($experienciaLaboral->description);
$user['idiomas'] = json_decode($idiomas->description);
$user['habilidades'] = json_decode($habilidades->description);
$user['rut'] = $rut->description;
$user['cam'] = json_decode($cam->description);
$user['lentes'] = json_decode($lentes->description);
$user['equip'] = json_decode($equip->description);
$user["act_code"] = $usr_info->act_code;
$user["profile_completed"] = $usr_info->profile_completed;
$user["wizard_completed"] = $usr_info->wizard_completed;
$user["wizard_contact_creative_completed"] = $usr_info->wizard_contact_creative_completed;
$user['user_cover'] = $cover->description;
$user['user_pago'] = $user_pago->description;
$user['full_name'] = ucwords($user["name"] . " " . $user['lastname']);
//TODO make it an external function
//TODO set a default image if file does not exists
if (file_exists(FConfig::getBasePath() . "/profiles/" . sha1($usr_info->id) . "/profile.jpg")) {
$user['profile_image_url'] = "profiles/" . sha1($usr_info->id) . "/profile.jpg";
} else {
if ($user['user_type'] == User::USER_TYPE_PHOTOGRAPHER) {
$user['profile_image_url'] = "images/profile_default_photographer.jpg";
} else {
$user['profile_image_url'] = "images/profile_default_client.jpg";
}
}
if (file_exists(FConfig::getBasePath() . "/profiles/" . sha1($usr_info->id) . "/cover.jpg")) {
$user['cover_image_url'] = "profiles/" . sha1($usr_info->id) . "/cover.jpg";
} else {
$user['cover_image_url'] = "images/cover_default.jpg";
}
return $user;
}
public static function getUserProfilePath($userId)
{
return FConfig::getBasePath('/profiles/' . sha1($userId) . "/");
}
public static function getUserInfo($id, $fields = array())
{
$usr_info = ORM::for_table(self::$table)->find_one($id);
if ($usr_info == null) {
return false;
}
$user = array();
//User table fields
$user['id'] = $usr_info->id;
$user['user_type'] = $usr_info->user_type;
$user['email'] = $usr_info->user;
$user['new_email'] = $usr_info->new_email;
$user['new_email_code'] = $usr_info->new_email_code;
$user["name"] = $usr_info->name;
$user['lastname'] = $usr_info->lastname;
$user['user_dob'] = DateHelper::getShortDate($usr_info->dob, 'd/m/Y');
$user['act'] = $usr_info->act;
$user["act_code"] = $usr_info->act_code;
$user["profile_completed"] = $usr_info->profile_completed;
$user["wizard_completed"] = $usr_info->wizard_completed;
$user["wizard_contact_creative_completed"] = $usr_info->wizard_contact_creative_completed;
$user['full_name'] = ucwords($user["name"] . " " . $user['lastname']);
//Gender
if ($usr_info->gender == "H") {
$gender = "Hombre";
} else {
$gender = "Mujer";
}
$user['sex'] = $gender;
// $user['dob']= DateHelper::getLongDate($usr_info->dob);
//Process only desired fields
if (in_array('*', $fields) || in_array('descripcion', $fields)) {
$descripcion = self::getUserData($id, "2");
$user['descripcion'] = $descripcion->description;
}
if (in_array('*', $fields) || in_array('user_img', $fields)) {
$user_img = self::getUserData($id, "1");
$user['user_img'] = $user_img->description;
}
if (in_array('*', $fields) || in_array('direccion', $fields)) {
$direccion = self::getUserData($id, "3");
$user['direccion'] = $direccion->description;
}
if (in_array('*', $fields) || in_array('ciudad', $fields)) {
$ciudad = self::getUserData($id, "10");
$user['ciudad'] = $ciudad->description;
}
if (in_array('*', $fields) || in_array('cp', $fields)) {
$cp = self::getUserData($id, "4");
$user['cp'] = $cp->description;
}
if (in_array('*', $fields) || in_array('pais', $fields)) {
$pais = self::getUserData($id, "5");
$rs_paisf = Country::loadCountriesByIso($pais->description);
$user['pais'] = utf8_encode($rs_paisf->nombre);
$user['pais_ab'] = utf8_encode($rs_paisf->iso);
}
if (in_array('*', $fields) || in_array('telefono', $fields)) {
$telefono = self::getUserData($id, "6");
$user['telefono'] = $telefono->description;
}
if (in_array('*', $fields) || in_array('movil', $fields)) {
$movil = self::getUserData($id, "7");
$user['movil'] = $movil->description;
}
//Todocheck if in use
// if (in_array('*', $fields) || in_array('exp', $fields)) {
// $exp = self::getUserData($id, "14");
// $user['exp'] = $exp->description;
// }
if (in_array('*', $fields) || in_array('cam', $fields)) {
$cam = self::getUserData($id, "11");
$user['cam'] = json_decode($cam->description);
}
if (in_array('*', $fields) || in_array('rut', $fields)) {
$rut = self::getUserData($id, "23");
$user['rut'] = $rut->description;
}
if (in_array('*', $fields) || in_array('lentes', $fields)) {
$lentes = self::getUserData($id, "12");
$user['lentes'] = json_decode($lentes->description);
}
if (in_array('*', $fields) || in_array('', $fields)) {
$equip = self::getUserData($id, "13");
$user['equip'] = json_decode($equip->description);
}
//Deprecated
// if (in_array('*', $fields) || in_array('user_cover', $fields)) {
// $cover = self::getUserData($id, "16");
// $user['user_cover'] = $cover->description;
// }
//TODO Used for paypal account, check if needed
if (in_array('*', $fields) || in_array('user_pago', $fields)) {
$user_pago = self::getUserData($id, "17");
$user['user_pago'] = $user_pago->description;
}
if (in_array('*', $fields) || in_array('escuela-fotografia', $fields)) {
$escuelaFotografia = self::getUserData($id, "18");
$user['escuela-fotografia'] = $escuelaFotografia->description;
}
if (in_array('*', $fields) || in_array('mas-educacion', $fields)) {
$masEducacion = self::getUserData($id, "19");
$user['mas-educacion'] = $masEducacion->description;
}
if (in_array('*', $fields) || in_array('experiencia-laboral', $fields)) {
$experienciaLaboral = self::getRecentUserData($id, "20");
$user['experiencia-laboral'] = json_decode($experienciaLaboral->description);
}
if (in_array('*', $fields) || in_array('idiomas', $fields)) {
$idiomas = self::getUserData($id, "22");
$user['idiomas'] = json_decode($idiomas->description);
}
if (in_array('*', $fields) || in_array('habilidades', $fields)) {
$habilidades = self::getUserData($id, "21");
$user['habilidades'] = json_decode($habilidades->description);
}
//Cover and profile image fields
if (file_exists(FConfig::getBasePath() . "/profiles/" . sha1($usr_info->id) . "/profile.jpg")) {
$user['profile_image_url'] = "profiles/" . sha1($usr_info->id) . "/profile.jpg";
} else {
if ($user['user_type'] == User::USER_TYPE_PHOTOGRAPHER) {
$user['profile_image_url'] = "images/profile_default_photographer.jpg";
} else {
$user['profile_image_url'] = "images/profile_default_client.jpg";
}
}
if (file_exists(FConfig::getBasePath() . "/profiles/" . sha1($usr_info->id) . "/cover.jpg")) {
$user['cover_image_url'] = "profiles/" . sha1($usr_info->id) . "/cover.jpg";
} else {
$user['cover_image_url'] = "images/cover_default.jpg";
}
return $user;
}
