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);
}
