3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2015 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2015
33 class CRM_Core_BAO_Navigation
extends CRM_Core_DAO_Navigation
{
35 // Number of characters in the menu js cache key
36 const CACHE_KEY_STRLEN
= 8;
41 public function __construct() {
42 parent
::__construct();
46 * Update the is_active flag in the db.
49 * Id of the database record.
50 * @param bool $is_active
51 * Value we want to set the is_active field.
53 * @return CRM_Core_DAO_Navigation|NULL
54 * DAO object on success, NULL otherwise
56 public static function setIsActive($id, $is_active) {
57 return CRM_Core_DAO
::setFieldValue('CRM_Core_DAO_Navigation', $id, 'is_active', $is_active);
61 * Get existing / build navigation for CiviCRM Admin Menu.
66 public static function getMenus() {
69 $menu = new CRM_Core_DAO_Menu();
70 $menu->domain_id
= CRM_Core_Config
::domainID();
73 while ($menu->fetch()) {
75 $menus[$menu->path
] = $menu->title
;
82 * Add/update navigation record.
84 * @param array $params Submitted values
86 * @return CRM_Core_DAO_Navigation
89 public static function add(&$params) {
90 $navigation = new CRM_Core_DAO_Navigation();
91 if (empty($params['id'])) {
92 $params['is_active'] = CRM_Utils_Array
::value('is_active', $params, FALSE);
93 $params['has_separator'] = CRM_Utils_Array
::value('has_separator', $params, FALSE);
96 if (!isset($params['id']) ||
97 (CRM_Utils_Array
::value('parent_id', $params) != CRM_Utils_Array
::value('current_parent_id', $params))
99 /* re/calculate the weight, if the Parent ID changed OR create new menu */
101 if ($navName = CRM_Utils_Array
::value('name', $params)) {
102 $params['name'] = $navName;
104 elseif ($navLabel = CRM_Utils_Array
::value('label', $params)) {
105 $params['name'] = $navLabel;
108 $params['weight'] = self
::calculateWeight(CRM_Utils_Array
::value('parent_id', $params));
111 if (array_key_exists('permission', $params) && is_array($params['permission'])) {
112 $params['permission'] = implode(',', $params['permission']);
115 $navigation->copyValues($params);
117 $navigation->domain_id
= CRM_Core_Config
::domainID();
124 * Fetch object based on array of properties.
126 * @param array $params
127 * (reference ) an assoc array of name/value pairs.
128 * @param array $defaults
129 * (reference ) an assoc array to hold the flattened values.
131 * @return CRM_Core_BAO_Navigation|null
132 * object on success, NULL otherwise
134 public static function retrieve(&$params, &$defaults) {
135 $navigation = new CRM_Core_DAO_Navigation();
136 $navigation->copyValues($params);
138 $navigation->domain_id
= CRM_Core_Config
::domainID();
140 if ($navigation->find(TRUE)) {
141 CRM_Core_DAO
::storeValues($navigation, $defaults);
148 * Calculate navigation weight.
150 * @param int $parentID
151 * Parent_id of a menu.
158 public static function calculateWeight($parentID = NULL, $menuID = NULL) {
159 $domainID = CRM_Core_Config
::domainID();
162 // we reset weight for each parent, i.e we start from 1 to n
163 // calculate max weight for top level menus, if parent id is absent
165 $query = "SELECT max(weight) as weight FROM civicrm_navigation WHERE parent_id IS NULL AND domain_id = $domainID";
168 // if parent is passed, we need to get max weight for that particular parent
169 $query = "SELECT max(weight) as weight FROM civicrm_navigation WHERE parent_id = {$parentID} AND domain_id = $domainID";
172 $dao = CRM_Core_DAO
::executeQuery($query);
174 return $weight = $weight +
$dao->weight
;
178 * Get formatted menu list.
181 * returns associated array
183 public static function getNavigationList() {
184 $cacheKeyString = "navigationList";
187 $config = CRM_Core_Config
::singleton();
189 // check if we can retrieve from database cache
190 $navigations = CRM_Core_BAO_Cache
::getItem('navigation', $cacheKeyString);
193 $domainID = CRM_Core_Config
::domainID();
195 SELECT id, label, parent_id, weight, is_active, name
196 FROM civicrm_navigation WHERE domain_id = $domainID {$whereClause} ORDER BY parent_id, weight ASC";
197 $result = CRM_Core_DAO
::executeQuery($query);
199 $pidGroups = array();
200 while ($result->fetch()) {
201 $pidGroups[$result->parent_id
][$result->label
] = $result->id
;
204 foreach ($pidGroups[''] as $label => $val) {
205 $pidGroups[''][$label] = self
::_getNavigationValue($val, $pidGroups);
208 $navigations = array();
209 self
::_getNavigationLabel($pidGroups[''], $navigations);
211 CRM_Core_BAO_Cache
::setItem($navigations, 'navigation', $cacheKeyString);
217 * Helper function for getNavigationList().
221 * @param array $navigations
223 * @param string $separator
226 public static function _getNavigationLabel($list, &$navigations, $separator = '') {
227 $i18n = CRM_Core_I18n
::singleton();
228 foreach ($list as $label => $val) {
229 if ($label == 'navigation_id') {
232 $translatedLabel = $i18n->crm_translate($label, array('context' => 'menu'));
233 $navigations[is_array($val) ?
$val['navigation_id'] : $val] = "{$separator}{$translatedLabel}";
234 if (is_array($val)) {
235 self
::_getNavigationLabel($val, $navigations, $separator . ' ');
241 * Helper function for getNavigationList().
245 * @param array $pidGroups
250 public static function _getNavigationValue($val, &$pidGroups) {
251 if (array_key_exists($val, $pidGroups)) {
252 $list = array('navigation_id' => $val);
253 foreach ($pidGroups[$val] as $label => $id) {
254 $list[$label] = self
::_getNavigationValue($id, $pidGroups);
256 unset($pidGroups[$val]);
265 * Build navigation tree.
267 * @param array $navigationTree
268 * Nested array of menus.
269 * @param int $parentID
271 * @param bool $navigationMenu
272 * True when called for building top navigation menu.
275 * nested array of menus
277 public static function buildNavigationTree(&$navigationTree, $parentID, $navigationMenu = TRUE) {
278 $whereClause = " parent_id IS NULL";
281 $whereClause = " parent_id = {$parentID}";
284 $domainID = CRM_Core_Config
::domainID();
286 // get the list of menus
288 SELECT id, label, url, permission, permission_operator, has_separator, parent_id, is_active, name
289 FROM civicrm_navigation
291 AND domain_id = $domainID
292 ORDER BY parent_id, weight";
294 $navigation = CRM_Core_DAO
::executeQuery($query);
295 $config = CRM_Core_Config
::singleton();
296 while ($navigation->fetch()) {
297 $label = $navigation->label
;
298 if (!$navigationMenu) {
299 $label = addcslashes($label, '"');
302 // for each menu get their children
303 $navigationTree[$navigation->id
] = array(
304 'attributes' => array(
306 'name' => $navigation->name
,
307 'url' => $navigation->url
,
308 'permission' => $navigation->permission
,
309 'operator' => $navigation->permission_operator
,
310 'separator' => $navigation->has_separator
,
311 'parentID' => $navigation->parent_id
,
312 'navID' => $navigation->id
,
313 'active' => $navigation->is_active
,
316 self
::buildNavigationTree($navigationTree[$navigation->id
]['child'], $navigation->id
, $navigationMenu);
319 return $navigationTree;
326 * By default output is html.
327 * @param bool $navigationMenu
328 * True when called for building top navigation menu.
331 * html or json string
333 public static function buildNavigation($json = FALSE, $navigationMenu = TRUE) {
334 $navigations = array();
335 self
::buildNavigationTree($navigations, $parent = NULL, $navigationMenu);
336 $navigationString = NULL;
338 // run the Navigation through a hook so users can modify it
339 CRM_Utils_Hook
::navigationMenu($navigations);
341 $i18n = CRM_Core_I18n
::singleton();
343 //skip children menu item if user don't have access to parent menu item
344 $skipMenuItems = array();
345 foreach ($navigations as $key => $value) {
347 if ($navigationString) {
348 $navigationString .= '},';
350 $data = $value['attributes']['label'];
352 if (!$value['attributes']['active']) {
353 $class = ', "attr": { "class" : "disabled"} ';
355 $l10nName = $i18n->crm_translate($data, array('context' => 'menu'));
356 $navigationString .= ' { "attr": { "id" : "node_' . $key . '"}, "data": { "title":"' . $l10nName . '"' . $class . '}';
359 // Home is a special case
360 if ($value['attributes']['name'] != 'Home') {
361 $name = self
::getMenuName($value, $skipMenuItems);
364 if (isset($value['attributes']['separator']) && $value['attributes']['separator'] == 2) {
365 $navigationString .= '<li class="menu-separator"></li>';
367 $removeCharacters = array('/', '!', '&', '*', ' ', '(', ')', '.');
368 $navigationString .= '<li class="menumain crm-' . str_replace($removeCharacters, '_', $value['attributes']['label']) . '">' . $name;
373 self
::recurseNavigation($value, $navigationString, $json, $skipMenuItems);
377 $navigationString = '[' . $navigationString . '}]';
380 // clean up - Need to remove empty <ul>'s, this happens when user don't have
381 // permission to access parent
382 $navigationString = str_replace('<ul></ul></li>', '', $navigationString);
385 return $navigationString;
389 * Recursively check child menus.
391 * @param array $value
392 * @param string $navigationString
394 * @param bool $skipMenuItems
398 public static function recurseNavigation(&$value, &$navigationString, $json, $skipMenuItems) {
400 if (!empty($value['child'])) {
401 $navigationString .= ', "children": [ ';
404 return $navigationString;
407 if (!empty($value['child'])) {
410 foreach ($value['child'] as $k => $val) {
411 if ($count == count($value['child'])) {
412 $appendComma = FALSE;
414 $data = $val['attributes']['label'];
416 if (!$val['attributes']['active']) {
417 $class = ', "attr": { "class" : "disabled"} ';
419 $navigationString .= ' { "attr": { "id" : "node_' . $k . '"}, "data": { "title":"' . $data . '"' . $class . '}';
420 self
::recurseNavigation($val, $navigationString, $json, $skipMenuItems);
421 $navigationString .= $appendComma ?
' },' : ' }';
426 if (!empty($value['child'])) {
427 $navigationString .= ' ]';
431 if (!empty($value['child'])) {
432 $navigationString .= '<ul>';
435 $navigationString .= '</li>';
436 //locate separator after
437 if (isset($value['attributes']['separator']) && $value['attributes']['separator'] == 1) {
438 $navigationString .= '<li class="menu-separator"></li>';
442 if (!empty($value['child'])) {
443 foreach ($value['child'] as $val) {
444 $name = self
::getMenuName($val, $skipMenuItems);
446 //locate separator before
447 if (isset($val['attributes']['separator']) && $val['attributes']['separator'] == 2) {
448 $navigationString .= '<li class="menu-separator"></li>';
450 $removeCharacters = array('/', '!', '&', '*', ' ', '(', ')', '.');
451 $navigationString .= '<li class="crm-' . str_replace($removeCharacters, '_', $val['attributes']['label']) . '">' . $name;
452 self
::recurseNavigation($val, $navigationString, $json, $skipMenuItems);
456 if (!empty($value['child'])) {
457 $navigationString .= '</ul></li>';
458 if (isset($value['attributes']['separator']) && $value['attributes']['separator'] == 1) {
459 $navigationString .= '<li class="menu-separator"></li>';
463 return $navigationString;
470 * @param array $skipMenuItems
472 * @return bool|string
474 public static function getMenuName(&$value, &$skipMenuItems) {
475 // we need to localise the menu labels (CRM-5456) and don’t
476 // want to use ts() as it would throw the ts-extractor off
477 $i18n = CRM_Core_I18n
::singleton();
479 $name = $i18n->crm_translate($value['attributes']['label'], array('context' => 'menu'));
480 $url = CRM_Utils_Array
::value('url', $value['attributes']);
481 $permission = CRM_Utils_Array
::value('permission', $value['attributes']);
482 $operator = CRM_Utils_Array
::value('operator', $value['attributes']);
483 $parentID = CRM_Utils_Array
::value('parentID', $value['attributes']);
484 $navID = CRM_Utils_Array
::value('navID', $value['attributes']);
485 $active = CRM_Utils_Array
::value('active', $value['attributes']);
486 $menuName = CRM_Utils_Array
::value('name', $value['attributes']);
487 $target = CRM_Utils_Array
::value('target', $value['attributes']);
489 if (in_array($parentID, $skipMenuItems) ||
!$active) {
490 $skipMenuItems[] = $navID;
494 //we need to check core view/edit or supported acls.
495 if (in_array($menuName, array(
499 if (!CRM_Core_Permission
::giveMeAllACLs()) {
500 $skipMenuItems[] = $navID;
505 $config = CRM_Core_Config
::singleton();
508 if (isset($url) && $url) {
509 if (substr($url, 0, 4) !== 'http') {
510 //CRM-7656 --make sure to separate out url path from url params,
511 //as we'r going to validate url path across cross-site scripting.
512 $urlParam = explode('?', $url);
513 if (empty($urlParam[1])) {
516 $url = CRM_Utils_System
::url($urlParam[0], $urlParam[1], FALSE, NULL, TRUE);
521 static $allComponents;
522 if (!$allComponents) {
523 $allComponents = CRM_Core_Component
::getNames();
526 if (isset($permission) && $permission) {
527 $permissions = explode(',', $permission);
529 $hasPermission = FALSE;
530 foreach ($permissions as $key) {
534 //get the component name from permission.
535 $componentName = CRM_Core_Permission
::getComponentName($key);
537 if ($componentName) {
538 if (!in_array($componentName, $config->enableComponents
) ||
539 !CRM_Core_Permission
::check($key)
542 if ($operator == 'AND') {
543 $skipMenuItems[] = $navID;
548 $hasPermission = TRUE;
551 elseif (!CRM_Core_Permission
::check($key)) {
553 if ($operator == 'AND') {
554 $skipMenuItems[] = $navID;
559 $hasPermission = TRUE;
563 if (!$showItem && !$hasPermission) {
564 $skipMenuItems[] = $navID;
571 $name = "<a href=\"{$url}\" target=\"{$target}\">{$name}</a>";
574 $name = "<a href=\"{$url}\">{$name}</a>";
582 * Create navigation for CiviCRM Admin Menu.
584 * @param int $contactID
588 * returns navigation html
590 public static function createNavigation($contactID) {
591 $config = CRM_Core_Config
::singleton();
593 $navigation = self
::buildNavigation();
597 //add additional navigation items
598 $logoutURL = CRM_Utils_System
::url('civicrm/logout', 'reset=1');
600 // get home menu from db
601 $homeParams = array('name' => 'Home');
603 $homeIcon = '<span class="crm-logo-sm" ></span>';
604 self
::retrieve($homeParams, $homeNav);
606 list($path, $q) = explode('?', $homeNav['url']);
607 $homeURL = CRM_Utils_System
::url($path, $q);
608 $homeLabel = $homeNav['label'];
609 // CRM-6804 (we need to special-case this as we don’t ts()-tag variables)
610 if ($homeLabel == 'Home') {
611 $homeLabel = ts('CiviCRM Home');
615 $homeURL = CRM_Utils_System
::url('civicrm/dashboard', 'reset=1');
616 $homeLabel = ts('CiviCRM Home');
618 // Link to hide the menubar
619 $hideLabel = ts('Hide Menu');
622 <li class='menumain crm-link-home'>$homeIcon
623 <ul id='civicrm-home'>
624 <li><a href='$homeURL'>$homeLabel</a></li>
625 <li><a href='#' class='crm-hidemenu'>$hideLabel</a></li>
626 <li><a href='$logoutURL' class='crm-logout-link'>" . ts('Log out') . "</a></li>
628 // <li> tag doesn't need to be closed
630 return $prepandString . $navigation;
634 * Reset navigation for all contacts or a specified contact.
636 * @param int $contactID
637 * Reset only entries belonging to that contact ID.
641 public static function resetNavigation($contactID = NULL) {
642 $newKey = CRM_Utils_String
::createRandom(self
::CACHE_KEY_STRLEN
, CRM_Utils_String
::ALPHANUMERIC
);
644 $query = "UPDATE civicrm_setting SET value = '$newKey' WHERE name='navigation' AND contact_id IS NOT NULL";
645 CRM_Core_DAO
::executeQuery($query);
646 CRM_Core_BAO_Cache
::deleteGroup('navigation');
649 // before inserting check if contact id exists in db
650 // this is to handle weird case when contact id is in session but not in db
651 $contact = new CRM_Contact_DAO_Contact();
652 $contact->id
= $contactID;
653 if ($contact->find(TRUE)) {
654 CRM_Core_BAO_Setting
::setItem(
656 CRM_Core_BAO_Setting
::PERSONAL_PREFERENCES_NAME
,
664 // also reset the dashlet cache in case permissions have changed etc
665 // FIXME: decouple this
666 CRM_Core_BAO_Dashboard
::resetDashletCache($contactID);
672 * Process navigation.
674 * @param array $params
675 * Associated array, $_GET.
677 public static function processNavigation(&$params) {
678 $nodeID = (int) str_replace("node_", "", $params['id']);
679 $referenceID = (int) str_replace("node_", "", $params['ref_id']);
680 $position = $params['ps'];
681 $type = $params['type'];
682 $label = CRM_Utils_Array
::value('data', $params);
686 self
::processMove($nodeID, $referenceID, $position);
690 self
::processRename($nodeID, $label);
694 self
::processDelete($nodeID);
698 //reset navigation menus
699 self
::resetNavigation();
700 CRM_Utils_System
::civiExit();
704 * Process move action.
707 * Node that is being moved.
708 * @param $referenceID
709 * Parent id where node is moved. 0 mean no parent.
711 * New position of the nod, it starts with 0 - n.
713 public static function processMove($nodeID, $referenceID, $position) {
714 // based on the new position we need to get the weight of the node after moved node
715 // 1. update the weight of $position + 1 nodes to weight + 1
716 // 2. weight of the ( $position -1 ) node - 1 is the new weight of the node being moved
718 // check if there is parent id, which means node is moved inside existing parent container, so use parent id
719 // to find the correct position else use NULL to get the weights of parent ( $position - 1 )
720 // accordingly set the new parent_id
722 $newParentID = $referenceID;
723 $parentClause = "parent_id = {$referenceID} ";
726 $newParentID = 'NULL';
727 $parentClause = 'parent_id IS NULL';
730 $incrementOtherNodes = TRUE;
731 $sql = "SELECT weight from civicrm_navigation WHERE {$parentClause} ORDER BY weight LIMIT %1, 1";
732 $params = array(1 => array($position, 'Positive'));
733 $newWeight = CRM_Core_DAO
::singleValueQuery($sql, $params);
735 // this means node is moved to last position, so you need to get the weight of last element + 1
737 // If this is not the first item being added to a parent
739 $lastPosition = $position - 1;
740 $sql = "SELECT weight from civicrm_navigation WHERE {$parentClause} ORDER BY weight LIMIT %1, 1";
741 $params = array(1 => array($lastPosition, 'Positive'));
742 $newWeight = CRM_Core_DAO
::singleValueQuery($sql, $params);
744 // since last node increment + 1
745 $newWeight = $newWeight +
1;
751 // since this is a last node we don't need to increment other nodes
752 $incrementOtherNodes = FALSE;
755 $transaction = new CRM_Core_Transaction();
757 // now update the existing nodes to weight + 1, if required.
758 if ($incrementOtherNodes) {
759 $query = "UPDATE civicrm_navigation SET weight = weight + 1
760 WHERE {$parentClause} AND weight >= {$newWeight}";
762 CRM_Core_DAO
::executeQuery($query);
765 // finally set the weight of current node
766 $query = "UPDATE civicrm_navigation SET weight = {$newWeight}, parent_id = {$newParentID} WHERE id = {$nodeID}";
767 CRM_Core_DAO
::executeQuery($query);
769 $transaction->commit();
773 * Function to process rename action for tree.
778 public static function processRename($nodeID, $label) {
779 CRM_Core_DAO
::setFieldValue('CRM_Core_DAO_Navigation', $nodeID, 'label', $label);
783 * Process delete action for tree.
787 public static function processDelete($nodeID) {
788 $query = "DELETE FROM civicrm_navigation WHERE id = {$nodeID}";
789 CRM_Core_DAO
::executeQuery($query);
793 * Get the info on navigation item.
795 * @param int $navigationID
801 public static function getNavigationInfo($navigationID) {
802 $query = "SELECT parent_id, weight FROM civicrm_navigation WHERE id = %1";
803 $params = array($navigationID, 'Integer');
804 $dao = CRM_Core_DAO
::executeQuery($query, array(1 => $params));
807 'parent_id' => $dao->parent_id
,
808 'weight' => $dao->weight
,
815 * @param array $params
816 * @param array $newParams
817 * New value of params.
819 public static function processUpdate($params, $newParams) {
820 $dao = new CRM_Core_DAO_Navigation();
821 $dao->copyValues($params);
822 if ($dao->find(TRUE)) {
823 $dao->copyValues($newParams);
829 * Rebuild reports menu.
831 * All Contact reports will become sub-items of 'Contact Reports' and so on.
833 * @param int $domain_id
835 public static function rebuildReportsNavigation($domain_id) {
836 $component_to_nav_name = array(
837 'CiviContact' => 'Contact Reports',
838 'CiviContribute' => 'Contribution Reports',
839 'CiviMember' => 'Membership Reports',
840 'CiviEvent' => 'Event Reports',
841 'CiviPledge' => 'Pledge Reports',
842 'CiviGrant' => 'Grant Reports',
843 'CiviMail' => 'Mailing Reports',
844 'CiviCampaign' => 'Campaign Reports',
847 // Create or update the top level Reports link.
848 $reports_nav = self
::createOrUpdateTopLevelReportsNavItem($domain_id);
850 // Get all active report instances grouped by component.
851 $components = self
::getAllActiveReportsByComponent($domain_id);
852 foreach ($components as $component_id => $component) {
853 // Create or update the per component reports links.
854 $component_nav_name = $component['name'];
855 if (isset($component_to_nav_name[$component_nav_name])) {
856 $component_nav_name = $component_to_nav_name[$component_nav_name];
858 $permission = "access {$component['name']}";
859 if ($component['name'] === 'CiviContact') {
860 $permission = "administer CiviCRM";
862 elseif ($component['name'] === 'CiviCampaign') {
863 $permission = "access CiviReport";
865 $component_nav = self
::createOrUpdateReportNavItem($component_nav_name, 'civicrm/report/list',
866 "compid={$component_id}&reset=1", $reports_nav->id
, $permission, $domain_id, TRUE);
867 foreach ($component['reports'] as $report_id => $report) {
868 // Create or update the report instance links.
869 $report_nav = self
::createOrUpdateReportNavItem($report['title'], $report['url'], 'reset=1', $component_nav->id
, $report['permission'], $domain_id);
870 // Update the report instance to include the navigation id.
871 $query = "UPDATE civicrm_report_instance SET navigation_id = %1 WHERE id = %2";
873 1 => array($report_nav->id
, 'Integer'),
874 2 => array($report_id, 'Integer'),
876 CRM_Core_DAO
::executeQuery($query, $params);
880 // Create or update the All Reports link.
881 self
::createOrUpdateReportNavItem('All Reports', 'civicrm/report/list', 'reset=1', $reports_nav->id
, 'access CiviReport', $domain_id);
885 * Create the top level 'Reports' item in the navigation tree.
887 * @param int $domain_id
889 * @return bool|\CRM_Core_DAO
891 static public function createOrUpdateTopLevelReportsNavItem($domain_id) {
894 $dao = new CRM_Core_BAO_Navigation();
895 $dao->name
= 'Reports';
896 $dao->domain_id
= $domain_id;
897 // The first selectAdd clears it - so that we only retrieve the one field.
899 $dao->selectAdd('id');
900 if ($dao->find(TRUE)) {
904 $nav = self
::createReportNavItem('Reports', NULL, NULL, NULL, 'access CiviReport', $id, $domain_id);
909 * Retrieve a navigation item using it's url.
912 * @param array $url_params
914 * @param int|null $parent_id
915 * Optionally restrict to one parent.
917 * @return bool|\CRM_Core_BAO_Navigation
919 public static function getNavItemByUrl($url, $url_params, $parent_id = NULL) {
920 $nav = new CRM_Core_BAO_Navigation();
921 $nav->url
= "{$url}?{$url_params}";
922 $nav->parent_id
= $parent_id;
923 if ($nav->find(TRUE)) {
930 * Get all active reports, organised by component.
932 * @param int $domain_id
936 public static function getAllActiveReportsByComponent($domain_id) {
939 civicrm_report_instance.id, civicrm_report_instance.title, civicrm_report_instance.permission, civicrm_component.name, civicrm_component.id AS component_id
943 civicrm_option_value ON civicrm_option_value.option_group_id = civicrm_option_group.id AND civicrm_option_group.name = 'report_template'
945 civicrm_report_instance ON civicrm_option_value.value = civicrm_report_instance.report_id
947 civicrm_component ON civicrm_option_value.component_id = civicrm_component.id
949 civicrm_option_value.is_active = 1
951 civicrm_report_instance.domain_id = %1
952 ORDER BY civicrm_option_value.weight";
954 $dao = CRM_Core_DAO
::executeQuery($sql, array(
955 1 => array($domain_id, 'Integer'),
958 while ($dao->fetch()) {
959 $component_name = is_null($dao->name
) ?
'CiviContact' : $dao->name
;
960 $component_id = is_null($dao->component_id
) ?
99 : $dao->component_id
;
961 $rows[$component_id]['name'] = $component_name;
962 $rows[$component_id]['reports'][$dao->id
] = array(
963 'title' => $dao->title
,
964 'url' => "civicrm/report/instance/{$dao->id}",
965 'permission' => $dao->permission
,
972 * Create or update a navigation item for a report instance.
974 * The function will check whether create or update is required.
976 * @param string $name
978 * @param string $url_params
979 * @param int $parent_id
980 * @param string $permission
981 * @param int $domain_id
983 * @param bool $onlyMatchParentID
984 * If True then do not match with a url that has a different parent
985 * (This is because for top level items there is a risk of 'stealing' rows that normally
986 * live under 'Contact' and intentionally duplicate the report examples.)
988 * @return \CRM_Core_DAO_Navigation
990 protected static function createOrUpdateReportNavItem($name, $url, $url_params, $parent_id, $permission,
991 $domain_id, $onlyMatchParentID = FALSE) {
993 $existing_nav = CRM_Core_BAO_Navigation
::getNavItemByUrl($url, $url_params, ($onlyMatchParentID ?
$parent_id : NULL));
995 $id = $existing_nav->id
;
998 $nav = self
::createReportNavItem($name, $url, $url_params, $parent_id, $permission, $id, $domain_id);
1003 * Create a navigation item for a report instance.
1005 * @param string $name
1006 * @param string $url
1007 * @param string $url_params
1008 * @param int $parent_id
1009 * @param string $permission
1011 * @param int $domain_id
1012 * ID of domain to create item in.
1014 * @return \CRM_Core_DAO_Navigation
1016 public static function createReportNavItem($name, $url, $url_params, $parent_id, $permission, $id, $domain_id) {
1017 if ($url !== NULL) {
1018 $url = "{$url}?{$url_params}";
1022 'label' => ts($name),
1024 'parent_id' => $parent_id,
1025 'is_active' => TRUE,
1026 'permission' => array(
1029 'domain_id' => $domain_id,
1032 $params['id'] = $id;
1034 return CRM_Core_BAO_Navigation
::add($params);
1042 * @return object|string
1044 public static function getCacheKey($cid) {
1045 $key = CRM_Core_BAO_Setting
::getItem(
1046 CRM_Core_BAO_Setting
::PERSONAL_PREFERENCES_NAME
,
1052 if (strlen($key) !== self
::CACHE_KEY_STRLEN
) {
1053 $key = self
::resetNavigation($cid);