/**
* Create a new controller instance.
*
* @return void
*/
public function __construct()
{
$this->middleware('auth');
$this->viewData['user_id'] = (int) Auth::User()->id;
$this->viewData['controller_heading'] = 'Actual Measures';
$this->viewData['controller_name'] = $this->controller;
$this->viewData['whatisit'] = 'Actual Measure';
$this->viewData['months'] = array(1 => 'Jan', 2 => 'Feb', 3 => 'Mar', 4 => 'Apr', 5 => 'May', 6 => 'Jun', 7 => 'Jul', 8 => 'Aug', 9 => 'Sept', 10 => 'Oct', 11 => 'Nov', 12 => 'Dec', 2 => 'Feb', 3 => 'Mar', 1 => 'Jan', 2 => 'Feb', 3 => 'Mar');
$this->viewData['measures'] = Measure::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('plans.user_id', '=', $this->viewData['user_id'])->where('initiatives.status', 0)->orderBy('initiatives.name')->select('initiatives.*')->lists('initiatives.name', 'initiatives.id');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
// $list = _MODEL::all();
$list = _MODEL::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('plans.user_id', '=', $this->viewData['user_id'])->where('plans.id', '=', $this->viewData['currentPlan']->id)->select('measures.*')->get();
foreach ($list as $row) {
//Calculate actual
$row->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $row->id)->sum('actual_measures.actual_measure');
if ($row->target != 0) {
$row->percent = $row->actual / $row->target * 100;
}
}
return view($this->controller . '.index', compact('list'), $this->viewData);
}
