PHP Course::join方法代码示例

 public function getSortableCourses($sort = 'name', $direction = 'asc')
 {
     if (!in_array($sort, ['name', 'par'])) {
         $sort = 'name';
     }
     return Course::join('holes', 'holes.course_id', '=', 'courses.id')->select('courses.slug', 'courses.name', DB::raw('sum(holes.par) as par'))->orderBy($sort, $direction)->groupBy('courses.id')->paginate(10);
 }

 /**
  * @param Request $request
  * @param $code
  * @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
  */
 public function showCourseStatistics(Request $request, $code)
 {
     if ($request->ajax()) {
         $courses = Course::join('semesters', 'courses.semester_id', '=', 'semesters.id')->join('teachers', 'courses.teacher_id', '=', 'teachers.id')->select('courses.code as Code', 'courses.name as Title', 'teachers.name as Teacher', 'semesters.name as Semester')->where('courses.department_code', '=', $code)->get();
         $unassignedCourses = Course::join('semesters', 'courses.semester_id', '=', 'semesters.id')->select('courses.code as Code', 'courses.name as Title', 'courses.teacher_id as Teacher', 'semesters.name as Semester')->where('courses.department_code', '=', $code)->whereNull('courses.teacher_id')->get();
         return response([$courses, $unassignedCourses]);
     }
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($date, $area, $professorId = null)
 {
     if ($professorId == null) {
     }
     $insert_control = Insert_control::where('period', $date)->first();
     if ($insert_control == null) {
         $insert_control = 0;
     } else {
         $insert_control = $insert_control->available;
     }
     $userRole = Auth::user()->role()->first()->name;
     $dateExp = explode("-", $date);
     $year = $dateExp[0];
     $semester = $dateExp[1];
     $professor = Professor::find($professorId);
     $professorFromAreas = Area::where('name', $area)->first()->professors()->get();
     $arrayProfessors = array();
     foreach ($professorFromAreas as $professorFromArea) {
         $arrayProfessors[$professorFromArea->id] = $professorFromArea->name;
     }
     if (!isset($professor)) {
         $status = 1;
         $arrayProfessorss = $arrayProfessors;
         $arrayProfessorss[""] = "";
         return view('schedules.show', compact("status", "year", "semester", "arrayProfessorss"));
     }
     $todasAreas = Area::all()->toArray();
     $arrayAreas = array();
     foreach ($todasAreas as $unArea) {
         $arrayAreas[$unArea['id']] = $unArea['name'];
     }
     $professorLoad = 0;
     $arrayCourses = array();
     $areaCourses = Course::join('areas', 'areas.id', '=', 'courses.area_id')->where('areas.name', $area)->where('courses.year', $year)->where('courses.semester', $semester)->select('courses.id', 'courses.year', 'courses.semester', 'areas.name', 'courses.branch', 'courses.section', 'courses.code', 'courses.schedule')->get();
     $courseSelect = array();
     foreach ($areaCourses as $oneCourse) {
         if (count($oneCourse->schedule()->groupBy('professor_id')->get()) == 0) {
             $courseSelect[$oneCourse->id] = $oneCourse->code . "-" . $oneCourse->section . "-" . $oneCourse->year . "-" . $oneCourse->semester . " " . $oneCourse->branch . " (" . $oneCourse->schedule . ")";
         }
     }
     $schedules = Schedule::join('courses', 'courses.id', '=', 'schedules.course_id')->where('schedules.professor_id', $professorId)->where('courses.year', $year)->where('courses.semester', $semester)->get();
     foreach ($schedules as $schedule) {
         $course = array();
         $code = $schedule->course()->first()->code;
         $course['name'] = $schedule->course()->first()->name;
         $course['area'] = $arrayAreas[$schedule->course()->first()->area_id];
         $course['branch'] = $schedule->course()->first()->branch;
         $course['section'] = $schedule->course()->first()->section;
         $course['semester'] = $schedule->course()->first()->semester;
         $course['id'] = $schedule->course()->first()->id;
         $course['year'] = $schedule->course()->first()->year;
         $course['schedule'] = explode("-", $schedule->course()->first()->schedule);
         $course['code'] = $code;
         $arrayCourses[$code . "-" . $course['section']] = $course;
         // $professorLoad = $professorLoad + count($course['schedule'])*22.5;
         foreach ($course['schedule'] as $horario) {
             $array[$horario] = $course['code'] . "-" . $course['section'];
         }
     }
     $schedulesYear = Schedule::join('courses', 'courses.id', '=', 'schedules.course_id')->where('schedules.professor_id', $professorId)->where('courses.year', $year)->get();
     foreach ($schedulesYear as $sche) {
         $professorLoad = $professorLoad + count(explode("-", $sche->course()->first()->schedule)) * 22.5;
     }
     if ($semester == 1) {
         $nextSemester = 2;
         $nextYear = $year;
         $previewsYear = $year - 1;
     } else {
         $nextSemester = 1;
         $nextYear = $year + 1;
         $previewsYear = $year;
     }
     $nextDate = $nextYear . "-" . $nextSemester;
     $previewsDate = $previewsYear . "-" . $nextSemester;
     $urlAnterior = "schedules/{$previewsDate}/{$area}/{$professor->id}";
     $urlSiguiente = "schedules/{$nextDate}/{$area}/{$professor->id}";
     return view('schedules.show', compact('year', 'semester', 'urlAnterior', 'urlSiguiente', 'professor', 'courseSelect', 'arrayCourses', 'arrayProfessors', 'array', 'area', 'professorLoad', 'userRole', 'insert_control'));
 }

 /**
  * Using this method for two different AJAX request. One for enroll course & one for save result
  *
  * Display the specified resource.
  *
  * @param Request $request
  * @param $id
  * @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
  */
 public function show(Request $request, $id)
 {
     if ($request->ajax()) {
         $studentInfo = Student::join('departments', 'students.department_code', '=', 'departments.code')->select('students.name', 'students.email', 'students.department_code', 'departments.name as department')->where('students.registration_no', '=', $id)->first();
         if ($request->has('grade')) {
             /**
              * Select courses of a student which is not being graded
              * @var TYPE_NAME $courses
              */
             $courses = Course::join('course_student', 'courses.code', '=', 'course_student.course_code')->select('courses.code', 'courses.name')->where('course_student.student_registration_no', $id)->where(function ($query) {
                 $query->whereNull('course_student.grade')->orWhere('course_student.grade', '');
             })->get();
         } elseif ($request->has('result')) {
             $student = Student::find($id);
             /** Check whether user can see the result
              * @var TYPE_NAME $this */
             $this->authorize('viewResult', $student);
             $courses = Course::join('course_student', 'courses.code', '=', 'course_student.course_code')->select('courses.code', 'courses.name', 'course_student.grade')->where('course_student.student_registration_no', $id)->get();
         } else {
             $courses = Course::select('courses.code', 'courses.name')->where('courses.department_code', '=', $studentInfo->department_code)->whereNotIn('courses.code', function ($query) use($id) {
                 $query->select('course_student.course_code')->from('course_student')->where('course_student.student_registration_no', '=', $id);
             })->get();
         }
         return response([$studentInfo, $courses]);
     }
 }