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