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;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$user = Auth::user();
$institution_id = $user->institution->id;
// determine the user_id of the Regional Administrator
$region_administrator = User::where('user_type', 'Region Administrator')->where('active', true)->where('region_id', $user->region->id)->first();
$report_dates = ReportDate::where('user_id', $region_administrator->id)->orderBy('petsa', 'desc')->lists('petsa', 'id');
return view('tviadmin.indicators.index', array('institution_id' => $institution_id, 'report_dates' => $report_dates));
}
public function show(Request $request)
{
$report_date = ReportDate::findOrFail($request->get('report_date_id'));
$institution = Institution::findOrFail($request->get('institution_id'));
$data_summary_trainers = new DataSummaryTrainers($request->get('institution_id'), $request->get('report_date_id'));
$data_summary_trainees = new DataSummaryTrainees($request->get('institution_id'), $request->get('report_date_id'));
$data_summary_cooperative_trainings = new DataSummaryCooperativeTrainings($request->get('institution_id'), $request->get('report_date_id'));
$data_summary_industry_extension = new DataSummaryIndustryExtension($request->get('institution_id'), $request->get('report_date_id'));
return view('tviadmin.report.show', array('data_summary_trainers' => $data_summary_trainers, 'data_summary_trainees' => $data_summary_trainees, 'data_summary_cooperative_trainings' => $data_summary_cooperative_trainings, 'data_summary_industry_extension' => $data_summary_industry_extension, 'institution' => $institution, 'report_date' => $report_date));
}
public function saveAsForm($id)
{
$user = Auth::user();
// determine the user_id of the Regional Administrator
$region_administrator = User::where('user_type', 'Region Administrator')->where('active', true)->where('region_id', $user->region->id)->first();
$report_dates = ReportDate::where('user_id', $region_administrator->id)->orderBy('petsa', 'desc')->lists('petsa', 'id');
$report_date = ReportDate::findOrFail($id);
return view('tviadmin.job_placement_graduates.save_as', array('report_dates' => $report_dates, 'report_date' => $report_date, 'institution_id' => $user->institution->id));
}
public function saveAsForm($id)
{
$user = Auth::user();
$report_dates = ReportDate::orderBy('petsa', 'desc')->lists('petsa', 'id');
$report_date = ReportDate::findOrFail($id);
return view('tviadmin.industry_extension1s.save_as', array('report_dates' => $report_dates, 'report_date' => $report_date, 'institution_id' => $user->institution->id));
}
public function delete($id)
{
$report_date = ReportDate::findOrFail($id);
return view('tviadmin.report_dates.delete', compact('report_date'));
}
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 show_report2_non_government(Request $request)
{
$user = Auth::user();
$region = Region::findOrFail($user->region_id);
$report_date = ReportDate::findOrFail($request->get('petsa'));
$rpt2 = new RTAReport2NonGovernment($report_date->id, $user->region_id);
switch ($request->get('report')) {
case 0:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', NewEnrollee::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_1', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 1:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', ReEnrollee::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_2', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 2:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', Transferee::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_3', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 3:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', Graduate::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_4', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 4:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', ShortTermTrainee::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_5', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 5:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', DropoutTransferee::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_6', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
case 6:
$institutions = Institution::where('region_id', $region->id)->where('ownership', '!=', 'Public')->whereIn('id', DropoutGraduate::where('report_date_id', $request->get('petsa'))->lists('institution_id'))->orderBy('name')->get();
return view('rtaadmin.show_rpt2nongov_7', compact('rpt2', 'region', 'report_date', 'institutions'));
break;
}
}
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;
}
