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]);
}
}
