public function create()
{
$classrooms = Classroom::inCurrentSemester()->pluck('code', 'id')->toArray();
$subjects = Subject::isCurrent()->lists('name', 'id')->toArray();
$intervals = ClassroomInterval::inCurrentSemester()->pluck('title', 'id')->toArray();
$teachers = Teacher::isActive()->pluck('name', 'id')->toArray();
return view('classrooms::sessions.create', compact('classrooms', 'subjects', 'teachers', 'intervals'));
}
public function index($subject_id = 0)
{
$subject = Subject::findOrFail($subject_id);
$teachers = Teacher::whereHas('subjects', function ($q) use($subject) {
$q->where('subject_subjects.id', $subject->id);
})->get();
$active_teachers = Teacher::isActive()->whereNotIn('teachers.id', $teachers->pluck('id')->toArray())->pluck('name', 'id')->toArray();
return view('subject::teachers.index', compact('subject', 'teachers', 'active_teachers'));
}
public function store(CreateGuideRequest $request)
{
$input = $request->all();
$guide = new TeacherGuide();
$guide = $guide->fill($input);
$guide->save();
$teachers = Teacher::isActive()->get();
$email = trans('teachers::guides.email_template', ['name' => $guide->name, 'url' => asset($guide->file->url())]);
$this->dispatch(new SendTeachersMessage($teachers, $email, false, user()->id));
if (isset($input['submit']) and $input['submit'] == 'save') {
return redirect()->route('teachers.guides.create');
}
return redirect()->route('teachers.guides.index');
}
public function index(Request $request)
{
$classrooms = Classroom::with('subject', 'teacher')->withCount('students')->inCurrentSemester();
// $input['username'] = (!empty($input['code']) and substr($input['code'],0,3)!='e20' and strlen($input['code'])>=5)
// ? strtoupper(substr($input['code'], -5,5))
// : (!empty($input['code']) ? $input['code'] : null);
// if(empty($input['username'])) {
// unset($input['username']);
// }
// unset($input['code']);
if (substr(request('username'), 0, 3) != 'e20' and strlen(request('username')) >= 5) {
$username = strtoupper(substr(request('username'), -5, 5));
} else {
$username = request('username');
}
// dd($username);
if (!empty($username)) {
$student_classroom = Student::with('classrooms')->where('username', $username)->first();
$filter_classroom = $student_classroom->classrooms->pluck('id')->toArray();
$classrooms->whereIn('id', $filter_classroom);
}
$array_filters = ['day', 'gender'];
$text_filters = ['code'];
foreach ($array_filters as $filter) {
if (request()->has($filter)) {
$classrooms->whereIn($filter, request($filter));
}
}
if (request()->has('teacher_id')) {
$classrooms->where('teacher_id', request('teacher_id'));
}
if (request()->has('subject_subject_id')) {
$classrooms->where('subject_subject_id', request('subject_subject_id'));
}
foreach ($text_filters as $filter) {
if (request()->has($filter)) {
$classrooms->where($filter, request($filter));
}
}
if (request()->ajax()) {
return $classrooms->get();
}
$teachers = Teacher::isActive()->pluck('name', 'id')->toArray();
$subjects = Subject::isCurrent()->lists('name', 'id');
$has_search = count(request()->except('page', 'per_page'));
$classrooms = $classrooms->orderBy('day', 'ASC')->orderBy('hour', 'ASC')->paginate(20);
$genders = $this->genders;
$days = $this->days;
return view('classrooms::classrooms.index', compact('classrooms', "days", "genders", 'has_search', 'teachers', 'subjects'));
}
public function teachertable(Request $request)
{
$sessions = ClassroomSession::with(['teacher', 'classroom', 'subject']);
if ($request->has('teacher_id')) {
$sessions->whereHas('teacher', function ($q) use($request) {
$q->where('id', $request->input('teacher_id'));
});
}
$per_page = request('per_page') ? request('per_page') : 30;
$sessions = $sessions->paginate($per_page);
$sessions = $sessions->appends($request->except("page"));
$teachers = Teacher::isActive()->pluck('name', 'id')->toArray();
return view('classrooms::reports.teachertable', compact('sessions', 'teachers'));
}