/**
* 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>";
}
?>
