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