Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
7e9e8871 | 4 | | CiviCRM version 4.7 | |
6a488035 | 5 | +--------------------------------------------------------------------+ |
0f03f337 | 6 | | Copyright CiviCRM LLC (c) 2004-2017 | |
6a488035 TO |
7 | +--------------------------------------------------------------------+ |
8 | | This file is a part of CiviCRM. | | |
9 | | | | |
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. | | |
13 | | | | |
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. | | |
18 | | | | |
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 | +--------------------------------------------------------------------+ | |
e70a7fc0 | 26 | */ |
6a488035 TO |
27 | |
28 | /** | |
29 | * | |
30 | * @package CRM | |
0f03f337 | 31 | * @copyright CiviCRM LLC (c) 2004-2017 |
6a488035 TO |
32 | */ |
33 | class CRM_Contact_BAO_Group extends CRM_Contact_DAO_Group { | |
34 | ||
35 | /** | |
67d19299 | 36 | * Class constructor. |
6a488035 | 37 | */ |
00be9182 | 38 | public function __construct() { |
6a488035 TO |
39 | parent::__construct(); |
40 | } | |
41 | ||
42 | /** | |
fe482240 EM |
43 | * Retrieve DB object based on input parameters. |
44 | * | |
45 | * It also stores all the retrieved values in the default array. | |
6a488035 | 46 | * |
77c5b619 TO |
47 | * @param array $params |
48 | * (reference ) an assoc array of name/value pairs. | |
49 | * @param array $defaults | |
50 | * (reference ) an assoc array to hold the flattened values. | |
6a488035 | 51 | * |
16b10e64 | 52 | * @return CRM_Contact_BAO_Group |
6a488035 | 53 | */ |
00be9182 | 54 | public static function retrieve(&$params, &$defaults) { |
6a488035 TO |
55 | $group = new CRM_Contact_DAO_Group(); |
56 | $group->copyValues($params); | |
57 | if ($group->find(TRUE)) { | |
58 | CRM_Core_DAO::storeValues($group, $defaults); | |
59 | return $group; | |
60 | } | |
6a488035 TO |
61 | } |
62 | ||
63 | /** | |
67d19299 | 64 | * Delete the group and all the object that connect to this group. |
65 | * | |
66 | * Incredibly destructive. | |
6a488035 | 67 | * |
67d19299 | 68 | * @param int $id Group id. |
6a488035 | 69 | */ |
00be9182 | 70 | public static function discard($id) { |
6a488035 TO |
71 | CRM_Utils_Hook::pre('delete', 'Group', $id, CRM_Core_DAO::$_nullArray); |
72 | ||
73 | $transaction = new CRM_Core_Transaction(); | |
74 | ||
75 | // added for CRM-1631 and CRM-1794 | |
76 | // delete all subscribed mails with the selected group id | |
77 | $subscribe = new CRM_Mailing_Event_DAO_Subscribe(); | |
78 | $subscribe->group_id = $id; | |
79 | $subscribe->delete(); | |
80 | ||
81 | // delete all Subscription records with the selected group id | |
82 | $subHistory = new CRM_Contact_DAO_SubscriptionHistory(); | |
83 | $subHistory->group_id = $id; | |
84 | $subHistory->delete(); | |
85 | ||
86 | // delete all crm_group_contact records with the selected group id | |
87 | $groupContact = new CRM_Contact_DAO_GroupContact(); | |
88 | $groupContact->group_id = $id; | |
89 | $groupContact->delete(); | |
90 | ||
91 | // make all the 'add_to_group_id' field of 'civicrm_uf_group table', pointing to this group, as null | |
92 | $params = array(1 => array($id, 'Integer')); | |
93 | $query = "UPDATE civicrm_uf_group SET `add_to_group_id`= NULL WHERE `add_to_group_id` = %1"; | |
94 | CRM_Core_DAO::executeQuery($query, $params); | |
95 | ||
96 | $query = "UPDATE civicrm_uf_group SET `limit_listings_group_id`= NULL WHERE `limit_listings_group_id` = %1"; | |
97 | CRM_Core_DAO::executeQuery($query, $params); | |
98 | ||
99 | // make sure u delete all the entries from civicrm_mailing_group and civicrm_campaign_group | |
100 | // CRM-6186 | |
101 | $query = "DELETE FROM civicrm_mailing_group where entity_table = 'civicrm_group' AND entity_id = %1"; | |
102 | CRM_Core_DAO::executeQuery($query, $params); | |
103 | ||
104 | $query = "DELETE FROM civicrm_campaign_group where entity_table = 'civicrm_group' AND entity_id = %1"; | |
105 | CRM_Core_DAO::executeQuery($query, $params); | |
106 | ||
107 | $query = "DELETE FROM civicrm_acl_entity_role where entity_table = 'civicrm_group' AND entity_id = %1"; | |
108 | CRM_Core_DAO::executeQuery($query, $params); | |
109 | ||
6a488035 TO |
110 | // delete from group table |
111 | $group = new CRM_Contact_DAO_Group(); | |
112 | $group->id = $id; | |
113 | $group->delete(); | |
114 | ||
115 | $transaction->commit(); | |
116 | ||
117 | CRM_Utils_Hook::post('delete', 'Group', $id, $group); | |
118 | ||
119 | // delete the recently created Group | |
120 | $groupRecent = array( | |
121 | 'id' => $id, | |
122 | 'type' => 'Group', | |
123 | ); | |
124 | CRM_Utils_Recent::del($groupRecent); | |
125 | } | |
126 | ||
127 | /** | |
128 | * Returns an array of the contacts in the given group. | |
ad37ac8e | 129 | * |
130 | * @param int $id | |
6a488035 | 131 | */ |
00be9182 | 132 | public static function getGroupContacts($id) { |
da0136df | 133 | $params = array(array('group', 'IN', array(1 => $id), 0, 0)); |
6a488035 TO |
134 | list($contacts, $_) = CRM_Contact_BAO_Query::apiQuery($params, array('contact_id')); |
135 | return $contacts; | |
136 | } | |
137 | ||
138 | /** | |
fe482240 | 139 | * Get the count of a members in a group with the specific status. |
6a488035 | 140 | * |
77c5b619 TO |
141 | * @param int $id |
142 | * Group id. | |
3f8d2862 CW |
143 | * @param string $status |
144 | * status of members in group | |
80ad33e7 | 145 | * @param bool $countChildGroups |
6a488035 | 146 | * |
a6c01b45 CW |
147 | * @return int |
148 | * count of members in the group with above status | |
6a488035 | 149 | */ |
00be9182 | 150 | public static function memberCount($id, $status = 'Added', $countChildGroups = FALSE) { |
6a488035 TO |
151 | $groupContact = new CRM_Contact_DAO_GroupContact(); |
152 | $groupIds = array($id); | |
153 | if ($countChildGroups) { | |
154 | $groupIds = CRM_Contact_BAO_GroupNesting::getDescendentGroupIds($groupIds); | |
155 | } | |
156 | $count = 0; | |
157 | ||
158 | $contacts = self::getGroupContacts($id); | |
159 | ||
160 | foreach ($groupIds as $groupId) { | |
161 | ||
162 | $groupContacts = self::getGroupContacts($groupId); | |
163 | foreach ($groupContacts as $gcontact) { | |
164 | if ($groupId != $id) { | |
165 | // Loop through main group's contacts | |
166 | // and subtract from the count for each contact which | |
167 | // matches one in the present group, if it is not the | |
168 | // main group | |
169 | foreach ($contacts as $contact) { | |
170 | if ($contact['contact_id'] == $gcontact['contact_id']) { | |
171 | $count--; | |
172 | } | |
173 | } | |
174 | } | |
175 | } | |
176 | $groupContact->group_id = $groupId; | |
177 | if (isset($status)) { | |
178 | $groupContact->status = $status; | |
179 | } | |
180 | $groupContact->_query['condition'] = 'WHERE contact_id NOT IN (SELECT id FROM civicrm_contact WHERE is_deleted = 1)'; | |
181 | $count += $groupContact->count(); | |
182 | } | |
183 | return $count; | |
184 | } | |
185 | ||
186 | /** | |
fe482240 | 187 | * Get the list of member for a group id. |
6a488035 | 188 | * |
100fef9d | 189 | * @param int $groupID |
80ad33e7 | 190 | * @param bool $useCache |
4c8b4719 | 191 | * @param int $limit |
192 | * Number to limit to (or 0 for unlimited). | |
80ad33e7 | 193 | * |
a6c01b45 CW |
194 | * @return array |
195 | * this array contains the list of members for this group id | |
6a488035 | 196 | */ |
4c8b4719 | 197 | public static function getMember($groupID, $useCache = TRUE, $limit = 0) { |
c7ef9868 | 198 | $params = array(array('group', '=', $groupID, 0, 0)); |
6a488035 | 199 | $returnProperties = array('contact_id'); |
4c8b4719 | 200 | list($contacts) = CRM_Contact_BAO_Query::apiQuery($params, $returnProperties, NULL, NULL, 0, $limit, $useCache); |
6a488035 TO |
201 | |
202 | $aMembers = array(); | |
203 | foreach ($contacts as $contact) { | |
204 | $aMembers[$contact['contact_id']] = 1; | |
205 | } | |
206 | ||
207 | return $aMembers; | |
208 | } | |
209 | ||
210 | /** | |
211 | * Returns array of group object(s) matching a set of one or Group properties. | |
212 | * | |
77c5b619 TO |
213 | * @param array $params |
214 | * Limits the set of groups returned. | |
215 | * @param array $returnProperties | |
216 | * Which properties should be included in the returned group objects. | |
3f8d2862 CW |
217 | * (member_count should be last element.) |
218 | * @param string $sort | |
219 | * @param int $offset | |
220 | * @param int $rowCount | |
80ad33e7 | 221 | * |
a6c01b45 | 222 | * @return array |
16b10e64 | 223 | * Array of group objects. |
6a488035 | 224 | * |
6a488035 TO |
225 | * |
226 | * @todo other BAO functions that use returnProperties (e.g. Query Objects) receive the array flipped & filled with 1s and | |
227 | * add in essential fields (e.g. id). This should follow a regular pattern like the others | |
228 | */ | |
2da40d21 | 229 | public static function getGroups( |
6a488035 TO |
230 | $params = NULL, |
231 | $returnProperties = NULL, | |
232 | $sort = NULL, | |
233 | $offset = NULL, | |
234 | $rowCount = NULL | |
235 | ) { | |
236 | $dao = new CRM_Contact_DAO_Group(); | |
6ce76461 CW |
237 | if (!isset($params['is_active'])) { |
238 | $dao->is_active = 1; | |
239 | } | |
6a488035 TO |
240 | if ($params) { |
241 | foreach ($params as $k => $v) { | |
242 | if ($k == 'name' || $k == 'title') { | |
243 | $dao->whereAdd($k . ' LIKE "' . CRM_Core_DAO::escapeString($v) . '"'); | |
244 | } | |
6ce76461 CW |
245 | elseif ($k == 'group_type') { |
246 | foreach ((array) $v as $type) { | |
247 | $dao->whereAdd($k . " LIKE '%" . CRM_Core_DAO::VALUE_SEPARATOR . (int) $type . CRM_Core_DAO::VALUE_SEPARATOR . "%'"); | |
248 | } | |
249 | } | |
6a488035 | 250 | elseif (is_array($v)) { |
6ce76461 CW |
251 | foreach ($v as &$num) { |
252 | $num = (int) $num; | |
253 | } | |
6a488035 TO |
254 | $dao->whereAdd($k . ' IN (' . implode(',', $v) . ')'); |
255 | } | |
256 | else { | |
257 | $dao->$k = $v; | |
258 | } | |
259 | } | |
260 | } | |
261 | ||
262 | if ($offset || $rowCount) { | |
263 | $offset = ($offset > 0) ? $offset : 0; | |
264 | $rowCount = ($rowCount > 0) ? $rowCount : 25; | |
265 | $dao->limit($offset, $rowCount); | |
266 | } | |
267 | ||
268 | if ($sort) { | |
269 | $dao->orderBy($sort); | |
270 | } | |
271 | ||
272 | // return only specific fields if returnproperties are sent | |
273 | if (!empty($returnProperties)) { | |
274 | $dao->selectAdd(); | |
275 | $dao->selectAdd(implode(',', $returnProperties)); | |
276 | } | |
277 | $dao->find(); | |
278 | ||
279 | $flag = $returnProperties && in_array('member_count', $returnProperties) ? 1 : 0; | |
280 | ||
281 | $groups = array(); | |
282 | while ($dao->fetch()) { | |
283 | $group = new CRM_Contact_DAO_Group(); | |
284 | if ($flag) { | |
285 | $dao->member_count = CRM_Contact_BAO_Group::memberCount($dao->id); | |
286 | } | |
287 | $groups[] = clone($dao); | |
288 | } | |
289 | return $groups; | |
290 | } | |
291 | ||
292 | /** | |
fe482240 | 293 | * Make sure that the user has permission to access this group. |
6a488035 | 294 | * |
77c5b619 TO |
295 | * @param int $id |
296 | * The id of the object. | |
addbec40 | 297 | * @param bool $excludeHidden |
298 | * Should hidden groups be excluded. | |
299 | * Logically this is the wrong place to filter hidden groups out as that is | |
300 | * not a permission issue. However, as other functions may rely on that defaulting to | |
301 | * FALSE for now & only the api call is calling with true. | |
6a488035 | 302 | * |
addbec40 | 303 | * @return array |
304 | * The permission that the user has (or NULL) | |
6a488035 | 305 | */ |
addbec40 | 306 | public static function checkPermission($id, $excludeHidden = FALSE) { |
307 | $allGroups = CRM_Core_PseudoConstant::allGroup(NULL, $excludeHidden); | |
6a488035 TO |
308 | |
309 | $permissions = NULL; | |
310 | if (CRM_Core_Permission::check('edit all contacts') || | |
311 | CRM_ACL_API::groupPermission(CRM_ACL_API::EDIT, $id, NULL, | |
312 | 'civicrm_saved_search', $allGroups | |
313 | ) | |
314 | ) { | |
315 | $permissions[] = CRM_Core_Permission::EDIT; | |
316 | } | |
317 | ||
318 | if (CRM_Core_Permission::check('view all contacts') || | |
319 | CRM_ACL_API::groupPermission(CRM_ACL_API::VIEW, $id, NULL, | |
320 | 'civicrm_saved_search', $allGroups | |
321 | ) | |
322 | ) { | |
323 | $permissions[] = CRM_Core_Permission::VIEW; | |
324 | } | |
325 | ||
326 | if (!empty($permissions) && CRM_Core_Permission::check('delete contacts')) { | |
327 | // Note: using !empty() in if condition, restricts the scope of delete | |
328 | // permission to groups/contacts that are editable/viewable. | |
329 | // We can remove this !empty condition once we have ACL support for delete functionality. | |
330 | $permissions[] = CRM_Core_Permission::DELETE; | |
331 | } | |
332 | ||
333 | return $permissions; | |
334 | } | |
335 | ||
336 | /** | |
fe482240 | 337 | * Create a new group. |
6a488035 | 338 | * |
77c5b619 | 339 | * @param array $params |
6a488035 | 340 | * |
72b3a70c CW |
341 | * @return CRM_Contact_BAO_Group|NULL |
342 | * The new group BAO (if created) | |
6a488035 | 343 | */ |
c3137c08 | 344 | public static function create(&$params) { |
6a488035 | 345 | |
a7488080 | 346 | if (!empty($params['id'])) { |
6a488035 TO |
347 | CRM_Utils_Hook::pre('edit', 'Group', $params['id'], $params); |
348 | } | |
349 | else { | |
350 | CRM_Utils_Hook::pre('create', 'Group', NULL, $params); | |
351 | } | |
352 | ||
353 | // form the name only if missing: CRM-627 | |
e2b7c67d | 354 | $nameParam = CRM_Utils_Array::value('name', $params, NULL); |
8cc574cf | 355 | if (!$nameParam && empty($params['id'])) { |
6a488035 TO |
356 | $params['name'] = CRM_Utils_String::titleToVar($params['title']); |
357 | } | |
358 | ||
359 | // convert params if array type | |
360 | if (isset($params['group_type'])) { | |
361 | if (is_array($params['group_type'])) { | |
362 | $params['group_type'] = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, | |
fb413e82 | 363 | CRM_Utils_Array::convertCheckboxFormatToArray($params['group_type']) |
353ffa53 | 364 | ) . CRM_Core_DAO::VALUE_SEPARATOR; |
6a488035 | 365 | } |
568fcb22 | 366 | else { |
367 | $params['group_type'] = CRM_Core_DAO::VALUE_SEPARATOR . $params['group_type'] . CRM_Core_DAO::VALUE_SEPARATOR; | |
368 | } | |
6a488035 TO |
369 | } |
370 | else { | |
82d7eb3d | 371 | $params['group_type'] = NULL; |
6a488035 TO |
372 | } |
373 | ||
481a74f4 | 374 | $session = CRM_Core_Session::singleton(); |
d0dfb649 PJ |
375 | $cid = $session->get('userID'); |
376 | // this action is add | |
377 | if ($cid && empty($params['id'])) { | |
6a488035 TO |
378 | $params['created_id'] = $cid; |
379 | } | |
d0dfb649 PJ |
380 | // this action is update |
381 | if ($cid && !empty($params['id'])) { | |
382 | $params['modified_id'] = $cid; | |
383 | } | |
6a488035 | 384 | |
d4fba42a SL |
385 | // CRM-19068. |
386 | // Validate parents parameter when creating group. | |
ec7846f5 | 387 | if (!empty($params['parents'])) { |
026e0308 FG |
388 | $parents = is_array($params['parents']) ? array_keys($params['parents']) : (array) $params['parents']; |
389 | foreach ($parents as $parent) { | |
390 | CRM_Utils_Type::validate($parent, 'Integer'); | |
d4fba42a SL |
391 | } |
392 | } | |
6a488035 TO |
393 | $group = new CRM_Contact_BAO_Group(); |
394 | $group->copyValues($params); | |
57c93d72 E |
395 | //@todo very hacky fix for the fact this function wants to receive 'parents' as an array further down but |
396 | // needs it as a separated string for the DB. Preferred approaches are having the copyParams or save fn | |
397 | // use metadata to translate the array to the appropriate DB type or altering the param in the api layer, | |
398 | // or at least altering the param in same section as 'group_type' rather than repeating here. However, further down | |
399 | // we need the $params one to be in it's original form & we are not sure what test coverage we have on that | |
22e263ad | 400 | if (isset($group->parents) && is_array($group->parents)) { |
57c93d72 | 401 | $group->parents = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, |
353ffa53 TO |
402 | array_keys($group->parents) |
403 | ) . CRM_Core_DAO::VALUE_SEPARATOR; | |
57c93d72 | 404 | } |
a7488080 | 405 | if (empty($params['id']) && |
e2b7c67d | 406 | !$nameParam |
0aab99e7 | 407 | ) { |
6a488035 TO |
408 | $group->name .= "_tmp"; |
409 | } | |
410 | $group->save(); | |
411 | ||
412 | if (!$group->id) { | |
413 | return NULL; | |
414 | } | |
415 | ||
a7488080 | 416 | if (empty($params['id']) && |
e2b7c67d | 417 | !$nameParam |
0aab99e7 | 418 | ) { |
6a488035 TO |
419 | $group->name = substr($group->name, 0, -4) . "_{$group->id}"; |
420 | } | |
421 | ||
422 | $group->buildClause(); | |
423 | $group->save(); | |
424 | ||
425 | // add custom field values | |
a7488080 | 426 | if (!empty($params['custom'])) { |
6a488035 TO |
427 | CRM_Core_BAO_CustomValueTable::store($params['custom'], 'civicrm_group', $group->id); |
428 | } | |
429 | ||
430 | // make the group, child of domain/site group by default. | |
431 | $domainGroupID = CRM_Core_BAO_Domain::getGroupId(); | |
432 | if (CRM_Utils_Array::value('no_parent', $params) !== 1) { | |
433 | if (empty($params['parents']) && | |
434 | $domainGroupID != $group->id && | |
aaffa79f | 435 | Civi::settings()->get('is_enabled') && |
6a488035 TO |
436 | !CRM_Contact_BAO_GroupNesting::hasParentGroups($group->id) |
437 | ) { | |
438 | // if no parent present and the group doesn't already have any parents, | |
439 | // make sure site group goes as parent | |
440 | $params['parents'] = array($domainGroupID => 1); | |
441 | } | |
442 | elseif (array_key_exists('parents', $params) && !is_array($params['parents'])) { | |
443 | $params['parents'] = array($params['parents'] => 1); | |
444 | } | |
445 | ||
446 | if (!empty($params['parents'])) { | |
447 | foreach ($params['parents'] as $parentId => $dnc) { | |
1069895e SL |
448 | if ($parentId && !CRM_Contact_BAO_GroupNesting::isParentChild($parentId, $group->id)) { |
449 | CRM_Contact_BAO_GroupNesting::add($parentId, $group->id); | |
6a488035 TO |
450 | } |
451 | } | |
452 | } | |
453 | ||
6a488035 TO |
454 | // this is always required, since we don't know when a |
455 | // parent group is removed | |
456 | CRM_Contact_BAO_GroupNestingCache::update(); | |
457 | ||
458 | // update group contact cache for all parent groups | |
459 | $parentIds = CRM_Contact_BAO_GroupNesting::getParentGroupIds($group->id); | |
460 | foreach ($parentIds as $parentId) { | |
461 | CRM_Contact_BAO_GroupContactCache::add($parentId); | |
462 | } | |
463 | } | |
464 | ||
a7488080 | 465 | if (!empty($params['organization_id'])) { |
6a488035 TO |
466 | $groupOrg = $params; |
467 | $groupOrg['group_id'] = $group->id; | |
468 | CRM_Contact_BAO_GroupOrganization::add($groupOrg); | |
469 | } | |
470 | ||
6d054a8e | 471 | self::flushCaches(); |
6a488035 TO |
472 | CRM_Contact_BAO_GroupContactCache::add($group->id); |
473 | ||
a7488080 | 474 | if (!empty($params['id'])) { |
6a488035 TO |
475 | CRM_Utils_Hook::post('edit', 'Group', $group->id, $group); |
476 | } | |
477 | else { | |
478 | CRM_Utils_Hook::post('create', 'Group', $group->id, $group); | |
479 | } | |
480 | ||
481 | $recentOther = array(); | |
482 | if (CRM_Core_Permission::check('edit groups')) { | |
483 | $recentOther['editUrl'] = CRM_Utils_System::url('civicrm/group', 'reset=1&action=update&id=' . $group->id); | |
484 | // currently same permission we are using for delete a group | |
485 | $recentOther['deleteUrl'] = CRM_Utils_System::url('civicrm/group', 'reset=1&action=delete&id=' . $group->id); | |
486 | } | |
487 | ||
488 | // add the recently added group (unless hidden: CRM-6432) | |
489 | if (!$group->is_hidden) { | |
490 | CRM_Utils_Recent::add($group->title, | |
491 | CRM_Utils_System::url('civicrm/group/search', 'reset=1&force=1&context=smog&gid=' . $group->id), | |
492 | $group->id, | |
493 | 'Group', | |
494 | NULL, | |
495 | NULL, | |
496 | $recentOther | |
497 | ); | |
498 | } | |
499 | return $group; | |
500 | } | |
501 | ||
502 | /** | |
100fef9d | 503 | * Given a saved search compute the clause and the tables |
6a488035 TO |
504 | * and store it for future use |
505 | */ | |
00be9182 | 506 | public function buildClause() { |
1dbdc161 | 507 | $params = array(array('group', 'IN', array($this->id), 0, 0)); |
6a488035 TO |
508 | |
509 | if (!empty($params)) { | |
510 | $tables = $whereTables = array(); | |
511 | $this->where_clause = CRM_Contact_BAO_Query::getWhereClause($params, NULL, $tables, $whereTables); | |
512 | if (!empty($tables)) { | |
513 | $this->select_tables = serialize($tables); | |
514 | } | |
515 | if (!empty($whereTables)) { | |
516 | $this->where_tables = serialize($whereTables); | |
517 | } | |
518 | } | |
6a488035 TO |
519 | } |
520 | ||
521 | /** | |
fe482240 | 522 | * Defines a new smart group. |
6a488035 | 523 | * |
77c5b619 TO |
524 | * @param array $params |
525 | * Associative array of parameters. | |
6a488035 | 526 | * |
72b3a70c CW |
527 | * @return CRM_Contact_BAO_Group|NULL |
528 | * The new group BAO (if created) | |
6a488035 TO |
529 | */ |
530 | public static function createSmartGroup(&$params) { | |
a7488080 | 531 | if (!empty($params['formValues'])) { |
6a488035 TO |
532 | $ssParams = $params; |
533 | unset($ssParams['id']); | |
534 | if (isset($ssParams['saved_search_id'])) { | |
535 | $ssParams['id'] = $ssParams['saved_search_id']; | |
536 | } | |
537 | ||
538 | $savedSearch = CRM_Contact_BAO_SavedSearch::create($params); | |
539 | ||
540 | $params['saved_search_id'] = $savedSearch->id; | |
541 | } | |
542 | else { | |
543 | return NULL; | |
544 | } | |
545 | ||
546 | return self::create($params); | |
547 | } | |
548 | ||
549 | /** | |
fe482240 | 550 | * Update the is_active flag in the db. |
6a488035 | 551 | * |
77c5b619 TO |
552 | * @param int $id |
553 | * Id of the database record. | |
554 | * @param bool $isActive | |
555 | * Value we want to set the is_active field. | |
6a488035 | 556 | * |
16b10e64 | 557 | * @return CRM_Core_DAO|null |
3f8d2862 | 558 | * DAO object on success, NULL otherwise |
6a488035 | 559 | */ |
00be9182 | 560 | public static function setIsActive($id, $isActive) { |
6a488035 TO |
561 | return CRM_Core_DAO::setFieldValue('CRM_Contact_DAO_Group', $id, 'is_active', $isActive); |
562 | } | |
563 | ||
564 | /** | |
100fef9d | 565 | * Build the condition to retrieve groups. |
6a488035 | 566 | * |
77c5b619 TO |
567 | * @param string $groupType |
568 | * Type of group(Access/Mailing) OR the key of the group. | |
3f8d2862 | 569 | * @param bool $excludeHidden exclude hidden groups. |
6a488035 | 570 | * |
a6c01b45 | 571 | * @return string |
6a488035 | 572 | */ |
00be9182 | 573 | public static function groupTypeCondition($groupType = NULL, $excludeHidden = TRUE) { |
6a488035 TO |
574 | $value = NULL; |
575 | if ($groupType == 'Mailing') { | |
576 | $value = CRM_Core_DAO::VALUE_SEPARATOR . '2' . CRM_Core_DAO::VALUE_SEPARATOR; | |
577 | } | |
578 | elseif ($groupType == 'Access') { | |
579 | $value = CRM_Core_DAO::VALUE_SEPARATOR . '1' . CRM_Core_DAO::VALUE_SEPARATOR; | |
580 | } | |
9b873358 | 581 | elseif (!empty($groupType)) { |
6a488035 TO |
582 | // ie we have been given the group key |
583 | $value = CRM_Core_DAO::VALUE_SEPARATOR . $groupType . CRM_Core_DAO::VALUE_SEPARATOR; | |
584 | } | |
585 | ||
586 | $condition = NULL; | |
587 | if ($excludeHidden) { | |
588 | $condition = "is_hidden = 0"; | |
589 | } | |
590 | ||
591 | if ($value) { | |
592 | if ($condition) { | |
593 | $condition .= " AND group_type LIKE '%$value%'"; | |
594 | } | |
595 | else { | |
596 | $condition = "group_type LIKE '%$value%'"; | |
597 | } | |
598 | } | |
599 | ||
600 | return $condition; | |
601 | } | |
602 | ||
47c89d6b | 603 | /** |
fe482240 | 604 | * Get permission relevant clauses. |
47c89d6b EM |
605 | * CRM-12209 |
606 | * | |
aaac0e0b EM |
607 | * @param bool $force |
608 | * | |
47c89d6b EM |
609 | * @return array |
610 | */ | |
aaac0e0b EM |
611 | public static function getPermissionClause($force = FALSE) { |
612 | static $clause = 1; | |
47c89d6b | 613 | static $retrieved = FALSE; |
9486be34 | 614 | if (!$retrieved || $force) { |
615 | if (CRM_Core_Permission::check('view all contacts') || CRM_Core_Permission::check('edit all contacts')) { | |
616 | $clause = 1; | |
47c89d6b | 617 | } |
aaac0e0b | 618 | else { |
9486be34 | 619 | //get the allowed groups for the current user |
620 | $groups = CRM_ACL_API::group(CRM_ACL_API::VIEW); | |
621 | if (!empty($groups)) { | |
622 | $groupList = implode(', ', array_values($groups)); | |
623 | $clause = "groups.id IN ( $groupList ) "; | |
624 | } | |
625 | else { | |
626 | $clause = '1 = 0'; | |
627 | } | |
aaac0e0b | 628 | } |
47c89d6b EM |
629 | } |
630 | $retrieved = TRUE; | |
631 | return $clause; | |
632 | } | |
633 | ||
6d054a8e | 634 | /** |
635 | * Flush caches that hold group data. | |
636 | * | |
637 | * (Actually probably some overkill at the moment.) | |
638 | */ | |
639 | protected static function flushCaches() { | |
640 | CRM_Utils_System::flushCache(); | |
641 | $staticCaches = array( | |
642 | 'CRM_Core_PseudoConstant' => 'groups', | |
643 | 'CRM_ACL_API' => 'group_permission', | |
644 | 'CRM_ACL_BAO_ACL' => 'permissioned_groups', | |
645 | ); | |
646 | foreach ($staticCaches as $class => $key) { | |
647 | if (isset(Civi::$statics[$class][$key])) { | |
648 | unset(Civi::$statics[$class][$key]); | |
649 | } | |
650 | } | |
651 | } | |
652 | ||
86538308 EM |
653 | /** |
654 | * @return string | |
655 | */ | |
6a488035 TO |
656 | public function __toString() { |
657 | return $this->title; | |
658 | } | |
659 | ||
660 | /** | |
661 | * This function create the hidden smart group when user perform | |
b44e3f84 | 662 | * contact search and want to send mailing to search contacts. |
6a488035 | 663 | * |
77c5b619 TO |
664 | * @param array $params |
665 | * ( reference ) an assoc array of name/value pairs. | |
6a488035 | 666 | * |
a6c01b45 CW |
667 | * @return array |
668 | * ( smartGroupId, ssId ) smart group id and saved search id | |
6a488035 | 669 | */ |
00be9182 | 670 | public static function createHiddenSmartGroup($params) { |
6a488035 TO |
671 | $ssId = CRM_Utils_Array::value('saved_search_id', $params); |
672 | ||
673 | //add mapping record only for search builder saved search | |
674 | $mappingId = NULL; | |
675 | if ($params['search_context'] == 'builder') { | |
676 | //save the mapping for search builder | |
677 | if (!$ssId) { | |
678 | //save record in mapping table | |
c997dfa8 TS |
679 | $mappingParams = array( |
680 | 'mapping_type_id' => CRM_Core_OptionGroup::getValue('mapping_type', | |
681 | 'Search Builder', | |
682 | 'name' | |
683 | ), | |
684 | ); | |
685 | $mapping = CRM_Core_BAO_Mapping::add($mappingParams); | |
353ffa53 | 686 | $mappingId = $mapping->id; |
6a488035 TO |
687 | } |
688 | else { | |
689 | //get the mapping id from saved search | |
690 | $savedSearch = new CRM_Contact_BAO_SavedSearch(); | |
691 | $savedSearch->id = $ssId; | |
692 | $savedSearch->find(TRUE); | |
693 | $mappingId = $savedSearch->mapping_id; | |
694 | } | |
695 | ||
696 | //save mapping fields | |
697 | CRM_Core_BAO_Mapping::saveMappingFields($params['form_values'], $mappingId); | |
698 | } | |
699 | ||
700 | //create/update saved search record. | |
701 | $savedSearch = new CRM_Contact_BAO_SavedSearch(); | |
702 | $savedSearch->id = $ssId; | |
703 | $savedSearch->form_values = serialize($params['form_values']); | |
704 | $savedSearch->mapping_id = $mappingId; | |
705 | $savedSearch->search_custom_id = CRM_Utils_Array::value('search_custom_id', $params); | |
706 | $savedSearch->save(); | |
707 | ||
708 | $ssId = $savedSearch->id; | |
709 | if (!$ssId) { | |
710 | return NULL; | |
711 | } | |
712 | ||
713 | $smartGroupId = NULL; | |
a7488080 | 714 | if (!empty($params['saved_search_id'])) { |
6a488035 TO |
715 | $smartGroupId = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Group', $ssId, 'id', 'saved_search_id'); |
716 | } | |
717 | else { | |
718 | //create group only when new saved search. | |
719 | $groupParams = array( | |
720 | 'title' => "Hidden Smart Group {$ssId}", | |
721 | 'is_active' => CRM_Utils_Array::value('is_active', $params, 1), | |
722 | 'is_hidden' => CRM_Utils_Array::value('is_hidden', $params, 1), | |
723 | 'group_type' => CRM_Utils_Array::value('group_type', $params), | |
724 | 'visibility' => CRM_Utils_Array::value('visibility', $params), | |
725 | 'saved_search_id' => $ssId, | |
726 | ); | |
727 | ||
728 | $smartGroup = self::create($groupParams); | |
729 | $smartGroupId = $smartGroup->id; | |
730 | } | |
731 | ||
c997dfa8 TS |
732 | // Update mapping with the name and description of the hidden smart group. |
733 | if ($mappingId) { | |
734 | $mappingParams = array( | |
735 | 'id' => $mappingId, | |
736 | 'name' => CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Group', $smartGroupId, 'name', 'id'), | |
737 | 'description' => CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Group', $smartGroupId, 'description', 'id'), | |
738 | 'mapping_type_id' => CRM_Core_OptionGroup::getValue('mapping_type', | |
739 | 'Search Builder', | |
740 | 'name' | |
741 | ), | |
742 | ); | |
743 | CRM_Core_BAO_Mapping::add($mappingParams); | |
744 | } | |
745 | ||
6a488035 TO |
746 | return array($smartGroupId, $ssId); |
747 | } | |
748 | ||
749 | /** | |
fe482240 | 750 | * wrapper for ajax group selector. |
6a488035 | 751 | * |
77c5b619 TO |
752 | * @param array $params |
753 | * Associated array for params record id. | |
6a488035 | 754 | * |
a6c01b45 CW |
755 | * @return array |
756 | * associated array of group list | |
16b10e64 CW |
757 | * -rp = rowcount |
758 | * -page= offset | |
d3e86119 TO |
759 | * @todo there seems little reason for the small number of functions that call this to pass in |
760 | * params that then need to be translated in this function since they are coding them when calling | |
6a488035 | 761 | */ |
bca4d720 | 762 | static public function getGroupListSelector(&$params) { |
6a488035 | 763 | // format the params |
353ffa53 | 764 | $params['offset'] = ($params['page'] - 1) * $params['rp']; |
6a488035 | 765 | $params['rowCount'] = $params['rp']; |
353ffa53 | 766 | $params['sort'] = CRM_Utils_Array::value('sortBy', $params); |
6a488035 TO |
767 | |
768 | // get groups | |
769 | $groups = CRM_Contact_BAO_Group::getGroupList($params); | |
770 | ||
771 | //skip total if we are making call to show only children | |
a7488080 | 772 | if (empty($params['parent_id'])) { |
6a488035 TO |
773 | // add total |
774 | $params['total'] = CRM_Contact_BAO_Group::getGroupCount($params); | |
775 | ||
776 | // get all the groups | |
777 | $allGroups = CRM_Core_PseudoConstant::allGroup(); | |
778 | } | |
779 | ||
780 | // format params and add links | |
781 | $groupList = array(); | |
3b448eca JL |
782 | foreach ($groups as $id => $value) { |
783 | $group = array(); | |
784 | $group['group_id'] = $value['id']; | |
785 | $group['count'] = $value['count']; | |
786 | $group['title'] = $value['title']; | |
787 | ||
788 | // append parent names if in search mode | |
789 | if (empty($params['parent_id']) && !empty($value['parents'])) { | |
790 | $group['parent_id'] = $value['parents']; | |
791 | $groupIds = explode(',', $value['parents']); | |
792 | $title = array(); | |
793 | foreach ($groupIds as $gId) { | |
794 | $title[] = $allGroups[$gId]; | |
795 | } | |
796 | $group['title'] .= '<div class="crm-row-parent-name"><em>' . ts('Child of') . '</em>: ' . implode(', ', $title) . '</div>'; | |
797 | $value['class'] = array_diff($value['class'], array('crm-row-parent')); | |
798 | } | |
799 | $group['DT_RowId'] = 'row_' . $value['id']; | |
46d33c7a | 800 | if (empty($params['parentsOnly'])) { |
fe6e4e4b | 801 | foreach ($value['class'] as $id => $class) { |
be632a8a | 802 | if ($class == 'crm-group-parent') { |
3b448eca | 803 | unset($value['class'][$id]); |
6a488035 | 804 | } |
6a488035 | 805 | } |
3b448eca JL |
806 | } |
807 | $group['DT_RowClass'] = 'crm-entity ' . implode(' ', $value['class']); | |
808 | $group['DT_RowAttr'] = array(); | |
809 | $group['DT_RowAttr']['data-id'] = $value['id']; | |
810 | $group['DT_RowAttr']['data-entity'] = 'group'; | |
6a488035 | 811 | |
3b448eca | 812 | $group['description'] = CRM_Utils_Array::value('description', $value); |
6a488035 | 813 | |
3b448eca JL |
814 | if (!empty($value['group_type'])) { |
815 | $group['group_type'] = $value['group_type']; | |
816 | } | |
817 | else { | |
818 | $group['group_type'] = ''; | |
6a488035 | 819 | } |
3b448eca JL |
820 | |
821 | $group['visibility'] = $value['visibility']; | |
822 | $group['links'] = $value['action']; | |
823 | $group['org_info'] = CRM_Utils_Array::value('org_info', $value); | |
824 | $group['created_by'] = CRM_Utils_Array::value('created_by', $value); | |
825 | ||
826 | $group['is_parent'] = $value['is_parent']; | |
827 | ||
1e223804 | 828 | array_push($groupList, $group); |
6a488035 | 829 | } |
3b448eca JL |
830 | |
831 | $groupsDT = array(); | |
832 | $groupsDT['data'] = $groupList; | |
adf9de83 TS |
833 | $groupsDT['recordsTotal'] = !empty($params['total']) ? $params['total'] : NULL; |
834 | $groupsDT['recordsFiltered'] = !empty($params['total']) ? $params['total'] : NULL; | |
3b448eca JL |
835 | |
836 | return $groupsDT; | |
6a488035 TO |
837 | } |
838 | ||
839 | /** | |
fe482240 | 840 | * This function to get list of groups. |
6a488035 | 841 | * |
77c5b619 TO |
842 | * @param array $params |
843 | * Associated array for params. | |
80ad33e7 EM |
844 | * |
845 | * @return array | |
6a488035 | 846 | */ |
00be9182 | 847 | public static function getGroupList(&$params) { |
6a488035 | 848 | $whereClause = self::whereClause($params, FALSE); |
f90c40b9 | 849 | |
adf9de83 | 850 | $limit = ""; |
6a488035 TO |
851 | if (!empty($params['rowCount']) && |
852 | $params['rowCount'] > 0 | |
853 | ) { | |
854 | $limit = " LIMIT {$params['offset']}, {$params['rowCount']} "; | |
855 | } | |
856 | ||
857 | $orderBy = ' ORDER BY groups.title asc'; | |
21d32567 DL |
858 | if (!empty($params['sort'])) { |
859 | $orderBy = ' ORDER BY ' . CRM_Utils_Type::escape($params['sort'], 'String'); | |
1d19a8f2 CW |
860 | |
861 | // CRM-16905 - Sort by count cannot be done with sql | |
862 | if (strpos($params['sort'], 'count') === 0) { | |
863 | $orderBy = $limit = ''; | |
864 | } | |
6a488035 TO |
865 | } |
866 | ||
867 | $select = $from = $where = ""; | |
868 | $groupOrg = FALSE; | |
869 | if (CRM_Core_Permission::check('administer Multiple Organizations') && | |
870 | CRM_Core_Permission::isMultisiteEnabled() | |
871 | ) { | |
872 | $select = ", contact.display_name as org_name, contact.id as org_id"; | |
873 | $from = " LEFT JOIN civicrm_group_organization gOrg | |
874 | ON gOrg.group_id = groups.id | |
875 | LEFT JOIN civicrm_contact contact | |
876 | ON contact.id = gOrg.organization_id "; | |
877 | ||
878 | //get the Organization ID | |
a3d827a7 | 879 | $orgID = CRM_Utils_Request::retrieve('oid', 'Positive'); |
6a488035 TO |
880 | if ($orgID) { |
881 | $where = " AND gOrg.organization_id = {$orgID}"; | |
882 | } | |
883 | ||
884 | $groupOrg = TRUE; | |
885 | } | |
886 | ||
887 | $query = " | |
cbe32e2f | 888 | SELECT groups.*, createdBy.sort_name as created_by {$select} |
6a488035 | 889 | FROM civicrm_group groups |
7f4b344c CW |
890 | LEFT JOIN civicrm_contact createdBy |
891 | ON createdBy.id = groups.created_id | |
892 | {$from} | |
6a488035 TO |
893 | WHERE $whereClause {$where} |
894 | {$orderBy} | |
895 | {$limit}"; | |
896 | ||
897 | $object = CRM_Core_DAO::executeQuery($query, $params, TRUE, 'CRM_Contact_DAO_Group'); | |
898 | ||
899 | //FIXME CRM-4418, now we are handling delete separately | |
900 | //if we introduce 'delete for group' make sure to handle here. | |
901 | $groupPermissions = array(CRM_Core_Permission::VIEW); | |
902 | if (CRM_Core_Permission::check('edit groups')) { | |
903 | $groupPermissions[] = CRM_Core_Permission::EDIT; | |
904 | $groupPermissions[] = CRM_Core_Permission::DELETE; | |
905 | } | |
906 | ||
907 | // CRM-9936 | |
908 | $reservedPermission = CRM_Core_Permission::check('administer reserved groups'); | |
909 | ||
910 | $links = self::actionLinks(); | |
911 | ||
912 | $allTypes = CRM_Core_OptionGroup::values('group_type'); | |
783144b0 | 913 | $values = array(); |
6a488035 | 914 | |
e3c75a92 | 915 | $visibility = CRM_Core_SelectValues::ufVisibility(); |
916 | ||
6a488035 | 917 | while ($object->fetch()) { |
6d054a8e | 918 | $newLinks = $links; |
919 | $values[$object->id] = array( | |
920 | 'class' => array(), | |
921 | 'count' => '0', | |
922 | ); | |
923 | CRM_Core_DAO::storeValues($object, $values[$object->id]); | |
924 | ||
925 | if ($object->saved_search_id) { | |
926 | $values[$object->id]['title'] .= ' (' . ts('Smart Group') . ')'; | |
927 | // check if custom search, if so fix view link | |
928 | $customSearchID = CRM_Core_DAO::getFieldValue( | |
929 | 'CRM_Contact_DAO_SavedSearch', | |
930 | $object->saved_search_id, | |
931 | 'search_custom_id' | |
cbe32e2f | 932 | ); |
6d054a8e | 933 | |
934 | if ($customSearchID) { | |
935 | $newLinks[CRM_Core_Action::VIEW]['url'] = 'civicrm/contact/search/custom'; | |
936 | $newLinks[CRM_Core_Action::VIEW]['qs'] = "reset=1&force=1&ssID={$object->saved_search_id}"; | |
6a488035 | 937 | } |
6d054a8e | 938 | } |
6a488035 | 939 | |
6d054a8e | 940 | $action = array_sum(array_keys($newLinks)); |
6a488035 | 941 | |
6d054a8e | 942 | // CRM-9936 |
943 | if (array_key_exists('is_reserved', $object)) { | |
944 | //if group is reserved and I don't have reserved permission, suppress delete/edit | |
945 | if ($object->is_reserved && !$reservedPermission) { | |
946 | $action -= CRM_Core_Action::DELETE; | |
947 | $action -= CRM_Core_Action::UPDATE; | |
948 | $action -= CRM_Core_Action::DISABLE; | |
6a488035 | 949 | } |
6d054a8e | 950 | } |
6a488035 | 951 | |
6d054a8e | 952 | if (array_key_exists('is_active', $object)) { |
953 | if ($object->is_active) { | |
954 | $action -= CRM_Core_Action::ENABLE; | |
6a488035 | 955 | } |
6d054a8e | 956 | else { |
957 | $values[$object->id]['class'][] = 'disabled'; | |
958 | $action -= CRM_Core_Action::VIEW; | |
959 | $action -= CRM_Core_Action::DISABLE; | |
960 | } | |
961 | } | |
6a488035 | 962 | |
6d054a8e | 963 | $action = $action & CRM_Core_Action::mask($groupPermissions); |
6a488035 | 964 | |
6d054a8e | 965 | $values[$object->id]['visibility'] = $visibility[$values[$object->id]['visibility']]; |
e3c75a92 | 966 | |
6d054a8e | 967 | if (isset($values[$object->id]['group_type'])) { |
968 | $groupTypes = explode(CRM_Core_DAO::VALUE_SEPARATOR, | |
969 | substr($values[$object->id]['group_type'], 1, -1) | |
6a488035 | 970 | ); |
6d054a8e | 971 | $types = array(); |
972 | foreach ($groupTypes as $type) { | |
973 | $types[] = CRM_Utils_Array::value($type, $allTypes); | |
6a488035 | 974 | } |
6d054a8e | 975 | $values[$object->id]['group_type'] = implode(', ', $types); |
976 | } | |
977 | $values[$object->id]['action'] = CRM_Core_Action::formLink($newLinks, | |
978 | $action, | |
979 | array( | |
980 | 'id' => $object->id, | |
981 | 'ssid' => $object->saved_search_id, | |
982 | ), | |
983 | ts('more'), | |
984 | FALSE, | |
985 | 'group.selector.row', | |
986 | 'Group', | |
987 | $object->id | |
988 | ); | |
6a488035 | 989 | |
6d054a8e | 990 | // If group has children, add class for link to view children |
991 | $values[$object->id]['is_parent'] = FALSE; | |
992 | if (array_key_exists('children', $values[$object->id])) { | |
993 | $values[$object->id]['class'][] = "crm-group-parent"; | |
994 | $values[$object->id]['is_parent'] = TRUE; | |
995 | } | |
6a488035 | 996 | |
6d054a8e | 997 | // If group is a child, add child class |
998 | if (array_key_exists('parents', $values[$object->id])) { | |
999 | $values[$object->id]['class'][] = "crm-group-child"; | |
1000 | } | |
1001 | ||
1002 | if ($groupOrg) { | |
1003 | if ($object->org_id) { | |
1004 | $contactUrl = CRM_Utils_System::url('civicrm/contact/view', "reset=1&cid={$object->org_id}"); | |
1005 | $values[$object->id]['org_info'] = "<a href='{$contactUrl}'>{$object->org_name}</a>"; | |
6a488035 TO |
1006 | } |
1007 | else { | |
6d054a8e | 1008 | $values[$object->id]['org_info'] = ''; // Empty cell |
6a488035 TO |
1009 | } |
1010 | } | |
6d054a8e | 1011 | else { |
1012 | $values[$object->id]['org_info'] = NULL; // Collapsed column if all cells are NULL | |
1013 | } | |
1014 | if ($object->created_id) { | |
1015 | $contactUrl = CRM_Utils_System::url('civicrm/contact/view', "reset=1&cid={$object->created_id}"); | |
1016 | $values[$object->id]['created_by'] = "<a href='{$contactUrl}'>{$object->created_by}</a>"; | |
1017 | } | |
6a488035 | 1018 | |
783144b0 | 1019 | // get group contact count using Contact.GetCount API |
1020 | $values[$object->id]['count'] = civicrm_api3('Contact', 'getcount', array('group' => $object->id)); | |
cbe32e2f CW |
1021 | } |
1022 | ||
1d19a8f2 CW |
1023 | // CRM-16905 - Sort by count cannot be done with sql |
1024 | if (!empty($params['sort']) && strpos($params['sort'], 'count') === 0) { | |
1025 | usort($values, function($a, $b) { | |
1026 | return $a['count'] - $b['count']; | |
1027 | }); | |
1028 | if (strpos($params['sort'], 'desc')) { | |
1029 | $values = array_reverse($values, TRUE); | |
1030 | } | |
1031 | return array_slice($values, $params['offset'], $params['rowCount']); | |
1032 | } | |
1033 | ||
6a488035 TO |
1034 | return $values; |
1035 | } | |
1036 | ||
1037 | /** | |
1038 | * This function to get hierarchical list of groups (parent followed by children) | |
1039 | * | |
77c5b619 TO |
1040 | * @param array $groupIDs |
1041 | * Array of group ids. | |
80ad33e7 | 1042 | * |
e60f24eb | 1043 | * @param NULL $parents |
80ad33e7 EM |
1044 | * @param string $spacer |
1045 | * @param bool $titleOnly | |
f828fa2c | 1046 | * |
80ad33e7 | 1047 | * @return array |
6a488035 | 1048 | */ |
2da40d21 | 1049 | public static function getGroupsHierarchy( |
f828fa2c | 1050 | $groupIDs, |
90d1fee5 | 1051 | $parents = NULL, |
6a488035 TO |
1052 | $spacer = '<span class="child-indent"></span>', |
1053 | $titleOnly = FALSE | |
90d1fee5 | 1054 | ) { |
f828fa2c DL |
1055 | if (empty($groupIDs)) { |
1056 | return array(); | |
1057 | } | |
1058 | ||
1059 | $groupIdString = '(' . implode(',', array_keys($groupIDs)) . ')'; | |
90d1fee5 | 1060 | // <span class="child-icon"></span> |
1061 | // need to return id, title (w/ spacer), description, visibility | |
1062 | ||
1063 | // We need to build a list of tags ordered by hierarchy and sorted by | |
b44e3f84 | 1064 | // name. The hierarchy will be communicated by an accumulation of |
90d1fee5 | 1065 | // separators in front of the name to give it a visual offset. |
1066 | // Instead of recursively making mysql queries, we'll make one big | |
b44e3f84 | 1067 | // query and build the hierarchy with the algorithm below. |
90d1fee5 | 1068 | $groups = array(); |
1069 | $args = array(1 => array($groupIdString, 'String')); | |
1070 | $query = " | |
f828fa2c DL |
1071 | SELECT id, title, description, visibility, parents |
1072 | FROM civicrm_group | |
1073 | WHERE id IN $groupIdString | |
1074 | "; | |
90d1fee5 | 1075 | if ($parents) { |
1076 | // group can have > 1 parent so parents may be comma separated list (eg. '1,2,5'). We just grab and match on 1st parent. | |
1077 | $parentArray = explode(',', $parents); | |
1078 | $parent = $parentArray[0]; | |
1079 | $args[2] = array($parent, 'Integer'); | |
1080 | $query .= " AND SUBSTRING_INDEX(parents, ',', 1) = %2"; | |
1081 | } | |
1082 | $query .= " ORDER BY title"; | |
1083 | $dao = CRM_Core_DAO::executeQuery($query, $args); | |
1084 | ||
1085 | // Sort the groups into the correct storage by the parent | |
1086 | // $roots represent the current leaf nodes that need to be checked for | |
1087 | // children. $rows represent the unplaced nodes | |
f71d7bd3 JJ |
1088 | // $tree contains the child nodes based on their parent_id. |
1089 | $roots = array(); | |
1090 | $tree = array(); | |
90d1fee5 | 1091 | while ($dao->fetch()) { |
f71d7bd3 JJ |
1092 | if ($dao->parents) { |
1093 | $parentArray = explode(',', $dao->parents); | |
1094 | $parent = $parentArray[0]; | |
1095 | $tree[$parent][] = array( | |
90d1fee5 | 1096 | 'id' => $dao->id, |
21dfd5f5 | 1097 | 'title' => $dao->title, |
f71d7bd3 JJ |
1098 | 'visibility' => $dao->visibility, |
1099 | 'description' => $dao->description, | |
90d1fee5 | 1100 | ); |
8f658465 JJ |
1101 | } |
1102 | else { | |
6bb7acc4 | 1103 | $roots[] = array( |
90d1fee5 | 1104 | 'id' => $dao->id, |
90d1fee5 | 1105 | 'title' => $dao->title, |
f71d7bd3 JJ |
1106 | 'visibility' => $dao->visibility, |
1107 | 'description' => $dao->description, | |
90d1fee5 | 1108 | ); |
1109 | } | |
1110 | } | |
1111 | $dao->free(); | |
90d1fee5 | 1112 | |
f71d7bd3 | 1113 | $hierarchy = array(); |
8f658465 | 1114 | for ($i = 0; $i < count($roots); $i++) { |
f71d7bd3 | 1115 | self::buildGroupHierarchy($hierarchy, $roots[$i], $tree, $titleOnly, $spacer, 0); |
90d1fee5 | 1116 | } |
f71d7bd3 JJ |
1117 | return $hierarchy; |
1118 | } | |
90d1fee5 | 1119 | |
f71d7bd3 JJ |
1120 | /** |
1121 | * Build a list with groups on alphabetical order and child groups after the parent group. | |
1122 | * | |
1123 | * This is a recursive function filling the $hierarchy parameter. | |
1124 | * | |
1125 | * @param $hierarchy | |
1126 | * @param $group | |
1127 | * @param $tree | |
1128 | * @param $titleOnly | |
1129 | * @param $spacer | |
1130 | * @param $level | |
1131 | */ | |
1132 | private static function buildGroupHierarchy(&$hierarchy, $group, $tree, $titleOnly, $spacer, $level) { | |
1133 | $spaces = str_repeat($spacer, $level); | |
1134 | ||
1135 | if ($titleOnly) { | |
1136 | $hierarchy[$group['id']] = $spaces . $group['title']; | |
90d1fee5 | 1137 | } |
f71d7bd3 JJ |
1138 | else { |
1139 | $hierarchy[$group['id']] = array( | |
8f658465 | 1140 | 'title' => $spaces . $group['title'], |
f71d7bd3 JJ |
1141 | 'description' => $group['description'], |
1142 | 'visibility' => $group['visibility'], | |
1143 | ); | |
90d1fee5 | 1144 | } |
1145 | ||
f71d7bd3 JJ |
1146 | // For performance reasons we use a for loop rather than a foreach. |
1147 | // Metrics for performance in an installation with 2867 groups a foreach | |
1148 | // caused the function getGroupsHierarchy with a foreach execution takes | |
1149 | // around 2.2 seoonds (2,200 ms). | |
1150 | // Changing to a for loop execustion takes around 0.02 seconds (20 ms). | |
d10c0875 JJ |
1151 | if (isset($tree[$group['id']]) && is_array($tree[$group['id']])) { |
1152 | for ($i = 0; $i < count($tree[$group['id']]); $i++) { | |
cca81cba | 1153 | self::buildGroupHierarchy($hierarchy, $tree[$group['id']][$i], $tree, $titleOnly, $spacer, $level + 1); |
d10c0875 | 1154 | } |
f71d7bd3 | 1155 | } |
6a488035 TO |
1156 | } |
1157 | ||
86538308 | 1158 | /** |
c490a46a | 1159 | * @param array $params |
86538308 | 1160 | * |
e60f24eb | 1161 | * @return NULL|string |
86538308 | 1162 | */ |
00be9182 | 1163 | public static function getGroupCount(&$params) { |
6a488035 TO |
1164 | $whereClause = self::whereClause($params, FALSE); |
1165 | $query = "SELECT COUNT(*) FROM civicrm_group groups"; | |
1166 | ||
a7488080 | 1167 | if (!empty($params['created_by'])) { |
6a488035 TO |
1168 | $query .= " |
1169 | INNER JOIN civicrm_contact createdBy | |
1170 | ON createdBy.id = groups.created_id"; | |
1171 | } | |
1172 | $query .= " | |
1173 | WHERE {$whereClause}"; | |
1174 | return CRM_Core_DAO::singleValueQuery($query, $params); | |
1175 | } | |
1176 | ||
47c89d6b | 1177 | /** |
fe482240 | 1178 | * Generate permissioned where clause for group search. |
c490a46a | 1179 | * @param array $params |
47c89d6b EM |
1180 | * @param bool $sortBy |
1181 | * @param bool $excludeHidden | |
1182 | * | |
1183 | * @return string | |
1184 | */ | |
00be9182 | 1185 | public static function whereClause(&$params, $sortBy = TRUE, $excludeHidden = TRUE) { |
6a488035 | 1186 | $values = array(); |
6a488035 TO |
1187 | $title = CRM_Utils_Array::value('title', $params); |
1188 | if ($title) { | |
1189 | $clauses[] = "groups.title LIKE %1"; | |
1190 | if (strpos($title, '%') !== FALSE) { | |
1191 | $params[1] = array($title, 'String', FALSE); | |
1192 | } | |
1193 | else { | |
1194 | $params[1] = array($title, 'String', TRUE); | |
1195 | } | |
1196 | } | |
1197 | ||
1198 | $groupType = CRM_Utils_Array::value('group_type', $params); | |
1199 | if ($groupType) { | |
1200 | $types = explode(',', $groupType); | |
1201 | if (!empty($types)) { | |
353ffa53 | 1202 | $clauses[] = 'groups.group_type LIKE %2'; |
6a488035 | 1203 | $typeString = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $types) . CRM_Core_DAO::VALUE_SEPARATOR; |
353ffa53 | 1204 | $params[2] = array($typeString, 'String', TRUE); |
6a488035 TO |
1205 | } |
1206 | } | |
1207 | ||
1208 | $visibility = CRM_Utils_Array::value('visibility', $params); | |
1209 | if ($visibility) { | |
1210 | $clauses[] = 'groups.visibility = %3'; | |
1211 | $params[3] = array($visibility, 'String'); | |
1212 | } | |
1213 | ||
1214 | $groupStatus = CRM_Utils_Array::value('status', $params); | |
1215 | if ($groupStatus) { | |
1216 | switch ($groupStatus) { | |
1217 | case 1: | |
1218 | $clauses[] = 'groups.is_active = 1'; | |
1219 | $params[4] = array($groupStatus, 'Integer'); | |
1220 | break; | |
1221 | ||
1222 | case 2: | |
1223 | $clauses[] = 'groups.is_active = 0'; | |
1224 | $params[4] = array($groupStatus, 'Integer'); | |
1225 | break; | |
1226 | ||
1227 | case 3: | |
1228 | $clauses[] = '(groups.is_active = 0 OR groups.is_active = 1 )'; | |
1229 | break; | |
1230 | } | |
1231 | } | |
1232 | ||
1233 | $parentsOnly = CRM_Utils_Array::value('parentsOnly', $params); | |
1234 | if ($parentsOnly) { | |
1235 | $clauses[] = 'groups.parents IS NULL'; | |
1236 | } | |
1237 | ||
1238 | // only show child groups of a specific parent group | |
1239 | $parent_id = CRM_Utils_Array::value('parent_id', $params); | |
1240 | if ($parent_id) { | |
1241 | $clauses[] = 'groups.id IN (SELECT child_group_id FROM civicrm_group_nesting WHERE parent_group_id = %5)'; | |
1242 | $params[5] = array($parent_id, 'Integer'); | |
1243 | } | |
1244 | ||
1245 | if ($createdBy = CRM_Utils_Array::value('created_by', $params)) { | |
1246 | $clauses[] = "createdBy.sort_name LIKE %6"; | |
1247 | if (strpos($createdBy, '%') !== FALSE) { | |
1248 | $params[6] = array($createdBy, 'String', FALSE); | |
1249 | } | |
1250 | else { | |
1251 | $params[6] = array($createdBy, 'String', TRUE); | |
1252 | } | |
1253 | } | |
1254 | ||
6a488035 TO |
1255 | if (empty($clauses)) { |
1256 | $clauses[] = 'groups.is_active = 1'; | |
1257 | } | |
1258 | ||
1259 | if ($excludeHidden) { | |
1260 | $clauses[] = 'groups.is_hidden = 0'; | |
1261 | } | |
33421d01 | 1262 | |
aaac0e0b | 1263 | $clauses[] = self::getPermissionClause(); |
6a488035 TO |
1264 | |
1265 | return implode(' AND ', $clauses); | |
1266 | } | |
1267 | ||
1268 | /** | |
fe482240 | 1269 | * Define action links. |
6a488035 | 1270 | * |
a6c01b45 CW |
1271 | * @return array |
1272 | * array of action links | |
6a488035 | 1273 | */ |
00be9182 | 1274 | public static function actionLinks() { |
6a488035 TO |
1275 | $links = array( |
1276 | CRM_Core_Action::VIEW => array( | |
1277 | 'name' => ts('Contacts'), | |
1278 | 'url' => 'civicrm/group/search', | |
1279 | 'qs' => 'reset=1&force=1&context=smog&gid=%%id%%', | |
1280 | 'title' => ts('Group Contacts'), | |
1281 | ), | |
1282 | CRM_Core_Action::UPDATE => array( | |
1283 | 'name' => ts('Settings'), | |
1284 | 'url' => 'civicrm/group', | |
1285 | 'qs' => 'reset=1&action=update&id=%%id%%', | |
1286 | 'title' => ts('Edit Group'), | |
1287 | ), | |
1288 | CRM_Core_Action::DISABLE => array( | |
1289 | 'name' => ts('Disable'), | |
4d17a233 | 1290 | 'ref' => 'crm-enable-disable', |
6a488035 TO |
1291 | 'title' => ts('Disable Group'), |
1292 | ), | |
1293 | CRM_Core_Action::ENABLE => array( | |
1294 | 'name' => ts('Enable'), | |
4d17a233 | 1295 | 'ref' => 'crm-enable-disable', |
6a488035 TO |
1296 | 'title' => ts('Enable Group'), |
1297 | ), | |
1298 | CRM_Core_Action::DELETE => array( | |
1299 | 'name' => ts('Delete'), | |
1300 | 'url' => 'civicrm/group', | |
1301 | 'qs' => 'reset=1&action=delete&id=%%id%%', | |
1302 | 'title' => ts('Delete Group'), | |
1303 | ), | |
1304 | ); | |
1305 | ||
1306 | return $links; | |
1307 | } | |
1308 | ||
86538308 EM |
1309 | /** |
1310 | * @param $whereClause | |
100fef9d | 1311 | * @param array $whereParams |
86538308 EM |
1312 | * |
1313 | * @return string | |
1314 | */ | |
00be9182 | 1315 | public function pagerAtoZ($whereClause, $whereParams) { |
6a488035 TO |
1316 | $query = " |
1317 | SELECT DISTINCT UPPER(LEFT(groups.title, 1)) as sort_name | |
1318 | FROM civicrm_group groups | |
1319 | WHERE $whereClause | |
1320 | ORDER BY LEFT(groups.title, 1) | |
1321 | "; | |
1322 | $dao = CRM_Core_DAO::executeQuery($query, $whereParams); | |
1323 | ||
1324 | return CRM_Utils_PagerAToZ::getAToZBar($dao, $this->_sortByCharacter, TRUE); | |
1325 | } | |
96025800 | 1326 | |
c955c26c SL |
1327 | /** |
1328 | * Assign Test Value. | |
1329 | * | |
1330 | * @param string $fieldName | |
1331 | * @param array $fieldDef | |
1332 | * @param int $counter | |
1333 | */ | |
1334 | protected function assignTestValue($fieldName, &$fieldDef, $counter) { | |
94183dd6 | 1335 | if ($fieldName == 'children' || $fieldName == 'parents') { |
c955c26c SL |
1336 | $this->{$fieldName} = "NULL"; |
1337 | } | |
1338 | else { | |
94183dd6 | 1339 | parent::assignTestValues($fieldName, $fieldDef, $counter); |
c955c26c SL |
1340 | } |
1341 | } | |
1342 | ||
883e1e76 | 1343 | /** |
1344 | * Get child group ids | |
1345 | * | |
783144b0 | 1346 | * @param array $regularGroupIDs |
883e1e76 | 1347 | * Parent Group IDs |
1348 | * | |
1349 | * @return array | |
1350 | */ | |
783144b0 | 1351 | public static function getChildGroupIds($regularGroupIDs) { |
1352 | $childGroupIDs = array(); | |
1353 | ||
1354 | foreach ($regularGroupIDs as $regularGroupID) { | |
1355 | // temporary store the child group ID(s) of regular group identified by $id, | |
1356 | // later merge with main child group array | |
1357 | $tempChildGroupIDs = array(); | |
1358 | // check that the regular group has any child group, if not then continue | |
1359 | if ($childrenFound = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Group', $regularGroupID, 'children')) { | |
1360 | $tempChildGroupIDs[] = $childrenFound; | |
1361 | } | |
1362 | else { | |
1363 | continue; | |
1364 | } | |
1365 | // as civicrm_group.children stores multiple group IDs in comma imploded string format, | |
1366 | // so we need to convert it into array of child group IDs first | |
1367 | $tempChildGroupIDs = explode(',', implode(',', $tempChildGroupIDs)); | |
1368 | $childGroupIDs = array_merge($childGroupIDs, $tempChildGroupIDs); | |
1369 | // recursively fetch the child group IDs | |
1370 | while (count($tempChildGroupIDs)) { | |
1371 | $tempChildGroupIDs = self::getChildGroupIds($tempChildGroupIDs); | |
1372 | if (count($tempChildGroupIDs)) { | |
1373 | $childGroupIDs = array_merge($childGroupIDs, $tempChildGroupIDs); | |
1374 | } | |
883e1e76 | 1375 | } |
1376 | } | |
1377 | ||
783144b0 | 1378 | return $childGroupIDs; |
883e1e76 | 1379 | } |
1380 | ||
6a488035 | 1381 | } |