/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $user = Auth::user(); $criteria = array('report_date_id' => $id, 'institution_id' => $user->institution->id); $cooperative_trainings = CooperativeTraining::where($criteria)->paginate(10); $report_date = ReportDate::findOrFail($id); return view('tviadmin.cooperative_trainings.index2', array('cooperative_trainings' => $cooperative_trainings, 'report_date' => $report_date)); }
public function mls($subsector_id) { $result = CooperativeTraining::where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->whereIn('occupation_id', DB::table('occupations')->select('id')->where(array('subsector_id' => $subsector_id))->lists('id'))->sum('ml_training'); return $result; }