/** * 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); $industry_extension5s = IndustryExtension5::where($criteria)->paginate(10); $report_date = ReportDate::findOrFail($id); return view('tviadmin.industry_extension5s.index2', array('industry_extension5s' => $industry_extension5s, 'report_date' => $report_date)); }
public function medium($subsector_id) { $result = IndustryExtension5::where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->where('subsector_id', $subsector_id)->sum('medium'); return $result; }