public function show($id) { $menu = new menuModel(); $arrayMenu = $menu->generateMenu(); $isDoctor = $menu->isDoctor(); $exp = new experienceModel(); if (doctorModel::find($id) != false) { $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); $doctor['infoGeneral']['hospital'] = doctorModel::obtenerDoctor($id); return view('doctor.show-perfil', ['doctor' => $doctor, 'menu' => $arrayMenu, 'isDoctor' => $isDoctor]); } else { //si el usuario no existe return redirect()->route('home'); } }