/** * 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); }
public function update($id) { // save updated $record = $this->records->find($id); if (!$record) { Measure::create(Input::all()); return $this->respond($record); } $record->fill(Input::all())->save(); return $this->respond($record); }
public function run() { DB::table('measures')->delete(); //60lbs -> bushel Measure::create(['unit' => 'bushel', 'abr' => 'bu', 'toPounds' => 60, 'fromPounds' => 1.8E-5]); //1lb -> pound Measure::create(['unit' => 'pound', 'abr' => 'lb', 'toPounds' => 1, 'fromPounds' => 1]); Measure::create(['unit' => 'hundredweight', 'abr' => 'cwt', 'toPounds' => 100, 'fromPounds' => 0.01]); Measure::create(['unit' => 'ton', 'abr' => 'ton', 'toPounds' => 2000, 'fromPounds' => 0.005]); Measure::create(['unit' => 'barrel', 'abr' => 'bbl', 'toPounds' => 162, 'fromPounds' => 0.00357]); //500 lbs -> bale Measure::create(['unit' => 'bale', 'abr' => 'bl', 'toPounds' => 500, 'fromPounds' => 0.002]); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $this->viewData['success'] = true; $this->viewData['content'] = []; $measure = _MODEL::find($id); // objective if (empty($measure)) { $this->viewData['success'] = false; return response()->json($this->viewData); } $this->viewData['content']['measure'] = $measure; $this->viewData['content']['measure']['actual_measures'] = $measure->actual_measures; return response()->json($this->viewData); }
/** * Display a listing of the resource. * * @return Response */ public function index() { if (!empty(Input::get('plan_id'))) { $this->viewData['currentPlan'] = Plan::find(Input::get('plan_id')); } $list = _MODEL::leftJoin('plans', 'plans.id', '=', 'dimensions.plan_id')->where('plans.user_id', '=', $this->viewData['user_id'])->where('plans.id', '=', $this->viewData['currentPlan']->id)->select('dimensions.*')->get(); foreach ($list as $row) { $row->AVERAGE = 0; // get objectives list related to dimension $objectives = Objective::where('objectives.dimension_id', '=', (int) $row->id)->select('*')->get(); $objective_AVERAGE = 0; $objective_count = 0; foreach ($objectives as $objective) { //get initiatives related to objective $initiatives = Initiative::where('initiatives.objective_id', '=', (int) $objective->id)->select('*')->get(); $initiative_AVERAGE = 0; $initiative_count = 0; foreach ($initiatives as $initiative) { //get measures related to initiative $measures = Measure::where('measures.initiative_id', '=', (int) $initiative->id)->select('*')->get(); $measure_count = 0; $percent = 0; foreach ($measures as $measure) { $measure->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $measure->id)->sum('actual_measures.actual_measure'); if ($measure->target != 0) { $percent += $measure->actual / $measure->target * 100; } $measure_count++; } //end measures if ($measure_count != 0) { $initiative_AVERAGE += $percent / $measure_count; } $initiative_count++; } //end initiative if ($initiative_count != 0) { $objective_AVERAGE += $initiative_AVERAGE / $initiative_count; } $objective_count++; } if ($objective_count != 0) { $row->AVERAGE = $objective_AVERAGE / $objective_count; } } return view($this->controller . '.index', compact('list'), $this->viewData); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $this->viewData['user_id'] = Auth::User()->id; $list = _MODEL::where('user_id', '=', (int) $this->viewData['user_id'])->get(); array_push($this->viewData['breadcrumb'], array()); foreach ($list as $row) { $row->AVERAGE = 0; // get objectives list related to dimension $objectives = Objective::where('objectives.dimension_id', '=', (int) $row->id)->select('*')->get(); $objective_AVERAGE = 0; $objective_count = 0; foreach ($objectives as $objective) { //get initiatives related to objective $initiatives = Initiative::where('initiatives.objective_id', '=', (int) $objective->id)->select('*')->get(); $initiative_AVERAGE = 0; $initiative_count = 0; foreach ($initiatives as $initiative) { //get measures related to initiative $measures = Measure::where('measures.initiative_id', '=', (int) $initiative->id)->select('*')->get(); $measure_count = 0; $percent = 0; foreach ($measures as $measure) { $measure->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $measure->id)->sum('actual_measures.actual_measure'); if ($measure->target != 0) { $percent += $measure->actual / $measure->target * 100; } $measure_count++; } //end measures if ($measure_count != 0) { $initiative_AVERAGE += $percent / $measure_count; } $initiative_count++; } //end initiative if ($initiative_count != 0) { $objective_AVERAGE += $initiative_AVERAGE / $initiative_count; } $objective_count++; } if ($objective_count != 0) { $row->AVERAGE = $objective_AVERAGE / $objective_count; } } return view($this->controller . '.index', compact('list'), $this->viewData); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $list = _MODEL::all(); $list = _MODEL::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('initiatives.*')->get(); foreach ($list as $row) { //get measures related to initiative $measures = Measure::where('measures.initiative_id', '=', (int) $row->id)->select('*')->get(); $percent = 0; $row->AVERAGE = 0; $measure_count = 0; foreach ($measures as $measure) { $measure->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $measure->id)->sum('actual_measures.actual_measure'); if ($measure->target != 0) { $percent += $measure->actual / $measure->target * 100; } $measure_count++; } //end initiative if ($measure_count != 0) { $row->AVERAGE = $percent / $measure_count; } } return view($this->controller . '.index', compact('list'), $this->viewData); }
public function getAverageDimension($dimension) { $dimension->AVERAGE = 0; // get objectives list related to dimension $objectives = Objective::where('objectives.dimension_id', '=', (int) $dimension->id)->select('*')->get(); $objective_AVERAGE = 0; $objective_count = 0; foreach ($objectives as $objective) { //get initiatives related to objective $initiatives = Initiative::where('initiatives.objective_id', '=', (int) $objective->id)->select('*')->get(); $initiative_AVERAGE = 0; $initiative_count = 0; foreach ($initiatives as $initiative) { //get measures related to initiative $measures = Measure::where('measures.initiative_id', '=', (int) $initiative->id)->select('*')->get(); $measure_count = 0; $percent = 0; foreach ($measures as $measure) { $measure->actual = ActualMeasure::where('actual_measures.measure_id', '=', (int) $measure->id)->sum('actual_measures.actual_measure'); if ($measure->target != 0) { $percent += $measure->actual / $measure->target * 100; } $measure_count++; } //end measures if ($measure_count != 0) { $initiative_AVERAGE += $percent / $measure_count; } $initiative_count++; } //end initiative if ($initiative_count != 0) { $objective_AVERAGE += $initiative_AVERAGE / $initiative_count; } $objective_count++; } if ($objective_count != 0) { $dimension->AVERAGE = (double) $objective_AVERAGE / $objective_count; } return $dimension; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { _MODEL::find($id)->delete(); Session::flash('message', $this->viewData['whatisit'] . ' deleted!'); Session::flash('alert-class', 'alert-danger'); return redirect($this->controller); }