From 39fab6d7ea6653c9d0c7a82fa5f47cc90df27ecf Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Mon, 31 Jul 2017 16:11:57 +1000 Subject: [PATCH] CRM-20989 Fix Active provider count to know about multistie and return a proper count --- CRM/SMS/BAO/Provider.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/SMS/BAO/Provider.php b/CRM/SMS/BAO/Provider.php index ee1bdb5fee..21c55629c6 100644 --- a/CRM/SMS/BAO/Provider.php +++ b/CRM/SMS/BAO/Provider.php @@ -43,7 +43,8 @@ class CRM_SMS_BAO_Provider extends CRM_SMS_DAO_Provider { * @return null|string */ public static function activeProviderCount() { - $activeProviders = CRM_Core_DAO::singleValueQuery('SELECT MAX(id) FROM civicrm_sms_provider WHERE is_active = 1'); + $activeProviders = CRM_Core_DAO::singleValueQuery('SELECT count(id) FROM civicrm_sms_provider WHERE is_active = 1 AND (domain_id = %1 OR domain_id IS NULL)', + array(1 => array(CRM_Core_Config::domainID(), 'Positive'))); return $activeProviders; } -- 2.25.1