CRM/Contribute/BAO/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  * This class contains Contribution Page related functions.
  20  */
  21 class CRM_Contribute_BAO_ContributionPage extends CRM_Contribute_DAO_ContributionPage {
  22
  23   /**
  24    * Creates a contribution page.
  25    *
  26    * @param array $params
  27    *
  28    * @return CRM_Contribute_DAO_ContributionPage
  29    */
  30   public static function create($params) {
  31     $financialTypeId = NULL;
  32     if (!empty($params['id']) && !CRM_Price_BAO_PriceSet::getFor('civicrm_contribution_page', $params['id'], NULL, 1)) {
  33       $financialTypeId = CRM_Core_DAO::getFieldValue('CRM_Contribute_DAO_ContributionPage', $params['id'], 'financial_type_id');
  34     }
  35
  36     if (isset($params['payment_processor']) && is_array($params['payment_processor'])) {
  37       $params['payment_processor'] = implode(CRM_Core_DAO::VALUE_SEPARATOR, $params['payment_processor']);
  38     }
  39     $hook = empty($params['id']) ? 'create' : 'edit';
  40     CRM_Utils_Hook::pre($hook, 'ContributionPage', CRM_Utils_Array::value('id', $params), $params);
  41     $dao = new CRM_Contribute_DAO_ContributionPage();
  42     $dao->copyValues($params);
  43     $dao->save();
  44     if ($financialTypeId && !empty($params['financial_type_id']) && $financialTypeId != $params['financial_type_id']) {
  45       CRM_Price_BAO_PriceFieldValue::updateFinancialType($params['id'], 'civicrm_contribution_page', $params['financial_type_id']);
  46     }
  47     CRM_Utils_Hook::post($hook, 'ContributionPage', $dao->id, $dao);
  48     return $dao;
  49   }
  50
  51   /**
  52    * Update the is_active flag in the db.
  53    *
  54    * @deprecated - this bypasses hooks.
  55    *
  56    * @param int $id
  57    *   Id of the database record.
  58    * @param bool $is_active
  59    *   Value we want to set the is_active field.
  60    *
  61    * @return bool
  62    *   true if we found and updated the object, else false
  63    */
  64   public static function setIsActive($id, $is_active) {
  65     return CRM_Core_DAO::setFieldValue('CRM_Contribute_DAO_ContributionPage', $id, 'is_active', $is_active);
  66   }
  67
  68   /**
  69    * Load values for a contribution page.
  70    *
  71    * @param int $id
  72    * @param array $values
  73    */
  74   public static function setValues($id, &$values) {
  75     $modules = ['CiviContribute', 'soft_credit', 'on_behalf'];
  76     $values['custom_pre_id'] = $values['custom_post_id'] = NULL;
  77
  78     $params = ['id' => $id];
  79     CRM_Core_DAO::commonRetrieve('CRM_Contribute_DAO_ContributionPage', $params, $values);
  80
  81     // get the profile ids
  82     $ufJoinParams = [
  83       'entity_table' => 'civicrm_contribution_page',
  84       'entity_id' => $id,
  85     ];
  86
  87     // retrieve profile id as also unserialize module_data corresponding to each $module
  88     foreach ($modules as $module) {
  89       $ufJoinParams['module'] = $module;
  90       $ufJoin = new CRM_Core_DAO_UFJoin();
  91       $ufJoin->copyValues($ufJoinParams);
  92       if ($module == 'CiviContribute') {
  93         $ufJoin->orderBy('weight asc');
  94         $ufJoin->find();
  95         while ($ufJoin->fetch()) {
  96           if ($ufJoin->weight == 1) {
  97             $values['custom_pre_id'] = $ufJoin->uf_group_id;
  98           }
  99           else {
 100             $values['custom_post_id'] = $ufJoin->uf_group_id;
 101           }
 102         }
 103       }
 104       else {
 105         $ufJoin->find(TRUE);
 106         if (!$ufJoin->is_active) {
 107           continue;
 108         }
 109         $params = CRM_Contribute_BAO_ContributionPage::formatModuleData($ufJoin->module_data, TRUE, $module);
 110         $values = array_merge($params, $values);
 111         if ($module == 'soft_credit') {
 112           $values['honoree_profile_id'] = $ufJoin->uf_group_id;
 113           $values['honor_block_is_active'] = $ufJoin->is_active;
 114         }
 115         else {
 116           $values['onbehalf_profile_id'] = $ufJoin->uf_group_id;
 117         }
 118       }
 119     }
 120   }
 121
 122   /**
 123    * Send the emails.
 124    *
 125    * @param int $contactID
 126    *   Contact id.
 127    * @param array $values
 128    *   Associated array of fields.
 129    * @param bool $isTest
 130    *   If in test mode.
 131    * @param bool $returnMessageText
 132    *   Return the message text instead of sending the mail.
 133    *
 134    * @param array $fieldTypes
 135    *
 136    * @throws \CRM_Core_Exception
 137    */
 138   public static function sendMail($contactID, $values, $isTest = FALSE, $returnMessageText = FALSE, $fieldTypes = NULL) {
 139     $gIds = [];
 140     $params = ['custom_pre_id' => [], 'custom_post_id' => []];
 141     $email = NULL;
 142
 143     // We are trying to fight the good fight against leaky variables (CRM-17519) so let's get really explicit
 144     // about ensuring the variables we want for the template are defined.
 145     // @todo add to this until all tpl params are explicit in this function and not waltzing around the codebase.
 146     // Next stage is to remove this & ensure there are no e-notices - ie. all are set before they hit this fn.
 147     $valuesRequiredForTemplate = [
 148       'customPre',
 149       'customPost',
 150       'customPre_grouptitle',
 151       'customPost_grouptitle',
 152       'useForMember',
 153       'membership_assign',
 154       'amount',
 155       'receipt_date',
 156       'is_pay_later',
 157     ];
 158
 159     foreach ($valuesRequiredForTemplate as $valueRequiredForTemplate) {
 160       if (!isset($values[$valueRequiredForTemplate])) {
 161         $values[$valueRequiredForTemplate] = NULL;
 162       }
 163     }
 164
 165     if (isset($values['custom_pre_id'])) {
 166       $preProfileType = CRM_Core_BAO_UFField::getProfileType($values['custom_pre_id']);
 167       if ($preProfileType == 'Membership' && !empty($values['membership_id'])) {
 168         $params['custom_pre_id'] = [
 169           [
 170             'member_id',
 171             '=',
 172             $values['membership_id'],
 173             0,
 174             0,
 175           ],
 176         ];
 177       }
 178       elseif ($preProfileType == 'Contribution' && !empty($values['contribution_id'])) {
 179         $params['custom_pre_id'] = [
 180           [
 181             'contribution_id',
 182             '=',
 183             $values['contribution_id'],
 184             0,
 185             0,
 186           ],
 187         ];
 188       }
 189
 190       $gIds['custom_pre_id'] = $values['custom_pre_id'];
 191     }
 192
 193     if (isset($values['custom_post_id'])) {
 194       $postProfileType = CRM_Core_BAO_UFField::getProfileType($values['custom_post_id']);
 195       if ($postProfileType == 'Membership' && !empty($values['membership_id'])) {
 196         $params['custom_post_id'] = [
 197           [
 198             'member_id',
 199             '=',
 200             $values['membership_id'],
 201             0,
 202             0,
 203           ],
 204         ];
 205       }
 206       elseif ($postProfileType == 'Contribution' && !empty($values['contribution_id'])) {
 207         $params['custom_post_id'] = [
 208           [
 209             'contribution_id',
 210             '=',
 211             $values['contribution_id'],
 212             0,
 213             0,
 214           ],
 215         ];
 216       }
 217
 218       $gIds['custom_post_id'] = $values['custom_post_id'];
 219     }
 220
 221     if (!empty($values['is_for_organization'])) {
 222       if (!empty($values['membership_id'])) {
 223         $params['onbehalf_profile'] = [
 224           [
 225             'member_id',
 226             '=',
 227             $values['membership_id'],
 228             0,
 229             0,
 230           ],
 231         ];
 232       }
 233       elseif (!empty($values['contribution_id'])) {
 234         $params['onbehalf_profile'] = [
 235           [
 236             'contribution_id',
 237             '=',
 238             $values['contribution_id'],
 239             0,
 240             0,
 241           ],
 242         ];
 243       }
 244     }
 245
 246     //check whether it is a test drive
 247     if ($isTest && !empty($params['custom_pre_id'])) {
 248       $params['custom_pre_id'][] = [
 249         'contribution_test',
 250         '=',
 251         1,
 252         0,
 253         0,
 254       ];
 255     }
 256
 257     if ($isTest && !empty($params['custom_post_id'])) {
 258       $params['custom_post_id'][] = [
 259         'contribution_test',
 260         '=',
 261         1,
 262         0,
 263         0,
 264       ];
 265     }
 266
 267     if (!$returnMessageText && !empty($gIds)) {
 268       //send notification email if field values are set (CRM-1941)
 269       foreach ($gIds as $key => $gId) {
 270         if ($gId) {
 271           $email = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_UFGroup', $gId, 'notify');
 272           if ($email) {
 273             $val = CRM_Core_BAO_UFGroup::checkFieldsEmptyValues($gId, $contactID, CRM_Utils_Array::value($key, $params), TRUE);
 274             CRM_Core_BAO_UFGroup::commonSendMail($contactID, $val);
 275           }
 276         }
 277       }
 278     }
 279
 280     if (!empty($values['is_email_receipt']) || !empty($values['onbehalf_dupe_alert']) ||
 281       $returnMessageText
 282     ) {
 283       $template = CRM_Core_Smarty::singleton();
 284
 285       if (!array_key_exists('related_contact', $values)) {
 286         list($displayName, $email) = CRM_Contact_BAO_Contact_Location::getEmailDetails($contactID, FALSE, CRM_Core_BAO_LocationType::getBilling());
 287       }
 288       // get primary location email if no email exist( for billing location).
 289       if (!$email) {
 290         list($displayName, $email) = CRM_Contact_BAO_Contact_Location::getEmailDetails($contactID);
 291       }
 292       if (empty($displayName)) {
 293         list($displayName, $email) = CRM_Contact_BAO_Contact_Location::getEmailDetails($contactID);
 294       }
 295
 296       //for display profile need to get individual contact id,
 297       //hence get it from related_contact if on behalf of org true CRM-3767
 298       //CRM-5001 Contribution/Membership:: On Behalf of Organization,
 299       //If profile GROUP contain the Individual type then consider the
 300       //profile is of Individual ( including the custom data of membership/contribution )
 301       //IF Individual type not present in profile then it is consider as Organization data.
 302       $userID = $contactID;
 303       if ($preID = CRM_Utils_Array::value('custom_pre_id', $values)) {
 304         if (!empty($values['related_contact'])) {
 305           $preProfileTypes = CRM_Core_BAO_UFGroup::profileGroups($preID);
 306           if (in_array('Individual', $preProfileTypes) || in_array('Contact', $preProfileTypes)) {
 307             //Take Individual contact ID
 308             $userID = $values['related_contact'] ?? NULL;
 309           }
 310         }
 311         list($values['customPre_grouptitle'], $values['customPre']) = self::getProfileNameAndFields($preID, $userID, $params['custom_pre_id']);
 312       }
 313       $userID = $contactID;
 314       if ($postID = CRM_Utils_Array::value('custom_post_id', $values)) {
 315         if (!empty($values['related_contact'])) {
 316           $postProfileTypes = CRM_Core_BAO_UFGroup::profileGroups($postID);
 317           if (in_array('Individual', $postProfileTypes) || in_array('Contact', $postProfileTypes)) {
 318             //Take Individual contact ID
 319             $userID = $values['related_contact'] ?? NULL;
 320           }
 321         }
 322         list($values['customPost_grouptitle'], $values['customPost']) = self::getProfileNameAndFields($postID, $userID, $params['custom_post_id']);
 323       }
 324       if (isset($values['honor'])) {
 325         $honorValues = $values['honor'];
 326         $template->_values = ['honoree_profile_id' => $values['honoree_profile_id']];
 327         CRM_Contribute_BAO_ContributionSoft::formatHonoreeProfileFields(
 328           $template,
 329           $honorValues['honor_profile_values'],
 330           $honorValues['honor_id']
 331         );
 332       }
 333
 334       $title = $values['title'] ?? CRM_Contribute_BAO_Contribution_Utils::getContributionPageTitle($values['contribution_page_id']);
 335
 336       // Set email variables explicitly to avoid leaky smarty variables.
 337       // All of these will be assigned to the template, replacing any that might be assigned elsewhere.
 338       $tplParams = [
 339         'email' => $email,
 340         'receiptFromEmail' => $values['receipt_from_email'] ?? NULL,
 341         'contactID' => $contactID,
 342         'displayName' => $displayName,
 343         'contributionID' => $values['contribution_id'] ?? NULL,
 344         'contributionOtherID' => $values['contribution_other_id'] ?? NULL,
 345         // CRM-5095
 346         'lineItem' => $values['lineItem'] ?? NULL,
 347         // CRM-5095
 348         'priceSetID' => $values['priceSetID'] ?? NULL,
 349         'title' => $title,
 350         'isShare' => $values['is_share'] ?? NULL,
 351         'thankyou_title' => $values['thankyou_title'] ?? NULL,
 352         'customPre' => $values['customPre'],
 353         'customPre_grouptitle' => $values['customPre_grouptitle'],
 354         'customPost' => $values['customPost'],
 355         'customPost_grouptitle' => $values['customPost_grouptitle'],
 356         'useForMember' => $values['useForMember'],
 357         'membership_assign' => $values['membership_assign'],
 358         'amount' => $values['amount'],
 359         'is_pay_later' => $values['is_pay_later'],
 360         'receipt_date' => !$values['receipt_date'] ? NULL : date('YmdHis', strtotime($values['receipt_date'])),
 361         'pay_later_receipt' => $values['pay_later_receipt'] ?? NULL,
 362         'honor_block_is_active' => $values['honor_block_is_active'] ?? NULL,
 363         'contributionStatus' => $values['contribution_status'] ?? NULL,
 364       ];
 365
 366       if ($contributionTypeId = CRM_Utils_Array::value('financial_type_id', $values)) {
 367         $tplParams['financialTypeId'] = $contributionTypeId;
 368         $tplParams['financialTypeName'] = CRM_Core_DAO::getFieldValue('CRM_Financial_DAO_FinancialType',
 369           $contributionTypeId);
 370         // Legacy support
 371         $tplParams['contributionTypeName'] = $tplParams['financialTypeName'];
 372         $tplParams['contributionTypeId'] = $contributionTypeId;
 373       }
 374
 375       if ($contributionPageId = CRM_Utils_Array::value('id', $values)) {
 376         $tplParams['contributionPageId'] = $contributionPageId;
 377       }
 378
 379       // address required during receipt processing (pdf and email receipt)
 380       if ($displayAddress = CRM_Utils_Array::value('address', $values)) {
 381         $tplParams['address'] = $displayAddress;
 382       }
 383
 384       // CRM-6976
 385       $originalCCReceipt = $values['cc_receipt'] ?? NULL;
 386
 387       // cc to related contacts of contributor OR the one who
 388       // signs up. Is used for cases like - on behalf of
 389       // contribution / signup ..etc
 390       if (array_key_exists('related_contact', $values)) {
 391         list($ccDisplayName, $ccEmail) = CRM_Contact_BAO_Contact_Location::getEmailDetails($values['related_contact']);
 392         $ccMailId = "{$ccDisplayName} <{$ccEmail}>";
 393
 394         //@todo - this is the only place in this function where  $values is altered - but I can't find any evidence it is used
 395         $values['cc_receipt'] = !empty($values['cc_receipt']) ? ($values['cc_receipt'] . ',' . $ccMailId) : $ccMailId;
 396
 397         // reset primary-email in the template
 398         $tplParams['email'] = $ccEmail;
 399
 400         $tplParams['onBehalfName'] = $displayName;
 401         $tplParams['onBehalfEmail'] = $email;
 402
 403         if (!empty($values['onbehalf_profile_id'])) {
 404           self::buildCustomDisplay($values['onbehalf_profile_id'], 'onBehalfProfile', $contactID, $template, $params['onbehalf_profile'], $fieldTypes);
 405         }
 406       }
 407
 408       // use either the contribution or membership receipt, based on whether it’s a membership-related contrib or not
 409       $sendTemplateParams = [
 410         'groupName' => !empty($values['isMembership']) ? 'msg_tpl_workflow_membership' : 'msg_tpl_workflow_contribution',
 411         'valueName' => !empty($values['isMembership']) ? 'membership_online_receipt' : 'contribution_online_receipt',
 412         'contactId' => $contactID,
 413         'tplParams' => $tplParams,
 414         'isTest' => $isTest,
 415         'PDFFilename' => 'receipt.pdf',
 416       ];
 417
 418       if ($returnMessageText) {
 419         list($sent, $subject, $message, $html) = CRM_Core_BAO_MessageTemplate::sendTemplate($sendTemplateParams);
 420         return [
 421           'subject' => $subject,
 422           'body' => $message,
 423           'to' => $displayName,
 424           'html' => $html,
 425         ];
 426       }
 427
 428       if (empty($values['receipt_from_name']) && empty($values['receipt_from_name'])) {
 429         list($values['receipt_from_name'], $values['receipt_from_email']) = CRM_Core_BAO_Domain::getNameAndEmail();
 430       }
 431
 432       if ($values['is_email_receipt']) {
 433         $sendTemplateParams['from'] = CRM_Utils_Array::value('receipt_from_name', $values) . ' <' . $values['receipt_from_email'] . '>';
 434         $sendTemplateParams['toName'] = $displayName;
 435         $sendTemplateParams['toEmail'] = $email;
 436         $sendTemplateParams['cc'] = $values['cc_receipt'] ?? NULL;
 437         $sendTemplateParams['bcc'] = $values['bcc_receipt'] ?? NULL;
 438         //send email with pdf invoice
 439         $template = CRM_Core_Smarty::singleton();
 440         $taxAmt = $template->get_template_vars('dataArray');
 441         $isEmailPDF = Civi::settings()->get('invoice_is_email_pdf');
 442         $invoicing = Civi::settings()->get('invoicing');
 443         if ($invoicing && !empty($isEmailPDF)) {
 444           $sendTemplateParams['isEmailPdf'] = TRUE;
 445           $sendTemplateParams['contributionId'] = $values['contribution_id'];
 446         }
 447         list($sent, $subject, $message, $html) = CRM_Core_BAO_MessageTemplate::sendTemplate($sendTemplateParams);
 448       }
 449
 450       // send duplicate alert, if dupe match found during on-behalf-of processing.
 451       if (!empty($values['onbehalf_dupe_alert'])) {
 452         $sendTemplateParams['groupName'] = 'msg_tpl_workflow_contribution';
 453         $sendTemplateParams['valueName'] = 'contribution_dupalert';
 454         $sendTemplateParams['from'] = ts('Automatically Generated') . " <{$values['receipt_from_email']}>";
 455         $sendTemplateParams['toName'] = $values['receipt_from_name'] ?? NULL;
 456         $sendTemplateParams['toEmail'] = $values['receipt_from_email'] ?? NULL;
 457         $sendTemplateParams['tplParams']['onBehalfID'] = $contactID;
 458         $sendTemplateParams['tplParams']['receiptMessage'] = $message;
 459
 460         // fix cc and reset back to original, CRM-6976
 461         $sendTemplateParams['cc'] = $originalCCReceipt;
 462
 463         CRM_Core_BAO_MessageTemplate::sendTemplate($sendTemplateParams);
 464       }
 465     }
 466   }
 467
 468   /**
 469    * Get the profile title and fields.
 470    *
 471    * @param int $gid
 472    * @param int $cid
 473    * @param array $params
 474    * @param array $fieldTypes
 475    *
 476    * @return array
 477    *
 478    * @throws \CRM_Core_Exception
 479    */
 480   protected static function getProfileNameAndFields($gid, $cid, $params, $fieldTypes = []) {
 481     $groupTitle = NULL;
 482     $values = [];
 483     if ($gid) {
 484       if (CRM_Core_BAO_UFGroup::filterUFGroups($gid, $cid)) {
 485         $fields = CRM_Core_BAO_UFGroup::getFields($gid, FALSE, CRM_Core_Action::VIEW, NULL, NULL, FALSE, NULL, FALSE, NULL, CRM_Core_Permission::CREATE, NULL);
 486         foreach ($fields as $k => $v) {
 487           if (!$groupTitle) {
 488             $groupTitle = $v['groupTitle'];
 489           }
 490           // suppress all file fields from display and formatting fields
 491           if (
 492             $v['data_type'] === 'File' || $v['name'] === 'image_URL' || $v['field_type'] === 'Formatting') {
 493             unset($fields[$k]);
 494           }
 495
 496           if (!empty($fieldTypes) && (!in_array($v['field_type'], $fieldTypes))) {
 497             unset($fields[$k]);
 498           }
 499         }
 500
 501         CRM_Core_BAO_UFGroup::getValues($cid, $fields, $values, FALSE, $params);
 502       }
 503     }
 504     return [$groupTitle, $values];
 505   }
 506
 507   /**
 508    * Send the emails for Recurring Contribution Notification.
 509    *
 510    * @param string $type
 511    *   TxnType.
 512    * @param int $contactID
 513    *   Contact id for contributor.
 514    * @param int $pageID
 515    *   Contribution page id.
 516    * @param object $recur
 517    *   Object of recurring contribution table.
 518    * @param bool|object $autoRenewMembership is it a auto renew membership.
 519    */
 520   public static function recurringNotify($type, $contactID, $pageID, $recur, $autoRenewMembership = FALSE) {
 521     $value = [];
 522     $isEmailReceipt = FALSE;
 523     if ($pageID) {
 524       CRM_Core_DAO::commonRetrieveAll('CRM_Contribute_DAO_ContributionPage', 'id', $pageID, $value, [
 525         'title',
 526         'is_email_receipt',
 527         'receipt_from_name',
 528         'receipt_from_email',
 529         'cc_receipt',
 530         'bcc_receipt',
 531       ]);
 532       $isEmailReceipt = $value[$pageID]['is_email_receipt'] ?? NULL;
 533     }
 534     elseif ($recur->id) {
 535       // This means we are coming from back-office - ie. no page ID, but recurring.
 536       // Ideally this information would be passed into the function clearly rather than guessing by convention.
 537       $isEmailReceipt = TRUE;
 538     }
 539
 540     if ($isEmailReceipt) {
 541       if ($pageID) {
 542         $receiptFrom = '"' . CRM_Utils_Array::value('receipt_from_name', $value[$pageID]) . '" <' . $value[$pageID]['receipt_from_email'] . '>';
 543
 544         $receiptFromName = $value[$pageID]['receipt_from_name'];
 545         $receiptFromEmail = $value[$pageID]['receipt_from_email'];
 546       }
 547       else {
 548         $domainValues = CRM_Core_BAO_Domain::getNameAndEmail();
 549         $receiptFrom = "$domainValues[0] <$domainValues[1]>";
 550         $receiptFromName = $domainValues[0];
 551         $receiptFromEmail = $domainValues[1];
 552       }
 553
 554       list($displayName, $email) = CRM_Contact_BAO_Contact_Location::getEmailDetails($contactID, FALSE);
 555       $templatesParams = [
 556         'groupName' => 'msg_tpl_workflow_contribution',
 557         'valueName' => 'contribution_recurring_notify',
 558         'contactId' => $contactID,
 559         'tplParams' => [
 560           'recur_frequency_interval' => $recur->frequency_interval,
 561           'recur_frequency_unit' => $recur->frequency_unit,
 562           'recur_installments' => $recur->installments,
 563           'recur_start_date' => $recur->start_date,
 564           'recur_end_date' => $recur->end_date,
 565           'recur_amount' => $recur->amount,
 566           'recur_txnType' => $type,
 567           'displayName' => $displayName,
 568           'receipt_from_name' => $receiptFromName,
 569           'receipt_from_email' => $receiptFromEmail,
 570           'auto_renew_membership' => $autoRenewMembership,
 571         ],
 572         'from' => $receiptFrom,
 573         'toName' => $displayName,
 574         'toEmail' => $email,
 575       ];
 576       //CRM-13811
 577       if ($pageID) {
 578         $templatesParams['cc'] = $value[$pageID]['cc_receipt'] ?? NULL;
 579         $templatesParams['bcc'] = $value[$pageID]['bcc_receipt'] ?? NULL;
 580       }
 581       if ($recur->id) {
 582         // in some cases its just recurringNotify() thats called for the first time and these urls don't get set.
 583         // like in PaypalPro, & therefore we set it here additionally.
 584         $template = CRM_Core_Smarty::singleton();
 585         $paymentProcessor = CRM_Financial_BAO_PaymentProcessor::getProcessorForEntity($recur->id, 'recur', 'obj');
 586         $url = $paymentProcessor->subscriptionURL($recur->id, 'recur', 'cancel');
 587         $template->assign('cancelSubscriptionUrl', $url);
 588
 589         $url = $paymentProcessor->subscriptionURL($recur->id, 'recur', 'billing');
 590         $template->assign('updateSubscriptionBillingUrl', $url);
 591
 592         $url = $paymentProcessor->subscriptionURL($recur->id, 'recur', 'update');
 593         $template->assign('updateSubscriptionUrl', $url);
 594       }
 595
 596       list($sent) = CRM_Core_BAO_MessageTemplate::sendTemplate($templatesParams);
 597
 598       if ($sent) {
 599         CRM_Core_Error::debug_log_message('Success: mail sent for recurring notification.');
 600       }
 601       else {
 602         CRM_Core_Error::debug_log_message('Failure: mail not sent for recurring notification.');
 603       }
 604     }
 605   }
 606
 607   /**
 608    * Add the custom fields for contribution page (ie profile).
 609    *
 610    * @deprecated assigning values to smarty like this is risky because
 611    *  - it is hard to debug since $name is used in the assign
 612    *  - it is potentially 'leaky' - it's better to do this on the form
 613    *  or close to where it is used / required. See CRM-17519 for leakage e.g.
 614    *
 615    * @param int $gid
 616    *   Uf group id.
 617    * @param string $name
 618    * @param int $cid
 619    *   Contact id.
 620    * @param $template
 621    * @param array $params
 622    *   Params to build component whereclause.
 623    *
 624    * @param array|null $fieldTypes
 625    */
 626   public static function buildCustomDisplay($gid, $name, $cid, &$template, &$params, $fieldTypes = NULL) {
 627     list($groupTitle, $values) = self::getProfileNameAndFields($gid, $cid, $params, $fieldTypes);
 628     if (!empty($values)) {
 629       $template->assign($name, $values);
 630     }
 631     $template->assign($name . "_grouptitle", $groupTitle);
 632   }
 633
 634   /**
 635    * Make a copy of a contribution page, including all the blocks in the page.
 636    *
 637    * @param int $id
 638    *   The contribution page id to copy.
 639    *
 640    * @return CRM_Contribute_DAO_ContributionPage
 641    */
 642   public static function copy($id) {
 643     $session = CRM_Core_Session::singleton();
 644
 645     $fieldsFix = [
 646       'prefix' => [
 647         'title' => ts('Copy of') . ' ',
 648       ],
 649       'replace' => [
 650         'created_id' => $session->get('userID'),
 651         'created_date' => date('YmdHis'),
 652       ],
 653     ];
 654     $copy = CRM_Core_DAO::copyGeneric('CRM_Contribute_DAO_ContributionPage', [
 655       'id' => $id,
 656     ], NULL, $fieldsFix);
 657
 658     //copying all the blocks pertaining to the contribution page
 659     $copyPledgeBlock = CRM_Core_DAO::copyGeneric('CRM_Pledge_DAO_PledgeBlock', [
 660       'entity_id' => $id,
 661       'entity_table' => 'civicrm_contribution_page',
 662     ], [
 663       'entity_id' => $copy->id,
 664     ]);
 665
 666     $copyMembershipBlock = CRM_Core_DAO::copyGeneric('CRM_Member_DAO_MembershipBlock', [
 667       'entity_id' => $id,
 668       'entity_table' => 'civicrm_contribution_page',
 669     ], [
 670       'entity_id' => $copy->id,
 671     ]);
 672
 673     $copyUFJoin = CRM_Core_DAO::copyGeneric('CRM_Core_DAO_UFJoin', [
 674       'entity_id' => $id,
 675       'entity_table' => 'civicrm_contribution_page',
 676     ], [
 677       'entity_id' => $copy->id,
 678     ]);
 679
 680     $copyWidget = CRM_Core_DAO::copyGeneric('CRM_Contribute_DAO_Widget', [
 681       'contribution_page_id' => $id,
 682     ], [
 683       'contribution_page_id' => $copy->id,
 684     ]);
 685
 686     //copy price sets
 687     CRM_Price_BAO_PriceSet::copyPriceSet('civicrm_contribution_page', $id, $copy->id);
 688
 689     $copyTellFriend = CRM_Core_DAO::copyGeneric('CRM_Friend_DAO_Friend', [
 690       'entity_id' => $id,
 691       'entity_table' => 'civicrm_contribution_page',
 692     ], [
 693       'entity_id' => $copy->id,
 694     ]);
 695
 696     $copyPersonalCampaignPages = CRM_Core_DAO::copyGeneric('CRM_PCP_DAO_PCPBlock', [
 697       'entity_id' => $id,
 698       'entity_table' => 'civicrm_contribution_page',
 699     ], [
 700       'entity_id' => $copy->id,
 701       'target_entity_id' => $copy->id,
 702     ]);
 703
 704     $copyPremium = CRM_Core_DAO::copyGeneric('CRM_Contribute_DAO_Premium', [
 705       'entity_id' => $id,
 706       'entity_table' => 'civicrm_contribution_page',
 707     ], [
 708       'entity_id' => $copy->id,
 709     ]);
 710     $premiumQuery = "
 711 SELECT id
 712 FROM civicrm_premiums
 713 WHERE entity_table = 'civicrm_contribution_page'
 714       AND entity_id ={$id}";
 715
 716     $premiumDao = CRM_Core_DAO::executeQuery($premiumQuery);
 717     while ($premiumDao->fetch()) {
 718       if ($premiumDao->id) {
 719         CRM_Core_DAO::copyGeneric('CRM_Contribute_DAO_PremiumsProduct', [
 720           'premiums_id' => $premiumDao->id,
 721         ], [
 722           'premiums_id' => $copyPremium->id,
 723         ]);
 724       }
 725     }
 726
 727     $copy->save();
 728
 729     CRM_Utils_Hook::copy('ContributionPage', $copy);
 730
 731     return $copy;
 732   }
 733
 734   /**
 735    * Get info for all sections enable/disable.
 736    *
 737    * @param array $contribPageIds
 738    * @return array
 739    *   info regarding all sections.
 740    */
 741   public static function getSectionInfo($contribPageIds = []) {
 742     $info = [];
 743     $whereClause = NULL;
 744     if (is_array($contribPageIds) && !empty($contribPageIds)) {
 745       $whereClause = 'WHERE civicrm_contribution_page.id IN ( ' . implode(', ', $contribPageIds) . ' )';
 746     }
 747
 748     $sections = [
 749       'settings',
 750       'amount',
 751       'membership',
 752       'custom',
 753       'thankyou',
 754       'friend',
 755       'pcp',
 756       'widget',
 757       'premium',
 758     ];
 759     $query = "
 760    SELECT  civicrm_contribution_page.id as id,
 761            civicrm_contribution_page.financial_type_id as settings,
 762            amount_block_is_active as amount,
 763            civicrm_membership_block.id as membership,
 764            civicrm_uf_join.id as custom,
 765            civicrm_contribution_page.thankyou_title as thankyou,
 766            civicrm_tell_friend.id as friend,
 767            civicrm_pcp_block.id as pcp,
 768            civicrm_contribution_widget.id as widget,
 769            civicrm_premiums.id as premium
 770      FROM  civicrm_contribution_page
 771 LEFT JOIN  civicrm_membership_block    ON ( civicrm_membership_block.entity_id = civicrm_contribution_page.id
 772                                             AND civicrm_membership_block.entity_table = 'civicrm_contribution_page'
 773                                             AND civicrm_membership_block.is_active = 1 )
 774 LEFT JOIN  civicrm_uf_join             ON ( civicrm_uf_join.entity_id = civicrm_contribution_page.id
 775                                             AND civicrm_uf_join.entity_table = 'civicrm_contribution_page'
 776                                             AND module = 'CiviContribute'
 777                                             AND civicrm_uf_join.is_active = 1 )
 778 LEFT JOIN  civicrm_tell_friend         ON ( civicrm_tell_friend.entity_id = civicrm_contribution_page.id
 779                                             AND civicrm_tell_friend.entity_table = 'civicrm_contribution_page'
 780                                             AND civicrm_tell_friend.is_active = 1)
 781 LEFT JOIN  civicrm_pcp_block           ON ( civicrm_pcp_block.entity_id = civicrm_contribution_page.id
 782                                             AND civicrm_pcp_block.entity_table = 'civicrm_contribution_page'
 783                                             AND civicrm_pcp_block.is_active = 1 )
 784 LEFT JOIN  civicrm_contribution_widget ON ( civicrm_contribution_widget.contribution_page_id = civicrm_contribution_page.id
 785                                             AND civicrm_contribution_widget.is_active = 1 )
 786 LEFT JOIN  civicrm_premiums            ON ( civicrm_premiums.entity_id = civicrm_contribution_page.id
 787                                             AND civicrm_premiums.entity_table = 'civicrm_contribution_page'
 788                                             AND civicrm_premiums.premiums_active = 1 )
 789            $whereClause";
 790
 791     $contributionPage = CRM_Core_DAO::executeQuery($query);
 792     while ($contributionPage->fetch()) {
 793       if (!isset($info[$contributionPage->id]) || !is_array($info[$contributionPage->id])) {
 794         $info[$contributionPage->id] = array_fill_keys(array_values($sections), FALSE);
 795       }
 796       foreach ($sections as $section) {
 797         if ($contributionPage->$section) {
 798           $info[$contributionPage->id][$section] = TRUE;
 799         }
 800       }
 801     }
 802
 803     return $info;
 804   }
 805
 806   /**
 807    * Get options for a given field.
 808    * @see CRM_Core_DAO::buildOptions
 809    *
 810    * @param string $fieldName
 811    * @param string $context : @see CRM_Core_DAO::buildOptionsContext
 812    * @param array $props : whatever is known about this dao object
 813    *
 814    * @return array|bool
 815    */
 816   public static function buildOptions($fieldName, $context = NULL, $props = []) {
 817     $params = [];
 818     // Special logic for fields whose options depend on context or properties
 819     switch ($fieldName) {
 820       case 'financial_type_id':
 821         // @fixme - this is going to ignore context, better to get conditions, add params, and call PseudoConstant::get
 822         // @fixme - https://lab.civicrm.org/dev/core/issues/547 if CiviContribute not enabled this causes an invalid query
 823         //   because $relationTypeId is not set in CRM_Financial_BAO_FinancialType::getIncomeFinancialType()
 824         if (array_key_exists('CiviContribute', CRM_Core_Component::getEnabledComponents())) {
 825           return CRM_Financial_BAO_FinancialType::getIncomeFinancialType();
 826         }
 827         return [];
 828     }
 829     return CRM_Core_PseudoConstant::get(__CLASS__, $fieldName, $params, $context);
 830   }
 831
 832   /**
 833    * Get or Set honor/on_behalf params for processing module_data or setting default values.
 834    *
 835    * @param array $params :
 836    * @param bool $setDefault : If yes then returns array to used for setting default value afterward
 837    * @param string $module : processing module_data for which module? e.g. soft_credit, on_behalf
 838    *
 839    * @return array|string
 840    */
 841   public static function formatModuleData($params, $setDefault = FALSE, $module) {
 842     $tsLocale = CRM_Core_I18n::getLocale();
 843     $config = CRM_Core_Config::singleton();
 844     $json = $jsonDecode = NULL;
 845     $domain = new CRM_Core_DAO_Domain();
 846     $domain->find(TRUE);
 847
 848     $moduleDataFormat = [
 849       'soft_credit' => [
 850         1 => 'soft_credit_types',
 851         'multilingual' => [
 852           'honor_block_title',
 853           'honor_block_text',
 854         ],
 855       ],
 856       'on_behalf' => [
 857         1 => 'is_for_organization',
 858         'multilingual' => [
 859           'for_organization',
 860         ],
 861       ],
 862     ];
 863
 864     //When we are fetching the honor params respecting both multi and mono lingual state
 865     //and setting it to default param of Contribution Page's Main and Setting form
 866     if ($setDefault) {
 867       $jsonDecode = json_decode($params);
 868       $jsonDecode = (array) $jsonDecode->$module;
 869       if (!$domain->locales && !empty($jsonDecode['default'])) {
 870         //monolingual state
 871         $jsonDecode += (array) $jsonDecode['default'];
 872         unset($jsonDecode['default']);
 873       }
 874       elseif (!empty($jsonDecode[$tsLocale])) {
 875         //multilingual state
 876         foreach ($jsonDecode[$tsLocale] as $column => $value) {
 877           $jsonDecode[$column] = $value;
 878         }
 879         unset($jsonDecode[$tsLocale]);
 880       }
 881       return $jsonDecode;
 882     }
 883
 884     //check and handle multilingual honoree params
 885     if (!$domain->locales) {
 886       //if in singlelingual state simply return the array format
 887       $json = [$module => NULL];
 888       foreach ($moduleDataFormat[$module] as $key => $attribute) {
 889         if ($key === 'multilingual') {
 890           $json[$module]['default'] = [];
 891           foreach ($attribute as $attr) {
 892             $json[$module]['default'][$attr] = $params[$attr];
 893           }
 894         }
 895         else {
 896           $json[$module][$attribute] = $params[$attribute];
 897         }
 898       }
 899       $json = json_encode($json);
 900     }
 901     else {
 902       //if in multilingual state then retrieve the module_data against this contribution and
 903       //merge with earlier module_data json data to current so not to lose earlier multilingual module_data information
 904       $json = [$module => NULL];
 905       foreach ($moduleDataFormat[$module] as $key => $attribute) {
 906         if ($key === 'multilingual') {
 907           $json[$module][$config->lcMessages] = [];
 908           foreach ($attribute as $attr) {
 909             $json[$module][$config->lcMessages][$attr] = $params[$attr];
 910           }
 911         }
 912         else {
 913           $json[$module][$attribute] = $params[$attribute];
 914         }
 915       }
 916
 917       $ufJoinDAO = new CRM_Core_DAO_UFJoin();
 918       $ufJoinDAO->module = $module;
 919       $ufJoinDAO->entity_id = $params['id'];
 920       $ufJoinDAO->find(TRUE);
 921       $jsonData = json_decode($ufJoinDAO->module_data);
 922       if ($jsonData) {
 923         $json[$module] = array_merge((array) $jsonData->$module, $json[$module]);
 924       }
 925       $json = json_encode($json);
 926     }
 927     return $json;
 928   }
 929
 930   /**
 931    * Generate html for pdf in confirmation receipt email  attachment.
 932    * @param int $contributionId
 933    *   Contribution Page Id.
 934    * @param int $userID
 935    *   Contact id for contributor.
 936    * @return array
 937    */
 938   public static function addInvoicePdfToEmail($contributionId, $userID) {
 939     $contributionID = [$contributionId];
 940     $contactId = [$userID];
 941     $pdfParams = [
 942       'output' => 'pdf_invoice',
 943       'forPage' => 'confirmpage',
 944     ];
 945     $pdfHtml = CRM_Contribute_Form_Task_Invoice::printPDF($contributionID, $pdfParams, $contactId);
 946     return $pdfHtml;
 947   }
 948
 949   /**
 950    * Helper to determine if the page supports separate membership payments.
 951    *
 952    * @param int $id form id
 953    *
 954    * @return bool
 955    *   isSeparateMembershipPayment
 956    */
 957   public static function getIsMembershipPayment($id) {
 958     $membershipBlocks = civicrm_api3('membership_block', 'get', [
 959       'entity_table' => 'civicrm_contribution_page',
 960       'entity_id' => $id,
 961       'sequential' => TRUE,
 962     ]);
 963     if (!$membershipBlocks['count']) {
 964       return FALSE;
 965     }
 966     return $membershipBlocks['values'][0]['is_separate_payment'];
 967   }
 968
 969 }