CRM/Contribute/Page/ContributionPage.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | Copyright CiviCRM LLC. All rights reserved.                        |
   5  |                                                                    |
   6  | This work is published under the GNU AGPLv3 license with some      |
   7  | permitted exceptions and without any warranty. For full license    |
   8  | and copyright information, see https://civicrm.org/licensing       |
   9  +--------------------------------------------------------------------+
  10  */
  11
  12 /**
  13  *
  14  * @package CRM
  15  * @copyright CiviCRM LLC https://civicrm.org/licensing
  16  */
  17
  18 /**
  19  * Create a page for displaying Contribute Pages
  20  * Contribute Pages are pages that are used to display
  21  * contributions of different types. Pages consist
  22  * of many customizable sections which can be
  23  * accessed.
  24  *
  25  * This page provides a top level browse view
  26  * of all the contribution pages in the system.
  27  *
  28  */
  29 class CRM_Contribute_Page_ContributionPage extends CRM_Core_Page {
  30
  31   /**
  32    * The action links that we need to display for the browse screen.
  33    *
  34    * @var array
  35    */
  36   private static $_actionLinks;
  37   private static $_contributionLinks;
  38   private static $_configureActionLinks;
  39   private static $_onlineContributionLinks;
  40
  41   /**
  42    * @var CRM_Utils_Pager
  43    */
  44   protected $_pager = NULL;
  45
  46   /**
  47    * @var string
  48    */
  49   protected $_sortByCharacter;
  50
  51   /**
  52    * Get the action links for this page.
  53    *
  54    * @return array
  55    */
  56   public static function &actionLinks() {
  57     // check if variable _actionsLinks is populated
  58     if (!isset(self::$_actionLinks)) {
  59       // helper variable for nicer formatting
  60       $deleteExtra = ts('Are you sure you want to delete this Contribution page?');
  61       $copyExtra = ts('Are you sure you want to make a copy of this Contribution page?');
  62
  63       self::$_actionLinks = array(
  64         CRM_Core_Action::COPY => array(
  65           'name' => ts('Make a Copy'),
  66           'url' => CRM_Utils_System::currentPath(),
  67           'qs' => 'action=copy&gid=%%id%%',
  68           'title' => ts('Make a Copy of CiviCRM Contribution Page'),
  69           'extra' => 'onclick = "return confirm(\'' . $copyExtra . '\');"',
  70         ),
  71         CRM_Core_Action::DISABLE => array(
  72           'name' => ts('Disable'),
  73           'title' => ts('Disable'),
  74           'ref' => 'crm-enable-disable',
  75         ),
  76         CRM_Core_Action::ENABLE => array(
  77           'name' => ts('Enable'),
  78           'ref' => 'crm-enable-disable',
  79           'title' => ts('Enable'),
  80         ),
  81         CRM_Core_Action::DELETE => array(
  82           'name' => ts('Delete'),
  83           'url' => CRM_Utils_System::currentPath(),
  84           'qs' => 'action=delete&reset=1&id=%%id%%',
  85           'title' => ts('Delete Custom Field'),
  86           'extra' => 'onclick = "return confirm(\'' . $deleteExtra . '\');"',
  87         ),
  88       );
  89     }
  90     return self::$_actionLinks;
  91   }
  92
  93   /**
  94    * Get the configure action links for this page.
  95    *
  96    * @return array
  97    */
  98   public function &configureActionLinks() {
  99     // check if variable _actionsLinks is populated
 100     if (!isset(self::$_configureActionLinks)) {
 101       $urlString = 'civicrm/admin/contribute/';
 102       $urlParams = 'reset=1&action=update&id=%%id%%';
 103
 104       self::$_configureActionLinks = array(
 105         CRM_Core_Action::ADD => array(
 106           'name' => ts('Title and Settings'),
 107           'title' => ts('Title and Settings'),
 108           'url' => $urlString . 'settings',
 109           'qs' => $urlParams,
 110           'uniqueName' => 'settings',
 111         ),
 112         CRM_Core_Action::UPDATE => array(
 113           'name' => ts('Contribution Amounts'),
 114           'title' => ts('Contribution Amounts'),
 115           'url' => $urlString . 'amount',
 116           'qs' => $urlParams,
 117           'uniqueName' => 'amount',
 118         ),
 119         CRM_Core_Action::VIEW => array(
 120           'name' => ts('Membership Settings'),
 121           'title' => ts('Membership Settings'),
 122           'url' => $urlString . 'membership',
 123           'qs' => $urlParams,
 124           'uniqueName' => 'membership',
 125         ),
 126         CRM_Core_Action::EXPORT => array(
 127           'name' => ts('Thank-you and Receipting'),
 128           'title' => ts('Thank-you and Receipting'),
 129           'url' => $urlString . 'thankyou',
 130           'qs' => $urlParams,
 131           'uniqueName' => 'thankyou',
 132         ),
 133         CRM_Core_Action::BASIC => array(
 134           'name' => ts('Tell a Friend'),
 135           'title' => ts('Tell a Friend'),
 136           'url' => $urlString . 'friend',
 137           'qs' => $urlParams,
 138           'uniqueName' => 'friend',
 139         ),
 140         CRM_Core_Action::PROFILE => array(
 141           'name' => ts('Include Profiles'),
 142           'title' => ts('Include Profiles'),
 143           'url' => $urlString . 'custom',
 144           'qs' => $urlParams,
 145           'uniqueName' => 'custom',
 146         ),
 147         CRM_Core_Action::MAP => array(
 148           'name' => ts('Contribution Widget'),
 149           'title' => ts('Contribution Widget'),
 150           'url' => $urlString . 'widget',
 151           'qs' => $urlParams,
 152           'uniqueName' => 'widget',
 153         ),
 154         CRM_Core_Action::FOLLOWUP => array(
 155           'name' => ts('Premiums'),
 156           'title' => ts('Premiums'),
 157           'url' => $urlString . 'premium',
 158           'qs' => $urlParams,
 159           'uniqueName' => 'premium',
 160         ),
 161         CRM_Core_Action::ADVANCED => array(
 162           'name' => ts('Personal Campaign Pages'),
 163           'title' => ts('Personal Campaign Pages'),
 164           'url' => $urlString . 'pcp',
 165           'qs' => $urlParams,
 166           'uniqueName' => 'pcp',
 167         ),
 168       );
 169       $context = array(
 170         'urlString' => $urlString,
 171         'urlParams' => $urlParams,
 172       );
 173       CRM_Utils_Hook::tabset('civicrm/admin/contribute', self::$_configureActionLinks, $context);
 174     }
 175
 176     return self::$_configureActionLinks;
 177   }
 178
 179   /**
 180    * Get the online contribution links.
 181    *
 182    * @return array
 183    */
 184   public function &onlineContributionLinks() {
 185     if (!isset(self::$_onlineContributionLinks)) {
 186       $urlString = 'civicrm/contribute/transact';
 187       $urlParams = 'reset=1&id=%%id%%';
 188       self::$_onlineContributionLinks = array(
 189         CRM_Core_Action::RENEW => array(
 190           'name' => ts('Live Page'),
 191           'title' => ts('Live Page'),
 192           'url' => $urlString,
 193           'qs' => $urlParams,
 194           'fe' => TRUE,
 195           'uniqueName' => 'live_page',
 196         ),
 197         CRM_Core_Action::PREVIEW => array(
 198           'name' => ts('Test-drive'),
 199           'title' => ts('Test-drive'),
 200           'url' => $urlString,
 201           'qs' => $urlParams . '&action=preview',
 202           // Addresses https://lab.civicrm.org/dev/core/issues/658
 203           'fe' => TRUE,
 204           'uniqueName' => 'test_drive',
 205         ),
 206       );
 207     }
 208
 209     return self::$_onlineContributionLinks;
 210   }
 211
 212   /**
 213    * Get the contributions links.
 214    *
 215    * @return array
 216    */
 217   public function &contributionLinks() {
 218     if (!isset(self::$_contributionLinks)) {
 219       //get contribution dates.
 220       $dates = CRM_Contribute_BAO_Contribution::getContributionDates();
 221       $now = $dates['now'];
 222       $yearDate = $dates['yearDate'];
 223       $monthDate = $dates['monthDate'];
 224       $yearNow = $yearDate + 10000;
 225
 226       $urlString = 'civicrm/contribute/search';
 227       $urlParams = 'reset=1&contribution_page_id=%%id%%&force=1&test=0';
 228
 229       self::$_contributionLinks = array(
 230         CRM_Core_Action::DETACH => array(
 231           'name' => ts('Current Month-To-Date'),
 232           'title' => ts('Current Month-To-Date'),
 233           'url' => $urlString,
 234           'qs' => "{$urlParams}&receive_date_low={$monthDate}&receive_date_high={$now}",
 235           'uniqueName' => 'current_month_to_date',
 236         ),
 237         CRM_Core_Action::REVERT => array(
 238           'name' => ts('Fiscal Year-To-Date'),
 239           'title' => ts('Fiscal Year-To-Date'),
 240           'url' => $urlString,
 241           'qs' => "{$urlParams}&receive_date_low={$yearDate}&receive_date_high={$yearNow}",
 242           'uniqueName' => 'fiscal_year_to_date',
 243         ),
 244         CRM_Core_Action::BROWSE => array(
 245           'name' => ts('Cumulative'),
 246           'title' => ts('Cumulative'),
 247           'url' => $urlString,
 248           'qs' => "{$urlParams}&receive_date_low=&receive_date_high=$now",
 249           'uniqueName' => 'cumulative',
 250         ),
 251       );
 252     }
 253
 254     return self::$_contributionLinks;
 255   }
 256
 257   /**
 258    * Run the page.
 259    *
 260    * This method is called after the page is created. It checks for the
 261    * type of action and executes that action.
 262    * Finally it calls the parent's run method.
 263    *
 264    * @return mixed
 265    */
 266   public function run() {
 267     // get the requested action
 268     $action = CRM_Utils_Request::retrieve('action', 'String',
 269       // default to 'browse'
 270       $this, FALSE, 'browse'
 271     );
 272
 273     // assign vars to templates
 274     $this->assign('action', $action);
 275     $id = CRM_Utils_Request::retrieve('id', 'Positive',
 276       $this, FALSE, 0
 277     );
 278
 279     // set breadcrumb to append to 2nd layer pages
 280     $breadCrumb = array(
 281       array(
 282         'title' => ts('Manage Contribution Pages'),
 283         'url' => CRM_Utils_System::url(CRM_Utils_System::currentPath(),
 284           'reset=1'
 285         ),
 286       ),
 287     );
 288
 289     // what action to take ?
 290     if ($action & CRM_Core_Action::ADD) {
 291       $session = CRM_Core_Session::singleton();
 292       $session->pushUserContext(CRM_Utils_System::url(CRM_Utils_System::currentPath(),
 293         'action=browse&reset=1'
 294       ));
 295
 296       $controller = new CRM_Contribute_Controller_ContributionPage(NULL, $action);
 297       CRM_Utils_System::setTitle(ts('Manage Contribution Page'));
 298       CRM_Utils_System::appendBreadCrumb($breadCrumb);
 299       return $controller->run();
 300     }
 301     elseif ($action & CRM_Core_Action::UPDATE) {
 302       $config = CRM_Core_Config::singleton();
 303
 304       // assign vars to templates
 305       $this->assign('id', $id);
 306       $this->assign('title', CRM_Core_DAO::getFieldValue('CRM_Contribute_DAO_ContributionPage', $id, 'title'));
 307       $this->assign('is_active', CRM_Core_DAO::getFieldValue('CRM_Contribute_DAO_ContributionPage', $id, 'is_active'));
 308       if (in_array('CiviMember', $config->enableComponents)) {
 309         $this->assign('CiviMember', TRUE);
 310       }
 311     }
 312     elseif ($action & CRM_Core_Action::COPY) {
 313       // @todo Unused local variable can be safely removed.
 314       // But are there any side effects of CRM_Core_Session::singleton() that we
 315       // need to preserve?
 316       $session = CRM_Core_Session::singleton();
 317       CRM_Core_Session::setStatus(ts('A copy of the contribution page has been created'), ts('Successfully Copied'), 'success');
 318       $this->copy();
 319     }
 320     elseif ($action & CRM_Core_Action::DELETE) {
 321       CRM_Utils_System::appendBreadCrumb($breadCrumb);
 322
 323       $session = CRM_Core_Session::singleton();
 324       $session->pushUserContext(CRM_Utils_System::url(CRM_Utils_System::currentPath(),
 325         'reset=1&action=browse'
 326       ));
 327
 328       $id = CRM_Utils_Request::retrieve('id', 'Positive',
 329         $this, FALSE, 0
 330       );
 331       $query = "
 332 SELECT      ccp.title
 333 FROM        civicrm_contribution_page ccp
 334 JOIN        civicrm_pcp cp ON ccp.id = cp.page_id
 335 WHERE       cp.page_id = {$id}
 336 AND         cp.page_type = 'contribute'
 337 ";
 338
 339       if ($pageTitle = CRM_Core_DAO::singleValueQuery($query)) {
 340         CRM_Core_Session::setStatus(ts('The \'%1\' cannot be deleted! You must Delete all Personal Campaign Page(s) related with this contribution page prior to deleting the page.', array(1 => $pageTitle)), ts('Deletion Error'), 'error');
 341
 342         CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/admin/contribute', 'reset=1'));
 343       }
 344
 345       $controller = new CRM_Core_Controller_Simple('CRM_Contribute_Form_ContributionPage_Delete',
 346         'Delete Contribution Page',
 347         CRM_Core_Action::DELETE
 348       );
 349       $controller->set('id', $id);
 350       $controller->process();
 351       return $controller->run();
 352     }
 353     else {
 354       // finally browse the contribution pages
 355       $this->browse();
 356
 357       CRM_Utils_System::setTitle(ts('Manage Contribution Pages'));
 358     }
 359
 360     return parent::run();
 361   }
 362
 363   /**
 364    * Make a copy of a contribution page, including all the fields in the page.
 365    */
 366   public function copy() {
 367     $gid = CRM_Utils_Request::retrieve('gid', 'Positive',
 368       $this, TRUE, 0, 'GET'
 369     );
 370
 371     $copy = CRM_Contribute_BAO_ContributionPage::copy($gid);
 372
 373     $urlString = CRM_Utils_System::currentPath();
 374     $urlParams = 'reset=1';
 375
 376     // Redirect to copied contribution page
 377     if ($copy->id) {
 378       $urlString = 'civicrm/admin/contribute/settings';
 379       $urlParams .= '&action=update&id=' . $copy->id;
 380     }
 381
 382     CRM_Utils_System::redirect(CRM_Utils_System::url($urlString, $urlParams));
 383   }
 384
 385   /**
 386    * Browse all contribution pages.
 387    *
 388    * @param mixed $action
 389    *   Unused parameter.
 390    */
 391   public function browse($action = NULL) {
 392     Civi::resources()->addStyleFile('civicrm', 'css/searchForm.css', 1, 'html-header');
 393
 394     $this->_sortByCharacter = CRM_Utils_Request::retrieve('sortByCharacter',
 395       'String',
 396       $this
 397     );
 398     // @todo Unused local variable can be safely removed.
 399     // But are there any side effects of CRM_Utils_Request::retrieve() that we
 400     // need to preserve?
 401     $createdId = CRM_Utils_Request::retrieve('cid', 'Positive',
 402       $this, FALSE, 0
 403     );
 404
 405     if ($this->_sortByCharacter == 'all' ||
 406       !empty($_POST)
 407     ) {
 408       $this->_sortByCharacter = '';
 409       $this->set('sortByCharacter', '');
 410     }
 411
 412     $this->search();
 413
 414     $params = array();
 415
 416     $whereClause = $this->whereClause($params, FALSE);
 417     $config = CRM_Core_Config::singleton();
 418     if ($config->includeAlphabeticalPager) {
 419       $this->pagerAToZ($whereClause, $params);
 420     }
 421     $params = array();
 422     $whereClause = $this->whereClause($params, TRUE);
 423     $this->pager($whereClause, $params);
 424
 425     list($offset, $rowCount) = $this->_pager->getOffsetAndRowCount();
 426
 427     //check for delete CRM-4418
 428     $allowToDelete = CRM_Core_Permission::check('delete in CiviContribute');
 429
 430     $query = "
 431   SELECT  id
 432     FROM  civicrm_contribution_page
 433    WHERE  $whereClause
 434    ORDER BY is_active desc, title asc
 435    LIMIT  $offset, $rowCount";
 436     $contribPage = CRM_Core_DAO::executeQuery($query, $params, TRUE, 'CRM_Contribute_DAO_ContributionPage');
 437     $contribPageIds = array();
 438     while ($contribPage->fetch()) {
 439       $contribPageIds[$contribPage->id] = $contribPage->id;
 440     }
 441     //get all section info.
 442     $contriPageSectionInfo = CRM_Contribute_BAO_ContributionPage::getSectionInfo($contribPageIds);
 443
 444     $query = "
 445 SELECT *
 446 FROM civicrm_contribution_page
 447 WHERE $whereClause
 448 ORDER BY is_active desc, title asc
 449    LIMIT $offset, $rowCount";
 450
 451     $dao = CRM_Core_DAO::executeQuery($query, $params, TRUE, 'CRM_Contribute_DAO_ContributionPage');
 452
 453     //get all campaigns.
 454     $allCampaigns = CRM_Campaign_BAO_Campaign::getCampaigns(NULL, NULL, FALSE, FALSE, FALSE, TRUE);
 455
 456     //get configure actions links.
 457     $configureActionLinks = self::configureActionLinks();
 458
 459     while ($dao->fetch()) {
 460       $contribution[$dao->id] = array();
 461       CRM_Core_DAO::storeValues($dao, $contribution[$dao->id]);
 462
 463       // form all action links
 464       $action = array_sum(array_keys(self::actionLinks()));
 465
 466       //add configure actions links.
 467       $action += array_sum(array_keys($configureActionLinks));
 468
 469       //add online contribution links.
 470       $action += array_sum(array_keys(self::onlineContributionLinks()));
 471
 472       //add contribution search links.
 473       $action += array_sum(array_keys(self::contributionLinks()));
 474
 475       if ($dao->is_active) {
 476         $action -= (int) CRM_Core_Action::ENABLE;
 477       }
 478       else {
 479         $action -= (int) CRM_Core_Action::DISABLE;
 480       }
 481
 482       //CRM-4418
 483       if (!$allowToDelete) {
 484         $action -= (int) CRM_Core_Action::DELETE;
 485       }
 486
 487       //build the configure links.
 488       $sectionsInfo = CRM_Utils_Array::value($dao->id, $contriPageSectionInfo, array());
 489       $contribution[$dao->id]['configureActionLinks'] = CRM_Core_Action::formLink(self::formatConfigureLinks($sectionsInfo),
 490         $action,
 491         array('id' => $dao->id),
 492         ts('Configure'),
 493         TRUE,
 494         'contributionpage.configure.actions',
 495         'ContributionPage',
 496         $dao->id
 497       );
 498
 499       //build the contributions links.
 500       $contribution[$dao->id]['contributionLinks'] = CRM_Core_Action::formLink(self::contributionLinks(),
 501         $action,
 502         array('id' => $dao->id),
 503         ts('Contributions'),
 504         TRUE,
 505         'contributionpage.contributions.search',
 506         'ContributionPage',
 507         $dao->id
 508       );
 509
 510       //build the online contribution links.
 511       $contribution[$dao->id]['onlineContributionLinks'] = CRM_Core_Action::formLink(self::onlineContributionLinks(),
 512         $action,
 513         array('id' => $dao->id),
 514         ts('Links'),
 515         TRUE,
 516         'contributionpage.online.links',
 517         'ContributionPage',
 518         $dao->id
 519       );
 520
 521       //build the normal action links.
 522       $contribution[$dao->id]['action'] = CRM_Core_Action::formLink(self::actionLinks(),
 523         $action,
 524         array('id' => $dao->id),
 525         ts('more'),
 526         TRUE,
 527         'contributionpage.action.links',
 528         'ContributionPage',
 529         $dao->id
 530       );
 531
 532       //show campaigns on selector.
 533       $contribution[$dao->id]['campaign'] = CRM_Utils_Array::value($dao->campaign_id, $allCampaigns);
 534     }
 535
 536     if (isset($contribution)) {
 537       $this->assign('rows', $contribution);
 538     }
 539   }
 540
 541   public function search() {
 542     if (isset($this->_action) & (CRM_Core_Action::ADD |
 543         CRM_Core_Action::UPDATE |
 544         CRM_Core_Action::DELETE
 545       )
 546     ) {
 547       return;
 548     }
 549
 550     $form = new CRM_Core_Controller_Simple('CRM_Contribute_Form_SearchContribution',
 551       ts('Search Contribution'),
 552       CRM_Core_Action::ADD
 553     );
 554     $form->setEmbedded(TRUE);
 555     $form->setParent($this);
 556     $form->process();
 557     $form->run();
 558   }
 559
 560   /**
 561    * @param array $params
 562    * @param bool $sortBy
 563    *
 564    * @return int|string
 565    */
 566   public function whereClause(&$params, $sortBy = TRUE) {
 567     // @todo Unused local variable can be safely removed.
 568     $values = $clauses = array();
 569     $title = $this->get('title');
 570     $createdId = $this->get('cid');
 571
 572     if ($createdId) {
 573       $clauses[] = "(created_id = {$createdId})";
 574     }
 575
 576     if ($title) {
 577       $clauses[] = "title LIKE %1";
 578       if (strpos($title, '%') !== FALSE) {
 579         $params[1] = array(trim($title), 'String', FALSE);
 580       }
 581       else {
 582         $params[1] = array(trim($title), 'String', TRUE);
 583       }
 584     }
 585
 586     $value = $this->get('financial_type_id');
 587     $val = array();
 588     if ($value) {
 589       if (is_array($value)) {
 590         foreach ($value as $k => $v) {
 591           if ($v) {
 592             $val[$k] = $k;
 593           }
 594         }
 595         $type = implode(',', $val);
 596       }
 597       // @todo Variable 'type' might not have been defined.
 598       $clauses[] = "financial_type_id IN ({$type})";
 599     }
 600
 601     if ($sortBy && $this->_sortByCharacter !== NULL) {
 602       $clauses[] = "title LIKE '" . strtolower(CRM_Core_DAO::escapeWildCardString($this->_sortByCharacter)) . "%'";
 603     }
 604
 605     $campaignIds = $this->getCampaignIds();
 606     if (count($campaignIds) >= 1) {
 607       $clauses[] = '( campaign_id IN ( ' . implode(' , ', $campaignIds) . ' ) )';
 608     }
 609
 610     if (empty($clauses)) {
 611       // Let template know if user has run a search or not
 612       $this->assign('isSearch', 0);
 613       return 1;
 614     }
 615     else {
 616       $this->assign('isSearch', 1);
 617     }
 618
 619     return implode(' AND ', $clauses);
 620   }
 621
 622   /**
 623    * Gets the campaign ids from the session.
 624    *
 625    * @return int[]
 626    */
 627   public function getCampaignIds() {
 628     // The unfiltered value from the session cannot be trusted, it needs to be
 629     // processed to get a clean array of positive integers.
 630     $ids = array();
 631     foreach ((array) $this->get('campaign_id') as $id) {
 632       if ((string) (int) $id === (string) $id && $id > 0) {
 633         $ids[] = $id;
 634       }
 635     }
 636     return $ids;
 637   }
 638
 639   /**
 640    * @param $whereClause
 641    * @param array $whereParams
 642    */
 643   public function pager($whereClause, $whereParams) {
 644
 645     $params['status'] = ts('Contribution %%StatusMessage%%');
 646     $params['csvString'] = NULL;
 647     $params['buttonTop'] = 'PagerTopButton';
 648     $params['buttonBottom'] = 'PagerBottomButton';
 649     $params['rowCount'] = $this->get(CRM_Utils_Pager::PAGE_ROWCOUNT);
 650     if (!$params['rowCount']) {
 651       $params['rowCount'] = CRM_Utils_Pager::ROWCOUNT;
 652     }
 653
 654     $query = "
 655 SELECT count(id)
 656 FROM civicrm_contribution_page
 657 WHERE $whereClause";
 658
 659     $params['total'] = CRM_Core_DAO::singleValueQuery($query, $whereParams);
 660
 661     $this->_pager = new CRM_Utils_Pager($params);
 662     $this->assign_by_ref('pager', $this->_pager);
 663   }
 664
 665   /**
 666    * @param $whereClause
 667    * @param array $whereParams
 668    */
 669   public function pagerAtoZ($whereClause, $whereParams) {
 670
 671     $query = "
 672 SELECT DISTINCT UPPER(LEFT(title, 1)) as sort_name
 673 FROM civicrm_contribution_page
 674 WHERE $whereClause
 675 ORDER BY UPPER(LEFT(title, 1))
 676 ";
 677     $dao = CRM_Core_DAO::executeQuery($query, $whereParams);
 678
 679     $aToZBar = CRM_Utils_PagerAToZ::getAToZBar($dao, $this->_sortByCharacter, TRUE);
 680     $this->assign('aToZ', $aToZBar);
 681   }
 682
 683   /**
 684    * @param array $sectionsInfo
 685    *
 686    * @return array
 687    */
 688   public function formatConfigureLinks($sectionsInfo) {
 689     // build the formatted configure links.
 690     $formattedConfLinks = self::configureActionLinks();
 691     foreach ($formattedConfLinks as $act => & $link) {
 692       $sectionName = CRM_Utils_Array::value('uniqueName', $link);
 693       if (!$sectionName) {
 694         continue;
 695       }
 696
 697       if (empty($sectionsInfo[$sectionName])) {
 698         $classes = array();
 699         if (isset($link['class'])) {
 700           $classes = $link['class'];
 701         }
 702         $link['class'] = array_merge($classes, array('disabled'));
 703       }
 704     }
 705
 706     return $formattedConfLinks;
 707   }
 708
 709 }