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