/** * Computes and returns data for dashboard. * **/ public function showMainDashboardInfo() { $results = array(); $NoOfOpdCases30days = CommunityMemberOpdCase::where(DB::raw('datediff(now(),rec_date )'), '<', array(30))->count(); $results['NoOfOpdCases30days'] = $NoOfOpdCases30days; $NoOfOpdCases7days = CommunityMemberOpdCase::where(DB::raw('datediff(now(),rec_date )'), '<', array(7))->count(); $results['NoOfOpdCases7days'] = $NoOfOpdCases7days; return View::make('dashboards.maindashboard', compact('NoOfOpdCases7days', 'NoOfOpdCases30days', 'results')); }