public function plannedVsActual() { $monthlyPlansCount = 0; $plannedVsActual = []; //Planned VS Actual // Planned Visits $monthlyPlans = Plan::select('doctors')->where('mr_id', \Auth::user()->id)->where('month', date('M-Y'))->get(); foreach ($monthlyPlans as $singlePlan) { $monthlyPlansCount += count(json_decode($singlePlan->doctors)); } // Actual Visits $actualVisits = Report::planned()->count(); $plannedVsActual[0]['label'] = 'Planned'; $plannedVsActual[0]['data'] = $monthlyPlansCount; $plannedVsActual[1]['label'] = 'Actual'; $plannedVsActual[1]['data'] = $actualVisits; return json_encode($plannedVsActual); }