Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
232624b1 | 4 | | CiviCRM version 4.4 | |
6a488035 TO |
5 | +--------------------------------------------------------------------+ |
6 | | Copyright CiviCRM LLC (c) 2004-2013 | | |
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 | +--------------------------------------------------------------------+ | |
26 | */ | |
27 | ||
28 | /** | |
29 | * | |
30 | * @package CRM | |
31 | * @copyright CiviCRM LLC (c) 2004-2013 | |
32 | * $Id$ | |
33 | * | |
34 | */ | |
35 | class CRM_Contact_BAO_Group extends CRM_Contact_DAO_Group { | |
36 | ||
37 | /** | |
38 | * class constructor | |
39 | */ | |
40 | function __construct() { | |
41 | parent::__construct(); | |
42 | } | |
43 | ||
44 | /** | |
45 | * Takes a bunch of params that are needed to match certain criteria and | |
46 | * retrieves the relevant objects. Typically the valid params are only | |
47 | * group_id. We'll tweak this function to be more full featured over a period | |
48 | * of time. This is the inverse function of create. It also stores all the retrieved | |
49 | * values in the default array | |
50 | * | |
51 | * @param array $params (reference ) an assoc array of name/value pairs | |
52 | * @param array $defaults (reference ) an assoc array to hold the flattened values | |
53 | * | |
54 | * @return object CRM_Contact_BAO_Group object | |
55 | * @access public | |
56 | * @static | |
57 | */ | |
58 | static function retrieve(&$params, &$defaults) { | |
59 | $group = new CRM_Contact_DAO_Group(); | |
60 | $group->copyValues($params); | |
61 | if ($group->find(TRUE)) { | |
62 | CRM_Core_DAO::storeValues($group, $defaults); | |
63 | return $group; | |
64 | } | |
65 | ||
66 | return NULL; | |
67 | } | |
68 | ||
69 | /** | |
70 | * Function to delete the group and all the object that connect to | |
71 | * this group. Incredibly destructive | |
72 | * | |
73 | * @param int $id group id | |
74 | * | |
75 | * @return null | |
76 | * @access public | |
77 | * @static | |
78 | * | |
79 | */ | |
80 | static function discard($id) { | |
81 | CRM_Utils_Hook::pre('delete', 'Group', $id, CRM_Core_DAO::$_nullArray); | |
82 | ||
83 | $transaction = new CRM_Core_Transaction(); | |
84 | ||
85 | // added for CRM-1631 and CRM-1794 | |
86 | // delete all subscribed mails with the selected group id | |
87 | $subscribe = new CRM_Mailing_Event_DAO_Subscribe(); | |
88 | $subscribe->group_id = $id; | |
89 | $subscribe->delete(); | |
90 | ||
91 | // delete all Subscription records with the selected group id | |
92 | $subHistory = new CRM_Contact_DAO_SubscriptionHistory(); | |
93 | $subHistory->group_id = $id; | |
94 | $subHistory->delete(); | |
95 | ||
96 | // delete all crm_group_contact records with the selected group id | |
97 | $groupContact = new CRM_Contact_DAO_GroupContact(); | |
98 | $groupContact->group_id = $id; | |
99 | $groupContact->delete(); | |
100 | ||
101 | // make all the 'add_to_group_id' field of 'civicrm_uf_group table', pointing to this group, as null | |
102 | $params = array(1 => array($id, 'Integer')); | |
103 | $query = "UPDATE civicrm_uf_group SET `add_to_group_id`= NULL WHERE `add_to_group_id` = %1"; | |
104 | CRM_Core_DAO::executeQuery($query, $params); | |
105 | ||
106 | $query = "UPDATE civicrm_uf_group SET `limit_listings_group_id`= NULL WHERE `limit_listings_group_id` = %1"; | |
107 | CRM_Core_DAO::executeQuery($query, $params); | |
108 | ||
109 | // make sure u delete all the entries from civicrm_mailing_group and civicrm_campaign_group | |
110 | // CRM-6186 | |
111 | $query = "DELETE FROM civicrm_mailing_group where entity_table = 'civicrm_group' AND entity_id = %1"; | |
112 | CRM_Core_DAO::executeQuery($query, $params); | |
113 | ||
114 | $query = "DELETE FROM civicrm_campaign_group where entity_table = 'civicrm_group' AND entity_id = %1"; | |
115 | CRM_Core_DAO::executeQuery($query, $params); | |
116 | ||
117 | $query = "DELETE FROM civicrm_acl_entity_role where entity_table = 'civicrm_group' AND entity_id = %1"; | |
118 | CRM_Core_DAO::executeQuery($query, $params); | |
119 | ||
120 | if (CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::MULTISITE_PREFERENCES_NAME, | |
121 | 'is_enabled' | |
122 | )) { | |
123 | // clear any descendant groups cache if exists | |
124 | $finalGroups = CRM_Core_BAO_Cache::deleteGroup('descendant groups for an org'); | |
125 | } | |
126 | ||
127 | // delete from group table | |
128 | $group = new CRM_Contact_DAO_Group(); | |
129 | $group->id = $id; | |
130 | $group->delete(); | |
131 | ||
132 | $transaction->commit(); | |
133 | ||
134 | CRM_Utils_Hook::post('delete', 'Group', $id, $group); | |
135 | ||
136 | // delete the recently created Group | |
137 | $groupRecent = array( | |
138 | 'id' => $id, | |
139 | 'type' => 'Group', | |
140 | ); | |
141 | CRM_Utils_Recent::del($groupRecent); | |
142 | } | |
143 | ||
144 | /** | |
145 | * Returns an array of the contacts in the given group. | |
146 | * | |
147 | */ | |
148 | static function getGroupContacts($id) { | |
149 | $params = array(array('group', 'IN', array($id => 1), 0, 0)); | |
150 | list($contacts, $_) = CRM_Contact_BAO_Query::apiQuery($params, array('contact_id')); | |
151 | return $contacts; | |
152 | } | |
153 | ||
154 | /** | |
155 | * Get the count of a members in a group with the specific status | |
156 | * | |
157 | * @param int $id group id | |
158 | * @param enum $status status of members in group | |
159 | * | |
160 | * @return int count of members in the group with above status | |
161 | * @access public | |
162 | */ | |
163 | static function memberCount($id, $status = 'Added', $countChildGroups = FALSE) { | |
164 | $groupContact = new CRM_Contact_DAO_GroupContact(); | |
165 | $groupIds = array($id); | |
166 | if ($countChildGroups) { | |
167 | $groupIds = CRM_Contact_BAO_GroupNesting::getDescendentGroupIds($groupIds); | |
168 | } | |
169 | $count = 0; | |
170 | ||
171 | $contacts = self::getGroupContacts($id); | |
172 | ||
173 | foreach ($groupIds as $groupId) { | |
174 | ||
175 | $groupContacts = self::getGroupContacts($groupId); | |
176 | foreach ($groupContacts as $gcontact) { | |
177 | if ($groupId != $id) { | |
178 | // Loop through main group's contacts | |
179 | // and subtract from the count for each contact which | |
180 | // matches one in the present group, if it is not the | |
181 | // main group | |
182 | foreach ($contacts as $contact) { | |
183 | if ($contact['contact_id'] == $gcontact['contact_id']) { | |
184 | $count--; | |
185 | } | |
186 | } | |
187 | } | |
188 | } | |
189 | $groupContact->group_id = $groupId; | |
190 | if (isset($status)) { | |
191 | $groupContact->status = $status; | |
192 | } | |
193 | $groupContact->_query['condition'] = 'WHERE contact_id NOT IN (SELECT id FROM civicrm_contact WHERE is_deleted = 1)'; | |
194 | $count += $groupContact->count(); | |
195 | } | |
196 | return $count; | |
197 | } | |
198 | ||
199 | /** | |
200 | * Get the list of member for a group id | |
201 | * | |
202 | * @param int $lngGroupId this is group id | |
203 | * | |
204 | * @return array $aMembers this arrray contains the list of members for this group id | |
205 | * @access public | |
206 | * @static | |
207 | */ | |
208 | static function &getMember($groupID, $useCache = TRUE) { | |
209 | $params = array(array('group', 'IN', array($groupID => 1), 0, 0)); | |
210 | $returnProperties = array('contact_id'); | |
211 | list($contacts, $_) = CRM_Contact_BAO_Query::apiQuery($params, $returnProperties, NULL, NULL, 0, 0, $useCache); | |
212 | ||
213 | $aMembers = array(); | |
214 | foreach ($contacts as $contact) { | |
215 | $aMembers[$contact['contact_id']] = 1; | |
216 | } | |
217 | ||
218 | return $aMembers; | |
219 | } | |
220 | ||
221 | /** | |
222 | * Returns array of group object(s) matching a set of one or Group properties. | |
223 | * | |
224 | * @param array $param Array of one or more valid property_name=>value pairs. | |
225 | * Limits the set of groups returned. | |
226 | * @param array $returnProperties Which properties should be included in the returned group objects. | |
227 | * (member_count should be last element.) | |
228 | * | |
229 | * @return An array of group objects. | |
230 | * | |
231 | * @access public | |
232 | * | |
233 | * @todo other BAO functions that use returnProperties (e.g. Query Objects) receive the array flipped & filled with 1s and | |
234 | * add in essential fields (e.g. id). This should follow a regular pattern like the others | |
235 | */ | |
236 | static function getGroups( | |
237 | $params = NULL, | |
238 | $returnProperties = NULL, | |
239 | $sort = NULL, | |
240 | $offset = NULL, | |
241 | $rowCount = NULL | |
242 | ) { | |
243 | $dao = new CRM_Contact_DAO_Group(); | |
6ce76461 CW |
244 | if (!isset($params['is_active'])) { |
245 | $dao->is_active = 1; | |
246 | } | |
6a488035 TO |
247 | if ($params) { |
248 | foreach ($params as $k => $v) { | |
249 | if ($k == 'name' || $k == 'title') { | |
250 | $dao->whereAdd($k . ' LIKE "' . CRM_Core_DAO::escapeString($v) . '"'); | |
251 | } | |
6ce76461 CW |
252 | elseif ($k == 'group_type') { |
253 | foreach ((array) $v as $type) { | |
254 | $dao->whereAdd($k . " LIKE '%" . CRM_Core_DAO::VALUE_SEPARATOR . (int) $type . CRM_Core_DAO::VALUE_SEPARATOR . "%'"); | |
255 | } | |
256 | } | |
6a488035 | 257 | elseif (is_array($v)) { |
6ce76461 CW |
258 | foreach ($v as &$num) { |
259 | $num = (int) $num; | |
260 | } | |
6a488035 TO |
261 | $dao->whereAdd($k . ' IN (' . implode(',', $v) . ')'); |
262 | } | |
263 | else { | |
264 | $dao->$k = $v; | |
265 | } | |
266 | } | |
267 | } | |
268 | ||
269 | if ($offset || $rowCount) { | |
270 | $offset = ($offset > 0) ? $offset : 0; | |
271 | $rowCount = ($rowCount > 0) ? $rowCount : 25; | |
272 | $dao->limit($offset, $rowCount); | |
273 | } | |
274 | ||
275 | if ($sort) { | |
276 | $dao->orderBy($sort); | |
277 | } | |
278 | ||
279 | // return only specific fields if returnproperties are sent | |
280 | if (!empty($returnProperties)) { | |
281 | $dao->selectAdd(); | |
282 | $dao->selectAdd(implode(',', $returnProperties)); | |
283 | } | |
284 | $dao->find(); | |
285 | ||
286 | $flag = $returnProperties && in_array('member_count', $returnProperties) ? 1 : 0; | |
287 | ||
288 | $groups = array(); | |
289 | while ($dao->fetch()) { | |
290 | $group = new CRM_Contact_DAO_Group(); | |
291 | if ($flag) { | |
292 | $dao->member_count = CRM_Contact_BAO_Group::memberCount($dao->id); | |
293 | } | |
294 | $groups[] = clone($dao); | |
295 | } | |
296 | return $groups; | |
297 | } | |
298 | ||
299 | /** | |
300 | * make sure that the user has permission to access this group | |
301 | * | |
302 | * @param int $id the id of the object | |
303 | * | |
304 | * @return string the permission that the user has (or null) | |
305 | * @access public | |
306 | * @static | |
307 | */ | |
308 | static function checkPermission($id) { | |
309 | $allGroups = CRM_Core_PseudoConstant::allGroup(); | |
310 | ||
311 | $permissions = NULL; | |
312 | if (CRM_Core_Permission::check('edit all contacts') || | |
313 | CRM_ACL_API::groupPermission(CRM_ACL_API::EDIT, $id, NULL, | |
314 | 'civicrm_saved_search', $allGroups | |
315 | ) | |
316 | ) { | |
317 | $permissions[] = CRM_Core_Permission::EDIT; | |
318 | } | |
319 | ||
320 | if (CRM_Core_Permission::check('view all contacts') || | |
321 | CRM_ACL_API::groupPermission(CRM_ACL_API::VIEW, $id, NULL, | |
322 | 'civicrm_saved_search', $allGroups | |
323 | ) | |
324 | ) { | |
325 | $permissions[] = CRM_Core_Permission::VIEW; | |
326 | } | |
327 | ||
328 | if (!empty($permissions) && CRM_Core_Permission::check('delete contacts')) { | |
329 | // Note: using !empty() in if condition, restricts the scope of delete | |
330 | // permission to groups/contacts that are editable/viewable. | |
331 | // We can remove this !empty condition once we have ACL support for delete functionality. | |
332 | $permissions[] = CRM_Core_Permission::DELETE; | |
333 | } | |
334 | ||
335 | return $permissions; | |
336 | } | |
337 | ||
338 | /** | |
339 | * Create a new group | |
340 | * | |
341 | * @param array $params Associative array of parameters | |
342 | * | |
343 | * @return object|null The new group BAO (if created) | |
344 | * @access public | |
345 | * @static | |
346 | */ | |
347 | public static function &create(&$params) { | |
348 | ||
349 | if (CRM_Utils_Array::value('id', $params)) { | |
350 | CRM_Utils_Hook::pre('edit', 'Group', $params['id'], $params); | |
351 | } | |
352 | else { | |
353 | CRM_Utils_Hook::pre('create', 'Group', NULL, $params); | |
354 | } | |
355 | ||
356 | // form the name only if missing: CRM-627 | |
357 | if (!CRM_Utils_Array::value('name', $params) && | |
358 | !CRM_Utils_Array::value('id', $params) | |
359 | ) { | |
360 | $params['name'] = CRM_Utils_String::titleToVar($params['title']); | |
361 | } | |
362 | ||
363 | // convert params if array type | |
364 | if (isset($params['group_type'])) { | |
365 | if (is_array($params['group_type'])) { | |
366 | $params['group_type'] = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, | |
367 | array_keys($params['group_type']) | |
368 | ) . CRM_Core_DAO::VALUE_SEPARATOR; | |
369 | } | |
370 | } | |
371 | else { | |
372 | $params['group_type'] = ''; | |
373 | } | |
374 | ||
375 | $session = CRM_Core_Session::singleton( ); | |
376 | if ($cid = $session->get('userID')) { | |
377 | $params['created_id'] = $cid; | |
378 | } | |
379 | ||
380 | $group = new CRM_Contact_BAO_Group(); | |
381 | $group->copyValues($params); | |
382 | ||
383 | if (!CRM_Utils_Array::value('id', $params)) { | |
384 | $group->name .= "_tmp"; | |
385 | } | |
386 | $group->save(); | |
387 | ||
388 | if (!$group->id) { | |
389 | return NULL; | |
390 | } | |
391 | ||
392 | if (!CRM_Utils_Array::value('id', $params)) { | |
393 | $group->name = substr($group->name, 0, -4) . "_{$group->id}"; | |
394 | } | |
395 | ||
396 | $group->buildClause(); | |
397 | $group->save(); | |
398 | ||
399 | // add custom field values | |
400 | if (CRM_Utils_Array::value('custom', $params)) { | |
401 | CRM_Core_BAO_CustomValueTable::store($params['custom'], 'civicrm_group', $group->id); | |
402 | } | |
403 | ||
404 | // make the group, child of domain/site group by default. | |
405 | $domainGroupID = CRM_Core_BAO_Domain::getGroupId(); | |
406 | if (CRM_Utils_Array::value('no_parent', $params) !== 1) { | |
407 | if (empty($params['parents']) && | |
408 | $domainGroupID != $group->id && | |
409 | CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::MULTISITE_PREFERENCES_NAME, | |
410 | 'is_enabled' | |
411 | ) && | |
412 | !CRM_Contact_BAO_GroupNesting::hasParentGroups($group->id) | |
413 | ) { | |
414 | // if no parent present and the group doesn't already have any parents, | |
415 | // make sure site group goes as parent | |
416 | $params['parents'] = array($domainGroupID => 1); | |
417 | } | |
418 | elseif (array_key_exists('parents', $params) && !is_array($params['parents'])) { | |
419 | $params['parents'] = array($params['parents'] => 1); | |
420 | } | |
421 | ||
422 | if (!empty($params['parents'])) { | |
423 | foreach ($params['parents'] as $parentId => $dnc) { | |
424 | if ($parentId && !CRM_Contact_BAO_GroupNesting::isParentChild($parentId, $group->id)) { | |
425 | CRM_Contact_BAO_GroupNesting::add($parentId, $group->id); | |
426 | } | |
427 | } | |
428 | } | |
429 | ||
430 | // clear any descendant groups cache if exists | |
431 | $finalGroups = CRM_Core_BAO_Cache::deleteGroup('descendant groups for an org'); | |
432 | ||
433 | // this is always required, since we don't know when a | |
434 | // parent group is removed | |
435 | CRM_Contact_BAO_GroupNestingCache::update(); | |
436 | ||
437 | // update group contact cache for all parent groups | |
438 | $parentIds = CRM_Contact_BAO_GroupNesting::getParentGroupIds($group->id); | |
439 | foreach ($parentIds as $parentId) { | |
440 | CRM_Contact_BAO_GroupContactCache::add($parentId); | |
441 | } | |
442 | } | |
443 | ||
444 | if (CRM_Utils_Array::value('organization_id', $params)) { | |
445 | $groupOrg = array(); | |
446 | $groupOrg = $params; | |
447 | $groupOrg['group_id'] = $group->id; | |
448 | CRM_Contact_BAO_GroupOrganization::add($groupOrg); | |
449 | } | |
450 | ||
451 | CRM_Contact_BAO_GroupContactCache::add($group->id); | |
452 | ||
453 | if (CRM_Utils_Array::value('id', $params)) { | |
454 | CRM_Utils_Hook::post('edit', 'Group', $group->id, $group); | |
455 | } | |
456 | else { | |
457 | CRM_Utils_Hook::post('create', 'Group', $group->id, $group); | |
458 | } | |
459 | ||
460 | $recentOther = array(); | |
461 | if (CRM_Core_Permission::check('edit groups')) { | |
462 | $recentOther['editUrl'] = CRM_Utils_System::url('civicrm/group', 'reset=1&action=update&id=' . $group->id); | |
463 | // currently same permission we are using for delete a group | |
464 | $recentOther['deleteUrl'] = CRM_Utils_System::url('civicrm/group', 'reset=1&action=delete&id=' . $group->id); | |
465 | } | |
466 | ||
467 | // add the recently added group (unless hidden: CRM-6432) | |
468 | if (!$group->is_hidden) { | |
469 | CRM_Utils_Recent::add($group->title, | |
470 | CRM_Utils_System::url('civicrm/group/search', 'reset=1&force=1&context=smog&gid=' . $group->id), | |
471 | $group->id, | |
472 | 'Group', | |
473 | NULL, | |
474 | NULL, | |
475 | $recentOther | |
476 | ); | |
477 | } | |
478 | return $group; | |
479 | } | |
480 | ||
481 | /** | |
482 | * given a saved search compute the clause and the tables | |
483 | * and store it for future use | |
484 | */ | |
485 | function buildClause() { | |
486 | $params = array(array('group', 'IN', array($this->id => 1), 0, 0)); | |
487 | ||
488 | if (!empty($params)) { | |
489 | $tables = $whereTables = array(); | |
490 | $this->where_clause = CRM_Contact_BAO_Query::getWhereClause($params, NULL, $tables, $whereTables); | |
491 | if (!empty($tables)) { | |
492 | $this->select_tables = serialize($tables); | |
493 | } | |
494 | if (!empty($whereTables)) { | |
495 | $this->where_tables = serialize($whereTables); | |
496 | } | |
497 | } | |
498 | ||
499 | return; | |
500 | } | |
501 | ||
502 | /** | |
503 | * Defines a new smart group | |
504 | * | |
505 | * @param array $params Associative array of parameters | |
506 | * | |
507 | * @return object|null The new group BAO (if created) | |
508 | * @access public | |
509 | * @static | |
510 | */ | |
511 | public static function createSmartGroup(&$params) { | |
512 | if (CRM_Utils_Array::value('formValues', $params)) { | |
513 | $ssParams = $params; | |
514 | unset($ssParams['id']); | |
515 | if (isset($ssParams['saved_search_id'])) { | |
516 | $ssParams['id'] = $ssParams['saved_search_id']; | |
517 | } | |
518 | ||
519 | $savedSearch = CRM_Contact_BAO_SavedSearch::create($params); | |
520 | ||
521 | $params['saved_search_id'] = $savedSearch->id; | |
522 | } | |
523 | else { | |
524 | return NULL; | |
525 | } | |
526 | ||
527 | return self::create($params); | |
528 | } | |
529 | ||
530 | /** | |
531 | * update the is_active flag in the db | |
532 | * | |
533 | * @param int $id id of the database record | |
534 | * @param boolean $isActive value we want to set the is_active field | |
535 | * | |
536 | * @return Object DAO object on sucess, null otherwise | |
537 | * @static | |
538 | */ | |
539 | static function setIsActive($id, $isActive) { | |
540 | return CRM_Core_DAO::setFieldValue('CRM_Contact_DAO_Group', $id, 'is_active', $isActive); | |
541 | } | |
542 | ||
543 | /** | |
544 | * build the condition to retrieve groups. | |
545 | * | |
546 | * @param string $groupType type of group(Access/Mailing) OR the key of the group | |
547 | * @param boolen $excludeHidden exclude hidden groups. | |
548 | * | |
549 | * @return string $condition | |
550 | * @static | |
551 | */ | |
552 | static function groupTypeCondition($groupType = NULL, $excludeHidden = TRUE) { | |
553 | $value = NULL; | |
554 | if ($groupType == 'Mailing') { | |
555 | $value = CRM_Core_DAO::VALUE_SEPARATOR . '2' . CRM_Core_DAO::VALUE_SEPARATOR; | |
556 | } | |
557 | elseif ($groupType == 'Access') { | |
558 | $value = CRM_Core_DAO::VALUE_SEPARATOR . '1' . CRM_Core_DAO::VALUE_SEPARATOR; | |
559 | } | |
560 | elseif (!empty($groupType)){ | |
561 | // ie we have been given the group key | |
562 | $value = CRM_Core_DAO::VALUE_SEPARATOR . $groupType . CRM_Core_DAO::VALUE_SEPARATOR; | |
563 | } | |
564 | ||
565 | $condition = NULL; | |
566 | if ($excludeHidden) { | |
567 | $condition = "is_hidden = 0"; | |
568 | } | |
569 | ||
570 | if ($value) { | |
571 | if ($condition) { | |
572 | $condition .= " AND group_type LIKE '%$value%'"; | |
573 | } | |
574 | else { | |
575 | $condition = "group_type LIKE '%$value%'"; | |
576 | } | |
577 | } | |
578 | ||
579 | return $condition; | |
580 | } | |
581 | ||
582 | public function __toString() { | |
583 | return $this->title; | |
584 | } | |
585 | ||
586 | /** | |
587 | * This function create the hidden smart group when user perform | |
588 | * contact seach and want to send mailing to search contacts. | |
589 | * | |
590 | * @param array $params ( reference ) an assoc array of name/value pairs | |
591 | * | |
592 | * @return array ( smartGroupId, ssId ) smart group id and saved search id | |
593 | * @access public | |
594 | * @static | |
595 | */ | |
596 | static function createHiddenSmartGroup($params) { | |
597 | $ssId = CRM_Utils_Array::value('saved_search_id', $params); | |
598 | ||
599 | //add mapping record only for search builder saved search | |
600 | $mappingId = NULL; | |
601 | if ($params['search_context'] == 'builder') { | |
602 | //save the mapping for search builder | |
603 | if (!$ssId) { | |
604 | //save record in mapping table | |
605 | $temp = array(); | |
606 | $mappingParams = array('mapping_type' => 'Search Builder'); | |
607 | $mapping = CRM_Core_BAO_Mapping::add($mappingParams, $temp); | |
608 | $mappingId = $mapping->id; | |
609 | } | |
610 | else { | |
611 | //get the mapping id from saved search | |
612 | $savedSearch = new CRM_Contact_BAO_SavedSearch(); | |
613 | $savedSearch->id = $ssId; | |
614 | $savedSearch->find(TRUE); | |
615 | $mappingId = $savedSearch->mapping_id; | |
616 | } | |
617 | ||
618 | //save mapping fields | |
619 | CRM_Core_BAO_Mapping::saveMappingFields($params['form_values'], $mappingId); | |
620 | } | |
621 | ||
622 | //create/update saved search record. | |
623 | $savedSearch = new CRM_Contact_BAO_SavedSearch(); | |
624 | $savedSearch->id = $ssId; | |
625 | $savedSearch->form_values = serialize($params['form_values']); | |
626 | $savedSearch->mapping_id = $mappingId; | |
627 | $savedSearch->search_custom_id = CRM_Utils_Array::value('search_custom_id', $params); | |
628 | $savedSearch->save(); | |
629 | ||
630 | $ssId = $savedSearch->id; | |
631 | if (!$ssId) { | |
632 | return NULL; | |
633 | } | |
634 | ||
635 | $smartGroupId = NULL; | |
636 | if (CRM_Utils_Array::value('saved_search_id', $params)) { | |
637 | $smartGroupId = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Group', $ssId, 'id', 'saved_search_id'); | |
638 | } | |
639 | else { | |
640 | //create group only when new saved search. | |
641 | $groupParams = array( | |
642 | 'title' => "Hidden Smart Group {$ssId}", | |
643 | 'is_active' => CRM_Utils_Array::value('is_active', $params, 1), | |
644 | 'is_hidden' => CRM_Utils_Array::value('is_hidden', $params, 1), | |
645 | 'group_type' => CRM_Utils_Array::value('group_type', $params), | |
646 | 'visibility' => CRM_Utils_Array::value('visibility', $params), | |
647 | 'saved_search_id' => $ssId, | |
648 | ); | |
649 | ||
650 | $smartGroup = self::create($groupParams); | |
651 | $smartGroupId = $smartGroup->id; | |
652 | } | |
653 | ||
654 | return array($smartGroupId, $ssId); | |
655 | } | |
656 | ||
657 | /** | |
658 | * This function is a wrapper for ajax group selector | |
659 | * | |
660 | * @param array $params associated array for params record id. | |
661 | * | |
662 | * @return array $groupList associated array of group list | |
663 | * @access public | |
664 | */ | |
665 | public function getGroupListSelector(&$params) { | |
666 | // format the params | |
667 | $params['offset'] = ($params['page'] - 1) * $params['rp']; | |
668 | $params['rowCount'] = $params['rp']; | |
669 | $params['sort'] = CRM_Utils_Array::value('sortBy', $params); | |
670 | ||
671 | // get groups | |
672 | $groups = CRM_Contact_BAO_Group::getGroupList($params); | |
673 | ||
674 | //skip total if we are making call to show only children | |
675 | if ( !CRM_Utils_Array::value('parent_id', $params) ) { | |
676 | // add total | |
677 | $params['total'] = CRM_Contact_BAO_Group::getGroupCount($params); | |
678 | ||
679 | // get all the groups | |
680 | $allGroups = CRM_Core_PseudoConstant::allGroup(); | |
681 | } | |
682 | ||
683 | // format params and add links | |
684 | $groupList = array(); | |
685 | if (!empty($groups)) { | |
686 | foreach ($groups as $id => $value) { | |
687 | $groupList[$id]['group_id'] = $value['id']; | |
688 | $groupList[$id]['group_name'] = $value['title']; | |
689 | $groupList[$id]['class'] = $value['class']; | |
690 | ||
691 | // append parent names if in search mode | |
692 | if ( !CRM_Utils_Array::value('parent_id', $params) && | |
693 | CRM_Utils_Array::value( 'parents', $value ) ) { | |
694 | $groupIds = explode(',', $value['parents']); | |
695 | $title = array(); | |
696 | foreach($groupIds as $gId) { | |
697 | $title[] = $allGroups[$gId]; | |
698 | } | |
699 | $groupList[$id]['group_name'] .= '<div class="crm-row-parent-name"><em>'.ts('Child of').'</em>: ' . implode(', ', $title) . '</div>'; | |
700 | $groupList[$id]['class'] = ''; | |
701 | } | |
702 | ||
703 | $groupList[$id]['group_description'] = CRM_Utils_Array::value('description', $value); | |
704 | if ( CRM_Utils_Array::value('group_type', $value) ) { | |
705 | $groupList[$id]['group_type'] = $value['group_type']; | |
706 | } | |
707 | else { | |
708 | $groupList[$id]['group_type'] = ''; | |
709 | } | |
710 | $groupList[$id]['visibility'] = $value['visibility']; | |
711 | $groupList[$id]['links'] = $value['action']; | |
712 | $groupList[$id]['org_info'] = CRM_Utils_Array::value('org_info', $value); | |
713 | $groupList[$id]['created_by'] = CRM_Utils_Array::value('created_by', $value); | |
714 | ||
715 | $groupList[$id]['is_parent'] = $value['is_parent']; | |
716 | } | |
717 | return $groupList; | |
718 | } | |
719 | } | |
720 | ||
721 | /** | |
722 | * This function to get list of groups | |
723 | * | |
724 | * @param array $params associated array for params | |
725 | * @access public | |
726 | */ | |
727 | static function getGroupList(&$params) { | |
728 | $config = CRM_Core_Config::singleton(); | |
729 | ||
730 | $whereClause = self::whereClause($params, FALSE); | |
731 | ||
732 | //$this->pagerAToZ( $whereClause, $params ); | |
733 | ||
734 | if (!empty($params['rowCount']) && | |
735 | $params['rowCount'] > 0 | |
736 | ) { | |
737 | $limit = " LIMIT {$params['offset']}, {$params['rowCount']} "; | |
738 | } | |
739 | ||
740 | $orderBy = ' ORDER BY groups.title asc'; | |
21d32567 DL |
741 | if (!empty($params['sort'])) { |
742 | $orderBy = ' ORDER BY ' . CRM_Utils_Type::escape($params['sort'], 'String'); | |
6a488035 TO |
743 | } |
744 | ||
745 | $select = $from = $where = ""; | |
746 | $groupOrg = FALSE; | |
747 | if (CRM_Core_Permission::check('administer Multiple Organizations') && | |
748 | CRM_Core_Permission::isMultisiteEnabled() | |
749 | ) { | |
750 | $select = ", contact.display_name as org_name, contact.id as org_id"; | |
751 | $from = " LEFT JOIN civicrm_group_organization gOrg | |
752 | ON gOrg.group_id = groups.id | |
753 | LEFT JOIN civicrm_contact contact | |
754 | ON contact.id = gOrg.organization_id "; | |
755 | ||
756 | //get the Organization ID | |
757 | $orgID = CRM_Utils_Request::retrieve('oid', 'Positive', CRM_Core_DAO::$_nullObject); | |
758 | if ($orgID) { | |
759 | $where = " AND gOrg.organization_id = {$orgID}"; | |
760 | } | |
761 | ||
762 | $groupOrg = TRUE; | |
763 | } | |
764 | ||
765 | $query = " | |
766 | SELECT groups.*, createdBy.sort_name as created_by {$select} | |
767 | FROM civicrm_group groups | |
768 | LEFT JOIN civicrm_contact createdBy | |
769 | ON createdBy.id = groups.created_id | |
770 | {$from} | |
771 | WHERE $whereClause {$where} | |
772 | {$orderBy} | |
773 | {$limit}"; | |
774 | ||
775 | $object = CRM_Core_DAO::executeQuery($query, $params, TRUE, 'CRM_Contact_DAO_Group'); | |
776 | ||
777 | //FIXME CRM-4418, now we are handling delete separately | |
778 | //if we introduce 'delete for group' make sure to handle here. | |
779 | $groupPermissions = array(CRM_Core_Permission::VIEW); | |
780 | if (CRM_Core_Permission::check('edit groups')) { | |
781 | $groupPermissions[] = CRM_Core_Permission::EDIT; | |
782 | $groupPermissions[] = CRM_Core_Permission::DELETE; | |
783 | } | |
784 | ||
785 | // CRM-9936 | |
786 | $reservedPermission = CRM_Core_Permission::check('administer reserved groups'); | |
787 | ||
788 | $links = self::actionLinks(); | |
789 | ||
790 | $allTypes = CRM_Core_OptionGroup::values('group_type'); | |
791 | $values = array(); | |
792 | ||
793 | while ($object->fetch()) { | |
794 | $permission = CRM_Contact_BAO_Group::checkPermission($object->id, $object->title); | |
0f8844a1 | 795 | //@todo CRM-12209 introduced an ACL check in the whereClause function |
796 | // it may be that this checking is now obsolete - or that what remains | |
797 | // should be removed to the whereClause (which is also accessed by getCount) | |
798 | ||
6a488035 TO |
799 | if ($permission) { |
800 | $newLinks = $links; | |
801 | $values[$object->id] = array(); | |
802 | CRM_Core_DAO::storeValues($object, $values[$object->id]); | |
803 | if ($object->saved_search_id) { | |
804 | $values[$object->id]['title'] .= ' (' . ts('Smart Group') . ')'; | |
805 | // check if custom search, if so fix view link | |
806 | $customSearchID = CRM_Core_DAO::getFieldValue( | |
807 | 'CRM_Contact_DAO_SavedSearch', | |
808 | $object->saved_search_id, | |
809 | 'search_custom_id' | |
810 | ); | |
811 | ||
812 | if ($customSearchID) { | |
813 | $newLinks[CRM_Core_Action::VIEW]['url'] = 'civicrm/contact/search/custom'; | |
814 | $newLinks[CRM_Core_Action::VIEW]['qs'] = "reset=1&force=1&ssID={$object->saved_search_id}"; | |
815 | } | |
816 | } | |
817 | ||
818 | $action = array_sum(array_keys($newLinks)); | |
819 | ||
820 | // CRM-9936 | |
821 | if (array_key_exists('is_reserved', $object)) { | |
822 | //if group is reserved and I don't have reserved permission, suppress delete/edit | |
823 | if ($object->is_reserved && !$reservedPermission) { | |
824 | $action -= CRM_Core_Action::DELETE; | |
825 | $action -= CRM_Core_Action::UPDATE; | |
826 | $action -= CRM_Core_Action::DISABLE; | |
827 | } | |
828 | } | |
829 | ||
830 | $values[$object->id]['class'] = ''; | |
831 | if (array_key_exists('is_active', $object)) { | |
832 | if ($object->is_active) { | |
833 | $action -= CRM_Core_Action::ENABLE; | |
834 | } | |
835 | else { | |
836 | $values[$object->id]['class'] = 'disabled'; | |
837 | $action -= CRM_Core_Action::VIEW; | |
838 | $action -= CRM_Core_Action::DISABLE; | |
839 | } | |
840 | } | |
841 | ||
842 | $action = $action & CRM_Core_Action::mask($groupPermissions); | |
843 | ||
844 | $values[$object->id]['visibility'] = CRM_Contact_DAO_Group::tsEnum('visibility', | |
845 | $values[$object->id]['visibility'] | |
846 | ); | |
847 | if (isset($values[$object->id]['group_type'])) { | |
848 | $groupTypes = explode(CRM_Core_DAO::VALUE_SEPARATOR, | |
849 | substr($values[$object->id]['group_type'], 1, -1) | |
850 | ); | |
851 | $types = array(); | |
852 | foreach ($groupTypes as $type) { | |
853 | $types[] = CRM_Utils_Array::value($type, $allTypes); | |
854 | } | |
855 | $values[$object->id]['group_type'] = implode(', ', $types); | |
856 | } | |
857 | $values[$object->id]['action'] = CRM_Core_Action::formLink($newLinks, | |
858 | $action, | |
859 | array( | |
860 | 'id' => $object->id, | |
861 | 'ssid' => $object->saved_search_id, | |
862 | ) | |
863 | ); | |
864 | ||
865 | // If group has children, add class for link to view children | |
866 | $values[$object->id]['is_parent'] = false; | |
867 | if (array_key_exists('children', $values[$object->id])) { | |
868 | $values[$object->id]['class'] = "crm-group-parent"; | |
869 | $values[$object->id]['is_parent'] = true; | |
870 | } | |
871 | ||
872 | // If group is a child, add child class | |
873 | if (array_key_exists('parents', $values[$object->id])) { | |
874 | $values[$object->id]['class'] = "crm-group-child"; | |
875 | } | |
876 | ||
877 | if (array_key_exists('children', $values[$object->id]) | |
878 | && array_key_exists('parents', $values[$object->id])) { | |
879 | $values[$object->id]['class'] = "crm-group-child crm-group-parent"; | |
880 | } | |
881 | ||
882 | if ($groupOrg) { | |
883 | if ($object->org_id) { | |
884 | $contactUrl = CRM_Utils_System::url('civicrm/contact/view', "reset=1&cid={$object->org_id}"); | |
885 | $values[$object->id]['org_info'] = "<a href='{$contactUrl}'>{$object->org_name}</a>"; | |
886 | } | |
887 | else { | |
888 | $values[$object->id]['org_info'] = ''; // Empty cell | |
889 | } | |
890 | } | |
891 | else { | |
892 | $values[$object->id]['org_info'] = NULL; // Collapsed column if all cells are NULL | |
893 | } | |
894 | if ($object->created_id) { | |
895 | $contactUrl = CRM_Utils_System::url('civicrm/contact/view', "reset=1&cid={$object->created_id}"); | |
896 | $values[$object->id]['created_by'] = "<a href='{$contactUrl}'>{$object->created_by}</a>"; | |
897 | } | |
898 | } | |
899 | } | |
900 | ||
901 | return $values; | |
902 | } | |
903 | ||
904 | /** | |
905 | * This function to get hierarchical list of groups (parent followed by children) | |
906 | * | |
f828fa2c DL |
907 | * @param array $groupIDs array of group ids |
908 | * | |
6a488035 TO |
909 | * @access public |
910 | */ | |
911 | static function getGroupsHierarchy ( | |
f828fa2c | 912 | $groupIDs, |
6a488035 TO |
913 | $parents = NULL, |
914 | $spacer = '<span class="child-indent"></span>', | |
915 | $titleOnly = FALSE | |
916 | ) { | |
f828fa2c DL |
917 | if (empty($groupIDs)) { |
918 | return array(); | |
919 | } | |
920 | ||
921 | $groupIdString = '(' . implode(',', array_keys($groupIDs)) . ')'; | |
6a488035 TO |
922 | // <span class="child-icon"></span> |
923 | // need to return id, title (w/ spacer), description, visibility | |
924 | ||
925 | // We need to build a list of tags ordered by hierarchy and sorted by | |
926 | // name. The heirarchy will be communicated by an accumulation of | |
927 | // separators in front of the name to give it a visual offset. | |
928 | // Instead of recursively making mysql queries, we'll make one big | |
929 | // query and build the heirarchy with the algorithm below. | |
930 | $groups = array(); | |
f828fa2c DL |
931 | $args = array(1 => array($groupIdString, 'String')); |
932 | $query = " | |
933 | SELECT id, title, description, visibility, parents | |
934 | FROM civicrm_group | |
935 | WHERE id IN $groupIdString | |
936 | "; | |
6a488035 TO |
937 | if ($parents) { |
938 | // group can have > 1 parent so parents may be comma separated list (eg. '1,2,5'). We just grab and match on 1st parent. | |
939 | $parentArray = explode(',', $parents); | |
940 | $parent = $parentArray[0]; | |
941 | $args[2] = array($parent, 'Integer'); | |
942 | $query .= " AND SUBSTRING_INDEX(parents, ',', 1) = %2"; | |
943 | } | |
944 | $query .= " ORDER BY title"; | |
945 | $dao = CRM_Core_DAO::executeQuery($query, $args); | |
946 | ||
947 | // Sort the groups into the correct storage by the parent | |
948 | // $roots represent the current leaf nodes that need to be checked for | |
949 | // children. $rows represent the unplaced nodes | |
950 | $roots = $rows = $allGroups = array(); | |
951 | while ($dao->fetch()) { | |
952 | $allGroups[$dao->id] = array('title' => $dao->title, | |
953 | 'visibility' => $dao->visibility, | |
954 | 'description' => $dao->description); | |
955 | ||
956 | if ($dao->parents == $parents) { | |
957 | $roots[] = array('id' => $dao->id, | |
958 | 'prefix' => '', | |
959 | 'title' => $dao->title); | |
960 | } | |
961 | else { | |
962 | // group can have > 1 parent so $dao->parents may be comma separated list (eg. '1,2,5'). Grab and match on 1st parent. | |
963 | $parentArray = explode(',', $dao->parents); | |
964 | $parent = $parentArray[0]; | |
965 | $rows[] = array('id' => $dao->id, | |
966 | 'prefix' => '', | |
967 | 'title' => $dao->title, | |
968 | 'parents' => $parent); | |
969 | } | |
970 | } | |
971 | $dao->free(); | |
972 | // While we have nodes left to build, shift the first (alphabetically) | |
973 | // node of the list, place it in our groups list and loop through the | |
974 | // list of unplaced nodes to find its children. We make a copy to | |
975 | // iterate through because we must modify the unplaced nodes list | |
976 | // during the loop. | |
977 | while (count($roots)) { | |
978 | $new_roots = array(); | |
979 | $current_rows = $rows; | |
980 | $root = array_shift($roots); | |
981 | $groups[$root['id']] = array($root['prefix'], $root['title']); | |
982 | ||
983 | // As you find the children, append them to the end of the new set | |
984 | // of roots (maintain alphabetical ordering). Also remove the node | |
985 | // from the set of unplaced nodes. | |
986 | if (is_array($current_rows)) { | |
987 | foreach ($current_rows as $key => $row) { | |
988 | if ($row['parents'] == $root['id']) { | |
989 | $new_roots[] = array('id' => $row['id'], 'prefix' => $groups[$root['id']][0] . $spacer, 'title' => $row['title']); | |
990 | unset($rows[$key]); | |
991 | } | |
992 | } | |
993 | } | |
994 | ||
995 | //As a group, insert the new roots into the beginning of the roots | |
996 | //list. This maintains the hierarchical ordering of the tags. | |
997 | $roots = array_merge($new_roots, $roots); | |
998 | } | |
999 | ||
1000 | // Prefix titles with the calcuated spacing to give the visual | |
1001 | // appearance of ordering when transformed into HTML in the form layer. Add description and visibility. | |
1002 | $groupsReturn = array(); | |
1003 | foreach ($groups as $key=>$value) { | |
1004 | if ($titleOnly) { | |
1005 | $groupsReturn[$key] = $value[0] . $value[1]; | |
1006 | } else { | |
f828fa2c DL |
1007 | $groupsReturn[$key] = array( |
1008 | 'title' => $value[0] . $value[1], | |
1009 | 'description' => $allGroups[$key]['description'], | |
1010 | 'visibility' => $allGroups[$key]['visibility'], | |
1011 | ); | |
6a488035 TO |
1012 | } |
1013 | } | |
1014 | ||
1015 | return $groupsReturn; | |
1016 | } | |
1017 | ||
1018 | static function getGroupCount(&$params) { | |
1019 | $whereClause = self::whereClause($params, FALSE); | |
1020 | $query = "SELECT COUNT(*) FROM civicrm_group groups"; | |
1021 | ||
1022 | if (CRM_Utils_Array::value('created_by', $params)) { | |
1023 | $query .= " | |
1024 | INNER JOIN civicrm_contact createdBy | |
1025 | ON createdBy.id = groups.created_id"; | |
1026 | } | |
1027 | $query .= " | |
1028 | WHERE {$whereClause}"; | |
1029 | return CRM_Core_DAO::singleValueQuery($query, $params); | |
1030 | } | |
1031 | ||
1032 | function whereClause(&$params, $sortBy = TRUE, $excludeHidden = TRUE) { | |
1033 | $values = array(); | |
1034 | $clauses = array(); | |
1035 | ||
1036 | $title = CRM_Utils_Array::value('title', $params); | |
1037 | if ($title) { | |
1038 | $clauses[] = "groups.title LIKE %1"; | |
1039 | if (strpos($title, '%') !== FALSE) { | |
1040 | $params[1] = array($title, 'String', FALSE); | |
1041 | } | |
1042 | else { | |
1043 | $params[1] = array($title, 'String', TRUE); | |
1044 | } | |
1045 | } | |
1046 | ||
1047 | $groupType = CRM_Utils_Array::value('group_type', $params); | |
1048 | if ($groupType) { | |
1049 | $types = explode(',', $groupType); | |
1050 | if (!empty($types)) { | |
1051 | $clauses[] = 'groups.group_type LIKE %2'; | |
1052 | $typeString = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $types) . CRM_Core_DAO::VALUE_SEPARATOR; | |
1053 | $params[2] = array($typeString, 'String', TRUE); | |
1054 | } | |
1055 | } | |
1056 | ||
1057 | $visibility = CRM_Utils_Array::value('visibility', $params); | |
1058 | if ($visibility) { | |
1059 | $clauses[] = 'groups.visibility = %3'; | |
1060 | $params[3] = array($visibility, 'String'); | |
1061 | } | |
1062 | ||
1063 | $groupStatus = CRM_Utils_Array::value('status', $params); | |
1064 | if ($groupStatus) { | |
1065 | switch ($groupStatus) { | |
1066 | case 1: | |
1067 | $clauses[] = 'groups.is_active = 1'; | |
1068 | $params[4] = array($groupStatus, 'Integer'); | |
1069 | break; | |
1070 | ||
1071 | case 2: | |
1072 | $clauses[] = 'groups.is_active = 0'; | |
1073 | $params[4] = array($groupStatus, 'Integer'); | |
1074 | break; | |
1075 | ||
1076 | case 3: | |
1077 | $clauses[] = '(groups.is_active = 0 OR groups.is_active = 1 )'; | |
1078 | break; | |
1079 | } | |
1080 | } | |
1081 | ||
1082 | $parentsOnly = CRM_Utils_Array::value('parentsOnly', $params); | |
1083 | if ($parentsOnly) { | |
1084 | $clauses[] = 'groups.parents IS NULL'; | |
1085 | } | |
1086 | ||
1087 | // only show child groups of a specific parent group | |
1088 | $parent_id = CRM_Utils_Array::value('parent_id', $params); | |
1089 | if ($parent_id) { | |
1090 | $clauses[] = 'groups.id IN (SELECT child_group_id FROM civicrm_group_nesting WHERE parent_group_id = %5)'; | |
1091 | $params[5] = array($parent_id, 'Integer'); | |
1092 | } | |
1093 | ||
1094 | if ($createdBy = CRM_Utils_Array::value('created_by', $params)) { | |
1095 | $clauses[] = "createdBy.sort_name LIKE %6"; | |
1096 | if (strpos($createdBy, '%') !== FALSE) { | |
1097 | $params[6] = array($createdBy, 'String', FALSE); | |
1098 | } | |
1099 | else { | |
1100 | $params[6] = array($createdBy, 'String', TRUE); | |
1101 | } | |
1102 | } | |
1103 | ||
1104 | /* | |
1105 | if ( $sortBy && | |
1106 | $this->_sortByCharacter !== null ) { | |
1107 | $clauses[] = | |
1108 | "groups.title LIKE '" . | |
1109 | strtolower(CRM_Core_DAO::escapeWildCardString($this->_sortByCharacter)) . | |
1110 | "%'"; | |
1111 | } | |
1112 | ||
1113 | // dont do a the below assignement when doing a | |
1114 | // AtoZ pager clause | |
1115 | if ( $sortBy ) { | |
1116 | if ( count( $clauses ) > 1 ) { | |
1117 | $this->assign( 'isSearch', 1 ); | |
1118 | } else { | |
1119 | $this->assign( 'isSearch', 0 ); | |
1120 | } | |
1121 | } | |
1122 | */ | |
1123 | ||
1124 | ||
1125 | if (empty($clauses)) { | |
1126 | $clauses[] = 'groups.is_active = 1'; | |
1127 | } | |
1128 | ||
1129 | if ($excludeHidden) { | |
1130 | $clauses[] = 'groups.is_hidden = 0'; | |
1131 | } | |
0f8844a1 | 1132 | //CRM-12209 |
1133 | if (!CRM_Core_Permission::check('view all contacts')) { | |
1134 | //get the allowed groups for the current user | |
1135 | $groups = CRM_ACL_API::group(CRM_ACL_API::VIEW); | |
1136 | if (!empty( $groups)) { | |
1137 | $groupList = implode( ', ', array_values( $groups ) ); | |
1138 | $clauses[] = "groups.id IN ( $groupList ) "; | |
1139 | } | |
1140 | } | |
6a488035 TO |
1141 | |
1142 | return implode(' AND ', $clauses); | |
1143 | } | |
1144 | ||
1145 | /** | |
1146 | * Function to define action links | |
1147 | * | |
1148 | * @return array $links array of action links | |
1149 | * @access public | |
1150 | */ | |
1151 | static function actionLinks() { | |
1152 | $links = array( | |
1153 | CRM_Core_Action::VIEW => array( | |
1154 | 'name' => ts('Contacts'), | |
1155 | 'url' => 'civicrm/group/search', | |
1156 | 'qs' => 'reset=1&force=1&context=smog&gid=%%id%%', | |
1157 | 'title' => ts('Group Contacts'), | |
1158 | ), | |
1159 | CRM_Core_Action::UPDATE => array( | |
1160 | 'name' => ts('Settings'), | |
1161 | 'url' => 'civicrm/group', | |
1162 | 'qs' => 'reset=1&action=update&id=%%id%%', | |
1163 | 'title' => ts('Edit Group'), | |
1164 | ), | |
1165 | CRM_Core_Action::DISABLE => array( | |
1166 | 'name' => ts('Disable'), | |
1167 | 'extra' => 'onclick = "enableDisable( %%id%%,\'' . 'CRM_Contact_BAO_Group' . '\',\'' . 'enable-disable' . '\' );"', | |
1168 | 'ref' => 'disable-action', | |
1169 | 'title' => ts('Disable Group'), | |
1170 | ), | |
1171 | CRM_Core_Action::ENABLE => array( | |
1172 | 'name' => ts('Enable'), | |
1173 | 'extra' => 'onclick = "enableDisable( %%id%%,\'' . 'CRM_Contact_BAO_Group' . '\',\'' . 'disable-enable' . '\' );"', | |
1174 | 'ref' => 'enable-action', | |
1175 | 'title' => ts('Enable Group'), | |
1176 | ), | |
1177 | CRM_Core_Action::DELETE => array( | |
1178 | 'name' => ts('Delete'), | |
1179 | 'url' => 'civicrm/group', | |
1180 | 'qs' => 'reset=1&action=delete&id=%%id%%', | |
1181 | 'title' => ts('Delete Group'), | |
1182 | ), | |
1183 | ); | |
1184 | ||
1185 | return $links; | |
1186 | } | |
1187 | ||
1188 | function pagerAtoZ($whereClause, $whereParams) { | |
1189 | $query = " | |
1190 | SELECT DISTINCT UPPER(LEFT(groups.title, 1)) as sort_name | |
1191 | FROM civicrm_group groups | |
1192 | WHERE $whereClause | |
1193 | ORDER BY LEFT(groups.title, 1) | |
1194 | "; | |
1195 | $dao = CRM_Core_DAO::executeQuery($query, $whereParams); | |
1196 | ||
1197 | return CRM_Utils_PagerAToZ::getAToZBar($dao, $this->_sortByCharacter, TRUE); | |
1198 | } | |
1199 | } | |
1200 |