public function seeProfile($idUser = 37) { // echo '<pre>';print_r(Auth::user());exit; $idUser = 37; if (user::find($idUser) != false) { DB::statement("SET lc_time_names = 'es_ES'"); $dataUser = array('infoGeneral' => user::find($idUser), 'infoSocialin' => user::find($idUser)->socialin, 'infoExperience' => experienceModel::obtenerExperienciaPorUsuario($idUser), 'infoEducation' => educationModel::obtenerEstudiosPorUsuario($idUser), 'infoCourse' => courseModel::obtenerCursosPorUsuario($idUser)); // $doctor['infoLinkedin']['srcImage']=doctorModel::isImageHere($doctor['infoLinkedin']); // $doctor['infoLinkedin']['currentExperiences']=$exp->getCurrentExperience($idUser); // $doctor['infoLinkedin']['oldExperiences']=$exp->getOldExperience($idUser); // echo '<pre>';print_r($dataUser);exit; return view('perfil.show', ['dataUser' => $dataUser]); } else { //si el usuario no existe return redirect()->route('home'); } return view("perfil.show"); }
public function showEdit($id) { $menu = new menuModel(); $arrayMenu = $menu->generateMenu(); $isDoctor = $menu->isDoctor(); $exp = new experienceModel(); $doctor = array('infoGeneral' => doctorModel::find($id), 'infoLinkedin' => doctorModel::find($id)->linkedin, 'infoExperience' => json_decode(experienceModel::where('idtblDr', $id)->where('idcatstatus', '<>', '4')->orderBy('tblExperienceStartDate', 'desc')->get(), 2), 'infoEducation' => json_decode(educationModel::where('idtblDr', $id)->where('idcatstatus', '<>', '4')->orderBy('tblEducationStartDate', 'desc')->get(), 2), 'infoCourse' => json_decode(courseModel::where('idtblDr', $id)->where('idcatstatus', '<>', '4')->orderBy('tblCoursesDateInit', 'desc')->get(), 2)); $doctor['infoLinkedin']['srcImage'] = doctorModel::isImageHere($doctor['infoLinkedin']); $doctor['infoLinkedin']['currentExperiences'] = $exp->getCurrentExperience($id); $doctor['infoLinkedin']['oldExperiences'] = $exp->getOldExperience($id); return view('doctor.edit-perfil', ['doctor' => $doctor, 'menu' => $arrayMenu, 'isDoctor' => $isDoctor]); }
public static function obtenerExperienciaPorUsuario($idUser) { $courses = json_decode(experienceModel::where('idtblusers', $idUser)->where('idcatstatus', '<>', '4')->orderBy('tblexperiencestartdate', 'desc')->select('*', DB::raw("DATE_FORMAT(tblexperiencestartdate,' %M %Y ') as format_star_date_exp"), DB::raw("CONCAT(TIMESTAMPDIFF(MONTH,tblexperiencestartdate,tblexperienceenddate),' meses') AS diff_time"), DB::raw("IF(tblexperiencecurrent=1,'Actual'," . DB::raw("DATE_FORMAT(tblexperienceenddate,' %M %Y ')") . ") AS tblexperienceenddateIF"))->get(), 2); return $courses; }
public function obtenerExperiencias(Request $request) { $experience = new experienceModel(); $response = $experience->obtenerExperiencias($request); return $response; }
public function getOldExperience($idtblDr) { $experiencia = experienceModel::where('idtblDr', '=', $idtblDr)->where('idcatstatus', '<>', '4')->where('tblExperienceCurrent', '=', 'N')->orderby('tblExperienceEndDate', 'DESC')->get(); if ($experiencia != false) { return $experiencia; } else { return false; } }
public function updateStatusExperience($idExperience) { $experience = ['idcatstatus' => '4']; if (experienceModel::where('idtblExperience', '=', $idExperience)->update($experience)) { return true; } else { return false; } }