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');
}
