Пример #1
0
 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");
 }
Пример #2
0
 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]);
 }
Пример #3
0
 public function obtenerCursos($request)
 {
     $course = courseModel::where('idtblDr', '=', $request->idtblDr)->where('idcatstatus', '<>', '4')->get();
     if ($course) {
         return Response::json(array('success' => '1', 'data' => $course, 'msg' => 'Registros obtenidos con exito.'));
     } else {
         return Response::json(array('success' => '0', 'data' => '', 'msg' => 'No hay registro asociados'));
     }
 }
Пример #4
0
 public function updateStatusCourse($idtblCourses)
 {
     $education = ['idcatstatus' => '4'];
     if (courseModel::where('idtblCourses', '=', $idtblCourses)->update($education)) {
         return true;
     } else {
         return false;
     }
 }
Пример #5
0
 public static function obtenerCursosPorUsuario($idUser)
 {
     $courses = json_decode(courseModel::where('idtblusers', $idUser)->where('idcatstatus', '<>', '4')->orderBy('tblcoursesdateinit', 'desc')->select('*', DB::raw("DATE_FORMAT(tblcoursesdateinit,' %M %Y ') as format_star_date_course"), DB::raw("CONCAT(TIMESTAMPDIFF(MONTH,tblcoursesdateinit,tblcoursesdateend),' meses') AS diff_time"), DB::raw("IF(tblcoursescurrent=1,'Actual'," . DB::raw("DATE_FORMAT(tblcoursesdateend,' %M %Y ')") . ") AS tblcourseenddateIF"))->get(), 2);
     return $courses;
 }
Пример #6
0
 public function obtenerCursos(Request $request)
 {
     $course = new courseModel();
     $response = $course->obtenerCursos($request);
     return $response;
 }