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