/**
  * 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);
 }
Пример #2
0
 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);
 }
Пример #3
0
 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);
 }
Пример #6
0
 /**
  * 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);
 }