/** * 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')); }