3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2017 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2017
35 * This class is for activity assignment functions.
37 class CRM_Activity_BAO_ActivityAssignment
extends CRM_Activity_DAO_ActivityContact
{
42 public function __construct() {
43 parent
::__construct();
47 * Add activity assignment.
49 * @param array $params
50 * (reference ) an assoc array of name/value pairs.
53 * activity type of object that is added
55 public static function create(&$params) {
56 $assignment = new CRM_Activity_BAO_ActivityContact();
57 $activityContacts = CRM_Core_OptionGroup
::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
58 $assigneeID = CRM_Utils_Array
::key('Activity Assignees', $activityContacts);
60 $assignment->copyValues($params);
61 $assignment->record_type_id
= $assigneeID;
63 return $assignment->save();
67 * Retrieve assignee_id by activity_id.
69 * @param int $activity_id
73 public static function retrieveAssigneeIdsByActivityId($activity_id) {
74 $assigneeArray = array();
75 if (!CRM_Utils_Rule
::positiveInteger($activity_id)) {
76 return $assigneeArray;
79 $activityContacts = CRM_Core_OptionGroup
::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
80 $assigneeID = CRM_Utils_Array
::key('Activity Assignees', $activityContacts);
84 FROM civicrm_activity_contact
85 INNER JOIN civicrm_contact ON contact_id = civicrm_contact.id
86 WHERE activity_id = %1
87 AND record_type_id = $assigneeID
88 AND civicrm_contact.is_deleted = 0
90 $assignment = CRM_Core_DAO
::executeQuery($sql, array(1 => array($activity_id, 'Integer')));
91 while ($assignment->fetch()) {
92 $assigneeArray[] = $assignment->contact_id
;
95 return $assigneeArray;
99 * Retrieve assignee names by activity_id.
101 * @param array $activityIDs
102 * IDs of the activities.
103 * @param bool $isDisplayName
104 * If set returns display names of assignees.
105 * @param bool $skipDetails
106 * If false returns all details of assignee contact.
110 public static function getAssigneeNames($activityIDs, $isDisplayName = FALSE, $skipDetails = TRUE) {
111 $assigneeNames = array();
112 if (empty($activityIDs)) {
113 return $assigneeNames;
115 $activityContacts = CRM_Core_OptionGroup
::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
116 $assigneeID = CRM_Utils_Array
::key('Activity Assignees', $activityContacts);
120 $whereClause = " AND ce.is_primary= 1";
122 $inClause = implode(",", $activityIDs);
125 SELECT contact_a.id, contact_a.sort_name, contact_a.display_name, ce.email,
126 civicrm_activity_contact.activity_id
127 FROM civicrm_contact contact_a
128 INNER JOIN civicrm_activity_contact ON civicrm_activity_contact.contact_id = contact_a.id
129 LEFT JOIN civicrm_email ce ON ce.contact_id = contact_a.id
130 WHERE civicrm_activity_contact.activity_id IN ( $inClause )
131 AND contact_a.is_deleted = 0
132 AND civicrm_activity_contact.record_type_id = $assigneeID
136 $dao = CRM_Core_DAO
::executeQuery($query);
137 while ($dao->fetch()) {
138 if (!$isDisplayName) {
139 $assigneeNames[$dao->id
] = $dao->sort_name
;
143 $assigneeNames[$dao->id
] = $dao->display_name
;
146 $assigneeNames[$dao->id
]['contact_id'] = $dao->id
;
147 $assigneeNames[$dao->id
]['display_name'] = $dao->display_name
;
148 $assigneeNames[$dao->id
]['sort_name'] = $dao->sort_name
;
149 $assigneeNames[$dao->id
]['email'] = $dao->email
;
150 $assigneeNames[$dao->id
]['role'] = ts('Activity Assignee');
151 $assigneeNames[$dao->id
]['activity_id'] = $dao->activity_id
;
155 return $assigneeNames;