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