get_results("SELECT id FROM {$wpdb->prefix}kc_clinics"))->pluck('id')->implode(","); } if(!empty($this->getLoginUserRole())){ $user_id = get_current_user_id(); if(isKiviCareProActive()){ if( $this->getLoginUserRole() === 'KiviCare_receptionist'){ $clinic_id = $wpdb->get_var("SELECT clinic_id FROM {$wpdb->prefix}kc_receptionist_clinic_mappings WHERE receptionist_id={$user_id}"); } if($this->getLoginUserRole() === 'kiviCare_doctor'){ unset($userList['KiviCare_doctor']); unset($userList['KiviCare_receptionist']); $clinic_id = collect($wpdb->get_results("SELECT clinic_id FROM {$wpdb->prefix}kc_doctor_clinic_mappings WHERE doctor_id = {$user_id}"))->pluck('clinic_id')->implode(","); } if($this->getLoginUserRole() === 'kiviCare_clinic_admin'){ $clinic_id = $wpdb->get_var("SELECT id FROM {$wpdb->prefix}kc_clinics WHERE clinic_admin_id = {$user_id}"); } } } $clinic = []; if(empty($clinic_id_param)){ $clinic = collect($wpdb->get_results("SELECT id,name FROM {$wpdb->prefix}kc_clinics WHERE id IN ({$clinic_id}) AND status = 1"))->toArray(); } $theme_mode = get_option(KIVI_CARE_PREFIX . 'theme_mode'); $rtl_attr = in_array($theme_mode,['1','true']) ? 'rtl' : ''; ?>