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 getExtensionDropoutGraduatesByOccupation($occupation_id)
{
$result = DropoutGraduate::select(DB::raw('
sum(extension_level1_male) as ext_level1_male,
sum(extension_level1_female) as ext_level1_female,
sum(extension_level1_male) + sum(extension_level1_female) as ext_level1_total,
sum(extension_level2_male) as ext_level2_male,
sum(extension_level2_female) as ext_level2_female,
sum(extension_level2_male) + sum(extension_level2_female) as ext_level2_total,
sum(extension_level3_male) as ext_level3_male,
sum(extension_level3_female) as ext_level3_female,
sum(extension_level3_male) + sum(extension_level3_female) as ext_level3_total,
sum(extension_level4_male) as ext_level4_male,
sum(extension_level4_female) as ext_level4_female,
sum(extension_level4_male) + sum(extension_level4_female) as ext_level4_total,
sum(extension_level5_male) as ext_level5_male,
sum(extension_level5_female) as ext_level5_female,
sum(extension_level5_male) + sum(extension_level5_female) as ext_level5_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 ie_mse_operators()
{
$result = IndustryExtension2::select(DB::raw('sum(starter_enterprise) as starter_enterprise,
sum(starter_mse_operator_male) as starter_mse_operator_male,
sum(starter_mse_operator_female) as starter_mse_operator_female,
sum(starter_mse_operator_supported_male) as starter_mse_operator_supported_male,
sum(starter_mse_operator_supported_female) as starter_mse_operator_supported_female,
sum(advance_enterprise) as advance_enterprise,
sum(advance_mse_operator_male) as advance_mse_operator_male,
sum(advance_mse_operator_female) as advance_mse_operator_female,
sum(advance_mse_operator_supported_male) as advance_mse_operator_supported_male,
sum(advance_mse_operator_supported_female) as advance_mse_operator_supported_female,
sum(competent_enterprise) as competent_enterprise,
sum(competent_mse_operator_male) as competent_mse_operator_male,
sum(competent_mse_operator_female) as competent_mse_operator_female,
sum(competent_mse_operator_supported_male) as competent_mse_operator_supported_male,
sum(competent_mse_operator_supported_female) as competent_mse_operator_supported_female'))->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 for_print_rpt1_non_gov_drop_grad($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', DropoutGraduate::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_7', compact('rpt1', 'region', 'report_date', 'sectors', 'subsectors', 'occupations'));
}
public function disabilities()
{
$result = FormalTraining::select(DB::raw('sum(mental_male) as mental_male,
sum(mental_female) as mental_female,
sum(visual_male) as visual_male,
sum(visual_female) as visual_female,
sum(hearing_male) as hearing_male,
sum(hearing_female) as hearing_female,
sum(physical_male) as physical_male,
sum(physical_female) as physical_female'))->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;
}
