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