/** * Display a listing of the resource. * * @return Response */ public function index($measureId) { // $list = _MODEL::all(); $this->viewData['measure_id'] = $measureId; $this->viewData['measure'] = Measure::find($measureId); $list = _MODEL::leftJoin('measures', 'measures.id', '=', 'actual_measures.measure_id')->leftJoin('initiatives', 'initiatives.id', '=', 'measures.initiative_id')->leftJoin('objectives', 'objectives.id', '=', 'initiatives.objective_id')->leftJoin('dimensions', 'dimensions.id', '=', 'objectives.dimension_id')->leftJoin('plans', 'plans.id', '=', 'dimensions.plan_id')->where('actual_measures.measure_id', '=', (int) $this->viewData['measure_id'])->where('plans.user_id', '=', $this->viewData['user_id'])->orderBy('actual_measures.month', 'asc')->select('actual_measures.*')->get(); $this->populateActualMeasureGraph(); return view($this->controller . '.index', compact('list'), $this->viewData); }