CRM/Event/Form/ManageEvent/Fee.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  * @package CRM
  14  * @copyright CiviCRM LLC https://civicrm.org/licensing
  15  */
  16
  17 /**
  18  * This class generates form components for Event Fees.
  19  */
  20 class CRM_Event_Form_ManageEvent_Fee extends CRM_Event_Form_ManageEvent {
  21
  22   /**
  23    * Constants for number of options for data types of multiple option.
  24    */
  25   const NUM_OPTION = 11;
  26
  27   /**
  28    * Constants for number of discounts for the event.
  29    */
  30   const NUM_DISCOUNT = 6;
  31
  32   /**
  33    * Page action.
  34    * @var int
  35    */
  36   public $_action;
  37
  38   /**
  39    * In Date.
  40    * @var string
  41    */
  42   private $_inDate;
  43
  44   /**
  45    * Set variables up before form is built.
  46    */
  47   public function preProcess() {
  48     parent::preProcess();
  49     $this->setSelectedChild('fee');
  50   }
  51
  52   /**
  53    * Set default values for the form.
  54    *
  55    * For edit/view mode the default values are retrieved from the database.
  56    */
  57   public function setDefaultValues() {
  58     parent::setDefaultValues();
  59
  60     $eventId = $this->_id;
  61     $params = [];
  62     $defaults = [];
  63     if (isset($eventId)) {
  64       $params = ['id' => $eventId];
  65     }
  66
  67     CRM_Event_BAO_Event::retrieve($params, $defaults);
  68
  69     if (isset($eventId)) {
  70       $price_set_id = CRM_Price_BAO_PriceSet::getFor('civicrm_event', $eventId, NULL, 1);
  71
  72       if ($price_set_id) {
  73         $defaults['price_set_id'] = $price_set_id;
  74       }
  75       else {
  76         $priceSetId = CRM_Price_BAO_PriceSet::getFor('civicrm_event', $eventId, NULL);
  77         if ($priceSetId) {
  78           if ($isQuick = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceSet', $priceSetId, 'is_quick_config')) {
  79             $this->assign('isQuick', $isQuick);
  80             $priceField = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $priceSetId, 'id', 'price_set_id');
  81             $options = [];
  82             $priceFieldOptions = CRM_Price_BAO_PriceFieldValue::getValues($priceField, $options, 'weight', TRUE);
  83             $defaults['price_field_id'] = $priceField;
  84             $countRow = 0;
  85             foreach ($options as $optionId => $optionValue) {
  86               $countRow++;
  87               $defaults['value'][$countRow] = CRM_Utils_Money::format($optionValue['amount'], NULL, '%a');
  88               $defaults['label'][$countRow] = $optionValue['label'];
  89               $defaults['name'][$countRow] = $optionValue['name'];
  90               $defaults['weight'][$countRow] = $optionValue['weight'];
  91               $defaults['price_field_value'][$countRow] = $optionValue['id'];
  92               if ($optionValue['is_default']) {
  93                 $defaults['default'] = $countRow;
  94               }
  95             }
  96           }
  97         }
  98       }
  99     }
 100
 101     //check if discounted
 102     $discountedEvent = CRM_Core_BAO_Discount::getOptionGroup($this->_id, 'civicrm_event');
 103     if (!empty($discountedEvent)) {
 104       $defaults['is_discount'] = $i = 1;
 105       $totalLables = $maxSize = $defaultDiscounts = [];
 106       foreach ($discountedEvent as $optionGroupId) {
 107         $defaults['discount_price_set'][] = $optionGroupId;
 108         $defaults["discount_name[$i]"] = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceSet', $optionGroupId, 'title');
 109
 110         $defaults["discount_start_date[$i]"] = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Discount', $optionGroupId,
 111           'start_date', 'price_set_id');
 112         $defaults["discount_end_date[$i]"] = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Discount', $optionGroupId,
 113           'end_date', 'price_set_id');
 114         $defaultDiscounts[] = CRM_Price_BAO_PriceSet::getSetDetail($optionGroupId);
 115         $i++;
 116       }
 117
 118       //avoid moving up value of lable when some labels don't
 119       //have a value ,fixed for CRM-3088
 120       $rowCount = 1;
 121       foreach ($defaultDiscounts as $val) {
 122         $discountFields = current($val);
 123         $discountFields = current($discountFields['fields']);
 124
 125         foreach ($discountFields['options'] as $discountFieldsval) {
 126           $defaults['discounted_label'][$discountFieldsval['weight']] = $discountFieldsval['label'];
 127           $defaults['discounted_value'][$discountFieldsval['weight']][$rowCount] = CRM_Utils_Money::format($discountFieldsval['amount'], NULL, '%a');
 128           $defaults['discount_option_id'][$rowCount][$discountFieldsval['weight']] = $discountFieldsval['id'];
 129           if (!empty($discountFieldsval['is_default'])) {
 130             $defaults['discounted_default'] = $discountFieldsval['weight'];
 131           }
 132         }
 133         $rowCount++;
 134       }
 135       //CRM-12970
 136       ksort($defaults['discounted_value']);
 137       ksort($defaults['discounted_label']);
 138       $rowCount = 1;
 139       foreach ($defaults['discounted_label'] as $key => $value) {
 140         if ($key != $rowCount) {
 141           $defaults['discounted_label'][$rowCount] = $value;
 142           $defaults['discounted_value'][$rowCount] = $defaults['discounted_value'][$key];
 143           unset($defaults['discounted_value'][$key]);
 144           unset($defaults['discounted_label'][$key]);
 145           foreach ($defaults['discount_option_id'] as &$optionIds) {
 146             if (array_key_exists($key, $optionIds)) {
 147               $optionIds[$rowCount] = $optionIds[$key];
 148               unset($optionIds[$key]);
 149             }
 150           }
 151         }
 152         $rowCount++;
 153       }
 154
 155       $this->set('discountSection', 1);
 156       $this->buildQuickForm();
 157     }
 158     elseif (!empty($defaults['label'])) {
 159       //if Regular Fees are present in DB and event fee page is in update mode
 160       $defaults['discounted_label'] = $defaults['label'];
 161     }
 162     elseif (!empty($this->_submitValues['label'])) {
 163       //if event is newly created, use submitted values for
 164       //discount labels
 165       if (is_array($this->_submitValues['label'])) {
 166         $k = 1;
 167         foreach ($this->_submitValues['label'] as $value) {
 168           if ($value) {
 169             $defaults['discounted_label'][$k] = $value;
 170             $k++;
 171           }
 172         }
 173       }
 174     }
 175     $defaults['id'] = $eventId;
 176     if (!empty($totalLables)) {
 177       $maxKey = count($totalLables) - 1;
 178       if (isset($maxKey) && !empty($totalLables[$maxKey]['value'])) {
 179         foreach ($totalLables[$maxKey]['value'] as $i => $v) {
 180           if ($totalLables[$maxKey]['amount_id'][$i] == CRM_Utils_Array::value('default_discount_fee_id', $defaults)) {
 181             $defaults['discounted_default'] = $i;
 182             break;
 183           }
 184         }
 185       }
 186     }
 187
 188     if (!isset($defaults['discounted_default'])) {
 189       $defaults['discounted_default'] = 1;
 190     }
 191
 192     if (!isset($defaults['is_monetary'])) {
 193       $defaults['is_monetary'] = 1;
 194     }
 195
 196     if (!isset($defaults['fee_label'])) {
 197       $defaults['fee_label'] = ts('Event Fee(s)');
 198     }
 199
 200     if (!isset($defaults['pay_later_text']) ||
 201       empty($defaults['pay_later_text'])
 202     ) {
 203       $defaults['pay_later_text'] = ts('I will send payment by check');
 204     }
 205
 206     $this->_showHide = new CRM_Core_ShowHideBlocks();
 207     if (!$defaults['is_monetary']) {
 208       $this->_showHide->addHide('event-fees');
 209     }
 210
 211     if (isset($defaults['price_set_id'])) {
 212       $this->_showHide->addHide('map-field');
 213     }
 214     $this->_showHide->addToTemplate();
 215     $this->assign('inDate', $this->_inDate);
 216     if (!empty($defaults['payment_processor'])) {
 217       $defaults['payment_processor'] = array_fill_keys(explode(CRM_Core_DAO::VALUE_SEPARATOR,
 218         $defaults['payment_processor']
 219       ), '1');
 220     }
 221
 222     return $defaults;
 223   }
 224
 225   /**
 226    * Build the form object.
 227    */
 228   public function buildQuickForm() {
 229     $this->addYesNo('is_monetary',
 230       ts('Paid Event'),
 231       NULL,
 232       NULL,
 233       ['onclick' => "return showHideByValue('is_monetary','0','event-fees','block','radio',false);"]
 234     );
 235
 236     //add currency element.
 237     $this->addCurrency('currency', ts('Currency'), FALSE);
 238
 239     $paymentProcessor = CRM_Core_PseudoConstant::paymentProcessor();
 240
 241     $this->assign('paymentProcessor', $paymentProcessor);
 242     $this->addCheckBox('payment_processor', ts('Payment Processor'),
 243       array_flip($paymentProcessor),
 244       NULL, NULL, NULL, NULL,
 245       ['&nbsp;&nbsp;', '&nbsp;&nbsp;', '&nbsp;&nbsp;', '<br/>']
 246     );
 247
 248     // financial type
 249     if (!CRM_Financial_BAO_FinancialType::isACLFinancialTypeStatus() ||
 250         (CRM_Financial_BAO_FinancialType::isACLFinancialTypeStatus() && CRM_Core_Permission::check('administer CiviCRM Financial Types'))) {
 251       $this->addSelect('financial_type_id');
 252     }
 253     else {
 254       CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes, CRM_Core_Action::ADD);
 255       $this->addSelect('financial_type_id', ['context' => 'search', 'options' => $financialTypes]);
 256     }
 257     // add pay later options
 258     $this->addElement('checkbox', 'is_pay_later', ts('Enable Pay Later option?'), NULL,
 259       ['onclick' => "return showHideByValue('is_pay_later','','payLaterOptions','block','radio',false);"]
 260     );
 261     $this->addElement('textarea', 'pay_later_text', ts('Pay Later Label'),
 262       CRM_Core_DAO::getAttribute('CRM_Event_DAO_Event', 'pay_later_text'),
 263       FALSE
 264     );
 265     $this->add('wysiwyg', 'pay_later_receipt', ts('Pay Later Instructions'), CRM_Core_DAO::getAttribute('CRM_Event_DAO_Event', 'pay_later_receipt'));
 266
 267     $this->addElement('checkbox', 'is_billing_required', ts('Billing address required'));
 268     $this->add('text', 'fee_label', ts('Fee Label'));
 269
 270     $price = CRM_Price_BAO_PriceSet::getAssoc(FALSE, 'CiviEvent');
 271     if (CRM_Utils_System::isNull($price)) {
 272       $this->assign('price', FALSE);
 273     }
 274     else {
 275       $this->assign('price', TRUE);
 276     }
 277     $this->addField('price_set_id', [
 278       'entity' => 'PriceSet',
 279       'options' => $price,
 280       'onchange' => "return showHideByValue('price_set_id', '', 'map-field', 'block', 'select', false);",
 281     ]);
 282
 283     $default = [$this->createElement('radio', NULL, NULL, NULL, 0)];
 284     $this->add('hidden', 'price_field_id', '', ['id' => 'price_field_id']);
 285     for ($i = 1; $i <= self::NUM_OPTION; $i++) {
 286       // label
 287       $this->add('text', "label[$i]", ts('Label'), CRM_Core_DAO::getAttribute('CRM_Core_DAO_OptionValue', 'label'));
 288       $this->add('hidden', "price_field_value[$i]", '', ['id' => "price_field_value[$i]"]);
 289
 290       // value
 291       $this->add('text', "value[$i]", ts('Value'), CRM_Core_DAO::getAttribute('CRM_Core_DAO_OptionValue', 'value'));
 292       $this->addRule("value[$i]", ts('Please enter a valid money value for this field (e.g. %1).', [1 => CRM_Utils_Money::formatLocaleNumericRoundedForDefaultCurrency('99.99')]), 'money');
 293
 294       // default
 295       $default[] = $this->createElement('radio', NULL, NULL, NULL, $i);
 296     }
 297
 298     $this->addGroup($default, 'default');
 299
 300     $this->addElement('checkbox', 'is_discount', ts('Discounts by Signup Date?'), NULL,
 301       ['onclick' => "warnDiscountDel(); return showHideByValue('is_discount','','discount','block','radio',false);"]
 302     );
 303     $discountSection = $this->get('discountSection');
 304
 305     $this->assign('discountSection', $discountSection);
 306
 307     // form fields of Discount sets
 308     $defaultOption = [];
 309     $_showHide = new CRM_Core_ShowHideBlocks('', '');
 310
 311     for ($i = 1; $i <= self::NUM_DISCOUNT; $i++) {
 312       //the show hide blocks
 313       $showBlocks = 'discount_' . $i;
 314       if ($i > 2) {
 315         $_showHide->addHide($showBlocks);
 316       }
 317       else {
 318         $_showHide->addShow($showBlocks);
 319       }
 320
 321       //Increment by 1 of start date of previous end date.
 322       if (is_array($this->_submitValues) &&
 323         !empty($this->_submitValues['discount_name'][$i]) &&
 324         !empty($this->_submitValues['discount_name'][$i + 1]) &&
 325         isset($this->_submitValues['discount_end_date']) &&
 326         isset($this->_submitValues['discount_end_date'][$i]) &&
 327         $i < self::NUM_DISCOUNT - 1
 328       ) {
 329         if (!empty($this->_submitValues['discount_end_date'][$i + 1])
 330           && empty($this->_submitValues['discount_start_date'][$i + 1])
 331         ) {
 332           $this->_submitValues['discount_start_date'][$i + 1] = date('Y-m-d', strtotime("+1 days " . $this->_submitValues['discount_end_date'][$i]));
 333         }
 334       }
 335       //Decrement by 1 of end date from next start date.
 336       if ($i > 1 &&
 337         is_array($this->_submitValues) &&
 338         !empty($this->_submitValues['discount_name'][$i]) &&
 339         !empty($this->_submitValues['discount_name'][$i - 1]) &&
 340         isset($this->_submitValues['discount_start_date']) &&
 341         isset($this->_submitValues['discount_start_date'][$i])
 342       ) {
 343         if (!empty($this->_submitValues['discount_start_date'][$i])
 344           && empty($this->_submitValues['discount_end_date'][$i - 1])
 345         ) {
 346           list($this->_submitValues['discount_end_date'][$i - 1]) = date('Y-m-d', strtotime("-1 days " . $this->_submitValues['discount_start_date'][$i]));
 347         }
 348       }
 349
 350       $this->add('text', 'discount_name[' . $i . ']', ts('Discount Name'),
 351         CRM_Core_DAO::getAttribute('CRM_Price_DAO_PriceSet', 'title')
 352       );
 353       $this->add('hidden', "discount_price_set[$i]", '', ['id' => "discount_price_set[$i]"]);
 354       $this->add('datepicker', 'discount_start_date[' . $i . ']', ts('Discount Start Date'), [], FALSE, ['time' => FALSE]);
 355       $this->add('datepicker', 'discount_end_date[' . $i . ']', ts('Discount End Date'), [], FALSE, ['time' => FALSE]);
 356     }
 357     $_showHide->addToTemplate();
 358     $this->addElement('xbutton', $this->getButtonName('submit'), ts('Add Discount Set to Fee Table'),
 359       [
 360         'type' => 'submit',
 361         'class' => 'crm-form-submit cancel',
 362         'value' => 1,
 363       ]
 364     );
 365     if (Civi::settings()->get('deferred_revenue_enabled')) {
 366       $deferredFinancialType = CRM_Financial_BAO_FinancialAccount::getDeferredFinancialType();
 367       $this->assign('deferredFinancialType', array_keys($deferredFinancialType));
 368     }
 369     $this->buildAmountLabel();
 370     parent::buildQuickForm();
 371   }
 372
 373   /**
 374    * Add local and global form rules.
 375    */
 376   public function addRules() {
 377     $this->addFormRule(['CRM_Event_Form_ManageEvent_Fee', 'formRule']);
 378   }
 379
 380   /**
 381    * Global validation rules for the form.
 382    *
 383    * @param array $values
 384    *   Posted values of the form.
 385    *
 386    * @return array
 387    *   list of errors to be posted back to the form
 388    */
 389   public static function formRule($values) {
 390     $errors = [];
 391     if (!empty($values['is_discount'])) {
 392       $occurDiscount = array_count_values($values['discount_name']);
 393       $countemptyrows = 0;
 394       $countemptyvalue = 0;
 395       for ($i = 1; $i <= self::NUM_DISCOUNT; $i++) {
 396         $start_date = $end_date = NULL;
 397         if (!empty($values['discount_name'][$i])) {
 398           if (!empty($values['discount_start_date'][$i])) {
 399             $start_date = ($values['discount_start_date'][$i]) ? CRM_Utils_Date::processDate($values['discount_start_date'][$i]) : 0;
 400           }
 401           if (!empty($values['discount_end_date'][$i])) {
 402             $end_date = ($values['discount_end_date'][$i]) ? CRM_Utils_Date::processDate($values['discount_end_date'][$i]) : 0;
 403           }
 404
 405           if ($start_date && $end_date && strcmp($end_date, $start_date) < 0) {
 406             $errors["discount_end_date[$i]"] = ts('The discount end date cannot be prior to the start date.');
 407           }
 408
 409           if (!$start_date && !$end_date) {
 410             $errors["discount_start_date[$i]"] = $errors["discount_end_date[$i]"] = ts('Please specify either start date or end date.');
 411           }
 412
 413           if ($i > 1) {
 414             $end_date_1 = ($values['discount_end_date'][$i - 1]) ? CRM_Utils_Date::processDate($values['discount_end_date'][$i - 1]) : 0;
 415             if ($start_date && $end_date_1 && strcmp($end_date_1, $start_date) >= 0) {
 416               $errors["discount_start_date[$i]"] = ts('Select non-overlapping discount start date.');
 417             }
 418             elseif (!$start_date && !$end_date_1) {
 419               $j = $i - 1;
 420               $errors["discount_start_date[$i]"] = $errors["discount_end_date[$j]"] = ts('Select either of the dates.');
 421             }
 422           }
 423
 424           foreach ($occurDiscount as $key => $value) {
 425             if ($value > 1 && $key <> '') {
 426               if ($key == $values['discount_name'][$i]) {
 427                 $errors['discount_name[' . $i . ']'] = ts('%1 is already used for Discount Name.', [1 => $key]);
 428               }
 429             }
 430           }
 431
 432           //validation for discount labels and values
 433           for ($index = (self::NUM_OPTION); $index > 0; $index--) {
 434             $label = TRUE;
 435             if (empty($values['discounted_label'][$index]) && !empty($values['discounted_value'][$index][$i])) {
 436               $label = FALSE;
 437               if (!$label) {
 438                 $errors["discounted_label[{$index}]"] = ts('Label cannot be empty.');
 439               }
 440             }
 441             if (!empty($values['discounted_label'][$index])) {
 442               $duplicateIndex = CRM_Utils_Array::key($values['discounted_label'][$index], $values['discounted_label']);
 443
 444               if ((!($duplicateIndex === FALSE)) && (!($duplicateIndex == $index))) {
 445                 $errors["discounted_label[{$index}]"] = ts('Duplicate label value');
 446               }
 447             }
 448             if (empty($values['discounted_label'][$index]) && empty($values['discounted_value'][$index][$i])) {
 449               $countemptyrows++;
 450             }
 451             if (empty($values['discounted_value'][$index][$i])) {
 452               $countemptyvalue++;
 453             }
 454           }
 455           if (!empty($values['_qf_Fee_next']) && ($countemptyrows == 11 || $countemptyvalue == 11)) {
 456             $errors["discounted_label[1]"] = $errors["discounted_value[1][$i]"] = ts('At least one fee should be entered for your Discount Set. If you do not see the table to enter discount fees, click the "Add Discount Set to Fee Table" button.');
 457           }
 458         }
 459       }
 460     }
 461     if ($values['is_monetary']) {
 462       //check if financial type is selected
 463       if (!$values['financial_type_id']) {
 464         $errors['financial_type_id'] = ts("Please select financial type.");
 465       }
 466
 467       //check for the event fee label (mandatory)
 468       if (!$values['fee_label']) {
 469         $errors['fee_label'] = ts('Please enter the fee label for the paid event.');
 470       }
 471
 472       if (empty($values['price_set_id'])) {
 473         //check fee label and amount
 474         $check = 0;
 475         $optionKeys = [];
 476         foreach ($values['label'] as $key => $val) {
 477           if (trim($val) && trim($values['value'][$key])) {
 478             $optionKeys[$key] = $key;
 479             $check++;
 480           }
 481         }
 482
 483         $default = $values['default'] ?? NULL;
 484         if ($default && !in_array($default, $optionKeys)) {
 485           $errors['default'] = ts('Please select an appropriate option as default.');
 486         }
 487
 488         if (!$check) {
 489           if (!$values['label'][1]) {
 490             $errors['label[1]'] = ts('Please enter a label for at least one fee level.');
 491           }
 492           if (!$values['value'][1]) {
 493             $errors['value[1]'] = ts('Please enter an amount for at least one fee level.');
 494           }
 495         }
 496       }
 497       if (isset($values['is_pay_later'])) {
 498         if (empty($values['pay_later_text'])) {
 499           $errors['pay_later_text'] = ts('Please enter the Pay Later prompt to be displayed on the Registration form.');
 500         }
 501         if (empty($values['pay_later_receipt'])) {
 502           $errors['pay_later_receipt'] = ts('Please enter the Pay Later instructions to be displayed to your users.');
 503         }
 504       }
 505       else {
 506         if (empty($values['payment_processor'])) {
 507           $errors['payment_processor'] = ts('You have indicated that this is a paid event, but no payment option has been selected. If this is not a paid event, please select the "No" option at the top of the page. If this is a paid event, please select at least one payment processor and/or enable the pay later option.');
 508         }
 509       }
 510     }
 511     return empty($errors) ? TRUE : $errors;
 512   }
 513
 514   public function buildAmountLabel() {
 515     $default = [];
 516     for ($i = 1; $i <= self::NUM_OPTION; $i++) {
 517       // label
 518       $this->add('text', "discounted_label[$i]", ts('Label'), CRM_Core_DAO::getAttribute('CRM_Core_DAO_OptionValue', 'label'));
 519       // value
 520       for ($j = 1; $j <= self::NUM_DISCOUNT; $j++) {
 521         $this->add('text', "discounted_value[$i][$j]", ts('Value'), ['size' => 10]);
 522         $this->addRule("discounted_value[$i][$j]", ts('Please enter a valid money value for this field (e.g. %1).', [1 => CRM_Utils_Money::formatLocaleNumericRoundedForDefaultCurrency('99.99')]), 'money');
 523       }
 524
 525       // default
 526       $default[] = $this->createElement('radio', NULL, NULL, NULL, $i);
 527     }
 528
 529     $this->addGroup($default, 'discounted_default');
 530   }
 531
 532   /**
 533    * Process the form.
 534    */
 535   public function postProcess() {
 536     $eventTitle = '';
 537     $params = $this->cleanMoneyFields($this->exportValues());
 538
 539     $this->set('discountSection', 0);
 540
 541     if (!empty($_POST['_qf_Fee_submit'])) {
 542       $this->buildAmountLabel();
 543       $this->set('discountSection', 2);
 544       return;
 545     }
 546
 547     if (!empty($params['payment_processor'])) {
 548       $params['payment_processor'] = array_keys($params['payment_processor']);
 549     }
 550     else {
 551       $params['payment_processor'] = 'null';
 552     }
 553
 554     $params['is_pay_later'] = CRM_Utils_Array::value('is_pay_later', $params, 0);
 555     $params['is_billing_required'] = CRM_Utils_Array::value('is_billing_required', $params, 0);
 556
 557     if ($this->_id) {
 558
 559       // delete all the prior label values or discounts in the custom options table
 560       // and delete a price set if one exists
 561       //@todo note that this removes the reference from existing participants -
 562       // even where there is not change - redress?
 563       // note that a more tentative form of this is invoked by passing price_set_id as an array
 564       // to event.create see CRM-14069
 565       // @todo get all of this logic out of form layer (currently partially in BAO/api layer)
 566       if (CRM_Price_BAO_PriceSet::removeFrom('civicrm_event', $this->_id)) {
 567         CRM_Core_BAO_Discount::del($this->_id, 'civicrm_event');
 568       }
 569     }
 570
 571     if ($params['is_monetary']) {
 572       if (!empty($params['price_set_id'])) {
 573         //@todo this is now being done in the event BAO if passed price_set_id as an array
 574         // per notes on that fn - looking at the api converting to an array
 575         // so calling via the api may cause this to be done in the api
 576         CRM_Price_BAO_PriceSet::addTo('civicrm_event', $this->_id, $params['price_set_id']);
 577         if (!empty($params['price_field_id'])) {
 578           $priceSetID = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $params['price_field_id'], 'price_set_id');
 579           CRM_Price_BAO_PriceSet::setIsQuickConfig($priceSetID, 0);
 580         }
 581       }
 582       else {
 583         // if there are label / values, create custom options for them
 584         $labels = $params['label'] ?? NULL;
 585         $values = $params['value'] ?? NULL;
 586         $default = $params['default'] ?? NULL;
 587         $options = [];
 588         if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
 589           for ($i = 1; $i < self::NUM_OPTION; $i++) {
 590             if (!empty($labels[$i]) && !CRM_Utils_System::isNull($values[$i])) {
 591               $options[] = [
 592                 'label' => trim($labels[$i]),
 593                 'value' => $values[$i],
 594                 'weight' => $i,
 595                 'is_active' => 1,
 596                 'is_default' => $default == $i,
 597               ];
 598             }
 599           }
 600           if (!empty($options)) {
 601             $params['default_fee_id'] = NULL;
 602             if (empty($params['price_set_id'])) {
 603               if (empty($params['price_field_id'])) {
 604                 $setParams['title'] = $eventTitle = ($this->_isTemplate) ? $this->_defaultValues['template_title'] : $this->_defaultValues['title'];
 605                 $eventTitle = strtolower(CRM_Utils_String::munge($eventTitle, '_', 245));
 606                 if (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle, 'id', 'name')) {
 607                   $setParams['name'] = $eventTitle;
 608                 }
 609                 elseif (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $this->_id, 'id', 'name')) {
 610                   $setParams['name'] = $eventTitle . '_' . $this->_id;
 611                 }
 612                 else {
 613                   $timeSec = explode('.', microtime(TRUE));
 614                   $setParams['name'] = $eventTitle . '_' . date('is', $timeSec[0]) . $timeSec[1];
 615                 }
 616                 $setParams['is_quick_config'] = 1;
 617                 $setParams['financial_type_id'] = $params['financial_type_id'];
 618                 $setParams['extends'] = CRM_Core_Component::getComponentID('CiviEvent');
 619                 $priceSet = CRM_Price_BAO_PriceSet::create($setParams);
 620
 621                 $fieldParams['name'] = strtolower(CRM_Utils_String::munge($params['fee_label'], '_', 245));
 622                 $fieldParams['price_set_id'] = $priceSet->id;
 623               }
 624               else {
 625                 foreach ($params['price_field_value'] as $arrayID => $fieldValueID) {
 626                   if (empty($params['label'][$arrayID]) && empty($params['value'][$arrayID]) && !empty($fieldValueID)) {
 627                     CRM_Price_BAO_PriceFieldValue::setIsActive($fieldValueID, '0');
 628                     unset($params['price_field_value'][$arrayID]);
 629                   }
 630                 }
 631                 $fieldParams['id'] = $params['price_field_id'] ?? NULL;
 632                 $fieldParams['option_id'] = $params['price_field_value'];
 633
 634                 $priceSet = new CRM_Price_BAO_PriceSet();
 635                 $priceSet->id = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', CRM_Utils_Array::value('price_field_id', $params), 'price_set_id');
 636
 637                 if ($this->_defaultValues['financial_type_id'] != $params['financial_type_id']) {
 638                   CRM_Core_DAO::setFieldValue('CRM_Price_DAO_PriceSet', $priceSet->id, 'financial_type_id', $params['financial_type_id']);
 639                 }
 640               }
 641               $fieldParams['label'] = $params['fee_label'];
 642               $fieldParams['html_type'] = 'Radio';
 643               CRM_Price_BAO_PriceSet::addTo('civicrm_event', $this->_id, $priceSet->id);
 644               $fieldParams['option_label'] = $params['label'];
 645               $fieldParams['option_amount'] = $params['value'];
 646               $fieldParams['financial_type_id'] = $params['financial_type_id'];
 647               foreach ($options as $value) {
 648                 $fieldParams['option_weight'][$value['weight']] = $value['weight'];
 649               }
 650               $fieldParams['default_option'] = $params['default'];
 651               $priceField = CRM_Price_BAO_PriceField::create($fieldParams);
 652             }
 653           }
 654         }
 655
 656         $discountPriceSets = !empty($this->_defaultValues['discount_price_set']) ? $this->_defaultValues['discount_price_set'] : [];
 657         $discountFieldIDs = !empty($this->_defaultValues['discount_option_id']) ? $this->_defaultValues['discount_option_id'] : [];
 658         if (CRM_Utils_Array::value('is_discount', $params) == 1) {
 659           // if there are discounted set of label / values,
 660           // create custom options for them
 661           $labels = $params['discounted_label'] ?? NULL;
 662           $values = $params['discounted_value'] ?? NULL;
 663           $default = $params['discounted_default'] ?? NULL;
 664
 665           if (!CRM_Utils_System::isNull($labels) && !CRM_Utils_System::isNull($values)) {
 666             for ($j = 1; $j <= self::NUM_DISCOUNT; $j++) {
 667               $discountOptions = [];
 668               for ($i = 1; $i < self::NUM_OPTION; $i++) {
 669                 if (!empty($labels[$i]) &&
 670                   !CRM_Utils_System::isNull(CRM_Utils_Array::value($j, $values[$i]))
 671                 ) {
 672                   $discountOptions[] = [
 673                     'label' => trim($labels[$i]),
 674                     'value' => $values[$i][$j],
 675                     'weight' => $i,
 676                     'is_active' => 1,
 677                     'is_default' => $default == $i,
 678                   ];
 679                 }
 680               }
 681
 682               if (!empty($discountOptions)) {
 683                 $fieldParams = [];
 684                 $params['default_discount_fee_id'] = NULL;
 685                 $keyCheck = $j - 1;
 686                 $setParams = [];
 687                 if (empty($discountPriceSets[$keyCheck])) {
 688                   if (!$eventTitle) {
 689                     $eventTitle = strtolower(CRM_Utils_String::munge($this->_defaultValues['title'], '_', 200));
 690                   }
 691                   $setParams['title'] = $params['discount_name'][$j];
 692                   if (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $params['discount_name'][$j], 'id', 'name')) {
 693                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j];
 694                   }
 695                   elseif (!CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceSet', $eventTitle . '_' . $params['discount_name'][$j] . '_' . $this->_id, 'id', 'name')) {
 696                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j] . '_' . $this->_id;
 697                   }
 698                   else {
 699                     $timeSec = explode('.', microtime(TRUE));
 700                     $setParams['name'] = $eventTitle . '_' . $params['discount_name'][$j] . '_' . date('is', $timeSec[0]) . $timeSec[1];
 701                   }
 702                   $setParams['is_quick_config'] = 1;
 703                   $setParams['financial_type_id'] = $params['financial_type_id'];
 704                   $setParams['extends'] = CRM_Core_Component::getComponentID('CiviEvent');
 705                   $priceSet = CRM_Price_BAO_PriceSet::create($setParams);
 706                   $priceSetID = $priceSet->id;
 707                 }
 708                 else {
 709                   $priceSetID = $discountPriceSets[$j - 1];
 710                   $setParams = [
 711                     'title' => $params['discount_name'][$j],
 712                     'id' => $priceSetID,
 713                   ];
 714                   if ($this->_defaultValues['financial_type_id'] != $params['financial_type_id']) {
 715                     $setParams['financial_type_id'] = $params['financial_type_id'];
 716                   }
 717                   CRM_Price_BAO_PriceSet::create($setParams);
 718                   unset($discountPriceSets[$j - 1]);
 719                   $fieldParams['id'] = CRM_Core_DAO::getFieldValue('CRM_Price_BAO_PriceField', $priceSetID, 'id', 'price_set_id');
 720                 }
 721
 722                 $fieldParams['name'] = $fieldParams['label'] = $params['fee_label'];
 723                 $fieldParams['is_required'] = 1;
 724                 $fieldParams['price_set_id'] = $priceSetID;
 725                 $fieldParams['html_type'] = 'Radio';
 726                 $fieldParams['financial_type_id'] = $params['financial_type_id'];
 727                 foreach ($discountOptions as $value) {
 728                   $fieldParams['option_label'][$value['weight']] = $value['label'];
 729                   $fieldParams['option_amount'][$value['weight']] = $value['value'];
 730                   $fieldParams['option_weight'][$value['weight']] = $value['weight'];
 731                   if (!empty($value['is_default'])) {
 732                     $fieldParams['default_option'] = $value['weight'];
 733                   }
 734                   if (!empty($discountFieldIDs[$j]) && !empty($discountFieldIDs[$j][$value['weight']])) {
 735                     $fieldParams['option_id'][$value['weight']] = $discountFieldIDs[$j][$value['weight']];
 736                     unset($discountFieldIDs[$j][$value['weight']]);
 737                   }
 738                 }
 739                 //create discount priceset
 740                 $priceField = CRM_Price_BAO_PriceField::create($fieldParams);
 741                 if (!empty($discountFieldIDs[$j])) {
 742                   foreach ($discountFieldIDs[$j] as $fID) {
 743                     CRM_Price_BAO_PriceFieldValue::setIsActive($fID, '0');
 744                   }
 745                 }
 746
 747                 $discountParams = [
 748                   'entity_table' => 'civicrm_event',
 749                   'entity_id' => $this->_id,
 750                   'price_set_id' => $priceSetID,
 751                   'start_date' => $params['discount_start_date'][$j],
 752                   'end_date' => $params['discount_end_date'][$j],
 753                 ];
 754                 CRM_Core_BAO_Discount::add($discountParams);
 755               }
 756             }
 757           }
 758         }
 759         if (!empty($discountPriceSets)) {
 760           foreach ($discountPriceSets as $setId) {
 761             CRM_Price_BAO_PriceSet::setIsQuickConfig($setId, 0);
 762           }
 763         }
 764       }
 765     }
 766     else {
 767       if (!empty($params['price_field_id'])) {
 768         $priceSetID = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $params['price_field_id'], 'price_set_id');
 769         CRM_Price_BAO_PriceSet::setIsQuickConfig($priceSetID, 0);
 770       }
 771       $params['financial_type_id'] = '';
 772       $params['is_pay_later'] = 0;
 773       $params['is_billing_required'] = 0;
 774     }
 775
 776     //update 'is_billing_required'
 777     if (empty($params['is_pay_later'])) {
 778       $params['is_billing_required'] = FALSE;
 779     }
 780
 781     //update events table
 782     $params['id'] = $this->_id;
 783     // skip update of financial type in price set
 784     $params['skipFinancialType'] = TRUE;
 785     CRM_Event_BAO_Event::add($params);
 786
 787     // Update tab "disabled" css class
 788     $this->ajaxResponse['tabValid'] = !empty($params['is_monetary']);
 789     parent::endPostProcess();
 790   }
 791
 792   /**
 793    * Return a descriptive name for the page, used in wizard header
 794    *
 795    * @return string
 796    */
 797   public function getTitle() {
 798     return ts('Event Fees');
 799   }
 800
 801   /**
 802    * Clean money fields in submitted params to remove formatting.
 803    *
 804    * @param array $params
 805    *
 806    * @return array
 807    */
 808   protected function cleanMoneyFields($params) {
 809     foreach ($params['value'] as $index => $value) {
 810       if (CRM_Utils_System::isNull($value)) {
 811         unset($params['value'][$index]);
 812       }
 813       else {
 814         $params['value'][$index] = CRM_Utils_Rule::cleanMoney(trim($value));
 815       }
 816     }
 817     foreach ($params['discounted_value'] ?? [] as $index => $discountedValueSet) {
 818       foreach ($discountedValueSet as $innerIndex => $value) {
 819         if (CRM_Utils_System::isNull($value)) {
 820           unset($params['discounted_value'][$index][$innerIndex]);
 821         }
 822         else {
 823           $params['discounted_value'][$index][$innerIndex] = CRM_Utils_Rule::cleanMoney(trim($value));
 824         }
 825       }
 826       if (empty($params['discounted_value'][$index])) {
 827         unset($params['discounted_value'][$index]);
 828       }
 829     }
 830     return $params;
 831   }
 832
 833 }