PNG  IHDR;IDATxܻn0K )(pA 7LeG{ §㻢|ذaÆ 6lذaÆ 6lذaÆ 6lom$^yذag5bÆ 6lذaÆ 6lذa{ 6lذaÆ `}HFkm,mӪôô! x|'ܢ˟;E:9&ᶒ}{v]n&6 h_tڠ͵-ҫZ;Z$.Pkž)!o>}leQfJTu іچ\X=8Rن4`Vwl>nG^is"ms$ui?wbs[m6K4O.4%/bC%t Mז -lG6mrz2s%9s@-k9=)kB5\+͂Zsٲ Rn~GRC wIcIn7jJhۛNCS|j08yiHKֶۛkɈ+;SzL/F*\Ԕ#"5m2[S=gnaPeғL lذaÆ 6l^ḵaÆ 6lذaÆ 6lذa; _ذaÆ 6lذaÆ 6lذaÆ RIENDB` "Manage Teachers", 'teachers' => $teachers, ]; return view('backend.teachers.index',$data); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $qualifications = TeacherQualification::get(); $instruments = Instrument::get(); $syllabuses = Syllabus::asSelectArray(); $studentTypes = StudentType::asSelectArray(); $levelTypes = LevelType::asSelectArray(); $goals = TeacherGoal::get(); $levels = TeacherCurrentLevel::get(); $genre = Genre::get(); $modes = Mode::get(); $ages = AgeGroup::get(); $budget = Budget::get(); $languages = Language::get(); $locations = Location::get(); $data = [ 'page_title' => "Create Teacher", 'qualifications' => $qualifications, 'instruments' => $instruments, 'syllabuses' => $syllabuses, 'levelTypes' => $levelTypes, 'studentTypes' => $studentTypes, 'goals' => $goals, 'levels' => $levels, 'genres' => $genre, 'modes' => $modes, 'ages' => $ages, 'languages' => $languages, 'budgets' => $budget, 'locations' => $locations, ]; return view('backend.teachers.create',$data); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // dd($request->all()); $request->validate([ 'first_name' => 'required', 'status' => 'required', ]); try { DB::beginTransaction(); $teacher = new Teacher(); $teacher->first_name = $request->first_name; $teacher->last_name = $request->last_name; $teacher->slug = Str::slug($request->first_name); $teacher->email = $request->email; $teacher->phone = $request->phone; $teacher->address1 = $request->address1; $teacher->address2 = $request->address2; $teacher->city = $request->city; $teacher->country = $request->country; $teacher->state = $request->state; $teacher->music_school_name = $request->school_name; $teacher->online_class = $request->online_class; $teacher->qualification_id = $request->qualification_id; $teacher->location_id = $request->location_id; $teacher->bio = $request->bio; $teacher->teacher_type = $request->teacher_type; // $teacher->video_url = $request->video_url; $teacher->status = $request->status; $teacher->save(); Teacher::where('id', $teacher->id)->update([ 'slug' => Str::slug(100 + $teacher->id."-".$request->first_name) ]); if ($request->hasFile("image")) { $teacher->addMedia($request->file('image'))->toMediaCollection('teacher_image'); } $languages = $request->get('language'); if (collect($languages)->count() > 0) { for ($j = 0; $j < collect($languages)->count(); $j++) { if ($languages[$j] != "" ) { $teacher_lang = new TeacherLanguageDetail(); $teacher_lang->teacher_id = $teacher->id; $teacher_lang->language_id = $languages[$j]; $teacher_lang->save(); } } } $instruments = $request->get('instrument'); if (collect($instruments)->count() > 0) { for ($j = 0; $j < collect($instruments)->count(); $j++) { if ($instruments[$j] != "" ) { $teacher_instrument = new TeacherInstrumentDetail(); $teacher_instrument->teacher_id = $teacher->id; $teacher_instrument->instrument_id = $instruments[$j]; $teacher_instrument->save(); } } } $syllabus = $request->get('syllabus'); if (collect($syllabus)->count() > 0) { for ($j = 0; $j < collect($syllabus)->count(); $j++) { if ($syllabus[$j] != "" ) { $teacher_syllabus = new TeacherSyllabusDetail(); $teacher_syllabus->teacher_id = $teacher->id; $teacher_syllabus->syllabus = $syllabus[$j]; $teacher_syllabus->save(); } } } $goal = $request->get('goal'); if (collect($goal)->count() > 0) { for ($j = 0; $j < collect($goal)->count(); $j++) { if ($goal[$j] != "" ) { $teacher_goal = new TeacherGoalDetail(); $teacher_goal->teacher_id = $teacher->id; $teacher_goal->goal_id = $goal[$j]; $teacher_goal->save(); } } } $level = $request->get('level'); if (collect($level)->count() > 0) { for ($j = 0; $j < collect($level)->count(); $j++) { if ($level[$j] != "" ) { $teacher_level = new TeacherLevelDetail(); $teacher_level->teacher_id = $teacher->id; $teacher_level->level_id = $level[$j]; $teacher_level->save(); } } } $levelTpye = $request->get('level_types'); if (collect($levelTpye)->count() > 0) { for ($j = 0; $j < collect($levelTpye)->count(); $j++) { if ($levelTpye[$j] != "" ) { $teacher_level_types = new TeacherLevelTypeDetails(); $teacher_level_types->teacher_id = $teacher->id; $teacher_level_types->level_type = $levelTpye[$j]; $teacher_level_types->save(); } } } $genre = $request->get('genre'); if (collect($genre)->count() > 0) { for ($j = 0; $j < collect($genre)->count(); $j++) { if ($genre[$j] != "" ) { $teacher_genre = new TeacherGenreDetail(); $teacher_genre->teacher_id = $teacher->id; $teacher_genre->genre_id = $genre[$j]; $teacher_genre->save(); } } } $mode = $request->get('mode'); if (collect($mode)->count() > 0) { for ($j = 0; $j < collect($mode)->count(); $j++) { if ($mode[$j] != "" ) { $teacher_mode = new TeacherModeDetail(); $teacher_mode->teacher_id = $teacher->id; $teacher_mode->mode_id = $mode[$j]; $teacher_mode->save(); } } } $age = $request->get('age'); if (collect($age)->count() > 0) { for ($j = 0; $j < collect($age)->count(); $j++) { if ($age[$j] != "" ) { $teacher_age = new TeacherAgeGroupDetail(); $teacher_age->teacher_id = $teacher->id; $teacher_age->age_group_id = $age[$j]; $teacher_age->save(); } } } $type = $request->get('type'); if (collect($type)->count() > 0) { for ($j = 0; $j < collect($type)->count(); $j++) { if ($type[$j] != "" ) { $teacher_type = new TeacherTypeDetail(); $teacher_type->teacher_id = $teacher->id; $teacher_type->type = $type[$j]; $teacher_type->save(); } } } $budget = $request->get('budget'); if (collect($budget)->count() > 0) { for ($j = 0; $j < collect($budget)->count(); $j++) { if ($type[$j] != "" ) { $teacher_budget = new TeacherBudgetDetail(); $teacher_budget->teacher_id = $teacher->id; $teacher_budget->budget_id = $budget[$j]; $teacher_budget->save(); } } } DB::commit(); Log::info("Teacher Updated successfully", [$request->first_name]); return redirect(route('teacher.index'))->with([ "message" => "Added successfully", 'm_type' => "success" ]); } catch (Exception $exception) { Log::emergency("Exception while adding Teacher " . $exception->getMessage() . " on line " . $exception->getLine()); return back()->with([ "message" => "Unable to add !", 'm_type' => "warning" ]); } } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $teacher = Teacher::find($id); $instruments = TeacherInstrumentDetail::join('instruments','instruments.id','teacher_instrument_details.instrument_id') ->where('teacher_instrument_details.teacher_id',$id)->pluck('instruments.name')->toArray(); $levels = TeacherLevelDetail::join('teacher_current_levels','teacher_current_levels.id','teacher_level_details.level_id') ->where('teacher_level_details.teacher_id',$id)->pluck('teacher_current_levels.name')->toArray(); $genre = TeacherGenreDetail::join('genres','genres.id','teacher_genre_details.genre_id') ->where('teacher_genre_details.teacher_id',$id)->pluck('genres.name')->toArray(); $modes = TeacherModeDetail::join('modes','modes.id','teacher_mode_details.mode_id') ->where('teacher_mode_details.teacher_id',$id)->pluck('modes.name')->toArray(); $ages = TeacherAgeGroupDetail::join('age_groups','age_groups.id','teacher_age_group_details.age_group_id') ->where('teacher_age_group_details.teacher_id',$id)->pluck('age_groups.name')->toArray(); $languages = TeacherLanguageDetail::join('languages','languages.id','teacher_language_details.language_id') ->where('teacher_language_details.teacher_id',$id)->pluck('languages.name')->toArray(); $goals = TeacherGoalDetail::join('teacher_goals','teacher_goals.id','teacher_goal_details.goal_id') ->where('teacher_goal_details.teacher_id',$id)->pluck('teacher_goals.name')->toArray(); $budget = TeacherBudgetDetail::join('budgets','budgets.id','teacher_budget_details.budget_id') ->where('teacher_budget_details.teacher_id',$id)->pluck('budgets.name')->toArray();; $syllabuses = TeacherSyllabusDetail::whereTeacherId($id)->pluck('syllabus')->toArray(); $types = TeacherTypeDetail::whereTeacherId($id)->pluck('type')->toArray(); $leveltypes = TeacherLevelTypeDetails::whereTeacherId($id)->pluck('level_type')->toArray(); $data = [ 'page_title' => $teacher->first_name ." ".'View teacher', 'teacher' => $teacher, 'instruments' => $instruments, 'levels' => $levels, 'genres' => $genre, 'modes' => $modes, 'languages' => $languages, 'ages' => $ages, 'syllabuses' => $syllabuses, 'goals' => $goals, 'budget' => $budget, 'types' => $types, 'leveltypes' => $leveltypes, ]; return view('backend.teachers.view',$data); } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $teacher = Teacher::find($id); $qualifications = TeacherQualification::get(); $instruments = Instrument::get(); $syllabuses = Syllabus::asSelectArray(); $studentTypes = StudentType::asSelectArray(); $levelTypes = LevelType::asSelectArray(); $goals = TeacherGoal::get(); $levels = TeacherCurrentLevel::get(); $genre = Genre::get(); $modes = Mode::get(); $ages = AgeGroup::get(); $budget = Budget::get(); $languages = Language::get(); $locations = Location::get(); $instrumentSelected = TeacherInstrumentDetail::whereTeacherId($id)->pluck('instrument_id')->toArray(); $goalSelected = TeacherGoalDetail::whereTeacherId($id)->pluck('goal_id')->toArray(); $levelSelected = TeacherLevelDetail::whereTeacherId($id)->pluck('level_id')->toArray(); $genreSelected = TeacherGenreDetail::whereTeacherId($id)->pluck('genre_id')->toArray(); $modeSelected = TeacherModeDetail::whereTeacherId($id)->pluck('mode_id')->toArray(); $ageSelected = TeacherAgeGroupDetail::whereTeacherId($id)->pluck('age_group_id')->toArray(); $budgetSelected = TeacherBudgetDetail::whereTeacherId($id)->pluck('budget_id')->toArray(); $languageSelected = TeacherLanguageDetail::whereTeacherId($id)->pluck('language_id')->toArray(); $levelTypesSelected = TeacherLevelTypeDetails::whereTeacherId($id)->pluck('level_type')->toArray(); $data = [ 'page_title' => "Edit Teacher", 'teacher' => $teacher, 'qualifications' => $qualifications, 'instruments' => $instruments, 'syllabuses' => $syllabuses, 'studentTypes' => $studentTypes, 'levelTypes' => $levelTypes, 'goals' => $goals, 'levels' => $levels, 'genres' => $genre, 'modes' => $modes, 'ages' => $ages, 'languages' => $languages, 'budgets' => $budget, 'instrumentSelected' => $instrumentSelected, 'goalSelected' => $goalSelected, 'levelSelected' => $levelSelected, 'genreSelected' => $genreSelected, 'modeSelected' => $modeSelected, 'ageSelected' => $ageSelected, 'budgetSelected' => $budgetSelected, 'languageSelected' => $languageSelected, 'levelTypesSelected' => $levelTypesSelected, 'locations' => $locations, ]; return view('backend.teachers.edit',$data); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $request->validate([ 'first_name' => 'required', 'status' => 'required', ]); try { DB::beginTransaction(); $teacher = Teacher::find($id); $teacher->first_name = $request->first_name; $teacher->last_name = $request->last_name; $teacher->email = $request->email; $teacher->phone = $request->phone; $teacher->address1 = $request->address1; $teacher->address2 = $request->address2; $teacher->city = $request->city; $teacher->country = $request->country; $teacher->state = $request->state; $teacher->music_school_name = $request->school_name; $teacher->online_class = $request->online_class; $teacher->qualification_id = $request->qualification_id; $teacher->location_id = $request->location_id; $teacher->bio = $request->bio; $teacher->teacher_type = $request->teacher_type; // $teacher->video_url = $request->video_url; $teacher->status = $request->status; $teacher->save(); Teacher::where('id', $teacher->id)->update([ 'slug' => Str::slug(100 + $teacher->id."-".$request->first_name) ]); if ($request->hasFile("image")) { $teacher->addMedia($request->file('image'))->toMediaCollection('teacher_image'); } $languages = $request->get('language'); if (collect($languages)->count() > 0) { $lang = TeacherLanguageDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($languages)->count(); $j++) { if ($languages[$j] != "" ) { $teacher_lang = new TeacherLanguageDetail(); $teacher_lang->teacher_id = $teacher->id; $teacher_lang->language_id = $languages[$j]; $teacher_lang->save(); } } } $instruments = $request->get('instrument'); if (collect($instruments)->count() > 0) { $instru = TeacherInstrumentDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($instruments)->count(); $j++) { if ($instruments[$j] != "" ) { $teacher_instrument = new TeacherInstrumentDetail(); $teacher_instrument->teacher_id = $teacher->id; $teacher_instrument->instrument_id = $instruments[$j]; $teacher_instrument->save(); } } } $syllabus = $request->get('syllabus'); if (collect($syllabus)->count() > 0) { $sybs = TeacherSyllabusDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($syllabus)->count(); $j++) { if ($syllabus[$j] != "" ) { $teacher_syllabus = new TeacherSyllabusDetail(); $teacher_syllabus->teacher_id = $teacher->id; $teacher_syllabus->syllabus = $syllabus[$j]; $teacher_syllabus->save(); } } } $goal = $request->get('goal'); if (collect($goal)->count() > 0) { $goals = TeacherGoalDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($goal)->count(); $j++) { if ($goal[$j] != "" ) { $teacher_goal = new TeacherGoalDetail(); $teacher_goal->teacher_id = $teacher->id; $teacher_goal->goal_id = $goal[$j]; $teacher_goal->save(); } } } $level = $request->get('level'); if (collect($level)->count() > 0) { $levels = TeacherLevelDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($level)->count(); $j++) { if ($level[$j] != "" ) { $teacher_level = new TeacherLevelDetail(); $teacher_level->teacher_id = $teacher->id; $teacher_level->level_id = $level[$j]; $teacher_level->save(); } } } $levelTpye = $request->get('level_types'); if (collect($levelTpye)->count() > 0) { $levelTpyes = TeacherLevelTypeDetails::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($levelTpye)->count(); $j++) { if ($levelTpye[$j] != "" ) { $teacher_level_types = new TeacherLevelTypeDetails(); $teacher_level_types->teacher_id = $teacher->id; $teacher_level_types->level_type = $levelTpye[$j]; $teacher_level_types->save(); } } } $genre = $request->get('genre'); if (collect($genre)->count() > 0) { $genres = TeacherGenreDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($genre)->count(); $j++) { if ($genre[$j] != "" ) { $teacher_genre = new TeacherGenreDetail(); $teacher_genre->teacher_id = $teacher->id; $teacher_genre->genre_id = $genre[$j]; $teacher_genre->save(); } } } $mode = $request->get('mode'); if (collect($mode)->count() > 0) { $modes = TeacherModeDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($mode)->count(); $j++) { if ($mode[$j] != "" ) { $teacher_mode = new TeacherModeDetail(); $teacher_mode->teacher_id = $teacher->id; $teacher_mode->mode_id = $mode[$j]; $teacher_mode->save(); } } } $age = $request->get('age'); if (collect($age)->count() > 0) { $ages = TeacherAgeGroupDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($age)->count(); $j++) { if ($age[$j] != "" ) { $teacher_age = new TeacherAgeGroupDetail(); $teacher_age->teacher_id = $teacher->id; $teacher_age->age_group_id = $age[$j]; $teacher_age->save(); } } } $type = $request->get('type'); if (collect($type)->count() > 0) { $types = TeacherTypeDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($type)->count(); $j++) { if ($type[$j] != "" ) { $teacher_type = new TeacherTypeDetail(); $teacher_type->teacher_id = $teacher->id; $teacher_type->type = $type[$j]; $teacher_type->save(); } } } $budget = $request->get('budget'); if (collect($budget)->count() > 0) { $budgets = TeacherBudgetDetail::whereTeacherId($teacher->id)->delete(); for ($j = 0; $j < collect($budget)->count(); $j++) { if ($type[$j] != "" ) { $teacher_budget = new TeacherBudgetDetail(); $teacher_budget->teacher_id = $teacher->id; $teacher_budget->budget_id = $budget[$j]; $teacher_budget->save(); } } } DB::commit(); Log::info("Teacher Updated successfully", [$request->first_name]); return redirect(route('teacher.index'))->with([ "message" => "Updated successfully", 'm_type' => "success" ]); } catch (Exception $exception) { Log::emergency("Exception while adding Teacher " . $exception->getMessage() . " on line " . $exception->getLine()); return back()->with([ "message" => "Unable to add !", 'm_type' => "warning" ]); } } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $teacher = Teacher::find($id); $teacher->delete(); $media = Media::where('id',$id)->where('collection_name','teacher_image')->delete(); $lang = TeacherLanguageDetail::whereTeacherId($id)->delete(); $instru = TeacherInstrumentDetail::whereTeacherId($id)->delete(); $sybs = TeacherSyllabusDetail::whereTeacherId($id)->delete(); $goals = TeacherGoalDetail::whereTeacherId($id)->delete(); $levels = TeacherLevelDetail::whereTeacherId($id)->delete(); $genres = TeacherGenreDetail::whereTeacherId($id)->delete(); $modes = TeacherModeDetail::whereTeacherId($id)->delete(); $ages = TeacherAgeGroupDetail::whereTeacherId($id)->delete(); $types = TeacherTypeDetail::whereTeacherId($id)->delete(); $budgets = TeacherBudgetDetail::whereTeacherId($id)->delete(); $levelType = TeacherLevelTypeDetails::whereTeacherId($id)->delete(); return back()->with([ 'message' => "Removed successfully", 'm_type' => 'success' ]); } }