public function signToAllStripesForCourse($id)
{
$course = Course::find($id);
foreach ($course->stripes as $stripe) {
$this->stripes()->attach($stripe);
}
}
public function destroy($id)
{
$courses = Course::find($id);
$courses->schedules()->delete();
$courses->delete();
return response()->json(['id' => $id]);
}
public function getUnavailableGpAsgs($courseId)
{
$gpAsgs = Course::find($courseId)->gpAsgs;
return $gpAsgs->filter(function ($gpAsg) {
return !$this->testGpAsgAvailable($gpAsg);
});
}
public function getUnavailableWithinGpAsgs($courseId)
{
$withinGpAsgs = Course::find($courseId)->withinGpAsgs;
return $withinGpAsgs->filter(function ($withinGpAsg) {
return !$this->testWithinGpAsgAvailable($withinGpAsg);
});
}
public function show($course_id)
{
$course = Course::find($course_id);
if ($course) {
return $this->createSuccessResponse($course, 200);
}
return $this->createErrorResponse("The course with id {$course_id} does not exists", 404);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($course_id)
{
if (Auth::user()->isProfessor()) {
return view('professors.courses.show', ['class' => Course::find($course_id)]);
} else {
return view('students.courses.show');
}
}
public function lessons($domain, $courseId)
{
$course = Course::find($courseId);
if (!$course) {
return response()->json(['error' => "Môn học không tồn tại"], 404);
}
$lessons = Lesson::where('course_id', $courseId)->get();
return response()->json(['course' => ['id' => $course->id, 'name' => $course->name, 'avatar_url' => $course->icon_url], 'lessons' => $lessons]);
}
/**
* Actualiza un curso por su ID
*
* @param Request
* @param Int id
*/
public function update(CourseRequest $request, $id)
{
$name = $request->name;
$url = UrlSanitizer::sanitize($name);
$request["url"] = $url;
$curso = Course::find($id);
$curso->update($request->all());
return redirect()->route('courses.index');
}
public function updateCourse(UpdateCourseRequest $req)
{
$course = Course::find($req->id);
$course->abrr = $req->abrr;
$course->name = $req->name;
$course->college = $req->college;
$course->status = $req->status;
$course->save();
}
public function destroy($id)
{
$course = Course::find($id);
/* $sections = $grade->sections;
if ($sections->count() > 0)
return back()->with('error', 'No es posible eliminar un curso asociado a secciones.');
*/
$course->delete();
return back();
}
public function destroy($teacher_id, $course_id)
{
$teacher = Teacher::find($teacher_id);
if ($teacher) {
$course = Course::find($course_id);
if ($course) {
$course->delete();
return $this->createSuccessResponse("The course with id {$course->id} has been deleted.", 200);
}
return $this->createErrorMessage("The course with the specified id does not exists.", 404);
}
return $this->createErrorMessage("The teacher with id {$teacher_id} does not exists.", 404);
}
public function update($courseId)
{
$request = json_decode(request()->getContent());
$rules = array('name' => 'required', 'attendants' => 'required');
$validation = Validator::make((array) $request, $rules);
if ($validation->fails()) {
return response()->json(array('error' => true, 'message' => $validation->errors()->all(), 200));
}
$course = Course::find($courseId);
$course->name = $request->name;
$course->attendants = abs($request->attendants);
$updated = $course->save();
return response()->json(array('error' => !$updated, 'courses' => $course->toArray()), $updated ? 200 : 500);
}
public function destroy($handbook_id, $course_id, $grade_id)
{
$course = Course::find($course_id);
// If the course is already associated
$relationExist = CourseGrade::where('course_handbook_id', $handbook_id)->where('course_id', $course_id)->where('grade_id', $grade_id)->first();
if ($relationExist) {
$relationExist->delete();
$message = "Se ha eliminado correctamente el curso del grado.";
$type = "success";
return back()->with(compact(['message', 'type']));
}
$message = "El curso no se encuentra asignado al grado.";
$type = "warning";
return back()->with(compact(['message', 'type']));
}
function view_curriculum($id)
{
$get_cur = DB::select("SELECT `id`,code, descriptivetitle FROM tbl_subject\n WHERE tbl_subject.id NOT IN (SELECT subject FROM tbl_curriculumdetail WHERE curriculum = '{$id}')\n ORDER BY code ASC,descriptivetitle ASC");
$cur_detail = DB::table('tbl_curriculumdetail')->where('curriculum', $id)->orderBy('yearlevel', 'ASC')->orderBy('term', 'ASC')->groupBy('yearlevel')->groupBy('term')->get();
$cur = DB::table('tbl_curriculum')->where('id', $id)->first();
$cm = DB::table('tbl_coursemajor')->where('id', $cur->coursemajor)->first();
$c = Course::find($cm->course);
$m = '';
if ($cm->major != 0) {
$m = DB::table('tbl_major')->where('id', $cm->major)->first();
$major = $m->description;
}
$course = $c->description . ' ' . $m;
return view('dean.view_curriculum', compact('get_cur', 'cur_detail', 'cur', 'id', 'course'));
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$course = Course::find($this->courses);
switch ($this->method()) {
case 'GET':
case 'DELETE':
return [];
case 'POST':
return ['department_id' => 'integer|min:1', 'code' => 'required|unique:courses|max:20', 'name' => 'required|max:254'];
case 'PUT':
case 'PATCH':
return ['department_id' => 'integer|min:1', 'code' => "required|unique:courses,code,{$course->id}|max:20", 'name' => 'required|max:254'];
default:
break;
}
}
public function destroy($course_id, $student_id)
{
$course = Course::find($course_id);
if ($course) {
$student = Student::find($student_id);
if ($student) {
if (!$course->students()->find($student->id)) {
return $this->createErrorResponse("The student with id {$student->id} does not exists in the course with id {$course->id}", 404);
}
$course->students()->detach($student->id);
return $this->createSuccessResponse("The student with id {$student->id} was removed from the course with id {$course->id}", 200);
}
return $this->createErrorResponse("The student with id {$student_id} does not exists", 404);
}
return $this->createErrorResponse("The course with id {$course_id}, does not exists", 404);
}
/**
* 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 destroy($teacher_id, $course_id)
{
$teacher = Teacher::find($teacher_id);
if ($teacher) {
$course = Course::find($course_id);
if ($course) {
if ($teacher->courses()->find($course_id)) {
$course->students()->detach();
$course->delete();
return $this->createSuccessResponse("The course with id {$course_id} was removed", 200);
}
return $this->createSuccessResponse("The course with id {$course_id} was updated", 200);
}
return $this->createErrorResponse("The course with the id {$course_id} does not exists", 404);
}
return $this->createErrorResponse("The teacher with the id {$teacher_id} does not exists", 404);
}
public function getElectiveList($courseCode)
{
// Get the list of allocated electives
$allocatedElectives = Course::find($courseCode)->allocatedElectives;
if ($allocatedElectives->isEmpty()) {
$studentList = 'No student has opted for this subject !!!';
} else {
$studentList = '';
$count = 1;
// Generate the student list
foreach ($allocatedElectives as $allocatedElective) {
$studentList = $studentList . "\n" . $count . ") " . $allocatedElective->rollNo . ", " . $allocatedElective->currentStudentState->student->name . ", " . $allocatedElective->currentStudentState->student->department->dName;
}
}
$list = App::make('snappy.pdf.wrapper');
$list->loadHTML($studentList)->setOption('margin-bottom', 10)->setOption('margin-top', 10);
return $list->download($courseCode . 'List.pdf');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function delete($id)
{
if ($user = Sentinel::check()) {
Course::find($id)->delete();
return redirect('admin');
} else {
return redirect('/');
}
}
public function postCancel($course_id)
{
$course = Course::find($course_id);
$user_id = Auth::user()->id;
$course->users()->detach($user_id);
CourseModification::create(['author_id' => Auth::user()->id, 'user_id' => $user_id, 'course_id' => $course_id, 'value' => 1]);
Flash::success("L'annulation de votre demande de devenir un professeur du cours ucfirst({$course->name}) à bien été prise en compte.");
return redirect('courses');
}
function send_mail_confirm_registration($user, $class_id, $emailcc)
{
$class = \App\StudyClass::find($class_id);
$course = \App\Course::find($class->course_id);
$data['class'] = $class;
$data['course'] = $course;
$data['user'] = $user;
$subject = "Xác nhận đăng kí khoá học " . $course->name;
Mail::queue('emails.confirm_email_2', $data, function ($m) use($user, $subject, $emailcc) {
$m->from('*****@*****.**', 'Color Me');
$m->to($user['email'], $user['name'])->bcc($emailcc)->subject($subject);
});
}
/**
* Handles course deletion
* @param $id
* @return mixed
*/
public function delete($id)
{
// Make sure we have an active user
if (Auth::check()) {
// Look up the course being deleted
$course = Course::find($id);
// Ensure that this course exists, and belongs to this user
if ($course && $course->instructor_id == Auth::id()) {
// Delete the course
$course->delete();
// Redirect the user back to their homepage with a success message
return Redirect::to('/home')->with('success', 'The course was deleted successfully');
}
}
// Redirect the user back to their homepage with a success message
return Redirect::to('/home')->with('error', 'Please ensure you are logged in and try again');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$crs = Course::find($id);
$crs->delete();
\Session::flash('sucess_message', 'Course deleted sucessfully');
return redirect('myAdmin/courses');
}
public function courseUpdate($id)
{
$colleges = College::All();
$course = Course::find($id);
$majors = Major::where('course', $course->course_guid)->get();
return view('admin.update-course', compact('colleges', 'course', 'majors'));
}
/**
* Update the specified course with request info.
*
* @param Request $request
* @return Response
*/
public function update_course(Request $request, $course_id)
{
$course = Course::find($course_id);
if ($course->department != $request->department || $course->number != $request->number) {
$duplication_check = DB::table('courses')->where('department', '=', $request->department)->where('number', '=', $request->number)->first();
if (!empty($duplication_check)) {
$data = array('old' => $request, 'course' => Course::find($course_id), 'professors' => Role::where('name', '=', 'professor')->first()->users, 'tutors' => Role::where('name', '=', 'tutor')->first()->users);
session()->put('error', 'Course with department and number already exists.');
return view('course_edit', $data);
}
}
$course->department = $request->department;
$course->number = $request->number;
$course->description = $request->description;
$course->save();
session()->put('success', 'Course has been updated.');
return redirect('/course/' . $course_id);
}
public function applyToCourse(Request $request)
{
$this->validate($request, ['team' => 'required|integer|exists:teams,id', 'course' => 'required|integer|exists:courses,id']);
$team = Team::find($request->input('team'));
$course = Course::find($request->input('course'));
$team->courses()->attach($course);
Session::flash('success', "Your team applied to {$course->name}");
return redirect()->back();
}
public function deleteCourse(Request $request)
{
$this->validate($request, ['module_id' => 'required|exists:modules,id', 'course_id' => 'required']);
Course::find($request->input('course_id'))->delete();
return response('Deleted course', 200);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create($cid)
{
$course = Course::find($cid);
return view('sections.create')->with('course', $course);
}
$course->refs()->attach($uref);
}
}
}
return redirect(route("admin"))->withSuccess("Referenti impostati con successo.");
}]);
Route::get('/administration/messages', ['as' => 'admin.feedback', 'uses' => 'IssueController@index']);
Route::get('/contact', ['uses' => 'IssueController@create']);
Route::post('/contact', ['as' => 'postContact', 'uses' => 'IssueController@store']);
Route::delete('/administration/feedback/delete/{id}', "IssueController@destroy");
Route::post('/administration/calls/generate', function () {
if (userIsMod() == NULL) {
return redirect(route("home"))->withErrors(["Non hai i privilegi necessari per l'amministrazione."]);
}
$input = Input::all();
$class_ = $input['class'] . strtolower($input['section']);
$users = User::where('class', $class_)->get();
return view('layouts.admin.genCall')->withUsers($users);
});
Route::get('/administration/courses/{id}/generate', ['as' => 'genCourseCall', function ($id) {
if (userIsMod() == NULL) {
return redirect(route("home"))->withErrors(["Non hai i privilegi necessari per l'amministrazione."]);
}
if (!$id) {
return redirect(route("home"))->withErrors(["Corso con id selezionato non presente"]);
}
$course = Course::find($id);
return view('layouts.admin.genCallCourse')->withCourse($course);
}]);
Route::get('/user/{target_id}/edit', ['as' => 'admin.editUser', 'uses' => 'UserController@edit']);
Route::post('/user/{target_id}/update', ['as' => 'admin.updateUser', 'uses' => 'UserController@update']);
