CRM/Contribute/Page/ContributionPage.php

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