/** * Display a listing of the resource. * * @return Response */ public function showNotifiableDiseaseEvents() { $notifableDiseases = CommunityMemberOpdCase::with('opdCase', 'communityMember')->select('opd_case_id', DB::raw('count("community_member_id") as SuspectedCases'))->get(); /** SELECT COUNT( `community_members_opd_cases`.`community_member_id` ), `opd_cases`.`opd_case_name`, `opd_case_categories`.`opd_case_category_id`, `opd_case_categories`.`opd_case_category`, `community_members_opd_cases`.`rec_date`, `community_members_opd_cases`.`lab` FROM `mhealth-ashesi`.`opd_case_categories` AS `opd_case_categories`, `mhealth-ashesi`.`opd_cases` AS `opd_cases`, `mhealth-ashesi`.`community_members` AS `community_members`, `mhealth-ashesi`.`community_members_opd_cases` AS `community_members_opd_cases` WHERE `opd_case_categories`.`opd_case_category_id` = `opd_cases`.`opd_case_category` AND `community_members`.`community_member_id` = `community_members_opd_cases`.`community_member_id` AND `opd_cases`.`opd_case_id` = `community_members_opd_cases`.`opd_case_id` GROUP BY `opd_cases`.`opd_case_name` */ return View::make('opdcases.diseaseEvents', compact('notifableDiseases')); }
/** * 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')); }