public static function drop($uid, $sid) { $enrollment = Enrollment::where('student_id', '=', $uid)->where('section_id', '=', $sid); if ($enrollment->count() <= 0) { return "Enrollment does not exist."; } $enrollment->delete(); $section = Section::find($sid); $section->filled = $section->filled - 1; $section->save(); return true; }
public function getData() { $user = Auth::user(); //User::find(1); $enrollments = Enrollment::where('student_id', '=', $user->id)->get(); $available_sections = $user->getAvailableSections(); //Vsection::All(); $enrolled_sections = array(); foreach ($enrollments as $e) { $enrolled_sections[] = Vsection::find($e->section_id); } $data = array("status" => "success", "enrolled_sections" => $enrolled_sections, "available_sections" => $available_sections); //echo $user->name; // echo "<pre>"; // print_r($data); // print_r(json_encode($data)); //$data = json_encode($data); return json_encode($data); }
/** * Store a newly created resource in storage. * * @return \Illuminate\Http\Response */ public function store() { if (!Input::get('attendee_id') or !Input::get('program_id')) { return $this->respondUnprocessableEntity('Parameters failed validation for an enrollment.'); } try { $attendee = Attendee::findOrFail(Input::get('attendee_id')); } catch (ModelNotFoundException $e) { return $this->respondUnprocessableEntity('Attendee provided does not exist.'); } try { $program = Program::findOrFail(Input::get('program_id')); } catch (ModelNotFoundException $e) { return $this->respondUnprocessableEntity('Program provided does not exist.'); } $existingEnrollment = Enrollment::where('attendee_id', $attendee->id)->where('program_id', $program->id)->whereNull('enrollments.deleted_at')->get(); if (count($existingEnrollment)) { return $this->respondUnprocessableEntity('The enrollment of the attendee to the program already exists.'); } //We pass validation. Now add the enrollment. Enrollment::create(Input::all()); return $this->respondCreated('Enrollment created successfully.'); }
public function dropAll() { $enrollments = Enrollment::where('student_id', '=', $this->id)->get(); foreach ($enrollments as $enrollment) { Enrollment::drop($this->id, $enrollment->section_id); } }