/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$faculty = Faculty::findOrFail($id);
$faculty->delete();
Flash::Success('Faculty Deleted successfully.');
return redirect()->route('faculty.index');
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(FacultyRequest $request, $id)
{
$input = $request->except('_method', '_token');
$faculty = Faculty::findOrFail($id);
if ($faculty->update($input)) {
$faculty->subjects()->sync($request->input('subject_list'));
return redirect('/faculties');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$faculty = Faculty::findOrFail($id);
$faculty->delete();
\Flash::success('Faculteit verwijderd');
return redirect('admin/faculties');
}
/**
* Display a listings of schedule of the faculty.
*
* @return \Illuminate\Http\Response
*/
public function view_faculty($master_id = null, $faculty_id = null)
{
$faculty = array();
$faculty_id_connector = ' = ';
if (empty($faculty_id)) {
$faculty_id = 'null';
$faculty_id_connector = ' is ';
} else {
$faculty = Faculty::findOrFail($faculty_id);
}
$_schedules = DB::select('SELECT sc.`key`, sc.section_name, da.code department_code, co.code course_code, su.code subject_code, su.name subject_name, su.units, ro.code room_code, sc.time_day, sc.time_from, sc.time_to, sc.feature_id
FROM schedules sc
INNER JOIN subjects su ON sc.subject_id = su.id
INNER 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 sc.faculty_id ' . $faculty_id_connector . $faculty_id . '
ORDER BY sc.time_day, sc.time_from');
$schedules = $_schedules;
return view('schedules.view_faculty', compact('schedules', 'faculty', 'master_id', 'faculty_id'));
}
