/** * Show the application dashboard. * * @return Response */ public function index() { // Get an array of courses which this instructor has created $courses = Course::where('instructor_id', '=', Auth::id())->get(); // Render the view, passing the courses array into it return view('home')->with('courses', $courses); }
public function show($slug) { $course = Course::where('slug', $slug)->firstOrFail(); $breadcrumbs = array(action('HomeController@show') => 'Início', action('CourseController@all') => 'Cursos', action('CourseController@show', $slug) => $course->name); $previous = action('CourseController@all'); return view('course', compact('breadcrumbs', 'previous', 'course')); }
public function new_courses() { Course::where('offered_this_semester', true)->update(['offered_this_semester' => false]); $courseSeeder = new \CourseTableSeeder(); $courseSeeder->run(); return redirect(route('course.index')); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create($course_url, $stage_url) { $curso = Course::where('url', $course_url)->first(); $etapa = Stage::where('url', $stage_url)->where('course_id', $curso->id)->first(); $tiposItem = ItemType::all()->pluck('name', 'id'); return view('pages.items.create', ['curso' => $curso, 'etapa' => $etapa, 'tiposItem' => $tiposItem]); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($course_url, $stage_url, $url) { $curso = Course::where('url', $course_url)->first(); $etapa = Stage::where('url', $stage_url)->first(); $item = Item::where('url', $url)->first(); $tiposItem = ItemType::all()->pluck('name', 'id'); return view('pages.items.edit', ['curso' => $curso, 'etapa' => $etapa, 'item' => $item, 'tiposItem' => $tiposItem]); }
public function getCourseInCategory($category_slug, $course_slug) { $category = Category::where('slug', $category_slug)->first(); // find id of slug $matchThese = ['category_id' => $category->id, 'slug' => $course_slug]; $course = Course::where($matchThese)->first(); return view('courses.show')->with('course', $course); }
public function getRemoved($crn) { $course_id = \App\Course::where('crn', '=', $crn)->first()->id; $user = \Auth::user(); $user->courses()->detach($course_id); \Session::flash('flash_message', 'The course was removed from your list!'); return redirect()->back(); }
public function showElectiveSelectionView() { // Get electives $electives = Course::where('dCode', Auth::guard('teacher')->user()->dCode)->where(function ($q) { $q->where('openElective', true)->orWhere('departmentElective', true); })->get(); return view($this->electiveSelectionView, ['electives' => $electives]); }
/** * Show courses currently present in database * * @return mixed */ public function manageCourses() { // Get the list of courses $courses = Course::where('dCode', Auth::guard('departmentStaff')->user()->dCode)->orderBy('semNo', 'asc')->paginate(8); // Department code $dCode = Auth::guard('departmentStaff')->user()->dCode; return view($this->courseManagementView, ['courses' => $courses, 'count' => 0, 'dCode' => $dCode]); }
protected function addAcademics() { // Academic details. $this->add('college_id', 'entity', ['label' => 'College', 'class' => 'App\\College', 'selected' => College::where('name', 'None')->value('id')])->add('course_id', 'entity', ['label' => 'Course', 'class' => 'App\\Course', 'property' => 'course_with_type', 'query_builder' => function ($obj) { return $obj::get(); }, 'selected' => Course::where('name', 'None')->value('id')])->add('start_year', 'number', ['label' => 'Matriculation year', 'default_value' => Carbon::today()->year])->add('end_year', 'number', ['label' => 'Graduation year (estimated)', 'default_value' => Carbon::today()->year + 3]); return $this; }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { //course is determined by the button pushed in the courses index page $course = Course::where('course_id', $id)->lists('course_name', 'course_id'); //user role must be 3, meaning this retrieves a student list with no admins/instructors $users = User::where('user_role', 3)->lists('user_name', 'user_id'); return view('courses.rosters')->with('course', $course)->with('users', $users); }
/** * Create a new user controller instance. * * @return void */ public function __construct() { $this->priviledge_user(); $this->_user = \Auth::user(); if (2 == $this->_user->role_id) { $this->_query_connect = "="; $this->_query_value = $this->_user->department_id; } $this->_plan_courses = Course::where('department_id', $this->_query_connect, $this->_query_value)->lists('name', 'id'); $this->_plan_curriculums = Curriculum::lists('name', 'id'); }
public function getByUniversity($code) { $university = Course::where('university_code', $code)->get(); $validator = Validator::make(array('code' => $code), array('code' => array('required', 'regex:/(?i)^[a-z]+/'))); if ($validator->fails()) { return response()->json(['error' => true, 'description' => 'only alphabets are allowed']); } if ($university == null) { return response()->json(['error' => true, 'description' => 'code is not valid']); } return response()->json(['error' => false, 'topic' => $university]); }
/** * Show courses currently taught by teacher * * @return mixed */ public function showCourseManagementView() { // Get the courses teacher is teaching $teacherCourses = Auth::guard('teacher')->user()->teachingDetails; $teacherCourseCodes = []; foreach ($teacherCourses as $teacherCourse) { array_push($teacherCourseCodes, $teacherCourse->courseCode); } // Get a list of all courses $courses = Course::where('dCode', Auth::guard('teacher')->user()->dCode)->whereNotIn('courseCode', $teacherCourseCodes)->get(); return view($this->courseView, ['teacherCourses' => $teacherCourses, 'courses' => $courses]); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { do { $videoCode = self::VIDEO_PRE_CODE . StringUtil::getRandomString(); $courses = Course::where('video_code', $videoCode)->first(); if (empty($courses)) { $request['video_code'] = $videoCode; break; } } while (true); return $next($request); }
public function oneCourse($id) { $modifs = CourseModification::where('course_id', $id)->orderBy('id', 'desc')->with('course', 'author', 'user')->paginate(20); $course = Course::where('id', $id)->first(); if (empty($course)) { Flash::error('Ce cours n\'existe pas.'); return abort(404); } $url = url('courses/show/' . $course->slug); $name = $course->name; $concerned = '<a href="' . $url . '">' . $name . '</a>'; return view('admin.modifications.courses', compact('modifs', 'concerned')); }
/** * Gets the prerequisites associated with the given course id * * @var array */ public function getCoreq($cid) { if (!Course::where('cid', '=', $cid)->exists()) { return null; } $list = Course::where('cid', '=', $cid)->first()->requisites; $results = array(); foreach ($list as $row) { //If CoRequisite exists if ($row->crid) { return $row->crid; } } }
/** * Define your route model bindings, pattern filters, etc. * * @param \Illuminate\Routing\Router $router * @return void */ public function boot(Router $router) { parent::boot($router); // bind skill, course, and project wildcards the the alias in the database. $router->bind('skill', function ($alias) { return Skill::where('alias', $alias)->firstOrFail(); }); $router->bind('course', function ($alias) { return Course::where('alias', $alias)->firstOrFail(); }); $router->bind('project', function ($alias) { return Project::where('alias', $alias)->firstOrFail(); }); }
/** * Run the database seeds. * * @return void */ public function run() { $courses = ['CSCI E-15 Dynamic Web Applications' => ['Area of Concentration', 'Upper Level Courses'], 'DGMD E-42 Making the Short Film: Innovations and Practices for the Digital Age' => ['On Campus', 'Upper Level Courses'], 'EXPO E-25 Academic Writing and Critical Reading' => ['Harvard Instructor', 'Expo-25'], 'CSCI E-3: Introduction to Web Programming Using JavaScript' => ['Area of Concentration', 'Upper Level Courses'], 'CSCI E-7: Introduction to Programming with Python' => ['Area of Concentration', 'Upper Level Courses', 'On Campus'], 'CSCI E-8: Web GIS: Technologies and Applications' => ['Area of Concentration', 'Upper Level Courses'], 'CSCI E-10A: Introduction to Computer Science Using Java I' => ['Area of Concentration', 'Upper Level Courses', 'Harvard Instructor']]; foreach ($courses as $course_name => $requirements) { # First get the course $course = \App\Course::where('course_name', 'like', $course_name)->first(); # Now loop through each tag for this book, adding the pivot foreach ($requirements as $requirement_name) { $requirement = \App\Requirement::where('requirement_name', 'LIKE', $requirement_name)->first(); # Connect this req to this course $course->requirements()->save($requirement); } } }
/** * Agrega la posicion del stage * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $course_id = Course::where('url', $request->course_url)->first()->id; $stages = Stage::where('course_id', $course_id)->orderBy('position', 'desc')->get(); //Si el curso no tiene stages if ($stages->count() <= 0) { $request['position'] = 1; } else { $lastPosition = $stages->first()->position; $request['position'] = $lastPosition + 1; } //Agrega ID del curso al request $request['course_id'] = $course_id; return $next($request); }
public function removecourse() { $course = Input::get('selectcoursecode'); $courseclasses = Course_detail::where('course_code', $course)->get(); foreach ($courseclasses as $courseclass) { //delete schedules data Schedule::where('course_code', $courseclass->id)->delete(); Time_table::where('course_code', $courseclass->id)->delete(); } //delete class data Course_detail::where('course_code', $course)->delete(); //delete own data Course::where('course_code', $course)->delete(); return view('layouts.removecourse')->with('deletemsg', 'Course Deleted'); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next, $param) { switch ($param) { case "url": if (Course::where('url', $request->url)->count() > 0) { return $next($request); } break; case "id": if (Course::find($request->id)) { return $next($request); } break; } return redirect()->route('courses.index')->withErrors(['message' => 'Se está intentando editar un curso inexistente']); }
public function note(Request $request, $courseSlug, $lessonSlug) { $course = Course::where('slug', $courseSlug)->firstOrFail(); $lesson = Lesson::where('slug', $lessonSlug)->where('course_id', $course->id)->firstOrFail(); $user = User::findOrFail($request->user_id); if (!Auth::user()->accompanies->contains($user)) { abort(403); } $note = $lesson->notes()->firstOrNew(['user_id' => $user->id, 'companion_id' => Auth::user()->id]); if (empty($request->message)) { $note->delete(); } else { $note->note = $request->message; $note->save(); } return back(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $student = Auth::user(); $regs = Registration::where('student_id', '=', $student->id)->get(); foreach ($regs as $reg) { $course = Course::where('id', '=', $reg->course_id)->firstOrFail(); $reg["course_name"] = $course->name; $reg["course_code"] = $course->code; $dept = Department::find($course->department_id); $reg["department"] = $dept->name; $reg["exam_taken"] = false; if (Exam::where('student_id', $student->id)->where('course_id', $course->id)->count() > 0) { $reg["exam_taken"] = true; } $reg["exam_ready"] = false; if (Question::where('course_id', $reg->course_id)->count() > 0) { $reg["exam_ready"] = true; } } return view('reg.index', compact('regs')); }
public function getIndex(Request $request) { $userCourses = \App\Course::whereHas('users', function ($query) { $query->where('user_id', '=', \Auth::id()); })->get(); # Get all the requirements $requirements = \App\Requirement::all(); # Array to keep track of the requirements this user has completed $satisfied_requirements = []; # See what requirements this user has satisfied by looping through all their courses foreach ($userCourses as $userCourse) { # Find out what requirements this particular course satisifies $course = \App\Course::where('id', '=', $userCourse->id)->with('requirements')->first(); # Loop through all the requirements this course satisfies foreach ($course->requirements as $requirement) { # If we've never had an instance of this requirement being satisfied # We'll start the count off with how many hours this particular course satisfies if (!isset($satisfied_requirements[$requirement->id]['course_hours'])) { $satisfied_requirements[$requirement->id]['course_hours'] = $course->course_hours; } else { $satisfied_requirements[$requirement->id]['course_hours'] += $course->course_hours; } } } # Now we'll loop through all the requirements and update each one with a count of 'hours_remaining' foreach ($requirements as &$requirement) { # If they have anything that satisfies this requirement if (isset($satisfied_requirements[$requirement->id])) { # Then how many hours have been completed... $hours_completed = $satisfied_requirements[$requirement->id]['course_hours']; # Subtract that from this requirements `requirement_hours` # That kets stored in a new attribute for this $requirement, called `remaining_hours` $requirement->remaining_hours = $requirement->requirement_hours - $hours_completed; } else { $requirement->remaining_hours = $requirement->requirement_hours; } } return view('dash.index')->with('userCourses', $userCourses)->with('requirements', $requirements); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create($trackId, $trainingId) { $course_name = Course::where('id', '=', $trackId)->pluck('course_name'); $user_id_training = UserTraining::where('trainings_id', '=', $trainingId)->get(); //dd($user_id_training); //$trainees = User::lists('id', 'name'); $trainees = User::all(); $courses = Course::lists('course_name', 'id'); $newTrainees = array(); $test = ""; foreach ($user_id_training as $traineesName) { //dd($traineesName); //$newTrainees++; $traineeHas = TraineeCourse::wheretrainee_id($traineesName->user_id)->wherecourse_id($trackId)->first(); if ($traineeHas == true) { $test++; } else { array_push($newTrainees, $traineesName->user_id); } } //dd($newTrainees); return view('traineeCourse.create', compact('trainees', 'trackId', 'course_name', 'newTrainees')); }
/** * Show course selection view * * @return mixed */ public function showCourseSelectionView() { if (!$this->isRegistrationActive('staff')) { return view($this->inactiveView); } // Get the semester $semNo = Auth::guard('teacher')->user()->semNo; /* * Check if the semeseter is null. If it * is null, then course selection form * should be in-active and semester * selection form should be active */ if ($semNo === null) { return redirect('/teachers/semesterRegistration/semester'); } else { // Get the courses $courses = Course::where(['dCode' => Auth::guard('teacher')->user()->dCode, 'semNo' => $semNo])->get(); // Get elective count $electiveCount = ElectiveCount::where(['dCode' => Auth::guard('teacher')->user()->dCode, 'semNo' => $semNo])->get(); return view($this->courseSelectionView, ['courses' => $courses, 'electiveCount' => $electiveCount, 'count' => 0]); } }
/** * Allocate a Classroom * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(ClassroomRequest $request) { $from = strtotime($request->input('from')); $to = strtotime($request->input('to')); $duration = round(abs($to - $from) / 60, 2); //time difference=(to-from)minute $from = date('G:i:s', $from); //convert to 24 hr format $to = date('G:i:s', $to); //convert to 24 hr format $classroom = new Classroom($request->except(['from', 'to'])); $classroom->from = $from; $classroom->to = $to; $classroom->duration = $duration; $department = Department::where('name', $request->input('department'))->first(); $room = Room::where('name', $request->input('room'))->first(); $course = Course::where('name', $request->input('course_name'))->first(); $classroom->room()->associate($room); $classroom->department()->associate($department); $classroom->course()->associate($course); $classroom->save(); $request->session()->flash('status', 'Classroom was saved successful!'); return back(); }
/** * Retorna view con la informacion del curso * * @param String: url */ public function edit($url) { $curso = Course::where('url', $url)->first(); $categorias = Category::all()->pluck('name', 'id'); return view('pages.cursos.edit', ['curso' => $curso, 'categorias' => $categorias->toArray()]); }
showbatchschedule($batchschedule, $batch, $department); ?> </table> <br> <table border='1'> <tr> <td><span style='font-weight:bold'>Course Code</span></td> <td><span style='font-weight:bold'>Course Title</span></td> <td><span style='font-weight:bold'>Course Instructor</span></td> </tr> <?php $batchschedule = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('time_tables.department_code', $block)->where('course_details.offered_to', $batch)->select('time_tables.*')->orderby('time_tables.stime', 'ASC')->get(); foreach ($batchschedule as $routine) { $course_code = Course_detail::where('id', $routine->course_code)->first()->course_code; $course_title = Course::where('course_code', $course_code)->first()->course_title; $offered_by = Course_detail::where('id', $routine->course_code)->first()->offered_by; $id = User::where('username', $offered_by)->first()->id; $userdetails = User_detail::where('id', $id)->first(); $fullname = $userdetails->first_name . " " . $userdetails->middle_name . " " . $userdetails->last_name; if (str_replace(" ", "", $fullname) == null) { $fullname = $offered_by; } echo "<tr>"; echo "<td>" . $course_code . "</td>"; echo "<td>" . $course_title . "</td>"; echo "<td>" . $fullname . "</td>"; echo "</tr>"; } ?>