public function total() { $result = Trainer::select(DB::raw('sum(full_time_male) as male, sum(full_time_female) as female, sum(full_time_male) + sum(full_time_female) as total'))->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->get(); return $result; }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $trainer_course = TrainerCourse::whereid($id)->firstOrfail(); $trainers = Trainer::lists('name', 'id'); $courses = Course::lists('course_name', 'id'); return view('TrainerCoursesRelation.edit', compact('trainer_course', 'trainers', 'courses')); }
public function total() { $result = Trainer::select(DB::raw('sum(full_time_male) as male, sum(full_time_female) as female, sum(full_time_male) + sum(full_time_female) as total'))->whereIn('report_date_id', ReportDate::select('id')->where('petsa', $this->petsa)->lists('id'))->whereIn('institution_id', Institution::select('id')->where('region_id', $this->region_id)->lists('id'))->get(); return $result; }
public function levelC($subsector_id) { $occupation_ids = Occupation::select('id')->where(array('subsector_id' => $subsector_id))->lists('id'); $level_C = Trainer::select(DB::raw('occupation_id, SUM(full_time_male) as male, SUM(full_time_female) as female, (SUM(full_time_male) + SUM(full_time_female)) as total'))->where('level', 'Level C')->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->whereIn('occupation_id', $occupation_ids)->get(); return $level_C; }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update($slug, TrainerFormRequest $request) { $trainer = Trainer::whereSlug($slug)->firstOrFail(); $trainer->name = $request->get('name'); $trainer->email = $request->get('email'); $trainer->country = $request->get('country'); $trainer->skill_set = $request->get('skill_set'); $trainer->gender = $request->get('gender'); $trainer->educational_qualification = $request->get('educational_qualification'); $trainer->previous_experience = $request->get('previous_experience'); $trainer->date_of_birth = $request->get('date_of_birth'); $trainer->cell_number = $request->get('cell_number'); if ($request->get('status') != null) { $trainer->status = 0; } else { $trainer->status = 1; } $trainer->save(); return redirect(action('TrainersController@edit', $trainer->slug))->with('status', 'The trainer status has been updated!'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update($id, TrainerFormRequest $request) { $input = $request->all(); if (isset($input['image'])) { $Image = $input['image']; //dd($Image); $imagePath = $this->imageUpload($Image); //call public function imageUpload for small img } else { $imagePath = Trainer::where('id', '=', $id)->pluck('filePath'); //dd($imagePath); } $trainer = Trainer::whereId($id)->firstOrFail(); $trainer->name = $request->get('name'); $trainer->email = $request->get('email'); $trainer->country = $request->get('country'); $trainer->skill_set = $request->get('skill_set'); $trainer->gender = $request->get('gender'); $trainer->educational_qualification = $request->get('educational_qualification'); $trainer->previous_experience = $request->get('previous_experience'); $trainer->date_of_birth = $request->get('date_of_birth'); $trainer->cell_number = $request->get('cell_number'); $trainer->filePath = $imagePath; if ($request->get('status') != null) { $trainer->status = 0; } else { $trainer->status = 1; } $trainer->save(); return redirect(action('TrainersController@show', $trainer->id))->with('status', 'The trainer status has been updated!'); }
public function subsectors() { $sub_sectors = Subsector::whereIn('id', Occupation::select('subsector_id')->whereIn('id', Trainer::select('occupation_id')->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->distinct()->lists('occupation_id'))->distinct()->lists('subsector_id'))->get(); return $sub_sectors; }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function admin_trainer_show($id) { $trainer = Trainer::whereTrainer_id($id)->first(); return $trainer; return view('admin.AdminTrainer.show', compact('trainer')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function adminShow($id) { $trainer = Trainer::whereId($id)->firstOrFail(); //return $trainer->trainer_id; return view('admin.AdminTrainer.show', compact('trainer')); }
public function feedbackIndex() { $feedbacks = Feedback::with('trainer')->distinct()->select('trainer_id')->get(); $trainers = Trainer::all(); return view('admin.feedbacks.index', compact('feedbacks', 'trainers')); }
public function trainer_by_course_id($course_id) { $trainers = Trainer::whereCourse_id($course_id)->get(); return $trainers; }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $trainers = Trainer::all(); return view('feedbacks.create', compact('trainers')); }
public function saveAs(Request $request) { // retrieve all records as collection $records = Trainer::select('report_date_id', 'institution_id', 'occupation_id', 'level', 'full_time_male', 'full_time_female', 'part_time_male', 'part_time_female', 'ethiopian_male', 'ethiopian_female', 'non_ethiopian_male', 'non_ethiopian_female', 'core_male', 'core_female', 'took_tm_male', 'took_tm_female', 'remarks')->where('report_date_id', $request->report_date_id_source)->get(); if (count($records) > 0) { // update report date id to target report date id foreach ($records as $rec) { $rec->report_date_id = $request->report_date_id_target; } // insert into the table Trainer::insert($records->toArray()); // send a flash message $request->session()->flash('alert-success', 'Save as operation was successful!'); } else { // send a flash message $request->session()->flash('alert-danger', 'Save as operation failed! No records found from source.'); } return redirect('trainers'); }