/**
* @desc Edit Department
* @Edit function Open Edit From view
* @param Department $department (get department data from provider route model binding $router->model)
* @param Specialty $specialty for parent specialty list
* @param Subject $subject for parent subject list
**/
public function edit(Department $department, Specialty $specialty, Subject $subject)
{
$subjects = $subject->pluck('name', 'id')->toArray();
$menu = $department->menu()->get();
$specialties = $specialty->get();
return view('academystructure::departments.edit', compact('department', 'menu', 'specialties', 'subjects'));
}
public function classroomedit($id, Classroom $Classroom)
{
$classroom = $Classroom->inCurrentSemester()->with('teacher', 'subject', 'subject.teachers')->findOrFail($id);
$genders = $this->genders;
$days = $this->days;
$teachers = $classroom->subject->teachers->pluck('name', 'id')->toArray();
$check_classroom = TeacherCheckClassroom::pluck('name', 'hour')->toArray();
$subjects = [NULL => NULL] + Subject::pluck('name', 'id')->toArray();
return view("teachers::profile.classrooms.classroomedit", compact('genders', 'subjects', 'days', 'classroom', 'teachers', 'check_classroom'));
}
public function index(Request $req, Subject $UserModel)
{
$subjects = Subject::select('*');
if (request('QB_subject')) {
$subjects->where('id', request('QB_subject'));
}
if (request('QB_year_term')) {
$subjects->whereIn('id', explode(',', request('QB_year_term')));
}
$subjects = $subjects->paginate(20);
$year_term = year::join('academystructure_terms', 'academystructure_years.id', '=', 'academystructure_terms.year_id')->join('academystructure_departments', 'academystructure_terms.id', '=', 'academystructure_departments.term_id')->select(\DB::raw('CONCAT(academystructure_years.name, "-", academystructure_terms.name) as name,
GROUP_CONCAT(DISTINCT(academystructure_departments.subject_ids)) as sid'))->groupBy('academystructure_terms.name', 'academystructure_years.name')->orderBy('academystructure_terms.id', 'desc')->get()->toArray();
$year_term_options;
foreach ($year_term as $key => &$aa) {
$a = implode(',', array_unique(array_merge(json_decode(str_replace('],[', ',', $aa['sid']), TRUE))));
$year_term_options[$a] = $aa['name'];
}
$subject_list = Subject::pluck('name', 'id')->toArray();
foreach ($subjects as &$subject) {
$subject->lessonscount = Lesson::where('subject_subject_id', $subject->id)->count();
}
return view('subject::reports.index', compact('subjects', 'lessons', 'subject_list', 'year_term_options'));
}
public function classroom_chose_subject(Request $request)
{
$chosen_subjects = StudentSubject::whereIn('student_subjects.state', ['study'])->selectRaw('student_subjects.student_id,students.name,students.username, students.name,students.mobile ,student_subjects.subject_id')->join('students', 'student_subjects.student_id', '=', 'students.id')->join('classrooms', function ($j) {
$j->on('classrooms.subject_subject_id', '=', 'student_subjects.subject_id')->where('classrooms.semester_id', '=', semester()->id);
})->leftJoin('classroom_students', function ($j) {
$j->on('classrooms.id', '=', 'classroom_students.classroom_id')->on('classroom_students.student_id', '=', 'student_subjects.student_id');
})->groupBy('student_subjects.subject_id', 'student_subjects.student_id');
if ($request->subject_subject_id) {
$chosen_subjects->where('student_subjects.subject_id', '=', $request->subject_subject_id);
}
if ($request->is_choise) {
$chosen_subjects->havingRaw('COUNT(classroom_students.id)=' . $request->is_choise);
}
$per_page = request('per_page') ? request('per_page') : 30;
$chosen_subjects = $chosen_subjects->paginate($per_page);
$subjects = Subject::pluck('name', 'id')->toArray();
$classroom_select = config('classrooms.classroom_select');
return view('classrooms::reports.classroom_chose_subject', compact('subjects', 'classroom_select', 'chosen_subjects'));
}
public function create(Term $term)
{
$types = config('subject.types');
$pre_request = Subject::pluck('name', 'id')->toArray();
return view('subject::subjects.create', compact('types', 'pre_request'));
}
public function show($order_id)
{
$Equal_order_model = new Equal();
$equal_order = $Equal_order_model->with('student', 'files', 'history', 'history.user', 'subjects.files')->findOrFail($order_id);
$all_subjects = Subject::pluck('name', 'id')->toArray();
return view('orders::equal.show', compact('equal_order', 'all_subjects'));
}
public function store($eq_id, EqSub $equations, Request $request)
{
$equations->registration_equation_id = $eq_id;
$equations->status = 'waiting';
$equations->fill($request->all())->save();
$message = 'تم اضافة مادة بنجاح';
$equal_order = Equation::with('registration', 'files', 'subjects')->findOrFail($eq_id);
$student_id = $equal_order->registration->registration_equation_id;
$all_subjects = Subject::pluck('name', 'id')->toArray();
$action_need = $equal_order->subjects->filter(function ($s) {
return $s->status == "accepted";
})->count();
if (request('submit') == 'save') {
return redirect()->back()->with('success', $message);
} else {
return redirect()->route('registration.equations.subjects', $eq_id)->with('success', $message);
}
}
