/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
Session::flash('message', 'Successfully Deleted your Data!');
return redirect()->back();
}
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
session()->flash('success', 'El curso ' . $course->name . ' se ha eliminado.');
return redirect()->route('admin.course.index');
}
/**
* Show training page for registration
*
* @param $id
*
* @return $this
*/
public function training($id)
{
if (isset($id)) {
$course = Course::findOrFail($id);
}
$data = ['title' => 'Teleaus | Training Page', 'parentPage' => 'Recources', 'page' => 'Registration form ', 'course' => count($course) ? $course : 0];
return view('training-form')->with($data);
}
public function store(ContentRequest $request)
{
$course = Course::findOrFail($request->input('course_id'));
$this->authorize('manage-course-contents', $course);
$content = new Content($request->only(['title', 'body']));
$content->course()->associate($course);
$content->save();
session()->flash('success', 'El contenido se ha publicado.');
return redirect()->route('content.edit', $content->id);
}
public function store(QuestionRequest $request)
{
$course = Course::findOrFail($request->input('course_id'));
$this->authorize('view-course', $course);
$question = new Question($request->only(['title', 'body']));
$question->course()->associate($course);
$question->user()->associate(auth()->user());
$question->save();
session()->flash('success', 'La pregunta ha sido enviada');
return redirect()->back();
}
public function addToCart(Request $request)
{
$orders = $request->session()->get('orders');
if (isset($orders)) {
foreach ($orders as $course) {
if ($course->id == $request->course_id) {
return redirect()->back();
}
}
}
$course = Course::findOrFail($request->course_id);
$request->session()->push('orders', $course);
$request->session()->put('total', $this->totalPrice($request->session()->get('orders')));
return redirect()->back();
}
public function sendMail($id)
{
$file = Data::findOrFail($id);
$pathToFile = $file->path;
Mail::raw(Input::get('body'), function ($message) use($pathToFile, $file) {
$message->to(Input::get('email'));
$message->subject(Input::get('subject'));
$message->attach($pathToFile, ['as' => $file->name, 'mime' => 'application/pdf']);
});
if ($file->courseId != null) {
$course = Course::findOrFail($file->courseId);
return Redirect::action('CoursesController@showParam', [$course->slug]);
}
if ($file->snippetId != null) {
$snippet = Snippet::findOrFail($file->snippetId);
return Redirect::action('CoursesController@show', [$snippet->slug]);
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$course = Course::findOrFail($id);
$questions = Question::where('course_id', '=', $course->id)->get();
return view('que.show', compact('course', 'questions'));
}
public function toggleLike($id)
{
$course = Course::findOrFail($id);
$course->toggleLike();
return Redirect::action('CoursesController@show', [$course->slug]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$course = Course::findOrFail($id);
if (\Auth::user()->role_id == 3) {
$professor = DB::table('professors')->join('users', 'professors.user_id', '=', 'users.id')->where('users.id', '=', \Auth::user()->id)->first();
return view('professor.edit_course', compact('course', 'professor'));
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
* @internal param ShowLessonRequest $request
*/
public function show($id)
{
$course = Course::findOrFail($id);
return view('courses.show')->with('course', $course)->with('title', $course->title);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
return redirect()->route('courses.index')->with('message', 'Item deleted successfully.');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
Session::flash('flash_message', 'Námskeiðinu hefur verið eytt');
return redirect()->route('dashboard.courses.index');
}
/**
* Get the Days for A Course
* @param int $id
* @return App\Day
*/
public function getDaysForCourse($id)
{
$course = Course::findOrFail($id);
return $course->days;
}
public function getExamEdit($id)
{
$course = Course::findOrFail($id);
$questions = $course->test()->first()->questions()->get();
return view('courses.test_edit', compact('questions'));
}
public function course_name_by_course_id($id)
{
return Course::findOrFail($id)->course_name;
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(CourseRequest $request, $id)
{
$input = $request->except('_method', '_token');
$course = Course::findOrFail($id);
if ($course->update($input)) {
return redirect('/courses');
}
}
/**
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function reject($id)
{
$application = Application::findOrFail($id);
$application->delete();
$course = Course::findOrFail($application->course_id);
$course->users()->detach($application->user_id);
return redirect()->route('teacher.applications.index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id, $area, $professor)
{
$course = Course::where('id', $id)->first();
$course = Course::findOrFail($id);
$course->taken = 0;
$course->save();
$prof = Professor::findOrFail($professor);
$selectedCourseSchedule = explode("-", $course->schedule);
$professorLoad = $prof->current_load - count($selectedCourseSchedule) * 22.5;
$prof->current_load = $professorLoad;
$prof->save();
$schedules = schedule::where('course_id', $id)->delete();
return redirect("schedules/{$course->year}-{$course->semester}/{$area}/{$professor}");
}
private function importGroups($filePath)
{
$csv = Reader::createFromPath($filePath);
$allGroups = collect($csv->setOffset(1)->fetchAll());
foreach ($allGroups as $group) {
$tmp = collect(['id' => $group[0], 'capacity' => $group[1], 'name' => $group[2]]);
$course = Course::findOrFail($group[3]);
$course->groups()->create($tmp->toArray());
}
Session::flash('success', "You imported your course groups successfully.");
}
public function show($id)
{
$course = Course::findOrFail($id);
$this->authorize('view-course', $course);
return view('courses.show', compact('course'));
}
public function delete($id)
{
$course = Course::findOrFail($id);
$course->delete();
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index($course_id)
{
$course = Course::findOrFail($course_id);
$schedules = Schedule::upcoming()->where('course_id', '=', $course_id)->paginate(10);
return view('schedules.index', compact('course', 'schedules'));
}
public function add_lecture($id)
{
$course = Course::findOrFail($id);
//dd($course);
if (\Auth::user()->role_id == 3) {
$is_professor = true;
$professor = DB::table('professors')->join('users', 'professors.user_id', '=', 'users.id')->where('users.id', '=', \Auth::user()->id)->first();
return view('professor.add_lecture', compact('course', 'is_professor', 'professor'));
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
return redirect()->route('courses.index')->with('flash', ['level' => 'success', 'message' => 'Deleted "' . $course->name . '".']);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
Flash::Success('Course Deleted successfully.');
return redirect()->route('course.index');
}
/**
* Remove the specified resource from storage.
*
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function destroy($id)
{
$course = Course::findOrFail($id);
$course->delete();
$messages = trans('messages.deleted_course_successfully');
Flash::info($messages);
return redirect()->route('teacher.courses.index');
}
/**
* Cancel a Subscription
* TODO this should only be possible if the course is not confirmed and the User is logged in
* and signed up
* @param $id
* @return \Illuminate\Http\RedirectResponse
*
*/
public function cancel($id)
{
$course = Course::findOrFail($id);
$course->participants()->detach(Auth::user());
\Session::flash('flash_message', "Du wurdest erfolgreich vom Kurs abgemeldet");
\Session::flash('flash_message_type', "success");
return redirect()->action('CourseController@show', [$course->id]);
}
public function update($id, CourseRequest $request)
{
$course = Course::findOrFail($id);
$course->update($request->all());
return redirect('courses');
}
/**
* Display a listings of schedule of the course section.
*
* @return \Illuminate\Http\Response
*/
public function view_course_section($master_id = null, $course_id = null, $section = null)
{
$course = Course::findOrFail($course_id);
$_schedules = DB::select('SELECT sc.`key`, CONCAT(fa.last_name, ", ", fa.first_name ) faculty_name, sc.section_name, sc.section_key, da.code department_code, co.code course_code, su.code subject_code,su.name subject_name, su.name subject_name, su.units, ro.code room_code, sc.time_day, sc.time_from, sc.time_to, fe.name feature_name
FROM schedules sc
LEFT JOIN faculties fa ON sc.faculty_id = fa.id
INNER JOIN subjects su ON sc.subject_id = su.id
INNER JOIN features fe ON sc.feature_id = fe.id
LEFT JOIN rooms ro ON sc.room_id = ro.id
INNER JOIN semesters se ON sc.semester_id = se.id
INNER JOIN plans pl ON se.plan_id = pl.id
INNER JOIN courses co ON pl.course_id = co.id
INNER JOIN departments da ON co.department_id = da.id
WHERE sc.master_id = ' . $master_id . '
AND pl.course_id = ' . $course_id . '
AND sc.section_key = "' . $section . '"
AND da.id ' . $this->_query_connect . ' "' . $this->_query_value . '"
ORDER BY sc.time_day, sc.time_from');
$schedules = $_schedules;
return view('schedules.view_course_section', compact('schedules', 'course', 'master_id', 'course_id'));
}
