public function getShortTermTraineesByOccupation($occupation_id)
{
$result = ShortTermTrainee::select(DB::raw('
sum(registered_male) as registered_male,
sum(registered_female) as registered_female,
sum(registered_male) + sum(registered_female) as registered_total,
sum(started_training_male) as started_training_male,
sum(started_training_female) as started_training_female,
sum(started_training_male) + sum(started_training_female) as started_training_total,
sum(completed_training_male) as completed_training_male,
sum(completed_training_female) as completed_training_female,
sum(completed_training_male) + sum(completed_training_female) as completed_training_total,
sum(sent_assessment_male) as sent_assessment_male,
sum(sent_assessment_female) as sent_assessment_female,
sum(sent_assessment_male) + sum(sent_assessment_female) as sent_assessment_total,
sum(assessed_male) as assessed_male,
sum(assessed_female) as assessed_female,
sum(assessed_male) + sum(assessed_female) as assessed_total,
sum(competent_male) as competent_male,
sum(competent_female) as competent_female,
sum(competent_male) + sum(competent_female) as competent_total'))->where('report_date_id', $this->report_date_id)->where('occupation_id', $occupation_id)->whereIn('institution_id', Institution::select('id')->where('region_id', $this->region_id)->where('ownership', 'Public')->lists('id'))->get();
return $result;
}
public function getShortTermTraineesByInstitutionID($institution_id)
{
$result = ShortTermTrainee::select(DB::raw('
sum(registered_male) as registered_male,
sum(registered_female) as registered_female,
sum(registered_male) + sum(registered_female) as registered_total,
sum(started_training_male) as started_training_male,
sum(started_training_female) as started_training_female,
sum(started_training_male) + sum(started_training_female) as started_training_total,
sum(completed_training_male) as completed_training_male,
sum(completed_training_female) as completed_training_female,
sum(completed_training_male) + sum(completed_training_female) as completed_training_total,
sum(sent_assessment_male) as sent_assessment_male,
sum(sent_assessment_female) as sent_assessment_female,
sum(sent_assessment_male) + sum(sent_assessment_female) as sent_assessment_total,
sum(assessed_male) as assessed_male,
sum(assessed_female) as assessed_female,
sum(assessed_male) + sum(assessed_female) as assessed_total,
sum(competent_male) as competent_male,
sum(competent_female) as competent_female,
sum(competent_male) + sum(competent_female) as competent_total'))->where('report_date_id', $this->report_date_id)->where('institution_id', $institution_id)->get();
return $result;
}
public function for_print_rpt1_non_gov_short($id)
{
$user = Auth::user();
$region = Region::findOrFail($user->region_id);
$report_date = ReportDate::findOrFail($id);
$rpt1 = new RTAReport1NonGovernment($report_date->id, $user->region_id);
// get occupations
$occupations = Occupation::whereIn('id', ShortTermTrainee::select('occupation_id')->where('report_date_id', $id)->whereIn('institution_id', Institution::select('id')->where('region_id', $region->id)->where('ownership', '!=', 'Public')->lists('id'))->lists('occupation_id'))->orderBy('name')->get();
// get sectors
$sectors = Sector::whereIn('id', Subsector::select('sector_id')->whereIn('id', $occupations->lists('subsector_id'))->get())->get();
// get subsectors
$subsectors = Subsector::whereIn('id', $occupations->lists('subsector_id'))->get();
return view('rtaadmin.print_rpt1nongov_5', compact('rpt1', 'region', 'report_date', 'sectors', 'subsectors', 'occupations'));
}
