X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FCase%2FBAO%2FCase.php;h=39823568ebe26d6af7fca940f8e40d62e7e05bed;hb=9c41996008a0cb938cd30d8996cdec462c6a61a7;hp=b251ffa58d902e8c893f18a6689bb2b8e2c3e14a;hpb=9cc8b9b246a371b9621a8279545258073fbd0e48;p=civicrm-core.git diff --git a/CRM/Case/BAO/Case.php b/CRM/Case/BAO/Case.php index b251ffa58d..39823568eb 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -1307,10 +1307,10 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c //check for operations. if (self::checkPermission($dao->id, 'Move To Case', $dao->activity_type_id)) { - $url .= ' ' . ts('Move To Case') . ' '; + $url .= ' ' . ts('Move To Case') . ' '; } if (self::checkPermission($dao->id, 'Copy To Case', $dao->activity_type_id)) { - $url .= ' ' . ts('Copy To Case') . ' '; + $url .= ' ' . ts('Copy To Case') . ' '; } // if there are file attachments we will return how many and, if only one, add a link to it if (!empty($dao->attachment_ids)) { @@ -1375,13 +1375,18 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c */ static function getRelatedContacts($caseID, $skipDetails = FALSE) { $values = array(); - $query = 'SELECT cc.display_name as name, cc.sort_name as sort_name, cc.id, crt.label_b_a as role, ce.email - FROM civicrm_relationship cr - LEFT JOIN civicrm_relationship_type crt ON crt.id = cr.relationship_type_id - LEFT JOIN civicrm_contact cc ON cc.id = cr.contact_id_b - LEFT JOIN civicrm_email ce ON ce.contact_id = cc.id - WHERE cr.case_id = %1 AND ce.is_primary= 1 - GROUP BY cc.id'; + $query = ' + SELECT cc.display_name as name, cc.sort_name as sort_name, cc.id, crt.label_b_a as role, ce.email + FROM civicrm_relationship cr + LEFT JOIN civicrm_relationship_type crt + ON crt.id = cr.relationship_type_id + LEFT JOIN civicrm_contact cc + ON cc.id = cr.contact_id_b + LEFT JOIN civicrm_email ce + ON ce.contact_id = cc.id + AND ce.is_primary= 1 + WHERE cr.case_id = %1 + GROUP BY cc.id'; $params = array(1 => array($caseID, 'Integer')); $dao = CRM_Core_DAO::executeQuery($query, $params); @@ -2093,7 +2098,8 @@ SELECT civicrm_contact.id as casemanager_id, {$limitClause} "; $dao = CRM_Core_DAO::executeQuery($query); - $statuses = CRM_Case_PseudoConstant::caseStatus(); + $statuses = CRM_Case_BAO_Case::buildOptions('status_id', 'create'); + $unclosedCases = array(); while ($dao->fetch()) { if ($doFilterCases && !array_key_exists($dao->id, $filterCases)) {