public function create($course_id) { $course = Course::with('placements')->find($course_id); $subjects = Subject::all(); $menu = 'academic'; return View::make('masteries.create', compact('course', 'subjects', 'menu')); }
public function create($course_id) { $course = Course::with('placements')->find($course_id); $employees = Employee::where('teach_salary', '>', 0.0)->get(); $hours = Hour::all(); $menu = 'academic'; return View::make('presences.create', compact('course', 'subjects', 'employees', 'hours', 'menu')); }
public function destroy($id) { $course = Course::with('placements')->find($id); if ($course->placements->count() > 0) { Session::flash('message', 'Tidak dapat menghapus data Kelas! Kelas ini pernah digunakan!'); } else { Course::destroy($id); Session::flash('message', 'Sukses menghapus data Kelas!'); } }
/** * Exports the total amount of students that are taking each course to a CSV file */ public function exporttCourseAttendenceToCSV() { $course_data = Course::with('students')->get(); $csv = \League\Csv\Writer::createFromFileObject(new \SplTempFileObject()); $column_flag = false; $course_listing = []; foreach ($course_data as $course) { $course_listing['course_name'] = $course->course_name; $course_listing['num_students'] = count($course->students); //Check whether column headers have been set (not ideal for large datasets) if ($column_flag === false) { $csv->insertOne(\Schema::getColumnListing('course_listing')); $column_flag = true; } $csv->insertOne($course_listing); } $csv->output('course_attendance_records.csv'); }
public function recapCourse() { $courses = Course::where('project_id', '=', Auth::user()->curr_project_id)->get(); $periods = DB::table('registrations')->select(DB::raw('month(registration_date) as months'), DB::raw('year(registration_date) as years'))->groupBy(DB::raw('month(registration_date)'))->get(); $courselists = array(); foreach ($courses as $course) { $statistics = array(); foreach ($periods as $period) { $count = Course::with(array('placements', 'placements.issues.registration'))->join('placements', 'placements.course_id', '=', 'courses.id')->join('issues', 'issues.id', '=', 'placements.issue_id')->join('registrations', 'registrations.id', '=', 'issues.registration_id')->where(DB::raw('month(registrations.registration_date)'), '=', $period->months)->where(DB::raw('year(registrations.registration_date)'), '=', $period->years)->where('courses.id', '=', $course->id)->count(); $statistics[] = array('count' => $count); } $courselists[] = array('id' => $course->id, 'name' => $course->name, 'statistics' => $statistics); } $menu = 'report'; return View::make('reports.recapcourse', compact('periods', 'courselists', 'menu')); }