public function dashboard() { $practice = DB::table('practiceinfo')->where('practice_id', '=', Session::get('practice_id'))->first(); $user_id = Session::get('user_id'); $result = User::find($user_id); $practice_id = Session::get('practice_id'); $fax_query = Received::where('practice_id', '=', $practice_id)->count(); $displayname = $result->displayname; $from = $displayname . ' (' . $user_id . ')'; $data['header'] = $this->mobile_header_build(Session::get('displayname')); if (Session::get('group_id') == '2') { $data1['number_messages'] = Messaging::where('mailbox', '=', $user_id)->count(); $data1['number_documents'] = Scans::where('practice_id', '=', $practice_id)->count() + $fax_query; $data1['number_appts'] = $this->getNumberAppts($user_id); $query1 = DB::table('t_messages')->join('demographics', 't_messages.pid', '=', 'demographics.pid')->where('t_messages.t_messages_from', '=', $from)->where('t_messages.t_messages_signed', '=', 'No')->count(); $query2 = DB::table('encounters')->join('demographics', 'encounters.pid', '=', 'demographics.pid')->where('encounters.encounter_provider', '=', $displayname)->where('encounters.encounter_signed', '=', 'No')->count(); $data1['number_drafts'] = $query1 + $query2; $data1['number_reminders'] = DB::table('alerts')->join('demographics', 'alerts.pid', '=', 'demographics.pid')->where('alerts.alert_provider', '=', $user_id)->where('alerts.alert_date_complete', '=', '0000-00-00 00:00:00')->where('alerts.alert_reason_not_complete', '=', '')->where(function ($query_array) { $query_array->where('alerts.alert', '=', 'Laboratory results pending')->orWhere('alerts.alert', '=', 'Radiology results pending')->orWhere('alerts.alert', '=', 'Cardiopulmonary results pending')->orWhere('alerts.alert', '=', 'Referral pending')->orWhere('alerts.alert', '=', 'Reminder')->orWhere('alerts.alert', '=', 'REMINDER'); })->count(); $data1['number_bills'] = Encounters::where('bill_submitted', '=', 'No')->where('user_id', '=', $user_id)->count(); $data1['number_tests'] = Tests::whereNull('pid')->where('practice_id', '=', $practice_id)->count(); } $data['content'] = View::make('mobile.home_content', $data1)->render(); $data['form'] = ''; $left_panel_array = array(array('Schedule', 'mobile_schedule'), array('Inbox', 'mobile_inbox')); if (Session::get('group_id') != '100') { $left_panel_array[] = array('Drafts', 'mobile_drafts'); $left_panel_array[] = array('Alerts', 'mobile_alerts'); if (Session::get('patient_centric') == 'n') { $left_panel_array[] = array('Scans', 'mobile_scan'); if ($practice->fax_type != "") { $left_panel_array[] = array('Faxes', 'mobile_fax'); } } } $data['left_panel'] = $this->mobile_menu_build($left_panel_array, "left_panel_list", 'mobile_click_home'); $data['right_panel'] = ''; $this->layout->style = HTML::style('css/mobile.css'); $this->layout->style .= HTML::style('css/toastr.min.css'); $this->layout->script = $this->js_assets('base', true); $this->layout->content = View::make('mobile.home', $data); }
public function dashboard() { $user_id = Session::get('user_id'); $practice_id = Session::get('practice_id'); $data['practiceinfo'] = Practiceinfo::find($practice_id); $result = User::find($user_id); $data['displayname'] = $result->displayname; $displayname = $result->displayname; $fax_query = Received::where('practice_id', '=', $practice_id)->count(); $from = $displayname . ' (' . $user_id . ')'; if (Session::get('group_id') == '2') { $data['number_messages'] = Messaging::where('mailbox', '=', $user_id)->count(); $data['number_documents'] = Scans::where('practice_id', '=', $practice_id)->count() + $fax_query; $data['number_appts'] = $this->getNumberAppts($user_id); $query1 = DB::table('t_messages')->join('demographics', 't_messages.pid', '=', 'demographics.pid')->where('t_messages.t_messages_from', '=', $from)->where('t_messages.t_messages_signed', '=', 'No')->count(); $query2 = DB::table('encounters')->join('demographics', 'encounters.pid', '=', 'demographics.pid')->where('encounters.encounter_provider', '=', $displayname)->where('encounters.encounter_signed', '=', 'No')->count(); $data['number_drafts'] = $query1 + $query2; $data['number_reminders'] = DB::table('alerts')->join('demographics', 'alerts.pid', '=', 'demographics.pid')->where('alerts.alert_provider', '=', $user_id)->where('alerts.alert_date_complete', '=', '0000-00-00 00:00:00')->where('alerts.alert_reason_not_complete', '=', '')->where(function ($query_array) { $query_array->where('alerts.alert', '=', 'Laboratory results pending')->orWhere('alerts.alert', '=', 'Radiology results pending')->orWhere('alerts.alert', '=', 'Cardiopulmonary results pending')->orWhere('alerts.alert', '=', 'Referral pending')->orWhere('alerts.alert', '=', 'Reminder')->orWhere('alerts.alert', '=', 'REMINDER'); })->count(); $data['number_bills'] = Encounters::where('bill_submitted', '=', 'No')->where('user_id', '=', $user_id)->count(); $data['number_tests'] = Tests::whereNull('pid')->where('practice_id', '=', $practice_id)->count(); if ($data['practiceinfo']->mtm_extension == 'y') { $mtm_users_array = explode(",", $data['practiceinfo']->mtm_alert_users); if (in_array($user_id, $mtm_users_array)) { $data['mtm_alerts'] = Alerts::where('alert_date_complete', '=', '0000-00-00 00:00:00')->where('alert_reason_not_complete', '=', '')->where('alert', '=', 'Medication Therapy Management')->where('practice_id', '=', $practice_id)->count(); $data['mtm_alerts_status'] = "y"; } else { $data['mtm_alerts_status'] = "n"; } } else { $data['mtm_alerts_status'] = "n"; } $data['vaccine_supplement_alert'] = $this->vaccine_supplement_alert($practice_id); } if (Session::get('group_id') == '3') { $data['number_messages'] = Messaging::where('mailbox', '=', $user_id)->count(); $data['number_documents'] = Scans::where('practice_id', '=', $practice_id)->count() + $fax_query; $data['number_drafts'] = DB::table('t_messages')->join('demographics', 't_messages.pid', '=', 'demographics.pid')->where('t_messages.t_messages_from', '=', $from)->where('t_messages.t_messages_signed', '=', 'No')->count(); $data['number_reminders'] = DB::table('alerts')->join('demographics', 'alerts.pid', '=', 'demographics.pid')->where('alerts.alert_provider', '=', $user_id)->where('alerts.alert_date_complete', '=', '0000-00-00 00:00:00')->where('alerts.alert_reason_not_complete', '=', '')->where(function ($query_array) { $query_array->where('alerts.alert', '=', 'Laboratory results pending')->orWhere('alerts.alert', '=', 'Radiology results pending')->orWhere('alerts.alert', '=', 'Cardiopulmonary results pending')->orWhere('alerts.alert', '=', 'Referral pending')->orWhere('alerts.alert', '=', 'Reminder')->orWhere('alerts.alert', '=', 'REMINDER'); })->count(); $data['number_bills'] = Encounters::where('bill_submitted', '=', 'No')->where('practice_id', '=', $practice_id)->count(); $data['number_tests'] = Tests::whereNull('pid')->where('practice_id', '=', $practice_id)->count(); $data['vaccine_supplement_alert'] = $this->vaccine_supplement_alert($practice_id); } if (Session::get('group_id') == '4') { $data['number_messages'] = Messaging::where('mailbox', '=', $user_id)->count(); $data['number_bills'] = Encounters::where('bill_submitted', '=', 'No')->where('practice_id', '=', $practice_id)->count(); $data['number_documents'] = Scans::where('practice_id', '=', $practice_id)->count() + $fax_query; } if (Session::get('group_id') == '100') { $row = Demographics_relate::where('id', '=', $user_id)->first(); Session::put('pid', $row->pid); } if (Session::get('group_id') == '1') { if ($practice_id == '1') { $data['saas_admin'] = 'y'; } else { $data['saas_admin'] = 'n'; } if (Session::get('patient_centric') != 'y') { $users = DB::table('users')->where('group_id', '=', '2')->where('practice_id', '=', Session::get('practice_id'))->first(); if ($users) { $data['users_needed'] = 'n'; } else { $data['users_needed'] = 'y'; } } else { $data['users_needed'] = 'n'; } if (Session::get('patient_centric') != 'y') { $schedule = DB::table('practiceinfo')->where('practice_id', '=', Session::get('practice_id'))->whereNull('minTime')->first(); if ($schedule) { $data['schedule_needed'] = 'y'; } else { $data['schedule_needed'] = 'n'; } } else { $data['schedule_needed'] = 'n'; } } if ($data['practiceinfo']->weekends == '1') { $data['weekends'] = 'true'; } else { $data['weekends'] = 'false'; } $data['minTime'] = ltrim($data['practiceinfo']->minTime, "0"); $data['maxTime'] = ltrim($data['practiceinfo']->maxTime, "0"); if (Session::get('group_id') == '2') { $provider = Providers::find(Session::get('user_id')); $data['schedule_increment'] = $provider->schedule_increment; } else { $data['schedule_increment'] = '15'; } if (!Session::get('encounter_active')) { Session::put('encounter_active', 'n'); } if ($data['practiceinfo']->fax_type != "") { $data1['fax'] = true; } else { $data1['fax'] = false; } $this->layout->style = $this->css_assets(); $this->layout->script = $this->js_assets('home'); $this->layout->content = ''; if (Session::get('group_id') == '1') { $this->layout->content .= View::make('search', $this->getSearchData())->render(); $this->layout->content .= View::make('dashboard', $data)->render(); $this->layout->content .= View::make('setup')->render(); $this->layout->content .= View::make('users')->render(); $this->layout->content .= View::make('extensions', $data)->render(); $this->layout->content .= View::make('schedule_admin')->render(); $this->layout->content .= View::make('update')->render(); $this->layout->content .= View::make('logs')->render(); $this->layout->content .= View::make('schedule')->render(); } if (Session::get('group_id') == '2' || Session::get('group_id') == '3' || Session::get('group_id') == '4') { $this->layout->content .= View::make('search', $this->getSearchData())->render(); $this->layout->content .= View::make('dashboard', $data)->render(); $this->layout->content .= View::make('demographics')->render(); $this->layout->content .= View::make('options')->render(); $this->layout->content .= View::make('messaging', $data1)->render(); $this->layout->content .= View::make('schedule')->render(); $this->layout->content .= View::make('billing')->render(); $this->layout->content .= View::make('financial')->render(); $this->layout->content .= View::make('office')->render(); if (Session::get('patient_centric') == 'yp' && Session::get('group_id') == '2') { $this->layout->content .= View::make('setup')->render(); } } if (Session::get('group_id') == '100') { $this->layout->content .= View::make('dashboard', $data)->render(); $this->layout->content .= View::make('demographics')->render(); $this->layout->content .= View::make('messaging', $data1)->render(); $this->layout->content .= View::make('schedule')->render(); $this->layout->content .= View::make('issues')->render(); $this->layout->content .= View::make('encounters')->render(); $this->layout->content .= View::make('t_messages')->render(); $this->layout->content .= View::make('medications')->render(); $this->layout->content .= View::make('supplements')->render(); $this->layout->content .= View::make('allergies')->render(); $this->layout->content .= View::make('immunizations')->render(); $this->layout->content .= View::make('documents')->render(); $this->layout->content .= View::make('forms')->render(); $this->layout->content .= View::make('graph')->render(); } }