CRM/Contribute/BAO/ContributionPage.php

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